Question

In: Finance

LMN Co. is considering a four-year project to improve its production efficiency. Buying a new machine...

LMN Co. is considering a four-year project to improve its production efficiency. Buying a new machine for $564,681 is estimated to result in $197,759 in annual pretax cost savings. The press falls in the MACRS five-year class, and it will have a salvage value at the end of the project of $67,980. The press also requires an initial investment in spare parts inventory of $20,510, along with an additional $3,912 in inventory for each succeeding year of the project, with full recovery at the end of year 4. If the shop's tax rate is 36 percent and its discount rate is 11 percent, what is the NPV?

Solutions

Expert Solution

Answer :

Initial investment = $564,681

Useful life = 4 years

Depreciation of Year 1 = 20.00% * $564,681 = $112,936.20

Depreciation of Year 2 = 32.00% * $564,681 = $180,697.92

Depreciation of Year 3 = 19.20% * $564,681 = $108,418.75

Depreciation of Year 4 = 11.52% * $564,681 = $65,051.25

Book value at the end of year 4 = $564,681 - $112,936.20 - $180,697.92 - $108,418.75 - $65,051.25

= $97,576.88

After-tax salvage value = Salvage value - ( Salvage value - Book value ) * tax rate

= $67,980 - ( $67,980 - $97,576.88 ) * 0.36

= $78,634.88

Year 0:

Net cash flows = Initial investment - Initial investment in NWC

= - $564,681 - $20,510 = - $585,191

Year 1:

Operating cash flow = Pre-tax cost saving * ( 1 - tax ) + tax * Depreciation

= $197,759 * ( 1 - 0.36 ) + 0.36 * $112,936.20

= $167,222.80

Net cash flows = Operating cash flow - Investment in NWC

= $167,222.80 - $3,912 = $163,310.80

Year 2:

Operating cash flow = Pre-tax cost saving * ( 1 - tax ) + tax * Depreciation

= $197,759 * ( 1 - 0.36 ) + 0.36 * $180,697.92

= $191,617.01

Net cash flows = Operating cash flow - Investment in NWC

= $191,617.01 - $3,912 = $187,705.01

Year 3:

Operating cash flow = Pre-tax cost saving * ( 1 - tax ) + tax * Depreciation

= $197,759 * ( 1 - 0.36 ) + 0.36 * $108,418.75

= $165,596.51

Net cash flows = Operating cash flow - Investment in NWC

= $165,596.51 - $3,912 = $161,684.50

Year 4:

Operating cash flow = Pre-tax cost saving * ( 1 - tax ) + tax * Depreciation

= $197,759 * ( 1 - 0.36 ) + 0.36 * $65,051.25

= $149,984.21

Net cash flows = Operating cash flows + NWC recovered + After-tax salvage value [ Note : NWC recovered = sum of all NWC invested ]

= $149,984.21 + $32,246 + $78,634.88

= $260,865.09

Required return = 11%

NPV = - $585,191 + $163,310.80 / 1.11 + $187,705.01 / 1.11^2 + $161,684.50 / 1.11^3 + $260,865.09 / 1.11^4

NPV = $4,343.67

  


Related Solutions

LMN Co. is considering a four-year project to improve its production efficiency. Buying a new machine...
LMN Co. is considering a four-year project to improve its production efficiency. Buying a new machine for $504,653 is estimated to result in $193,497 in annual pretax cost savings. The press falls in the MACRS five-year class, and it will have a salvage value at the end of the project of $69,336. The press also requires an initial investment in spare parts inventory of $18,633, along with an additional $3,427 in inventory for each succeeding year of the project, with...
LMN Co. is considering a four-year project to improve its production efficiency. Buying a new machine...
LMN Co. is considering a four-year project to improve its production efficiency. Buying a new machine for $536,680 is estimated to result in $199,833 in annual pretax cost savings. The press falls in the MACRS five-year class, and it will have a salvage value at the end of the project of $69,265. The press also requires an initial investment in spare parts inventory of $22,611, along with an additional $3,788 in inventory for each succeeding year of the project, with...
CMS Machine Shop is considering a four-year project to improve its production efficiency. Buying a new...
CMS Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $545,000 is estimated to result in $97,000 in annual pretax cost savings. The press falls in the MACRS five-year class, and it will have a salvage value of $70,000. The press also requires an initial working capital of $21,000, along with an additional $3,000 in working capital for each succeeding years of project. The tax rate is 34%, and the company's...
Geller Machine Shop is considering a four-year project to improve its production efficiency. Buying a new...
Geller Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $390,000 is estimated to result in $150,000 in annual pretax cost savings. The press falls in the MACRS five-year class, and it will have a salvage value at the end of the project of $66,000. The press also requires an initial investment in spare parts inventory of $12,000, along with an additional $1,700 in inventory for each succeeding year of the...
Geary Machine Shop is considering a four-year project to improve its production efficiency. Buying a new...
Geary Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $1,132,800 is estimated to result in $377,600 in annual pretax cost savings. The press falls in the MACRS five-year class (MACRS Table), and it will have a salvage value at the end of the project of $165,200. The press also requires an initial investment in spare parts inventory of $47,200, along with an additional $7,080 in inventory for each succeeding year...
Geller Machine Shop is considering a four-year project to improve its production efficiency. Buying a new...
Geller Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $480,000 is estimated to result in $195,000 in annual pretax cost savings. The press falls in the MACRS five-year class, and it will have a salvage value at the end of the project of $81,000. The press also requires an initial investment in spare parts inventory of $21,000, along with an additional $2,600 in inventory for each succeeding year of the...
Geary Machine Shop is considering a four-year project to improve its production efficiency. Buying a new...
Geary Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $950,400 is estimated to result in $316,800 in annual pretax cost savings. The press falls in the MACRS five-year class (MACRS Table), and it will have a salvage value at the end of the project of $138,600. The press also requires an initial investment in spare parts inventory of $39,600, along with an additional $5,940 in inventory for each succeeding year...
Geary Machine Shop is considering a four-year project to improve its production efficiency. Buying a new...
Geary Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $566,400 is estimated to result in $188,800 in annual pretax cost savings. The press falls in the MACRS five-year class (MACRS Table), and it will have a salvage value at the end of the project of $82,600. The press also requires an initial investment in spare parts inventory of $23,600, along with an additional $3,540 in inventory for each succeeding year...
CSM Machine Shop is considering a four-year project to improve its production efficiency. Buying a new...
CSM Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $423,000 is estimated to result in $158,000 in annual pretax cost savings. The press falls in the MACRS five-year class (MACRS Table) and it will have a salvage value at the end of the project of $59,000. The press also requires an initial investment in spare parts inventory of $16,400, along with an additional $3,400 in inventory for each succeeding year...
CSM Machine Shop is considering a four-year project to improve its production efficiency. Buying a new...
CSM Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $415,000 is estimated to result in $154,000 in annual pretax cost savings. The press falls in the MACRS five-year class (MACRS Table) and it will have a salvage value at the end of the project of $55,000. The press also requires an initial investment in spare parts inventory of $16,000, along with an additional $3,000 in inventory for each succeeding year...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT