G

#### Guest

of tuition saved for monthly payments from $275-875 in increments of $50. For

the following data:

Annual Tuition $45,000, Rate = 4.25%/12, total payments of 15 years for 12

months/yr. I don't know how to setup the worksheet to calculate the

percentage of tuition saved. I setup the formula to calculate the FV as:

(reference the cell with the value - in my case is B15:B27) * ((1 +

Annual_Return / 12) * Years * 12)/Annual_Return/12. I don't know if my future

value calculation is correct but I have $97,402.57, $115,112.13, $132,821.69,

$150,531.25, $168,240.81, $185,950.37, $203,659.93, $221,369.49, $239,079.04,

$256,788.60, $274,498.16, $292,207.72, $309,917.28 as the future values based

on the various increments of $275-875 but that is as far as I've been able to

get. Can someone help?