Question

In: Finance

You must evaluate the purchase of a spectrometer for a firm. The base price is $140,000...

You must evaluate the purchase of a spectrometer for a firm. The base price is $140,000 and it would cost another $30,000 to modify the equipment for special use by the firm.

The equipment will be depreciated to zero value over the 3 years using prime cost (straight line) method. The machine would be sold after 3 years for $60,000. The machine would require a $8,500 increase in net working capital and fully recover at the end of its 3-year life. The equipment should save the firm $50,000 per year in before-tax labor costs.

Below shows the forecasted sales revenues, variable cost and fixed cost.

Year 1

Year 2

Year 3

Sales quantity (units)

4,000

5,000

5,500

Selling price per unit

$4

$4

$4

Fixed cost of production (per year)

$1,500

$1,500

$1,500

Variable cost of production (per unit)

$1.1

$1.1

$1.1

The marginal tax rate is 40% and the discount rate is 10%.

What is the net present value (NPV) of the proposed project?   

Solutions

Expert Solution

(a.) Calculation of Net present value (NPV) of the proposed project :

Year 0 Year 1 Year 2 Year 3
Initial Investment ( 140000 + 30000) 170000
Saving in Pre tax Labour Cost 50000 50000 50000
Sales (Quantity * Selling Price) 16000 20000 22000
Less :Variable cost of Production (Quantity * Variable cost per unit) 4400 5500 6050
Less :Fixed Cost of Production 1500 1500 1500
Less : Depreciation (170000 / 3 ) 56666.67 56666.67 56666.67
Earning before taxes 3433.333 6333.333 7783.333
Taxes @ 40% -1373.33 -2533.33 -3113.33
Earnings After Taxes 2060 3800 4670
Add : Depreciation 56666.67 56666.67 56666.67
Plus : Salvage Value 60000
Less : tax on salvage @ 40% 24000
NWC 8500
Plus : Recapture of NWC 8500
Operating Cash Flows 178500 58727 60467 105836.7
PV Factor @ 10% 1 0.909091 0.826446 0.751315
PV of Net Cash flows (Inflow) 53387.88 49972.45 79516.65
PV of Net Cash flows (Outflow) 178500
The net present value (NPV) of this project is         = $ 4376.9847 or $ 4376.98
NPV = PV of cash inflow - PV of cash outflow
        = 182879.9847- 178500
        = $ 4376.9847 or $ 4376.98
Working Note :
Book Value = 0 (Since it is fully depreciated
Gain on Sale = Salvage Value - Book Value
                          = 60000- 0
                          = 60000
Tax on Gain on Sale = 60000 * 0.4 = 24000

Related Solutions

You must evaluate a proposed spectrometer for the R&D Department. The base price is $140,000, and...
You must evaluate a proposed spectrometer for the R&D Department. The base price is $140,000, and it would cost another $30,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 $60,000. The applicable depreciation rates are 33%, 45%, 15%, and 7% as discussed in Appendix 12A. The equipment would require an $8,000 increase in working capital (spare parts inventory). The project would have...
You must evaluate the purchase of a spectrometer for the R&D department. The base price is...
You must evaluate the purchase of a spectrometer for the R&D department. The base price is $140,000, and it would cost another $30,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 $60,000. The applicable depreciation rates are 33%, 45%, 15%, and 7% as discussed in Appendix 12A. The equipment would require an $8,000 increase in net operating working working capital (spare parts...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT