Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started