Determine the following ratios(show calculation) for both Constellation Brands and Molson Coors utilizing the 2019 balance sheets and income statements (attached).
| Debt Ratio |
| Times Interest Earned |
| Gross Profit Margin |
| Operating Profit Margin |
| Net Profit Margin |
| Return on Total Assets |
| Return on Equity |
A summary of restricted Class A Common Stock activity under our Long-Term Stock Incentive Plan is as follows: Tebruary 28, 2019 Weighted Average Grant-Date Number Fair Value For the Years Ended February 28, 2018 Weighted Average Grant-Date Number Fair Value February 28, 2017 Weighted Average Grant-Date Number Fair Value Restricted Stock Awards Outstanding balance as of March 1. Norvested Granted Vested Outstanding balance as of last. day of February, Nonvested 3,848 $ 3.914 $ (3,818) $ 197.18 21 4.29 197.18 4,088 $ 3,848 $ (4,088) $ 166.34 197.18 166.31 4.984 $ 4.088 $ 119.37 166.34 11937 (1.981) S 3,914 $ 21 4.29 3,848 $ 197.18 4.088 $ 166.34 157.29 117.44 70.23 178.11 156.74 Restricted Stock Units Outstanding balance as of March I, Norvested Ciranted Vested Forfeited Outstanding balance as of last day of February, Nonvested 286,658 $ 108.545 % (39,717) $ (41.234) $ 226.97 129 57 455,699 $ 157,200 $ (299,182) S 27,059 $ 917,009 $ 174,187 $ (567.643) $ (67,854) $ 109.09 54.29 182.00 140.00 108.56 314,252 $ 181.62 286,658 $ 157.29 455.699 $ 117.44 (1) Performance Share Units Outstanding balance as of March 1, Nonnested 227,720 $ 1?7.90 250,333 $ 1:11.91 501,261 $ 92-11 Granted 172,468 $ 222.92 55,464 $ 236.79 75.765 $ 190.33 Performance achievement (281) $ 155.72 55.081 $ 99.85 105,330 $ 66.50 Vested (106,368) $ 147.34 (121,51 21 $ 100.73 (359,370) $ Forfeited (34,075) $ 215.63 (8.6461 S $ 144.57 (72.653) $ 144.26 Outstanding balance as of last day of February, Nouvested 259.4164 $ 213.27 227,720 $ 177.90 250,333 $ 1.11.91 Reflects the net monber of awards achieved above (below) target levels based on actual performance measured at the end of the performance period. The fair value of shares vested for our restricted Class A Common Stock awards is as follows: For the Years Ended February 28, February 28, February 28, 2019 2018 2017 S (in millions) Restricted stock awards Restricted stock units Performance share units S 0.8 $ 9.0 $ 24.4 $ 0.8 S 56.5 $ 21.4 $ 0.8 89.4 57.2 S 95 Parent Subsidiary Subsidiary Company CHuarantors Nongwarantors Eliminations Consolidated fin millions) Condensed Consolidating Balance Sheet at February 28, 2019 Current assets Cash and cash equivalents $ 11.0 $ 2.6 $ 80.0 $ S 93.6 Accounts receivable 435,6 370,6 40.7 846.9 Inventories 197.7 1,485.4 609.9 (1626) 2.130.4 Intercompany receivable 29,712.5 33,775.4 20.050.6 (83,538.5) Propuid excises and other 899 78.1 4-16.7 (1.6) 613.1 Total current assets 35,712.1 21.227.9 (83,702.?) 3.684.0 Property, plant and equipment 85.3 786.8 1,395.2 5,2673 Investments in subsidiaries 26,533.8 1,599.6 2.982.1 (31,115.5) Goodwill 6,185,5 1.903.3 8,0888 Intangible assets 605.0 2.593.1 3,198.1 Intercompany notes receivable 3,218.6 38.6 (3,257.27 Equity method investments 1.7 3.463.9 3.465.6 Securities measured as fair value 3.234.7 3,234.7 Deferred income taxes 69.2 2.183.3 (69.2) 2,1833 Other Assets 17.3 1.1 91.3 Total assets $ 60.370.9 $ 44,891.8 $ 42.113.4 $ 1118,144.61 S 29.231.5 30,446 ? 109.7 732.5 $ $ 59.0 $ S 12.2 0.2 415.8 791.5 1,065.2 616.7 18.322.0 1.56.6 18.953.6 (83,538.5) (24.5) (83,563.0) 690.4 Current liabilities: Short-term borrowings $ Current maturities of long-term debt Accounts payable Intercompaily payable Other accrued expenses and liabilities Total current liabilities Long-term debt, less current maturities Intercompany notes payable Deferred income taxes and other liabilities Total liabilities CBI stockholders' equity Noncontrolling interests Total stockhokters' equily Total liabilities and stockholders' equity $ 1,052.8 59.6 33,787,6 374.3 36,006.8 11,743.4 38.5 31.2 47.819.9 12,551.0 141.3 31,128.9 184.0 31,766.1 16.0 2,694.4 540.5 35,017.3 9,874.5 3.163.8 11,759.8 524.3 (3.257.21 955.9 (56.9) 20,434.2 (86,877.11 21.393.0 (31 267.5) 286.2 21.679.2 (31.267.5) 42.113.4 $ (118,144.6) S 1,470.7 16,394.3 12.551.0 286.2 12,837.2 29.231.5 12.551.0) 60.370.9 $ 9,874.5 44,891.8 $ 101 Parent Subsidiary Subsidiary Company Chuarantors Nongwarantors Eliminations Consolidated fin millions) Condensed Consolidating Statement of Comprehensive Income for the Year Ended February 28, 2019 Sales S 2,996.9 $ 7.323.1 S 3,905.8 S (5.341.5) S 8,8843 Excise taxes (3593) (3962) (12.8) (7683) Nel sales 2,6376 6.9269 3,893.0 (5,341.5) 8,116.0 Cost of product sold (2,060.3) (5,399.8) (1,924.2) 5,348,6 (4.035.?) Gross prolit 577.3 1,5271 1,9688 7.1 4,0803 Selling general and whicinistrative expenses (548.1) 1908.7) (2336) 22.3 (1,668.1) Operating income 29.2 618.4 1,735.2 29.4 2.412.2 Equity in carugs (losses) of equily method investees and subsidiaries and related activities 3,889.6 (394) 1829 (1.302.5) 30.6 Unrealized net gain on securities measured at fair value 1.971.2 1.971.2 Net gain on sale of unconsolidated vestment 90.8 99.8 Interest income 0.6 11.4 12.0 Intercompany interest income 259.7 (47.1 6.3 (913.1) Interest expenso (361.7) (1.0) ) (16.-1) (379.1) Intercompany interest expense (547.1) (1963) (169.?) 913.1 Loss on extinguisfuncit of debt Income before income taxes 3,268.6 1,028.8 4.120.7 (4,273.1) 4.145.0 (Provision for benefit from income xes 167.3 12502) (598.1) (1.9) (6859) Net income 3,435.9 278.6 3,5226 (4,278.0) 3.459.1 Vet income attributable to HIONICONTOllity inletest (232) (232) Net incone attributable to CBI S 3,435.9 $ 778.6 S 3.499.4 S (4.278.0) S 3.435.9 Comprehensive income attributable to CBI S 3,284.9 $ 77?? S 3.358.4 S (4,136.1) S 3.284.9 103 CONSTELLATION BRANDS, NC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (in millions, except per share data) For the Years Ended February 28, February 28, February 28, 2019 2018 2017 Sales $ 8.884.3 S 8,322.1 S 8,051.2 Excise taxes (741.8) (730.1) Net sales 8,116.0 7,580.3 7,321.1 Cost of product sold (4,035.7) 13,767.8) (3.802.1) Gross profit 4.080.3 3,812.5 3.519.0 Selling general and administrative expenses (1.608.1) (1,532.) (1.392.4) Gain on sale of business 262:1 Operating inconc 2,112.2 2,279.8 2,389 0 Income from unconsolidated investments 2.1016 487.2 27.3 Interest expense (367.1) (332.0)) (3333) Los on extinguistutent of debt (97,0) Income before income taxes 4,145.0 2,338,0 2,0830 Provision for income taxes (6859) (22.7) (5503) Net income 3,459.1 2,315.3 1,5323 Net income attributable to noncontrolling interests (23.2) (11.9) (4.1) Net income attributable to CBI $ 3.435 9S 2,303.4 S 1,528.6 Net income per common share attributable to CBI: Basic Class A Common Stock $ 18.24 S 11.96 S 7.76 Basic - Class B Convertible Common Stock $ 16.57 S 10.86 S 7.04 Diluled - Class A CULTILO1 Stock $ 17.57 S 11.47 S 7,49 Diluted - Class B Convertible Common Stock $ 16.21 S 10.59 $ 6.90 Weighted average common shares outstanding: Basic - Class A COMUTOL Stock 167.249 171.457 175.934 Basic - Class B Convertible Cannon Stock 23.321 23,336 23.353 Diluted - Class A ComIch Stock Diluted - Class B Convertible Common Stock 195.532 23.321 200.745 23.336 204.099 23.353 Cash dividends declared per Connon share: Class A Corunou Stock Class B Convertible Common Stock $ 2.96 S 2.68 S 2.08 S 1.88 1.60 1.44 . $ 3,459.1 S 2,315.3 S 1,532.7 Comprehensive income: Net income Other comprehensive income (loss), net of income tax effect: F'oreign currency translation adjustments Uncalized gaill on cash flow hedges Unrealized gain (loss) on available-for-sale debt securities Pension/postretirement adjustments Share of other comprehensive income of equity method investments Other comprehensive income (loss) niet of income tax elfect Comprehensive income Comprelusivc (conc) loss attributable to 11011Controlling interests Comprehensive income attributable to CBI 153.8 55.5 (0.2) (1.1) 22.1 7.8 0.5 11.6 (1986.8) 11.1 2.5 05 29.6 (152.8) 3,306,3 (211) 3.281.9 S 208.0 2.523.3 (23.0) 2,500.35 42.0 1,574.7 6.6 1.581.3 $ The accompanying notes are an integral part of these statements 57 MOLSON COORS BEVERAGE COMPANY AND SUBSIDIARIES CONDENSED CONSOLIDATING STATEMENT OF OPERATIONS (IN MILLIONS) Parent Issuer Eliminations (6215) 115.8 $ $ $ (6215) 4498 (1717) 1717 Cosalidated 13.009.1 (2.429.7) 10 579.4 (6.378.2) 4.2012 (2,7280) (7088) 115.8 (8.4) 107.4 (2440) (14.4) 593.4 4424 (2979) Subsidiary Guarantors 9.931.2 (1.356.5) 8,574.7 (5.0576) 3,5171 (1.004) (317.1) (444.8) 7603 262.1 (25.4) (47.5) 1892 949.5 s (3544) 595.1 Sales Excise taxes Net sales Cost of goods sold Gross profit Marketing general and administrative expenses Special items, net Equity income (Loss) in subsidiaries Operating income (loss) Interest income (expense), net Olker pension and postetutement benefits (costs), se! Other income (expense), nel Total other income (expense), net Income (los) before income taxes Income tax benefit (expense) Net income (loss) Net (come) loss attributable to cocontrolling interests Net income (loss) attributable to MCBC Comprehensive income (los) attributable to MCBC Year ended December 31, 2019 Subsidiary Nou Guarantors 3.583.6 (1.073.2) 2,510.4 (1.762.0) 748 4 (6608) (3773) (1991) (4888) (236) 28.3 33.3 (1753) (664.1) 23.0 (6411) (4.5) (645.6) (608.3) 50.5 505 7644 (0.5) (1984) 144.0 97.7 241.7 50.5 (2727) 2.9 (14.7) (2845) 479.9 (233.7) 2462 (4.5) 241.7 505 241.7 $ S S 50.5 S $ $ 595.1 6953 304.3 $ $ S (87.0) 304.3 MOLSON COORS BEVERAGE COMPANY AND SUBSIDIARIES CONDENSED CONSOLIDATING BALANCE SHEETS De sobre, 2017 Nos Subsidiary Elimination Consolidated 1196 so 388.15 - $5234 4491 1668 6159 14 190.0 3901 2.184.4 1920 2014 ** (340614 8.364) 31260.5 10.550.9 40 28.8598 874.6 2762 ese ed 18 3.6955 3.693.5 w cos 135.0 anss 151862 3419 253.7 3440 288598
