In: Finance
You must evaluate a proposal to buy a new milling machine. The base price is $161,000, and shipping and installation costs would add another $20,000. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $80,500. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The machine would require a $9,500 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 $39,000 per year. The marginal tax rate is 35%, and the WACC is 12%. 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.V.Sunk cost and does not represent incremental cash flow and should not be included
a.Initial Investment Outlay = Base Price + Modification cost + Increase in Working Capital
= -161,000-20,000-9,500
= -$190,500
b.Annual Cash Flows:
Year 1 |
2 |
3 |
|
Savings in Cost |
39,000 |
39,000 |
39,000 |
Less: Depreciation |
59,730 |
81,450 |
27,150 |
Net Savings |
-20,730 |
-42,450 |
11,850 |
Less: Tax @35% |
-7,255.50 |
-14,857.50 |
4,147.50 |
Income after Tax |
-13,474.50 |
-27,592.50 |
7,702.50 |
Add: Depreciation |
59,730 |
81,450 |
27,150 |
Cash Flow |
46,255.50 |
53,857.50 |
34,852.50 |
Add: After tax salvage value |
56,759.50 |
||
Recovery of Working capital |
9,500 |
||
Cash Flow |
46,255.50 |
53,857.50 |
101,112 |
Note: Written down value of machine = 181,000*7% = $12,670
Sale Price = $80,500
Gain on Sale = $67,830
Tax on Gain = $23,740.5
After tax salvage value = 80,500 – 23,740.5 = $56,759.5
c.NPV = Present value of cash inflows – present value of cash outflows
= 46,255.5*PVF(12%, 1 year) + 53,857.5*PVF(12%, 2 years) + 101,112*PVF(12%, 3 years) – 190,500
= 46,255.5*0.893 + 53,857.5*0.797 + 101,112*0.712 – 190,500
= -$34,277.67
No, should not be purchased (since NPV is negative)