Hi all! For Excel Project #2, you are adding into the project all 3 of the financial statements for 2 competitors. So you will have:

• Tab #5: Competitor (put in the competitor name) #1 Income Statement
• Tab #6Competitor (put in the competitor name)#1 Balance Sheet
• Tab #7Competitor (put in the competitor name)#1 Statement of Cash Flow
• Tab #8Competitor (put in the competitor name) #2 Income Statement
• Tab #9Competitor (put in the competitor name) #2 Balance Sheet
• Tab #10Competitor (put in the competitor name) #2 Statement of Cash Flow
• Tab #11 - Historical and Competitor Ratios (for your company, both competitor companies and the industry averages)

For the ratios- calculate (or look them up, some are in the company reports on the company website or you can use Morningstar.com) the ratios for your company for all 3 years, calculate the ratios for Competitor #1 and #2 for the most recent year only. https://corporatefinanceinstitute.com/resources/accounting/financial-ratios/ is a great site that summarizes what these various ratios are. EXCEL PROJECT: COMPETITOR ANALYSIS ASSIGNMENT INSTRUCTIONS OVERVIEW Competitor #1 Income Statement (Tab 5), Competitor #1 Balance Sheet (Tab 6), Competitor #1 Cash Flows (Tab 7), Competitor #2 Income Statement (Tab 8), Competitor #2 Balance Sheet (Tab 9), Competitor #2 Cash Flows (Tab 10), Historical and Competitor Ratios (Tab 11) INSTRUCTIONS Continue in the same Excel workbook prepared in Module 2: Week 2, adding the following tabs: o The 5th tab and 8th tabs in your Financial Statement Analysis Template must be labeled (Competitor Company Name) Income Statements. (Replace "Competitor Company Name" with the name of the competitor.) Include the latest three years of income statements for your competitor based on SEC filings. Ensure that the worksheet includes a header with: Company Name Financial Statement Name (Income Statements) Financial Statement Dates Denomination level ($s in millions or thousands, etc.) o The 6th and 9th tabs in your Financial Statement Analysis Template must be labeled (Competitor Company Name) Balance Sheets. (Replace "Competitor Company Name" with the name of the competitor.) Include the latest three years of balance sheets for your first competitor based on SEC (10-K) filings. (Note: Some 10-Ks only provided 2 years of balance sheet data. You may need to download the second most recent 10-K for your company in order to obtain 3 years of balance sheet data.) Ensure that the worksheet includes a header with: Company Name Financial Statement Name Financial Statement Dates Denomination level ($s in millions or thousands, etc.) o The 7th and 10th tabs in your Financial Statement Analysis Template must be labeled (Competitor Company Name) Cash Flows. (Replace "Competitor Company Name" with the name of the competitor.) Include the latest three years based on SEC (10-K) filings. Make sure that the Income Statement, Balance Sheet, and Cash Flows Statement tie in as follows:

American Air Lines, Inc.
Financial Statement American Air Lines, Inc. (Income Statements)
As of December 31, 2021, December 31, 2022, and December 31, 2023
Denomination level ($s in millions or thousands, etc.)
Consolidated Statements of Operations - American Airlines Group Inc. - USD ($) shares in Thousands, $ in Millions		12 Months Ended
	Dec. 31, 2023	Dec. 31, 2022	Dec. 31, 2021
Operating revenues:
Total operating revenues	$ 52,788	$ 48,971	$ 29,882
Operating expenses:
Aircraft fuel and related taxes	12,257	13,791	6,792
Salaries, wages and benefits	14,580	12,972	11,817
Regional expenses	4,643	4,385	3,204
Maintenance, materials and repairs	3,265	2,684	1,979
Other rent and landing fees	2,928	2,730	2,619
Aircraft rent	1,369	1,395	1,425
Selling expenses	1,799	1,815	1,098
Depreciation and amortization	1,936	1,977	2,019
Special items, net	971	193	(4,006)
Other	6,006	5,422	3,994
Total operating expenses	$ 49,754	$ 47,364	$ 30,941
Operating income (loss)	3,034	1,607	(1,059)
Nonoperating income (expense):
Interest income	591	216	18
Interest expense, net	(2,145)	(1,962)	(1,800)
Other income (expense), net	(359)	325	293
Total nonoperating expense, net	(1,913)	(1,421)	(1,489)
Income (loss) before income taxes	1,121	186	(2,548)
Income tax provision (benefit)	299	59	(555)
Net income (loss)	822.00	127.00	-1993.00
Earnings (loss) per common share:
Basic (in dollars per share)	1.26	0.20	-3.09
Diluted (in dollars per share)	1.21	0.19	-3.09
Weighted average shares outstanding (in thousands):
Basic (in shares)	653,612	650,345	644,015
Diluted (in shares)	719,669	655,122	644,015
Passenger
Operating revenues:
Total operating revenues	$ 48,512	$ 44,568	$ 26,063
Cargo
Operating revenues:
Total operating revenues	$ 812	$ 1,233	$ 1,314
Other
Operating revenues:
Total operating revenues	$ 3,464	$ 3,170	$ 2,505

Please help with excel formulas and ratios.