Question 1188536: Find the present value and future value of monthly payments of 3,000 pesos for 4 years with an interest rate of 3% compounded quarterly. Answer by Theo(13342) (Show Source):
for the present value analysis through the use of the financial calculator, inputs were everything except pv.
for the future value analysis through the use of the financial calculator, inputs were everything except fv.
the excel analysis shows the quarter by quarter payments along with the use of the excel built-in functions that calculated pv and fv as shown.
here are the results.
in the financial calculator, the percent interest rate was used.
in excel, the interest rate was used.
percent interest rate = interest rate * 100.
interest rate = percent interest rate / 100.
