In: Finance
NEW PROJECT ANALYSIS
You must evaluate a proposal to buy a new milling machine. The base price is $118,000, and shipping and installation costs would add another $6,000. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $64,900. 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 $44,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.IV.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
= 118,000+6,000 +9,500
= -$133,500 since outflow
b.Annual Cash Flows:
Year 1 |
2 |
3 |
|
Savings in Cost |
44,000 |
44,000 |
44,000 |
Less: Depreciation |
40,920 |
55,800 |
18,600 |
Net Savings |
3,080 |
(11,800) |
25,400 |
Less: Tax @35% |
1,078 |
(4,130) |
8,890 |
Income after Tax |
2,002 |
(7,670) |
16,510 |
Add: Depreciation |
40,920 |
55,800 |
18,600 |
Cash Flow |
42,922 |
48,130 |
35,110 |
Add: After tax salvage value |
45,223 |
||
Recovery of Working capital |
9,500 |
||
Cash Flow |
42,922 |
48,130 |
89,833 |
Note: Written down value of machine = 124000*7% = $8,680
Sale Price = $64,900
Gain on Sale = $56,220
Tax on Gain = $19,677
After tax salvage value = 64,900– 19,677= $45,223
c.NPV = Present value of cash inflows – present value of cash outflows
= 42,922*PVF(12%, 1 year) + 48,130*PVF(12%, 2 years) + 89,833*PVF(12%, 3 years) – 133,500
= 42,922*0.893 + 48,130*0.797 + 89,833*0.712 – 133,500
= $7,150.052
Yes, should not be purchased (since NPV is positive)