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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!