In: Finance
New-Project Analysis
The president of the company you work for 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 $71,000, and it would cost another $15,000 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 $28,000. The MACRS rates for the first 3 years are 0.3333, 0.4445 and 0.1481. Use of the equipment would require an increase in net working capital (spare parts inventory) of $3,350. The machine would have no effect on revenues, but it is expected to save the firm $28,200 per year in before-tax operating costs, mainly labor. The firm's marginal federal-plus-state tax rate is 40%. 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? 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 cash flow in Year 3 from NWC and salvage?
$
If the project's cost of capital is 11%, what is the NPV of the project? .
$
Should the chromatograph be purchased?
-Select-YesNoItem 7
| a.Initial Investment Outlay = Base Price + Modification cost + Increase in Working Capital | |||
| =-71,000-15000-3350 | |||
| (89,350) | since outflow | ||
| b.Annual Cash Flows: | |||
| Year 1 | 2 | 3 | |
| Savings in Cost | 28,200 | 28,200 | 28,200 |
| Less: Depreciation | 28,664 | 38,227 | 12,737 |
| Net Savings | -464 | -10,027 | 15,463 |
| Less: Tax @40% | -185.52 | -4,010.80 | 6,185.36 |
| Income after Tax | -278.28 | -6,016.20 | 9,278.04 |
| Add: Depreciation | 28,664 | 38,227 | 12,737 |
| Operating Cash Flow | 28,385.52 | 32,210.80 | 22,014.64 |
| Add: After tax salvage value | 19,349.04 | ||
| Recovery of Working capital | 3,350 | ||
| Additional cash flows | 22,699 | ||
| Total Cash Flow | 28,385.52 | 32,210.80 | 44,713.68 |
| Written down value | 6,373 | ||
| Sale price | 28000 | ||
| Gain on sale | 21,627 | ||
| Tax | 8650.96 | ||
| After tax salvage value | 19349.04 | ||
| c.NPV = Present value of cash inflows – present value of cash outflows | |||
| = 28,385.52*PVF(11%, 1 year) + 32,210.80*PVF(11%, 2 years) + 44,713.68*PVF(11%, 3 years) – 89,350 | |||
| -4940.194144 | |||
| No, should not be purchased (since NPV is negative) |