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 $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 revenues, but it is expected to save the firm $479,000 per year in before-tax operating costs, mainly labor. Campbell's marginal tax rate is 40%. 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 14 %, 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 E AutoSum 11.A. A. ー E ゴText 9-ずWrap Text General Sort &Find & チFormat Painter B l U. ーータ.Δ. -=- 還便困Merge & Center. $,%,,Ma conditional Format Cell Insert Delete Format Formatting as Table Styles2 Clear Clipboard Alignment Number Cells Editing VZ WA WB WC WD WE WF WG WH 78 79 80 81 COST OF ASSET 82 WORKING CAPITAL 83 SAVINGS IN COST 84 DEPRECIATION 85 INCOME BEFORE TAX 86 TAX 87 NET INCOME 88 DEPRECIATION 89 OPERATING CASH FLOW 90 RECOVERY OF WORKING CAPITAL 91 AFTER TAX SALVAGE VALUE OF ASSET 92 NET CASH FLOW 93 PV FACTOR AT 14% 94 PV OF CFAT 95 96 NPV (4 トト MIRR NPV IRR REPLACEMENTS-HPR GMAM ( EAC MACRS NOTE COST OF ASSE DEPRECIATI YEAR YEAR 3 (820000 23000) 843000 9500 479000.00 479000.00 479000.00 280971.90 374713.50 124848.30 198028.10 104286.50 354151.70 79211.24 41714.60141660.68 118816.86 6257190 212491.02 280971.90 374713.50 124848.30 -852500 399788.76 437285.40 337339.32 9500.00 4 NOTE SALVAGE VAL BOOK VALUE PROFIT ON SA TAX ON PROF AFTER TAX SA 405986.52 (SEE NOTE) (A-B) 852500 399788.76 437285.40 752825.84 0.8772 0.7695 0.6750 852500 350691.89 336476.92 508136.00 342804.81 NPV 342804.81 LEASE RATIOCASHBUDGET wacc- BOND EPS EBIT REPLACEMENT STat NPV BETA LEVERED ☆ rences: DX15 130% 03:12 31-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum Wrap Text ta copy. в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Paste Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard Font Alignment Number Cells Edting WP96 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 トト 843000 RATE 33.33% 44.45% 14.81% 7.41% DEPRECIATION BOOK VALUE 280971.90 562028.1 374713.50 187314.6 62466.3 0.00 124848.30 62466.30 4 635000A 62466.3 572533.7 229013.48 B 405986.52 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% 03:12 31-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum ー E ゴWrap Text General aCopy в 1 프· ー· 鱼, Δ. : 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 WF111 vw Font Alignment Number Styles Cells VX VY VZ WA WB WC WD WE WF 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 -852500 399789 437285 337339 415487 (9500 + 405986.52) OPERATING CASH FLOW ADDITIONAL CASH FLOW YEAR 3 NPV 342805 YES, AS NPV IS POSITIVE, IT SHOULD BE PURCHASED 112 113 114 115 116 トト MIRR NPV İRR REPLACEMENT S HPR GMAM EAC MACRS LEASE . . RATIOCASHBUDGET / wacc BOND EPS EBIT , REPLACEMENT , STats | NPV . BETA LEVERED 9う - - rences: ED12 130% 03:13 31-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 $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...

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

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

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

  • 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 $820,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 $636,000. The machine would require an increase in net working capital (inventory) of $12,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,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...

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