Autoleve A Retirement Exam & Tahome Problem (Excl Home Insert Page Layo Formulas Data Review View Help Calen 18 A A W General 4- BTU Menge & Center Funt Alignment 1 How old will I be when I retire? Number Conditional format as Cell Formatting Table Styles- Styles 55 H Riley Manko Share $ imet Delete Format Cel 2 At what age do I plan to start saving for retirement 3 How many years do I need to save? 5 What is the amount of your retirement account in part 1? 25 years 30 years Retirement Goal from part 1 $80,000.00 $80,000.00 a. assume a 2% annual rate of return compounded monthly b. assume a 5% annual rate of return compounded monthly Using Excel functions calculate how much you need to save each month to meet your retirement goal in part 1 under both rates of return. When calculating percentage of monthly salary, assume you earn 6 $65,000 per year. action Type here to search Monthly Payment Pri balance at retirement Percentage of monthly salary Pt 2 Monthly Retirement Savings Sort & Find & Analy Fiber Select Eating Data Analys Comments Monthly compounded rate 40 3:04 PM 5/1/2021