In: Finance
New-Project Analysis
The president of your company, MorChuck Enterprises, has asked you to evaluate the proposed acquisition of a new chromatograph for the firm's R&D department. The equipment's basic price is $70,000, and it would cost another $18,500 to modify it for special use by your firm. The chromatograph, which falls into the MACRS 3-year class, would be sold after 3 years for $32,100. The MACRS rates for the first three years are 0.3333, 0.4445 and 0.1481. (Ignore the half-year convention for the straight-line method.) Use of the equipment would require an increase in net working capital (spare parts inventory) of $2,600. The machine would have no effect on revenues, but it is expected to save the firm $22,200 per year in before-tax operating costs, mainly labor. The firm's marginal federal-plus-state tax rate is 25%. Cash outflows and negative NPV value, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to the nearest dollar.
What is the Year-0 net cash flow?
$
What are the net operating cash flows in Years 1, 2, and 3? (Note: Do not include recovery of NWC or salvage value in Year 3's calculation here.)
Year 1: | $ |
Year 2: | $ |
Year 3: | $ |
What is the additional (nonoperating) cash flow in Year 3?
$
If the project's cost of capital is 14%, what is the NPV of the project?
$
Should the chromatograph be purchased?
a.Initial Investment Outlay = Base Price + Modification cost + Increase in Working Capital | |||
=-70,000-18500-2600 | |||
(91,100) | since outflow | ||
b.Annual Cash Flows: | |||
Year 1 | 2 | 3 | |
Savings in Cost | 22,200 | 22,200 | 22,200 |
Less: Depreciation | 29,497 | 39,338 | 13,107 |
Net Savings | -7,297 | -17,138 | 9,093 |
Less: Tax @25% | -1,824.26 | -4,284.56 | 2,273.29 |
Income after Tax | -5,472.79 | -12,853.69 | 6,819.86 |
Add: Depreciation | 29,497 | 39,338 | 13,107 |
Operating Cash Flow | 24,024.26 | 26,484.56 | 19,926.71 |
Add: After tax salvage value | 25,714.46 | ||
Recovery of Working capital | 2,600 | ||
Additional cash flows | 28,314 | ||
Total Cash Flow | 24,024.26 | 26,484.56 | 48,241.18 |
Written down value | 6,558 | ||
Sale price | 32100 | ||
Gain on sale | 25,542 | ||
Tax | 6385.5375 | ||
After tax salvage value | 25714.4625 | ||
c.NPV = Present value of cash inflows – present value of cash outflows | |||
= 24024.26*PVF(14%, 1 year) + 26484.56*PVF(14%, 2 years) + 48241.18*PVF(14%, 3 years) – 91100 | |||
-17085.65564 | |||
No, should not be purchased (since NPV is negative) |