Auditing exercise Ratio calculations of an airline (service) industry Liquidity Ratio's Gross Profit Margin Gross Profit / sales x 100 2020 forecast $2,200,000/ 12,000,000 x 100 18.33% 2019 Actual 6,000,000 / 18,000,000 x 100 33.33% 2018 6,300,000 / 18,000,000 x 100 35% Current Ratio 2020 3,200,000 / 7,900,000 0,41% 2019 4,300,000 / 8,600,000 0.5% 2018 3,500,000 / 7,600,000 -0.46% Quick Ratio Current assets - inventories / current liabilities 2020 forecast 3,200,000 - 13,000,000 / 7,900,000 -1.241 2019 4,300,000 - 15,000,000 / 8,600,000 -1.244 2018 3,500,000 - 14,100,000 / 7,600,000 -1.395 Net Profit Margin Net profit after tax / sales x 100 2020 Forecast -2,100,000 / 12,000,000 x 100 -17.5% 2019 900,000 / 18,000,000 x 100 5% 2018 900,000 / 18,000,000 x 100 - 5% Inventory turnover ratio Cost of sales / average inventory Return on assets 2020 forecast 2,100,000 /17,200,000 x 100 - 12.21% 2019 900,000 / 19,400,000 x 100 4.64% 2018 900,000 / 18,700,000 x 100 4.81% Trades receivable turnover (in days) Average trade receivables / sales x 365 2020 2,000,000 / 12,000,000 x 365 = 60.84 → 61 days 2019 1,500,000 / 18,000,000 x 365 - 30.416 → 31 days 2018 1,000,000 / 18,000,000 x 365 - 20.277 → 21 days Trades payable turnover (in days) Average trades payable / purchases x 365 Return on equity 2020 2,100,000 / 1,900,000 x 100 -110.53% 2019 900,000 / 1,900,000 x 100 47.37% 2018 900,000 / 2,500,000 x 100 - 36%