Fundamentals of Corporate Finance
11th Edition
ISBN: 9780077861704
Author: Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Bradford D Jordan Professor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 11, Problem 3QP
Scenario Analysis [LO2] Sloan Transmissions, Inc., has the following estimates for its new gear assembly project: price = $1,700 per unit; variable costs = $480 per unit; fixed costs = $4.1 million; quantity = 95,000 units. Suppose the company believes all of its estimates are accurate only to within ±15 percent. What values should the company use for the four variables given here when it performs its best-case scenario analysis? What about the worst-case scenario?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The most likely outcomes for a particular project are estimated as follows:
Unit price:
Variable cost:
Fixed cost:
Expected sales:
50
24
30
$370,000
36,000 units per year
However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 10%
higher or 10% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1.4 million, which will
be depreclated straight-line over the project life to a final value of zero. The firm's tax rate is 21% and the required rate of return is 14%.
(For all the requirements, a negative amount should be indicated by a minus sign. Enter your answer in dollars not in millions. Do
not round intermediate calculations. Round your answer to the nearest dollar amount.)
a. What is project NPV in the best-case scenario, that is, assuming all variables take on the best possible value?
b. What is project NPV in the worst-case scenario?
[EXCEL] Payback: Refer to Problem 5. What are the payback periods for production systems 1 and 2? If the systems are mutually exclusive and the firm always chooses projects with the lowest payback period, in which system should the firm invest? please use excel.
Problem 5 info:
5. [EXCEL] Net present value: Blanda Incorporated management is considering investing in two alternative production systems. The systems are mutually exclusive, and the cost of the new equipment and the resulting cash flows are shown in the accompanying table. If the firm uses a 9 percent discount rate for production system projects, in which system should the firm invest?
Year System 1 System 2
0 −$15,000 −$45,000
1 15,000 32,000
2 15,000 32,000
3 15,000 32,000
1. Desai Industries is analyzing an average-risk project, and the following data have been developed. Unit sales will be
constant, but the sales price should increase with inflation. Fixed costs will also be constant, but variable costs should rise
with inflation. The project should last for 3 years, it will be depreciated on a straight-line basis, and there will be no
salvage value. No change in net operating working capital would be required. This is just one of many projects for the
firm, so any losses on this project can be used to offset gains on other firm projects. What is the project's expected
NPV? Do not round the intermediate calculations and round the final answer to the nearest whole number.
WACC
10.0%
Net investment cost (depreciable basis)
Units sold
$200,000
40,000
$25.00
Average price per unit, Year 1
Fixed op. cost excl. depr. (constant)
Variable op. cost/unit, Year 1
Annual depreciation rate
Expected inflation rate per year
Tax rate
$150,000
$20.20
33.333%
5.00%…
Chapter 11 Solutions
Fundamentals of Corporate Finance
Ch. 11.1 - Prob. 11.1ACQCh. 11.1 - What are some potential sources of value in a new...Ch. 11.2 - Prob. 11.2ACQCh. 11.2 - What are the drawbacks to the various types of...Ch. 11.3 - How are fixed costs similar to sunk costs?Ch. 11.3 - What is net income at the accounting break-even...Ch. 11.3 - Why might a financial manager be interested in the...Ch. 11.4 - If a project breaks even on an accounting basis,...Ch. 11.4 - If a project breaks even on a cash basis, what is...Ch. 11.4 - Prob. 11.4CCQ
Ch. 11.5 - What is operating leverage?Ch. 11.5 - How is operating leverage measured?Ch. 11.5 - Prob. 11.5CCQCh. 11.6 - What is capital rationing? What types are there?Ch. 11.6 - Prob. 11.6BCQCh. 11 - Prob. 11.1CTFCh. 11 - Marcos Entertainment expects to sell 84,000...Ch. 11 - Delta Tool has projected sales of 8,500 units at a...Ch. 11 - What is true for a project if that project is...Ch. 11 - A capital-intensive project is one that has a...Ch. 11 - Pavloki, Inc., has three proposed projects with...Ch. 11 - Forecasting Risk [LO1] What is forecasting risk?...Ch. 11 - Sensitivity Analysis and Scenario Analysis [LO1,...Ch. 11 - Prob. 3CRCTCh. 11 - Operating Leverage [LO4] At one time at least,...Ch. 11 - Operating Leverage [LO4] Airlines offer an example...Ch. 11 - Prob. 6CRCTCh. 11 - Prob. 7CRCTCh. 11 - Prob. 8CRCTCh. 11 - Prob. 9CRCTCh. 11 - Scenario Analysis [LO2] You are at work when a...Ch. 11 - Calculating Costs and Break-Even [LO3] Night...Ch. 11 - Prob. 2QPCh. 11 - Scenario Analysis [LO2] Sloan Transmissions, Inc.,...Ch. 11 - Sensitivity Analysis [LO1] For the company in the...Ch. 11 - Sensitivity Analysis and Break-Even [LO1, 3] We...Ch. 11 - Prob. 6QPCh. 11 - Prob. 7QPCh. 11 - Calculating Break-Even [LO3] In each of the...Ch. 11 - Calculating Break-Even [LO3] A project has the...Ch. 11 - Using Break-Even Analysis [LO3] Consider a project...Ch. 11 - Calculating Operating Leverage [LO4] At an output...Ch. 11 - Leverage [LO4] In the previous problem, suppose...Ch. 11 - Operating Cash Flow and Leverage [LO4] A proposed...Ch. 11 - Cash Flow and Leverage [LO4] At an output level of...Ch. 11 - Prob. 15QPCh. 11 - Prob. 16QPCh. 11 - Sensitivity Analysis [LO1] Consider a four-year...Ch. 11 - Operating Leverage [LO4] In the previous problem,...Ch. 11 - Project Analysis [LO1, 2, 3, 4] You are...Ch. 11 - Project Analysis [LO1, 2] McGilla Golf has decided...Ch. 11 - Prob. 21QPCh. 11 - Sensitivity Analysis [LO1] McGilla Golf would like...Ch. 11 - Break-Even Analysis [LO3] Hybrid cars are touted...Ch. 11 - Break-Even Analysis [LO3] In an effort to capture...Ch. 11 - Prob. 25QPCh. 11 - Operating Leverage and Taxes [LO4] Show that if we...Ch. 11 - Scenario Analysis [LO2] Consider a project to...Ch. 11 - Sensitivity Analysis [LO1] In Problem 27, suppose...Ch. 11 - Prob. 29QPCh. 11 - Prob. 30QP
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- A firm has two potential investment projects. The project information is summarised in the table below. Project A $670 Project B $700 Expected value of profit Standard deviation of profit Coefficient of variation of profit 175 370 0.26 0.53 Which project has a lower absolute risk level? Which project has a lower relative risk level? Which project would you advise the firm to choose? Explain your answers. ---- --- ---- ..- ---arrow_forwardYour boss wants you to conduct a sensitivity and scenario analysis to determine whether the following project is a winner. You are entering an established market, and you know the market size will be 1,100,000 units. You are unsure of your exact market share, the price you will be able to charge, and your variable cost per unit, but have determined a range of possible values for each (in the table below). Your initial investment cost is $150 million, and that investment will depreciate in straight-line form over the 20-year life of the project. There are no new NWC requirements, and there will be no salvage value at the end of the 20 years. The tax rate is 35%. The discount rate is 18%. a) Use the following table to conduct a full sensitivity analysis for the project. Make sure to include the NPV for the expected outcome as part of the full sensitivity analysis. Also add the best- and worst-case scenarios to the full sensitivity analysis. Show all of your work (written out, not an…arrow_forwardThe most likely outcomes for a particular project are estimated as follows: Unit price Variable cost $ 49 21 $309, 000 29, 200 uni ts per year Fixed cost Expected sales However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 10% higher or 10% lower than the initial estimate. The project will last for 13 years and requires an initial investment of $0.99 million, which will be depreciated straight-line over the project life to a final value of zero. The firm's tax rate is 35% and the required rate of return is 17%. What is project NPV in the "best case" scenario, that is, assuming all variables take on the best possible value? (Round your answer to the nearest whole dollar amount.) NPV in the "best case" scenario 1961296 What about the "worst case" scenario? (Use the minus sign for negative values. Round your answer to the nearest whole dollar amount.) NPV in the "worst case" scenario -148345arrow_forward
- Adam Andler Corp is analyzing an average-risk project, and the following data have been developed. Unit sales will be constant, but the sales price should increase with inflation. Fixed costs will also be constant, but variable costs should rise with inflation. The project should last for 3 years. This is just one of many projects for the firm, so any losses on this project can be used to offset gains on other firm projects. What is the project's expected NPV? Do not round the intermediate calculations and round the final answer to the nearest whole number. WACC or cost of capital Net investment cost (depreciable basis) The salvage value of its equipment No other fixed assets will be acquired for following years The company will require an increase in net working capital at the $10,000 beginning The company will liquidate all working capital at the end of the project -10,000 Units sold (constant through years) 60,000 $30.00 $50,000 $17.00 Average price per unit, Year 1 Fixed operating…arrow_forwardCalculate the NPV if cost savings value deviate by minus 20%. $ c. Suppose the CFO wants you to do a scenario analysis with different values for the cost savings, the machine's salvage value, and the working capital (WC) requirement. She asks you to use the following probabilities and values in the scenario analysis: Scenario Worst case Base case Best case Probability Cost Savings Salvage Value 0.35 $ 88,000 $28,000 0.35 0.30 110,000 132,000 33,000 38,000 WC $40,000 35,000 30,000 Calculate the project's expected NPV, its standard deviation, and its coefficient of variation. Do not round intermediate calculations. Round the monetary values to the nearest dollar and a coefficient of variation to two decimal places. Negative values, if any, should be indicated by a minus sign. The project's expected NPV: $ Standard deviation: $ Coefficient of variation:arrow_forwardWaste Management Inc. is analyzing an average-risk project, and the following data have been developed. Unit sales will be constant, but the sales price will increase with inflation. Fixed costs will also be constant, but variable costs will rise with inflation. The project should last for 3 years, and there will be no salvage value. This is just one project for the firm, so any losses can be used to offset gains on other firm projects. What is the project's expected NPV? IRR? Would you accept this project? WACC 9.50% Net investment cost (depreciable basis) $100,000 Units sold 40,000 Average price per unit, Year 1 $25.00 Fixed op. cost excl. depr'n (constant) $150,000 Variable op. cost/unit, Year 1 $20.20 Annual depreciation rate 33.33% Expected inflation 5.00% Tax rate 40.0% Please show work.arrow_forward
- Ch 7. Decision Trees. For questions 12 and 13, please use the following information: Ang Electronics, Inc., has developed a new DVDR. If the DVDR is successful, the present value of the payoff (when the product is brought to market) is $28.6 million. If the DVDR fails, the present value of the payoff is $10.2 million. If the product goes directly to market, there is a 40 percent chance of success. Alternatively, the company can delay the launch by one year and spend $1.42 million to test market the DVDR. Test marketing would allow the firm to improve the product and increase the probability of success to 70 percent. The appropriate discount rate is 11 percent. Calculate the NPV of test marketing before going to market. Format answer as "XX,XXX,XXX.XX"arrow_forwardHuang Industries is considering a proposed project whose estimated NPV is $12 million. This estimate assumes that economic conditions will be "average." However, the CFO realizes that conditions could be better or worse, so she performed a scenario analysis and obtained these results: Economic Scenario Probability of Outcome Recession ($40 million) (24 million) 12 million 18 million Boom 0.05 34 million Calculate the project's expected NPV, standard deviation, and coefficient of variation. Enter your answers for the project's expected NPV and standard deviation in millions. For example, an answer of $13,000,000 should be entered as 13. Do not round intermediate calculations. Round your answers to two decimal places. Below average Average Above average E(NPV): ONPV: CV: million million 0.05 0.20 0.50 NPV 0.20arrow_forwardCh 7. Decision Trees. For questions 12 and 13, please use the following information: Ang Electronics, Inc., has developed a new DVDR. If the DVDR is successful, the present value of the payoff (when the product is brought to market) is $28.6 million. If the DVDR fails, the present value of the payoff is $10.2 million. If the product goes directly to market, there is a 40 percent chance of success. Alternatively, the company can delay the launch by one year and spend $1.32 million to test market the DVDR. Test marketing would allow the firm to improve the product and increase the probability of success to 70 percent. The appropriate discount rate is 12 percent. Calculate the NPV of going directly to market. Format answer as "XX,XXX,XXX.XX"arrow_forward
- Texas Instruments is concerned that the estimated future operating costs of its soon-to-be-purchased equipment may not be very accurate. Let's say, the fixed production costs end up being 15% higher than what the company's research team has estimated, and the variable production costs will on the other hand be 8% lower. Clearly, this will affect the valuation of the project. But to which extent?? To see the extent of the effect on the project's current value, one should perform calculations known as analysis. Multiple Choice break-even scenario O sensitivity O equivalent cost homemadearrow_forwardQUESTION 1 Agro Tech Corporation is considering investing in a new IT system for selling to its clients. The company has identified two new possible systems, which would be suitable for its customers. Only one of the systems can be selected and the directors are looking for guidance on which system would be the best. The company requires a 15% rate of return on projects of this nature. The installation cost per project will be R100 000 each, while systems can be disposed for R200 000 each after five- years life span. Cash flows for Agro Tech Corporation: IT System (Rands) PERIOD 1 2 3 4 5 SYSTEM A -4 000 000 R1 800 000 R1 700 000 R1 600 000 R1 500 000 R1 400 000 SYSTEM B -3 500 000 1 500 000 1 500 000 1 500 000 1 400 000 R1 300 000 Required: 1.1 Determine the payback period in years, months and days for both systems 1.2 Based on your calculations in 1.1, which system should Agro Tech Corporation consider? Why? 1.3 Calculate the Net Present Value for both systems. 1.4 Calculate the…arrow_forwardCelestial Crane Cosmetics is analyzing a project that requires an initial investment of $3,225,000. The project's expected cash flows are: Year Cash Flow Year 1 $375,000 Year 2 -125,000 Year 3 500,000 Year 4 400,000 If the company's WACC is 8% and the project has the same risk as the firm's average project, what is the project's modified internal rate of return (MIRR)? Should you accept or reject this project?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
What is Risk Management? | Risk Management process; Author: Educationleaves;https://www.youtube.com/watch?v=IP-E75FGFkU;License: Standard youtube license