HC2091: Medibank vs NIB Holdings Financial Analysis Report 2018

This report presents a comprehensive financial analysis comparing Medibank Private Limited and NIB Holdings Limited, two prominent Australian health insurers. It begins with a description of each company, outlining their core activities and competitive advantages within the insurance industry. The analysis employs various financial ratios, including liquidity, profitability, solvency, and efficiency ratios, to assess and compare their financial performance. Key metrics such as current ratio, net profit margin, return on equity, debt-to-equity ratio, and asset turnover ratio are evaluated. Furthermore, the report includes a share price valuation analysis using the dividend growth model and compares the share price movements against the all-ordinary index. The ultimate goal is to provide financial and investment advice, determining whether investing in these organizations would be beneficial for investors.

Selected Company- Medibank Private Ltd and NIB Holdings Ltd
financial analysis of Medibank private limited and NIB Holding Limited
Financial analysis
University Name-

Table of Contents
Introduction.................................................................................................................................................1
Description of the Reject Shop................................................................................................................1
Core activities of the Reject Shop............................................................................................................1
Competitive advantage............................................................................................................................1
Industry...................................................................................................................................................2
Financial analysis of The Reject Shop..........................................................................................................2
Liquidity ratio...........................................................................................................................................2
Current ratio........................................................................................................................................2
Quick ratio...........................................................................................................................................3
Profitability ratio......................................................................................................................................3
Net profit margin.................................................................................................................................3
Return on equity..................................................................................................................................4
Return on assets-.................................................................................................................................4
Gross profit margin..............................................................................................................................4
Solvency ratio......................................................................................................................................4
Debt to equity......................................................................................................................................5
Efficiency ratio.........................................................................................................................................5
Creditors turnover ratio.......................................................................................................................5
Inventory Turnover ratio.....................................................................................................................6
Assets turnover ratio...........................................................................................................................6
Market ratio (General investment proposal analysis).............................................................................6
Dividend payout ratio..........................................................................................................................7
Evaluation of the key points found in this financial analysis.......................................................................7
Analysis to compare the Share price movement of Reject Shop with all ordinary index.............................7
Computation of the value of the stock of the Reject Shop Company......................................................8
Computation of the dividend growth rate of Reject Shop...................................................................9
Recommendation......................................................................................................................................10
Conclusion.................................................................................................................................................10
References.................................................................................................................................................11

Appendix...................................................................................................................................................13
Introduction
With the ramified financial market factors, each and every investor needs to use financial
analysis tools before investing their capital in the particular stocks and shares. In this report,
financial analysis of Medibank private limited and NIB Holding Limited has been take into
consideration to analyses and compare the financial performance, share valuation and capital
structure of these two companies. In the starting of this report, description of both companies,
their competitive advantages and core activities have been discussed. After that financial ratio
analysis has been used to identify the ups and down in the financial performance of company.
Afterward, share price valuation analysis has been done by using the dividend growth models so
that the share price value of company could be assessed. In the end , share price comparison of
the company with another and all ordinary stock exchange have been done so that it could be
determined whether investing capital in organization would be beneficial for the investors to
create value on its investment or not. There are several financial analysis tools have been used
such as Du pont analysis, capital budgeting, dividend growth model, ratio analysis and share
price valuation methods to determine whether company has been creating value on the invested
capital of the investors or not.
Description of the Medibank and NIB Holding Limited
The Medibank Private limited is the Australian national private health insurer which has been
offering its banking and insurance services to its clients throughout the time. It is the second
largest health insurance service provider after BUPA. It has covered at least 29.1% market share
in the insurance industry of the Australia. This company has created value on its investment by
offering insurance services to its clients. Currently, all the shares of company are traded at AUD
$ 3.3 which is 12% higher as compared to last year data.

On the other hand, NIB holding Limited is also one of the health insurer which offers health
insurance and financial services to clients. It has increased its capital investment by 20% with a
view to cover more market share in the insurance sector of the Australia.
Core activities of the Medibank Private Limited
The core activity of Medibank is to provide insurance services to clients so that they could their
health insurance from the most trusted brands.
Competitive advantage
The main competitive advantage of Medibank Organizaiton is related to its health
insurance services. it has been providing unique health insurance services at very low cost which
will help clients to avail these health services at very least cost. It will assist company to grab
more market share.
Industry
The Medibank is indulged in offering its health insurance to its clients in insurance and financial
sectors with the increase in the GDP rate of the Australia; it would be positive factor for the
Medibank to strengthen its overall turnover and market share.
Financial analysis of Medibank private Limited
The financial analysis of Medibank private Limited is used to evaluate the liquidity, profitability,
efficiency and market ratio of company and how well it has performed throughout the time.
Liquidity ratio
The liquidity ratio is used to measure how well company could pay off its long term and short
term liabilities out of its available current assets investment. This ratio has been divided into two
main parts.
Current ratio
The current

Descriptio
n Formula MEDIBANK PRIVATE LTD (Ratio Analysis )
2015` 2016 2017
NIB Holding
Company
Current
ratio
Current assets/current
liabilities 0.62 0.32 0.34 0.42
Quick
Ratio
Current
assets-Inventory/current
liabilities 0.62 0.32 0.34 0.39
Current ratio
The current ratio of Medibank private Limited has decreased by .32 points in 2017 which is very
low as compared to last three year data. Medibank private Limited might face issue in managing
its busienss if the demand of the market increases. On the other hand, NIB Holding has kept .42
current ratio which is .12 points higher as compared to Medibank private Limited. It reflects that
NIB Holding has kept higher liquidity in its capital which might be positive for the company in
case of sluggish market condition.
Quick ratio
The Medibank private Limited does not have inventory in its books of account therefore; the
quick ratio would be equal to its current ratio. ON the other hand, NIB Holding has kept .30
points quick ratio as it has blocked some of its current asset investment in its inventory.
Profitability ratio
The profitability ratio divulges the performance ability of company in terms of the earning made
by company.

Net profit margin
The net profit margin ratio of company reflects the net profit earing of company out of its
available turnover. The Medibank private Limited has kept stable net profit margin in all the last
three years. However, as compared to NIB Holding, Medibank private Limited has 2% higher net
profit margin ratio. This shows that Medibank has been performing well in market than its
competitors.
Descriptio
n Formula MEDIBANK PRIVATE LTD (Ratio Analysis )
2015` 2016 2017
NIB Holding
Company
Net
margin Net profit/revenues 6.27% 6.62% 6.43% 4%
Return on
equity Net profit/Equity 28.99% 28.50% 25.87% 24%
Return on
assets Net profit/ Total assets 13.31% 13.78% 12.85% 12.4
Return on equity
The return on equity reflects the net profit earned by company available to distribute to its equity
shareholders. It reflects how well company has performed throughout the time. The return on
euqtiy of company is way too higher in case of Medibank private limited and it shows how well
company has created value on its investment. However, NIB HOldign is havig return on equity
4% lower if it is compared with the Medibank.
Return on assets-
The return on assets of company has increased by 1% since last one year in case of Medibank
private limited. However, still as compared to NIB holding, return on assets of Medibank is

higher. It reflects that company is consistently increasing its profitability and performing well in
market as compared to others.
Gross profit margin
The gross profit margin of Medibank private limited has increased with the increase in its overall
turnover. However, the gross profit margin has increased to 12% which is 2% higher as
compared to last three year data. On the other hand, NIB Holding has also increased its earning
and kept gross profit margin to 11% in 2017. It reveals that Medibank private limited has
performed well and kept higher profitability as compared to others (Medibank private limited,
2015).
Solvency ratio
This ratio divulges the capital structure and interest coverage ratio of company. the
Descriptio
n Formula MEDIBANK PRIVATE LTD (Ratio Analysis )
2015` 2016 2017
NIB Holding
Company
Debt to
Equity
Ratio Debt/ Equity 1.18 1.07 1.01 2.2
Gearing
ratio Interest/ EBIT - - - 2
Debt to equity ratio
The debt to equity ratio reveals the relation between the debt and equity part of the company in
its capital structure. Medibank private limited has kept 1.01 debts to equity ratio which is very
low as compared to others in market. It is analyzed that as compared to NIB Holding, Medibank

private limited has kept lower debt to equity which may be risky in terms of cost of caaptial. It is
considered that due to the low debt capital portion in its business, Medibank private limited may
have high cost of capital and it will eventually decrease the overall return on capital employed of
company.
Gearing ratio
It is analyzed that gearing ratio reflects how well company could meet its financial interest
payment out of its available earning. It shows its interest coverage capacity in its busienss. It
might negatively impact the business sustainability if company has low interest coverage. In case
of Medibank private limited, it is analyzed that it has kept zero interest coverage or gearing ratio
as it has no amount to pay as its interest payment. On the other hand, NIB Holding company has
kept low interest payment which is positive indicator and higher debt portion will also be helpful
for the Organizaiton to lower down its cost of capital. The interest payment will also be used by
company as tax deduction expenses to lower down the tax expenses (Yahoo Finance, 2017).
Efficiency ratio
This ratio divulges how Medibank private limited could effectively deploy its capital in its
busienss process.
Creditors turnover ratio
The creditor’s turnover ratio reflects times which will be required to pay to its creditors for their
debts. In case of Medibank private limited¸ the creditor’s turnover ratio of company is zero as it
has not kept creditors. On the other hand NIB Holding has kept 51 times creditors which will
assist it to lower down its cost of capital (Medibank private limited, 2016).
Receivable turnover ratio
The receivable turnover ratio of Medibank private limited is zero as it has kept zero debts in its
balance sheet. However, it would be beneficial for the organization as there would be no credit
sales and no amount of capital would be blocked. On the other hand, NIB Holding has kept 45
times debtor’s turnover which may negatively impact the business (NIB Holding, 2015).

Descriptio
n Formula MEDIBANK PRIVATE LTD (Ratio Analysis )
2015` 2016 2017
NIB Holding
Company
Creditors
payable
period creditors / Total sales*365 - - - 51
Inventory
Turnover
ratio COGS/ Sales*365 - - - 245
Asset
turnover
ratio Total sales/ Total assets 2.12 2.08 2.00 4
Inventory Turnover ratio
The inventory turnover ratio Medibank private limited is zero as it has not kept capital in its
inventory. It would be beneficial for the organization as there would be no amount of capital
blocked in its inventory. On the other hand, NIB Holding has kept 245 times inventory’s
turnover which may result to increased cost of capital and may also negatively impact the
busienss (Talebnia, Jaberzadeh, and Salehi, (2015).
Assets turnover ratio
The assets turnover ratio of Medibank private limited has been stable since last three years.
Company has not been performing well but the assets turnover ratio of company is also not that
high. NIB Holding company has kept 4 times assets turnover which is positive indicator for the
future growth of the organization.

Market ratio (General investment proposal analysis)
The market ratio of company has shown how well company has increased the amount of profit
available to its equity shareholders. It is analyzed that company has the dividend payout ratio of
company has increased effectively with the increase in its profit. It has followed profit based
dividend policy.
Descriptio
n Formula MEDIBANK PRIVATE LTD (Ratio Analysis )
2015` 2016 2017
NIB Holding
Company
PE Ratio MPS/EPS 18.97 23.16 25.12 32
Dividend
Payout
dividend payment/ Earning
*100
-
0.5717703
35 -0.631111111 -0.696629213 -0.823
Dividend payout ratio
The Medibank has increased its dividend payment to its equity shareholders which may be
positive indicator for the future growth of the organization. However, as compared to NIB
holding, it has decreased their PE ratios which reflect the negative outcomes for Medibank. On
the other hand, NIB Holding has kept dividend payout 80% of its earning which is 10% higher as
compared to Medibank Private limited (Tayeh, Al-Jarrah, and Tarhini, (2015).
Evaluation of the key points found in this financial analysis
There are several main key points that have been found after implementing the financial analysis
 Medibank Private limited has kept low financial leverage so it has been carrying high
cost of capital.
 The profitability of company is not increasing effectively and dividend payout is very
high.

As compared to NIB Holding, Medibank Private limited has low financial performance in
terms of profitability and solvency.
Analysis to compare the Share price movement of Medibank Private
limited with all ordinary index and NIB holding
It is analyzed that the share price movement of Medibank is having high fluctuation. It is
analyzed that the share price movement of Medibank private holding is having increase and
decrease in its share price. It is analyzed that in 2016 company had good amount of increment in
its share price. On the other hand, NIB holding faced high downfall in its share price in 2016 due
to its legal compliance issues. It is analyzed that both companies are facing high fluctuation and
when the share price of both companies are compared with the all ordinary stock then it reflects
that these companies are not performing well in market and negatively impacting the busienss in
long run (Uechi, et al. (2015).
1/1/2016
4/1/2016
7/1/2016
10/1/2016
1/1/2017
4/1/2017
7/1/2017
10/1/2017
1/1/2018
4/1/2018
7/1/2018
(0.15)
(0.10)
(0.05)
-
0.05
0.10
0.15
0.20
MEDIBANK PRIVATE LTD
Adj Close (All ordinary share
index)
NIB Holding Return
Source: (The Reject Shop, 2016).
The high share price fluctuation of NIB Holding is stable in 2017 and 2018. However, in case of
Medibank Company, the share price went up in the December 2017 and after that the share price
was stable in 2017 and 2018. This shows that due to the stable profitability and low amount of
busienss loss the share price movement of Medibank is reflecting the positive indicator. It is

inferred that the share price movement of all ordinary index is very lost and reflecting the
positive indicator. If investors invest their capital in all ordinary index share companies then they
will have higher return on capital employed (Delen, Kuzey, and Uyar, (2013).
Computation of the value of the stock of the Reject Shop Company
The dividend growth model is the model which is used to compute the share value of company.
It uses the divided paid to shareholders, growth rate and cost of capital of company (Ehiedu,
2014).
Formula:
Value of the stock = D1/ KE-G
Computation of the dividend growth rate of Medibank Private limited
The return on equity of company has been computed in ratio analysis
ROE= 25.97%
Retention ratio=20%
Growth= 90%*8.8=5.5%
Growth rate would be= 5.5%
But as per the question dividend growth rate is 14%
So we will take 14% growth rate.
Cost of capital = 9%
Last year dividend is =.27

Value of the stock = D1/ KE-G
P1= .27/9%-25.97%
AUD $ -1.66
The market price of Medibank Private limited would be AUD $ -1.66 on the other hand, the
future share price of NIB Holding will also be AUD $ -1.933.
Recommendation
 Investors should invest their capital in NIB holding as it has more profitability in this
business and efficiently used its capital
 Due to the sluggish market condition, shareholders may face high in creating value on its
investment. Investors if have other options to invest their capital then they should opt to
invest their capital in other investment options.
 The financial leverage of both companies are showing the negative indictor which might
negatively impacted the business growth and will negatively impact the capital
investment of shareholders (Mwangi, and Murigu, (2015).
Conclusion
These both companies have been facing profitability, solvency and busienss efficiency issue in
its busienss. It is analyzed that if investors want to invest their capital in these two companies
then they should invest their capital for the long term basis. It is analyzed that due to the low
profitability and less efficient busienss ratio divulged that investors might face issue in creating
value on its investment if they invest their capital in these two companies. However, if investors
want to choose one company to invest their capital out of these both companies then they should
invest their capital in NIB holding company as it has good efficiency ratio.

References
Delen, Kuzey, and Uyar, (2013). Measuring firm performance using financial ratios: A decision
tree approach. Expert Systems with Applications, 40(10), pp.3970-3983.
Ehiedu, V.C., (2014). The impact of liquidity on profitability of some selected companies: The
financial statement analysis (FSA) approach. Research Journal of Finance and Accounting, 5(5),
pp.81-90.
Medibank private limited, (2015), Annual report, Available at
https://www.medibank.com.au/about/investor-centre/results-reports/annual-reports/., ., Accessed on
19th September, 2018,
Medibank private limited, (2016), Annual report, Available at
https://www.medibank.com.au/about/investor-centre/results-reports/annual-reports/., ., Accessed on
19th September, 2018,
Mwangi, M. and Murigu, J.W., (2015). The determinants of financial performance in general
insurance companies in Kenya. European Scientific Journal, ESJ, 11(1). pp.81-90.
NIB Holding , (2016), Annual report, Available at https://www.nib.com.au/shareholders/financial-
results., ., Accessed on 19th September, 2018,
NIB Holding, (2015), Annual report, Available at https://www.nib.com.au/shareholders/financial-
results., , , Accessed on 19th September, 2018,
Talebnia, G., Jaberzadeh, F. and Salehi, M., (2015) Study Information Content of
Comprehensive income by Focusing on Firm Size. Asian Journal of Research in Banking and
Finance, 5(1), pp.111-118.
Tayeh, M., Al-Jarrah, I.M. and Tarhini, A., (2015). Accounting vs. market-based measures of
firm performance related 2nd ed, Australia: Pearson.

Uechi, L., Akutsu, T., Stanley, H.E., Marcus, A.J. and Kenett, D.Y., (2015). Sector dominance
ratio analysis of financial markets. Physica A: Statistical Mechanics and its Applications, 421,
pp.488-509.
Yahoo Finance, 2017, ‘Medibank Limied, Available at https://in.finance.yahoo.com/quote/DEB.L/.,
, Accessed on 19th September, 2018,
Yahoo Finance, 2017, ‘NIB Holding, Available at https://in.finance.yahoo.com/quote/DEB.L/., ,
Accessed on 19th September, 2018,

Appendix
Descripti
on MEDIBANK PRIVATE LTD (M
2015 2016 2017
Revenue 6,666.00 6,796.00 6,916.00
Cost of
goods
sold
12,498.0
0 12,575.00 12,748.00
Gross
profit 546.00 629.00 628.00
Operating
profit 546.00 629.00 628.00
Net profit 418.00 450.00 445.00
Interest - - -
Inventory - - -
Current
assets 1,047.00 540.00 591.00
Receivabl
es 131.00 152.00 130.00
Current
liabilities 1,699.00 1,687.00 1,743.00
Payables - - -
Equity 1,442.00 1,579.00 1,720.00
Total
liabilities 1,699.00 1,688.00 1,743.00
Total
assets 3,141.00 3,266.00 3,462.00
Market
price 5.50 6.60 6.50
Descripti
on Formula MEDIBANK PRIVATE LTD (Ratio Analaysis )
2015` 2016 2017
NIB
Holding
Company
Profitabil
ity

Net
margin
Net
profit/revenues 6.27% 6.62% 6.43% 4%
Return on
equity Net profit/Equity 28.99% 28.50% 25.87% 24.00%
Return on
assets
Net profit/ Total
assets 13.31% 13.78% 12.85% 12.4
Liquidity
Current
ratio
Current
assets/current
liabilities 0.62 0.32 0.34 0.42
Quick
Ratio
Current assets-
Inventory/current
liabilities 0.62 0.32 0.34 0.39
Efficienc
y
Creditors
payble
period
creditors / Total
sales*365 - - - 51
Inventory
Turnover
ratio
COGS/
Sales*365 - - - 245
Asset
turnover
ratio
Total sales/ Total
assets 2.12 2.08 2.00 4
Solvency
Debt to
Equity
Ratio Debt/ Equity 1.18 1.07 1.01 2.2
Gearing
ratio Interest/ EBIT - - - 2
Market
Ratio
PE Ratio MPS/EPS 18.97 23.16 25.12 32
Dividend
Payout
dividend
payment/ Earnign
*100
-
0.57177
0335 -0.631111111 -0.696629213 -0.823

Dat
e
MEDIBANK
PRIVATE LTD _
Adj Close
MED
IBAN
K
PRIV
ATE
LTD
Adj Close (All
ordinary share
index)
(All ordinary
share
index)Average
Return
NIB
Holdings
Limited
(NHF.AX
31/0
1/20
16 null - 5310.399902 - null
29/0
2/20
16 2.375205 - 5644 0.06 6.11533
31/0
3/20
16 2.393617 0.01 5529.399902
-
0.02 6.561846
30/0
4/20
16 2.596154 0.08 5525.200195
-
0.00 6.561846
31/0
5/20
16 2.485679
-
0.04 5402.399902
-
0.02 6.513311
30/0
6/20
16 2.596154 0.04 5502.399902 0.02 6.833638
31/0
7/20
16 2.596154 - 5719.100098 0.04 6.192985
31/0
8/20
16 2.729831 0.05 5675
-
0.01 5.476743
30/0
9/20
16 2.579737
-
0.05 5761 0.02 5.378417
31/1
0/20
16 2.626642 0.02 5903.799805 0.02 5.634064
30/1
1/20
16 2.551595
-
0.03 5947.600098 0.01 5.545571
31/1
2/20
16 2.851783 0.12 5761.299805
-
0.03 6.410837
31/0
1/20
17 2.739212
-
0.04 5764 0.00 5.761888
28/0 2.944886 5773.899902 5.815

2/20
17 0.08 0.00
31/0
3/20
17 3.136735 0.07 5776.299805 0.00 null
30/0
4/20
17 3.15592 0.01 5744.899902
-
0.01 5.580008077
31/0
5/20
17 3.213475 0.02 5976.399902 0.04 5.511201802
30/0
6/20
17 3.040811
-
0.05 6057.200195 0.01 5.442395527
31/0
7/20
17 2.781814
-
0.09 6167.299805 0.02 5.373589253
31/0
8/20
17 2.860376 0.03 6130.399902
-
0.01 5.304782978
30/0
9/20
17 2.860376 - 6131.399902 0.00 5.235976703
31/1
0/20
17 2.850614
-
0.00 6287.299944 0.03 5.167170429
30/1
1/20
17 3.036099 0.07 6359.699951 0.01 5.098364154
31/1
2/20
17 2.967762
-
0.02 6432.099958 0.01 5.029557879
31/0
1/20
18 2.840852
-
0.04 6504.499965 0.01 4.960751604
28/0
2/20
18 2.86 0.01 6576.899972 0.01 4.89194533
31/0
3/20
18 3.105 0.09 6649.299979 0.01 4.823139055
30/0
4/20
18 2.733962
-
0.12 6721.699985 0.01 4.75433278
31/0
5/20
2.558208 -
0.06
6794.099992
0.01
null

18
30/0
6/20
18 2.773019 0.08 6866.499999 0.01 4.685526505