Question: what if analysis- please use the scenario manager hello please help walk me through this problem and show the steps I need to do to
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 (Beginning Balance times annual rate of return plus the Beginning Balance) 7 8 9 Annual Rate of Return Ending Balance 10 Beginning Balance 11 Investments 300,000.00 12 13 14
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
