Spread Sheet

profilejamesblent
cis_week4.xlsx
Home>Business & Finance homework help>Spread Sheet

Sheet1

Initial Assets $167,000 Age Salary Retirement Contributions Post-retirment Needs SS Income Post-retirement Taxes Retirement Assets Year Assets=0 Age
Salary $115,000 47 $115,000 $25,300 $0 $0 $0 $167,000 0 47
Savings Rate 12% 48 $120,750 $26,565 $0 $0 $0 $207,330 0 0 48
Salary Growth 5% 49 $126,788 $27,893 $0 $0 $0 $252,555 0 0 49
Inflation 2.50% 50 $133,127 $29,288 $0 $0 $0 $303,178 0 0 50
Investment return pre-retirement 9% 51 $139,783 $30,752 $0 $0 $0 $359,752 0 0 51
Investment return post-retirement 5% 52 $146,772 $32,290 $0 $0 $0 $422,882 0 0 52
Retire date 66 53 $154,111 $33,904 $0 $0 $0 $493,231 0 0 53
Post-retirement withdrawal rate 50% 54 $161,817 $35,600 $0 $0 $0 $571,526 0 0 54
Post-retirement tax rate 30% 55 $169,907 $37,380 $0 $0 $0 $658,563 0 0 55
SS Income at retirement $30,000 56 $178,403 $39,249 $0 $0 $0 $755,214 0 0 56
57 $187,323 $41,211 $0 $0 $0 $862,431 0 0 57
Last Salary $266,000 58 $196,689 $43,272 $0 $0 $0 $981,261 0 0 58
Initial post-retirement income $133,000 59 $206,523 $45,435 $0 $0 $0 $1,112,846 0 0 59
Year assets=0 80 60 $216,850 $47,707 $0 $0 $0 $1,258,438 0 0 60
61 $227,692 $50,092 $0 $0 $0 $1,419,404 0 0 61
62 $239,077 $52,597 $0 $0 $0 $1,597,243 0 0 62
63 $251,031 $55,227 $0 $0 $0 $1,793,591 0 0 63
64 $263,582 $57,988 $0 $0 $0 $2,010,241 0 0 64
65 $276,761 $60,887 $0 $0 $0 $2,249,151 0 0 65
66 $0 $0 $133,000 $30,000 $30,900 $2,361,609 0 0 66
67 $0 $0 $136,325 $30,750 $31,673 $2,345,789 0 0 67
68 $0 $0 $139,733 $31,519 $32,464 $2,325,831 0 0 68
69 $0 $0 $143,226 $32,307 $33,276 $2,301,444 0 0 69
70 $0 $0 $146,807 $33,114 $34,108 $2,272,320 0 0 70
71 $0 $0 $150,477 $33,942 $34,961 $2,238,136 0 0 71
72 $0 $0 $154,239 $34,791 $35,835 $2,198,547 0 0 72
73 $0 $0 $158,095 $35,661 $36,730 $2,153,192 0 0 73
74 $0 $0 $162,048 $36,552 $37,649 $2,101,686 0 0 74
75 $0 $0 $166,099 $37,466 $38,590 $2,043,626 0 0 75
76 $0 $0 $170,251 $38,403 $39,555 $1,978,585 0 0 76
77 $0 $0 $174,508 $39,363 $40,543 $1,906,111 0 0 77
78 $0 $0 $178,870 $40,347 $41,557 $1,825,728 0 0 78
79 $0 $0 $183,342 $41,355 $42,596 $1,736,934 0 0 79
80 $0 $0 $187,926 $42,389 $43,661 $1,639,198 0 0 80
81 $0 $0 $192,624 $43,449 $44,752 $1,531,960 0 0 81
82 $0 $0 $197,439 $44,535 $45,871 $1,414,631 0 0 82
83 $0 $0 $202,375 $45,649 $47,018 $1,286,588 0 0 83
84 $0 $0 $207,435 $46,790 $48,193 $1,147,172 0 0 84
85 $0 $0 $212,620 $47,960 $49,398 $995,693 0 0 85
86 $0 $0 $217,936 $49,158 $50,633 $831,418 0 0 86
87 $0 $0 $223,384 $50,387 $51,899 $653,578 0 0 87
88 $0 $0 $228,969 $51,647 $53,197 $461,361 0 0 88
89 $0 $0 $234,693 $52,938 $54,526 $253,911 0 0 89
90 $0 $0 $240,561 $54,262 $55,890 $30,325 0 0 90

Sheet2

Sheet3