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 17QP
Sensitivity Analysis [LO1] Consider a four-year project with the following information: initial fixed asset investment = $475,000; straight-line
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Please give Answer Fast with Definition of the Required
Comparing Investment Criteria [L01,2,3,5,7] Consider the following two mutually exclusive projects:
Year Cash Flow (A) Cash Flow (B)
0 -$300,000 -$40,000
1 20,000 19,000
2 50,000 12,000
3 50,000 18,000
4 390,000 10,500
Whichever project you choose, if any, you require a 15 per cent return on your investment.
a. If you apply the payback criterion, which will you choose? Why?
b. If you apply the discounted payback criterion, which investment will you choose? Why?
c. If you apply the NPV criterion, which investment will you choose? Why?
d. If you apply the IRR criterion, which investment will you choose? Why?
e. If you apply the profitability index criterion, which investment will you choose? Why?
f. Based on your answers in (a) through (e), which project will you finally choose? Why?
Please explain your calculations and conclusions
use excel/show all excel formulas answering the following
LO3 20. Sensitivity Analysis We are evaluating a project that costs $1.68 million, has a six-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 90,000 units per year. Price per unit is $37.95, variable cost per unit is $23.20, and fixed costs are $815,000 per year. The tax rate is 21 percent, and we require a return of 11 percent on this project. a. Calculate the base-case cash flow and NPV. What is the sensitivity of NPV to changes in the sales figure? Explain what your answer tells you about a 500-unit decrease in projected sales. b. What is the sensitivity of OCF to changes in the variable cost figure? Explain what your answer tells you about a $1 decrease in estimated variable costs.
LO3 21. Scenario Analysis In the previous problem, suppose the projections given for price, quantity, variable costs, and fixed costs are all accurate to…
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
- Consider the following two projects, X and Y: Period Project X Project Y 0 $(100,000) $(120,000) 1 $22,000 $0 2 $22,000 $0 3 $22,000 $0 4 $22,000 $0 5 $45,000 $175,000 Regarding the internal rate of return, which of the following statements is correct? The internal rate of return of Project Y is greater than the internal rate of return of Project X. The internal rate of return of Project X is equal to the internal rate of return of Project Y. O The internal rate of return of Project X is greater than the internal rate of return of Project Y. The internal rate of return of Projects X and Y cannot be determined based on this information.arrow_forwardAm. 121.arrow_forwardQuestion is in imagearrow_forward
- Nonearrow_forwardQ.9.arrow_forwardSolve for LO3 21. (LO3 20 for data / Do not solve) LO3 20. Sensitivity Analysis We are evaluating a project that costs $1.68 million, has a six-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 90,000 units per year. Price per unit is $37.95, variable cost per unit is $23.20, and fixed costs are $815,000 per year. The tax rate is 21 percent, and we require a return of 11 percent on this project. a. Calculate the base-case cash flow and NPV. What is the sensitivity of NPV to changes in the sales figure? Explain what your answer tells you about a 500-unit decrease in projected sales. b. What is the sensitivity of OCF to changes in the variable cost figure? Explain what your answer tells you about a $1 decrease in estimated variable costs. LO3 21. Scenario Analysis In the previous problem, suppose the projections given for price, quantity, variable costs, and fixed costs are all accurate to within…arrow_forward
- Q3 7a 7. XYZ Co. is evaluating whether to invest in a project with the following information: Project cost = $950,000 Project life = five years Projected number of units sold per year = 10,000 Projected price per unit = $200 Projected variable cost per unit = 150 Fixed costs per year = $150,000 Required rate of return = 15% Marginal tax rate = 35% Assume straight-line depreciation to zero over five years, and ignore the half-year rule for accounting for depreciation. a. Calculate the cash break-even sales quantity for this project.arrow_forwardQ3 7c 7. XYZ Co. is evaluating whether to invest in a project with the following information: Project cost = $950,000 Project life = five years Projected number of units sold per year = 10,000 Projected price per unit = $200 Projected variable cost per unit = 150 Fixed costs per year = $150,000 Required rate of return = 15% Marginal tax rate = 35% Assume straight-line depreciation to zero over five years, and ignore the half-year rule for accounting for depreciation. c. Calculate the financial break-even sales quantity for this project.arrow_forwardExplanation it correctly and not use excelarrow_forward
- Q3 7d 7. XYZ Co. is evaluating whether to invest in a project with the following information: Project cost = $950,000 Project life = five years Projected number of units sold per year = 10,000 Projected price per unit = $200 Projected variable cost per unit = 150 Fixed costs per year = $150,000 Required rate of return = 15% Marginal tax rate = 35% Assume straight-line depreciation to zero over five years, and ignore the half-year rule for accounting for depreciation. d. Calculate the Degree of Operating Leverage (DOL) at the cash break-even, accounting break-even, and financial break-even sales quantities.arrow_forwardAlpesharrow_forwardmore. 3. Net present value method Aa Aa Consider the case of Underwood Manufacturing: Underwood Manufacturing is evaluating a proposed capital budgeting project that will require an initial investment of $120,000. The project is expected to generate the following net cash flows: Year Cash Flow Year 1 $37,600 Year 2 $50,500 Year 3 $45,000 Year 4 $41,900 Assume the desired rate of return on a project of this type is 10%. What is the net present value of this project? -$4,415.10 $18,344.79 -$7,244.50 $23,914.50 Suppose Underwood Manufacturing has enough capital to fund the project, and the project is not competing for funding with other projects. Should Underwood Manufacturing accept or reject this project? Accept the project Reject the projectarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
What is Risk Management? | Risk Management process; Author: Educationleaves;https://www.youtube.com/watch?v=IP-E75FGFkU;License: Standard youtube license