EXCEL PART 2

Excel1Project.xlsx

Historical Income Statements

McDonalds
Income Statement
Years ended December 31,
$s in Thousands
In millions, except per share and unit amounts	2020	2019	2018
Revenues
Sales by Company-operated restaurants	$ 8,139.00	$ 9,421.00	$ 10,013.00
Revenues from franchised restaurants	$ 10,726.00	$ 11,656.00	$ 11,012.00
Other revenues	$ 343.00	$ 288.00	$ 233.00
Total revenues	$ 19,208.00	$ 21,365.00	$ 21,258.00
Operating income	$ 7,324.00	$ 9,070.00	$ 88,233.00
Net income	$ 26,532.00	$ 30,435.00	$ 109,491.00

Mcdonalds
Consolidated Balace Sheet
As of December 12,2020, December 12,2021, December 12,2018
$s in Thousands
	12/30/2020	12/30/2019	12/30/2018
Total Assets	$ 52,626,800.00	$ 47,510,800.00	$ 32,811,200.00
Current Assets …….	$ 6,243,200.00	$ 3,557,900.00	$ 4,053,200.00
Total non-current assets	$ 46,383,600.00	$ 43,952,900.00	$ 28,758,000.00
Total Liabilities Net Minority	$ 60,451,700.00	$ 55,721,100.00	$ 39,069,600.00
Current Liabilities	$ 6,181,200.00	$ 3,621,000.00	$ 2,973,500.00
Total Non Current Liabilities	$ 54,270,500.00	$ 52,100,100.00	$ 36,096,100.00
Total Equity Gross Minority Int	$ (7,824,900.00)	$ (8,210,300.00)	$ (6,258,400.00)
Total Capitalization	$ 27,371,900.00	$ 25,907,800.00	$ 24,816,900.00
Common Stock Equity	$ (7,824,900.00)	$ (8,210,300.00)	$ (6,258,400.00)
Capital Lease Obligations	$ 14,022,800.00	$ 13,378,800.00	-
Net Tangible Assets	$ (10,598,000.00)	$ (10,887,700.00)	$ (8,589,900.00)
Working Capital	$ 62,000.00	$ (63,100.00)	$ 1,079,700.00
Invested Capital	$ 29,615,500.00	$ 25,966,900.00	$ 24,816,900.00
Tangible Book Value	$ (10,598,000.00)	$ (10,887,700.00)	$ (8,589,900.00)
Total Debt	$ 51,463,200.00	$ 47,556,000.00	$ 31,075,300.00
Net Debt	$ 33,991,300.00	$ 33,278,700.00	$ 30,209,300.00
Share Issued	$ 1,660,600.00	$ 1,660,600.00	$ 1,660,600.00
Ordinary Shares Number	$ 745,400.00	$ 746,300.00	$ 767,100.00
Treasury Shares Number	$ 915,200.00	$ 914,300.00	$ 893,500.00

Mcdonalds
Consolidated Balace Sheet
As of December 12,2020, December 12,2021, December 12,2018
$s in Thousands
	TTM	12/30/2020	12/30/2019	12/30/2018
Operating Cash Flow	$ 6,843,200.00	$ 6,265,200.00	$ 8,122,100.00	$ 6,966,700.00
Investing Cash Flow	$ (1,272,000.00)	$ (1,545,800.00)	$ (3,071,100.00)	$ (2,455,100.00)
Financing Cash Flow	$ (8,045,900.00)	$ (2,249,000.00)	$ (4,994,800.00)	$ (5,949,600.00)
End Cash Position	$ 2,905,100.00	$ 3,449,100.00	$ 898,500.00	$ 866,000.00
Income Tax Paid Supplemental Data	-	$ 1,441,900.00	$ 1,589,700.00	$ 1,734,400.00
Interest Paid Supplemental Data	-	$ 1,136,000.00	$ 1,066,500.00	$ 959,600.00
Capital Expenditure	$ (1,527,000.00)	$ (1,640,800.00)	$ (2,393,700.00)	$ (2,741,700.00)
Issuance of Debt	$ (101,700.00)	$ 5,543,000.00	$ 4,499,000.00	$ 3,794,500.00
Repayment of Debt	$ (3,486,800.00)	$ (2,411,700.00)	$ (2,061,900.00)	$ (1,759,600.00)
Repurchase of Capital Stock	$ (26,700.00)	$ (907,800.00)	$ (4,976,200.00)	$ (5,207,700.00)
Free Cash Flow	$ (4,711,800.00)	$ 9,080,100.00	$ (1,321,900.00)	$ (3,792,500.00)

		ACCT 370 EXCEL PROJECT
		McDonalds
		McDonald’s, in full McDonald’s Corporation, American fast-food chain that is one of the largest in the world, known for its hamburgers.
		(Micah Armstrong)
		Company name	McDonalds
		Ticker symbol	233.89 +0.32 (+0.14%)
		Industry	retail sector
		Products and services offered	Hamburgers, sandwiches, Chicken, fish, Salads, Snacks, sides,Beverages, Desserts, shakes,Breakfast, McCafé
		Major Competitors	Fast-casual restaurants with names like Chipotle Mexican Grill (CMG), Panera Bread Company, Starbucks (SBUX)