Fill This Form To Receive Instant Help
Homework answers / question archive / The Campbell Company is considering adding a robotic paint sprayer to its production line
The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $800,000, and it would cost another $23,000 to install it. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $526,000. The MACRS rates for the first three years are 0.3333, 0.4445, and 0.1481. The machine would require an increase in net working capital (inventory) of $14,000. The sprayer would not change revenues, but it is expected to save the firm $362,000 per year in before-tax operating costs, mainly labor. Campbell's marginal tax rate is 25%. (Ignore the half-year convention for the straight-line method.) Cash outflows, 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?
Year 1: | $ |
Year 2: | $ |
Year 3: | $ |
What is the additional Year-3 cash flow (i.e, the after-tax salvage and the return of working capital)?
$
If the project's cost of capital is 13%, what is the NPV of the project?
$
Answer : Calculation of Operating Cash Flow :
(a.) Calculation of Year-0 net cash flow :
Cash Flow in Year 0 = Base Price + Installation Cost + Increase in Net working Capital
= 800000 + 23000 + 14000
= - 837000
(b.) Calculation of Cash Flow :
Year 1 :340076
Year 2 : 362956
Year 3 :301972
(c.) Additional Cash Flow :423746
(d.) NPV :251159
Below is the table showing Calculation of NPV :
Year 0 | Year 1 | Year 2 | Year 3 | |
Initial Investment (800000+23000) | -823000 | |||
Before tax Operating Cost saving | 362000 | 362000 | 362000 | |
Less : Depreciation (Working Note) | 274305.90 | 365823.50 | 121886.30 | |
Earning before taxes | 87694.10 | -3823.50 | 240113.70 | |
Taxes @ 25% | 21923.53 | -955.875 | 60028.425 | |
Net Income | 65770.58 | -2867.625 | 180085.28 | |
Add : Depreciation | 274305.9 | 365823.5 | 121886.3 | |
Add: Salvage Value | 526000 | |||
Less : Tax on Sale | 116253.93 | |||
Net Working Capital | -14000 | |||
Recapture of Net Working Capital | 14000 | |||
Free Cash Flows | -837000 | 340076.48 | 362955.88 | 725717.65 |
PV Factor @ 10% | 1 | 0.884956 | 0.783147 | 0.6930502 |
PV of Net Cash flows (Inflow) | 300952.6 | 284247.7 | 502958.74 | |
PV of Net Cash flows (Outflow) | -837000 | |||
The net present value (NPV) of this project is | = $ 251159 | |||
NPV = PV of cash inflow - PV of cash outflow | ||||
= 1088159.058- 837000 | ||||
= $ 251159 | ||||
Working Note : | ||||
Calculation of Depreciation | ||||
Year 1 = 823000 * 0.3333 = 274305.9 | ||||
Year 2 = 823000 * 0.4445 = 365823.5 | ||||
Year 3 = 823000 * 0.1481 = 121886.3 | ||||
Book Value at the end of year 3 = 823000 - 274305.9 - 365823.5 - 121886.3 = 60984.3 | ||||
Gain on Sale = 526000 - 60984.3 = 465015.7 | ||||
Tax on Gain on sale = 465015.7 * 25% = 116253.925 |