Discussion

WK4Spreadsheet.xlsx

Home >Business & Finance homework help >Financial markets homework help >Discussion

INCOME STATEMENT

Best Buy Co., Inc.
Consolidated Statements of Earnings
$ and shares in millions, except per share amounts
BBY
Retail industry
Products: Consumer electronics and appliances
Competitors: WalMart, Target, Costco, Amazon, Sears and Staples
Fiscal Years Ended	1-Feb-20	2-Feb-19	3-Feb-18
Revenue	$	43,638	$	42,879	$	42,151
Cost of sales	33,590	32,918	32,275
Gross profit	$ 10,048.0	$ 9,961	$ 9,876.00
Selling, general and administrative expenses	7,998	8,015	8,023
Restructuring charges	41	46	10
Operating income	$ 2,009	$ 1,900	1843
Other income (expense):
Gain on sale of investments	1	12	1
Investment income and other	47	49	48
Interest expense	-64	-73	-75
Earnings from continuing operations before income tax expense	$ 1,993	$ 1,888	$ 1,817
Income tax expense	452	424	818
Net earnings from continuing operations	$ 1,541	$ 1,464	$ 999
Gain from discontinued operations, net of $0 tax expense	-	-	1
Net earnings	$	$ 1,541	$	$ 1,464	$	$ 1,000

BALANCE SHEET

Best Buy Co., Inc.
Consolidated Balance Sheets
$ in millions, except per share and share amounts
BBY
Retail industry
Products: Consumer electronics and appliances
Competitors: WalMart, Target, Costco, Amazon, Sears and Staples
1-Feb-20	2-Feb-19
Assets
Current assets
Cash and cash equivalents	$	2,229	$	1,980
Receivables, net	1,149	1,015
Merchandise inventories	5,174	5,409
Other current assets	305	466
Total current assets	$ 8,857	$ 8,870
Property and equipment
Land and buildings	650	637
Leasehold improvements	2,203	2,119
Fixtures and equipment	6,286	5,865
Property under capital and financing leases	-	579
Property under finance leases	89	-
Gross property and equipment	$ 9,228	$ 9,200
Less accumulated depreciation	6,900	6,690
Net property and equipment	$ 2,328	$ 2,510
Operating lease assets	2,709	-
Goodwill	984	915
Other assets	713	606
Total assets	$	15591	$	12901
Liabilities and equity
Current liabilities
Accounts payable	$	5,288	$	5,257
Unredeemed gift card liabilities	281	290
Deferred revenue	501	446
Accrued compensation and related expenses	410	482
Accrued liabilities	906	982
Current portion of operating lease liabilities	660	-
Current portion of long-term debt	14	56
Total current liabilities	8060	7513
Long-term operating lease liabilities	2,138	-
Long-term liabilities	657	750
Long-term debt	1,257	1,332
Contingencies and commitments (Note 13)
Equity
Best Buy Co., Inc. Shareholders' Equity
Preferred stock, $1.00 par value: Authorized 400,000 shares; Issued and outstanding none	-	-
Common stock, $0.10 par value: Authorized 1.0 billion shares; Issued and outstanding 256,494,000 and 265,703,000 shares, respectively	26	27
Additional paid-in capital	-	-
Retained earnings	3,158	2,985
Accumulated other comprehensive income	295	294
Total equity	3479	3306
Total liabilities and equity	$	15591	$	12901

CASH FLOW

Best Buy Co., Inc.
Consolidated Statements of Cash Flows
$ in millions
BBY
Retail industry
Products: Consumer electronics and appliances
Competitors: WalMart, Target, Costco, Amazon, Sears and Staples
Fiscal Years Ended	1-Feb-20	2-Feb-19	3-Feb-18
Operating activities
Net earnings	$	1,541	$	1,464	$	1,000
Adjustments to reconcile net earnings to total cash provided by operating activities:
Depreciation and amortization	812	770	683
Restructuring charges	41	46	10
Stock-based compensation	143	123	129
Deferred income taxes	70	10	162
Other, net	21	-25	-13
Changes in operating assets and liabilities, net of acquired assets and liabilities:
Receivables	-131	28	315
Merchandise inventories	237	-194	-335
Other assets	16	-34	-21
Accounts payable	47	432	-196
Income taxes	-132	22	290
Other liabilities	-100	-234	117
Total cash provided by operating activities	2565	2408	2,141
Investing activities
Additions to property and equipment, net of $10, $53 and $123, respectively, of non-cash capital expenditures	-743	-819	-688
Purchases of investments	-330	-	-4,325
Sales of investments	322	2,098	4,018
Acquisitions, net of cash acquired	-145	-787	-
Other, net	1	16	-7
Total cash provided by (used in) investing activities	-895	508	-1,002
Financing activities
Repurchase of common stock	-1,003	-1,505	-2,004
Issuance of common stock	48	38	163
Dividends paid	-527	-497	-409
Borrowings of debt	-	498	-
Repayments of debt	-15	-546	-46
Other, net	-1	-6	-1
Total cash used in financing activities	-1,498	-2,018	-2,297
Effect of exchange rate changes on cash	-1	-14	25
Increase (decrease) in cash, cash equivalents and restricted cash	171	884	-1,133
Cash, cash equivalents and restricted cash at beginning of period	2,184	1,300	2,433
Cash, cash equivalents and restricted cash at end of period	$	2355	$	2184	$	1300
References
Best Buy Co., Inc. (2020). Best Buy Co., Inc. (BBY). Yahoo Finance - Stock Market Live, Quotes, Business & Finance News. https://finance.yahoo.com/quote/BBY/cash-flow?p=BBY
UNITED STATES SECURITIES AND EXCHANGE COMMISSION. (2020, February 1). Inline XBRL viewer. SEC.gov. https://www.sec.gov/ix?doc=/Archives/edgar/data/764478/000076447820000017/bby-20200201x10k.htm

https://finance.yahoo.com/quote/BBY/cash-flow?p=BBY https://www.sec.gov/ix?doc=/Archives/edgar/data/764478/000076447820000017/bby-20200201x10k.htm

McDonald IS

McDonald income statement
value uin USD million
Fiscal year is January-December. All values USD Millions.	2019	2018	2017
Sales/Revenue	21,077	21,025	22,820
Sales Growth	0.24%	-7.87%	-7.32%
Cost of Goods Sold (COGS) incl. D&A	9,961	10,239	12,200
COGS excluding D&A	8,343	8,757	10,836
Depreciation & Amortization Expense	1,618	1,482	1,363
Depreciation	1,392	1,303	1,228
Amortization of Intangibles	226	179	136
COGS Growth	-2.72%	-16.07%	-15.38%
Gross Income	11,115	10,786	10,621
Gross Income Growth	3.05%	1.56%	4.08%
Gross Profit Margin	52.74%	-	-
SG&A Expense	2,301	2,200	2,231
Other SG&A	2,301	2,200	2,231
SGA Growth	4.59%	-1.39%	-6.42%
EBIT	8,814	8,586	8,390
Unusual Expense	-23	209	-771
Non Operating Income/Expense	122	264	143
Non-Operating Interest Income	37	4	7
Equity in Affiliates (Pretax)	154	152	184
Interest Expense	1,132	980	921
Interest Expense Growth	15.54%	6.43%	4.13%
Gross Interest Expense	1,140	986	926
Interest Capitalized	7	6	5
Pretax Income	8,018	7,816	8,574
Pretax Income Growth	2.58%	-8.83%	24.87%
Pretax Margin	38.04%	-	-
Income Tax	1,993	1,892	3,381
Income Tax - Current Domestic	717	477	2,201
Income Tax - Current Foreign	1,127	1,312	1,217
Income Tax - Deferred Domestic	59	164	-107
Income Tax - Deferred Foreign	91	-62	71
Consolidated Net Income	6,025	5,924	5,192
Net Income	6,025	5,924	5,192
Net Income Growth	1.71%	14.10%	10.79%
Net Margin	28.59%	-	-
Net Income After Extraordinaries	6,025	5,924	5,192
Net Income Available to Common	6,025	5,924	5,192
EPS (Basic)	7.88	7.54	6.37
EPS (Basic) Growth	4.47%	18.37%	17.10%
Basic Shares Outstanding	758	778	807
EPS (Diluted)	7.88	7.54	6.37
EPS (Diluted) Growth	4.46%	18.44%	17.00%
Diluted Shares Outstanding	765	786	816
EBITDA	10,432	10,068	9,753
EBITDA Growth	3.62%	3.23%	4.46%
EBITDA Margin	49.50%	-	-
EBIT	8,814	8,586	8,390

McDonald BS

McDonald income statement
value uin USD million
Fiscal year is January-December. All values USD Millions.	2019	2018	2017
Cash & Short Term Investments	899	866	2,464
Cash Only	899	866	2,464
Cash & Short Term Investments Growth	3.75%	-64.85%	101.39%
Cash & ST Investments / Total Assets	1.89%	2.64%	7.29%
Total Accounts Receivable	2,224	2,442	1,976
Accounts Receivables, Net	2,224	2,442	1,976
Accounts Receivables, Gross	2,224	2,442	1,976
Accounts Receivable Growth	-8.90%	23.55%	34.06%
Accounts Receivable Turnover	9.48	8.61	11.55
Inventories	50	51	59
Finished Goods	50	51	59
Other Current Assets	385	695	828
Miscellaneous Current Assets	385	695	828
Total Current Assets	3,558	4,053	5,327
Net Property, Plant & Equipment	37,421	22,843	22,448
Property, Plant & Equipment - Gross	52,312	37,194	36,626
Buildings	29,610	28,241	27,286
Land & Improvements	6,026	5,521	5,662
Machinery & Equipment	2,995	2,943	3,166
Other Property, Plant & Equipment	420	489	512
Accumulated Depreciation	14,891	14,351	14,178
Total Investments and Advances	1,471	1,207	1,253
LT Investment - Affiliate Companies	1,270	1,203	1,086
Other Long-Term Investments	201	4	167
Intangible Assets	2,677	2,332	2,380
Net Goodwill	2,677	2,332	2,380
Other Assets	1,244	1,158	1,528
Tangible Other Assets	1,244	1,158	1,528
Total Assets	47,511	32,811	33,804
Assets - Total - Growth	44.80%	-2.94%	8.96%
Asset Turnover	0.52	-	-
Return On Average Assets	15.00%	-	-
Liabilities & Shareholders' Equity
All values USD Millions.	2019	2018	2017
ST Debt & Current Portion LT Debt	680	-	-
Short Term Debt	621	-	-
Current Portion of Long Term Debt	59	-	-
Accounts Payable	988	1,208	925
Accounts Payable Growth	-18.19%	30.61%	22.33%
Income Tax Payable	332	228	266
Other Current Liabilities	1,621	1,537	1,700
Accrued Payroll	1,026	983	1,108
Miscellaneous Current Liabilities	595	554	592
Total Current Liabilities	3,621	2,974	2,891
Current Ratio	0.98	1.36	1.84
Quick Ratio	0.97	1.35	1.82
Cash Ratio	0.25	0.29	0.85
Long-Term Debt	46,876	31,075	29,536
Long-Term Debt excl. Capitalized Leases	34,118	31,075	29,536
Non-Convertible Debt	34,118	31,075	29,536
Deferred Taxes	179	-4	252
Deferred Taxes - Credit	1,318	1,216	1,119
Deferred Taxes - Debit	1,139	1,219	868
Other Liabilities	3,906	3,805	3,525
Other Liabilities (excl. Deferred Income)	3,246	3,178	3,525
Deferred Income	661	628	-
Total Liabilities	55,721	39,070	37,072
Total Liabilities / Total Assets	117.28%	119.07%	109.67%
Common Equity (Total)	-8,210	-6,258	-3,268
Common Stock Par/Carry Value	17	17	17
Additional Paid-In Capital/Capital Surplus	7,654	7,376	7,072
Retained Earnings	52,931	50,487	48,326
Cumulative Translation Adjustment/Unrealized For. Exch. Gain	-2,251	-2,425	-1,972
Other Appropriated Reserves	-232	-184	-207
Treasury Stock	-66,329	-61,529	-56,504
Common Equity / Total Assets	-17.28%	-19.07%	-9.67%
Total Shareholders' Equity	-8,210	-6,258	-3,268
Total Shareholders' Equity / Total Assets	-17.28%	-19.07%	-9.67%
Total Equity	-8,210	-6,258	-3,268
Liabilities & Shareholders' Equity	47,511	32,811	33,804

McDonald CF

Fiscal year is January-December. All values USD Millions.	2019	2018	2017	2016	2015	5-year trend
Net Income before Extraordinaries	6,025	5,924	5,192	4,687	4,529
Net Income Growth	1.71%	14.10%	10.79%	3.47%	-
Depreciation, Depletion & Amortization	1,618	1,482	1,363	1,517	1,556
Depreciation and Depletion	1,392	1,303	1,228	1,391	1,438
Amortization of Intangible Assets	226	179	136	126	118
Deferred Taxes & Investment Tax Credit	150	103	-36	-539	-1
Deferred Taxes	150	103	-36	-539	-1
Other Funds	31	-70	12	228	288
Funds from Operations	7,824	7,439	6,532	5,893	6,371
Changes in Working Capital	299	-473	-981	167	168
Receivables	27	-479	-341	-159	-181
Accounts Payable	-27	129	-60	90	-15
Income Taxes Payable	173	-33	-396	170	-64
Other Accruals	-4	-87	-146	38	383
Other Assets/Liabilities	129	-2	-37	28	45
Net Operating Cash Flow	8,122	6,967	5,551	6,060	6,539
Net Operating Cash Flow Growth	16.58%	25.50%	-8.39%	-7.33%	-
Net Operating Cash Flow / Sales	38.54%	33.13%	24.33%	24.61%	25.73%
Investing Activities
All values USD Millions.	2019	2018	2017	2016	2015	5-year trend
Capital Expenditures	-2,394	-2,742	-1,854	-1,821	-1,814
Capital Expenditures (Fixed Assets)	-2,394	-2,742	-1,854	-1,821	-1,814
Capital Expenditures Growth	12.69%	-47.90%	-1.79%	-0.40%	-
Capital Expenditures / Sales	-11.36%	-13.04%	-8.12%	-7.40%	-7.14%
Net Assets from Acquisitions	-541	-102	-77	-110	-141
Sale of Fixed Assets & Businesses	492	691	2,739	1,059	554
Other Uses	-629	-303	-72	-284	-20
Net Investing Cash Flow	-3,071	-2,455	736	-1,156	-1,420
Net Investing Cash Flow Growth	-25.09%	-433.57%	163.69%	18.62%	-
Net Investing Cash Flow / Sales	-14.57%	-11.68%	3.23%	-4.69%	-5.59%
Financing Activities
All values USD Millions.	2019	2018	2017	2016	2015	5-year trend
Cash Dividends Paid - Total	-3,582	-3,256	-3,089	-3,058	-3,230
Common Dividends	-3,582	-3,256	-3,089	-3,058	-3,230
Change in Capital Stock	-4,626	-4,805	-4,229	-10,872	-5,782
Repurchase of Common & Preferred Stk.	-4,976	-5,208	-4,686	-11,171	-6,099
Sale of Common & Preferred Stock	351	403	457	299	317
Other Proceeds from Sale of Stock	351	403	457	299	317
Issuance/Reduction of Debt, Net	3,236	2,131	2,028	2,670	9,755
Change in Current Debt	799	96	-1,050	-286	590
Change in Long-Term Debt	2,437	2,035	3,078	2,957	9,166
Issuance of Long-Term Debt	4,499	3,795	4,728	3,780	10,220
Reduction in Long-Term Debt	-2,062	-1,760	-1,649	-823	-1,055
Other Funds	-24	-20	-21	-3	-8
Other Uses	-24	-20	-21	-3	-59
Other Sources	-	-	-	-	51
Net Financing Cash Flow	-4,995	-5,950	-5,311	-11,262	735
Net Financing Cash Flow Growth	16.05%	-12.03%	52.84%	-1631.67%	-
Net Financing Cash Flow / Sales	-23.70%	-28.30%	-23.27%	-45.74%	2.89%
Exchange Rate Effect	-24	-160	264	-104	-247
Net Change in Cash	33	-1,598	1,240	-6,462	5,608
Free Cash Flow	5,728	4,225	3,698	4,239	4,725
Free Cash Flow Growth	35.58%	14.27%	-12.76%	-10.30%	-
Free Cash Flow Yield	1.42%	-	-	-	-

BurgerKing IS

Burger king
income statement
value in $ million
2019	2018	2017
Revenues	1,146	1,966	3,112
Revenue, net	1,076	1,904	2,980
Cost of revenue	-312	-1,050	-1,362
Cost of goods and services sold	-195	-1,037	-1,232
Other undisclosed gross profit	-91	-165	-256
Gross profit:	743	751	1,494
Operating expenses	-312	-499	-811
Other operating expense, net	-34	-53	-87
Other undisclosed operating income	125	218	343
Operating income:	522	418	940
Nonoperating income (expense)	-12	4	-8
Investment income, nonoperating	-5	-5
Foreign currency transaction gain (loss), before tax	-7	4	-3
Interest and debt expense	-200	-258	-458
Other undisclosed income (loss) from continuing operations before equity method investments, income taxes	12	-4	8
Income from continuing operations before equity method investments, income taxes:	322	160	482
Loss from equity method investments	-13	-4	-17
Income from continuing operations before income taxes:	310	156	466
Income tax expense	-89	-42	-131
Net income:	221	114	335
Other undisclosed net income attributable to parent	13	4	17
Net income available to common stockholders, diluted:	234	118	352
0
Comprehensive Income ($ in millions)	0
0
0
Net income:	221	114	335
Other comprehensive income	165	3	168
Comprehensive income:	386	117	503
Other undisclosed comprehensive income, net of tax, attributable to parent	13	4	17
Comprehensive income, net of tax, attributable to parent:	399	121	520

BurgerKing BS

Burger king
Balance sheet
value in $ million
ASSETS
Current Assets	2019	2018	2017
Cash, cash equivalents, and short-term investments	787	547	674
Cash and cash equivalents	787	547	674
Receivables	180	179	181
Inventory, net of allowances, customer advances and progress billings	1	7	4
Inventory	1	7	4
Prepaid expense	34	✕	34
Deferred costs	9	9	9
Prepaid expense and other current assets	✕	91	92
Assets held-for-sale	24	12
Income taxes receivable	25	29	27
Other undisclosed current assets	38	6	22
Total current assets:	1,074	891	992
Noncurrent Assets
Property, plant and equipment	802	885	852
Long-term investments and receivables	102	52
Long-term investments	102	52
Intangible assets, net (including goodwill)	3,426	3,430	3462
Goodwill	630	619	631
Intangible assets, net (excluding goodwill)	2,796	2,811	2832
Other noncurrent assets	364	✕	368
Prepaid expense and other noncurrent assets	✕	178	180
Other undisclosed noncurrent assets	61	180	122
Total noncurrent assets:	4,754	4,674	4761
TOTAL ASSETS:	5,829	5,564	5753
LIABILITIES AND EQUITY
Liabilities
Current Liabilities
Accounts payable and accrued liabilities	244	352	301
Accounts payable	31	69	51
Accrued liabilities	177	207	194
Employee-related liabilities	31	45	38
Taxes payable	5	31	18
Debt	81	45	64
Deferred revenue and credits	20	10
Other undisclosed current liabilities	1	1	1
Total current liabilities:	346	398	376
Noncurrent Liabilities
Long-term debt and lease obligation	2,956	2,994	3005
Long-term debt, excluding current maturities	2,880	2,905	2921
Capital lease obligations	75	88	82
Liabilities, other than long-term debt	1,119	1,118	1130
Pension and other postretirement defined benefit plans, liabilities	37	78	58
Accrued income taxes	32	26	29
Deferred compensation liability, classified	6	8	7
Deferred tax liabilities, net	693	615	661
Postemployment benefits liability	7	8	8
Other liabilities	318	382	354
Derivative instruments and hedges, liabilities	26	13
Other undisclosed noncurrent liabilities	-108	-120	-115
Total noncurrent liabilities:	3,966	3,991	4018
Total liabilities:	4,312	4,389	4394
Stockholders' equity
Stockholders' equity attributable to parent	1,516	1,175	1359
Common stock	4	4	4
Treasury stock, value	-7	-4
Additional paid in capital	1,240	1,206	1235
Accumulated other comprehensive income (loss)	55	-110	-28
Retained earnings	226	76	153
Total stockholders' equity:	1,516	1,175	1359
TOTAL LIABILITIES AND EQUITY:	5,829	5,564	5753

BurgerKing CF

Annual Data \| Millions of US $ except per share data	31-Dec-2019	31-Dec-2018	31-Dec-2017
Burger king
Cash flow
value in $ million
31-Dec-2019	31-Dec-2018	31-Dec-2018
Net Income/Loss	$1,111	$1,144	$1,235
Total Depreciation And Amortization - Cash Flow	$214	$209	$215
Other Non-Cash Items	$74	($13)	($461)
Total Non-Cash Items	$288	$196	($246)
Change In Accounts Receivable	($53)	$19	($30)
Change In Inventories	($15)	($7)	$19
Change In Accounts Payable	$112	$41	$14
Change In Assets/Liabilities	$138	$43	$59
Total Change In Assets/Liabilities	$131	($123)	$422
Cash Flow From Operating Activities	$1,476	$1,165	$1,391
Net Change In Property, Plant, And Equipment	($54)	($78)	($11)
Net Change In Intangible Assets
Net Acquisitions/Divestitures	-	-	($864)
Net Change In Short-term Investments
Net Change In Long-Term Investments	-	-	$16
Net Change In Investments - Total	-	-	$16
Investing Activities - Other	$24	$34	$1
Cash Flow From Investing Activities	($30)	($44)	($858)
Net Long-Term Debt	($16)	$1	$3,108
Net Current Debt
Debt Issuance/Retirement Net - Total	($16)	$1	$3,108
Net Common Equity Issued/Repurchased	$102	$61	$29
Net Total Equity Issued/Repurchased	$102	$1	($2,977)
Total Common And Preferred Stock Dividends Paid	($901)	($728)	($664)
Financial Activities - Other	($27)	($559)	($403)
Cash Flow From Financial Activities	($842)	($1,285)	($936)
Net Cash Flow	$620	($184)	($379)
Stock-Based Compensation	$68	$48	$48
Common Stock Dividends Paid	($901)	($728)	($664)

competition ratio

McDonald	Burger King
2019	2018	2017	2019	2018	2017
liquid ratio	quick ratio	0.97	1.35	1.82	3.00	2.22	2.54
current ratio	0.98	1.36	1.84	3.10	2.24	2.64
Leverage Ratios	Debt to Total Assets Ratio	1.17	1.19	1.10	0.74	0.79	0.76
Debt Equity Ratio	-6.79	-6.24	-11.34	2.84	3.74	3.23
Long-Term Debt to Equity	-5.71	-4.97	-9.04	0.68	0.72	0.70
Times Interest Earned Ratio	7.08	7.98	9.31	-1.55	-0.60	-1.02
Activity Ratios	inventory Turnover	199.22	200.76	206.78	-312.00	-150.00	-337.13
Fixed Assets Turnover	0.40	0.57	0.62	0.24	0.42	0.65
Total Assets Turnover	0.44	0.64	0.68	0.20	0.35	0.54
Accounts Receivable Turnover	0.00	0.00	0.00	0.00	0.00	0.00
Average Collection Period	0.00	0.00	0.00	0.00	0.00	0.00
Profitability Ratios	Gross Profit Margin	0.53	0.51	0.47	0.65	0.38	0.48
Operating Profit Margin	0.45	0.44	0.41	0.46	0.21	0.30
Net Profit Margin	0.29	0.28	0.23	0.19	0.06	0.11
Return on Total Assets (ROA)	0.13	0.18	0.15	0.04	0.02	0.06
Return on Stockholders’ Equity (ROE)	-0.73	-0.95	-1.59	0.15	0.10	0.25
Earnings Per Share (EPS)	7.88	7.54	6.37	13.00	4.00	17.00
Price Earnings Ratio	0.18	0.17	0.16	0.41	0.14	0.30

Format: Quarterly