Scenario Analysis [LO2] Consider a project to supply Detroit with 35,000 tons of machine screws annually for automobile production. You will need an initial $5,200,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 $985,000 and that variable costs should be $185 per ton; accounting will
a. What is the estimated OCF for this project? The
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 estimated operating cash flow (OCF) and Net present value of the project.
Introduction:
Net present value (NPV) refers to the discounted value of the future cash flows at present. In case, the NPV is positive or greater than zero, then the company will accept the project or vice-versa. If there are two mutually exclusive projects, then the company has to select the project that has higher net present value.
Answer
The estimated Operating cash flow is $1,846,000.
The NPV of the project is $1,273,596.06.
Explanation of Solution
Given information:
The annual fixed costs are $985,000, variable cost per unit is $185 per ton, number of quantity supplied is 35,000, marginal tax rate is 38%, initial investment on the equipment is $5,200,000, and life of the project is five years. The net initial working capital investment is $410,000 and the required rate of return is 13%.
Formulae:
The formula to calculate the operating cash flow:
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:
Where,
n refers to the number of years.
Compute the Operating cash flow (OCF):
Hence, the estimated Operating cash flow (OCF) is $1,846,000.
Compute the NPV:
Note: To determine the present value of annuity of $1 period for 8 period at a discount rate of 10%, refer the PV of an annuity of $1 table. Then, find out the 10% discount rate and period of 8 years’ value from the table. Here, the value for the rate 10% and 8 years’ period value is 5.3349.
Hence, the NPV is $1,273,593.77.
To discuss: Whether the project is pursued or not based on the computation of NPV.
Explanation of Solution
A project is accepted, when the net present value is positive or greater than zero. This project indicates a positive NPV of $1,273,593.77. Therefore, the project is pursed.
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 might be able to find the possible project, which would result in a positive net present value (NPV).
Answer
Worst-case scenario:
The operating cash flow of the worst-case is $1,297,680.
The Net present value (NPV) of the worst-case is -$1,469,585.54.
Best-case scenario:
The operating cash flow of the best-case is $2,394,320.
The Net present value (NPV) of best-case scenario is -$3,206,975.18195.
Explanation of Solution
Given information:
The fixed costs of the project are $985,000. The variable cost per unit is $185 per ton and selling price per unit of the project is $280 per ton. The unit sold is 35,000 tons, required rate of return is 13%, and marginal tax rate is 38%.
The initial cost and salvage value of the projection is ±15%. The price estimate will be accurate within ±10% as per the marketing department. The estimate of net working capital is ±5%.
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 units 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 indicate 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 indicate a decrease 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 worst-case scenario. In this problem, the price and quantity is decreased by 10%. As a result, both the price and quantity is multiplied by a 10 percent decrease. However, the variable and fixed costs will indicate an increase by 15 percent.
Hence, the operating cash flow of worst-case scenario is $1,297,680.
Compute the NPV of worst-case scenario:
Hence, the NPV of worst-case scenario is -$1,469,585.54.
Compute the operating cash flow for best-case scenario:
Hence, the operating cash flow of best-case scenario is $2,394,320.
Compute the NPV of best-case scenario:
Hence, the NPV of best-case scenario is −$3,206,975.18195. Both the best and worst-case scenarios indicate a negative NPV. Therefore, it will be difficult to proceed with project.
Want to see more full solutions like this?
Chapter 11 Solutions
FUND. OF CORP. FINANCE (LL) W/CONNECT
- show all excel formulas/ work answering the following: LO2 27. Project Analysis You are considering a new product launch. The project will cost $780,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 170 units per year, price per unit will be $16,300, variable cost per unit will be $11,100, and fixed costs will be $535,000 per year. The required return on the project is 11 percent, and the relevant tax rate is 21 percent. a. Based on your experience, you think the unit sales, variable cost, and fixed cost projections given here are probably accurate within +10 percent. What are the best and worst cases for these projections? What is the base-case NPV? What are the best- case and worst-case scenarios? b. Evaluate the sensitivity of your base-case NPV to changes in fixed costs.arrow_forwardA3 8av You are considering a new product launch. The project will cost $680,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 100 units per year, price per unit will be $19,000, variable cost per unit will be $14,000, and fixed costs will be $150,000 per year. The required return on the project is 15%, and the relevant tax rate is 35%. Ignore the half-year rule for accounting for depreciation. a. Calculate the following six numbers for this project. Round your answers to two decimal places. (v) Internal Rate of Return (IRR in %)arrow_forwardA3 8ai You are considering a new product launch. The project will cost $680,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 100 units per year, price per unit will be $19,000, variable cost per unit will be $14,000, and fixed costs will be $150,000 per year. The required return on the project is 15%, and the relevant tax rate is 35%. Ignore the half-year rule for accounting for depreciation. a. Calculate the following six numbers for this project. Round your answers to two decimal places. (i) NPVarrow_forward
- CH5 #10 A company is considering two alternative marketing strategies for a new product. Introducing the product will require an outlay of $15,000. With a low price, the product will generate cash proceeds of $10,000 per year and will have a life of two years. With a high price, the product will generate cash proceeds of $18,000 but will have a life of only one year. The hurdle rate for this project is 0.05. Which marketing strategy should be accepted?arrow_forwardA3 8avi You are considering a new product launch. The project will cost $680,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 100 units per year, price per unit will be $19,000, variable cost per unit will be $14,000, and fixed costs will be $150,000 per year. The required return on the project is 15%, and the relevant tax rate is 35%. Ignore the half-year rule for accounting for depreciation. a. Calculate the following six numbers for this project. Round your answers to two decimal places. (vi) Average Accounting Return (AAR in %) Hint: Net Income = {[(Price – variable cost)*Quantity Sold] – Fixed Costs – Depreciation} * (1 – Tax rate)arrow_forward5. Flexibility options Stay Swift Corp. is looking at investing in a production facility that will require an initial investment of $500,000. The facility will have a three-year useful life, and it will not have any salvage value at the end of the project’s life. If demand is strong, the facility will be able to generate annual cash flows of $255,000, but if demand turns out to be weak, the facility will generate annual cash flows of only $135,000. Stay Swift Corp. thinks that there is a 50% chance that demand will be strong and a 50% chance that demand will be weak. If the company uses a project cost of capital of 13%, what will be the expected net present value (NPV) of this project? -$37,596 -$39,575 -$29,681 -$19,788 Stay Swift Corp. could spend $510,000 to build the facility. Spending the additional $10,000 on the facility will allow the company to switch the products they produce in the facility after the first year of operations if demand…arrow_forward
- 1 Downside scenarios Consider a proposal to produce and market a new tennis racquet. The most likely outcome scenario for the project incl. Expected sales of 30,000 units per year, Unit price of $200, Variable cost per racquet of $120, Fixed cost of $1,200,000. The project will last for 10 years and requires an initial investment of $4 million, which will be depreciated straight-line over the project life to a fnal value of zero. The firm´s tax rate is 30%, and the required rate of return is 12%. 1. What is the project NPV? However, you recognize that some of these estimates are subject to error. Sales could fall 20% below expectations for the life of the project and, if that happens, the unit price would probably be only $150. The good news is that Öxed costs could be as low as $800,000, and total Variable costs1 would decline in proportion to sales. 2. What is NPV in the worst-case scenario?3. How else could you consider the downside scenario in your NPV calculation? (Answer…arrow_forwardA3 8aiii You are considering a new product launch. The project will cost $680,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 100 units per year, price per unit will be $19,000, variable cost per unit will be $14,000, and fixed costs will be $150,000 per year. The required return on the project is 15%, and the relevant tax rate is 35%. Ignore the half-year rule for accounting for depreciation. a. Calculate the following six numbers for this project. Round your answers to two decimal places. (iii) Payback period (in years)arrow_forward2 Net Present Value (NPV) Example 1 (Ross et al., 2023, pp. 299-300): We want to establish a new fertilizer business. The project costs $30,000 to launch. The project can generate cash revenues of $20,000 per year. The project will incur cash costs (including taxes) of $14,000 per year. The project will be terminated in 8 years and the project's assets can be sold for $2,000 at that time. A 15% discount rate is appropriate for this project. a. Should we undertake this project? b. If there are 1,000 shares of stock outstanding, what will be the effect on the price per share from taking the project?arrow_forward
- Engineering economy - ENGR 3322 The International Parcel Service has installed a new radio frequency identification system to help reduce the number of packages that are incorrectly delivered. The capital investment in the system is $65,000, and the projected annual savings are tabled below. The system’s market value at the EOY five is negligible, and the MARR is 18% per year. Calculate the annual worth of the project. a. $ 9,750 b. $ 10,750 c. $ 11,750 d. None of the choicesarrow_forwardEngineering economy - ENGR 3322 The International Parcel Service has installed a new radio frequency identification system to help reduce the number of packages that are incorrectly delivered. The capital investment in the system is $65,000, and the projected annual savings are tabled below. The system’s market value at the EOY five is negligible, and the MARR is 18% per year. Calculate the return on investment of the project a. 36% b. 37% c. 38% d. None of the choicesarrow_forward14. Need help with this question asap please! A company is considering a project that would require a cash outflow in the amount of $1,000,000 at the beginning. The company expects the project to generate average annual cash inflows in the amount of $40,000. The average book value for the project is expected to be $250,000 and average annual net income is expected to be $55,000. The company requires a return of 15.25%. What is the average accounting return for this project?arrow_forward
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education