Instructions 1. The purpose of this template is to gather data that will be analyzed and discussed in Memo #3 submission. Insert the name of the company in the "INSERT COMPANY HERE." 2. The template intends for you to gather financial information that is readily available in multiple online financial resources. Part of the learning process is the data gathering exercise. Please take your time looking for it. Please use end of year ratios. Only some ratios/metrics have TTM/QoQ informaiton. Add what is applicable. 3. Ratios can be found from a variety of online financial resources, to include, but not limited to: Morningstar's, Yahoo Finance, Google Finance, Market Watch, Bloomberg, and many more. Sometimes it is as simple as Google: "What is Apple's revenue?" 4. Do not edit the table. Do not add extra ratios. More is not necessarily better - we are looking for quality over quantity. 5. You can also change the font size and the column widths. Keep the headings standard. 6. While not a requirement, you can copy/paste the Excel completed table as a picture in your memorandum template. Southwest Airlines Delta Airlines Insert Financial Resource(s) 2021 2022 Trailing Twelve Months Insert Financial Resource(s) Trailing Twelve 2021 2022 Used Here (TTM) / QoQ / Forecast Used Here Months (TTM) / QoQ / Forecast Margin Ratios Margin Ratios Gross Profit Margin Gross Profit Margin EBITDA EBITDA Operating Profit Operating Profit Net Profit Net Profit Cash Flow Cash Flow Profitability Ratios Profitability Ratios Return on Assets (ROA) Return on Assets (ROA) Return on Equity (ROE) Return on Equity (ROE) Return on Invested Capital (ROIC) Return on Invested Capital (ROIC) nterest Coverage Interest Coverage