Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions