Transcribed Image Text
1. You have just turned 22, and you intend to start saving foryour retirement. You plan to retire in 43 years when you turn 65.During your retirement, you would like to have an annual incomeof$120,000 per year for 26years (until age 91).a)Calculate how much you need to have in your account before thefirst withdrawal at age 66.b)Calculate how much you would have to save annually between nowand age 65 in order to finance your retirement income and to fillthat account.Make the following assumptions:Assume that the relevant compounded interest rate is 4 percentper year.You make the first deposit today and the last deposition the dayyou turn 65 (44 deposits in total).You make the first withdrawal when you turn 66and the lastwithdrawal when you turn 91(26 withdrawals).(PLEASE SHOW STEP-BY-STEP EXCEL FORMULA WITH FUNCTIONS)