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 Wir IUP Webso Logout - India X B Homework 3 - Fall 2021 Auto Save OFM Home Insert Draw Page Layout Formulas Data Review Calibri (Body) V 11 ' Paste B U SV 0 AV A1 4 x fe You plan to retire in 30 years and would like to start sa A B D E #WNH You plan to retire in 30 years and would like to start saving (annual end-of-year contributions) for your re to be placed on a new worksheet rather than on this (existing worksheet. Please ensure all cell reference Scenario Annual rate in una 6 Optimistic 7 Most likely Pessimistic 8% 5% 3% Annual contributions (end-of-year) $4,500 $3,200 $2,500 10 [Hint: You can use the FV function) 12 113 14 15 16 17 18 119 20 21 22