Forecast 2020 Actual Actual 2019 2018 Revenue 12.0 18.0 18 0 Expenditure Wages 3.3 5.0 Aircraft Costs 4.0 4.0 3.7 Fuel 2.5 3.0 Depreciation 1.6 1.4 Other 1.4 2.5 3.1 3.4 PBIT 1.5 1.5 Finance Costs (0.2) (0.2) (0.2) Income Tax 0.0 (0.4) (0.4) Statutory Profit for the Year (2.1) 0.9Forecast 2020 Actual Actual 2019 Current Assets 2018 Cash & Cash Equivalents 0.5 Receivables 18 1.5 2.0 15 1.0 Other 0.7 Total Current Assets 1.0 1.0 3.1 43 3.5 Non-Current Assets Property, Plant & Equipment 12.3 Intangible Assets 13.0 13.0 0.7 2.0 Other 2.1 1.0 Total Non-Current Assets 0.0 0.1 14.0 Total Assets 15.1 15.2 17.2 19.4 18.7 Current Liabilities Payables 4.0 18 Revenue Received in Advance 1.7 Interest Bearing Liabilities 1.0 5.0 4.5 Provisions 2.0 0.6 0.4 0.9 Other 1.0 1.0 Total Current Liabilities 7.9 7.6Non-Current Liabilities Revenue Received in Advance 0.2 15 1.5 Interest Bearing Liabilities 6.5 4.3 Provisions 0.4 0.4 0.4 Deferred Tax Liabilities 0.8 0.8 0.9 Other 0.1 0.1 0.n Total Non-Current Liabilities 8.0 7.A 7.1 Total Liabilities 15.9 15.9 14.7 Net Assets 1.3 3.5 Equity Issued Capital 1.9 19 2.5 Treasury Shares (0.2) (0.2) (0.1) Reserves 0.2 0.2 0.5 Retained Earnings (0.5) 1.1 Total Equity 1.3 3.5Auditing exercise Ratio calculations of an airline (service) industry Liquidity Ratio's Gross Profit Margin Gross Profit / sales x 100 Current Ratio 2020 forecast 2020 $2,200,000/ 12,000,000 x 100 3,200,000 / 7,900,000 18.33% - 0.41% 2019 Actual 2019 6,000,000 / 18,000,000 x 100 4,300,000 / 8,600,000 - 33.33% 0.5% 2018 2018 6,300,000 / 18,000,000 x 100 3,500,000 / 7,600,000 35% 0.46%% Quick Ratio Net Profit Margin Current assets - inventories / current liabilities Net profit after tax / sales x 100 2020 forecast 2020 Forecast 3,200,000 - 13,000,000 / 7,900,000 -2,100,000 / 12,000,000 x 100 -1.241 -17.5% 2019 2015 4,300,000 - 15,000,000 / 8,600,000 900,000 / 18,000,000 x 100 -1.244 5% 2018 2018 3,500,000 - 14,100,000 / 7,600,000 900,000 / 18,000,000 x 100 -1.395 = 5% Inventory turnover ratio Return on assets Cost of sales / average inventory 2020 forecast 2,100,000 /17,200,000 x 100 Trades receivable turnover (in days) # 12.21% Average trade receivables / sales x 365 2015 2020 900,000 / 19,400,000 x 100 2,000,000 / 12,000,000 x 365 = 4.64% # 60.84 9 61 days 2018 201! 900,000 / 18,700,000 x 100 1,500,000 / 18,000,000 x 365 - 4.81% 30.416 9 31 days 2018 Return on equity 1,000,000 / 18,000,000 x 365 2020 20.277 > 21 days 2,100,000 / 1,900,000 x 100 # 110.53%% Trades payable turnover (in days] 2019 Average trades payable / purchases x 365 900,000 / 1,900,000 x 100 - 47.37% 2018 900,000 / 2,500,000 x 100 = 36%
