Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


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

Finance

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.

  1. What is the Year-0 net cash flow?

    $  

  2. What are the net operating cash flows in Years 1, 2, and 3?

    Year 1: $  
    Year 2: $  
    Year 3: $  
  3. What is the additional Year-3 cash flow (i.e, the after-tax salvage and the return of working capital)?

    $  

  4. If the project's cost of capital is 13%, what is the NPV of the project?

    $  

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

  • 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