In: Finance
You must evaluate a proposal to buy a new milling machine. The base price is $172,000, and shipping and installation costs would add another $7,000. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $60,200. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The machine would require a $10,000 increase in net operating working capital (increased inventory less increased accounts payable). There would be no effect on revenues, but pretax labor costs would decline by $32,000 per year. The marginal tax rate is 35%, and the WACC is 14%. Also, the firm spent $5,000 last year investigating the feasibility of using the machine.
What is the initial investment outlay for the machine for
capital budgeting purposes, that is, what is the Year 0 project
cash flow? Round your answer to the nearest cent.
$
What are the project's annual cash flows during Years 1, 2, and 3? Round your answer to the nearest cent. Do not round your intermediate calculations.
Year 1 $
Year 2 $
Year 3 $
a
Time line | 0 | 1 | 2 | 3 | |||
Cost of new machine | -179000 | ||||||
Initial working capital | -10000 | ||||||
=b. Initial Investment outlay | -189000 | ||||||
3 years MACR rate | 33.00% | 45.00% | 15.00% | 7.00% | |||
Savings | 32000 | 32000 | 32000 | ||||
-Depreciation | =Cost of machine*MACR% | -59070 | -80550 | -26850 | 12530 | =Salvage Value | |
=Pretax cash flows | -27070 | -48550 | 5150 | ||||
-taxes | =(Pretax cash flows)*(1-tax) | -17595.5 | -31557.5 | 3347.5 | |||
+Depreciation | 59070 | 80550 | 26850 | ||||
=c. after tax operating cash flow | 41474.5 | 48992.5 | 30197.5 | ||||
reversal of working capital | 10000 | ||||||
+Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 39130 | |||||
+Tax shield on salvage book value | =Salvage value * tax rate | 4385.5 | |||||
=Terminal year after tax cash flows | 53515.5 | ||||||
Total Cash flow for the period | -189000 | 41474.5 | 48992.5 | 83713 | |||
Discount factor= | (1+discount rate)^corresponding period | 1 | 1.14 | 1.2996 | 1.481544 | ||
Discounted CF= | Cashflow/discount factor | -189000 | 36381.14 | 37698.138 | 56503.891 | ||
NPV= | Sum of discounted CF= | -58416.8 |
d
reject project as NPV is negative