Primary company is Autodesk Inc (ADSK). Competitors are Adobe, Inc. and Bentley Systems

oThe 11^th tab in your Financial Statement Analysis Template must be labeled Historical and Competitor Ratios

The list of ratios to be included are as follows.They should be grouped under the headings, as shown:

Liquidity Ratios

oCurrent Ratio

oQuick Ratio

Leverage Ratios

oDebt to Total Assets Ratio

oDebt Equity Ratio

oLong-Term Debt to Equity

oTimes Interest Earned Ratio

Activity Ratios

oInventory Turnover

oFixed Assets Turnover

oTotal Assets Turnover

oAccounts Receivable Turnover

oAverage Collection Period

Profitability Ratios

oGross Profit Margin

oOperating Profit Margin

oNet Profit Margin

oReturn on Total Assets (ROA)

oReturn on Stockholders' Equity (ROE)

oEarnings Per Share (EPS)

oPrice Earnings Ratio

Calculate the ratios for your chosen company (AUTODESK) for the last three years, linking the ratio calculations back to the historical financial statement tabs (Tabs 2-4) using formulas.

Calculate the ratios for each of your company's competitors (ADOBE INC AND BENTLEY SYSTEMS) (most recent year only), linking the ratio calculations to the competitor financial statements shown in Tabs 5-10 using formulas.

Using the internet, locate the industry averages for the ratios listed above, and include them in the final column of the ratio tab.Include a footnote on the tab to identify the source of the industry averages.