In: Finance
MCDONALDS balance sheet.
Fiscal year is January-December. All values USD millions. | 2014 | 2015 | 2016 | 2017 | 2018 | 5-year trend |
---|---|---|---|---|---|---|
Cash & Short Term Investments | 2.08B | 7.69B | 1.22B | 2.46B | 866M | |
Cash Only | 2.08B | 7.69B | 1.22B | 2.46B | 866M | |
Short-Term Investments | - | - | - | - | - | |
Total Accounts Receivable | 1.21B | 1.3B | 1.47B | 1.98B | 2.44B | |
Accounts Receivables, Net | 1.21B | 1.3B | 1.47B | 1.98B | 2.44B | |
Accounts Receivables, Gross | 1.21B | 1.3B | 1.47B | 1.98B | 2.44B | |
Bad Debt/Doubtful Accounts | - | - | - | - | - | |
Other Receivables | - | - | - | - | - | |
Inventories | 110M | 100.1M | 58.9M | 58.8M | 51.1M | |
Finished Goods | 110M | 100.1M | 58.9M | 58.8M | 51.1M | |
Work in Progress | - | - | - | - | - | |
Raw Materials | - | - | - | - | - | |
Progress Payments & Other | - | - | - | - | - | |
Other Current Assets | 783.2M | 558.7M | 2.09B | 828.4M | 694.6M | |
Miscellaneous Current Assets | 783.2M | 558.7M | 2.09B | 828.4M | 694.6M | |
Total Current Assets | 4.19B | 9.64B | 4.85B | 5.33B | 4.05B |
2014 | 2015 | 2016 | 2017 | 2018 | 5-year trend | |
---|---|---|---|---|---|---|
Net Property, Plant & Equipment | 24.56B | 23.12B | 21.26B | 22.45B | 22.84B | |
Property, Plant & Equipment - Gross | 39.13B | 37.69B | 34.44B | 36.63B | 37.19B | |
Buildings | 27.61B | 26.9B | 25.21B | 27.29B | 28.24B | |
Land & Improvements | 5.79B | 5.58B | 5.47B | 5.66B | 5.52B | |
Computer Software and Equipment | - | - | - | - | - | |
Other Property, Plant & Equipment | 617.5M | 546.8M | 500.4M | 512.4M | 488.6M | |
Accumulated Depreciation | 14.57B | 14.57B | 13.19B | 14.18B | 14.35B | |
Total Investments and Advances | 1B | 792.7M | 725.9M | 1.09B | 1.2B | |
Other Long-Term Investments | - | - | - | - | - | |
Long-Term Note Receivable | - | - | - | - | - | |
Intangible Assets | 2.74B | 2.52B | 2.34B | 2.38B | 2.33B | |
Net Goodwill | 2.74B | 2.52B | 2.34B | 2.38B | 2.33B | |
Net Other Intangibles | - | - | - | - | - | |
Other Assets | 1.21B | 1.34B | 1.05B | 1.69B | 1.16B | |
Tangible Other Assets | 1.21B | 1.34B | 1.05B | 1.69B | 1.16B | |
Total Assets | 34.28B | 37.94B | 31.02B | 33.8B | 32.81B |
Liabilities & Shareholders' Equity
2014 | 2015 | 2016 | 2017 | 2018 | 5-year trend | |
---|---|---|---|---|---|---|
ST Debt & Current Portion LT Debt | - | - | 77.2M | - | - | |
Short Term Debt | - | - | - | - | - | |
Current Portion of Long Term Debt | - | - | 77.2M | - | - | |
Accounts Payable | 860.1M | 874.7M | 756M | 924.8M | 1.21B | |
Income Tax Payable | 166.8M | 154.8M | 267.2M | 265.8M | 228.3M | |
Other Current Liabilities | 1.72B | 1.92B | 2.37B | 1.7B | 1.54B | |
Dividends Payable | - | - | - | - | - | |
Accrued Payroll | 1.16B | 1.38B | 1.16B | 1.15B | 986.6M | |
Miscellaneous Current Liabilities | 563.7M | 542.1M | 1.21B | 553.8M | 550.7M | |
Total Current Liabilities | 2.75B | 2.95B | 3.47B | 2.89B | 2.97B | |
Long-Term Debt | 14.99B | 24.12B | 25.88B | 29.54B | 31.08B | |
Long-Term Debt excl. Capitalized Leases | 14.99B | 24.12B | 25.88B | 29.54B | 31.08B | |
Non-Convertible Debt | 14.99B | 24.12B | 25.88B | 29.54B | 31.08B | |
Convertible Debt | - | - | - | - | - | |
Capitalized Lease Obligations | - | - | - | - | - | |
Provision for Risks & Charges | - | - | - | - | - | |
Deferred Taxes | 1.03B | 1.17B | 1.01B | 251.5M | (3.9M) | |
Deferred Taxes - Credit | 1.62B | 1.7B | 1.82B | 1.12B | 1.22B | |
Deferred Taxes - Debit | 591.2M | 532.8M | 804M | 867.9M | 1.22B | |
Other Liabilities | 2.07B | 2.07B | 2.06B | 3.53B | 3.81B | |
Other Liabilities (excl. Deferred Income) | 2.07B | 2.07B | 2.06B | 3.53B | 3.18B | |
Deferred Income | - | - | - | - | 627.8M | |
Total Liabilities | 21.43B | 30.85B | 33.23B | 37.07B | 39.07B | |
Non-Equity Reserves | - | - | - | - | - | |
Preferred Stock (Carrying Value) | - | - | - | - | - | |
Redeemable Preferred Stock | - | - | - | - | - | |
Non-Redeemable Preferred Stock | - | - | - | - | - | |
Common Equity (Total) | 12.85B | 7.09B | (2.2B) | (3.27B) | (6.26B) | |
Common Stock Par/Carry Value | 16.6M | 16.6M | 16.6M | 16.6M | 16.6M | |
Retained Earnings | 43.29B | 44.59B | 46.22B | 48.33B | 50.49B | |
ESOP Debt Guarantee | - | - | - | - | - | |
Cumulative Translation Adjustment/Unrealized For. Exch. Gain | (1.38B) | (2.73B) | (2.91B) | (1.97B) | (2.43B) | |
Unrealized Gain/Loss Marketable Securities | - | - | - | - | - | |
Revaluation Reserves | - | - | - | - | - | |
Treasury Stock | (35.18B) | (41.18B) | (52.11B) | (56.5B) | (61.53B) | |
Total Shareholders' Equity | 12.85B | 7.09B | (2.2B) | (3.27B) | (6.26B) | |
Accumulated Minority Interest | - | - | - | - | - | |
Total Equity | 12.85B | 7.09B | (2.2B) | (3.27B) | (6.26B) | |
Liabilities & Shareholders' Equity | 34.28B | 37.94B | 31.02B | 33.8B | 32.81B |
*Question* for years ((**2015-2018**)) please show work , please and thank you :)
What is Mcdonald's 1) current ratio 2) debt-equity ratio 3) profit margin 4) return on assets (ROA) 5) return on equity (ROE) 6) Use the Dupont identity to calculate total assets turnover (TAT).
PARTICULARS | 2015 | 2016 | 2017 | 2018 |
A.TOTAL CURRENT ASSET | 9.64 | 4.85 | 5.33 | 4.05 |
B.TOTAL CURRENT LIABILITIES | 2.95 | 3.47 | 2.89 | 2.97 |
*CURRENT RATIO = CURRENT ASSET/CURRENT LIABILITIES | 3.27 | 1.40 | 1.84 | 1.36 |
C.TOTAL LIABILITIES | 30.85 | 33.23 | 37.07 | 39.07 |
D.TOTAL SHAREHOLDER'S EQUITY | 7.09 | -2.20 | -3.27 | -6.26 |
*DEBT EQUITY RATIO=TOTAL LIABILITIES/TOTAL SHAREHOLDER'S EQUITY | 4.35 | -15.10 | -11.34 | -6.24 |
D.NET INCOME = RETAINED EARNING OF CURRENT YEAR - PREVIOUS YEAR | =44.59-43.29 | =46.22-44.59 | =48.33-46.22 | =50.49-48.33 |
1.30 | 1.63 | 2.11 | 2.16 | |
E.NET SALES(ASSUMING ALL CREDIT SALES) | =1.3-1.21 | =1.47-1.3 | =1.98-1.47 | =2.44-1.98 |
0.09 | 0.17 | 0.51 | 0.46 | |
*PROFIT MARGIN=NET INCOME/NET SALES | 14.44 | 9.59 | 4.14 | 4.70 |
F.AVERAGE TOTAL ASSET | =(34.28+37.94)/2 | =(37.94+31.02)/2 | =(33.8+31.02)/2 | =(32.81+33.8)/2 |
36.11 | 34.48 | 32.41 | 33.31 | |
*RETURN ON ASSET=NET INCOME/AVERAGE TOTAL ASSET | 0.04 | 0.05 | 0.07 | 0.06 |
G.AVERAGE SHAREHOLDERS EQUITY | =(7.09+12.85)/2 | =(7.09-2.2)/2 | =-(2.2+3.27)/2 | =-(6.26+3.27)/2 |
9.97 | 2.45 | 2.74 | 4.77 | |
*RETURN ON EQUITY=AVERAGE SHAREHOLDERS EQUITY/NET INOCOME | 7.67 | 1.50 | 1.30 | 2.21 |
F.ASSET TURNOVER=SALES/AVERAGE TOTAL ASSETS | 0.002 | 0.005 | 0.02 | 0.01 |
G.EQUITY MULTIPLIER=AVERAGE TOTAL ASSETS/AVERAGE SHAREHOLDERS EQUITY | 3.62 | 14.07 | 11.83 | 6.98 |
*DUPONT ANALYSIS=NET PROFIT MARGIN*ASSET TURNOVER*EQUITY MULTIPLIER | 0.13 | 0.67 | 0.77 | 0.45 |