Provide common-size analysis of your companys income statement and balance sheet for the 2 most recent years
Fantastic news! We've Found the answer you've been seeking!
Question:
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). Must be done in excel format, not hand written or a word created format chart but EXCEL PLEASE! show formulas as well in a separate chart if you can.
Transcribed Image Text:
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 DARDEN RESTAURANTS, INC. CONSOLIDATED STATEMENTS OF EARNINGS (In millions, except per share data) Total operating costs and expenses Operating income Interest, net Other (income) expense, net Earnings (loss) before income taxes Income tax expense (benefit) Earnings (loss) from continuing operations Losses from discontinued operations, net of tax benefit 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 (loss) Diluted net earnings per share: Earnings (loss) from continuing operations Losses from discontinued operations Net earnings (loss) Average number of common shares outstanding: Basic Diluted May 31, 2020 $ 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) $ $ S $ Fiscal Year Ended May 26, 2019 7,806.9 $ 8,510.4 $ $ $ (49.2) $ (3.2) (52.4) $ (0.40) $ (0.03) (0.43) $ (0.40) $ (0.03) (0.43) $ 122.7 122.7 2,412.5 2,771.1 1,477.8 255.3 405.5 336.7 19.0 May 27, 2018 8,080.1 7,677.9 S 832.5 50.2 782.3 63.7 718.6 S (5.2) 713.4 $ 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 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 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 DARDEN RESTAURANTS, INC. CONSOLIDATED STATEMENTS OF EARNINGS (In millions, except per share data) Total operating costs and expenses Operating income Interest, net Other (income) expense, net Earnings (loss) before income taxes Income tax expense (benefit) Earnings (loss) from continuing operations Losses from discontinued operations, net of tax benefit 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 (loss) Diluted net earnings per share: Earnings (loss) from continuing operations Losses from discontinued operations Net earnings (loss) Average number of common shares outstanding: Basic Diluted May 31, 2020 $ 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) $ $ S $ Fiscal Year Ended May 26, 2019 7,806.9 $ 8,510.4 $ $ $ (49.2) $ (3.2) (52.4) $ (0.40) $ (0.03) (0.43) $ (0.40) $ (0.03) (0.43) $ 122.7 122.7 2,412.5 2,771.1 1,477.8 255.3 405.5 336.7 19.0 May 27, 2018 8,080.1 7,677.9 S 832.5 50.2 782.3 63.7 718.6 S (5.2) 713.4 $ 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 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
Expert Answer:
Answer rating: 100% (QA)
In common size analysis all Income Statement items are expressed as of Net Sales and all Balance Sheet items are expressed as of Total Assets a Common ... View the full answer
Related Book For
Financial Accounting
ISBN: 978-0077862268
2nd edition
Authors: J. David Spiceland, Wayne Thomas, Don Herrmann
Posted Date:
Students also viewed these accounting questions
-
The following income statement and balance sheet for The Athletic Attic are provided. Required: Assuming that all sales were on account, calculate the following risk ratios for 2012: 1. Receivables...
-
On Dec. 31, 2013, Neyo Co. purchased machinery for $95,933.37. The Co. paid $20,000 down & agreed to finance the remainder by making 4 equal payments each Dec. 31 at the implicit interest rate of...
-
The following income statement and balance sheet information are available for two firms, Firm A and Firm B. (a) Calculate the amount of dividends Firm A and Firm B paid using the information given....
-
Water flows in a cylindrical, horizontal pipe. As the pipe narrows to half its initial diameter, the pressure in the pipe changes. (a) Is the pressure in the narrow region greater than, less than, or...
-
Find an example of a print ad and evaluate it using the cognitive response model shown in Figure 4-4. Identify the specific types of cognitive responses that the ad might elicit from consumers and...
-
Many states conduct lotteries; a typical lottery (Keno) payoff ticket is shown here. Assume there are 20 numbers chosen from a set of 80 possible numbers. Use this information for Problems 52-56....
-
Consumer complaints are frequently reported to the Better Business Bureau (BBB). Industries with the most complaints to the BBB are often banks, cable and satellite television companies, collection...
-
HORIZONTAL ANALYSIS OF COMPARATIVE FINANCIAL STATEMENTS Amounts from the comparative income statement and balance sheet of Johnson Stores, Inc., for the last two years are as follows: REQUIRED...
-
What does the Performance Management (PM) process consist of? On what motivational theory is the PM process based on?
-
Consider the assignment problem having the following cost table. (a) Draw the network representation of this assignment problem. (b) Formulate this problem as a transportation problem by constructing...
-
In March, 2009, during hurricane Hamish, the MV Pacific Adventurer spilled 260 tonnes of fuel, along with 31 shipping containers housing 620 tonnes of ammonium nitrate, into the Coral Sea, just north...
-
Megan Furlan uses an automobile in a business that she carries on as a sole proprietor that uses a December 31 fiscal period. The automobile cost $88,000 in 2022, with maximum CCA being claimed for...
-
You manufacture and sell SCUBA and dive equipment. Most of your sales occur during the summer swimming season (May-August). To help ramp-up sales outside of this timeframe and clear your inventory at...
-
Describe the process of recanalization. What cells are participating in the process? Explain
-
What is proteomics? What are all the proteins produces by an organism's genome called? What development proteomics plays a crucial role in? What three dimensional shapes are used for in proteomics ?
-
Why do people enter pooling arrangements? Given their benefits, why don't most people simply form their own pooling of losses arrangements rather than involve insurance companies? Discuss.
-
Perform the multiplication and simplify. (In the second answer box, state any other restrictions on x not excluded by the domain of the expression in the first answer box. If there are no other...
-
Modify the CYK algorithm so that it applies to any CFG, not just those in CNF.
-
Each of the following independent situations represents amounts shown on the four basic financial statements. 1. Revenues = $25,000; Expenses = $17,000; Net income = __________. 2. Increase in...
-
The Intramural Sports Club reports sales revenue of $550,000. Inventory at both the beginning and end of the year totals $100,000. The inventory turnover ratio for the year is 4.0. What amount of...
-
Laker Incorporated's fiscal year-end is December 31, 2012. The following is an adjusted trial balance as of December 31. Required: Prepare the necessary closing entries? Debit Credit Accounts Cash...
-
A container of an organic liquid a $25^{\circ} \mathrm{C}$ has a mass of $1100 \mathrm{~kg}$ and a volume of $0.94 \mathrm{~m}^{3}$. Find the liquid's weight, its density, and its specific gravity.
-
What is the pressure one mile $(1.6 \mathrm{~km})$ beneath the ocean's surface?
-
At what pressure will water boil at $65^{\circ} \mathrm{C}$ ? The vapor pressure of water can be determined from the Antoine equation: \[\frac{P(P a)}{1 \times...
Study smarter with the SolutionInn App