Your uncle is 45 years old now and has saved $400,000 in his retirement account up to today (i.e, his 45^th birth day). He wants to work for another 20 years (i.e., he retires once he is 65 years old). Then, he expect to live for another 25 years, and withdraw $150,000 each year from his retirement account to cover his after retirement life. He will make his first withdraw of $150,000 at the age of 66 (i.e., at the end of age 65 cell D26, which is one year after his retirement). Use Goal seek to compute how much he has to save, and the first saving will be made one year from today (i.e., will start save this amount of money at the end of age 45 in C6). Assume an interest rate is 6%. Note, he will make 20 equal savings in Cells C6-C25, and will make 25 equal withdraws in cells D26-D50. You are required to fill all cells marked in color.

AutoSave OFF AHU Excel 1 -Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Developer Share Comments 21 7 DE Show Detail HE LP! Connections Progerties A Edit Links Clear Reply Advanced Refresh Geography From From New Database HTML Text Query 7. Sort Filter Graua Text to Flash Columns Fill Herrave Data Cansalidate Duplicates Veidation What if Analysis Urgroup Subtatal Hde Detail Data Analysis Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates B7 E - K 1 x 2 NA Cohe tal y viga Book Problem 2: Retirement Pyrene at end of yey XII. IIII WEWE! Tudor beginning of 492 Label NA dyear Nestante afya W Withara 49 . 21 . 4. 10 49 13 53 . 1! 12 14 16 TH IT TH 31 59 21 3 . 2 JINGLE 30 2 0 -4 20 311 23 21 0 24 19 0 40 21 14 42 22 0 11 15 29 17 24 12 0 11 all day toto 51 25 52 61 Probeml temp Problem2 temp Problems tomp Problem4_temp Problem5_temp + 69%