• Copy the Consolidated Statements of Income and the Consolidated Balance Sheets from the 10-Ks you downloaded in excel to new tabs in this Excel Workbook. Use linking formulas in Excel to calculate the following eight (8) ratios found in Exhibit 17.16, page 627 of your text, for the current year and previous year (2 years total).
  • Current Ratio
  • Total Asset Turnover
  • Debt Ratio
  • Equity Ratio
  • Profit Margin Ratio
  • Return on Total Assets
  • Price-Earnings Ratio
  • Inventory Turnover
• You are required to use Excel formulas to calculate the ratios. You will calculate 16 ratios for your company (8 ratios x 2 years).

Please use Excel and show formulas! Thank you!

February 28, 2018 90.3 7762 2,084.0 5235 3.4740 4,789.7 8.08.1 3,3048 121.5 6722 109.7 93.4 20,538.7 746.8 CONSTELLATION BRANDS, INC. AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS Inuillions, excepe share and per share data) February 28, 2019 ASSETS Current assets: Cash and cash equivalents s 93.6 s Accounts receivable 846.9 Inventories 2.130.4 Prepaid expenses and other 613.1 Total current assets 3,684.0 Property, plant and equipment 5,267.3 Goodwill 8,088.8 Intangible assets 3.198.1 Equity method investments 3,465.6 Securities measured at fair value 3,234.7 Deferred income taxes 2.183.3 Other assets Total assets s 29,231.5 5 LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Short-term borrowings s 791.5 S Current maturities of long-term debt 1,065.2 Accounts payable 616.7 Other accrued expenses and liabilities 690.4 Total current liabilities 3.163.8 Long-term debt, less current maturities 11,759.8 Deferred income taxes and other liabilities 1,470.7 Total liabilities 16,394.3 Commitments and contingencies (Note 15) CBI stockholders' equity: Preferred Stock, S.Ol par value - Authorized, 1,000,000 shares; Issued, none Class A Common Stock, S.01 par value - Authorized, 322,000,000 shares; Issued, 185,740,178 shares and 258.718,356 shares, respectively 1.9 Class B Convertible Common Stock, S.1 par value - Authorized, 30,000,000 shares; Issued, 28,322,419 shares and 28,335,387 shares, respectively 0.3 Class 1 Common Stock, S.Ol par value - Authorized 25,000,000 shares, Issued, 1,149,624 shares and 1,970 shares, respectively Additional paid-in capital 1.410.8 Retained earnings 14,276,2 Accumulated other comprehensive loss (353.9) 15,335,3 Less: Treasury stock Class A Common Stock, at cost, 18,927,966 shares and 90,743,239 shares, respectively (2.782.1) Class B Convertible Common Stock, at cost, 5,005,800 shares (2,784.3) 5922 6783 2,0196 9,417.6 1,089.8 12,547.0 03 2.8253 9,1572 (202.9) 11,782.5 (3,805_2) (2.2) (3.807.4) 3 of 221 10/13/2020, 11:1 http://www.sec.gov/Archives/edgar data/6918/0000016918190000 cument Total CBI stockholders' equity Noncontrolling interests Total stockholders' equity Total liabilities and stockholders' equity 12.551.0 286.2 12,837.2 29.231.5 s 7,975.1 16.6 7,991.7 20,538.7 S CONSTELLATION BRANDS, INC. 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 $ 8.322.1 S 8,051.2 Excise taxes (768.3) (741.8) (730.1) Net sales 8,116.0 7.5803 7,321.1 Cost of product sold (4,035.7) (3.767.8) (3.802.1) Gross profit 4,080.3 3.812.5 3.519.0 Selling, general and administrative expenses (1,668.1) (1.532.7) (1,392.4) Gain on sale of business 262.4 Operating income 2,412.2 2.279.8 2.389.0 Income from unconsolidated investments 2,101.6 487.2 27.3 Interest expense (367.1) (332.0) (333.3) Loss on extinguishment of debt (1.7) (97.0) Income before income taxes 4,145.0 2.338.0 2,083.0 Provision for income taxes (685.9) (22.7) (550.3) Net income 3,459.1 2.3153 1,532.7 Net income attributable to noncontrolling interests (23.2) (11.9) Net income attributable to CBI $ 3,435.9 $ 2.303.4 S 1,528.6 Net income per common share attributable to CBI: Basic - Class A Common Stock Basic - Class B Convertible Common Stock $ $ 18.24 $ 16.57 s 11.96 S 10.86 s 7.76 7.04 Diluted - Class A Common Stock Diluted-Class B Convertible Common Stock $ $ 17.57 $ 16.21 $ 11.47 S 10.59 $ 7.49 6.90 Weighted average common shares outstanding: Basic - Class A Common Stock Basic - Class B Convertible Common Stock 167.249 23.321 171.457 23.336 175.934 23.353 Diluted - Class A Common Stock Diluted-Class B Convertible Common Stock 195.532 23.321 200.745 23.336 204.099 23.353 $ $ 2.96 $ 2.68 $ 2.08 S 1.88 $ 1.60 1.44 $ 3.459.1 $ 2.3153 $ 1.532.7 Cash dividends declared per common share: Class A Common Stock Class B Convertible Common Stock Comprehensive income: Net income Other comprehensive income (los), net of income tax effect Foreign currency translation adjustments Unrealized gain 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 (1968) 11.4 2.5 0.5 29.6 153.8 SS.S (0.2) (1.1) 22.1 7.8 0.5 11.6 of 221 10/13/2020, 11:17 https://www.sec.gov/Archives/edgar/data/169 18/00000169181900002 ament Other comprehensive income (loss), net of income tax effect Comprehensive income Comprehensive (income) loss attributable to noncontrolling interests Comprehensive income attributable to CBI (152.8) 3.306.3 (21.4) 3.284.9 $ 208.0 2.5233 (23.0) 2.500.3 42.0 1,574.7 6.6 1.581.3 $ $ B - Consolidated Balance Sheets - USD ($) $ in Millions Feb. 29, 2020 Feb. 28, 2019 2 Current assets: 3 Cash and cash equivalents $ 81.4 $ 93.6 1 Accounts receivable 864.8 846.9 Inventories 1,373,6 2,130.4 5 Prepaid expenses and other 535.8 613.1 Assets held for sale - current 628.5 0 3 Total current assets 3,484.1 3,684 Property, plant, and equipment 5,333 5,267.3 ) Goodwill 7,757.1 8,088.8 1 Intangible assets 2,718.9 3,198.1 2 Equity method investments 3,093.9 3,465.6 3 Securities measured at fair value 1.117.1 3,234.7 # Deferred income taxes 2,656.3 2.183.3 5 Assets held for sale 552.1 0 5 Other assets 610.7 109.7 7 Total assets 27,323.2 29,231.5 8 Current liabilities: Short-term borrowings 238.9 791.5 o Current maturities of long-term debt 734.9 1,065.2 7 Accounts payable 557.6 616.7 2 Other accrued expenses and liabilities 780.4 690.4 3 Total current liabilities 2,311.8 3,163.8 4 Long-term debt, less current maturities 11,210.8 11,759.8 5 Deferred income taxes and other liabilities 1,326.3 1,470.7 6 Total liabilities 14,848.9 16,394.3 7 Commitments and contingencies 3 CBI stockholders' equity: 9 Preferred Stock, Value 0 0 o Additional paid-in capital 1,514.6 1,410.8 1 Retained earnings 13,695.3 14,276.2 2 Accumulated other comprehensive income (loss) (2663) (353.9) 3 Total stockholders' equity before treasury stock adjustments 14,945.8 15,335.3 4 Less: Treasury stock - (2,814) (2,784.3) 5 Total CBI stockholders' equity 12,131.8 12,551 6 Noncontrolling interests 342.5 286.2 7 Total stockholders' equity 12,474.3 12,837.2 8 Total liabilities and stockholders' equity 27,323.2 29,231.5 9 Class A Common Stock (Member) O CBI stockholders' equity: 1 Common Stock, Value 1.9 1.9 2. Less: Treasury stock - (2,811.8) (2.782.1) 3 Class B Convertible Common Stock (Member) 4 CBI stockholders' equity: 5 Common Stock, Value 0.3 0.3 6 Less: Treasury stock - (2.2) (22) 7 Class 1 Common Stock (Member) 3 CBI stockholders' equity: 9 Common Stock, Value $0 $0 0 B Feb. 29, 2020 $ 0.01 1,000,000 0 Feb. 28, 2019 $ 0.01 1,000,000 0 A 1 Consolidated Balance Sheets (Parenthetical) - $ / shares - Preferred Stock, par value Preferred Stock, shares authorized Preferred Stock, shares issued 6 Class A Common Stock [Member] 5 Common Stock, par value Common Stock, shares authorized 3 Common Stock, shares issued Treasury Stock, shares at cost 0 Class B Convertible Common Stock [Member] 1 Common Stock, par value 2 Common Stock, shares authorized 3. Common Stock, shares issued 4 Treasury Stock, shares at cost 5 Class 1 Common Stock [Member] 6 Common Stock, par value 7 Common Stock, shares authorized 8 Common Stock, shares issued $ 0.01 322,000,000 186,090,745 18,256,826 $ 0.01 322,000,000 185,740,178 18,927,966 $ 0.01 30,000,000 28,300,206 5,005,800 $ 0.01 30,000,000 28,322,419 5,005,800 $ 0.01 25,000,000 1,692,227 $ 0.01 25,000,000 1,149,624 12 Months Ended Feb. 29, 2020 Feb. 28, 2019 $ 9,113 $ 8,884.3 (769.5) (768.3) 8,343.5 8,116 (4,191.6) (4,035.7) 4,151.9 4,080.3 (1,621.8) (1,668.1) (449.7) 0 74.1 0 2,154.5 2,412.2 (2,668.6) 2,101.6 (428.7) (367.1) (2.4) (1.7) (945.2) 4,145 966.6 (685.9) 21.4 3,459.1 (33.2) (23.2) (11.8) 3,435.9 Feb. 28, 2018 $ 8,322.1 (741.8) 7,580.3 (3,767.8) 3,812.5 (1,532.7) 0 0 2,279.8 487.2 (332) (97) 2,338 (22.7) 2,315.3 (11.9) 2,303.4 Consolidated Statements of Income (Loss) - USD ($) shares in Thousands, $ in Millions Sales Excise taxes Net sales Cost of product sold Gross profit Selling, general, and administrative expenses Impairment of assets held for sale Gain (loss) on sale of business Operating income (loss) Income (loss) from unconsolidated investments Interest expense Loss on extinguishment of debt Income (loss) before income taxes (Provision for) benefit from income taxes Net income (loss) Net income (loss) attributable to noncontrolling interests Net income (loss) attributable to CBI Class A Common Stock [Member] Net income (loss) attributable to CBI Net income (loss) per common share attributable to CBI: Net income (loss) per common share attributable to CBI, basic (in dollars per share) Net income (loss) per common share attributable to CBI, diluted (in dollars per share) Weighted average number of shares outstanding: Weighted average common shares outstanding, basic Weighted average common shares outstanding, diluted Cash dividends declared per common share: Cash dividends declared per common share Class B Convertible Common Stock [Member] Net income (loss) attributable to CBI Net income (loss) per common share attributable to CBI: Net income (loss) per common share attributable to CBI, basic (in dollars per share) Net income (loss) per common share attributable to CBI, diluted (in dollars per share) Weighted average number of shares outstanding: Weighted average common shares outstanding, basic Weighted average common shares outstanding, diluted Cash dividends declared per common share: Cash dividends declared per common share $ (10.2) $ 3,049.5 $ 2,049.9 $ (0.07) $ (0.07) $ 18.24 $ 17.57 $ 11.96 $ 11.47 168,329 168,329 167,249 195,532 171,457 200,745 $ 3 $ 2.96 $ 2.08 $ (1.6) $ 386.4 $ 253.5 $ (0.07) $ (0.07) $ 16.57 $ 16.21 $ 10.86 $ 10.59 23,313 23,313 23,321 23,321 23,336 23,336 $ 2.72 $ 2.68 $ 1.88 February 28, 2018 90.3 7762 2,084.0 5235 3.4740 4,789.7 8.08.1 3,3048 121.5 6722 109.7 93.4 20,538.7 746.8 CONSTELLATION BRANDS, INC. AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS Inuillions, excepe share and per share data) February 28, 2019 ASSETS Current assets: Cash and cash equivalents s 93.6 s Accounts receivable 846.9 Inventories 2.130.4 Prepaid expenses and other 613.1 Total current assets 3,684.0 Property, plant and equipment 5,267.3 Goodwill 8,088.8 Intangible assets 3.198.1 Equity method investments 3,465.6 Securities measured at fair value 3,234.7 Deferred income taxes 2.183.3 Other assets Total assets s 29,231.5 5 LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Short-term borrowings s 791.5 S Current maturities of long-term debt 1,065.2 Accounts payable 616.7 Other accrued expenses and liabilities 690.4 Total current liabilities 3.163.8 Long-term debt, less current maturities 11,759.8 Deferred income taxes and other liabilities 1,470.7 Total liabilities 16,394.3 Commitments and contingencies (Note 15) CBI stockholders' equity: Preferred Stock, S.Ol par value - Authorized, 1,000,000 shares; Issued, none Class A Common Stock, S.01 par value - Authorized, 322,000,000 shares; Issued, 185,740,178 shares and 258.718,356 shares, respectively 1.9 Class B Convertible Common Stock, S.1 par value - Authorized, 30,000,000 shares; Issued, 28,322,419 shares and 28,335,387 shares, respectively 0.3 Class 1 Common Stock, S.Ol par value - Authorized 25,000,000 shares, Issued, 1,149,624 shares and 1,970 shares, respectively Additional paid-in capital 1.410.8 Retained earnings 14,276,2 Accumulated other comprehensive loss (353.9) 15,335,3 Less: Treasury stock Class A Common Stock, at cost, 18,927,966 shares and 90,743,239 shares, respectively (2.782.1) Class B Convertible Common Stock, at cost, 5,005,800 shares (2,784.3) 5922 6783 2,0196 9,417.6 1,089.8 12,547.0 03 2.8253 9,1572 (202.9) 11,782.5 (3,805_2) (2.2) (3.807.4) 3 of 221 10/13/2020, 11:1 http://www.sec.gov/Archives/edgar data/6918/0000016918190000 cument Total CBI stockholders' equity Noncontrolling interests Total stockholders' equity Total liabilities and stockholders' equity 12.551.0 286.2 12,837.2 29.231.5 s 7,975.1 16.6 7,991.7 20,538.7 S CONSTELLATION BRANDS, INC. 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 $ 8.322.1 S 8,051.2 Excise taxes (768.3) (741.8) (730.1) Net sales 8,116.0 7.5803 7,321.1 Cost of product sold (4,035.7) (3.767.8) (3.802.1) Gross profit 4,080.3 3.812.5 3.519.0 Selling, general and administrative expenses (1,668.1) (1.532.7) (1,392.4) Gain on sale of business 262.4 Operating income 2,412.2 2.279.8 2.389.0 Income from unconsolidated investments 2,101.6 487.2 27.3 Interest expense (367.1) (332.0) (333.3) Loss on extinguishment of debt (1.7) (97.0) Income before income taxes 4,145.0 2.338.0 2,083.0 Provision for income taxes (685.9) (22.7) (550.3) Net income 3,459.1 2.3153 1,532.7 Net income attributable to noncontrolling interests (23.2) (11.9) Net income attributable to CBI $ 3,435.9 $ 2.303.4 S 1,528.6 Net income per common share attributable to CBI: Basic - Class A Common Stock Basic - Class B Convertible Common Stock $ $ 18.24 $ 16.57 s 11.96 S 10.86 s 7.76 7.04 Diluted - Class A Common Stock Diluted-Class B Convertible Common Stock $ $ 17.57 $ 16.21 $ 11.47 S 10.59 $ 7.49 6.90 Weighted average common shares outstanding: Basic - Class A Common Stock Basic - Class B Convertible Common Stock 167.249 23.321 171.457 23.336 175.934 23.353 Diluted - Class A Common Stock Diluted-Class B Convertible Common Stock 195.532 23.321 200.745 23.336 204.099 23.353 $ $ 2.96 $ 2.68 $ 2.08 S 1.88 $ 1.60 1.44 $ 3.459.1 $ 2.3153 $ 1.532.7 Cash dividends declared per common share: Class A Common Stock Class B Convertible Common Stock Comprehensive income: Net income Other comprehensive income (los), net of income tax effect Foreign currency translation adjustments Unrealized gain 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 (1968) 11.4 2.5 0.5 29.6 153.8 SS.S (0.2) (1.1) 22.1 7.8 0.5 11.6 of 221 10/13/2020, 11:17 https://www.sec.gov/Archives/edgar/data/169 18/00000169181900002 ament Other comprehensive income (loss), net of income tax effect Comprehensive income Comprehensive (income) loss attributable to noncontrolling interests Comprehensive income attributable to CBI (152.8) 3.306.3 (21.4) 3.284.9 $ 208.0 2.5233 (23.0) 2.500.3 42.0 1,574.7 6.6 1.581.3 $ $ B - Consolidated Balance Sheets - USD ($) $ in Millions Feb. 29, 2020 Feb. 28, 2019 2 Current assets: 3 Cash and cash equivalents $ 81.4 $ 93.6 1 Accounts receivable 864.8 846.9 Inventories 1,373,6 2,130.4 5 Prepaid expenses and other 535.8 613.1 Assets held for sale - current 628.5 0 3 Total current assets 3,484.1 3,684 Property, plant, and equipment 5,333 5,267.3 ) Goodwill 7,757.1 8,088.8 1 Intangible assets 2,718.9 3,198.1 2 Equity method investments 3,093.9 3,465.6 3 Securities measured at fair value 1.117.1 3,234.7 # Deferred income taxes 2,656.3 2.183.3 5 Assets held for sale 552.1 0 5 Other assets 610.7 109.7 7 Total assets 27,323.2 29,231.5 8 Current liabilities: Short-term borrowings 238.9 791.5 o Current maturities of long-term debt 734.9 1,065.2 7 Accounts payable 557.6 616.7 2 Other accrued expenses and liabilities 780.4 690.4 3 Total current liabilities 2,311.8 3,163.8 4 Long-term debt, less current maturities 11,210.8 11,759.8 5 Deferred income taxes and other liabilities 1,326.3 1,470.7 6 Total liabilities 14,848.9 16,394.3 7 Commitments and contingencies 3 CBI stockholders' equity: 9 Preferred Stock, Value 0 0 o Additional paid-in capital 1,514.6 1,410.8 1 Retained earnings 13,695.3 14,276.2 2 Accumulated other comprehensive income (loss) (2663) (353.9) 3 Total stockholders' equity before treasury stock adjustments 14,945.8 15,335.3 4 Less: Treasury stock - (2,814) (2,784.3) 5 Total CBI stockholders' equity 12,131.8 12,551 6 Noncontrolling interests 342.5 286.2 7 Total stockholders' equity 12,474.3 12,837.2 8 Total liabilities and stockholders' equity 27,323.2 29,231.5 9 Class A Common Stock (Member) O CBI stockholders' equity: 1 Common Stock, Value 1.9 1.9 2. Less: Treasury stock - (2,811.8) (2.782.1) 3 Class B Convertible Common Stock (Member) 4 CBI stockholders' equity: 5 Common Stock, Value 0.3 0.3 6 Less: Treasury stock - (2.2) (22) 7 Class 1 Common Stock (Member) 3 CBI stockholders' equity: 9 Common Stock, Value $0 $0 0 B Feb. 29, 2020 $ 0.01 1,000,000 0 Feb. 28, 2019 $ 0.01 1,000,000 0 A 1 Consolidated Balance Sheets (Parenthetical) - $ / shares - Preferred Stock, par value Preferred Stock, shares authorized Preferred Stock, shares issued 6 Class A Common Stock [Member] 5 Common Stock, par value Common Stock, shares authorized 3 Common Stock, shares issued Treasury Stock, shares at cost 0 Class B Convertible Common Stock [Member] 1 Common Stock, par value 2 Common Stock, shares authorized 3. Common Stock, shares issued 4 Treasury Stock, shares at cost 5 Class 1 Common Stock [Member] 6 Common Stock, par value 7 Common Stock, shares authorized 8 Common Stock, shares issued $ 0.01 322,000,000 186,090,745 18,256,826 $ 0.01 322,000,000 185,740,178 18,927,966 $ 0.01 30,000,000 28,300,206 5,005,800 $ 0.01 30,000,000 28,322,419 5,005,800 $ 0.01 25,000,000 1,692,227 $ 0.01 25,000,000 1,149,624 12 Months Ended Feb. 29, 2020 Feb. 28, 2019 $ 9,113 $ 8,884.3 (769.5) (768.3) 8,343.5 8,116 (4,191.6) (4,035.7) 4,151.9 4,080.3 (1,621.8) (1,668.1) (449.7) 0 74.1 0 2,154.5 2,412.2 (2,668.6) 2,101.6 (428.7) (367.1) (2.4) (1.7) (945.2) 4,145 966.6 (685.9) 21.4 3,459.1 (33.2) (23.2) (11.8) 3,435.9 Feb. 28, 2018 $ 8,322.1 (741.8) 7,580.3 (3,767.8) 3,812.5 (1,532.7) 0 0 2,279.8 487.2 (332) (97) 2,338 (22.7) 2,315.3 (11.9) 2,303.4 Consolidated Statements of Income (Loss) - USD ($) shares in Thousands, $ in Millions Sales Excise taxes Net sales Cost of product sold Gross profit Selling, general, and administrative expenses Impairment of assets held for sale Gain (loss) on sale of business Operating income (loss) Income (loss) from unconsolidated investments Interest expense Loss on extinguishment of debt Income (loss) before income taxes (Provision for) benefit from income taxes Net income (loss) Net income (loss) attributable to noncontrolling interests Net income (loss) attributable to CBI Class A Common Stock [Member] Net income (loss) attributable to CBI Net income (loss) per common share attributable to CBI: Net income (loss) per common share attributable to CBI, basic (in dollars per share) Net income (loss) per common share attributable to CBI, diluted (in dollars per share) Weighted average number of shares outstanding: Weighted average common shares outstanding, basic Weighted average common shares outstanding, diluted Cash dividends declared per common share: Cash dividends declared per common share Class B Convertible Common Stock [Member] Net income (loss) attributable to CBI Net income (loss) per common share attributable to CBI: Net income (loss) per common share attributable to CBI, basic (in dollars per share) Net income (loss) per common share attributable to CBI, diluted (in dollars per share) Weighted average number of shares outstanding: Weighted average common shares outstanding, basic Weighted average common shares outstanding, diluted Cash dividends declared per common share: Cash dividends declared per common share $ (10.2) $ 3,049.5 $ 2,049.9 $ (0.07) $ (0.07) $ 18.24 $ 17.57 $ 11.96 $ 11.47 168,329 168,329 167,249 195,532 171,457 200,745 $ 3 $ 2.96 $ 2.08 $ (1.6) $ 386.4 $ 253.5 $ (0.07) $ (0.07) $ 16.57 $ 16.21 $ 10.86 $ 10.59 23,313 23,313 23,321 23,321 23,336 23,336 $ 2.72 $ 2.68 $ 1.88