Question

Problem 11-06 New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its...

Problem 11-06 New-Project Analysis

The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $1,010,000, and it would cost another $17,500 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after 3 years for $677,000. The machine would require an increase in net working capital (inventory) of $20,000. The sprayer would not change revenues, but it is expected to save the firm $378,000 per year in before-tax operating costs, mainly labor. Campbell's marginal tax rate is 30%.

  1. What is the Year 0 net cash flow? $_________
  2. What are the net operating cash flows in Years 1, 2, and 3? Do not round intermediate calculations. Round your answers to the nearest dollar.
    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)? Do not round intermediate calculations. Round your answer to the nearest dollar. $_________
  4. If the project's cost of capital is 10 %, what is the NPV of the project? Do not round intermediate calculations. Round your answer to the nearest dollar. $ ___________
    Should the machine be purchased? ________( Yes / No )
0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum 11.A. A.--- 9- ずWrap Text General Formatz チFormat Painter B l U. ㄧ˙ タ.Δ. -=- 還便困Merge & Center. $,%,,Ma conditional Format Cell Insert Delete Format Clipboard 2 ClearFe Select Edting Formattng as Table styies Number Cells VY CAMPBELL VX VZ WA WB WC WD WE WF WG 78 79 80 YEAR (1010000+17500) 0 -1027500 20000 2 COST OF ASSET WORKING CAPITAL SAVINGS IN COST DEPRECIATION INCOME BEFORE TAX TAX NET INCOME DEPRECIATION OPERATING CASH FLOW RECOVERY OF WORKING CAPITAL AFTER TAX SALVAGE VALUE OF ASSET NET CASH FLOW PV FACTOR AT 10% PV OF CFAT 82 83 84 85 86 378000.00 378000.00 378000.00 342465.75 456723.75 152172.75 35534.25 78723.75 225827.25 10660.28-23617.1367748.18 24873.98 55106.63 158079.08 342465.75 456723.75 152172.75 367339.73 401617.13 310251.83 20000.00 89 90 91l 92 93 94 95 96 (4 トト 1047500 496741.33 (SEE NOTE) (A-B) -1047500 367339.73 401617.13 826993.15 0.7513 0.9091 0.8264 1047500 333945.20 331914.98 621332.19239692.38 NPV NPV 239692.38 , MIRR NPV İRR REPLACEMENT S HPR GMAM EAC MACRS LEASE- RATIOCASHBUDGET / wacc BOND EPS EBIT , REPLACEMENT (STats | NPV . BETA LEVERED 9う - - rences: DX15 130% 26-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text ta copy. в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Paste Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard Alignment Number Cells Wo85 WH WI WI WK WL WM WN WO WP 78 79 NOTE 80 COST OF ASSET 81 DEPRECIATION 82 YEAR 83 84 85 86 87 88 NOTE 89 SALVAGE VALUE 90 BOOK VALUE 91 PROFIT ON SALE 92 TAX ON PROFIT 93 AFTER TAX SALVAGE VALUE 94 95 96 (4 トト 1027500 (1010000 + 17500) RATE 33.33% 44.45% 14.81% 7.41% DEPRECIATION BOOK VALUE 342465.75 685034.25 456723.75 228310.5 152172.75 76137.75 0 4 76137.75 677000A 76137.75 600862.25 180258.68 B 496741.33 A-B , MIRR NPV İRR REPLACEMENT S HPR GMAM EAC MACRS LEASE- RATIOCASHBUDGET / wacc , BOND EPS EBIT REPLACEMENT (STats | NPV . BETA LEVERED 9う - - rences: DX15 130% 26-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text General ta copy ▼ в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Paste Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard vz111 VY Font Alignment Number Styles Cells Formula Bar WA WB WC WD WF WG WH 97 98 100 101 102 103 104 105 106 107 108 109 110 YEAR O CASH FLOW YEAR 1 CASH FLOW YEAR 2 CASH FLOW YEAR 3 CASH FLOW 1047500 OPERATING CASH FLOW 367340 401617 310252 516741 20000 + 496741) ADDITIONAL CASH FLOW YEAR3 NPV 239692 YES, AS NPV IS POSITIVE, IT SHOULD BE PURCHASED 112 113 114 115 MIRR NPV IRR REPLACEMENTS HPR GMAM EAC MACRS LEASE RATIOCASHBUDGET acc BOND / EPS EBIT REPLACEMENT Tats NPV BETA LEVERED 。 rences: ED12 130% 02:37 26-01-2019

Add a comment
Know the answer?
Add Answer to:
Problem 11-06 New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Problem 11-06 New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its...

    Problem 11-06 New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $1,180,000, and it would cost another $24,000 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after 3 years for $670,000. The machine would require an increase in net working capital (inventory) of $13,000. The sprayer would not change...

  • Problem 11-06 New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its...

    Problem 11-06 New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $820,000, and it would cost another $23,000 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after 3 years for $635,000. The machine would require an increase in net working capital (inventory) of $9,500. The sprayer would not change...

  • Problem 11-06 New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its...

    Problem 11-06 New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $980,000, and it would cost another $19,000 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after 3 years for $508,000. The machine would require an increase in net working capital (inventory) of $10,000. The sprayer would not change...

  • Problem 11-06 New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production...

    Problem 11-06 New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $900,000, and it would cost another $18,500 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after 3 years for $591,000. The machine would require an increase in networking capital (inventory) of $18,500. The sprayer would not change revenues,...

  • Problem 11-06 New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its...

    Problem 11-06 New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $1,010,000, and it would cost another $17,500 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after 3 years for $677,000. The machine would require an increase in net working capital (inventory) of $20,000. The sprayer would not change...

  • New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production line....

    New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $930,000, and it would cost another $22,000 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after 3 years for $502,000. The machine would require an increase in net working capital (inventory) of $16,500. The sprayer would not change revenues, but...

  • New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production line....

    New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $810,000, and it would cost another $23,000 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after 3 years for $628,000. The machine would require an increase in net working capital (inventory) of $19,500. The sprayer would not change revenues, but...

  • The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's...

    The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $1,010,000, and it would cost another $21,000 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after 3 years for $641,000. The machine would require an increase in net working capital (inventory) of $18,500. The sprayer would not change revenues, but it is...

  • New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production line....

    New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $810,000, and it would cost another $23,000 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after 3 years for $628,000. The machine would require an increase in net working capital (inventory) of $19,500. The sprayer would not change revenues, but...

  • New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its pr...

    New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $1,130,000, and it would cost another $16,000 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after 3 years for $589,000. The machine would require an increase in net working capital (inventory) of $14,500. The sprayer would not change revenues, but...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT