Remember Me?

#1
 Steven M. Britton Posts: n/a
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
 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Joveni Excel Discussion (Misc queries) 2 January 22nd 05 04:58 PM Chiki Charts and Charting in Excel 0 December 6th 04 01:55 AM dpayne Excel Discussion (Misc queries) 0 December 3rd 04 04:49 PM Bob Excel Worksheet Functions 4 November 24th 04 06:54 AM Michael from Austin Excel Worksheet Functions 1 November 9th 04 06:32 PM

All times are GMT +1. The time now is 04:35 PM.