# AstraZeneca PLC (AZN) Investment Valuation

January 18th, 2013 Posted by No Comment yet
AstraZeneca PLC (AZN) Investment Valuation. This model is prepared in a very simple and easy way to value a company, it adopts the investment style of the Father of Value Investing Benjamin Graham. The essence is that any investment should be purchased at a discount, meaning the true value should be more than the market value. Graham believed in fundamental analysis and was looking for companies with a sound balance sheet and with little debt. The basis for this valuation is the company’s five years of historical financial records, the balance sheet, income statement, and cash flow statement. We calculated first the enterprise value as our first step. We believed this is important because it measures the total value of the company.

## AZN Investment in Enterprise Value

The concept of enterprise value is to calculate what it would cost to purchase an entire business. Enterprise  Value (EV) is the present value of the entire company.  Market capitalization is the total value of the company’s equity shares. In essence, it is a company’s theoretical takeover price, because the buyer would have to buy all of the stock and pay off existing debt, and taking any remaining cash.  The formula is given below:

Enterprise Value = Market Capitalization + Total Debt – (Cash and Cash Equivalent + Short Term Investment)

#### Explanation

The market capitalization of AZN was stable at an average of \$62.8 billion. The total debt represented 15.3 percent, while cash and cash equivalent were 15.5 percent. Therefore, the total debt was offset by cash and cash equivalent, since this valuation factors the balance sheet account. Digging into results, if an investor decided to buy the entire business of AZN, he/she will be paying 100 percent of its equity.

The purchase price of AstraZeneca plc (ADR) to date, January 16, 2013, would be \$59.3 billion at \$46.26 per share. The market price to date was \$59.08 per share.

### The Net Current Asset Value (NCAV) Method

The Net Current Asset Value (NCAV) is a method from Benjamin Graham to identify whether the stock is trading below the company’s net current asset value per share, specifically two-thirds or 66 percent of net current asset value. Meaning they are essentially trading below the company’s liquidation value and therefore, the stocks is trading in a bargain, and it is worth buying.

#### Explanation

The net current asset value approach tells us that AZN’s stock price was overvalued from 2007 to the trailing twelve months because the market price was greater than the 66 percent ratio. The 66 percent ratio represents only 6 percent of the market price average, therefore the price was overvalued.

What does it mean? It indicates that the stock of AZN traded above the liquidation value of the company.

### Market Capitalization/Net Current Asset Value (MC/NCAV) Valuation

By calculating market capitalization over the net current asset value of the company, we can determine if the stock is trading over or undervalued.

For AZN, the result of MC/NCAV valuation shows that the stock was at an overvalued price because the ratio of MC/NCAV exceeded the 1.2 ratios, therefore the price was expensive.

### The margin of Safety (MOS)

The margin of safety is used to identify the difference between company value and price. Value investing is based on the assumption that two values are attached to all companies – the market price and the company’s business value or true value. Graham called it the intrinsic value. The difference between the two values is called the margin of safety. According to Graham, the investor should invest only if the market price is trading at a discount to its intrinsic value. Value investing is buying with a sufficient margin of safety. Graham considers buying when the market price is considerably lower than the intrinsic or real value, a minimum of 40 to 50 percent below. The enterprise value is used because I think it is a much more accurate measure of the company’s true market value than market capitalization.

#### Explanation

The table shows that the margin of safety was 81 percent average. There was the margin of safety from 2007 to the trailing twelve months. The enterprise value represents only 17 percent of the intrinsic value, therefore the intrinsic value was over 600 percent of the enterprise value.

Intrinsic Value =  Current Earnings x (9 + 2 x Sustainable  Growth Rate)

The explanation in the calculation of intrinsic value was as follows:

EPS or the company’s last 12-month earnings per share; G is the company’s long-term (five years) sustainable growth estimate; 9 as the constant representing the appropriate P-E ratio for a no-growth company as proposed; and 2 for the average yield of high-grade corporate bonds.

#### Explanation

The earning per share was average 5, while the sustainable growth rate was average 21. The annual growth rate was 51 average. On the other hand, the intrinsic value was \$267 average.

The earnings per share (EPS) and the sustainable growth rate (SGR) factor intrinsic value.

#### Earnings per Share (EPS)

Sustainable growth rate (SGR), on the other hand, shows how fast a company can grow using internally generated assets without issuing additional debt or equity. To calculate the sustainable growth rate you need to know the return on equity (ROE). You also need to know the dividend payout ratio. From there, multiply the company’s ROE by its plow back ratio, which is equal to 1 minus the dividend payout ratio.

Sustainable-growth rate = ROE x (1 – dividend-payout ratio)

#### Explanation

Return on Equity (ROE) is an indicator of company’s profitability by measuring how much profit the company generates with the money invested by common stock owners.

Return on Equity shows how many dollars of earnings result from each dollar of equity.  According to Cris, there are two approaches to calculating the sustainable growth rate. These are the relative ratio approach and the average ratio approach. I have summarized the difference between these two approaches in the table given below:

#### Explanation

It shows that the average approach shows a greater result than by applying the relative approach. The margin of safety was greater by 1 percent, so as with the growth and the return on equity.

I want you to understand more clearly the relationship between the price and the intrinsic value in getting the margin of safety.  Please follow me, I will explain to you what does the graph mean.

#### Explanation

The intrinsic value (IV) is the true value of the stock and the EV line is the market price. The stock of AZN is trading below the true value of the stock or in other words, the stock price of AZN is cheap.

Further, the space between the two lines is the margin of safety. The margin of safety is the difference between the enterprise value and the intrinsic value.  So, if we get the difference, the average would be 81 percent. This is the average margin of safety for AZN. The requirement of Benjamin Graham in buying the stock is at least 40-50 percent margin of safety, so this means, the stock of AZN is cheap and is a candidate for buying.

### Price to Earnings/Earning Per Share (P/E*EPS)

This approach will help us determine whether the stocks are undervalued or overvalued by multiplying the Price to Earnings (P/E) ratio with the company’s relative Earning per Share (EPS) and comparing it to the enterprise value per share. This will give us an idea about the status of the stock price.

The P/E*EPS valuation above shows that the stock was trading overvalued in 2007 and 2008. While during 2009 to the trailing twelve months, the stock was trading at an undervalued price. Because the price was lesser than the P/E*EPS ratio. Overall, the stock price is considered undervalued.

### The Enterprise value (EV)/Earning Per Share (EPS) or (EV/EPS)

The use of this ratio is to separate price and earnings in the enterprise value by dividing the enterprise value of projected earnings (EPS). The result represents the price (P/E) and the difference represents the earnings (EPS).

#### Explanation

The EV/EPS valuation, tells us how much is the price and the earnings in the enterprise value. It shows that the average price (P/E) was 20 percent and the earnings (EPS) was 80 percent average.

However, what important here is it separate the P/E and the EPS from the price. This is the price that the investor is willing to pay.

### Enterprise Value (EV)/ Earnings Before Interest, Tax, Depreciation, and Amortization (EBITDA) or (EV/EBITDA)

This metric is used in estimating business valuation.  This metric is useful for analyzing and comparing profitability between companies and industries.  It gives us an idea of how long it would take the earnings of the company to pay off the price of buying the entire business, including debt.

The EV/EBITDA tells us that it will take 5 years to cover the costs of buying the entire business. In other words, it will take 5 times the cash earnings of the company to cover the purchase price.

This valuation also indicates the profitability of the company considering the cash earnings of the company. Exclusive of the non-cash expenses against the market price, net of total debt and cash and cash equivalent. The average net margin of AZN is 23 percent.

In conclusion:

The market capitalization of AstraZeneca plc (ADR) was stable at \$62.8 billion average. The total debt represents 15.3 percent. An investor would be buying 100 percent equity in buying the entire business. The purchase price of the entire business to date, January 16, 2013, is \$59.3 billion at \$46.26 per share. While the market price to date was \$59.08 per share.

The net current asset value approach tells us that the stock was overvalued and expensive. Because the ratio was greater than the 1.2 ratios. Therefore the stock of AZN was expensive.

#### The margin of Safety (MOS)

On the other hand, the margin of safety was 81 percent average. There was a margin of safety from 2007 to the trailing twelve months.  The intrinsic value was \$267 average and the earning per share was 5 average. On the other hand, the sustainable growth rate was 21 average. While the annual growth rate was 51 average.

Moreover, in the EV/EPS valuation, it shows that the price (P/E) 20 percent. Moreover, the earnings (EPS) was 80 percent average.

Furthermore, the EV/EBITDA valuation shows that it will take 5 years to cover the cost of buying AZN.  In other words, it will take 5 times the cash earnings to cover the purchase price. The net margins of the company were 23 percent average.

There is a margin of safety at 81 percent in buying the stock of  AZN. Therefore, I recommend a Buy in the stock of AstraZeneca plc (ADR).

Research and Written by Cris

Interested to learn more about the company? Here’s investment guide for a quick view, company research to know more of its background and history; and value investing guide for the financial status.

Tags: