Spreadsheet_21_4

Spreadsheet_21_4 - 15000 0.25 0.15 0.06 0.0291 Age Income...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Retirement Years Income growth Rate of InflationExemption now Tax Rate Saving rate ROR rROR 25 0.04 0.03 9350 0.25 0.08 0.08 0.0437 Age Income Deflator Exemption Taxes Savings Cumulative Savings rConsumption 30 50,000 1.00 9,350 10,163 3,187 3,187 36,651 31 52,000 1.03 9,631 10,652 3,308 6,734 36,932 35 60,833 1.16 10,839 12,871 3,837 25,187 38,063 45 90,047 1.56 14,567 20,819 5,538 117,297 40,880 55 133,292 2.09 19,577 34,147 7,932 335,773 43,564 65 197,304 2.81 26,310 56,959 11,228 825,929 45,886 Total 970,363 232,764 Real Annuity= 19,529 RETIREMENT Age Nom Withdraw Deflator Exemption Taxes Fund left rConsumption 66 56,599 2.90 27,099 8,711 831,275 16,523 70 63,703 3.26 30,500 8,105 838,138 17,044 75 73,849 3.78 35,358 6,407 800,304 17,834 80 85,612 4.38 40,990 3,138 681,808 18,813 85 99,247 5.08 47,518 0 437,290 19,529 90 115,055 5.89 55,086 0 0 19,529 Total 2,063,573 104,682 A B C D E F G H 1 2 3 4 5 9 19 29 39 40 41 42 43 47 52 57 62 67 68
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
tirement Ye come growRate of InExemp Tax Rate Saving rate ROR rROR 25 0.07 0.03
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 15000 0.25 0.15 0.06 0.0291 Age Income Deflatorxemptio Taxes Savings ulative Sav rConsumption Total labor income 30 50,000 1.00 ### 8,750 6,188 6,188 35,063 Total exemptions 31 53,500 1.03 ### 9,605 6,584 13,143 36,224 Lifetime taxable income 65 533,829 2.81 ### 148,611 57,783 1,874,346 116,365 Total 1,884,163 834,226 al Annuity 37,882 RETIREMENT Age om WithdraDeflatorxemptio Taxes Fund left rConsumption Check 66 109,792 2.90 ### 17,247 1,877,014 31,931 109,792 67 113,086 2.99 ### 16,961 1,876,549 32,200 113,086 15,264 90 223,185 5.89 ### 37,882 223,185 Total ### 203,199 A B C D E F G H I J K L 1 2 3 4 5 39 40 41 42 43 44 67 68 7,445,673 876,304 6,569,369 M N O 1 2 3 4 5 39 40 41 42 43 44 67 68...
View Full Document

  • Spring '11
  • SHERBO
  • #, Prime number, 109,792 113,086 223,185 15,264 0 M, C D E F G H R, Deflator Exemption Taxes, Exemption Taxes Fund

{[ snackBarMessage ]}

Page1 / 3

Spreadsheet_21_4 - 15000 0.25 0.15 0.06 0.0291 Age Income...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online