You plan to retire in 30 years and would like to start saving (annual end-of-year contributions) for your retirement. Use the Scenario Manager to create a scenario summary that displays the retirement savings (i.e., the future value) at the end of 30 years for each of the scenarios given below. The scenario summary is to be placed on a new worksheet rather than on this (existing) worksheet. Please ensure all cell references in the scenario summary are labelled appropriately using range names.

Excel File Edit View Insert Format Tools Data Window H IUP Webso Logout - Index Homework 3 - Fall 2021 F X AutoSave CE . Home Insert Draw Page Layout Formulas Data Review View X Calibri (Body 11 ' ' OA lllllll Paste B Tale TH A1 X x You plan to retire in 30 years and would like to start saving annu D 1 2 you plan to retire in 30 years and would like to start saving annual end of year contribution for your retirement US 3 to be placed on a new worksheet rather than this extra worksheet. Please ensure all cell references in Scenario 5 Annual rate 5 Optimistic 7 Most likely Pessimistic Annual contributions lend of year) $4,500 $3,200 $2.500 SX 3X 10 pnt: You can use the function 11 12 13 30 15 1 IB 10 21 22 23 24 25 20 22