-
-
Your client has been experimenting with calculating the NPV of a project based on different combinations of related inputs. They want to be able to quickly toggle through the various combinations for quick reference and review. Which of the following tools will facilitate this analysis?
1. Question 1 Your client has been experimenting with calculating the NPV of a project based on different combinations of related inputs. They want to be able to quickly toggle…
-
In Week 2, student exercise 1, in order to use Goal Seek you will need to indicate the “changing cell”, which cell should be identified?
6. Question 6 In Week 2, student exercise 1, in order to use Goal Seek you will need to indicate the “changing cell”, which cell should be identified? 1 point…
-
Your client wants to understand the profitability of a project but many of the variables are not known and vary independently. What approach would allow the user to test the likelihood of the project being profitable at many combinations of variables?
3. Question 3 Your client wants to understand the profitability of a project but many of the variables are not known and vary independently. What approach would allow the user…
-
Your client wants to know what the Net Present Value (NPV) would be of a particular capital project as interest rates move from 1% to 15%. What would be the most appropriate approach?
2. Question 2 Your client wants to know what the Net Present Value (NPV) would be of a particular capital project as interest rates move from 1% to 15%. What…
-
In Week 2, student exercise 3. We are using a one-way data table to determine the impact of changing cost per hour. If we instead were asked to determine the impact of changing Revenue per Purchase, what other information would we need?
8. Question 8 In Week 2, student exercise 3. We are using a one-way data table to determine the impact of changing cost per hour. If we instead were asked…
-
In Week 2, student exercise 2, for the scenario “Low growth with margin impact”, what would you indicate as the revenue growth rate?
7. Question 7 In Week 2, student exercise 2, for the scenario “Low growth with margin impact”, what would you indicate as the revenue growth rate? 1 point 3.5%…
-
As part of your analysis you want to be able to answer “what if” questions by starting, first, with the outcome of the analysis. What is the best tool to use?
5. Question 5 As part of your analysis you want to be able to answer “what if” questions by starting, first, with the outcome of the analysis. What is the…
-
You need to mathematically optimize outcomes in your model given specific constraints. What is the best tool to use?
4. Question 4 You need to mathematically optimize outcomes in your model given specific constraints. What is the best tool to use? 1 point Solver Goal Seek …
-
Imagine you have an Excel file that contains 5 separate data tables. What Excel features will allow you to create a Pivot Table that includes data from all 5 of the separate data tables?
6. Question 6 Imagine you have an Excel file that contains 5 separate data tables. What Excel features will allow you to create a Pivot Table that includes data from…