Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION: Analyzing the Financial Health in Detail: Balance Sheet and Income Statement Financial Ratios Particulars Mar 2016 Mar 2015 Dec 2013 Dec 2012 Dec 2011
QUESTION: Analyzing the Financial Health in Detail: Balance Sheet and Income Statement
Financial Ratios
Particulars | Mar 2016 | Mar 2015 | Dec 2013 | Dec 2012 | Dec 2011 |
Operational & Financial Ratios | |||||
Earnings Per Share (Rs) | 396.78 | 426.02 | 281.75 | 305.19 | 357.55 |
CEPS(Rs) | 522.58 | 600.67 | 404.11 | 422.07 | 439.65 |
DPS(Rs) | 85.00 | 85.00 | 55.00 | 60.00 | 135.00 |
Book NAV/Share(Rs) | 2639.75 | 2339.81 | 2004.55 | 1774.94 | 1505.86 |
Tax Rate(%) | 32.98 | 31.61 | 29.60 | 28.81 | 28.67 |
Margin Ratios | |||||
Core EBITDA Margin(%) | 16.43 | 15.35 | 13.63 | 14.40 | 17.24 |
EBIT Margin(%) | 16.32 | 15.27 | 13.30 | 14.42 | 17.95 |
Pre Tax Margin(%) | 16.28 | 15.16 | 13.30 | 14.36 | 17.95 |
PAT Margin (%) | 10.91 | 10.37 | 9.36 | 10.22 | 12.80 |
Cash Profit Margin (%) | 14.37 | 14.62 | 13.43 | 14.14 | 15.74 |
Performance Ratios | |||||
ROA(%) | 9.97 | 11.95 | 8.94 | 11.82 | 16.05 |
ROE(%) | 15.94 | 19.61 | 14.91 | 18.60 | 25.44 |
ROCE(%) | 23.58 | 28.28 | 20.47 | 24.94 | 33.46 |
Asset Turnover(x) | 0.91 | 1.15 | 0.96 | 1.16 | 1.25 |
Sales/Fixed Asset(x) | 2.27 | 2.84 | 2.29 | 2.57 | 2.75 |
Working Capital/Sales(x) | 3.71 | 3.82 | 2.51 | 2.54 | 2.70 |
Efficiency Ratios | |||||
Fixed Capital/Sales(x) | 0.44 | 0.35 | 0.44 | 0.39 | 0.36 |
Receivable days | 40.02 | 31.74 | 40.22 | 37.44 | 33.65 |
Inventory Days | 39.56 | 34.99 | 44.28 | 44.36 | 41.46 |
Payable days | 55.93 | 42.39 | 49.94 | 51.92 | 57.59 |
Valuation Parameters | |||||
PER(x) | 52.39 | 59.58 | 35.80 | 31.05 | 18.96 |
PCE(x) | 39.78 | 42.26 | 24.96 | 22.45 | 15.42 |
Price/Book(x) | 7.87 | 10.85 | 5.03 | 5.34 | 4.50 |
Yield(%) | 0.41 | 0.33 | 0.55 | 0.63 | 1.99 |
EV/Net Sales(x) | 5.98 | 6.45 | 3.47 | 3.29 | 2.53 |
EV/Core EBITDA(x) | 28.12 | 30.60 | 18.53 | 16.58 | 11.26 |
EV/EBIT(x) | 34.08 | 39.55 | 24.19 | 21.08 | 13.11 |
EV/CE(x) | 4.85 | 6.54 | 2.91 | 3.06 | 2.99 |
M Cap / Sales | 6.15 | 6.60 | 3.62 | 3.44 | 2.61 |
Growth Ratio | |||||
Net Sales Growth(%) | -12.19 | 38.01 | 1.13 | 6.04 | 22.21 |
Core EBITDA Growth(%) | -11.32 | 55.16 | -4.50 | -6.19 | 25.43 |
EBIT Growth(%) | -5.43 | 56.73 | -7.00 | -14.15 | 30.47 |
PAT Growth(%) | -6.86 | 51.20 | -7.68 | -14.64 | 30.71 |
EPS Growth(%) | -6.86 | 51.20 | -7.68 | -14.64 | 30.71 |
Financial Stability Ratios | |||||
Total Debt/Equity(x) | 0.01 | 0.02 | 0.03 | 0.04 | 0.06 |
Current Ratio(x) | 1.64 | 1.76 | 1.93 | 2.04 | 2.65 |
Quick Ratio(x) | 1.39 | 1.47 | 1.64 | 1.73 | 2.05 |
Interest Cover(x) | 443.64 | 137.78 | 2514.20 | 245.76 | 3936.00 |
Total Debt/Mcap(x) | 0.00 | 0.00 | 0.01 | 0.01 | 0.01 |
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