I want to build an amortization sheet that I can use to show customers the
difference of investing $1,000 per year for 7 years at a young age verus
investing $1,000 per year in your mid 20's for 27 years.

I can make a sheet that shows the proper results as I know and understand
the math, but it is just to columns and a fixed cell with a percentage of
return.

So I am looking for two different things, 1st I need to be able to put the
beginning age of investing, then a stop age of investing. (eg. 18 - 25),
investmest amount per year, and an estimated percentage of return - Then the
age of retirement. I need the sheet to amortize the investment on return the
final amount.

Then I need to do the same thing but with beginning age and ending age of
(eg. 28 - 55), I'll use the same investment per year and the same estimated %
return and same age of retirement.

Thanks in advance for any guidance you are able to provide.

-Steve

One way would be to put all the Input and Results cells at the top of the
sheet, then hide all the tables in lower rows. You could dress up the input
and results section to make it look professional.

"Steven M. Britton" wrote:

I want to build an amortization sheet that I can use to show customers the
difference of investing $1,000 per year for 7 years at a young age verus
investing $1,000 per year in your mid 20's for 27 years.

I can make a sheet that shows the proper results as I know and understand
the math, but it is just to columns and a fixed cell with a percentage of
return.

So I am looking for two different things, 1st I need to be able to put the
beginning age of investing, then a stop age of investing. (eg. 18 - 25),
investmest amount per year, and an estimated percentage of return - Then the
age of retirement. I need the sheet to amortize the investment on return the
final amount.

Then I need to do the same thing but with beginning age and ending age of
(eg. 28 - 55), I'll use the same investment per year and the same estimated %
return and same age of retirement.

Thanks in advance for any guidance you are able to provide.

-Steve