i need help to make spreadsheet Two and Three ive been stuck for a while. i have got spreadsheet One complete which is the second picture just to show how i manage to do it but i dont know how to do Two and Three if you could please help i would really appreciate it thank you.

Yow are sick and tired of govig to tohool. Ths is understandatle, since you've been going to school seemingly al of your lile. However, you arent thelled with the idea of 'working for a hing." As a rofilt, your uhmate goal is to retice in thinty years (or less). The question you are most intrested Piease replicate the following spreadsheet. Your spreadsheet should extend for a period of thirty yoars. Assume that al funds are invested at the end of the year. Use formulas wherever possible, as you will be asked to make revisions. A B c. D E F G. 1 2 3 4 5 6 7 8 9 10 1 Your Name Redirement Planning 3 Dabe 5 6 8 10 Primary Objective: All subsequent changes will be made only to the three values in shaded bo \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multirow[b]{2}{*}{Year} & \multicolumn{3}{|c|}{ Pay Income Taxes As You Go } & \multicolumn{4}{|c|}{ Defor All Income Taxes } \\ \hline & \begin{tabular}{r} Amount \\ Investod \end{tabular} & \begin{tabular}{l} Interest \\ Earnod \end{tabular} & \begin{tabular}{r} Total \\ Nest Egg \\ \end{tabular} & Year & \begin{tabular}{l} Amount \\ Invested \end{tabular} & \begin{tabular}{l} Interest \\ Eamed \end{tabular} & \begin{tabular}{r} Total \\ Nest Egg \\ \end{tabular} \\ \hline 1 & $1,600,00 & & $1,600,00 & 1 & $2,000.00 & & $2,000.00 \\ \hline 2 & 1,600.00 & $102.40 & 3,302,40 & 2 & 2,000.00$ & 160,00 & 4,160,00 \\ \hline 3 & 1,600.00 & 211.35 & 5,113.75 & 3 & 2,000,00 & 332.80 & 6,492.80 \\ \hline 4 & 1,600,00 & 327.28 & 7,041.03 & 4 & 2,000.00 & 519.42 & 9,012.22 \\ \hline 5 & 1,600.00 & 450.63 & 9,091,66 & 5 & 2,000.00 & 720.98 & 11,733.20 \\ \hline 6 & 1,600,00 & 581.87 & 11,273.53 & 6 & 2,000,00 & 938.66 & 14,671,86 \\ \hline 7 & 1,600.00 & 721.51 & 13,595,03 & 7 & 2,000,00 & 1,173,75 & 17,845.61 \\ \hline 8 & 1,600.00 & 870.08 & 16,065,11 & 8 & 2,000,00 & 1,427.65 & 21,273.26 \\ \hline 9 & 1,600,00 & 1,028,17 & 18,693.28 & 9 & 2,000.00 & 1,701.86 & 24,975,12 \\ \hline 10 & 1,600.00 & 1,196,37 & 21,489,65 & 10 & 2,000,00 & 1,998,01 & 28,973,12 \\ \hline 11 & 1,600,00 & 1,375,34 & 24,464,99 & 11 & 2,000.00 & 2,317,85 & 33,29097 \\ \hline 12 & 1,600,00 & 1,565.76 & 27,630.75 & 12 & 2,000.00 & 2,663,28 & 37,954,25 \\ \hline 13 & 1,600,00 & 1,768,37 & 30,999.12 & 13 & 2,000.00 & 3,036,34 & 42,990,59 \\ \hline 14 & 1,600.00 & 1,983.94 & 34,583.06 & 14 & 2,000,00 & 3,439,25 & 48,429,84 \\ \hline 15 & 1,600,00 & 2,213,32 & 38,396,38 & 15 & 2,000.00 & 3,874,39 & 54,304,23 \\ \hline 16 & 1,600,00 & 2,457.37 & 42,453.74 & 16 & 2,000,00 & 4,344,34 & 60,648.57 \\ \hline 17 & 1,600.00 & 2,717.04 & 46,770,78 & 17 & 2,000,00 & 4,851.89 & 67,500,45 \\ \hline 18 & 1,600,00 & 2,993.33 & 51,364,11 & 18 & 2,000,00 & 5,400.04 & 74,900,49 \\ \hline 19 & 1,600,00 & 3,287,30 & 56,251,42 & 19 & 2,000.00 & 5,992,04 & 82,892.53 \\ \hline 20 & 1,600,00 & 3,600,09 & 61,451.51 & 20 & 2,000.00 & 6,631.40 & 91,523,93 \\ \hline 21 & 1,600.00 & 3,932,90 & 66,984.40 & 21 & 2,000,00 & 7,321.91 & 100,845.84 \\ \hline 22 & 1,600,00 & 4,287,00 & 72,871,41 & 22 & 2,000,00 & 8,067.67 & 110,913.51 \\ \hline 23 & 1,600,00 & 4,663.77 & 79,135.18 & 23 & 2,000.00 & 8,873.08 & 121,786,59 \\ \hline 24 & 1,600,00 & 5,064,65 & 85,799,83 & 24 & 2,000.00 & 9,742,93 & 133,529,52 \\ \hline 25 & 1,600,00 & 5,491,19 & 92,891.02 & 25 & 2,000,00 & 10,682:36 & 146,211,88 \\ \hline 26 & 1,600,00 & 5,945,02 & 100,436.04 & 26 & 2,000,00 & 11,696.95 & 159,908,83 \\ \hline 27 & 1,600,00 & 6,427.91 & 108,463,95 & 27 & 2,000,00 & 12,792,71 & 174,701.54 \\ \hline 28 & 1,600,00 & 6,941.69 & 117,005,64 & 28 & 2,000,00 & 13,976,12 & 190,677.66 \\ \hline 29 & 1,600,00 & 7,488,36 & 126,094,00 & 29 & 2,000,00 & 15,254.21 & 207,931.87 \\ \hline 30 & 1,600,00 & 8,070,02 & 135,764.02 & 30 & 2,000,00 & 16,634.55 & 226,566,42 \\ \hline & & & & \multicolumn{3}{|c|}{ After-Tax Nest Egg } & $181,253,1 \\ \hline & & & & & & $45,489.12 & \\ \hline \end{tabular}