Tricky FV function
I agree with Ron's handling of the first 2 parts of the question. You
can double-check your results with the following approach:
The FV of $500 p.a. at 10% p.a. interest (compounding monthly) for 30
years is calculated as follows:
FV= ((Amt of $500 over 30years*12 months @ 10%/12)-1)/10%/12
=500*((((1+(0.1/12))^30*12)-1))/(0.1/12)
=$86,3541.09
The 3rd part is easier with a spreadsheet layout:
The 3% increments will produce a cash flow of:
1st year 12 monthly instals.: 500 *(1.03)^0-500 = 0
2nd year 12 monthly instals.: 500*(1.03) ^1-500 per month
3rd year 12 monthly instals.: 500*(1.03)^2-500 per month
|