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 (The Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate)
- Consider a project to supply Detroit with 25,000 tons of machine screws annually for automobile production. You will need an initial $5,400,000 investment in threading equipment to get the project started; the project will last for 6 years. The accounting department estimates that annual fixed costs will be $1,300,000 and that variable costs should be $245 per ton; accounting will depreciate the initial fixed asset investment straight-line to zero over the 6-year project life. It also estimates a salvage value of $675,000 after dismantling costs. The marketing department estimates that the automakers will let the contract at a selling price of $356 per ton. The engineering department estimates you will need an initial net working capital investment of $520,000. You require a return of 9 percent and face a tax rate of 21 percent on this project. Calculate the accounting, cash, and financial break-even quantities. (Do not round intermediate calculations and round your answers to the…arrow_forwardConsider a project to supply Detroit with 27,000 tons of machine screws annually for automobile production. You will need an initial $5,600,000 investment in threading equipment to get the project started; the project will last for 6 years. The accounting department estimates that annual fixed costs will be $1,350,000 and that variable costs should be $255 per ton; accounting will depreciate the initial fixed asset investment straight-line to zero over the 6-year project life. It also estimates a salvage value of $725,000 after dismantling costs. The marketing department estimates that the automakers will let the contract at a selling price of $368 per ton. The engineering department estimates you will need an initial net working capital investment of $540,000. You require a return of 12 percent and face a tax rate of 23 percent on this project. Calculate the accounting, cash, and financial break-even quantities. (Do not round intermediate calculations and round your answers to the…arrow_forward26. Scenario Analysis Consider a project to supply Detroit with 26,000 tons of machine screws annually for automobile production. You will need an initial $2,900,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 $345,000 and that variable costs should be $295 per ton; accounting will depreciate the initial fixed asset investment straight-line to zero over the 5-year project life. It also estimates a salvage value of $275,000 after dismantling costs. The marketing department estimates that the automakers will let the contract at a selling price of $375 per ton. The engineering department estimates you will need an initial net working capital investment of $500,000. You require a 13 percent return and face a marginal tax rate of 24 percent on this project. a. What is the estimated OCF for this project? The NPV? Should you pursue this project? b. Suppose you believe…arrow_forward
- 4. Your company is considering the introduction of a new product line. The initial investment required for this project is $500,000, and annual maintenance costs are anticipated to be $35,000. Annual operating costs will be directly proportional to the level of production at $7.50 per unit, and each unit of product can be sold for $50. If the MARR is 15% and the project has a life of 5 years, what is the minimum annual production level for which the project is economically viable?arrow_forwardConsider a project to supply Detroit with 40,000 tons of machine screws annually forautomobile production. You will need an initial $5,600,000 investment in threadingequipment to get the project started; the project will last for 6 years. The accountingdepartment estimates that annual fixed costs will be $600,000 and that variable costsshould be $250 per ton. Further, the accounting department will depreciate the initialfixed asset investment straight-line to zero over the 6-year project life and estimate asalvage value of $450,000 after dismantling costs. The marketing department estimatesthat the automakers will let the contract at a selling price of $340 per ton. The engineeringdepartment estimates you will need an initial net working capital investment of $560,000.You require a return of 13 percent and face a marginal tax rate of 24 percent on thisproject.Suppose you’re confident about your own projections, but you’re a little unsure aboutDetroit’s actual machine screw…arrow_forwardYou are considering a proposal to produce and market a new sluffing machine. The most likely outcomes for the project are as follows: Expected sales: 115,000 units per year Unit price: $220 Variable cost: $132 Fixed cost: $4,890,000 The project will last for 10 years and requires an initial investment of $16.70 million, which will be depreciated straight-line over the project life to a final value of zero. The firm's tax rate is 30%, and the required rate of return is 12%. However, you recognize that some of these estimates are subject to error. In one scenario a sharp rise in the dollar could cause sales to fall 30% below expectations for the life of the project and, if that happens, the unit price would probably be only $210. The good news is that fixed costs could be as low as $3,260,000, and variable costs would decline in proportion to sales. a. What is project NPV if all variables are as expected? Note: Do not round intermediate calculations. Enter your answer in thousands not in…arrow_forward
- es You are considering a new product launch. The project will cost $2,225,000, have a four- year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 280 units per year; price per unit will be $19,700, variable cost per unit will be $13,250, and fixed costs will be $670,000 per year. The required return on the project is 12 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 to within ±10 percent. What are the upper and lower bounds for these projections? What is the base-case NPV? What are the best-case and worst-case scenarios? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Round your NPV answers to 2 decimal places, e.g., 32.16. Round your other answers to the nearest whole number, e.g. 32.) Scenario Unit Sales Variable Cost Fixed Costs NPV Base 280 $ 13,250 $ 670,000…arrow_forwardA particular service can be purchased for $130 per unit. The same service can be provided by equipment that costs $400,000 today and has a salvage value of $250,000 after 10 years. Annual operating expenses will be $5000 per year plus $20 per unit.a) If the estimates are correct, what will be the internal rate of return on the incremental investment if 400 units/year are produced.b) If the Attractive Minimum Rate of Return is 15% per year, what is the best alternative? Please answer in detailarrow_forwardYou are considering a proposal to produce and market a new sluffing machine. The most likely outcomes for the project are as follows: Expected sales: 125,000 units per year Unit price: $240 Variable cost: $144 Fixed cost: $5,430,000 The project will last for 10 years and requires an initial Investment of $21.78 million, which will be depreciated straight-line over the project life to a final value of zero. The firm's tax rate is 30%, and the required rate of return is 12% However, you recognize that some of these estimates are subject to error. In one scenario a sharp rise in the dollar could cause sales to fall 30% below expectations for the life of the project and, if that happens, the unit price would probably be only $230. The good news is that fixed costs could be as low as $3,620,000, and variable costs would decline in proportion to sales. a. What is project NPV If all variables are as expected? Note: Do not round Intermediate calculations. Enter your answer in thousands not in…arrow_forward
- NEED ASAP !!!! WITH EXPLANATION Santos Company needs a new cutting machine. The company is considering two machines: machine X and machine Y. Machine A costs$18,000, has a useful life of ten years, and will reduce operating costs by $7,000 per year. Machine B costs only $12,500, will also reduceoperating costs by $3,500 per year, but has a useful life of only five years.The payback period formula is = Investment required / Annual Net Cash Inflow Which machine should be purchased according to the payback method? a)Machine Xb) none of the abovec) Machine Yd) Both have the same payback periodarrow_forwardThe management of a manufacturing company is planning to buy a new milling machine. The investment cost is $17,613. At the end of its 6-year expected life, the equipment will have a salvage value of $8,000. There is an upgrade cost of $9,572 at the end of year 3. The equipment can save $5,000 per year by increasing productivity. Suppose that ϵ=MARR=18%. Determine the project’s ERR.arrow_forwardYou are responsible to manage an IS project with a 4-year horizon. The annal cost of the project is estimated at $40,000 per year, and a one-time costs of $120,000. The annual monetary benefit of the project is estimated at $96,000 per year with a discount rate of 6 percent. a. Calculate the overall return on investment (ROI) of the project. b. Perform a break-even analysis (BEA). At what year does break-even occur?arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning