The company is Delta Airlines for years 2019, 2018, and 2017

Annual report for 2017, 2018 and 2019

It's an excel ratios project.

Using Microsoft Excel, create a financial analysis workbook for the company from your group project. This is not a group assignment. Each person will submit his/her own Excel to submission box on BlackBoard. The grade on this assignment will replace your lowest exam grade. The workbook will include five spreadsheets: 1. Sheet 1 will be a Horizontal analysis of the Income Statements for the three years you are examining 2 Sheet 2 will be a Horizontal analysis of the Balance Sheets for the three years you are examining 3 Sheet 3 will be a Vertical analysis of the Income Statements for the three years you are examining 4. Sheet 4 will be a Vertical analysis of the Balance Sheet for the three years you are examining 5 Sheet 5 will be dedicated to all of the ratios listed in Chapter 12 on page 586 of your textbook You MUST use Excel functions to do all of the calculations. Do NOT use a calculator You will be graded on the execution of the spreadsheet (the how) and the appearance of the spreadsheet. So, your spreadsheet should look polished enough to be published. The following website pages will assist you in creating the workbook. 586 Chapter 12 Exhibit 12-10 Five Key Questions Ratios used to analyze and make the decision Is the business a going concern? use liquidity ratios to determine the following: Net Working Capital - Current Assets - Current Liabilities Current Assets Care Rate Current Liabres wirl Betis Daick Assets (Cash + Net Current Receivables + Short-Term investments Current Liabilities Cash Conversion Cyele-Days-Sales-In-Inventory (Receivable Collection Period - Accounts Payable Payment Period) Days-Sales-in-inventory = Average Inventory Cost of Goods Sold/365 Days) Receivable Collection Period trage Not Accounts Receivable Net Credit Sales/365 Days) Average Accounts Payable Accounts Payable Payment Period = Cost of Goods Sold/365 Days) Use profitability ratios to determine the following How is the business Barning a net income or loss? Gross Prot Percentage - Gross Profi Welcome Percentage Net Sales Net Income Sales Where is the business getting its money and can it pay its debt obligations? Use solvency ratios to determine the following: Total Liabilities Dellt Ratio Total Assets Interest Coverage Ratio EBIT est Expense How is the business Use asset management ratios to determine the following: and is it using its assets efficiently? Net Credit Sales Accounts Receivable Turnover Ratio = Average Net Accounts Receivable Inventory Termowe Batie Cost of Goods Sold Average Inventory Fixed Asset Turnover Ratio - Sales Average Fixed Assets Sales Total Asset Turnover Ratio - Average Total Assets Net Income Return on Assets = Average Total Assets Is the business generating enough net income to reward the stockholders for the use of their money Use market analysis ratios to determine the following: Net Income Earnings per Share (EPS) = Average Number of Common Shares Outstanding Dividends Dividends per Share (OPS) berane Number of Common Shares Outstanding Dividends Dividend Payout Ratio - Not Income Net income e Stockholders Equity Rabaron Equity (ROE) D Using Microsoft Excel, create a financial analysis workbook for the company from your group project. This is not a group assignment. Each person will submit his/her own Excel to submission box on BlackBoard. The grade on this assignment will replace your lowest exam grade. The workbook will include five spreadsheets: 1. Sheet 1 will be a Horizontal analysis of the Income Statements for the three years you are examining 2 Sheet 2 will be a Horizontal analysis of the Balance Sheets for the three years you are examining 3 Sheet 3 will be a Vertical analysis of the Income Statements for the three years you are examining 4. Sheet 4 will be a Vertical analysis of the Balance Sheet for the three years you are examining 5 Sheet 5 will be dedicated to all of the ratios listed in Chapter 12 on page 586 of your textbook You MUST use Excel functions to do all of the calculations. Do NOT use a calculator You will be graded on the execution of the spreadsheet (the how) and the appearance of the spreadsheet. So, your spreadsheet should look polished enough to be published. The following website pages will assist you in creating the workbook. 586 Chapter 12 Exhibit 12-10 Five Key Questions Ratios used to analyze and make the decision Is the business a going concern? use liquidity ratios to determine the following: Net Working Capital - Current Assets - Current Liabilities Current Assets Care Rate Current Liabres wirl Betis Daick Assets (Cash + Net Current Receivables + Short-Term investments Current Liabilities Cash Conversion Cyele-Days-Sales-In-Inventory (Receivable Collection Period - Accounts Payable Payment Period) Days-Sales-in-inventory = Average Inventory Cost of Goods Sold/365 Days) Receivable Collection Period trage Not Accounts Receivable Net Credit Sales/365 Days) Average Accounts Payable Accounts Payable Payment Period = Cost of Goods Sold/365 Days) Use profitability ratios to determine the following How is the business Barning a net income or loss? Gross Prot Percentage - Gross Profi Welcome Percentage Net Sales Net Income Sales Where is the business getting its money and can it pay its debt obligations? Use solvency ratios to determine the following: Total Liabilities Dellt Ratio Total Assets Interest Coverage Ratio EBIT est Expense How is the business Use asset management ratios to determine the following: and is it using its assets efficiently? Net Credit Sales Accounts Receivable Turnover Ratio = Average Net Accounts Receivable Inventory Termowe Batie Cost of Goods Sold Average Inventory Fixed Asset Turnover Ratio - Sales Average Fixed Assets Sales Total Asset Turnover Ratio - Average Total Assets Net Income Return on Assets = Average Total Assets Is the business generating enough net income to reward the stockholders for the use of their money Use market analysis ratios to determine the following: Net Income Earnings per Share (EPS) = Average Number of Common Shares Outstanding Dividends Dividends per Share (OPS) berane Number of Common Shares Outstanding Dividends Dividend Payout Ratio - Not Income Net income e Stockholders Equity Rabaron Equity (ROE) D