Hi, can you please calculate the ratios here also please say if its better or worse and why in short.
current
receviables turnover
average collection period
inventory turnover
debt to total assets
times interest earned
return on assets
return on shareholders equity
Here's the data
Excel File Edit View Insert Format Tools Data Window Help 35% Fri 12:35 am AutoSave OFF Excel Workbook Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri 11 A A 207 General Insert v E x Delete v AP- OV Paste B IUV A FE $ ~ % " Conditional Format Cell Sort & Find & Ideas Sensitivity Formatting as Table Styles Format v Filter Select 41 X fx ASX Code C D F G H K M N O P 1 ASX Code Company Name Item 06/18 06/19 2 APZ Aspen Group Net Profit Margin (%) 11.61 7.72 APZ Aspen Group EBIT Margin (% 13.66 11.02 APZ Aspen Group EBITA Margin (%) 13.77 11.24 5 APZ Aspen Group EBITDA Margin (%) 21.64 20.02 6 APZ Aspen Group ROE (%) 1.87 1.75 APZ Aspen Group ROA (%) 2.12 1.95 8 APZ Aspen Group ROIC (%) 3.47 2.65 9 APZ Aspen Group NOPLAT Margin (%) 13.08 10.13 10 APZ Aspen Group Invested Capital Turnover 0.27 0.26 11 APZ Aspen Group Inventory Turnover 13.89 10.59 12 APZ Aspen Group Asset Turnover 0.17 0.21 13 APZ Aspen Group T Asset Turnover 0.20 0.23 14 APZ Aspen Group PPE Turnover 0.27 0.26 15 APZ Aspen Group Depreciation/PP&E (%) 1.99 2.16 16 APZ Aspen Group Depreciation/Revenue (%) 7.87 8.78 17 APZ Aspen Group Wkg Capital/Revenue (%) -2.82 -6.14 APZ Aspen Group Working Cap Turnover 16.27 19 APZ Aspen Group Financial Leverage 1.11 1.30 20 Aspen Group Gross Gearing (D/E) (%) 4.10 22.53 21 Aspen Group Net Gearing (%) 7.56 16.58 22 APZ Aspen Group Net Interest Cover 5.95 2.99 APZ Aspen Group Current Ratio 2.54 1.55 24 APZ Aspen Group Quick Ratio 2.35 1.23 25 APZ Aspen Group Gross Debt/CF 1.23 5.01 26 APZ Aspen Group Net Debt/CF 2.27 3.69 27 APZ Aspen Group NTA per Share ($) 1.15 1.18 28 APZ Aspen Group BV per Share ($) 1.40 1.34 29 APZ Aspen Group Cash per Share ($) 0.14 0.07 30 APZ Aspen Group Receivables/Op. Rev. (%) 6.91 8.30 31 Aspen Group Inventory/Trading Rev. (%) 7.20 9.44 32 APZ Aspen Group Creditors/Op. Rev. (%) 26.86 22.19 APZ Aspen Group Funds from Ops./EBITDA (%) 113.13 65.77 34 APZ Aspen Group Depreciation/Capex (%) 4.88 9.49 35 APZ Aspen Group Capex/Operating Rev. (%) 161.09 92.54 36 APZ Days Inventory 26.2 34.47 37 APZ Aspen Group Aspen Group Days Receivables 25.23 30.31 38 APZ Aspen Group Days Payables 98.04 80.98 APZ Aspen Group Gross CF per Share ($) 0.04 0.05 Profit Loss Balance Sheet Cash Flow Ratio Analysis + - + 100% 7,80 22 O O 328 tv X 4 WExcel File Edit View Insert Format Tools Data Window Help 35% Fri 12:35 am AutoSave OFF Excel Workbook Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri 12 AA Percentage Insert v E x Delete v V v Paste BIUV A FE $ ~ % " Conditional Format Cell Ideas Formatting as Table Styles Format v X Sort & Find & Sensitivity Filter Select G5 X V fx = F5 / E5 C D G H M N O P 1 AW NI ASX Code Company Name Item 06/18 06/19 $ Movement APZ Aspen Group CA - Cash 13,370,000.00 6,466,000.00 6,904,000.00 106.77% APZ Aspen Group CA - Receivables 1,950,000.0 3,913,000.00 -1,963,000.00 50.17% 4 APZ Aspen Group CA - Investments 0.00 D.0 0.0 0.00% 5 APZ Aspen Group CA - Other 5,723,000.00 2,760,000.00 2,963,000.00 107.36% 6 APZ Aspen Group Total Current Assets 21,043,000.00 13,139,000.00 7,904,000.0 60.16% 7 APZ Aspen Group CA - Investments 0.00 0.00 0.00 0.00% 8 APZ Aspen Group NCA - Property 0.00 0.00 0.00 0.00% 9 APZ Aspen Group CA - Other 106,619,000.00 128,596,000.00 -21,977,000.00 17.09% 10 APZ Aspen Group Total NCA 106,619,000.00 128,596,000.00 -21,977,000.00 17.09% 11 APZ Aspen Group Total Assets 27,662,000.00 141,735,000.00 -14,073,000.0 -9.93% 12 APZ Aspen Grou Creditors 5,841,000.00 6,485,000.00 -644,000.00 -9.93% 13 APZ Aspen Group Provisions 2,402,000.0 1,984,000.00 000.00 21.07% 14 APZ Aspen Group Other 43,000.00 0.0 43,000.00 0.00% 15 APZ Aspen Group Total Curr. Liabilities 8,286,000.00 8,469,000.0 -183,000.00 -2.16% 16 APZ Aspen Group Borrowings 4,700,000.00 24,500,000.00 -19,800,000.0 80.82% 17 APZ Aspen Group Deferred Tax 0.00 0.00 0.00 0.00% 18 APZ Aspen Group Other 0.00 0.00 0.00 0.00% 19 APZ Aspen Group Total NCL 4,700,000.00 24,500,000.00 -19,800,000.00 80.82% 20 Aspen Group Total Liabilities 12,986,000.00 32,969,000.00 -19,983,000.00 60.61% 21 Aspen Group Share Capital 490,361,000.00 490,348,000.00 13,000.00 0.00% 22 APZ Aspen Group Reserves 7,129,000.00 14,092,000.00 -6,963,000.00 49.41% APZ Retained Earnings 3.39% 24 APZ Aspen Group -362,782,000.00 ,531,000.00 Aspen Group Other Equity 0.00 0.0 0.00 0.00% 25 APZ Aspen Group Convertible Equity 0.00 .OC .00 0.00% 26 APZ Aspen Group SE Held Sale 0.00 0.0 0.00 0.00% 27 APZ Aspen Group Outside Equity -20,032,000.00 -20,143,000.00 111,000.00 -0.55% 28 APZ Aspen Group Total Equity 114,676,000.00 ,766,000.00 5,910,000.00 5.43% 29 Profit Loss Balance Sheet Cash Flow Ratio Analysis + - + 100% 7,80 X 328 22 tv 4 O 4 W
