Question

In: Finance

You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price...

You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $240,000, and it would cost another $48,000 to modify the equipment for special use by the firm. The equipment falls into the MACRS 3-year class and would be sold after 3 years for $72,000. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require a $9,000 increase in net operating working capital (spare parts inventory). The project would have no effect on revenues, but it should save the firm $61,000 per year in before-tax labor costs. The firm's marginal federal-plus-state tax rate is 40%.

a. What is the initial investment outlay for the spectrometer, that is, what is the Year 0 project cash flow? Round your answer to the nearest cent. Negative amount should be indicated by a minus sign.

b. What are the project's annual cash flows in Years 1, 2, and 3? Round your answers to the nearest cent.

In Year 1 $ ________

In Year 2 $ ________

In Year 3 $ ________

c. If the WACC is 13%, should the spectrometer be purchased?

Solutions

Expert Solution

a.Initial Investment Outlay = Base Price + Modification cost + Increase in Working Capital

= -240,000-48,000-9,000

= -$297,000

b.Annual Cash Flows:

Year 1

2

3

Savings in Cost

61,000

61,000

61,000

Less: Depreciation

95,040

129,600

43,200

Net Savings

-34,040

-68,600

17,800

Less: Tax @40%

-13,616

-27,440

7,120

Income after Tax

-20,424

-41,160

10,680

Add: Depreciation

95,040

129,600

43,200

Cash Flow

74,616

88,440

53,880

Add: After tax salvage value

51,264

Recovery of Working capital

9,000

Cash Flow

74,616

88,440

114,144

Note: Written down value of machine = 288,000*7% = $20,160

Sale Price = $72,000

Gain on Sale = $51,840

Tax on Gain = $20,736

After tax salvage value = 72,000 – 20,736 = $51,264

c.NPV = Present value of cash inflows – present value of cash outflows

= 74,616*PVF(13%, 1 year) + 88,440*PVF(13%, 2 years) + 114,144*PVF(13%, 3 years) – 297,000

= 74,616*0.885 + 88,440*0.783 + 114,144*0.693 - 297,000

= -$82,614.53

No, should not be purchased (since NPV is negative)


Related Solutions

You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price...
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $200,000, and it would cost another $50,000 to modify the equipment for special use by the firm. The equipment falls into the MACRS 3-year class and would be sold after 3 years for $50,000. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require a $10,000 increase in net operating working capital (spare parts inventory). The project would have...
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price...
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $280,000, and it would cost another $56,000 to modify the equipment for special use by the firm. The equipment falls into the MACRS 3-year class and would be sold after 3 years for $126,000. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require a $7,000 increase in net operating working capital (spare parts inventory). The project would have...
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price...
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $190,000, and it would cost another $28,500 to modify the equipment for special use by the firm. The equipment falls into the MACRS 3-year class and would be sold after 3 years for $76,000. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require a $14,000 increase in net operating working capital (spare parts inventory). The project would have...
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price...
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $240,000, and it would cost another $36,000 to modify the equipment for special use by the firm. The equipment falls into the MACRS 3-year class and would be sold after 3 years for $108,000. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require a $8,000 increase in net operating working capital (spare parts inventory). The project would have...
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price...
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $60,000, and it would cost another $12,000 to modify the equipment for special use by the firm. The equipment falls into the MACRS 3-year class and would be sold after 3 years for $27,000. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require an $13,000 increase in net operating working capital (spare parts inventory). The project would have...
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price...
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $270,000, and it would cost another $67,500 to modify the equipment for special use by the firm. The equipment falls into the MACRS 3-year class and would be sold after 3 years for $135,000. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require a $9,000 increase in net operating working capital (spare parts inventory). The project would have...
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price...
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $250,000, and it would cost another $37,500 to modify the equipment for special use by the firm. The equipment falls into the MACRS 3-year class and would be sold after 3 years for $62,500. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require a $10,000 increase in net operating working capital (spare parts inventory). The project would have...
you must evaluate the purchase of a proposed spectrometer for the R&D department. The base price...
you must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $240,000, and it would cost another $36,000 to modify the equipment for special use by the firm. The equipment falls into the MACRS 3-year class and would be sold after 3 years for $108,000. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require a $8,000 increase in net operating working capital (spare parts inventory). The project would have...
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price...
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $90,000, and it would cost another $13,500 to modify the equipment for special use by the firm. The equipment falls into the MACRS 3-year class and would be sold after 3 years for $40,500. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require an $14,000 increase in net operating working capital (spare parts inventory). The project would have...
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price...
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $70,000, and it would cost another $14,000 to modify the equipment for special use by the firm. The equipment falls into the MACRS 3-year class and would be sold after 3 years for $24,500. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require an $9,000 increase in net operating working capital (spare parts inventory). The project would have...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT