Question: In the provided data below of NDTV, do ratio analysis for the year range 2015-2019: 1. Liquidity Ratios (Current Ratio & Debt to equity ratio)

In the provided data below of NDTV, do ratio analysis for the year range 2015-2019:

1. Liquidity Ratios (Current Ratio & Debt to equity ratio)

2. Profitability Ratio (Operating Margin, Net profit Margin & Return on net worth)

Please share graph representations and interpretation for all the each and every ratio. (Interpretation is a must)

Note: To view the image clearly, click on the image and open the image in a new tab. By doing this you can see data very clearly.

In the provided data below of NDTV, do ratio analysis for the

New Delhi Television Ltd. Executive Summary : Mar 2011 - Mar 2020 : Non-Annualised: Rs. Million Mar-15 12 mths IGAAP Mar-16 12 mths IGAAP Mar-17 12 mths INDAS Mar-18 12 mths Mar-19 12 mths INDAS INDAS Total income Sales Income from financial services 4,353.30 4,255.10 22.5 4,343.90 4,281.90 15.3 3,902.20 3,761.60 73.3 3,120.80 3,009.50 77.2 2.767.40 2,538.50 83.4 Change in stock Total expenses Raw materials, stores & Spares Power, fuel & water charges Compensation to employees Interest expenses Depreciation 4,609,10 2.6 63.3 1,391.30 197.5 212.7 4,560.00 2.8 61.6 1,450,40 160.4 184.5 4,352.80 1.6 54.5 1,478.40 145 160.5 3,735.20 0.9 47.6 1,292.10 145.2 131.2 2,634.20 0.4 38.5 750.9 158.8 94.9 Profits PBDITA PBDITA net of P&E&OI&FI Profit after tax (PAT) PAT net of P&E 385.5 290 -255.8 -323.4 166.8 105.9 -216.1 -251.1 -105.4 -169.2 -450.6 -435.3 -220.1 -201.6 -614.4 -517.3 496.1 312.6 133.2 43.6 Total liabilities Shareholders' funds Paid up equity capital Reserves and funds Non-current liabilities (incl long term provns) Long term borrowings Current liabilities incl short term provns 7,098.30 3,394.20 257.9 3,136.30 824.5 264.1 2,879.60 6,711.60 3.178.10 257.9 2,920.20 699.2 35.6 2,834.30 6,772.90 2,893.00 257.9 2,635.10 689 7.1 3,190.90 6,739.90 2,244.20 257.9 1,986.30 721 0 3,774.70 6,882.40 2.360.60 257.9 2,102.70 703.2 3,818.60 Net worth Tangible net worth 3,394.20 3,375.10 3.178.10 3.163.40 2,893.00 2,883.50 2,244.20 2,237.40 2,360.60 2,356.80 Total assets Non-current assets Net fixed assets Long term investments Current assets (incl short term invest & adv) 7.098.30 4,200.00 731 2,990.40 2,898,30 6,711.60 4,001,80 586.5 2,748.90 2,709.80 6,772.90 3,818.20 448.6 3,067.70 2,954.70 6,739.90 3,934,10 324.1 3,136.80 2.805.80 6,882.40 3,819.80 242.3 3,197.10 3,062.60 Profitability ratios (%) Operating margin Net profit margin Return on net worth Return on total assets Return on capital employed 6.8 -7.6 -9.2 -4.6 -6 2.5 -5.8 -7.6 -3.6 -5.2 -4.5 -11.3 - 14.3 -6.5 -10.1 -6.7 -16.8 -20.1 -7.7 -13.7 12.3 1.7 1.9 0.6 1.3 1.121 0.885 0.922 Liquidity ratios (times) Current ratio Debt to equity ratio Interest cover 0.95 0.531 0.898 0.419 0.421 0.541 0.403 1.265 x Average cost of Funds (%) 10.5 10.2 11.4 11.9 14.7 Efficiency ratios (times) Total income / total assets Sales /NFA excl reval Total income / compensation to employees 0.613 5.394 3.078 0.629 6.5 2.97 0.579 7.268 2.598 0.462 7.79 2.39 0.406 8.964 3.506 New Delhi Television Ltd. Executive Summary : Mar 2011 - Mar 2020 : Non-Annualised: Rs. Million Mar-15 12 mths IGAAP Mar-16 12 mths IGAAP Mar-17 12 mths INDAS Mar-18 12 mths Mar-19 12 mths INDAS INDAS Total income Sales Income from financial services 4,353.30 4,255.10 22.5 4,343.90 4,281.90 15.3 3,902.20 3,761.60 73.3 3,120.80 3,009.50 77.2 2.767.40 2,538.50 83.4 Change in stock Total expenses Raw materials, stores & Spares Power, fuel & water charges Compensation to employees Interest expenses Depreciation 4,609,10 2.6 63.3 1,391.30 197.5 212.7 4,560.00 2.8 61.6 1,450,40 160.4 184.5 4,352.80 1.6 54.5 1,478.40 145 160.5 3,735.20 0.9 47.6 1,292.10 145.2 131.2 2,634.20 0.4 38.5 750.9 158.8 94.9 Profits PBDITA PBDITA net of P&E&OI&FI Profit after tax (PAT) PAT net of P&E 385.5 290 -255.8 -323.4 166.8 105.9 -216.1 -251.1 -105.4 -169.2 -450.6 -435.3 -220.1 -201.6 -614.4 -517.3 496.1 312.6 133.2 43.6 Total liabilities Shareholders' funds Paid up equity capital Reserves and funds Non-current liabilities (incl long term provns) Long term borrowings Current liabilities incl short term provns 7,098.30 3,394.20 257.9 3,136.30 824.5 264.1 2,879.60 6,711.60 3.178.10 257.9 2,920.20 699.2 35.6 2,834.30 6,772.90 2,893.00 257.9 2,635.10 689 7.1 3,190.90 6,739.90 2,244.20 257.9 1,986.30 721 0 3,774.70 6,882.40 2.360.60 257.9 2,102.70 703.2 3,818.60 Net worth Tangible net worth 3,394.20 3,375.10 3.178.10 3.163.40 2,893.00 2,883.50 2,244.20 2,237.40 2,360.60 2,356.80 Total assets Non-current assets Net fixed assets Long term investments Current assets (incl short term invest & adv) 7.098.30 4,200.00 731 2,990.40 2,898,30 6,711.60 4,001,80 586.5 2,748.90 2,709.80 6,772.90 3,818.20 448.6 3,067.70 2,954.70 6,739.90 3,934,10 324.1 3,136.80 2.805.80 6,882.40 3,819.80 242.3 3,197.10 3,062.60 Profitability ratios (%) Operating margin Net profit margin Return on net worth Return on total assets Return on capital employed 6.8 -7.6 -9.2 -4.6 -6 2.5 -5.8 -7.6 -3.6 -5.2 -4.5 -11.3 - 14.3 -6.5 -10.1 -6.7 -16.8 -20.1 -7.7 -13.7 12.3 1.7 1.9 0.6 1.3 1.121 0.885 0.922 Liquidity ratios (times) Current ratio Debt to equity ratio Interest cover 0.95 0.531 0.898 0.419 0.421 0.541 0.403 1.265 x Average cost of Funds (%) 10.5 10.2 11.4 11.9 14.7 Efficiency ratios (times) Total income / total assets Sales /NFA excl reval Total income / compensation to employees 0.613 5.394 3.078 0.629 6.5 2.97 0.579 7.268 2.598 0.462 7.79 2.39 0.406 8.964 3.506

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!