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

Free

50.1K

Verified Solution

Question

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)) pleaseshow work , please and thank you :)
What is Mcdonald's 1) current ratio 2)debt-equity ratio 3) profitmargin 4) return on assets (ROA) 5)return on equity (ROE) 6) Use the Dupontidentity to calculate total assets turnover (TAT).

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

	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

Answer & Explanation Solved by verified expert

4.4 Ratings (833 Votes)

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

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

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

Free

50.1K

Verified Solution

Question

Finance

Answer & Explanation Solved by verified expert

Get Answers to Unlimited Questions

Membership Benefits:

Transcribed Image Text

Other questions asked by students