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

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 MARGINASSET TURNOVER*EQUITY MULTIPLIER	0.13	0.67	0.77	0.45

jeff jeffy answered 1 year ago

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

Question