Foreign Exchange Rates (8 Points) 10. a.) Assume that Campbell generated 3% of its total revenue from Mexico in 2021 totaling $245.28 million when translated back to USD. Total revenue in Mexico is expected to increase by 3.25% from 2021 to 2022. The 2021 USS/MXN Peso exchange rate was 1 USD-23.45 MXN, and the MXN Peso is expected to depreciate against the USD by 2.5% in 2022. What is the amount of revenue in USD that Cambpell will recognize from Mexico in 2022? (5 points) b.) Assume the price of 2 liters of Coca-Cola in Denver, Colorado is $1.99 and in Mexico City it costs 45 pesos. The current foreign exchange rate is 1 USD = 25.30 MXN Pesos. Based on the purchasing power parity theory which currency may be overvalued? (3 points) G H Balance Sheet Balance Sheet as of Jul-30-2017 USD Reclassified Jul-29-2018 USD JU-28-2010 USD Aug-02-2020 USD Aug-01-2021 USD Currency ASSETS Cath And Equivalents Total Cash & ST Investments 3190 319,0 490 49.0 310 31.0 8500 859.0 690 69.0 Accounts Receivable Other Receivables Total Receivables 5500 550 6050 5100 530 563.0 5250 490 574.0 5300 50 575.0 5440 510 596.0 933.0 Inventory Other Curront Assets Tocal Current Assets 9020 740 1.90070 887.6 7970 22:30TO 8630 4990 1.70 8710 800 2,36510 1,69600 Gross Properly. Part & Equipment Accred Depreciation Net Property. Plant & Equipment 6,0430 (3.5090 2,454,0 5,2390 12.773.0) 2,466.0 5.2150 (2.7000) 2,455.0 5,339.0 (2.9170) 2,6220 5,7240 31190) 2.605.0 000 Long form investments Goodwin Omenangis Dobuted Tax Assets Other Long Term Assets 900 3,8640 3,0640 20 2.145 0 77.0 40170 3.4150 2 115 0 1.1180 30.0 340 3.986.0 3.350.0 3.9810 3.2390 12170 29.0 214.0 Income Statement Balance Sheet Cash Flow Workbook Statistics Give Feedba D E F G B 300 340 77260 C 20 2.1450 14.5290 12170 1600 200 1220 2140 110 1.0700 as todox 6 Other Long Term Assets 37 Total Assets 38 39 LIABILITIES 30 Accounts Payable 41 Es 2 Short om Borrowings 43 Cut Port of LTDA 44 Cut Port of Love 45 G Income Taxes Pays 46 Other Current 47 Total Current Liabilities 7050 4940 11360 390.0 5130 0060 4940 10360 220 10 200 1560 23960 J70 8140 5720 8500 5000 210 150 6130 TO 1.0400 6030 2780 9210 70.0 240 1300 370750 100 3000 3.594.0 650 SO 1240 18140 7.9010 7.1010 20 49 Long Term Date 50 Long Termo 51 Pension of Pool Pet Bents 52. Det by Non-Cum 53 Other Non Our Lisbes 54 Total Labs 55 56 Common Stock 57 Mon Pardin Capri 58 Refined Earrings y Sock 2.4920 70 5080 4000 180 B0810 3470 9000 2640 13,156,0 389.0 9240 2360 12.0360 49000 1880 4620 9140 1740 9.30STO + 120 0 3.1000 (102300 50020 1880 3410 1,0510 1640 8,680,0 120 3500 23850 (10000) 120 300 2 2240 (1.10300 120 3720 1.993,0 (10760 120 4140 3.12.0 1021.09 Income Statement Balance Sheet Cash Flow Workbook Statistics Lood G 70010 B 2,4020 7.0 5030 4900 1890 6.081.0 3470 980.0 2040 13,156,0 D 7,1010 20 3800 9240 2150 12,036,0 E 4,0000 1880 4020 9140 1740 9.803.0 F 50020 100.0 3410 10510 1840 8.580.0 Lungform DR Long termes 1 Person the Post-Retiro Benes 2 Out Tix Liability. Non Cut Other Non Content Liais 4 Total Liabetes 5 6 Comenon Stock Addon Padin Capital 8 Red Eamos 29 Yasury Stock Consive Inc. and Other 51 Total Common Equity 120 120 3580 2,3850 (1.066.00 (530) 1,6370 120 3490 2,2240 (5.1030) (1180) 1,364,0 120 3720 1,9930 (1.076.0) (1980) 1,103,0 3040 31000 (1.0230) (100) 2,583.0 120 4140 37429 (1.021 09 50 31520 80 80 80 20 1.6450 1,373.0 1.1120 2.569.0 3.154.0 7,7280 14,5290 13.148.0 12372.0 11.7340 53 Monty interest 54 55 Total Equity 56 57 Total Libes And Equity 58 59 Supplemental Items 70 Shwes Out on Balance Sheet Date 71 72 More Price of Stock 3010 3010 301.0 3020 3020 $1620 $3945 $4500 $52 61 541 73 E Income Statement H Roclassified 12 months Jul-30-2017 USD Reclassified 12 months Jul-29-2018 USD 12 months Jul-28-2019 USO 12 months Aug-02-2020 USD 12 months Aug-01-2021 USD 58370 0,015 0 81070 3,6010 8,4760 254 28 5,637,0 6,615.0 8.1076 8,691.0 8,476.0 33910 2440.0 4.1540 24010 5.3000 2.7110 5,600 3,008,0 5 6620 2,8140 For the Fiscal Period Ending 4 $ Currency 6 7 Revenue 8 Other Rover 19 Total Revenue 30 11 Cut Of Goods Sold 22 Gross Pro 23 4 Sling General & Admin Exp 25 RSDEN 26 Depreciation & Amort 27 Other Operating Expense (Income) 98 29 Other Operating Exp. Total 30 31 Operating Income 32 33 Interest Expense 34 interest and Inwest Income Net interest Ep. 10000 930 1.1770 910 13830 1,5190 120 1.300.0 340 (24009 (2110) 1230 1060 (2000 9430 1.057.0 1,594.0 1.717.0 1.2046 1,503.0 1.404.0 1.1170 1,291.0 1610.0 (1150) (1830) 30 (1800) (3660) 20 (354.00 (3450) 40 134709 Q100) 10 209701 (116.01 Income Statement Balance Sheet Cash Flow Winkhool Swiss Glycodick v Arial B A General F170.03 B G G H D 20 (3540) 30 (1800) 115.00 20 (3410) HU TO) (150) TO 201 (TO) 1,3730 12250 753.0 3460 14001 (480) (1210) 000) 530) 1202.00 (1070) (0 (100) (10) (490) (6409 (11 34 and Invest Income 35 Not interest Exp. 36 37 Currency Exchange Cans (L03 38 Other Non-Operating Inc (EX) 29 EBT Excl. Unusuales 40 41 Restructuring Changes 42 Merger & Rointed Restruct. Charges 43 norment of Goodwill 44 Caicoss) On Sale Of Invest 45 Can. On Sale Of Assets 46 Asset Widow Legal Solomon 48 Other Unusual ten 49 EBT Indl. Unusual terms 50 51 income Tax Expono 52 Earnings from Cont. Ops. 53 54 Eumngs of Oncontund Ops 55 Extraced tem Account Change 56 Net Income to Company 57 58 Minority in n Eatings (160) (540) (20 1,3760 8300 6250 TO 3920 9240 1060 724.0 1510 474,0 1740 5820 1210 1,000.0 (370) (4630) 26.01 100 50 3870 2010 2110 1,628,0 100276 - f =F170.03 B c D E F G H Other Non Operating Inc (EXD EBT Excl. Unusual items 9 1,373.0 1.225.0 763 0 948.0 1.400.0 (430) 2020 (1070) (1210) (090) 1530) (90) (100) (10) (490) 1640) (110) (540) 12209 (160) 1,316,0 83070 6250 7660 1 Rostructuring Charges 2 Morgor & Rod Restruct Charges 3 tent of Goodwil 14 Gan (Loss) On Sale Ofirst 35 Gan (LOS) On Sale Ot Assets 26 Asset Wrtodown 17 La Setments 38 Other Unusual 49 EBT Indl. Unusual Items 50 51 Income Tax Expenso 52 Earnings from Cont. Op 53 54 Engs of Descontod Ops 55 Extraordom Account Change 56 Net Income to Company 57 58 Minority in Earnings 39 Not Income 3920 9240 1060 7240 1510 474.0 1740 5820 3280 1.0080 (370) (2630) 100 160) 6876 2610 211.0 16280 1,0020 8870 2610 21110 1628.0 1,002.0 399 Income Statement Balance Sheet Foreign Exchange Rates (8 Points) 10. a.) Assume that Campbell generated 3% of its total revenue from Mexico in 2021 totaling $245.28 million when translated back to USD. Total revenue in Mexico is expected to increase by 3.25% from 2021 to 2022. The 2021 USS/MXN Peso exchange rate was 1 USD-23.45 MXN, and the MXN Peso is expected to depreciate against the USD by 2.5% in 2022. What is the amount of revenue in USD that Cambpell will recognize from Mexico in 2022? (5 points) b.) Assume the price of 2 liters of Coca-Cola in Denver, Colorado is $1.99 and in Mexico City it costs 45 pesos. The current foreign exchange rate is 1 USD = 25.30 MXN Pesos. Based on the purchasing power parity theory which currency may be overvalued? (3 points) G H Balance Sheet Balance Sheet as of Jul-30-2017 USD Reclassified Jul-29-2018 USD JU-28-2010 USD Aug-02-2020 USD Aug-01-2021 USD Currency ASSETS Cath And Equivalents Total Cash & ST Investments 3190 319,0 490 49.0 310 31.0 8500 859.0 690 69.0 Accounts Receivable Other Receivables Total Receivables 5500 550 6050 5100 530 563.0 5250 490 574.0 5300 50 575.0 5440 510 596.0 933.0 Inventory Other Curront Assets Tocal Current Assets 9020 740 1.90070 887.6 7970 22:30TO 8630 4990 1.70 8710 800 2,36510 1,69600 Gross Properly. Part & Equipment Accred Depreciation Net Property. Plant & Equipment 6,0430 (3.5090 2,454,0 5,2390 12.773.0) 2,466.0 5.2150 (2.7000) 2,455.0 5,339.0 (2.9170) 2,6220 5,7240 31190) 2.605.0 000 Long form investments Goodwin Omenangis Dobuted Tax Assets Other Long Term Assets 900 3,8640 3,0640 20 2.145 0 77.0 40170 3.4150 2 115 0 1.1180 30.0 340 3.986.0 3.350.0 3.9810 3.2390 12170 29.0 214.0 Income Statement Balance Sheet Cash Flow Workbook Statistics Give Feedba D E F G B 300 340 77260 C 20 2.1450 14.5290 12170 1600 200 1220 2140 110 1.0700 as todox 6 Other Long Term Assets 37 Total Assets 38 39 LIABILITIES 30 Accounts Payable 41 Es 2 Short om Borrowings 43 Cut Port of LTDA 44 Cut Port of Love 45 G Income Taxes Pays 46 Other Current 47 Total Current Liabilities 7050 4940 11360 390.0 5130 0060 4940 10360 220 10 200 1560 23960 J70 8140 5720 8500 5000 210 150 6130 TO 1.0400 6030 2780 9210 70.0 240 1300 370750 100 3000 3.594.0 650 SO 1240 18140 7.9010 7.1010 20 49 Long Term Date 50 Long Termo 51 Pension of Pool Pet Bents 52. Det by Non-Cum 53 Other Non Our Lisbes 54 Total Labs 55 56 Common Stock 57 Mon Pardin Capri 58 Refined Earrings y Sock 2.4920 70 5080 4000 180 B0810 3470 9000 2640 13,156,0 389.0 9240 2360 12.0360 49000 1880 4620 9140 1740 9.30STO + 120 0 3.1000 (102300 50020 1880 3410 1,0510 1640 8,680,0 120 3500 23850 (10000) 120 300 2 2240 (1.10300 120 3720 1.993,0 (10760 120 4140 3.12.0 1021.09 Income Statement Balance Sheet Cash Flow Workbook Statistics Lood G 70010 B 2,4020 7.0 5030 4900 1890 6.081.0 3470 980.0 2040 13,156,0 D 7,1010 20 3800 9240 2150 12,036,0 E 4,0000 1880 4020 9140 1740 9.803.0 F 50020 100.0 3410 10510 1840 8.580.0 Lungform DR Long termes 1 Person the Post-Retiro Benes 2 Out Tix Liability. Non Cut Other Non Content Liais 4 Total Liabetes 5 6 Comenon Stock Addon Padin Capital 8 Red Eamos 29 Yasury Stock Consive Inc. and Other 51 Total Common Equity 120 120 3580 2,3850 (1.066.00 (530) 1,6370 120 3490 2,2240 (5.1030) (1180) 1,364,0 120 3720 1,9930 (1.076.0) (1980) 1,103,0 3040 31000 (1.0230) (100) 2,583.0 120 4140 37429 (1.021 09 50 31520 80 80 80 20 1.6450 1,373.0 1.1120 2.569.0 3.154.0 7,7280 14,5290 13.148.0 12372.0 11.7340 53 Monty interest 54 55 Total Equity 56 57 Total Libes And Equity 58 59 Supplemental Items 70 Shwes Out on Balance Sheet Date 71 72 More Price of Stock 3010 3010 301.0 3020 3020 $1620 $3945 $4500 $52 61 541 73 E Income Statement H Roclassified 12 months Jul-30-2017 USD Reclassified 12 months Jul-29-2018 USD 12 months Jul-28-2019 USO 12 months Aug-02-2020 USD 12 months Aug-01-2021 USD 58370 0,015 0 81070 3,6010 8,4760 254 28 5,637,0 6,615.0 8.1076 8,691.0 8,476.0 33910 2440.0 4.1540 24010 5.3000 2.7110 5,600 3,008,0 5 6620 2,8140 For the Fiscal Period Ending 4 $ Currency 6 7 Revenue 8 Other Rover 19 Total Revenue 30 11 Cut Of Goods Sold 22 Gross Pro 23 4 Sling General & Admin Exp 25 RSDEN 26 Depreciation & Amort 27 Other Operating Expense (Income) 98 29 Other Operating Exp. Total 30 31 Operating Income 32 33 Interest Expense 34 interest and Inwest Income Net interest Ep. 10000 930 1.1770 910 13830 1,5190 120 1.300.0 340 (24009 (2110) 1230 1060 (2000 9430 1.057.0 1,594.0 1.717.0 1.2046 1,503.0 1.404.0 1.1170 1,291.0 1610.0 (1150) (1830) 30 (1800) (3660) 20 (354.00 (3450) 40 134709 Q100) 10 209701 (116.01 Income Statement Balance Sheet Cash Flow Winkhool Swiss Glycodick v Arial B A General F170.03 B G G H D 20 (3540) 30 (1800) 115.00 20 (3410) HU TO) (150) TO 201 (TO) 1,3730 12250 753.0 3460 14001 (480) (1210) 000) 530) 1202.00 (1070) (0 (100) (10) (490) (6409 (11 34 and Invest Income 35 Not interest Exp. 36 37 Currency Exchange Cans (L03 38 Other Non-Operating Inc (EX) 29 EBT Excl. Unusuales 40 41 Restructuring Changes 42 Merger & Rointed Restruct. Charges 43 norment of Goodwill 44 Caicoss) On Sale Of Invest 45 Can. On Sale Of Assets 46 Asset Widow Legal Solomon 48 Other Unusual ten 49 EBT Indl. Unusual terms 50 51 income Tax Expono 52 Earnings from Cont. Ops. 53 54 Eumngs of Oncontund Ops 55 Extraced tem Account Change 56 Net Income to Company 57 58 Minority in n Eatings (160) (540) (20 1,3760 8300 6250 TO 3920 9240 1060 724.0 1510 474,0 1740 5820 1210 1,000.0 (370) (4630) 26.01 100 50 3870 2010 2110 1,628,0 100276 - f =F170.03 B c D E F G H Other Non Operating Inc (EXD EBT Excl. Unusual items 9 1,373.0 1.225.0 763 0 948.0 1.400.0 (430) 2020 (1070) (1210) (090) 1530) (90) (100) (10) (490) 1640) (110) (540) 12209 (160) 1,316,0 83070 6250 7660 1 Rostructuring Charges 2 Morgor & Rod Restruct Charges 3 tent of Goodwil 14 Gan (Loss) On Sale Ofirst 35 Gan (LOS) On Sale Ot Assets 26 Asset Wrtodown 17 La Setments 38 Other Unusual 49 EBT Indl. Unusual Items 50 51 Income Tax Expenso 52 Earnings from Cont. Op 53 54 Engs of Descontod Ops 55 Extraordom Account Change 56 Net Income to Company 57 58 Minority in Earnings 39 Not Income 3920 9240 1060 7240 1510 474.0 1740 5820 3280 1.0080 (370) (2630) 100 160) 6876 2610 211.0 16280 1,0020 8870 2610 21110 1628.0 1,002.0 399 Income Statement Balance Sheet