Bob's Retirement Planning-M2 - Bob's Retirement Planning Created by Created on Parameters Current Income Current Age Current Retirement Fund Income

Bob's Retirement Planning-M2 - Bob's Retirement Planning...

This preview shows page 1 - 9 out of 9 pages.

Bob's Retirement Planning Created by Created on Parameters Current Income 116000 Current Age 46 Current Retirement Fund 167000 Income Growth Rate 4% Age of Retirement 65 Employer's Contribution Rate 10% Pre-retirement rate of return 8% Post-retirement rate of return 5% Post-retirement consumption Exp. 70% Savings Rate 5% Inflation 2% Post-retirement tax rate 35% Model Pre-retirement section Age Income 46 116000 47 120640 48 125466 49 130484 50 135704 51 141132 52 146777 53 152648 54 158754 55 165104 56 171708 57 178577 58 185720 59 193149 60 200874 61 208909
Image of page 1
62 217266 63 225956 64 234995 65 244395 66 254170 67 264337 68 274911 69 285907 70 297343 71 309237 72 321606 73 334471 74 347850 75 361764 76 376234 77 391283 78 406935 79 423212 80 440141 81 457746 82 476056 83 495098 84 514902 85 535498 86 556918 87 579195 88 602363 89 626457 90 651516
Image of page 2
Image of page 3
Assumption: Tax is imposed on withdawal Post-retirement section End of Year Asset Age 11600 5800 167000 197760 66 171076.2 263194.1 12064 6032 197760 231677 67 174497.7 268458 12547 6273 231677 269031 68 177987.6 273827.1 13048 6524 269031 310126 69 181547.4 279303.7 13570 6785 310126 355291 70 185178.3 284889.7 14113 7057 355291 404885 71 188881.9 290587.5 14678 7339 404885 459292 72 192659.5 296399.3 15265 7632 459292 518932 73 196512.7 302327.3 15875 7938 518932 584260 74 200443 308373.8 16510 8255 584260 655767 75 204451.8 314541.3 17171 8585 655767 733984 76 208540.9 320832.1 17858 8929 733984 819489 77 212711.7 327248.8 18572 9286 819489 912907 78 216965.9 333793.7 19315 9657 912907 1014911 79 221305.2 340469.6 20087 10044 1014911 1126235 80 225731.4 347279 20891 10445 1126235 1247671 81 230246 354224.6 Employer's Contribution Personal Contribution Beginning of Year Asset Consump
Image of page 4
Image of page 5
Image of page 6
Image of page 7
Image of page 8
Image of page 9

You've reached the end of your free preview.

Want to read all 9 pages?

  • Fall '16
  • Johan fernandez
  • Finance, Prime number, Income Growth Rate, Post-retirement consumption Exp, Current Retirement Fund

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes