Question

In: Finance

Q: You are considering a proposal to produce and market a new sluffing machine. The most...

Q:

You are considering a proposal to produce and market a new sluffing machine. The most likely outcomes for the project are as follows:

Expected sales: 30,000 units per year

Unit price: $50

Variable cost: $30

Fixed cost: $300,000

The project will last for 10 years and requires an initial investment of $1 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. Sales could fall 30% below expectations for the life of the project and, if that happens, the unit price would probably be only $40. The good news is that fixed costs could be as low as $200,000, and variable costs would decline in proportion to sales.

a. What is project NPV if all variables are as expected? (Do not round intermediate calculations. Enter your answer in thousands not in millions and round your answer to the nearest whole dollar amount.)

b. What is NPV in the worst-case scenario? (Do not round intermediate calculations. Enter your answer in thousands not in millions and round your answer to the nearest whole dollar amount. Negative amount should be indicated with a minus sign.)

Solutions

Expert Solution

a. NPV is the difference between present value of cash inflows and initial investment.

present value of cash inflows = Year 1 operating cash flow/(1+required rate of return) + Year 2 operating cash flow/(1+required rate of return)2 + Year 3 operating cash flow/(1+required rate of return)3 + Year 4 operating cash flow/(1+required rate of return)4 ... + Year 10 operating cash flow/(1+required rate of return)10

Years 0 1 2 3 4 5 6 7 8 9 10
Initial investment -$1,000,000 0 0 0 0 0 0 0 0 0 0
Sales quantity 0 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000
Sales price/unit 0 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00
Variable cost/unit 0 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00
Sales $0 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000
Less: Variable cost $0 $900,000 $900,000 $900,000 $900,000 $900,000 $900,000 $900,000 $900,000 $900,000 $900,000
Less: Fixed cost $0 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000
Less: Depreciation $0 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
Pre-tax cash flow $0 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000
Less: Taxes @30% $0 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000
After-tax cash flow $0 $140,000 $140,000 $140,000 $140,000 $140,000 $140,000 $140,000 $140,000 $140,000 $140,000
Add back: Depreciation $0 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
Operating cash flow -$1,000,000 $240,000 $240,000 $240,000 $240,000 $240,000 $240,000 $240,000 $240,000 $240,000 $240,000
NPV $356,054

project NPV is $356,054 if all variables are as expected.

Calculations

b. NPV in the worst-case scenario

new sales = expected sales*(1-rate of fall) = 30,000*(1-0.30) = 30,000*0.70 = 21,000

% drop is sale price = (reduced sale price/expected sale price) - 1 = ($40/$50) - 1 = 0.8 - 1 = -0.2 or 20%

reduced variable cost per unit = expected variable cost*(1-% drop is sale price) = $30*(1-0.20) = $30*0.8 = $24

Years 0 1 2 3 4 5 6 7 8 9 10
Initial investment -$1,000,000 0 0 0 0 0 0 0 0 0 0
Sales quantity 0 21,000 21,000 21,000 21,000 21,000 21,000 21,000 21,000 21,000 21,000
Sales price/unit 0 $40.00 $40.00 $40.00 $40.00 $40.00 $40.00 $40.00 $40.00 $40.00 $40.00
Variable cost/unit 0 $24.00 $24.00 $24.00 $24.00 $24.00 $24.00 $24.00 $24.00 $24.00 $24.00
Sales $0 $840,000 $840,000 $840,000 $840,000 $840,000 $840,000 $840,000 $840,000 $840,000 $840,000
Less: Variable cost $0 $504,000 $504,000 $504,000 $504,000 $504,000 $504,000 $504,000 $504,000 $504,000 $504,000
Less: Fixed cost $0 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000
Less: Depreciation $0 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
Pre-tax cash flow $0 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000
Less: Taxes @30% $0 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800
After-tax cash flow $0 $25,200 $25,200 $25,200 $25,200 $25,200 $25,200 $25,200 $25,200 $25,200 $25,200
Add back: Depreciation $0 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
Operating cash flow -$1,000,000 $125,200 $125,200 $125,200 $125,200 $125,200 $125,200 $125,200 $125,200 $125,200 $125,200
NPV ($292,592)

NPV in the worst-case scenario is -$292,592.


Related Solutions

You are considering a proposal to produce and market a new sluffing machine. The most likely...
You are considering a proposal to produce and market a new sluffing machine. The most likely outcomes for the project are as follows: Expected sales: 30,000 units per year Unit price: $50 Variable cost: $30 Fixed cost: $300,000 The project will last for 10 years and requires an initial investment of $1 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...
You are considering a proposal to produce and market a new sluffing machine. The most likely...
You are considering a proposal to produce and market a new sluffing machine. The most likely outcomes for the project are as follows: Expected sales: 100,000 units per year Unit price: $190 Variable cost: $114 Fixed cost: $4,080,000 The project will last for 10 years and requires an initial investment of $11.28 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...
You are considering a proposal to produce and market a new sluffing machine. The most likely...
You are considering a proposal to produce and market a new sluffing machine. The most likely outcomes for the project are as follows: Expected sales: 100,000 units per year Unit price: $190 Variable cost: $114 Fixed cost: $4,080,000 The project will last for 10 years and requires an initial investment of $11.28 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...
You are considering a proposal to produce and market a new sluffing machine. The most likely...
You are considering a proposal to produce and market a new sluffing machine. The most likely outcomes for the project are as follows: Expected sales: 30,000 units per year Unit price: $50 Variable cost: $30 Fixed cost: $300,000 The project will last for 10 years and requires an initial investment of $1 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...
Polycorp Steel Division is considering a proposal to purchase a new machine to produce a new...
Polycorp Steel Division is considering a proposal to purchase a new machine to produce a new product for a three-year contract. The new machine will cost $1.83 million. The machine has an estimated life of 3 years for accounting and taxation purposes. Installation will cost a further $90,000. The contract will not continue beyond three years and the equipment has an estimated salvage value at the end of three years of $300,000. The tax rate is 29 percent and is...
Polycorp Steel Division is considering a proposal to purchase a new machine to produce a new...
Polycorp Steel Division is considering a proposal to purchase a new machine to produce a new product for a three-year contract. The new machine will cost $1.83 million. The machine has an estimated life of 3 years for accounting and taxation purposes. Installation will cost a further $90,000. The contract will not continue beyond three years and the equipment has an estimated salvage value at the end of three years of $300,000. The tax rate is 29 percent and is...
Polycorp Steel Division is considering a proposal to purchase a new machine to produce a new...
Polycorp Steel Division is considering a proposal to purchase a new machine to produce a new product for a three-year contract. The new machine will cost $1.83 million. The machine has an estimated life of 3 years for accounting and taxation purposes. Installation will cost a further $90,000. The contract will not continue beyond three years and the equipment has an estimated salvage value at the end of three years of $300,000. The tax rate is 29 percent and is...
Tocserp is considering the purchase of a new machine that will produce widgets. The widget maker...
Tocserp is considering the purchase of a new machine that will produce widgets. The widget maker will require an initial investment of $12,000 and has an economic life of five years and will be fully depreciated by the straight line method. The machine will produce 1,400 widgets per year with each costing $2.00 to make. Each will be sold at $4.50. Assume Tocserp uses a discount rate of 14 percent and has a tax rate of 34 percent. What is...
A corporation is considering a proposal for the purchase of a machine that will save $250,000...
A corporation is considering a proposal for the purchase of a machine that will save $250,000 per year before taxes. The cost of operating the machine, including maintenance, is $35,000 per year. The machine will be needed for five years after which it will have a zero salvage value. MACRS depreciation will be used, assuming a three‐year class life. The marginal income‐tax rate is 24%. If the firm wants 15% IRR after taxes, how much can it afford to pay...
NEW PROJECT ANALYSIS You must evaluate a proposal to buy a new milling machine. The base...
NEW PROJECT ANALYSIS You must evaluate a proposal to buy a new milling machine. The base price is $163,000, and shipping and installation costs would add another $18,000. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $65,200. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The machine would require a $3,000 increase in net operating working capital (increased inventory less increased accounts payable). There would be no effect on...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT