View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default CProject results of monthly amount invested in different 529B plan

EXCEL 2007

Try Formulas / Function Library group / Financial / FV where Rate is the
monthly rate of interest (example 8%/12) Nper is the number of payments
(example 360 payments would be 30 years at 12 payments per year) and Pmt is
the monthly contrubution (example 300).

Entering the above into the 3 boxes returns 447,107.83 (the amount that you
would get back).

If my comments have helped please hit Yes.





"snevitt" wrote:

I am trying to make a final selection of a 529B plan. For 3 plans I have
1yr/3yr/5yr Peformance, total expsnse % and front end load %. I would like
to be able to project the value of each plan after n years of investing $y
every month.