3 Income Growth 4 Savings Rate 5 6 7 8 9 10 12 13 14 15 16 Return on Portfolio Inflation Rate Taxable Income Up to: $0 $15,000 $50,000 $100,000 $250,000 Base 0.050 0.150 0.100 0.035 $0 $1,500 $8,500 $21,000 $66,000 Marginal Tax Rate 0.10 0.20 0.25 0.30 0.35 Required: Using the data above and below, please find the investor's annual income, savings, cumulative savings, consumption, and real consumption (using a deflator). Then solve for the annuity during retirement years. For simplicity, ignore taxes during retirement years. 18 (Use cells A3 to C13 from the given information to complete this question.) 19