CProject results of monthly amount invested in different 529B plan
 

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.

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.

CProject results of monthly amount invested in different 529B plan
 

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

Regards,
Fred

"snevitt" wrote in message
...
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.