View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davidm
 
Posts: n/a
Default 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