Question: 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


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, ignoce taxes during retirement vears. (Use cells A3 to C13 from the tiven information to complete this question.) \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & 8 & & C & D. & E & F. & G & H. \\ \hline 36 & $67,005 & & 1.23 & $15,243 & $8,941 & $8,710 & $70,987 & $49,355 \\ \hline 37 & $70,355 & & 1.27 & $15,776 & $9,645 & $9,107 & $87,192 & $51,604 \\ \hline 38 & $73,873 & & 1.32 & $16,328 & $10,386 & $9,523 & $105,434 & $53,964 \\ \hline 39. & $77,566 & 8 & 1.36 & $16,900 & $11,167 & $9,960 & $125,938 & $6.440 \\ \hline \multicolumn{9}{|l|}{40} \\ \hline 41 & $85,517 & & 1.46 & $18,104 & $12,853 & $10,900 & $174,744 & $61,764 \\ \hline 42 & $89,793 & & 1.51 & $18,737 & $13,764 & $11,404 & $203,623 & $64,625 \\ \hline 43 & $94,282 & & 1.56 & $19,393 & $14,722 & $11,934 & $235,919 & $67,626 \\ \hline 44 & $98,997 & & 1.62 & $20,072 & $15,731 & $12,490 & $272,001 & $70,776 \\ \hline 45 & $103,946 & & 1.68 & $20,774 & $16,793 & $13,073 & $312,274 & $74,080 \\ \hline 46 & $109,144 & a & 1.73 & $21,501 & $17,911 & $13,685 & $357,187 & $77,548 \\ \hline 47 & $114,601 & & 1.79 & $22,254 & $19,087 & $14,327 & $407,232 & $81,187 \\ \hline 48 & $120,331 & & 1.86 & $23,033 & $20,325 & $15,001 & $462,957 & $85,005 \\ \hline 49 & $126,348 & ? & 1.92. & $23,839 & $21,753 & $15,689 & $524,941 & $88,906 \\ \hline \multicolumn{9}{|l|}{ sor } \\ \hline 51 & $139,298 & & 2.06 & $25,537 & $25,128 & $17,125 & $670,334 & $97,044 \\ \hline 52 & $146,263 & & 2.13 & $26,431 & $26,950 & $17,897 & $755,264 & $101,416 \\ \hline 53 & $153,576 & & 2.21 & $27,356 & $28,866 & $18,707 & $849,497 & $106,004 \\ \hline 54 & $161,255 & & 2.28 & $28,313 & $30,883 & $19,556 & $954,003 & $110,817 \\ \hline 55 & $169,318 & & 2.36 & $29,304 & $33,004 & $20,447 & $1,069,850 & $115,867 \\ \hline 56 & $177,784 & & 2.45 & $30,330 & $35,236 & $21,382 & $1,198,217 & $121,165 \\ \hline 57 & $186,673 & & 2.53 & $31,391 & $37,584 & $22,363 & $1,340,402 & $126,725 \\ \hline 58 & $196,006 & & 2.62 & $32,490 & $40,055 & $23,393 & $1,497,835 & $132,559 \\ \hline 59 & $205,807 & & 2.71 & $33,627 & $42.654 & $24,473 & $1,672,091 & $138.680 \\ \hline \multicolumn{9}{|l|}{60r} \\ \hline 61 & $226,902 & & 2.91 & $36,022 & $48,264 & $26,796 & $2,078,193 & $151,842 \\ \hline 62 & $238,247 & & 3.01 & $37,283 & $51,289 & $28,044 & $2,314,056 & $158,914 \\ \hline 63 & $250,160 & & 3.11 & $38,588 & $54,471 & $29,353 & $2,574,815 & $166,335 \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
