Scenario Analysis Consider a project to supply Detroit with 25,000 tons of machine screws annually for automobile production. You will need an initial $2,700,000 investment in threading equipment to get the project started; the project will last for five years. The accounting department estimates that annual fixed costs will be $275,000 and that variable costs should be $265 per ton; accounting will
- a. What is the estimated OCF for this project? The
NPV ? Should you pursue this project? - b. Suppose you believe that the accounting department’s initial cost and salvage value projections are accurate only to within ±15 percent; the marketing department’s price estimate is accurate only to within ±10 percent; and the engineering department’s net working capital estimate is accurate only to within ±5 percent. What is your worst-case scenario for this project? Your best-case scenario? Do you still want to pursue the project?
a)
To determine: The operating cash flow and net present value.
Introduction:
Net present value (NPV) refers to the discounted value of the future cash flows at present. The company should accept the project, if the net present value is positive or greater than zero and vice-versa. If there are two mutually exclusive projects, then the company has to select the project that has higher net present value.
Answer to Problem 26QP
Solution: The operating cash flow is $1,274,700 and the net present value is $1,684,650.59.
Explanation of Solution
Given information:
The annual fixed costs are $275,000, variable cost per unit is $265 per ton, number of quantity supplied is 25,000, marginal tax rate is 38%, initial investment on the equipment is $2,700,000, and life of the project is five years. The net initial working capital investment is $400,000 and required rate of return is 13%. The salvage value is $250,000. The selling price is $345 per ton. The marginal tax rate at 38%
The formula to calculate the operating cash flow:
The formula to calculate the net present value:
Where,
n refers to the number of years.
Compute the operating cash flows:
Hence, the operating cash flow is $1,274,700.
Compute the net present value:
Note: The increase in operating cash flow at present value of interest factor annuity at 13% for 5 years is 3.51723.
Calculate the net present value:
Hence, the net present value is $1,684,650.59.
b)
To determine: The worst-case scenario and best-case scenario of the project.
Introduction:
Scenario analysis is a process of analyzing the possible future events. This analysis helps to determine the effect of what-if questions towards the net present value estimates. At the time when the firm begins to look for an alternative, then they can be able to find the possible project, which would result in positive net present value (NPV).
Answer to Problem 26QP
Solution:
Worst-case scenario:
The operating cash flow of the worst-case scenario is $770,730 and the NPV of worst-case scenario is −$514,691.82.
Best-case scenario:
The operating cash flow of the best-case scenario is $1,778,670 and the NPV of best-case scenario is $3,883,992.99.
Explanation of Solution
Given information:
The annual fixed costs are $275,000, variable cost per unit is $265 per ton, number of quantity supplied is 25,000, marginal tax rate is 38%, initial investment on the equipment is $2,700,000, and life of the project is five years. The net initial working capital investment is $400,000 and required rate of return is 13%. The salvage value is $250,000. The selling price is $345 per ton. The marginal tax rate at 38%
Formulae:
The formula to calculate the operating cash flow for best or worst-cases scenarios:
Where,
P refers to the price per unit of the project
v refers to the variable cost per unit
Q refers to the number of unit sold
FC refers to the fixed costs
The formula to calculate the NPV of best or worst-cases:
Note: In the best-case scenario, both the price and sales indicates an increase in the value whereas the costs will indicate a decrease in the value. In the worst-case scenario, both the price and sales indicates a decrease in the value but the costs will specify an increase in the value.
Compute the operating cash flow for worst-case scenario:
Note: The tax shield approach is used to determine the operating cash flow of the worst-case scenario. In this given problem, the price and quantity is decreased by 10%. As a result, both price and quantity is multiplied by 10 percent decrease. However, the variable and fixed costs will indicate an increase by 15 percent.
Hence, the operating cash flow of the worst-case scenario is $770,730.
Compute the NPV of worst-case scenario:
Hence, the NPV of the worst-case scenario is −$514,691.82.
Compute the operating cash flow for best-case scenario:
Hence, the operating cash flow of the best-case scenario is $1,778,670.
Compute the net present value of best-case scenario:
Hence, the net present value of the best-case scenario is $3,883,992.99.
To discuss: Whether the project is pursued or not based on the computation of NPV.
Explanation of Solution
The worst-case scenario indicates a negative NPV whereas the best-case indicates the positive NPV. Therefore, to proceed with the project would not be difficult.
Want to see more full solutions like this?
Chapter 7 Solutions
CORPORATE FINANCE-ACCESS >CUSTOM<
- Gina Ripley, president of Dearing Company, is considering the purchase of a computer-aided manufacturing system. The annual net cash benefits and savings associated with the system are described as follows: The system will cost 9,000,000 and last 10 years. The companys cost of capital is 12 percent. Required: 1. Calculate the payback period for the system. Assume that the company has a policy of only accepting projects with a payback of five years or less. Would the system be acquired? 2. Calculate the NPV and IRR for the project. Should the system be purchasedeven if it does not meet the payback criterion? 3. The project manager reviewed the projected cash flows and pointed out that two items had been missed. First, the system would have a salvage value, net of any tax effects, of 1,000,000 at the end of 10 years. Second, the increased quality and delivery performance would allow the company to increase its market share by 20 percent. This would produce an additional annual net benefit of 300,000. Recalculate the payback period, NPV, and IRR given this new information. (For the IRR computation, initially ignore salvage value.) Does the decision change? Suppose that the salvage value is only half what is projected. Does this make a difference in the outcome? Does salvage value have any real bearing on the companys decision?arrow_forwardAverage 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_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
- Gardner Denver Company is considering the purchase of a new piece of factory equipment that will cost $420,000 and will generate $95,000 per year for 5 years. Calculate the IRR for this piece of equipment. For further Instructions on internal rate of return in Excel, see Appendix C.arrow_forwardCaduceus Company is considering the purchase of a new piece of factory equipment that will cost $565,000 and will generate $135,000 per year for 5 years. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return In Excel, see Appendix C.arrow_forwardManzer Enterprises is considering two independent investments: A new automated materials handling system that costs 900,000 and will produce net cash inflows of 300,000 at the end of each year for the next four years. A computer-aided manufacturing system that costs 775,000 and will produce labor savings of 400,000 and 500,000 at the end of the first year and second year, respectively. Manzer has a cost of capital of 8 percent. Required: 1. Calculate the IRR for the first investment and determine if it is acceptable or not. 2. Calculate the IRR of the second investment and comment on its acceptability. Use 12 percent as the first guess. 3. What if the cash flows for the first investment are 250,000 instead of 300,000?arrow_forward
- Talbot Industries is considering launching a new product. The new manufacturing equipment will cost $17 million, and production and sales will require an initial $5 million investment in net operating working capital. The company’s tax rate is 25%. What is the initial investment outlay? The company spent and expensed $150,000 on research related to the new product last year. What is the initial investment outlay? Rather than build a new manufacturing facility, the company plans to install the equipment in a building it owns but is not now using. The building could be sold for $1.5 million after taxes and real estate commissions. What is the initial investment outlay?arrow_forwardAverage 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_forward
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubIntermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning