Please complete table below for Wendy's. I am almost certain that my calculations are correct, but I want to be 100% confident. And please show formulas and calculations in the cells for verification. I provided the formulas needed, I just want to make sure that I am using the correct figures. Thank you. (/ = divided by)
The data:
Consolidated Statements of Earnings GENERAL MILLS, INC. AND SUBSIDIARIES (In Millions, Except per Share Data) Fiscal Year 2019 2018 2017 Net sales 16,865.2 $ 15,740.4 $ 15.619.8 Cost of sales 11,108.4 10,304.8 10.052.0 Selling, general, and administrative expenses 1,935.8 2,850.1 2,888.8 Divestitures Iness 30.0 h.5 Redructuring. impairment, and other exit costs 275.1 165.6 180.4 Operating profit 2.515.9 2,419.9 2,492.1 Benefit plan non-service income (47.9) (89.4) (74.3) Interest, net 521.8 373.7 295.1 Earnings before income taxes and after-tax carnings from joint ventures 2,082.0 2,135.6 2.2713 Income taxes 367.8 57.3 655.2 After-tax earnings from joint ventures 72.0 84 7 850 Net earnings, including earnings attributable to redeemable and noncontrolling interests 1.786.2 2,163.0 1 701.1 Net earnings attributable to redeemable and Boncontrolling interests 32.0 436 Not earnings attributable to General Mills 1.751.7 2.131.0 1.657.5 Earnings per share - basic 3.69 2.82 Lamings per share - diluted 2.77 Dividends per share see accompanying notes to complicated financial statementsConsolidated Statements of Comprehensive Income GENERAL MILLS, INC. AND SUBSIDIARIES (In Millions) Fiscal Year 2019 2018 2017 Net earnings, including earnings attributable to redeemable and noncontrolling interests 1,786.2 $ 2,163.0 $ 1,701.1 Other comprehensive income (loss), net of tax: Foreign currency translation (82.8) (37.0) 6.3 Net actuarial (loss) income (253.4) 140.1 197.9 Other fair value changes: Securities 12 Hedge derivatives 12.1 (50.8 53.3 Reclassification to earnings: Securities (2.0) (5.1) Hedge derivatives 0.9 17.4 (25.7) Amortization of losses and prior service costs 84.6 117.6 122.5 Other comprehensive (loss) income, net of tax (240.6) 183.4 355.1 Total comprehensive income 1.545.6 2.346.4 2,056 2 Comprehensive (loss) income attributable to redeemable and noncontrolling interests (10.7) 70 5 31.0 Comprehensive income attributable to General Mills 1.556.3 2.275.9 $ 2.025.2 See accompanying notes to consolidated financial statements.Comolidated Balance Sheets GENERAL MILLS, INC. AND SUBSIDIARIES (In Millions, Except Par Value) May 26, May 27, 2019 2018 ASSETS Current assets: Cash and cash equivalents 450.0 399.0 Receivables 1,679.7 1,684.2 Inventories 1,559-3 1.642.2 Prepaid expenses and other current assets 497.5 398.3 Total current assets 4,186.5 4.123.7 Land, buildings, and equipment 3,787.2 4,047.2 Goodwill 13,995.8 14.065.0 Other intangible assets 7,166.8 7.445.1 Other aacts 974.9 943.0 Total assets 30,111.2 30.624.0 LIABILITIES AND EQUITY Current liabilities: Accounts payable 2,854.1 2,746.2 Current portion of long-term debt 1,396.5 1.600.1 Notes payable 1,468.7 1,549.8 Other current liabilities 1,367.8 1.445.8 Total current liabilities 7.087.1 7,341.9 Long-term debt 11.624.8 12,668.7 Deferred income taxes 2,031.0 2.003.8 Other liabilities 1,448.9 1,341.0 Total liabilities 22,191.8 23.355.4 Redeemable interest 551.7 776.2 Stockholders equity Common stock, 754.6 shares issued, 50.10 par value 75.5 75.5 Additional paid-in capital 1,386.7 1,202 5 Retained camings 14.990.7 14,459 6 Common stock in treasury. at cost, shares of 152.7 and 161.5 (6.779.0) (7.167.5) Accumulated other comprehensive loss (2.625.4) (2.429.0) Total stockholders' equity 7.054.5 6.141.1 Noncontrolling interests 313.2 351.3 Total equity 7.367.7 6,492.4 Total liabilities and equity 30,111.2 30,624.0 Sec accompanying notes to consolidated financial statements,Con welldated Statements of Total Equity, and Redeemable Internit GENERAL MILLS, INC. AND SUASIONARIES (in Million, Forp pre Shanny DaisyConsolidated Statements of Cash Flows GENERAL MILLS, INC. AND SUBSIDIARIES (In Millions) Fiscal Year 2019 2018 2017 Cash Flows - Operating Activities Net earnings, including earnings attributable to redeemable and Doncontrolling interests 1,786.2 5 2,1630 5 1,701.1 Adjustments to reconcile net carings to net cash provided by operating activities: Depreciation and amortization 618.8 603.6 After-tax earnings from joint ventures (72.0) (84.7) (85.0) Distributions of earnings from joint ventures HALT 113.2 75.6 Stock-based compensation 77.0 95.7 Deferred income tires (504.3) 1839 Pension and other postretirement benefit plan contribution (31.8) (454) Pension and other postretirement benefit plan costs 6.1 4.6 35.7 Divestitures loss 30.0 13.5 Restructuring. impairment, and other exit costs 135.7 126.0 117.0 Changes in current assets and liabilities, excluding the effects of acquisitions and divestitures (75) 542.1 (194 2) Other, net (27.9) (182.9) (86.3) Net cash provided by operating activities 2,807.0 2,841.0 2,415.2 Cash Flows - Investing Activities Purchases of land, buildings, and equipment (537.6) (622.7) (684.4) Acquisition, net of cash acquired (8,035.8) Investments in affiliates, net 0.1 (17.3) 3.3 Proceeds from disposal of land, buildings, and equipment 14 42 Proceeds from divestitures 26.4 17.5 Exchangeable note 130 Other, net 159. 71 (110) 105 Net cash used by investing activities (5365) (8.685.4) (646.9) Cash Flows - Financing Activities Change in notes payable (653) Issuance of long-term debt 327 5 962 4 319.1 Payment of long-term debt 6.550.0 1.072.1 Proceeds from common stock issued on cuoreised options (600.1) (1.000.0) Proceeds from common stock loved 241.4 99 3 112.6 Purchases of common stock for treasury 969.9 Dividends paid (601.6) Investments in redeemable interest LIST) (1.651 5 (1.139.7) $5.7 (1.135, 1) Distribution to noncontrolling and rodecmable intoed holders Onlier, nel (385) 161.0 Net cash provided i used ) by financing activities (10s.0) 146.9) (2, 176.4) 5.445.5 Effect of exchange rate changes on cash and cash equivalents (1,747.4) Increase (docicak) in garth and cash equivalents 3.1.8 (18 5) Cash and each equivalents . beginning of year $1.0 1367.11 1940 24 Cash and cash equivalents . end of year 761 7 3920 Cash Fire from Changes in Cunical Assets and Lichilities, Fuchsin the ellecho of acquisitions and divestitureed 113271 169 31 Prepaid caperses and other cumcut assets 15.6 (61-5) 1624 846 179.61 1751 1494.27