A C D E 1 What If Analysis - Scenario Manager 2 3 Use the Scenario Manager to create a comparison between different different rates of return on the following investment. 4 When creating your economic scenarios, use four different annual rates of return: 10%, 5%, -1%, and -4% 5 When finished with the scenarios, create a scenario summary using the scenario summary tool. 6 The Scenario cell is cell C11. You must also include the proper formula in cell D11 to calculate the ending balance 7 (Beginning Balance times annual rate of return plus the Beginning Balance) 8 9 10 Beginning Balance Annual Rate of Return Ending Balance 11 Investment $ 300,000.00 12 13