View Single Post
  #1   Report Post  
Steven M. Britton
 
Posts: n/a
Default Making a new form

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