80.2K

Verified Solution

Link Copied!

Question 20 Which of the following is NOT true with regards to the 'Goal Seek' tool in Excel? The Goal Seek'tool lets you set a cell equal to any value by changing a cell in the assumptions. The 'Goal Seek tool lets you 'maximize' an output variable based on multiple input variables. The 'Goal Seek' tool only works in a dynamic model. If an assumption that is changed is hard-coded in the model, the 'Goal Seek' tool will not work. The Goal Seek tool can be used to find the break-even sales price by setting the NPV equal to zero. No now by clicking on the Add button in the Sc D Question 19 1 pts A Data Table' in Excel can be used to Calculate the payback period in a dynamic way. Calculate the correlation between two variables. Change multiple assumptions in a scenario analysis. Data Table then automatically places the new assumptions directly into the separate assumption section. Calculate a new outcome, such as the NPV, within a table based on a range of values for one or two variables. 1 pts Question 18 Which of the following is NOT true with regards to the 'Scenario Manager'in Excel: The scenario manager is "dynamic", that means you can change the underlying assumptions within the worksheet and Excel will automatically recalculate the Summary Table We can select multiple variables that are changed in a scenario when we calculate the new NPV. The 'Scenario Manager'in Excel creates a summary output; however, it does not show the expected NPV, the E(NPV). We can create many different scenarios or cases within the 'Scenario Manager' by clicking on the 'Add' button in the Scenario Manager window. ATV-5000 There is no way to calculate the ATSV based on the information given. 1 pts D Question 17 In order to calculate the sensitivity of the NPV in a capital budgeting analysis You can only change one variable at a time. You use the formula =(ending value - beginning value)/beginning value. You use the formula =% change in variable X/% change in NPV. O You can use a 3-dimensional data table. Question 18

Answer & Explanation Solved by verified expert

See Answer