Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making Mailing Labels | Links and Linking in Excel | |||
making cells adjust | Excel Discussion (Misc queries) | |||
How do I set up a click "column title" and auto arrange data form. | Excel Discussion (Misc queries) | |||
Making Rows into Columns | Excel Discussion (Misc queries) | |||
A "previous" button on a user form | Excel Discussion (Misc queries) |