What is the future value FV after 4 years of the following i
What is the future value (FV) after 4 years of the following investments:
Payment $150 per quarter starting quarter 0. Interest Rate is 4 % semiannually.
Solution
Quarterly investment = $150
Number of quarters = 4 years = 4*4 = 16 quarters
Semi annul interest rate = 4%
Quarterly Interest rate = 4%/2 = 2%
The future value of this investment after 4 years is calculated in excel as =FV(rate,nper,pmt) =PV(0.02,16,150) = $2,795.89
