Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

Can you Provide common-size analysis of your company's income statement and balance sheet for the 2 most recent years (must be done using Excel with

image text in transcribed

Can you Provide common-size analysis of your company's income statement and balance sheet for the 2 most recent years (must be done using Excel with formulas).

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
DARDEN RESTAURANTS, INC. CONSOLIDATED STATEMENTS OF EARNINGS (In millions, except per share data) Sales Costs and expenses: Food and beverage Restaurant labor Restaurant expenses Marketing expenses General and administrative expenses Depreciation and amortization Impairments and disposal of assets, net Goodwill impairment Total operating costs and expenses Operating income Interest, net Other (income) expense, net Earnings (loss) before income taxes Income tax expense (benet) Earnings (loss) from continuing operations Losses from discontinued operations, net of tax benet of $0.9, $1.8 and $4.8, respectively Net earnings (loss) Basic net earnings per share: Earnings (loss) from continuing operations Losses from discontinued operations Net earnings (105s) Diluted net earnings per share: Earnings (loss) from continuing operations Losses from discontinued operations Net earnings (105s) Average number of common shares outstanding: Basic Diluted May 31, 2020 $ $ $ 7,806.9 2,240.8 2,682.6 1,475.1 238.0 376.4 355.9 221.0 169.2 7,759.0 47.9 57.3 151.6 (161.0) (111.8) (49.2) (3.2) (52.4) (0.40) (0.03) (0.43) (0.40) (0.03) (0.43) 122.7 122.7 Fiscal Year Ended May 26, 2019 May 27, 2018 $ 8,510.4 $ 8,080.1 2,412.5 2,771.1 1,477.8 255.3 405.5 336.7 19.0 $ 7,677.9 832.5 50.2 782.3 63.7 $ 718.6 (5.2) $ 713.4 :5 5.82 (0.04) $ 5.78 $ 5.73 (0.04) $ 5.69 123.5 125.4 2,303.1 2,614.5 1,417.1 252.3 409.8 313.1 3.4 s 7,313.3 766.8 161.1 605.7 1.9 $ 603.8 (7.8) $ 596.0 $ 4.87 (0.06) $ 4.81 $ 4.79 (0.06) $ 4.73 124.0 126.0 DARDEN RESTAURANTS, INC. CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (In millions) Net earnings Other comprehensive income (loss): Foreign currency adjustment Change in fair value of marketable securities, net of taxes of $0.0, $0.0 and $0.0, respectively Change in fair value of derivatives and amortization of unrecognized gains and losses on derivatives, net of taxes of $(0.3), $(0.1) and $0.0, respectively Net unamortized gain (loss) arising during period, including amortization of unrecognized net actuarial loss, net of taxes of $30.8, $05.4) and $(0.7), respectively Reclassication of tax effect Other comprehensive income (loss) Total comprehensive income See accompanying notes to consolidated nancial statements. (17.6) 92.7 80.6 $ 28.2 $ Fiscal Year Ended May 31, 2020 May 26, 2019 (52.4) s May 27, 2013 713.4 s 596.0 0.6 (0.9) (9'1) 5.6 (4.6) (19.2) (1.1) (15.6) (13.0) $ (22.3) 700.4 s 573.7 DARDEN RESTAURANTS, INC. CONSOLIDATED BALANCE SHEETS (In millions) ASSETS Current assets: Cash and cash equivalents Receivables, net Inventories Prepaid income taxes Prepaid expenses and other current assets Total current assets Land, buildings and equipment, net Operating lease right-of-use assets Goodwill Trademarks Other assets Total assets LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Accounts payable Short-term debt Accrued payroll Accrued income taxes Other accrued taxes Unearned revenues Other current liabilities Total current liabilities Long-term debt Deferred income taxes Operating lease liabilities - non-current Deferred rent Other liabilities Total liabilities Stockholders' equity: Common stock and surplus, no par value. Authorized 500.0 shares; issued 129.9 and 123.1 shares, respectively; outstanding 129.9 and 123.1 shares, respectively Preferred stock, no par value. Authorized 25.0 shares; none issued and outstanding Retained earnings Accumulated other comprehensive income (loss) Unearned compensation Total stockholders' equity Total liabilities and stockholders' equity See accompanying notes to consolidated nancial statements. May 31, 2020 May 26, 2019 $ $ 763.3 s 49.8 206.9 18.4 63.0 1,101.4 $ 2,756.9 3,969.2 1,037.4 805.9 275.3 9,946.1 s 249.4 s 270.0 150.0 6.2 43.4 467.9 605.9 1,792.8 $ 928.8 56.1 4,276.3 560.9 7,614.9 5 2,205.3 143.5 (17.6) 2,331.2 s 9,946.1 s 457.3 88.3 207.3 41 .6 98.1 892.6 2,552.6 1,183.7 950.8 313.1 5,892.8 332.6 175.3 11.6 54.2 428.5 471.9 1,474.1 927.7 156.9 354.4 587.1 3,500.2 1,685.0 806.6 (98.2) (0.8) 2,392.6 5,892.8 Balances at May 28, 2017 Net earnings Other comprehensive income Dividends declared ($2.52 per share) Stock option exercises (0.8 shares) Stock-based compensation Repurchases ofcommon stock (2.8 shares) Issuance of stock under Emp loyee Stock Purchase Plan and other plans (0.1 shares} Other Balances at May 2?, 2018 Net earnings Other comprehensive income Dividends declared (S3.00 per share) Stock option exercises (1.2 shares) Stock-based compensation Repurchases of common stock (1.9 shares) Issuance of stock under Employee Stock Purchase Plan and other plans (0.1 shares} Other Balances at May 26, 2019 Net earnings Other comprehensive income Dividends declared ($2.64 per share) Stock option exercises (0.3 shares) Stock-based compensation Repurchases of common stock (2.9 shares) Issuance of stock under Employee Stock Purchase Plan and other plans (0.1 shares} Stock issuance - Public Offering (9.0 shares) Other Balances at May 31, 2020 DARDEN RESTAURANTS, INC. CONSOLIDATED STATEMENTS OF CHANGES IN STOCKHOLDERS'EQUITY (In millions, except per share data) Common Stock And Surplus S 1,614.6 S 32.0 22.7 (36.0) 5.7 (7-1} 3 1,631.9 s 52.2 26.8 (26.2) 7.1 (6.3) s 1,685.0 s 12.4 33.4 (40.9) 8.4 505.1 1.9 s 2,205.3 $ See accompanying notes to consolidated nancial statements. Retained Earnings 560.] $ 596.0 (315.3) (193.8) 15.6 657.6 $ 713.4 (373.5) (131.3) (9.6) 306.6 s (52.4) (325.1) (289.4) 3.3 143.5 :8 Treasury Stock (7.8) S S Accumulated Other Comprehensive Income (Loss) (62.9) S (22.3) (35.2) 3 (13.0) (98.2) S 80.6 Unearned Compensation (2.3) 3 0.1 0.5 (1.7) s 0.8 0.1 (0.8) $ $ Total Stockholders' Equity 2,101.7 596.0 (22.3) (3 15.3) 32.0 22.7 (234.8) 5.3 9.0 2,194.3 713.4 (13.0) (373.5) 52.2 26.8 (207.5) 7.9 (8.5) 2,392.6 (52.4) 80.6 (325.1) 12.4 33.4 (330.3) 8.4 505.1 6.5 2,331.2 DARDEN RESTAURANTS, INC. CONSOLIDATED STATEMENTS OF CASH FLOWS (In millions) Fiscal Year Ended May 31, 2020 May 26, 2019 May 27, 2018 Cash flows - operating activities Net earnings (los $ (52.4) $ 713.4 $ 596.0 Losses from discontinued operations, net of tax 3.2 5.2 7.8 Adjustments to reconcile net earnings (loss) from continuing operations to cash flows: Depreciation and amortization 355.9 336.7 313.1 Goodwill and other impairments and disposal of assets, net 390.2 19.0 3.4 Stock-based compensation expense 53.0 59.8 42.8 Change in current assets and liabilities (73.3) 36.4 (8.0) Contributions to pension and postretirement plans 14.4) (1.7) (62.0) Deferred income taxes (133.6) 47.5 (20.6) Change in deferred rent 34.3 36.6 Change in other assets and liabilities 38.3 9.5 14.6 Pension settlement charge 145.5 Loss on extinguishment of debt 102.2 Other, net 5.0 7.5 6.1) Net cash provided by operating activities of continuing operations $ 717.4 $ 1,267.6 $ 1,019.8 Cash flows - investing activities Purchases of land, buildings and equipment (459.9) (452.0) (396.0) Proceeds from disposal of land, buildings and equipment 5.8 13.2 3.3 Cash used in business acquisitions, net of cash acquired (55.8) (40.4) Purchases of capitalized software and other assets 24.6) 25.9) 22.8) Other, net (9.5 2.1 4.8 Net cash used in investing activities of continuing operations 544.0) $ 462.6) $ (451.1) Cash flows - financing activities Net proceeds from issuance of common stock 525.9 59.3 37.8 Dividends paid (322.3) 370.8) (313.5) Repurchases of common stock (330.3 (207.5) (234.8) Proceeds from issuance of short-term debt 1,020.0 137.5 960.0 Repayments of short-term debt (750.0) (137.5) (960.0) Repayments of long-term debt 408.2) Proceeds from issuance of long-term debt 300.0 Principal payments on capital and financing leases (5.2) (6.2) (5.4) Proceeds from financing lease obligation 40.9 Other, net 0.6 0.1 12.5) Net cash provided by (used) in financing activities of continuing operations $ (484.2) $ 636.6) Cash flows - discontinued operations Net cash used in operating activities of discontinued operations (6.1) (10.4) (18.5) Net cash provided by investing activities of discontinued operations ).2 Net cash used in discontinued operations $ (6.1) $ (10.4) $ 18.3) Increase (decrease) in cash and cash equivalents 306.0 310.4 86.2) Cash and cash equivalents - beginning of year 457.3 146.9 233.1 Cash and cash equivalents - end of year 763.3 $ 457.3 $ 146.9DARDEN RESTAURANTS, INC. CONSOLIDATED STATEMENTS OF CASH FLOWS (Continued) (In millions) Fiscal Year Ended May 31, 2020 May 26, 2019 May 27, 2018 Cash flows from changes in current assets and liabilities Receivables, net 13.7 $ 2.1 $ (7.2) Inventories (13.9) (2.1) (26.6) Prepaid expenses and other current assets (2.8) (8.2) (12.5) Accounts payable (68.5) 55.0 12.6 Accrued payroll (25.3) (2.2) 25.9 Prepaid/accrued income taxes 17.8 (14.2) (9.9) Other accrued taxes (10.9) (2.4) 1.6 Unearned revenues 39.4 11.3 33.5 Other current liabilities (22.8) (2.9) (25.4) Change in current assets and liabilities (73.3) $ 36.4 $ (8.0) See accompanying notes to consolidated financial statements

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Students also viewed these Accounting questions

Question

Create a Fishbone diagram with the problem being coal "mine safety

Answered: 1 week ago