View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Struggling College Student Struggling College Student is offline
external usenet poster
 
Posts: 1
Default Saving for College

I have to make a plan for a monthly payment deposit for the next 15 years.
The account pays 4.5% annual interest, compounded monthly. I have to use the
FV function to determine the % of college tuition saved.

Out of State Annual Tuition=40000
Rate(per month)=4.5%/12
Nper(number of monthly payments)=15*12
Pmt(payment per period)=375
Percentage of Tuition Saved=FV/Tuition for 4 years