CProject results of monthly amount invested in different 529B plan

S

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.
 
T

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.
 
F

Fred Smith

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

Regards,
Fred
 
Top