Interés compuesto con #Casio fx-CG50
Calculating Final Amount with Compound Interest
Introduction to the Example
- The video presents a financial example where an individual invests 1200 pesos for 3 years at an annual interest rate of 6%. The goal is to calculate the final amount received using compound interest.
Using the Financial Application
- The presenter navigates to a financial application in Excel, showcasing various calculations available. Two screens are displayed for viewing calculations, focusing on the F2 function for compound interest.
Inputting Data into Excel
- To compute the final amount, data must be entered:
- Number of compounding periods (3 years).
- Annual interest rate (6%).
- Additional parameters include:
- PV (Present Value): Represents either a loan or savings capital.
- PMT: Payment made towards a loan or deposit.
- FV (Future Value): Total amount owed or capital plus interest.
Setting Up Calculations
- For accurate results, input the present value as negative (-1200 pesos), ensuring that the future value calculated will be positive. Other settings include:
- Compounding frequency set to zero if not applicable.