Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Steven M. Britton
 
Posts: n/a
Default Amortization Schedule

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.

So as an example:

18 1000 $1,080.00 8%
19 1000 $2,166.40
20 1000 $3,339.71
21 1000 $4,606.89
22 1000 $5,975.44
23 1000 $7,453.48
24 1000 $9,049.75
25 $10,773.73
26 $11,635.63
27 $12,566.48
28 $13,571.80 1000 $1,080.00
29 $14,657.55 1000 $2,166.40
30 $15,830.15 1000 $3,339.71
31 $17,096.56 1000 $4,606.89
32 $18,464.29 1000 $5,975.44
33 $19,941.43 1000 $7,453.48
34 $21,536.74 1000 $9,049.75
35 $23,259.68 1000 $10,773.73
36 $25,120.46 1000 $12,635.63
37 $27,130.09 1000 $14,646.48
38 $29,300.50 1000 $16,818.20
39 $31,644.54 1000 $19,163.66
40 $34,176.10 1000 $21,696.75
41 $36,910.19 1000 $24,432.49
42 $39,863.01 1000 $27,387.09
43 $43,052.05 1000 $30,578.06
44 $46,496.21 1000 $34,024.30
45 $50,215.91 1000 $37,746.25
46 $54,233.18 1000 $41,765.94
47 $58,571.84 1000 $46,107.22
48 $63,257.58 1000 $50,795.80
49 $68,318.19 1000 $55,859.46
50 $73,783.65 1000 $61,328.22
51 $79,686.34 1000 $67,234.48
52 $86,061.25 1000 $73,613.23
53 $92,946.15 1000 $80,502.29
54 $100,381.84 1000 $87,942.48
55 $108,412.38 1000 $95,977.87


I just want to have this be pretty and show the final numbers...

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

-Steve
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating an Amortization schedule ? Joveni Excel Discussion (Misc queries) 2 January 22nd 05 04:58 PM
I would like to make a schedule for my dept. Who works what days . Chiki Charts and Charting in Excel 0 December 6th 04 01:55 AM
Mortgage Amortization Schedule dpayne Excel Discussion (Misc queries) 0 December 3rd 04 04:49 PM
Schedule Rotation Question Bob Excel Worksheet Functions 4 November 24th 04 06:54 AM
Unknown IF function parameter on amortization schedule Michael from Austin Excel Worksheet Functions 1 November 9th 04 06:32 PM


All times are GMT +1. The time now is 08:35 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"