EXCEL PROJECT: PART III INSTRUCTIONS - Accounting
The analysis is on McDonalds years 2020, 2019, 2018. and the competitors are Burgerking and Windys
Excel Project: Part III Instructions
Common Sized Balance Sheets (Tabs 12), Common Sized Income Statements (Tab 13), Horizontal Analysis Balance Sheets (Tab 14), Horizontal Analysis Income Statements (Tab 15), and Projected Financial Statements (Tabs 16-18)
· Continue in the same Excel workbook prepared in Week 4, adding the following tabs:
· The
12th tab
in your Financial Statement Analysis Template must be labeled Common Sized Balance Sheets.
· Set-up like the Historical Balance Sheets (Tab 3), this worksheet should use formulas to calculate the common sized percentages, linking to the Historical Balance Sheets for the calculations. “Total Assets” should be used as the base for all common sized calculations on the Balance Sheets. Common sized percentages should be calculated for all three historical years presented.
· See Exhibit A for a partial example of this tab.
· The
13th tab
in your Financial Statement Analysis Template must be labeled Common Sized Income Statements.
· Set-up like the Historical Income Statements (Tab 2), this worksheet should use formulas to calculate the common sized percentages, linking to the Historical Income Statements for the calculations. “Revenue” or “Total Revenue” (depending on your company) should be used as the base for all common sized calculations on the Income Statements. Common sized percentages should be calculated for all three historical years presented.
· The
14th tab
in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Balance Sheets.
· Start by copying and pasting the Historical Balance Sheets from Tab 3 to this worksheet. Then, add dollar and percentage change columns between each of the set of historical years.
· See Exhibit B for an example of this tab.
· The
15th tab
in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Income Statements.
· Start by copying and pasting the Historical Income Statements from Tab 2 to this worksheet. Then, add dollar and percentage change columns between each of the set of historical years.
· The
16th tab
in your Financial Statement Analysis Template must be labeled Projected Income Statements. Three years of projected statements should be included, starting with the most recent year after the company’s last issued report.
· The
17th tab
in your Financial Statement Analysis Template must be labeled Projected Balance Sheets. Three years of projected statements should be included. Three years of projected statements should be included, starting with the most recent year after the company’s last issued report.
· The
18th tab
in your Financial Statement Analysis Template must be labeled Projected Statement of Cash Flows. Three years of projected statements should be included, starting with the most recent year after the company’s last issued report.
· Other information relating to projected tabs:
· Projections should be based on research performed on your company and its industry. Use historical, trend, ratio data and current and future economic projections as well as information from the company’s MD&A to aid in preparing projections.
· Clearly state your assumptions in a text box at the bottom of each tab. Cite sources for assumptions based on research.
· The statements should be consistent, reasonable, and accurate. Areas that will be checked for accuracy include:
· The Balance Sheets should balance for all years presented.
· Retained earnings should be properly calculated using the prior year’s balance, net income, and dividends.
· The Ending Cash Balance on the Statement of Cash Flows should agree to the Cash Balance shown on the Balance Sheet for the same year.
· Net Income on the Income Statements should match what is reported on the top of the Statement of Cash Flows (if indirect method is used).
· Other instructions:
· The Excel workbook should be professionally formatted. Professional formatting includes:
· All numbers are formatted similarly. The use of decimals, commas for thousands, and other formatting is consistent.
· Dollar signs are included in the first and last numbers of each column.
· Subtotals and totals are preceded by a single underline. Totals are followed by a double underline.
· Line descriptions are indented/bolded in a manner that makes the spreadsheet easy to read.
· All common sized, horizontal analysis, and projection items should be calculated using formulas. Totals and subtotals should also be calculated using formulas. For an example of which cells may need formulas, please see Exhibits A & B.
This assignment is due by 11:59 p.m. (ET) on Monday of Module/Week 6.
ACCT 370
Exhibit A: Example Common Sized Balance Sheets (Tab 12, Partial View)
(IMPORTANT NOTE: Only Partial Balance Sheet shown. Your Balance Sheet should include Liabilities and Stockholders’ Equity as well.)
Exhibit B: Example Horizontal Analysis of Balance Sheets (Tab 14, Partial View)
(IMPORTANT NOTE: Only Partial Balance Sheet shown. Your Balance Sheet should include Liabilities and Stockholders’ Equity as well.)
Company Information
ACCT 370 Excel Project
McDonald’s
Company Information
Company Name McDonalds
Ticker Symbol MCD
Industry Fast Food Restaurant Franchise
Products and Services Offered McDonald’s menu includes hamburgers and cheeseburgers, Big Mac, Quarter Pounder with Cheese, Filet-O-Fish, several chicken sandwiches, Chicken McNuggets, wraps, McDonalds Fries, salads, oatmeal, shakes, McFlurry desserts, sundaes, soft serve cones, bakery items, soft drinks, coffee, McCafé beverages and other beverages.
McDonald’s restaurants in the U.S. and many international markets offer a full or limited breakfast menu. Breakfast offerings may include Egg McMuffin, Sausage McMuffin with Egg, McGriddles, biscuit and bagel sandwiches, oatmeal, breakfast burritos and hotcakes.
In addition to these menu items, the restaurants sell a variety of other products during limited-time promotions.
Taste, quality, choice, value and nutrition are important to our customers, and we are continuously evolving our menu to meet our customers needs, including testing new products on an ongoing basis.
Major Competitors Burger king (owned by Restraunt Brands International Inc.), Windys, and Chick-Fill-a
Historical Income Statements
McDonalds
Consolidated Statement of Income
Years ended in 2020, 2019, 2018
$s in Millions, except per share data
REVENUES 2020 2019 2018
Sales by Company-operated restaurants $ 8,139.2 $ 9,420.8 $ 10,012.7
Revenues from franchised restaurants 10,726.1 11,655.7 11,012.5
Other revenues 342.5 287.9 232.7
Total revenues 19,207.8 21,364.4 21,257.9
OPERATING COSTS AND EXPENSES
Company-operated restaurant expenses
Food & paper 2,564.2 2,980.3 3,153.8
Payroll & employee benefits 2,416.4 2,704.4 2,937.9
Occupancy & other operating expenses 2,000.6 2,075.9 2,174.2
Franchised restaurants-occupancy expenses 2,207.5 2,200.6 1,973.3
Other restaurant expenses 267.0 223.8 186.1
Selling, general & administrative expenses
Depreciation and amortization 300.6 262.5 214.8
Other 2,245.0 1,966.9 1,985.4
Other operating (income) expense, net (117.5) (119.8) (190.2)
Total operating costs and expenses 11,883.8 12,294.6 12,435.3
Operating income 7,324.0 9,069.8 8,822.6
Interest expense-net of capitalized interest of $6.0, $7.4 and $5.6 1,218.1 1,121.9 981.2
Nonoperating (income) expense, net (34.8) (70.2) 25.3
Income before provision for income taxes 6,140.7 8,018.1 7,816.1
Provision for income taxes 1,410.2 1,992.7 1,891.8
Net income 4,730.5 6,025.4 5,924.3
Earnings per common share–basic 6.4 8.0 7.6
Earnings per common share–diluted 6.3 7.9 7.5
Dividends declared per common share 5.0 4.7 4.2
Weighted-average shares outstanding–basic 744.6 758.1 778.2
Weighted-average shares outstanding–diluted $ 750.1 $ 764.9 $ 785.6
Historical Balance Sheets
McDonalds
Consolidated Balance Sheet
Years ended in 2020, 2019, 2018
$s in Millions, except per share data
ASSETS 2020 2019 2018
Current assets
Cash and equivalents $ 3,449.1 $ 898.5 $ 866.0
Accounts and notes receivable 2,110.3 2,224.2 2,441.5
Inventories, at cost, not in excess of market 51.1 50.2 51.1
Prepaid expenses and other current assets 632.7 385.0 694.6
Total current assets 6,243.2 3,557.9 4,053.2
Other assets
Investments in and advances to affiliates 1,297.2 1,270.3 1,202.8
Goodwill 2,773.1 2,677.4 2,331.5
Miscellaneous 3,527.4 2,584.0 2,381.5
Total other assets 7,597.7 6,531.7 5,915.8
Lease right-of-use asset, net 13,827.7 13,261.2
Property and equipment
Property and equipment, at cost 41,476.5 39,050.9 37,193.6
Accumulated depreciation and amortization (16,518.3) (14,890.9) (14,350.9)
Net property and equipment 24,958.2 24,160.0 22,842.7
Total assets 52,626.8 47,510.8 32,811.7
LIABILITIES AND SHAREHOLDERS’ EQUITY
Current liabilities
Accounts payable 741.3 988.2 1,207.9
Lease liability 701.5 621.0
Income taxes 741.1 331.7 228.3
Other taxes 227.0 247.5 253.7
Accrued interest 388.4 337.8 297.0
Accrued payroll and other liabilities 1,138.3 1,035.7 986.6
Current maturities of long-term debt 2,243.6 59.1
Total current liabilities 6,181.2 3,621.0 2,973.5
Long-term debt 32,196.8 34,118.1 31,075.3
Long-term lease liability 13,321.3 12,757.8
Long-term income taxes 1,970.7 2,265.9 2,081.2
Deferred revenues - initial franchise fees 702.0 660.6 627.8
Other long-term liabilities 1,054.1 979.6 1,096.3
Deferred income taxes 2,025.6 1,318.1 1,215.5
Shareholders’ equity (deficit)
Preferred stock, no par value; authorized – 165.0 million shares; issued – none
Common stock, $.01 par value; authorized – 3.5 billion shares; issued – 1,660.6 million shares 16.6 16.6 16.6
Additional paid-in capital 7,903.6 7,653.9 7,376.0
Retained earnings 53,908.1 52,930.5 50,487.0
Accumulated other comprehensive income (loss) (2,586.8) (2,482.7) (2,609.5)
Common stock in treasury, at cost; 915.2 and 914.3 million shares (67,066.4) (66,328.6) (61,528.5)
Total shareholders’ equity (deficit) (7,824.9) (8,210.3) (6,258.4)
Total liabilities and shareholders’ equity (deficit) $ 52,626.8 $ 47,510.8 $ 32,811.2
McDonalds Corporation 2020 Annual Report 36 & 40
Historical Statement of Cash Fl
McDonalds
Consolidated Statement of Cash Flows
Years ended in 2020, 2019, 2018
$s in Millions, except per share data
Operating activities 2020 2019 2018
Net income $ 4,730.5 $ 6,025.4 $ 5,924.3
Adjustments to reconcile to cash provided by operations
Charges and credits:
Depreciation and amortization 1,751.4 1,617.9 1,482.0
Deferred income taxes 6.4 149.7 102.6
Share-based compensation 92.4 109.6 125.1
Net gain on sale of restaurant businesses (28.2) (128.2) (308.8)
Other (75.2) 49.2 114.2
Changes in working capital items:
Accounts receivable (6.8) 27.0 (479.4)
Inventories, prepaid expenses and other current assets (68.6) 128.8 (1.9)
Accounts payable (137.5) (26.8) 129.4
Income taxes (43.6) 173.4 (33.4)
Other accrued liabilities 44.4 (3.9) (87.4)
Cash provided by operations 6,265.2 8,122.1 6,966.7
Investing activities
Capital expenditures (1,640.8) (2,393.7) (2,741.7)
Purchases of restaurant and other businesses (66.1) (540.9) (101.7)
Sales of restaurant businesses 76.3 340.8 530.8
Sales of property 27.4 151.2 160.4
Other 57.4 (628.5) (302.9)
Cash used for investing activities (1,545.8) (3,071.1) (2,455.1)
Financing activities
Net short-term borrowings (893.1) 799.2 95.9
Long-term financing issuances 5,543.0 4,499.0 3,794.5
Long-term financing repayments (2,411.7) (2,061.9) (1,759.6)
Treasury stock purchases (907.8) (4,976.2) (5,207.7)
Common stock dividends (3,752.9) (3,581.9) (3,255.9)
Proceeds from stock option exercises 295.5 350.5 403.2
Other (122.0) (23.5) (20.0)
Cash used for financing activities (2,249.0) (4,994.8) (5,949.6)
Effect of exchange rates on cash and equivalents 80.2 (23.7) (159.8)
Cash and equivalents increase (decrease) 2,550.6 32.5 (1,597.8)
Cash and equivalents at beginning of year 898.5 866.0 2,463.8
Cash and equivalents at end of year 3,449.1 898.5 866.0
Supplemental cash flow disclosures
Interest paid 1,136.0 1,066.5 959.6
Income taxes paid $ 1,441.9 $ 1,589.7 $ 1,734.4
Burger King Income Statements
Burger King (Restraunt Brands International Inc.)
Consolidated Statements Of Operations / Comperhensive Income
Years ended in 2020, 2019, 2018
$s in Millions, except per share data
Revenues: 2020 2019 2018
Sales $ 2,013 $ 2,362 $ 2,355
Franchise and property revenues 2,955 3,241 3,002
Total revenues 4,968 5,603 5,357
Operating costs and expenses:
Cost of sales 1,610 1,813 1,818
Franchise and property expenses 528 540 422
Selling, general and administrative expenses 1,264 1,264 1,214
(Income) loss from equity method investments 39 (11) (22)
Other operating expenses (income), net 105 (10) 8
Total operating costs and expenses 3,546 3,596 3,440
Income from operations 1,422 2,007 1,917
Interest expense, net 508 532 535
Loss on early extinguishment of debt 98 23 —
Income before income taxes 816 1,452 1,382
Income tax expense 66 341 238
Net income 750 1,111 1,144
Net income attributable to noncontrolling interests (Note 12) 264 468 532
Net income attributable to common shareholders 486 643 612
Earnings per common share:
Basic 1.61 2.40 2.46
Diluted 1.60 2.37 2.42
Weighted average shares outstanding:
Basic 302 268 249
Diluted 468 469 473
Net income 750 1,111 1,144
Foreign currency translation adjustment 332 409 (831)
Net change in fair value of net investment hedges, net of tax of $60, $32, and $(101) (242) (86) 282
Net change in fair value of cash flow hedges, net of tax of $91, $29, and $7 (244) (77) (19)
Amounts reclassified to earnings of cash flow hedges, net of tax of $(27), $(6), and $(5) 73 15 14
Gain (loss) recognized on defined benefit pension plans and other items, net of tax of $3, $1, and $0 (16) (2) 1
Other comprehensive income (loss) (97) 259 (553)
Comprehensive income (loss) 653 1,370 591
Comprehensive income (loss) attributable to noncontrolling interests 224 571 276
Comprehensive income (loss) attributable to common shareholders $ 429 $ 799 $ 315
Burger King Balance Sheets
Burger King (Restraunt Brands International Inc.)
Balance Sheet
Years ended in 2020, 2019, 2018
$s in Millions, except per share data
ASSETS 2020 2019 2018
Current assets:
Cash and cash equivalents $ 1,560 $ 1,533 $ 913
Accounts and notes receivable, net of allowance of $42 and $13, respectively 536 527 452
Inventories, net 96 84 75
Prepaids and other current assets 72 52 60
Total current assets 2,264 2,196 1,500
Property and equipment, net of accumulated depreciation and amortization of $879 and $746, respectively 2,031 2,007 1,996
Operating lease assets, net 1,152 1,176 —
Intangible assets, net 10,701 10,563 10,463
Goodwill 5,739 5,651 5,486
Net investment in property leased to franchisees 66 48 54
Other assets, net 824 719 642
Total assets 22,777 22,360 20,141
LIABILITIES AND SHAREHOLDERS’ EQUITY
Current liabilities:
Accounts and drafts payable 464 644 513
Other accrued liabilities 835 790 637
Gift card liability 191 168 167
Current portion of long-term debt and finance leases 111 101 91
Total current liabilities 1,601 1,703 1,408
Long-term debt, net of current portion 12,397 11,759 11,823
Finance leases, net of current portion 315 288 226
Operating lease liabilities, net of current portion 1,082 1,089 —
Other liabilities, net 2,236 1,698 1,547
Deferred income taxes, net 1,425 1,564 1,519
Total liabilities 19,056 18,101 16,523
Commitments and contingencies (Note 16)
Shareholders’ equity:
Common shares, no par value; Unlimited shares authorized at December 31, 2020 and December 31, 2019; 304,718,749 shares issued and outstanding at December 31, 2020; 298,281,081 shares issued and outstanding at December 31, 2019 2,399 2,478 1,737
Retained earnings 622 775 674
Accumulated other comprehensive income (loss) (854) (763) (800)
Total Restaurant Brands International Inc. shareholders’ equity 2,167 2,490 1,611
Noncontrolling interests 1,554 1,769 2,007
Total shareholders’ equity 3,721 4,259 3,618
Total liabilities and shareholders’ equity $ 22,777 $ 22,360 $ 20,141
Burger King Cash Flows
Burger King (Restraunt Brands International Inc.)
Statement of Cash Flows
Years ended in 2020, 2019, 2018
$s in Millions, except per share data
Cash flows from operating activities: 2020 2019 2018
Net income $ 750 $ 1,111 $ 1,144
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization 189 185 180
Premiums paid and non-cash loss on early extinguishment of debt 97 16 —
Amortization of deferred financing costs and debt issuance discount 26 29 29
(Income) loss from equity method investments 39 (11) (22)
Loss (gain) on remeasurement of foreign denominated transactions 100 (14) (33)
Net (gains) losses on derivatives 32 (49) (40)
Share-based compensation expense 74 68 48
Deferred income taxes (208) 58 29
Other 28 6 5
Changes in current assets and liabilities, excluding acquisitions and dispositions:
Accounts and notes receivable (30) (53) 19
Inventories and prepaids and other current assets (10) (15) (7)
Accounts and drafts payable (183) 112 41
Other accrued liabilities and gift card liability 16 (51) (219)
Tenant inducements paid to franchisees (22) (54) (52)
Other long-term assets and liabilities 23 138 43
Net cash provided by operating activities 921 1,476 1,165
Cash flows from investing activities:
Payments for property and equipment (117) (62) (86)
Net proceeds from disposal of assets, restaurant closures and refranchisings 12 8 8
Settlement/sale of derivatives, net 33 24 17
Other investing activities, net (7) — 17
Net cash used for investing activities (79) (30) (44)
Cash flows from financing activities:
Proceeds from issuance of long-term debt 5,235 2,250 75
Repayments of long-term debt and finance leases (4,708) (2,266) (74)
Payment of financing costs (43) (50) (3)
Payment of dividends on common shares and distributions on Partnership exchangeable units (959) (901) (728)
Repurchase of Partnership exchangeable units (380) — (561)
Proceeds from stock option exercises 82 102 61
(Payments) proceeds from derivatives (46) 23 —
Other financing activities, net (2) — (55)
Net cash used for financing activities (821) (842) (1,285)
Effect of exchange rates on cash and cash equivalents 6 16 (20)
Increase (decrease) in cash and cash equivalents 27 620 (184)
Cash and cash equivalents at beginning of period 1,533 913 1,097
Cash and cash equivalents at end of period 1,560 1,533 913
Supplemental cash flow disclosures:
Interest paid 463 584 561
Income taxes paid $ 267 $ 248 $ 433
Windys Income Statements
The Wendys Company and Subidiaries
Consolidated Statements Of Operations / Comperhensive Income
Years ended in 2020, 2019, 2018
$s in Millions, except per share data
Revenues: 2021/2020 2019 2018
Sales $ 722,764 $ 707,485 $ 651,577
Franchise royalty revenue and fees 444,749 428,999 409,043
Franchise rental income 232,648 233,065 203,297
Advertising funds revenue 333,664 339,453 326,019
1,733,825 1,709,002 1,589,936
Costs and expenses:
Cost of sales 614,907 597,530 548,588
Franchise support and other costs 26,464 43,686 25,203
Franchise rental expense 125,613 123,929 91,104
Advertising funds expense 345,360 338,116 321,866
General and administrative 206,876 200,206 217,489
Depreciation and amortization 132,775 131,693 128,879
System optimization gains, net (3,148) (1,283) (463)
Reorganization and realignment costs 16,030 16,965 9,068
Impairment of long-lived assets 8,037 6,999 4,697
Other operating income, net (8,397) (11,418) (6,387)
1,464,517 1,446,423 1,340,044
Operating profit 269,308 262,579 249,892
Interest expense, net (117,737) (115,971) (119,618)
Loss on early extinguishment of debt — (8,496) (11,475)
Investment (loss) income, net (225) 25,598 450,736
Other income, net 1,449 7,771 5,381
Income before income taxes 152,795 171,481 574,916
Provision for income taxes (34,963) (34,541) (114,801)
Net income 117,832 136,940 460,115
Net income per share:
Basic .53 .60 1.93
Diluted .52 .58 1.88
Net income 117,832 136,940 460,115
Other comprehensive income (loss), net:
Foreign currency translation adjustment 4,187 7,845 (16,524)
Change in unrecognized pension loss:
Unrealized gains arising during the period — — 156
Income tax provision — — (39)
Final settlement of pension liability — — 932
— — 1,049
Other comprehensive income (loss), net 4,187 7,845 (15,475)
Comprehensive income $ 122,019 $ 144,785 $ 444,640
Windys Cash Flows
The Wendys Company and Subidiaries
Statement of Cash Flows
Years ended in 2020, 2019, 2018
$s in Millions, except per share data
Cash flows from operating activities: 2021/2020 2019 2018
Net income $ 117,832 $ 136,940 $ 460,115
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization 132,775 131,693 128,879
Share-based compensation 18,930 18,676 17,918
Impairment of long-lived assets 8,037 6,999 4,697
Deferred income tax 10,266 837 (6,568)
Non-cash rental expense (income), net 28,937 28,202 (17,043)
Change in operating lease liabilities (40,905) (41,911) —
Net receipt (recognition) of deferred vendor incentives 2,495 (501) 139
System optimization gains, net (3,148) (1,283) (463)
Gain on sale of investments, net — (24,496) (450,000)
Distributions received from TimWen joint venture 8,376 13,400 13,390
Equity in earnings in joint ventures, net (6,096) (8,673) (8,076)
Long-term debt-related activities, net (see below) 6,723 15,317 18,673
Other, net (6,438) (4,838) 5,178
Changes in operating assets and liabilities:
Accounts and notes receivable, net (16,243) 16,935 13,226
Inventories (841) (163) (434)
Prepaid expenses and other current assets (8,780) (1,569) 6,824
Advertising funds restricted assets and liabilities 49,052 (2,720) 13,955
Accounts payable 1,620 1,054 (145)
Accrued expenses and other current liabilities (18,231) 5,034 23,963
Net cash provided by operating activities 284,361 288,933 224,228
Cash flows from investing activities:
Capital expenditures (68,969) (74,453) (69,857)
Acquisitions (4,879) (5,052) (21,401)
Dispositions 6,091 3,448 3,223
Proceeds from sale of investments 169 24,496 450,000
Notes receivable, net (662) (3,370) 959
Payments for investments — — (13)
Net cash (used in) provided by investing activities (68,250) (54,931) 362,911
Cash flows from financing activities:
Proceeds from long-term debt 153,315 850,000 934,837
Repayments of long-term debt (191,462) (899,800) (894,501)
Repayments of finance lease liabilities (8,383) (6,835) (5,571)
Deferred financing costs (2,122) (14,008) (17,340)
Repurchases of common stock, including accelerated share repurchase (62,173) (217,797) (269,809)
Dividends (64,866) (96,364) (80,532)
Proceeds from stock option exercises 23,361 28,328 45,228
Payments related to tax withholding for share-based compensation (5,577) (8,820) (11,805)
Contingent consideration payment — — (6,269)
Net cash used in financing activities (157,907) (365,296) (305,762)
Net cash provided by (used in) operations before effect of exchange rate changes on cash 58,204 (131,294) 281,377
Effect of exchange rate changes on cash 1,330 3,489 (7,689)
Net increase (decrease) in cash, cash equivalents and restricted cash 59,534 (127,805) 273,688
Cash, cash equivalents and restricted cash at beginning of period 358,707 486,512 212,824
Cash, cash equivalents and restricted cash at end of period 418,241 358,707 $ 486,512
Detail of cash flows from operating activities:
Long-term debt-related activities, net:
Loss on early extinguishment of debt — 8,496 11,475
Accretion of long-term debt 1,161 1,272 1,255
Amortization of deferred financing costs 5,562 5,549 5,943
6,723 15,317 18,673
Supplemental cash flow information:
Cash paid for:
Interest 136,228 138,270 137,607
Income taxes, net of refunds 16,202 34,798 102,827
Supplemental non-cash investing and financing activities:
Capital expenditures included in accounts payable 3,673 6,026 6,460
Finance leases 34,918 50,061 6,569
Reconciliation of cash, cash equivalents and restricted cash at end of period:
Cash and cash equivalents 306,989 300,195 431,405
Restricted cash 33,973 34,539 29,860
Restricted cash, included in Advertising funds restricted assets 77,279 23,973 25,247
Total cash, cash equivalents and restricted cash $ 418,241 $ 358,707 $ 486,512
Windys Balance Sheet
The Wendys Company and Subidiaries
Balance Sheet
Years ended in 2020, 2019, 2018
$s in Millions, except per share data
ASSETS 2020/2021 2019 2018
Current assets:
Cash and cash equivalents $ 306,989 $ 300,195 $ 431,405
Restricted cash 33,973 34,539 29,860
Accounts and notes receivable, net 109,891 117,461 109,805
Inventories 4,732 3,891 3,687
Prepaid expenses and other current assets 89,732 15,585 14,452
Advertising funds restricted assets 142,306 82,376 76,509
Total current assets 687,623 554,047 665,718
Properties 915,889 977,000 1,023,267
Finance lease assets 206,153 200,144 189,969
Operating lease assets 821,480 857,199 —
Goodwill 751,049 755,911 747,884
Other intangible assets 1,224,960 1,247,212 1,294,153
Investments 44,574 45,949 47,660
Net investment in sales-type and direct financing leases 268,221 256,606 226,477
Other assets 120,057 100,461 96,907
Total assets 5,040,006 4,994,529 4,292,035
LIABILITIES AND STOCKHOLDERS’ EQUITY
Current liabilities:
Current portion of long-term debt 28,962 22,750 23,250
Current portion of finance lease liabilities 12,105 11,005 8,405
Current portion of operating lease liabilities 45,346 43,775 —
Accounts payable 31,063 22,701 21,741
Accrued expenses and other current liabilities 155,321 165,272 150,636
Advertising funds restricted liabilities 140,511 84,195 80,153
Total current liabilities 413,308 349,698 284,185
Long-term debt 2,218,163 2,257,561 2,305,552
Long-term finance lease liabilities 506,076 480,847 447,231
Long-term operating lease liabilities 865,325 897,737 —
Deferred income taxes 280,755 270,759 269,160
Deferred franchise fees 89,094 91,790 92,232
Other liabilities 117,689 129,778 245,226
Total liabilities 4,490,410 4,478,170 3,643,586
Commitments and contingencies
Stockholders’ equity:
Common stock, $0.10 par value; 1,500,000 shares authorized; 47,042 47,042 47,042
470,424 shares issued; 224,268 and 224,889 shares outstanding, respectively
Additional paid-in capital 2,899,276 2,874,001 2,884,696
Retained earnings 238,674 185,725 146,277
Common stock held in treasury, at cost; 246,156 and 245,535 shares, respectively (2,585,755) (2,536,581) (2,367,893)
Accumulated other comprehensive loss (49,641) (53,828) (61,673)
Total stockholders’ equity 549,596 516,359 648,449
Total liabilities and stockholders’ equity $ 5,040,006 $ 4,994,529 $ 4,292,035
)
)
4,292,035
Historical and Competitor Ratio
McDonald’s Competitor Ratio Analysis
Historical Ratios
Years ended in 2020, 2019, 2018
$s in Millions, except per share data
2020 2019 2018 Burger King Windys Industry Average
Liquidity
Current Ratio 1.01 1.41 1.66 1.34
Chris Thomas: Chris Thomas:
Industry average Current Ratio retrieved from https://www.macrotrends.net/stocks/charts/QSR/restaurant-brands/current-ratio
Quick Ratio 0.9 1.02 1
Chris Thomas: Chris Thomas:
Industry average for Quick Ratio retrieved from https://wahospitality.org/blog/trouble-ahead-look-for-these-five-red-flags-in-your-restaurant-financial-statements/
Leverage Ratios
Debt to Total Assets Ratio 1.15 0.89 0.55
Debt to Equity Ratio 0 0 0 5.12 8.17 0.56
Chris Thomas: Chris Thomas:
Industry average for Debit to Equity Ratio retrieved from https://pos.toasttab.com/blog/on-the-line/restaurant-debt-to-equity-ratio
Long-Term Debt to Equity 0 0 0 0.56
Chris Thomas: Chris Thomas:
Industry average for Debit to Equity Ratio retrieved from https://pos.toasttab.com/blog/on-the-line/restaurant-debt-to-equity-ratio
Times Intrest Earned Ratio 6.04 7.58 2.3 3.25
Chris Thomas: Chris Thomas:
retrieved from https://www.readyratios.com/sec/industry/20/
Activity Ratios
Inventory Turnover 2 14 1 79
Chris Thomas: Chris Thomas:
Industry average for Inventory Turnover retrieved from https://wahospitality.org/blog/trouble-ahead-look-for-these-five-red-flags-in-your-restaurant-financial-statements/
Fixed Assets Turnover 1059 869
Chris Thomas: Chris Thomas:
retrieved from …
CATEGORIES
Economics
Nursing
Applied Sciences
Psychology
Science
Management
Computer Science
Human Resource Management
Accounting
Information Systems
English
Anatomy
Operations Management
Sociology
Literature
Education
Business & Finance
Marketing
Engineering
Statistics
Biology
Political Science
Reading
History
Financial markets
Philosophy
Mathematics
Law
Criminal
Architecture and Design
Government
Social Science
World history
Chemistry
Humanities
Business Finance
Writing
Programming
Telecommunications Engineering
Geography
Physics
Spanish
ach
e. Embedded Entrepreneurship
f. Three Social Entrepreneurship Models
g. Social-Founder Identity
h. Micros-enterprise Development
Outcomes
Subset 2. Indigenous Entrepreneurship Approaches (Outside of Canada)
a. Indigenous Australian Entrepreneurs Exami
Calculus
(people influence of
others) processes that you perceived occurs in this specific Institution Select one of the forms of stratification highlighted (focus on inter the intersectionalities
of these three) to reflect and analyze the potential ways these (
American history
Pharmacology
Ancient history
. Also
Numerical analysis
Environmental science
Electrical Engineering
Precalculus
Physiology
Civil Engineering
Electronic Engineering
ness Horizons
Algebra
Geology
Physical chemistry
nt
When considering both O
lassrooms
Civil
Probability
ions
Identify a specific consumer product that you or your family have used for quite some time. This might be a branded smartphone (if you have used several versions over the years)
or the court to consider in its deliberations. Locard’s exchange principle argues that during the commission of a crime
Chemical Engineering
Ecology
aragraphs (meaning 25 sentences or more). Your assignment may be more than 5 paragraphs but not less.
INSTRUCTIONS:
To access the FNU Online Library for journals and articles you can go the FNU library link here:
https://www.fnu.edu/library/
In order to
n that draws upon the theoretical reading to explain and contextualize the design choices. Be sure to directly quote or paraphrase the reading
ce to the vaccine. Your campaign must educate and inform the audience on the benefits but also create for safe and open dialogue. A key metric of your campaign will be the direct increase in numbers.
Key outcomes: The approach that you take must be clear
Mechanical Engineering
Organic chemistry
Geometry
nment
Topic
You will need to pick one topic for your project (5 pts)
Literature search
You will need to perform a literature search for your topic
Geophysics
you been involved with a company doing a redesign of business processes
Communication on Customer Relations. Discuss how two-way communication on social media channels impacts businesses both positively and negatively. Provide any personal examples from your experience
od pressure and hypertension via a community-wide intervention that targets the problem across the lifespan (i.e. includes all ages).
Develop a community-wide intervention to reduce elevated blood pressure and hypertension in the State of Alabama that in
in body of the report
Conclusions
References (8 References Minimum)
*** Words count = 2000 words.
*** In-Text Citations and References using Harvard style.
*** In Task section I’ve chose (Economic issues in overseas contracting)"
Electromagnetism
w or quality improvement; it was just all part of good nursing care. The goal for quality improvement is to monitor patient outcomes using statistics for comparison to standards of care for different diseases
e a 1 to 2 slide Microsoft PowerPoint presentation on the different models of case management. Include speaker notes... .....Describe three different models of case management.
visual representations of information. They can include numbers
SSAY
ame workbook for all 3 milestones. You do not need to download a new copy for Milestones 2 or 3. When you submit Milestone 3
pages):
Provide a description of an existing intervention in Canada
making the appropriate buying decisions in an ethical and professional manner.
Topic: Purchasing and Technology
You read about blockchain ledger technology. Now do some additional research out on the Internet and share your URL with the rest of the class
be aware of which features their competitors are opting to include so the product development teams can design similar or enhanced features to attract more of the market. The more unique
low (The Top Health Industry Trends to Watch in 2015) to assist you with this discussion.
https://youtu.be/fRym_jyuBc0
Next year the $2.8 trillion U.S. healthcare industry will finally begin to look and feel more like the rest of the business wo
evidence-based primary care curriculum. Throughout your nurse practitioner program
Vignette
Understanding Gender Fluidity
Providing Inclusive Quality Care
Affirming Clinical Encounters
Conclusion
References
Nurse Practitioner Knowledge
Mechanics
and word limit is unit as a guide only.
The assessment may be re-attempted on two further occasions (maximum three attempts in total). All assessments must be resubmitted 3 days within receiving your unsatisfactory grade. You must clearly indicate “Re-su
Trigonometry
Article writing
Other
5. June 29
After the components sending to the manufacturing house
1. In 1972 the Furman v. Georgia case resulted in a decision that would put action into motion. Furman was originally sentenced to death because of a murder he committed in Georgia but the court debated whether or not this was a violation of his 8th amend
One of the first conflicts that would need to be investigated would be whether the human service professional followed the responsibility to client ethical standard. While developing a relationship with client it is important to clarify that if danger or
Ethical behavior is a critical topic in the workplace because the impact of it can make or break a business
No matter which type of health care organization
With a direct sale
During the pandemic
Computers are being used to monitor the spread of outbreaks in different areas of the world and with this record
3. Furman v. Georgia is a U.S Supreme Court case that resolves around the Eighth Amendments ban on cruel and unsual punishment in death penalty cases. The Furman v. Georgia case was based on Furman being convicted of murder in Georgia. Furman was caught i
One major ethical conflict that may arise in my investigation is the Responsibility to Client in both Standard 3 and Standard 4 of the Ethical Standards for Human Service Professionals (2015). Making sure we do not disclose information without consent ev
4. Identify two examples of real world problems that you have observed in your personal
Summary & Evaluation: Reference & 188. Academic Search Ultimate
Ethics
We can mention at least one example of how the violation of ethical standards can be prevented. Many organizations promote ethical self-regulation by creating moral codes to help direct their business activities
*DDB is used for the first three years
For example
The inbound logistics for William Instrument refer to purchase components from various electronic firms. During the purchase process William need to consider the quality and price of the components. In this case
4. A U.S. Supreme Court case known as Furman v. Georgia (1972) is a landmark case that involved Eighth Amendment’s ban of unusual and cruel punishment in death penalty cases (Furman v. Georgia (1972)
With covid coming into place
In my opinion
with
Not necessarily all home buyers are the same! When you choose to work with we buy ugly houses Baltimore & nationwide USA
The ability to view ourselves from an unbiased perspective allows us to critically assess our personal strengths and weaknesses. This is an important step in the process of finding the right resources for our personal learning style. Ego and pride can be
· By Day 1 of this week
While you must form your answers to the questions below from our assigned reading material
CliftonLarsonAllen LLP (2013)
5 The family dynamic is awkward at first since the most outgoing and straight forward person in the family in Linda
Urien
The most important benefit of my statistical analysis would be the accuracy with which I interpret the data. The greatest obstacle
From a similar but larger point of view
4 In order to get the entire family to come back for another session I would suggest coming in on a day the restaurant is not open
When seeking to identify a patient’s health condition
After viewing the you tube videos on prayer
Your paper must be at least two pages in length (not counting the title and reference pages)
The word assimilate is negative to me. I believe everyone should learn about a country that they are going to live in. It doesnt mean that they have to believe that everything in America is better than where they came from. It means that they care enough
Data collection
Single Subject Chris is a social worker in a geriatric case management program located in a midsize Northeastern town. She has an MSW and is part of a team of case managers that likes to continuously improve on its practice. The team is currently using an
I would start off with Linda on repeating her options for the child and going over what she is feeling with each option. I would want to find out what she is afraid of. I would avoid asking her any “why” questions because I want her to be in the here an
Summarize the advantages and disadvantages of using an Internet site as means of collecting data for psychological research (Comp 2.1) 25.0\% Summarization of the advantages and disadvantages of using an Internet site as means of collecting data for psych
Identify the type of research used in a chosen study
Compose a 1
Optics
effect relationship becomes more difficult—as the researcher cannot enact total control of another person even in an experimental environment. Social workers serve clients in highly complex real-world environments. Clients often implement recommended inte
I think knowing more about you will allow you to be able to choose the right resources
Be 4 pages in length
soft MB-920 dumps review and documentation and high-quality listing pdf MB-920 braindumps also recommended and approved by Microsoft experts. The practical test
g
One thing you will need to do in college is learn how to find and use references. References support your ideas. College-level work must be supported by research. You are expected to do that for this paper. You will research
Elaborate on any potential confounds or ethical concerns while participating in the psychological study 20.0\% Elaboration on any potential confounds or ethical concerns while participating in the psychological study is missing. Elaboration on any potenti
3 The first thing I would do in the family’s first session is develop a genogram of the family to get an idea of all the individuals who play a major role in Linda’s life. After establishing where each member is in relation to the family
A Health in All Policies approach
Note: The requirements outlined below correspond to the grading criteria in the scoring guide. At a minimum
Chen
Read Connecting Communities and Complexity: A Case Study in Creating the Conditions for Transformational Change
Read Reflections on Cultural Humility
Read A Basic Guide to ABCD Community Organizing
Use the bolded black section and sub-section titles below to organize your paper. For each section
Losinski forwarded the article on a priority basis to Mary Scott
Losinksi wanted details on use of the ED at CGH. He asked the administrative resident