Question

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 expected to save the firm $362,000 per year in before-tax operating costs, mainly labor. Campbell's marginal tax rate is 35%.

What is the Year 0 net cash flow?
$



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 $

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.
$

If the project's cost of capital is 13 %, 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 or 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

projects (Autosaved) (Autosaved) (Autosaved) Microsoft Excel Home Insert Page Layout Formls Data Review View Add-Ins Cut E AutoSum calibn . 11.A. A. B 1 U. -.10, ,A. ー E ゴText Wrap Text General Copy i-F,困Merge & Center. $, % , -28, conditional Format-Cell- Formatting, as Table w styles. Insert Delete Format 2 ClearFe Select Editing E ma ,inte, ▼ ㆆ ▼ Clipboard Number VY VZ WB WC ให้งา13 WE WF WG WH 78 CAMPBELL NOTE COST OF ASSET DEPRECIATION YEAR 80 YEAR COST OF ASSET WORKING CAPITAL 0 1031000 -18500 82 83 RATE 33.33% 44.45% 14.81% 7.41% SAVINGS IN LABOR 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 13% PV OF CFAT 362000.00 362000.00 362000.00 343632.30 458279.50 152691.10 18367.70 -96279.50 209308.90 6428.70 -33697.83 73258.12 11939.01 -62581.68136050.79 343632.30 458279.50 152691.10 86 4 89 90 91l 92 93 ANS1 94 NOTE SALVAGE VALUE BOOK VALUE PROFIT ON SALE TAX ON PROFIT AFTER TAX SALVAGE VALUE 1049500 355571.31 395697.83288741.89 18500.00 443388.99 (SEE NOTE) (A-B) 1049500 355571.31 395697.83 750630.87 0.6931 0.8850 0.7831 1049500 314664.87 309889.44 520224.85 95279.16 NPV 96 GMAM EAC MACRS LEASE RATIOS CASH BUDGETwacc BOND EPS EBIT REPLACEMENT bond senstvity Sheet? Sheet1 STats NPVBETA LEVERED rences: ED12 12:46

Add a comment
Know the answer?
Add Answer to:
The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's...
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
  • 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,070,000, and it would cost another $23,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 $532,000. The machine would require an increase in net working capital (inventory) of $20,000. The sprayer would not change revenues, but it is...

  • 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,170,000, and it would cost another $21,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 $579,000. The machine would require an increase in net working capital (inventory) of $10,500. The sprayer would not change revenues, but it is...

  • 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 $880,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 $522,000. The machine would require an increase in net working capital (inventory) of $8,500. The sprayer would not change revenues, but it is...

  • 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 $990,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 $542,000. The machine would require an increase in net working capital (inventory) of $19,000. The sprayer would not change revenues, but it is...

  • 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,200,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 $578,000. The machine would require an increase in net working capital (inventory) of $12,500. The sprayer would not change revenues, but it is...

  • 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 $990,000, and it would cost another $20,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 $623,000. The machine would require an increase in net working capital (inventory) of $15,500. The sprayer would not change revenues, but it is...

  • 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 $890,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 $662,000. The machine would require an increase in net working capital (inventory) of $15,000. The sprayer would not change revenues, but it is...

  • 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,030,000, and it would cost another $22,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 $631,000. The machine would require an increase in net working capital (inventory) of $20,000. 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 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...

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