Do Ratio analysis (Liquidity) for 2015 to 2019

New Delhi Television Ltd. Liquidity, Working Cycle & Turnover Ratios : Mar 2011 - Mar 2020: Non-Annualised : Rs. Million Mar-16 Mar-11 12 mths IGAAP Mar-12 12 mths IGAAP Mar-13 12 mths IGAAP Mar-14 12 mths IGAAP Mar-15 12 mths IGAAP 12 mths Mar-17 12 mths INDAS Mar-18 12 mths INDAS Mar-19 12 mths INDAS Mar-20 12 mths INDAS IGAAP Liquidity Cash to current liabilities (times) Cash to avg cost of sales (times) Quick ratio (times) Current ratio (times) 0.033 1.82 0.009 2.464 0.563 0.615 0.017 2.732 0.552 0.557 0.041 1.014 0.845 0.875 0.037 0.748 0.925 0.95 0.004 0.727 0.856 0.898 0.074 9.374 1.076 1.121 0.066 22.642 0.844 0.885 0.019 22.08 0.887 0.922 0.024 13.821 0.856 0.893 0.659 0.687 2.009 0.748 0.031 0.41 0.827 0.005 0.552 0.957 0.172 0.811 0.024 0.497 1.147 24.214 Total outside liabilities / tangible net worth Total term liabilities / tangible net worth Debt to equity ratio (times) Long term Borrowings to PBDITA (net of P&E&OI&FI) Borrowings to PBDITA (net of P&E&OI&FI) Interest cover times) ) Interest incidence (%) 1.097 0.131 0.531 1.526 6.215 1.346 0.012 0.421 0.536 1.117 0.083 0.419 2.494 12.571 0.003 0.541 1.919 0 0.403 0 3.046 1.265 14.7 1.957 0.035 0.392 0.286 3.213 1.664 16.3 11.3 11 9.7 8.8 10.5 10.2 11.4 11.9 TE 0 0 0 Structure of current assets % of total) Short term investments Inventories Trade receivables & Bills receivables Other short term receivables Cash & bank balance Loans & advances by finance cos (short term) Short term loans & advances Asset held for sale or transfer Unamortised expenses (short term) 1.1 0.4 59.9 0.5 27.7 0 10.4 0 0 3.1 0.2 55.7 0.1 23.4 0.3 59 0.5 27.1 0 13.2 0 0 3.5 0.4 55.9 1.5 12.6 0 26.1 0 0 3.2 1.1 60.3 3.1 6.6 0 25.6 0 0 0 2.4 58 3.3 7 0 29.3 0 0 0 0.4 49.4 11.2 6.4 0 32.6 0 0 INFO 0.8 45.9 12.9 7.3 0 33.1 0 0 0.2 47.2 10.8 2 0 39.8 0 0 0 0 0 0.2 46.6 8.9 2.5 0 41.8 0 0 0 17.6 0 0 . Working capital & turnover ratios Net working capital Net working capital cost of sales method) -1,066.70 -3,526.80 -1,346.90 -5,102.70 -984 -2,807.30 -311.7 -519.2 -136.4 -476.3 -273.4 -2,656.40 309.5 2,335.70 -356.9 7,901.90 -249 19,127.90 -379.4 -5,388.60 345.8 315.9 306.3 969.5 2.392.80 5,657.50 2,473.90 86.4 0.5 61.9 1.5 Working cycle (days) Raw material cycle WIP cycle Finished goods cycle Debtors cycle Gross working capital cycle Creditors cycle Net working capital cycle 152.5 239.4 579 -339.6 148.9 212.3 706 -493.6 136.9 1 0.4 155.7 294 550 -256 1.2 167.4 514.3 563.8 -49.4 3.7 138.8 458.3 500.5 -42.2 9.2 141.5 457 682.4 -225.4 6.7 147 1,123.30 912.5 210.8 2.5 166.5 2.561.80 1,693.90 867.9 3 196.4 5,856.90 2,829.10 3,027.80 0.1 244.4 2,718.40 3,694.80 -976.4 1.056 1.156 1.191 0.376 0.153 0.065 0.148 4.222 763.864 5.895 238.065 Turnover ratios (times) Raw material turnover WIP turnover Finished goods turnover Debtors turnover Creditors turnover 2.667 373 942.861 2.344 0.664 2.394 0.63 2.451 0.517 313.741 2.181 0.647 99.511 2.63 0.729 39.765 2.58 0.535 54.246 2.483 0.4 147.07 2.192 0.215 121.958 1.859 0.129 4,099.85 1.493 0.099 Asset utilisation ratios (times) Total income / total assets Total income / compensation to employees 0.601 2.985 0.547 3.365 0.539 3.171 0.494 2.575 0.613 3.078 0.629 2.97 0.579 2.598 0.462 2.39 0.406 3.506 0.341 3.751 Sales / GFA excl reval Sales / NFA excl reval Sales net of repairs / NFA excl reval 1.119 2.036 2.036 1.149 2.195 2.195 1.277 2.739 2.739 1.292 3.456 3.456 1.641 5.394 5.394 1.665 6.5 6.5 2.388 7.268 7.268 4.934 7.79 7.79 4.129 8.964 8.964 3.34 7.882 7.882 1 K