Financial Planning

profiledarub11
retirement_homework_mgt_3062.xlsm
Home>Business & Finance homework help>Financial Planning

Feuil1

Now At retirement Uncertainety
Current age 25 Retirement age 65 Investment return uncertainety 0.40%
Annual savings 1800 How long will you live 85 Annual savings uncertainety 0.00%
Employer contribution (%) 0.00% How much money will you need every month after you retire? 8796 Annual savings increase uncertainety 0.00%
Annual savings increase 2.50% How much do you want to leave to your heirs? 0 Money needed after retirement uncertainety 0.00%
Investment return 10%
Roth IRA savings

Compute

Yearly balance

Monthly balance before retirement 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 0 1800 3825 6098.625 8646.890625 11498.442890625001 14684.821962890626 18240.752311962893 22204.461899761965 26618.033305256016 31527.789981687416 36984.721159409601 43044.949259392837 49770.244068975459 57228.588356607426 65494.800070020952 74651.216776719652 84788.448571580637 96006.206298857447 108414.21262061491 122133.20421684491 137296.03423105212 154048.88498649313 172552.60200078663 192984.16142940058 215538.28428158932 240429.21208672813 267892.6601568053 298187.96620542533 331600.4538597308 368444.03255531099 409064.05745318934 453840.47538191418 503191.28540809662 557576.34549909714 617501.5598879524 683523.48521166691 756254.39730112581 836367.86468873802 924604.87950654887 1021780.6015148642 Monthly balance after retirement 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 1021780.6015148642 1018406.6616663507 1014695.3278329859 1010612.8606162847 1006122.1466779131 1001182.3613457046 995748.5974802752 989771.45722830272 983196.60295113316 975964.26324624661 968008.68957087141 959257 .55852795858 949631.31438075448 939042.44581883005 927394.69040071312 914582.15944078448 900488.375384863 884985.21292334935 867931.73421568435 849172.90763725282 828538.19840097823 Upper limit 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 0 1800 3832.2 6121.8738000000003 8696.9518002000004 11588.297990545801 14830.015764765691 18459.785557084528 22519.237611624103 27054.363538750862 32115.970692686751 37760.183824279622 44048.998926046981 51050.894697999203 58841.50762732554 67504.377298320178 77131.769237042085 87825.583354883493 99698.356893910124 112874.3717027485 127490.87669400284 143699.43746270187 161667.42629115866 181579.66714108337 203640.25175229131 228074.54464377827 255131.39666371109 285085.58877814142 318240.53004400764 354931.23620234738 395527.61807699862 440438.11199935368 490113.68783069239 545052.27385307546 605803.64188398619 672974.80047886632 747235.9490635877 829327.0513344931 920065.09233078 1020352.0902821182 1131183.941729119 1143275.0716689476 1156623.6791225183 1171360.5417512604 1187630.0380933916 1205591.5620551044 1225421.0845088353 1247312.8772977544 1271481.4165367209 1298163.4838565399 1327620.4861776202 1360141.0167400928 1396043.6824810626 1435680.2254590932 1479438.9689068391 1527748.6216731505 1581082.4783271581 1639963.056 0731827 1704967.2139047938 1776731.8041508927 1855959.9117825856 Lower limit 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 0 1800 3817.8 6075.4338000000007 8597.0785698 11409.261315625801 14541.085185129003 18024.47751568459 21894.461713793095 26189.455253835084 30951.596304109051 36227.101728856964 42066.659478869515 48525.858672484326 55665.660985777242 63552.91731816464 72260.934080405044 81870.093869312957 92468.535750885756 104152.9008748425 117029.14969299588 131213.4576560462 146833.19692336241 164028.0123436494 182951.00075717503 203770.00353911251 226669.02325584719 251849.77634981289 279533.39491233439 309962.29185768147 343402.20518562599 380144.43852579332 420508.31680767535 464843.87770920323 513534.82151947764 567001.74422429304 625705.68100474449 690151.98994949216 760894.60864214296 838540.71942072571 923755.86254277593 906884.42534688255 888393.3301801834 868127.08987748111 845915.29050571937 821571.15839426848 794889.98960011837 765647.4286017298 733597.58174749592 698470.94959525554 659972.16075640009 617777.48818901461 571532.12705516012 520847.21125245548 465296.5435326912 404413.01171182957 337684.66083616525 264550.38827643712 184395.22555097513 96545.167203868768 261.50325544018415 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85

Feuil2

25 - 0 0 0
26 1,800.00 1800 1800
27 3,825.00 3832.2 3817.8
28 6,098.63 6121.8738 6075.4338
29 8,646.89 8696.9518002 8597.0785698
30 11,498.44 11588.2979905458 11409.2613156258
31 14,684.82 14830.0157647657 14541.085185129
32 18,240.75 18459.7855570845 18024.4775156846
33 22,204.46 22519.2376116241 21894.4617137931
34 26,618.03 27054.3635387509 26189.4552538351
35 31,527.79 32115.9706926868 30951.5963041091
36 36,984.72 37760.1838242796 36227.101728857
37 43,044.95 44048.998926047 42066.6594788695
38 49,770.24 51050.8946979992 48525.8586724843
39 57,228.59 58841.5076273255 55665.6609857772
40 65,494.80 67504.3772983202 63552.9173181646
41 74,651.22 77131.7692370421 72260.934080405
42 84,788.45 87825.5833548835 81870.093869313
43 96,006.21 99698.3568939101 92468.5357508858
44 108,414.21 112874.371702748 104152.900874842
45 122,133.20 127490.876694003 117029.149692996
46 137,296.03 143699.437462702 131213.457656046
47 154,048.88 161667.426291159 146833.196923362
48 172,552.60 181579.667141083 164028.012343649
49 192,984.16 203640.251752291 182951.000757175
50 215,538.28 228074.544643778 203770.003539113
51 240,429.21 255131.396663711 226669.023255847
52 267,892.66 285085.588778141 251849.776349813
53 298,187.97 318240.530044008 279533.394912334
54 331,600.45 354931.236202347 309962.291857681
55 368,444.03 395527.618076999 343402.205185626
56 409,064.06 440438.111999354 380144.438525793
57 453,840.48 490113.687830692 420508.316807675
58 503,191.29 545052.273853075 464843.877709203
59 557,576.35 605803.641883986 513534.821519478
60 617,501.56 672974.800478866 567001.744224293
61 683,523.49 747235.949063588 625705.681004744
62 756,254.40 829327.051334493 690151.989949492
63 836,367.86 920065.09233078 760894.608642143
64 924,604.88 1020352.09028212 838540.719420726
65 1,021,780.60 1021780.60151486 1131183.94172912 923755.862542776
66 1018406.66166635 1143275.07166895 906884.425346883
67 1014695.32783299 1156623.67912252 888393.330180183
68 1010612.86061628 1171360.54175126 868127.089877481
69 1006122.14667791 1187630.03809339 845915.290505719
70 1001182.3613457 1205591.5620551 821571.158394268
71 995748.597480275 1225421.08450884 794889.989600118
72 989771.457228303 1247312.87729775 765647.42860173
73 983196.602951133 1271481.41653672 733597.581747496
74 975964.263246247 1298163.48385654 698470.949595256
75 968008.689570871 1327620.48617762 659972.1607564
76 959257.558527959 1360141.01674009 617777.488189015
77 949631.314380754 1396043.68248106 571532.12705516
78 939042.44581883 1435680.22545909 520847.211252455
79 927394.690400713 1479438.96890684 465296.543532691
80 914582.159440784 1527748.62167315 404413.01171183
81 900488.375384863 1581082.47832716 337684.660836165
82 884985.212923349 1639963.05607318 264550.388276437
83 867931.734215684 1704967.21390479 184395.225550975
84 849172.907637253 1776731.80415089 96545.1672038688
85 828538.198400978 1855959.91178259 261.5032554402

Feuil3