Cash Flow Estimation (6 points) 9. Campbell pays a consultant $85,000 to assess whether it should open a new plant that would sell unique soups from around the world and that would invite visitors and make it a tourist destination. The new plant is estimated to cost $95 million. Campbell would open the new plant in a parcel of land that it currently owns and could sell it for $5 million. Campbell estimates sales would increase sales by $1.0 million per year from merchandise, but it would lose $275,000 per year on other soup products. The new plant is expected to generate cash inflows of $6.5 million in perpetuity. If Campbell has a WACC or discount rate of 7.25%, should it build the new plant? D 13 Cash Flow Rostated 12 months 30-2017 USD Restated 12 months -29-2018 USD Rostated 12 month 28-2019 USO Rastated 12 months Aug-02-2020 USO 12 month Aug-01-2001 USO 887.0 1990 10 19370 2610 2500 200 2/070 211.0 3150 480 3630 1.628.0 250 430 3280 1.0020 2750 420 3170 For the Fiscal Period Ending 14 15 Currency 16 17 Net Income 18 Depreciation & Amort 19 Anor of Goodwill and intangibles 20 Depreciation & Amort. Total 21 22 m) Loss From Sale Of Assets 23 anoss On Sain oftest 24 Ace Widow & Restructuring Costs 25 Stock Bosed Compensation 26 Net Cash From Descontinued Ops 27 Other Opening Activities 28 Change MACC Rocolate 29 Change in inventos 30. Change in Ace Payable 31 Charon in Other Not Operating Assets 32 Cash from Ops 33 Capital Expenditure 110 (97509 90 00 610 210 130 600 2800 (2000) 200 460 (480) (270) 1,236,0 100 1160 010 9140 GOOD SO (840) 780 220 14100 120 10 470 580 3120 710 (110) 380 1250 (10) 1,250.0 2040 (30.09 (2009 9101 2009 (170 (1540) T2 1050 1980 (3380) (1070) 2990 G750) Income Statement Balance Sheet Cash Flow General - B C D E F H YO MO 4470 310 100 0. (110 2.50 200 7500 20 TO 000 13600 11901 CADO 1530 1630 40 2220 35 Cash Abons 3D 17 Maret 38 Dec nad 39 Othering A Cash hom Investing 41 12 Short Oublied Largumented To obtid 45 Sot mbled 46 Column Bed 47 Total Debt cold 49 of Canon 50 of me TO 1200 2470 2110 0,4580 000 400 1020 2240 TO 5. 102 102 OY 10000 BUTO 2.000 200 TOT con DO 150169 20 20 100 52 Cmon Dividends 31 Total Odenda Paid 420 21 2300 TO 14230 Sound 56 Other Activities 0 1 120 ST Balance Sheet Cash Flow Income Statement Woo Stics what you want to do View An General ov 11 A G 4200 4.2009 C 14200 1828.00 30 14230 E 200 Condensad 53 Total Dividends Pald 54 Spaniend pid 36 Other Activiti Cash from Francing 40 300 30 (0) 1970 SZO (10 11.10 (120 (20876 . on Exchange Net Change in Cash to 17000 IXO SO 120 10) 20 61 63 65 66 39 70 Income Statement Balance Sheet Cash Flow B H Balance Sheet Balance Sheets of Jul-30-2017 USD Reclassified Jul-29-2018 USO Jul-28-2019 USD Aug-02-2020 USD Aug-01-2021 USD 5 Currency 6 ASSETS 7 Cash And Eques Total Cash & ST Investments 9 0 Accounts Receive 1 Other Recovables Total Receivable 3190 31970 400 49.0 310 310 41600 8890 DO 590 5500 550 605,0 5100 830 583.0 5250 490 5740 5300 450 540 510 595.0 5750 9020 740 1,900.0 3870 7970 232900 BO 490.0 1.070 8710 000 2,386,0 900 1,6950 -4 for 5 Other Cont Assets Total Current Assets 17 8 Cros Property. Pan & Em Aboumated Depronton ONet Property. Plant & Equipment 11 2 Long Investments Good Other butario 5 Ofeled Tax AL 60330 13,580.00 2,454.0 $200 02.173.0 2,466.0 52150 12.7500) 2.456,0 015390 2.917.03 2,6220 5.7240 15,1190) 2005.0 090 2,1150 1.1180 380 920 38640 30640 20 - 770 40170 34150 379860 3.3500 10 32390 Income Statement Balance Sheet Cash Flow wixxtatistic NI View Automate Help me what you to do 46 Viewing 30. 2 LL . 000 F SO TO 40170 . 34 2100 20 20 ORD LIABILITIES do te TRO 7850 03 0140 Cat TO ON DELE 0226 000 OTO 5010 3000 IC SO OLDE DH TO 200 100 22360 100 Tube DORT 700 24 100 | 0 Ora 91 Foto 7. 2020 PO SO 0.000 51 20 020 00 Dette Or 00 10 ORI DHE 000 5 30 12200 1748 6.00 LEGO 120 DEL 00 Income Statement Balance Sheet Cash Flow E Green Milch mus Date Review View Automate Halo VE 8 A Viewing ty - C D E 00 100 500 20 D 2016 10 YO IMO RO 1200 Boto 51 SOFT Det Non- Omer Non-Curent 58 Total List 55 56 Contoh 57 Addino 58 RE 59 Tesy stock Coron and me 61 Total Common Ely 130 120 Won 7100 ( 120 3400 20 07.300 14100 13840 120 D 3.00 ( NO 00 1.00 Conan 50 1657 20 0 00 00 1.5450 1:57 1.12 2.300 14 54 55 Total Equity 66 OT Total inbitties And quity 60 69 Supplemental 70 Total Shoe Shoot 7.2210 MA 12.3720 IMMO 2010 100 1010 20 4 3450 54 72 Photo 73 74 25 Income Statement Balance Sheet Cash Flow D 12 Income Statement G Reclassified 12 months Jul-30-2017 Reclassified 12 months Jul-20-2018 USD 12 months Jul-25-2019 USO USD 12 months Aug-02-2020 USD 12 months Aug-01-2021 USO 5.8370 6,6150 8.1070 010 1146 5.8370 66150 For the Fiscal Period Ending 14 15 Currency 16 17 Rover 10 Other Revine 19 Total Revenue 20 21 Cost of Goods Sold Gross Profit 23 24 Seng General Admin Exp 25 RSD Exp 26 Depreciation & Amon 27 Other Operating Expenso Income 8,107.0 690 3.4700 33010 274460 41540 2461.0 500 2.711.0 6.000 STOOD. 56020 25140 10900 030 13830 1.1770 090 1.500 13800 12400 (2110) 1230 1000 960) 54570 1.057.0 1.5940 1,7170 12040 1,503.0 29 Other Operating Exp. Total 30 31 Operating Income 32 33 Interest Expense 34 Interest and invest income 1.404,0 1.1170 1.291.0 1.6100 (1150) (1890) 10 60 20 (3450) 40 10 Income Statement Balance Sheet Cash Flow CH F17*0,03 A 3 c 29 Other Operating p. 1 F D 1,54 WU G 7,070 E 1.To 120 1,503 0 1.404.0 1.1170 1.2010 1.8100 (115.09 (10 30 1700 31 Operating income 32 restente 24 West and let income 35 Net interest Exp 36 32 Currency Exchange Garn 38 Other Non Operating in Emm) 39 EBT Excl. Unusuallars 116.0) 20 (5640) 40 (329.00 1200701 (150) 10 20 (10 70370 9480 ADO 00001 (1070 (12109 000 100 10 (430 140 016 41 Asturing Charges 42 Mt Related Posts Changes 43 men of Good 44 on Sale 45 Ganoon sale or 46 Ave Widow 47 Low settle 40 Other Unus 49 EBT Inc. Unuturs 50 51 Income Tax Expert 52 Earnings from Cont Ope 53 1560 (220 1.37.00 300 6250 12 1140 3820 240 TODO 724.0 1510 4740 380 7.000 Income Statement Balance Sheet Cash Flow Al BAG Tell me what you want to do Viewing TO F170.03 B D H 13360 45 Other in 39 EBT Ind. Uns 50 51 Inco por Earnings from Cant. Op 330 3120 9540 100 7240 1510 4740 1140 520 300 1000 GY 54 East Oncomodos 55 Don Bom Account Che 16 Nelcome Company 12616 TOO 07 2010 2110 10 1870 2113 58 Menit Netcom 60 61 62 64 88899 69 70 73 Income Statement Balance Sheet Cash Flow