Question

Bart and Millhouse own a small factory that manufactures rubber snakes used to scare away birds from houses, gardens and playgrounds. A recent and unexplained increase in the bird population in Springfield has significantly increased the demand for

rubber snakes. To take advantage of this opportunity, Bart and Millhouse plan to add a new molding machine that will double the output of their existing facility. The cost of the new machine is $20,000. With this purchase, current assets must increase by $5,000 and current liabilities will increase by $3,000. The economic life of the machine is 4 years, and it falls under the MACRS three year depreciation schedule. The machine is expected to be obsolete at the end of the fourth year and have no salvage value.

Bart and Millhouse anticipate recouping 100% of the additional investment in net working capital at the end of year 4. Sales are expected to increase by $20,000 each year in year 1 and 2 and by $10,000 each year in year 3 and 4. The increase in operating expenses is estimated to be 20% of the annual change in sales. Assume that the marginal tax rate is 40%.

Assume that the company’s discount rate is 14%. Calculate the NPV of this project. Would you recommend that Bart and Millhouse add this machine to their factory?

USING FORMULAS PLEASE

Answer 1

fr =20000*0.3333 D3 Н Depreciat After-tax OCF Deprecia Working capital Net Tax cash PVIF@ Year Revenue Tax@40% income Investment flow 14% Costs tion PBT ion Present value -$13,600.00 (2,000) $ (11,600) $ (13,600) 1.000 1 $ 20,000 $ 4,000 $ 6,666 | $ 9,334 $ 3,734 $ 5,600 $ 6,666 $ 12,266 $ $10,760.00 3 12,266 0.877 2 $ 20,000 $ 4,000 $ 8,890 $ 7,110 $ 2,844 $ 4,266 $ 8,890 $ 13,156$ $10,123.11 0.769 13,156 3 $ 10,000 $ 2,000 $ 2,962 $ 5,038 $ 2,015 $ 3,023 $ 2,962 $ 5,985 $ $4,039.57 5,985 0.675 4 $ 10,000 $ 2,000 $ 1,482 $ 3,911 $ 1,482 $ 6,518 | $ 2,607 5,393 $ $ $4,377.13 2,000 7,393 0.592 $15,699.82 Net present value

*Please rate thumbs up