Concept explainers
Sensitivity Analysis and Break-Even Point We are evaluating a project that costs $588,000, has an eight-year life, and has no salvage value. Assume that
- a. Calculate the accounting break-even point.
- b. 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. - c. 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.
a)
To determine: Accounting break-even point
Introduction:
Accounting break-even point refers where the company faces zero profits. This technique determines the variable’s value (independent) affecting another variable (dependent) under some set of assumptions is termed as sensitivity analysis.
Answer to Problem 1QP
Solution: The accounting break-even point is $48,031.25.
Explanation of Solution
Given information:
The cost of the project is $588,000 and the life is 8 years with no salvage value and is depreciated under straight line method. A sale of the project is 70,000 units, price per unit is $36, variable cost is $20 per unit and fixed cost is $695,000. The tax is at 35% and the rate of return is 15%.
The formula to calculate accounting break-even point:
The formula to calculate the depreciation:
Compute the value of depreciation:
Hence, the depreciation is $73,500.
Compute the accounting break-even point:
Hence, the accounting break-even point is $48,031.25.
b)
To determine: The base-case flow and net present value
Introduction:
The comparison of the present value of cash outflow and the present value of cash inflow is termed as net present value.
Answer to Problem 1QP
Solution:
Base-case operating cash flow is $301,975 and the net present value is $767,058.45.
The sensitivity of net present value is $813,726.58 and the net present value drops $23,330.
Explanation of Solution
Given information:
The cost of the project is $588,000 and the life is 8 years with no salvage value and is depreciated under straight line method. A sale of the project is $70,000 units, price per unit is $36, variable cost is $20 per unit and fixed cost is $695,000. The tax is at 35% and the rate of return is 15%.
The formula to calculate the base-case cash flow:
The formula to calculate the net present value:
Compute the base-case cash flow:
Hence, base-case operating cash flow is $301,975.
Compute net present value:
Note: The increase in operating cash flow at present value of interest factor annuity at 15% for 8 years is 4.48732.
Hence, the net present value is $767,058.45.
Note: The following calculations are required to compute the net present value when sales decrease by 500 units.
Compute net present value when sales is 71,000:
Note: Net present value at different quantities is calculated to determine the sensitivity of the net present value. Therefore, consider 71,000 as units sold.
Hence, the operating cash flow when sales are 71,000 is $312,375.
Compute net present value when sales is 71,000:
Note: The increase in operating cash flow at present value of interest factor annuity at 15% for 8 years is 4.48732.
Hence, the sensitivity of net present value is $813,726.58.
Compute changes in net present value:
Hence, the changes in net present value are $46.66.
Note: When sales drop by 500 units, then eventually the net present value will drop.
Compute the NPV drop value:
Hence, the net present value drops by $23,330.
c)
To determine: The sensitivity of operating cash flow to changes in the variable cost and a decrease of $1 in estimated variable costs.
Answer to Problem 1QP
Solution: The change in net present value is −$45,500 when variable cost decreases by $1.
Explanation of Solution
Given information:
The cost of the project is $588,000 and the life is 8 years with no salvage value and is depreciated under straight line method. A sale of the project is 70,000 units, price per unit is $36, variable cost is $20 per unit and fixed cost is $695,000. The tax is at 35% and the rate of return is 15%.
The formula to calculate the operating cash flow:
The formula to calculate the net present value:
The formula to calculate changes in operating cash flow for a $1 change in variable cost:
Compute sensitivity of operating cash flow change in variable cost:
Note: Assume variable cost as $21 since choosing another number is irrelevant because the same ratio of operating cash flow will be determined when the dollar decreases by $1. Using ‘tax shield approach’, determine the operating cash flow when the variable cost is $21.
Hence, the operating cash flow is $256,475.
Compute change in operating cash flow for a $1 change in variable cost:
Hence, the change in the net present value is −$45,500
Want to see more full solutions like this?
Chapter 7 Solutions
CORPORATE FINANCE-ACCESS >CUSTOM<
- Average rate of returncost savings Maui Fabricators Inc. is considering an investment in equipment that will replace direct labor. The equipment has a cost of 125,000 with a 15,000 residual value and an eight-year life. The equipment will replace one employee who has an average wage of 28,000 per year. In addition, the equipment will have operating and energy costs of 5,150 per year. Determine the average rate of return on the equipment, giving effect to straight-line depreciation on the investment.arrow_forwardREPLACEMENT ANALYSIS St. Johns River Shipyards is considering the replacement of an 8-year-old riveting machine with a new one that will increase earnings from 24,000 to 46,000 per year. The new machine will cost 80,000, and it will have an estimated life of 8 years and no salvage value. The new riveting machine is eligible for 100% bonus depreciation at the time of purchase. The applicable corporate tax rate is 25%, and the firms WACC is 10%. The old machine has been fully depreciated and has no salvage value. Should the old riveting machine be replaced by the new one? Explain your answer.arrow_forwardNew-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer’s base price is $1,080,000, and it would cost another $22,500 to install it. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $605,000. The MACRS rates for the first 3 years are 0.3333, 0.4445, and 0.1481. The machine would require an increase in net working capital (inventory) of $15,500. The sprayer would not change revenues, but it is expected to save the firm $380,000 per year in before-tax operating costs, mainly labor. Campbell’s marginal tax rate is 35%. What is the Year-0 cash flow? What are the net operating cash flows in Years 1, 2, and 3? What is the additional Year-3 cash flow (i.e., the after-tax salvage and the return of working capital)? If the project’s cost of capital is 12%, should the machine be purchased?arrow_forward
- Average rate of returnnew product Hana Inc. is considering an investment in new equipment that will be used to manufacture a smart-phone. The phone is expected to generate additional annual sales of 10,000 units at 300 per unit. The equipment has a cost of 4,500,000, residual value of 500,000, and a 10-year life. The equipment can only be used to manufacture the phone. The cost to manufacture the phone follows: Determine the average rate of return on the equipment.arrow_forwardFriedman Company is considering installing a new IT system. The cost of the new system is estimated to be 2,250,000, but it would produce after-tax savings of 450,000 per year in labor costs. The estimated life of the new system is 10 years, with no salvage value expected. Intrigued by the possibility of saving 450,000 per year and having a more reliable information system, the president of Friedman has asked for an analysis of the projects economic viability. All capital projects are required to earn at least the firms cost of capital, which is 12 percent. Required: 1. Calculate the projects internal rate of return. Should the company acquire the new IT system? 2. Suppose that savings are less than claimed. Calculate the minimum annual cash savings that must be realized for the project to earn a rate equal to the firms cost of capital. Comment on the safety margin that exists, if any. 3. Suppose that the life of the IT system is overestimated by two years. Repeat Requirements 1 and 2 under this assumption. Comment on the usefulness of this information.arrow_forwardHemmingway, Inc. is considering a $5 million research and development (R&D) project. Profit projections appear promising, but Hemmingway’s president is concerned because the probability that the R&D project will be successful is only 0.50. Furthermore, the president knows that even if the project is successful, it will require that the company build a new production facility at a cost of $20 million in order to manufacture the product. If the facility is built, uncertainty remains about the demand and thus uncertainty about the profit that will be realized. Another option is that if the R&D project is successful, the company could sell the rights to the product for an estimated $25 million. Under this option, the company would not build the $20 million production facility. The decision tree follows. The profit projection for each outcome is shown at the end of the branches. For example, the revenue projection for the high demand outcome is $59 million. However, the cost of the R&D project ($5 million) and the cost of the production facility ($20 million) show the profit of this outcome to be $59 – $5 – $20 = $34 million. Branch probabilities are also shown for the chance events. Analyze the decision tree to determine whether the company should undertake the R&D project. If it does, and if the R&D project is successful, what should the company do? What is the expected value of your strategy? What must the selling price be for the company to consider selling the rights to the product? Develop a risk profile for the optimal strategy.arrow_forward
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTFundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningIntermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning