Question

In: Finance

MCDONALDS balance sheet. Fiscal year is January-December. All values USD millions. 2014 2015 2016 2017 2018...

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).

Solutions

Expert Solution

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

Related Solutions

Dominos balance sheet Fiscal year is January-December. All values USD millions. 2014 2015 2016 2017 2018...
Dominos balance sheet Fiscal year is January-December. All values USD millions. 2014 2015 2016 2017 2018 5-year trend Cash & Short Term Investments 151.81M 314.39M 169.31M 227.53M 237.42M Cash Only 151.81M 314.39M 169.31M 227.53M 237.42M Short-Term Investments - - - - - Total Accounts Receivable 118.4M 131.58M 150.37M 173.68M 190.09M Accounts Receivables, Net 118.4M 131.58M 150.37M 173.68M 190.09M Accounts Receivables, Gross 121.76M 134.24M 152.71M 175.1M 191.97M Bad Debt/Doubtful Accounts (3.36M) (2.66M) (2.34M) (1.42M) (1.88M) Other Receivables - - - -...
WIPER, INC. Condensed Balance Sheets December 31, 2017, 2016, 2015 (in millions) 2017 2016 2015 Current...
WIPER, INC. Condensed Balance Sheets December 31, 2017, 2016, 2015 (in millions) 2017 2016 2015 Current assets $ 683 $ 915 $ 763 Other assets 2,416 1,923 1,722 Total assets $ 3,099 $ 2,838 $ 2,485 Current liabilities $ 576 $ 806 $ 713 Long-term liabilities 1,513 1,003 851 Stockholders’ equity 1,010 1,029 921 Total liabilities and stockholders' equity $ 3,099 $ 2,838 $ 2,485 WIPER, INC Selected Income Statement and Other Data For the year Ended December 31, 2017...
Perform a horizontal analysis of the Balance Sheet. Fiscal year ends in June. USD in millions...
Perform a horizontal analysis of the Balance Sheet. Fiscal year ends in June. USD in millions except per share data. 2016-06 2017-06 2018-06 Assets 193,694 241,086 258,848 Current assets 139,660 159,851 169,662 Cash 113,240 132,981 133,768 Cash and cash equivalents 6,510 7,663 11,946 Short-term investments 106,730 125,318 121,822 Total cash 113,240 132,981 133,768 Receivables 18,277 19,792 26,481 Inventories 2,251 2,181 2,662 Deferred income taxes Other current assets 5,892 4,897 6,751 Total current assets 139,660 159,851 169,662 Non-current assets Property, plant...
CONSOLIDATED BALANCE SHEET (millions of dollars) 2016 2015 Assets 2016 2015 Current assets 2016 2015 Cash...
CONSOLIDATED BALANCE SHEET (millions of dollars) 2016 2015 Assets 2016 2015 Current assets 2016 2015 Cash and cash equivalents 3,657 3,705 Notes and accounts receivable 21,394 19,875 Inventories: Crude oil, products and merchandise 10,877 12,037 Materials and supplies 4,203 4,208 Other current assets 1,285 2,798      Total current assets 41,416 42,623 Crude oil, products and merchandise inventories are carried at the lower of current market value or cost (generally determined under the last-in, first-out method – LIFO). Inventory costs include...
LAKE OF EGYPT MARINA, INC. Balance Sheet as of December 31, 2018 and 2017 (in millions...
LAKE OF EGYPT MARINA, INC. Balance Sheet as of December 31, 2018 and 2017 (in millions of dollars) 2018 2017 2018 2017 Assets Liabilities and Equity Current assets: Current liabilities: Cash and marketable securities $ 100 $ 48 Accrued wages and taxes $ 60 $ 48 Accounts receivable 110 72 Accounts payable 110 72 Inventory 301 174 Notes payable 70 60 Total $ 511 $ 294 Total $ 240 $ 180 Fixed assets: Long-term debt: $ 429 $ 237 Gross...
ARDUOUS COMPANY Comparative Balance Sheets December 31, 2016 and 2015 ($ in millions) 2016 2015   Assets...
ARDUOUS COMPANY Comparative Balance Sheets December 31, 2016 and 2015 ($ in millions) 2016 2015   Assets   Cash $ 116    $ 81      Accounts receivable 190    194      Investment revenue receivable 6    4      Inventory 205    200      Prepaid insurance 4    8      Long-term investment 156    125      Land 196    150      Buildings and equipment 412    400          Less: Accumulated depreciation (97) (120)   Patent 30    32    $ 1,218    $ 1,074...
2018 2017 2016 2015 2014 Sales $ 80,000 $ 73,000 $ 61,000 $ 57,000 $ 50,000...
2018 2017 2016 2015 2014 Sales $ 80,000 $ 73,000 $ 61,000 $ 57,000 $ 50,000 Cost of goods sold 72,600 53,400 45,600 33,300 30,000 Dollar amounts stated above are in thousands. a. Compute trend percentages for the above items taken from the financial statements of Lopez Plumbing over a five-year period. Treat 2014 as the base year. b. State whether the trends are favorable or unfavorable. Required A Required B Compute trend percentages for the above items taken from...
2018 2017 2016 2015 2014 Sales $ 672,729 $ 434,019 $ 347,215 $ 242,808 $ 181,200...
2018 2017 2016 2015 2014 Sales $ 672,729 $ 434,019 $ 347,215 $ 242,808 $ 181,200 Cost of goods sold 332,087 214,419 173,535 120,176 88,788 Accounts receivable 32,560 25,434 23,715 14,180 12,376 Compute trend percents for the above accounts, using 2014 as the base year. (Round the percents to whole numbers.)
Beltway Technologies: Balance Sheet for the Year Ended December 31, 2017 (in Millions of Dollars) Cash...
Beltway Technologies: Balance Sheet for the Year Ended December 31, 2017 (in Millions of Dollars) Cash Accounts receivable Inventory      Current assets Net fixed assets Total assets $    5.1 26.4     56.1 $ 87.6     26.3 $113.9 Accounts payable Accruals Notes payable     Current liabilities Long-term debt Preferred stock Common stock Total claims $   3.8 5.9      1.3 $10.1 40.8 9.7    53.3 $113.9 To begin, Bill reviewed Beltway's 2017 balance sheet, which is contained in Table 1. Next, Bill...
Jafan Retailing, Balance Sheet Statement December 31, 2016 & December 31, 2017 2016 2017 Cash $   ...
Jafan Retailing, Balance Sheet Statement December 31, 2016 & December 31, 2017 2016 2017 Cash $    235,000 $    400,000 Accounts Receivable        367,200        325,000 Inventory        450,000        500,200 Prepaid Expenses        120,000        160,000 Long-term investment        100,000        300,000 Equiptment (Net)     1,050,000     1,125,000 Total Assets $ 2,322,200 $ 2,810,200 Accounts Payable $    421,000 $    411,000 Salary Payable        134,000        180,000 Interest Payable        110,000        112,000 Bonds Payable        550,000        560,000 Common Shares...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT