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,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 expected to save the firm $425,000 per year in before-tax operating costs, mainly labor. Campbell's marginal tax rate is 30%. 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 15 %, what is the NPV of the project? Do not round intermediate calculations. Round your answer to the nearest dollar. $ Should the machine be purchased?

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 11.A. A.--- 9- ずWrap Text Σ AutoSum ー E ゴText General в 1 프· ー· 鱼, Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Formsat 2 ClearFe Select Edting Clipboard WB79 VY VZ WA WB WC 921 WE WF WG 79 80 81 82 83 84 85 86 87 YEAR (1070000 23500) 0 1093500 20000 NO CO DEI 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 15% PV OF CFAT 425000.00 425000.00 425000.00 364463.55 486060.75 161947.35 60536.45 -61060.75 263052.65 18160.94-18318.23 78915.80 42375.5242742.53 184136.86 364463.55 486060.75 161947.35 406839.07 443318.23 346084.21 20000.00 NO SAL 80 89 90 91 92 93 1113500 396708.51 (SEE NOTE) A-B) 1113500 406839.07 443318.23 762792.71 0.6575 TA AF 0.7561 1113500 353773.10 335212.27 5054859 77033.96 0.8696 95 96 97 NPV NPV 77033.96 . . HPR GMAM LEASE- , RATIOCASHBUDGET / wacc BOND EPS EBIT REPLACEMENT STats NPV BETA LEVERED 9う 福 (4 トト MIRR NPV IRR REPLACEMENT S EAC MACRS rences: DX15 130%Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text ta copy ▼ в 1 프· ー· 鱼, Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Formsat Paste Sort &Find & 2 ClearFe Select Edting Format Painter Formatting, as Table w styles. Styles ▼ ㆆ ▼ Clipboard Font Alignment Number Cells WG79 WG WH WI WJ WK WL WM WN WO 79 80 81 82 83 84 85 86 87 NOTE COST OF ASSET DEPRECIATION YEAR 1093500 (1070000 +23500) RATE DEPRECIATION BOOK VALU 33.33% 44.45% 14.81% 7.41% 364463.55 729036.45 486060.75 242975.7 161947.35 81028.35 0 4 81028.35 NOTE SALVAGE VALUE BOOK VALUE PROFIT ON SALE TAX ON PROFIT AFTER TAX SALVAGE VALUE 89 90 91 (A-B) 92 93 94 95 96 97 11 r MIRR NPV İRR , REPLACEMENT S HPR GMAM LEAC MACRS 532000 A 81028.35 450971.65 135291.50 B 396708.51 A-B RATIOCASHBUDGET / wacc . BOND . EPS EBIT , REPLACEMENT , STats | NPV . BETA LEVERED rences: DX15 福 130% 07:14Home nert Page Layout Formulas Data Review View dd-Ins Cut copy ▼ Format Painter Σ AutoSum ー E ゴWrap Text General в 1 프· ー· 鱼, Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Paste Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Clipboard WA111 vw Font Alignment Number Styles Cells Edting VX VY VZ WA WB WC WD WE WF 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 1113500 OPERATING CASH FLOW 406839 443318 346084 416709 (20000+396708.51)) ADDITIONAL CASH FLOW YEAR 3 NPV YES, AS NPV IS POSITIVE, IT SHOULD BE PURCHASED 77034 112 113 114 115 116 NOTI COST DEPR YEAR トト MIRR NPV İRR REPLACEMENT S HPR GMAM EAC MACRS LEASE . . RATIOCASHBUDGET / wacc BOND EPS EBIT , REPLACEMENT , STats | NPV . BETA LEVERED 9う - - rences: ED12 130% 07:15

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

  • 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
ADVERTISEMENT