Scribd
Upload
116 views3 pages

Retirement Calculation

The document summarizes a retirement calculation showing inputs such as monthly savings of $200 starting at age 25 and outputs such as total savings and projected monthly income in retirement. It shows savings and returns growing over 36 years until retirement at age 60, with a projected monthly income of $1,049.51. Insurance premiums for $150,000 of life coverage are also included, with annual costs shown for 25 years of coverage.

Uploaded by

api-3765908
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
116 views3 pages

Retirement Calculation

The document summarizes a retirement calculation showing inputs such as monthly savings of $200 starting at age 25 and outputs such as total savings and projected monthly income in retirement. It shows savings and returns growing over 36 years until retirement at age 60, with a projected monthly income of $1,049.51. Insurance premiums for $150,000 of life coverage are also included, with annual costs shown for 25 years of coverage.

Uploaded by

api-3765908
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 3

Retirement Calculation

Inputs Outputs
Saving Age 25
1) Monthly Savings 200 ($) Retirement Year 36
Yearly Savings 2400 ($) Retirement Age 60
Yearly Rate of Return 4.00% % Disabled Age 80
Inflation Rate 0 % Monthly Income 1049.51
2) Savings Rise 5.00% %
3) Effective Rate of Return 4.00% %

Year Age Annual Savings Total savings Year Age

1 25 2520 2.62E+03 19 43
2 26 2646 5.48E+03 20 44
3 27 2778.3 8.59E+03 21 45
4 28 2917.22 1.20E+04 22 46
5 29 3063.08 1.56E+04 23 47
6 30 3216.23 1.96E+04 24 48
7 31 3377.04 2.39E+04 25 49
8 32 3545.89 2.85E+04 26 50
9 33 3723.19 3.36E+04 27 51
10 34 3909.35 3.90E+04 28 52
11 35 4104.81 4.48E+04 29 53
12 36 4310.06 5.11E+04 30 54
13 37 4525.56 5.78E+04 31 55
14 38 4751.84 6.51E+04 32 56
15 39 4989.43 7.29E+04 33 57
16 40 5238.9 8.12E+04 34 58
17 41 5500.84 9.02E+04 35 59
18 42 5775.89 9.98E+04 36 60

Notes: 1) Initially monthly savings


2) Annual increase in saving rates
3) Annual rate of return - Inflation rate
Insurance Calculations for $150,000 Cover
Premium(i-young) i-term Year Age
100 536.6 0 25
100 536.6 1 26
100 536.6 2 27
100 536.6 3 28
($) 100 536.6 4 29
536.6 536.6 5 30
536.6 536.6 6 31
536.6 536.6 7 32
Annual Savings Total savings 536.6 536.6 8 33
536.6 536.6 9 34
6064.68 1.23E+04 536.6 536.6 10 35
6367.91 1.94E+04 536.6 536.6 11 36
6686.31 2.72E+04 536.6 536.6 12 37
7020.63 3.55E+04 536.6 536.6 13 38
7371.66 4.46E+04 536.6 536.6 14 39
7740.24 5.45E+04 536.6 536.6 15 40
8127.25 6.51E+04 536.6 536.6 16 41
8533.61 7.66E+04 536.6 536.6 17 42
8960.3 8.90E+04 536.6 536.6 18 43
9408.31 1.02E+05 536.6 536.6 19 44
9878.73 1.17E+05 536.6 536.6 20 45
10372.66 1.32E+05 536.6 536.6 21 46
10891.29 1.49E+05 536.6 536.6 22 47
11435.86 1.67E+05 536.6 536.6 23 48
12007.65 1.86E+05 536.6 536.6 24 49
12608.04 2.06E+05 536.6 536.6 25 50
13238.44 2.28E+05 536.6 536.6 26 51
13900.36 2.52E+05 536.6 536.6 27 52
536.6 536.6 28 53
536.6 536.6 29 54
536.6 536.6 30 55
536.6 536.6 31 56
536.6 536.6 32 57
536.6 536.6 33 58
536.6 536.6 34 59
536.6 536.6 35 60
536.6 536.6 36 61
536.6 536.6 37 62
536.6 536.6 38 63
536.6 536.6 39 64
Total 19281 21464
0.08
$150,000 Cover 25 2500
Date 26 2700
2007 27 2916
2008 28 3149
2009 29 3401
2010 30 3673
2011 31 3967
2012 32 4285
2013 33 4627
2014 34 4998
2015 35 5397
2016 36 5829
2017 37 6295
2018 38 6799
2019 39 7343
2020 40 7930
2021 41 8565
2022 42 9250
2023 43 9990
2024 44 10789
2025 45 11652
2026 46 12585
2027 47 13591
2028 48 14679
2029 49 15853
2030 50 17121
2031 51 18491
2032 52 19970
2033 53 21568
2034 54 23293
2035 55 25157
2036
2037
2038
2039
2040
2041
2042
2043
2044
2045
2046

You might also like