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 depreciate the initial fixed asset investment straight-fine to zero over the five-year project life. It also estimates a salvage value of $500,000 after dismantling costs. The marketing department estimates that the automakers will let the contract at a selling price of $280 per ton. The engineering department estimates you will need an initial net working capital investment of $410,000. You require a return of 13 percent and face a marginal tax rate of 38 percent on this project.
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 to Problem 27QP
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 to Problem 27QP
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
Fundamentals of Corporate Finance
- 13. Project Analysis You are considering a new product launch. The project will cost$720,000, have a 4-year life, and have no salvage value; depreciation is straight-line tozero. Sales are projected at 380 units per year; price per unit will be $17,400; variablecost per unit will be $14,100; and fixed costs will be $680,000 per year. The requiredreturn on the project is 15 percent and the relevant tax rate is 21 percent.a. Based on your experience, you think the unit sales, variable cost, and fixed costprojections given here are probably accurate to within ±10 percent. What are theupper and lower bounds for these projections? What is the base-case NPV? What arethe best-case and worst-case scenarios?b. Evaluate the sensitivity of your base-case NPV to changes in fixed costs.c. What is the accounting break-even level of output for this project?arrow_forward1 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_forwardNonearrow_forward
- 15arrow_forwardThe 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?arrow_forwardA3arrow_forward
- 15 UPS is considering the purchase of a electric truck that would cost $150,000 and would last for 5 years. At the end of 5 years, the truck would have a salvage value of $20,000. By reducing labor and other operating costs, the machine would provide annual cost savings of $45,000. The company requires a minimum return of 19% on all investment projects. The net present value of the proposed project is closest to (Ignore income taxes.): PV factor of $1 annuity for 5 years at 19% is 3.058 and PV of $1 over 5 years is 0.419 A. $85,000 B. -$12,390 C. -$4,010 D. $145,990arrow_forwardThe most likely outcomes for a particular project are estimated as follows: Unit price: Variable cost: Fixed cost: Expected sales: $ 50 $ 30 $ 490,000 48,000 units per year However, you recognize that some of these estimates are subject to error. Suppose each variable turns 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 $2.3 million, which will be depreciated 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 10%. a. NPV b. NPV a. What is project's NPV in the best-case scenario, that is, assuming all variables take on the best possible value? b. What is project's NPV in the worst-case scenario? Note: For all the requirements, a negative amount should be indicated by a minus sign. Enter your answers in dollars, not in millions. Do not round intermediate calculations. Round your answers to the nearest dollar amount. 4arrow_forward12q-18arrow_forward
- [EXCEL] Net present value: Management of Franklin Mints, a confectioner, is considering purchasing a new jelly bean-making machine at a cost of $312,500. They project that the cash flows from this investment will be $121,450 for the next seven years. If the appropriate discount rate is 14 percent, what is the NPV for the project? please use excelarrow_forwardNeed with explanationarrow_forward[EXCEL] Average accounting rate of return (ARR): Capitol Corp. management is expecting a project to generate after-tax income of $63,435 in each of the next three years. The average book value of the project's equipment over that period will be $212,500. If the firm's investment decision on any project is based on an ARR of 37.5 percent, should this project be accepted? please use excel.arrow_forward
- 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 LearningSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning