Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have to setup a worksheet that claculates the future value and percentage
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
future value | Excel Discussion (Misc queries) | |||
Future Value (FV) | Excel Discussion (Misc queries) | |||
Future Value | Excel Worksheet Functions | |||
need age in future year | New Users to Excel | |||
Future Value | Excel Worksheet Functions |