CProject results of monthly amount invested in different 529B plan

[snevitt]

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.

 

[trip_to_tokyo]

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.

 

[Fred Smith]

You want FV. Just type in =FV( then enter the required parameters in the
dialogue box.

Regards,
Fred