Calculate the ratios in the last picture using the last five balance sheets and income statements

Consolidated income statement for the years ended 31 March Consolidated income statement for the years ended 31 March continued Consolidated income statement Consolidated income statement for the years ended 31 March for the years ended 31 March continued \begin{tabular}{l|l} \hline Consolidated income statement & \begin{tabular}{l} Consolidated income statement \\ for the years ended 31 March \end{tabular} \\ for the years ended 31 March continued \end{tabular} Consolidated income statement Consolidated income statement for the years ended 31 March for the years ended 31 March continued Consolidated income statement Consolidated income statement for the years ended 31 March for the years ended 31 March continued To complete Question \# 2: the following requirements, you need to use the last five Balance sheets and income statements from your company's website, which will extract from past annual financial reports. Only financial statements and notes from the firm's official site will be accepted. Financial statements from other sources, such as Yahoo Financial, Google Financial, etc., won't be accepted. Chapter 3: Ratio Analysi: a) Using excel and the financial statements of your assigned company, calculate the following ratios for the last five years and prepare a table showing these ratios. Requirements: Liquidity Ratios a) Current Ratio b) Quick Ratio c) Cash Ratio Long-Term Solvency Ratios d) Total debt ratio e) Debt/equity ratio f) Equity Multiplier = Assets/Equity g) Long-term Debt Equity ration h) Times Interest Earned Assets Turnover Ratio i) Inventory Turnover j) Day's sales in inventory k) Receivables turnover I) Days' sales in receivables m) Total Assets turnover Profitability Ratios n) Profit Margin o) Return on Assets To make easy your ratio calculations, I am requesting to simplify your financial statements (statement of financial position and the statement of income). Because each company has different accounts in their financial statements, you need to re-arrange the accounts and create your simplified and unique statement of financial position. You will need to decide the categories, but you can't change the total. The total in your simplified financial statements should be the same