Know Your Worth
What is Know Your Worth ?
As a module in the app, Know Your Worth assists you in determining the Economic / Intrinsic Value of a Company. The module consists of two sub-sections: Early Stage and Growth & Mature Stage Companies. This module helps a user to conduct Valuation of any Company in any Country and in any Currency.
This section elucidates terms, methodology, and models used in the app, which will help to determine the Economic / Intrinsic Value of a Company. The app uses the Perpetuity with Real Constant NOPAT Model to determine Residual Value and the model assumes that the Companies are being valued as a Going Concern.
What are Economic Value, Intrinsic Value, Enterprise Value and Shareholder Value ?
The Economic or Intrinsic Value of Company is a Discounted Cash Flow (DCF) Valuation where the Cost of Capital discounts the Future Cash Flows in Perpetuity to arrive at the Present Value of Cash Flows. These Cash Flows consists of two parts:
- Cash Flows during the Forecast Period.
- Cash Flows Post Forecast Period (Residual Period).
The Value Augmentation of a Company is most pronounced during the Forecast Period. During the post Forecast Period – also referred to as Residual period – the assumption in the model is that the Company would not create any additional value since it would earn equivalent to its Cost of Capital. It is also assumed that the Company would be able to sustain its Net Operating Profit after Tax (NOPAT) in real terms post the Forecast Period.
The Cash Flows generated during these periods belong to Debt Holders and Shareholders. Thus the Economic or Intrinsic Value of the Company would thus be the sum of Equity and Debt Values, also referred to as the Enterprise Value of a business. The value of the Equity is referred to as Shareholder Value. Therefore:
- Enterprise Value = Shareholder Value + Debt Value (includes all interest bearing obligations)
- Shareholder Value = Enterprise Value – Debt (Further the Company’s Statement Of Affairs may also contain Non-Operating Balance Sheet elements such as Cash, Securities, Investments & Other Assets and Minority Interest & Other Liabilities that are not utilized for generating Operating Cash Flows which may need to be added or subtracted to arrive at Enterprise and Shareholder Value.)
- Shareholder Value therefore is:
- The Present Value (PV) of Cash Flows from Operations during the Forecast Period Plus
- Present Value of Residual Value of the Company’s business, referable to the period beyond the Forecast Period Plus
- Cash & Marketable Securities and Other Investments (The Income from these Investments should not be included in Cash Flows from Operations) Minus
- Minority Interest and Other Liabilities Minus
- Debt and Long Term Obligations.
What is Present Value of Cash Flow from Operations ?
Cash Flow from Operations is Operating Cash Inflows less Operating Cash Outflows. Cash Inflows is Operating Profit and Cash Outflows is Incremental Fixed Assets Investments, Incremental Net Working Capital (NWC) Investments and Income Tax.
The Cash Flow from Operations is estimated for each year in the Forecast Period, which is then discounted back to the present. The Cost of Capital or the Weighted Average of the Cost of Debt and Equity Capital (WACC) discounts the Cash Flows. In the App we use the WACC to discount the Cash Flows.
Table 1.1 demonstrates the computation of Present Value of Cash Flows for a Forecast Period of 5 years with a discount rate of 11%.
Table 1.1
Year | 1 | 2 | 3 | 4 | 5 |
---|---|---|---|---|---|
Cash Flow | 1000 | 1500 | 2000 | 2500 | 3000 |
11 % Discount Factor | 0.901 | 0.812 | 0.731 | 0.659 | 0.593 |
Present Value of Cash Flow | 900.9 | 1217.4 | 1462.4 | 1646.8 | 1780.4 |
Cumulative PV of Cash Flow | 900.9 | 2118.3 | 3580.7 | 5227.5 | 7007.9 |
Discount factor = |
1 (1 + 0.11)n |
The Cumulative Present Value of Cash Flows during the Forecast Period is 7007.9.
Cash Flow Drivers
What is Forecast Period ?
Prior to any Valuation, it is imperative to know the Number of years for which Valuation is to be based on. These years constitute the period for which the Company is expected to generate returns in excess of its Cost of Capital. This could be from a single year to 15 years and if companies have significant competitive advantage then these could be over 15 years and even go up to 30 years.
The model used in the App, assumes that post the Forecast Period, Incremental Investments would not create value and the Company will be able to sustain its NOPAT in real terms. The App permits the Forecast Period to be a maximum of 30 Years.
When using the App, enter the number of years for which the Valuation is to be based on. The maximum period of forecast in the app is limited to 30 years.
What is Sales in Prior Period ?
The starting point of estimating Cash Flows is Sales and the Growth Rate of Sales. The Sales is the Sales in the Prior Period and should exclude non-operating income.
What is Prior Period?
The Prior Period is ideally the 12-month trailing period for which the data is to be entered, for instance June 30, 2017. In case data is not easily available for 12 months the user may enter the data for immediately preceding fiscal year – for instance, March 31, 2017.
What is Sales Growth Rate ?
The user should estimate the Sales for the Forecast Period either in Values or Sales Growth Percentage to Prior Period Sales. This can be done by estimating Compounded Annual Growth Rate (CAGR) or by a yearly percentage of growth.
When using the App, the user may enter either CAGR or different growth rates for each individual year. In case of start-ups, if the Sales were zero in the previous and or subsequent years, the user must enter zero and not a percentage until the time there are sales.
What is Operating Profit Margin ?
Operating Profit Margin (OPM) is the Earnings before Interest and Income Tax (EBIT), and after deducting Depreciation.
To arrive at the Operating Profit, all expenses including Depreciation should be deducted. The Operating Profit Margin should not include Other Income.
To compute the Cash Flow the user must also deduct Depreciation from Operating Profit though a non-cash item - however other non-cash items such as amortization of intangibles should not be deducted.
Further the user also needs to remember to deduct the Depreciation from Capital Expenditure to arrive at the correct Cash Flow.
A significant portion of the Shareholder Value is in the Residual Value. The Target Year (Last Year of the Forecast Period) Operating Profit is the key driver in computing the Residual Value, thus the user needs to carefully ascertain the Operating Profit / Margin for the Target Year.
When using the App, the user must enter the Operating Profit / Margin percentage for the Prior Period either in Values or as Percentage to Sales. During the Forecast Period enter the Operating Profit / Margin either uniform for all the years or for each individual year. In the case of start-ups, if the Sales were zero in the previous and or subsequent years, the user must enter Operating Profit Values and not a percentage, until the time there are Sales.
What is Incremental Investment Rate ?
Incremental Investment Rate is Incremental Fixed Asset Rate plus Incremental Net Working Capital Investment Rate.
What is Incremental Fixed Assets Investment Rate ?
The Incremental Fixed Assets Investment represents the Net Investments in Fixed Assets and Intangibles (Net Block of Fixed Assets). The Fixed Asset Investments forms a part of Company’s operations to support Sales Growth. This Investment Rate can be expressed as a percentage of Incremental Sales.
The Incremental Fixed Assets Investment is defined as Capital Expenditures less Depreciation expense for the year.
Incremental Fixed Assets Investment = Capital Expenditures – Depreciation expense
And can be expressed as
Incremental Fixed Assets |
Incremental Sales |
What is Incremental Net Working Capital Investment Rate?
The Incremental Net Working Capital (NWC) Investment represents the Investments in Current Assets less Current Liabilities. The Incremental Net Working Capital Investments forms a part of Company's operations to support Sales. Short-term borrowings should be excluded from Current Liabilities and will form a part of Debt and Obligations.
This Investment can be expressed as a percentage of Incremental Sales Growth.
Incremental NWC Investment Rate | = | Incremental NWC Investments |
Incremental Sales |
When using the App, the user must enter the Incremental NWC Investment either in Values or as Incremental NWC to Incremental Sales Rate. The user can enter the Incremental NWC Investment / Rate uniform for all the years or for each individual year. In the case of start-ups, if the Sales were zero in the previous and or subsequent years, the user must enter Incremental NWC Investment in Values and not a percentage, until the time there are Sales.
What is Income Tax Rate during Forecast Period ?
The Income Tax Rate represents taxes on the Operating Profit for a year, which a Company is likely to incur during the Forecast Period. There could be a difference in the Cash Income Tax Rate and the Income Tax Rate due to Company polices of recognizing some revenue and expense items at different times, for financial accounts and tax accounts.
When using the App, the user must ideally enter the Marginal Income Tax Rate, the Company is likely to incur during the Forecast Period and not the Cash Income Tax Rate, since any excess or less Tax paid, would be set off in the subsequent years.
What is Income Tax Rate during Residual Period ?
Income Tax Rate during the Residual Period is the rate companies expect to pay during the post-Forecast Period. This should be the Marginal Income Tax Rate.
When using the App, the user must enter the Residual Income Tax Rate expected during the Residual period.
How to compute Net Cash Flows ?
Example for computing Net Cash Flow of Joy Sweets
Assumptions
Forecast Period | 5 Years |
Sales in Prior Period | 1000 |
Sales Growth, CAGR | 15% |
Operating Profit Margin | 18% |
Income Tax | 33% |
Incremental Fixed Assets Investment Rate | 35% |
Incremental Net Working Capital Investment Rate | 30% |
Computation of Net Cash Flow
Table 1.2
Year | 0 | 1 | 2 | 3 | 4 | 5 |
Sales | 1000 | 1,150 | 1,323 | 1,521 | 1,749 | 2,011 |
Operating Profit | 207 | 238 | 274 | 315 | 362 | |
Income Tax | 68 | 79 | 90 | 104 | 119 | |
Incremental Fixed Assets | 53 | 60 | 69 | 80 | 92 | |
Incremental Net Working Capital | 45 | 52 | 60 | 68 | 79 | |
Net Cash Flow | 41 | 47 | 54 | 63 | 72 |
We have now computed the Cash Flows from operations for Joy Sweets based on various parameters or value drivers.
We also need to arrive at a Present Value of these Cash Flows for which we require a Cost of Capital to discount the Cash Flows. The Cost of Capital is explained in the Capital Structure section.
Balance Sheet Items
Which Balance Sheet items are required to be included to value a company ?
The Company may have Non-Operating Assets not utilisied for generating Operating Cash Flows.
We therefore require Balance sheet items, which will consist of
- Non-Operating Assets not utilized to generate Operating Cash Flows and
- Liabilities such as Debt, Minority Interest and Other Liabilities
To be added or subtracted to arrive at the Shareholder Value.
What is Non-Operating Assets ?
Non-Operating assets are those Assets that are not required for generating Operating Cash Flows. These could be Cash & Securities, Investments, Other Assets etc
What is Cash & Securities ?
This is the Cash and Securities at Market Value including short-term Investment as on the Prior Period ending for the Company.
When using the App the user must enter the Cash and Securities for the Prior Period.
What is Investments ?
This is the Investments in the books as on the Prior Period. This would be the estimated Market Value of Investment in Subsidiaries or Joint Venture or Other Partnerships for which the financial information would not be consolidated and no part of it should form a part of the Profit and Loss Account.
When using the App, the user must enter the Investments at Market Value if any as on the Prior Period ended.
What is Other Assets ?
The items in Other Assets could include Deferred Tax Assets and other Non-Operating Assets and expected Contingent Assets. The Income from these Assets should not be considered as Revenue / Sales.
What is Minority Interest ?
This is the Market Value of Minority Interest. This should be entered if the Company is being valued on consolidated basis for these Investments and there is a Minority Interest.
When using the App, the user must enter the Minority Interest if any as on the Prior Period ended.
What is Other Liabilities ?
This should include Deferred Tax Liabilities, Non-Interest Bearing Obligations, Under Funded Pensions and Health Care Obligations and Expected Contingent Liabilities as on Prior Period Ended.
What is Debt & Obligations ?
This is the Value of Debt and Interest Bearing Obligations as on Prior Period Ended. The Debt portion should include Short Term Borrowings.
What is Carry Forward Losses ?
These are Losses in the books as on the Prior Period ended. The model assumes that the losses will be set off against any future profits until the Target Year. The Target Year is the last year of the Forecast Period.
When using the App, the user must enter the Carry Forward Losses figure. This will offset the Income Tax payable in future years until the last year of the Forecast Period.
The App ignores any Carry Forward Loss post Forecast Period.
What is Outstanding Shares ?
Outstanding shares is the Company’s Stock / Shares currently held by all its Shareholders. This should include Equity Options, Convertible Shares and Warrant Options.
When using the App, the user must enter the number of outstanding shares as on the Prior Period ended.
Capital Structure
What is Market Capitalization or Estimated Valuation ?
Market Capitalization is the Market Value of a Company’s outstanding shares. This is calculated by multiplying a Company’s outstanding shares by the current market price of a share.
When using the App, the user must enter the Market Capitalization or in case of early stage companies the estimated latest Valuation of the Company - usually the Valuation as on the last round of funding. Entering this figure is necessary since the Debt Equity Ratio is computed based on the Market Value of the Company’s Equity.
What is Debt Equity Ratio ?
We compute the Debt Equity Ratio based on Market Values since Investors demand returns on Market Valuation and not Book Value.
The user can either use the Debt Equity Ratio as computed based on Market Capitalization or Change the Debt Equity Ratio if the user expects the Long Term Debt Equity Ratio to be different from the Ratio computed based on the Market Capitalization. The app will then use the revised Debt Equity Ratio to compute WACC, while ignoring computation based on Market Capitalization.
When using the App, the user must enter the Debt Equity Ratio only if the user expects it to change during the Forecast Period or has not entered the Market Capitalization.
What are Cost of Capital and WACC ?
We need to arrive at a Present Value of Operating Cash Flows for which we require a Cost of Capital to discount the Cash Flows.
We use the Weighted Average Cost of Capital (WACC) to compute the Cost Of Capital and discount the Cash Flows by the WACC. WACC is the weighted average Cost of Debt and Equity Capital. For example, if a Company’s pre-tax Cost of Debt is 10%, estimated Cost of Equity 15%, Income Tax Rate is 30%, and it finances its business growth by Debt 40% and Equity 60%, then the Weighted Average Cost of Capital would be computed as follows:
Table 1.3
Weight | Cost | Weighted Cost | |
% | % | % | |
Debt (After Tax) | 40 | 7 | 2.8 |
Equity | 60 | 15 | 9.0 |
Cost of Capital | 11.8 |
Note:
- Post tax Cost of Debt equals Cost of Debt (1 - Tax Rate) = 10% * (1 - 30%) = 7%
- Cost of Capital is also called Weighted Average Cost of Capital (WACC)
What is Cost of Debt ?
Cost of Debt is the expected Cost of Long Term Debt. The Intrinsic Value involves forecasting Future Cash Flows and discounting it by future discount rates. The model assumes the Cost of Debt to remain uniform during the forecast period. The Cost of Debt should be the Cost of Debt of the Currency in which the Company is being Valued.
The Cost of Debt is Pre-tax and in Nominal terms is measured as follows:
Real Interest Rate + Expected Inflation Rate + Default Spread.
Hence, if the Cost of Debt would be 9.75% and Income Tax Rate at 33% then the after tax Cost of Debt will be 9.75% (1 - 33%) = 6.53%.
In the App, the user must enter the Pre-tax Cost of Debt in nominal terms.
What is Real Interest Rate ?
The Real Interest Rate is the rate of interest an investor or lender receives (or expects to receive) after factoring inflation. It can be described more formally by the Fisher equation, which states that the real interest rate is approximately the Nominal Interest Rate minus the Inflation Rate.
What is Risk Free Rate ?
A Risk Free Rate is a rate of return on Investment with no risk or financial loss. This is a Bond Treasury Rate issued by the government. Risk Free Rate varies from country to country and from currency to currency.
Risk Free Rate = Real Interest Rate + Expected Inflation.
Please note that Risk Free Rates vary across varying time horizons and should be consistent with Forecast Period while doing Valuation.
What is Default Spread ?
Default Spread is the difference between the Cost of Debt to the borrower and the Risk Free Rate.
What is Expected Inflation ?
Expected Inflation is the Expected Inflation Rate of the Currency during the forecast period. It is normally built in to the Risk Free Rate.
To elucidate: For a country in 2016, the Real Interest Rate is 2% and the Expected Inflation is 5.25%. If a Company’s default spread is 2.5% then the Pre-tax Cost of Debt is 9.75%. It is necessary to understand that the Risk Free Rate is Real Interest Rate + Expected Inflation Rate which is 2% + 5.25% = 7.25%
When using the App, the user must enter the Pre-tax Cost of Debt in nominal terms.
What is Cost of Equity ?
Cost of Equity is an expected rate of return required by the investors to invest in the Company’s shares. The Equity Investors generally require a risk-free rate plus an additional return called Equity Risk Premium (ERP) for investing in a Company’s shares to compensate for the risk undertaken by the investors.
The model that explains the relationship between the systematic risk and the expected return on Assets, particularly stocks, is referred to as The Capital Asset Pricing Model (CAPM). This model is used extensively to evaluate risky securities, expected returns on Assets based on the risk level of the Assets, and for calculating the Costs of Capital.
The formula for calculating the expected return of an asset given its risk is as follows:
Simply,
Cost of Equity = Risk Free Rate + Equity Risk Premium, where
Risk-free Rate = Real Interest Rate + Expected Inflation Rate
Equity Risk Premium = Beta (Expected Return on Market - Risk Free Rate)
The Expected Return on Market represents the additional return expected by investors to invest in the Equity market versus risk-free government bonds.
The Beta coefficient is the measure of volatility or systematic risk of the stock in comparison to the market as a whole. The individual stocks tend to be riskier or less risky than the market and the Beta measures this risk. Beta is easily obtainable from various financial online sites.
The expected Return on Equity varies across investor types. For example, venture capitalists would demand higher returns than a stock market investor. Returns also depend on lifecycle stage of a Company.
In case the user finds computing Beta and Cost of Equity under the Capital Asset Pricing Model (CAPM) cumbersome, then the user may use a hurdle rate as Cost of Equity or Stock Market Expected Returns on Equity, or any other reference as the Cost of Equity.
When using the App, the user must enter the Cost of Equity for the Forecast Period. This may be uniform for all the years or the user can opt to enter the Cost of Equity individually for each year.
What is Expected Market Returns and Expected Return Over Inflation ?
The Expected Market Return is the return expected by the Investors for an Investment made in companies represented in the Index. The Expected Market Return is an important concept in risk management, because it is used to determine the market risk premium. The Market Risk Premium, in turn, is part of the Capital Asset Pricing Model, (CAPM) formula.
The returns on individual stocks may be considerably higher or lower depending on their volatility relative to the market represented by Beta of the Stock.
One way to compute Expected Market Return is to add the Expected Inflation Rate and the Real Returns (Returns Over Inflation in the Stock Market).
The Real Return (Market Return plus Dividend Yield Less Inflation) for the S&P 500 as analysed for a period of 100 years (1918 – 2017) and the Geometric Average is about 7.13% over Inflation.
It is possible to compute the Expected Market Returns by adding the Expected Return Over Inflation (Real Return) to Inflation. Hence, if the inflation rate is 2%, the Expected Market Return will be about 9.13% (2%+7.13%).
How to compute WACC / Cost of Capital ?
Example of Joy Sweets for Computing WACC / Cost of Capital
Market Cap | 3000 |
Debt | 1000 |
Cost of Debt | 10% |
Income Tax | 33% |
Cost of Equity | 15% |
Table 1.4
Computation of WACC (Cost of Capital) Post Tax Cost of Debt = Debt Cost x (1 - t) = 10% (1 - 33%) |
||||
Weight | Post tax cost | Weight Cost | ||
Debt | 1000 | 25% | 6.70% | 1.68% |
Equity | 3000 | 75% | 15% | 11.25% |
Cost of Capital /WACC | 4000 | 100% | 12.93% |
Present Value of Cash Flows
In the following table, we discount the Cash Flows of Joy Sweets with Cost of Capital (WACC) computed above.
Table 1.5
Net Cash Flow | 41 | 47 | 54 | 63 | 72 | |
Discount Factor | 1 | 0.886 | 0.784 | 0.694 | 0.615 | 0.545 |
PV of Cash Flows | 36 | 37 | 38 | 39 | 39 | |
Cumulative PV of Cash Flows | 36 | 74 | 111 | 150 | 189 |
What is Residual Value or Terminal Value ?
As mentioned earlier in this section the Free Cash Flows over the Forecast Period represent the first part of a Company’s value. The model values Companies as a going concern thus a Company continues to have value post the Forecast Period – the Cash Flows continue to remain.This part of the Cash Flow (Post Forecast Period) is called Residual Value or Terminal Value.
Residual Value is the value of a Company post the Forecast Period and it is assumed the owners will earn only the minimum required rate of return. Residual Value often constitutes most of a Company’s total value.
What is Residual / Terminal Value under Perpetuity with Real Constant NOPAT Model ?
We have used the Perpetuity with Real Constant NOPAT Model to compute Residual Value. This model assumes that any future Investments, beyond the Forecast Period, would not create value and a Company would be able to sustain its Net Operating Profit after Tax (NOPAT) in real terms post the Forecast Period.
This is because in order to survive, companies would need to cope with long-term inflationary pressures.
The Perpetuity with Real Constant NOPAT Model in other words assumes that the NOPAT will cope up with the inflation and thus grow in perpetuity at the Inflation Rate, in the post-Forecast Period or will remain constant in real terms. The formula for the Present Value of Residual Value is that of a growing perpetuity as follows:
Residual Value | = | NOPAT x (1 + Inflation Rate) |
WACC in Real Terms |
1. NOPAT in Target Year. Thus estimating the Target Year Operating Profit thus forms a crucial parameter in arriving at a Valuation
Present Value of Residual Value = Residual Value x Discount Factor at end of Forecast Period.
What is Cost of Debt in Real Terms ?
Cost of Debt in Real Terms = Cost of Debt – Expected Inflation Rate
The App automatically computes Cost of Debt in real terms by deducting expected inflation. There is no entry point in the App for Cost of Debt in real terms.
What is Cost of Equity in Real Terms ?
Cost of Equity in Real Terms = Cost of Equity – Expected Inflation Rate.
The App automatically computes Cost of Equity in real terms by deducting expected inflation. There is no entry point in the App for Cost of Equity in real terms.
What is Cost of Equity during Residual Period ?
This is the Cost of Equity expected during the Residual Period. This should be closer to Market Returns since it is expected that companies would become Mature Companies during the Residual Period.
The app automatically computes Cost of Equity in Real Terms by deducting the Inflation Rate.
When using the App, the user must enter The Cost of Equity during Residual Period in nominal terms.
What is WACC in Real Terms ?
In the Perpetuity Real Constant NOPAT Model, it would be required to divide the NOPAT by WACC in real terms. The computation of WACC in Real Terms is shown in the example below:
Example of Computation of WACC Real in computing Residual Value for Joy Sweets:
Computation of WACC (Cost of Capital) | |
Debt | 1000 |
Equity | 3000 |
Cost of Debt | 10% |
Cost of Equity | 15% |
Tax Rate | 33% |
Inflation Rate | 5% |
Risk Free Rate | 7% |
Table 1.6
Computation Of WACC In Residual Value - Real | |||
Cost of Debt in Real Terms = 10% - 5% = 5% | |||
Cost of Equity in Real Terms = 15% - 5% = 10% | |||
Post tax Cost of Debt= 5% * (1 - 33%) = 3.35% | |||
Weight | Weighted Cost | ||
Debt | 1000 | 0.25 | 0.84% |
Equity | 3000 | 0.75 | 7.50% |
4000 | 1 | ||
WACC in Real Term | 8.34% |
How to compute the Present Value of Residual Value ?
Table 1.7
Computation of Present Value of Residual Value Of Joy Sweets
Operating Profit in Year 5 | 362 | |||||
Income Tax Rate in Residual Value | 33% | |||||
Cost of Equity | 15% | |||||
Cost of Debt | 10% | |||||
Debt : Equity Ratio | Debt | 25% | ||||
Equity | 75% | |||||
Inflation | 5% | |||||
5th Year Discount Factor | 0.545 | |||||
Residual Value: |
= 1664 |
How to compute Valuation ?
Thus the Valuation of Joy Sweets is computed as follows:
Table 1.8
Valuation and Joy Sweets | ||||||
0 | 1 | 2 | 3 | 4 | 5 | |
Sales | 1000 | 1150 | 1323 | 1521 | 1749 | 2011 |
Operating Profit | 207 | 238 | 274 | 315 | 362 | |
Income Tax | 68 | 79 | 90 | 104 | 119 | |
Incremental Fixed Assets | 53 | 60 | 69 | 80 | 92 | |
Incremental Net Working Capital | 45 | 52 | 60 | 68 | 79 | |
Net Cash Flow | 41 | 47 | 54 | 63 | 72 | |
Discount Factor | 1 | 0.886 | 0.784 | 0.694 | 0.615 | 0.545 |
PV of Cash Flows | 36 | 37 | 38 | 39 | 39 | |
Cumulative PV of Cash Flows | 36 | 74 | 111 | 150 | 189 |
Cumulative Present Value of Cash Flow | 189 |
Present Value of Residual Value | 1664 |
Cash, Securities and Investments | 750 |
Minority Interest | 300 |
Enterprise Value | 2303 |
Debt | (1000) |
Shareholder Value | 1303 |
No of Shares | 150 |
Price per share | 8.69 |
When using the App, the user must enter the requested data and information in the Know Your Worth module to get:
- Valuation Report
- Shareholder Value Augmented Report (Explained in the Value Augmentation Section)
Summary Illustration - Valuation
Now that the estimation procedures for the calculation components of Shareholder Value-Cash Flow from operations, Cost of Capital, and Residual Value, have been explained, let us look at an illustration that incorporates all of the components. Consider a business Snap Value with the following five-year forecast:
Assumption for Snap Value | ||
Forecast Period | 5 years | |
Expected Inflation Rate | % | 5% |
Sales in Prior Period | In Mn | 150 |
CAGR of Sales (all 5 Years) | % | 11% |
Operating Profit Margin Prior Period | ||
Operating Profit Margin (all 5 years) | % | 10% |
Incremental Fixed Assets Investment | % | 24% |
Incremental Net Working Capital Investment | % | 20% |
Income Tax rate in Forecast Period | % | 35% |
Income Tax Rate in Residual Period | % | 35% |
Cash Securities | In Mn | 30 |
Investment and Other Assets | In Mn | 0 |
Minority Interest and Other Liabilities | In Mn | 10 |
Debt & Obligations | In Mn | 50 |
Carry Forward Losses | In Mn | 0 |
Outstanding Shares | In Mn | 30 |
Market Capitalization | In Mn | 70 |
Cost of Debt | % | 10% |
Cost of Equity in Forecast Period | % | 16% |
Cost of Equity in Residual Period | % | 16% |
Table 1.9
Valuation of Snap Value | ||||||
1 | 2 | 3 | 4 | 5 | ||
Sales | 150 | 166.50 | 184.82 | 205.14 | 227.71 | 252.76 |
Operating Profit | 16.65 | 18.48 | 20.51 | 22.77 | 25.28 | |
Income Tax | 5.83 | 6.47 | 7.18 | 7.97 | 8.85 | |
Incremental Fixed Assets | 3.96 | 4.40 | 4.88 | 5.42 | 6.01 | |
Incremental Net Working Capital | 3.30 | 3.66 | 4.07 | 4.51 | 5.01 | |
Net Cash Flow | 3.56 | 3.95 | 4.39 | 4.87 | 5.41 | |
Discount Factor | 1 | 0.89 | 0.80 | 0.71 | 0.63 | 0.57 |
Present Value Of Free Cash Flow | 3.18 | 3.15 | 3.12 | 3.09 | 3.06 | |
Cumulative Present Value of Cash Flows | 15.61 | |||||
Residual Value | 222 | |||||
Present Value of Residual Value | 126 | |||||
Cumulative PV + Residual Value | 141 | |||||
Cash Securities & Investments | 30 | |||||
Minority Interest | 10 | |||||
Enterprise Value | 161 | |||||
Less: - Debt & Obligations | 50 | |||||
Shareholder Value | 111 | |||||
No of Shares | 30 | |||||
Price per share | 3.7 | |||||
Shareholder Value Augmented | 9.6 |
1 | 2 | 3 | 4 | 5 | |
Future Value Per Share | 4.3 | 5 | 5.8 | 6.7 | 7.8 |
Shareholder Value Augmented | 2.0 | 1.9 | 1.9 | 1.9 | 1.9 |
What is Shareholder Value Augmented (SVAg) ?
SVAg is the difference in Shareholder Value between two time periods. Total SVAg denotes the Shareholder Value Augmented during the Forecast Period. For more details please refer to FAQs on Value Augmentation.
What is Future Value Per Share ?
Future Value Per Share is derived by the process of compounding the Present Value Per Share by the Cost of Equity used to discount the Cash flows for that year.
Capital Markets & Expectations Valuation
What is Expectations Valuation Concept ?
Expectations Valuation is a concept that deals with the Stock Market Prices and based on those, it is possible to analyze and understand the Expectations Value Drivers built in to the Stock Market Price and also supports decision making. This helps the Investors and Businesses to determine whether a stock is undervalued or overvalued and practise Value Investing. The tool is valuable for both, Investors and Businesses.
In the earlier section, we showed how to arrive at Shareholder Value of a Company using Discounted Cash Flows (DCF). Here we use the same Concepts but we start with the Market Capitalization / Estimated Valuation to arrive at the Shareholder Value. In other words, Expectations Valuation Concept is an inverse computation from Market Capitalization to Expectations Value Drivers.
How do I Compute Expectations Valuation ?
The process is similar to arriving at the Shareholder Value. Here we start estimating the Cash Flows and discount it by the Cost of Capital to arrive at the Shareholder Value and we continue the process until we equate the Shareholder Value to the Market Value to arrive at the Expectations Value Drivers. The price to value equation is derived through a sound iteration process.
What Information or Inputs do I need before Iterating ?
We start with the Prior Period information and Basic information and these include Currency in which the company is being valued, the Sales and Operating Profit Margin in the Prior Period, Income Tax in Forecast and Residual Period as well as the Non-Operating Assets of the Balance Sheet, such as Cash and Securities, Investments and Other Assets, Minority Interest and Other Liabilities. As well as Debt and Obligations, Carry Forward Losses, Outstanding Shares and Market Capitalization. All of these have been explained in the Know Your Worth Module. Then we start estimating the Cash Flows and discount it by the Cost of Capital to arrive at the Shareholder Value and we continue the process until we equate it to the Market Value.
The illustration below explains and demonstrates the steps required to arrive at the Expectations Value Drivers of Z Media under two Scenarios, which will equate the Shareholder Value equivalent to its Market Capitalization.
Assumptions for Z Media
Currency | INR |
Figures in | Millions |
Sales in Prior Period | 1000 |
Operating Profit Margin in Prior Period | 10% |
Income Tax Rate | |
- Forecast Period | 33% |
- Residual Period | 33% |
Market Capitalisation | 2500 |
Debt Ratio | 28.5% |
Equity Ratio | 71.5% |
Cash and Securities | 750 |
Investments and Other Assets | 0 |
Minority Interest and Other Liabilities | 300 |
Debt and Obligations | 1000 |
Carry Forward Losses | 0 |
Outstanding Shares | 150 |
Which are the Value Drivers one can Iterate ?
In the app, there are Nine Value Drivers in the Expectations Valuation Module that can be iterated.
1. Forecast Period
The first Value Driver is the number of years of Free Cash Flows on which the Valuation is based on. How many years the user estimates Shareholder Value to be created? This can range from a single year up to 30 years depending upon the industry dynamics, market strategy, opportunity, barriers to entry and competitiveness. This will help to ascertain how many years of Forecast Period the Market is building in the Stock Price.
In the case of Z Media we assume 15 years and 20 years Forecast Period and proceed. In case we are unable to equate Values then on can also come back and Iterate.
2. Expected Inflation Rate
In this step, we need to estimate the Long Term Expected Inflation Rate of the Currency we are valuing the Company in. For instance, the Long Term Inflation Rate of Indian Rupee is say 4%. We must take care of the inflation built in other inputs such as, Cost of Debt and Cost of Equity to be consistent with the inflation assumptions.
3. Sales Growth Rate (CAGR)
The next step is estimating the expected Sales Growth Rate (CAGR) for the Forecast Period. This is based on the Market Opportunity, Industry dynamics, Company’s Strategy etc.
For Z Media we have assumed a CAGR of Sales to be 16% and 14% for 15 years and 20 years respectively.
4. Target Operating Profit Margin
The next step in the process is estimation of the Target Operating Profit Margin at the end of the Forecast Period. What will be the margin the company will attain by the end of the Forecast Period or during its mature stage?
Operating Profit is the key driver in computing the Residual Value, thus the user needs to ascertain carefully the Operating Profit Margin for the Target Year.
The benefit of the App is that it equates and equalizes the difference between the Operating Profit Margin of the Year Prior with the Target Year.
For Z Media we assume Target Operating Profit Margin of 22% in the 15th year and 20th year.
5. Incremental Fixed Asset Investment Rate
This is the step in the process of iteration where the user would need to estimate the Incremental Fixed Assets (including intangibles) Investment Rate.
Incremental Sales
The Company to grow its sales during the Forecast Period will need to Invest in Incremental Fixed Assets.
For Z Media we assume Incremental Fixed Asset Investment Rate to be 22% during the Forecast Period under both the Scenarios.
6. Incremental Net Working Capital Investment Rate
This is the step in the process of iteration where the user would need to estimate the Incremental Net Working Capital Investment Rate
Incremental NWC Investments |
Incremental Sales |
The Company to grow its sales during the Forecast Period will need to Invest in Incremental Working Capital.
For Z Media we assume Incremental NWC Investment Rate to be 22% during the Forecast Period under both the Scenarios.
7. Cost of Debt
This step the user needs to estimate the expected future cost of Pre-tax Long Term Debt in Nominal terms.
The user should review the Forecast Period, Expected Inflation Rate, and Risk Free Rate for the Currency and the Default Spread for the Company before entering this data.
In the illustration of Z media we take the Cost of Debt as 8.5% for both the scenarios.
The Cost of Debt can be broken down theoretically as the Inflation Rate + Real Interest Rate + Default Spread where, say, Inflation Rate is 4%, Real Interest Rate is 2.5% and the Default Spread is 2%.
8. Cost of Equity
In the next step the user needs to estimate the Cost of Equity. This could be based on Capital Asset Pricing Model (CAPM), Other Models or could just be the implicit return rate of the market or as investors require. The user must enter the Cost of Equity in Nominal Terms.
For Z media, we take the Cost of Equity as 13.5% for both the scenarios.
As per the Capital Asset Pricing Model the Cost of Equity can be theoretically broken down into Equity Risk Premium + Risk Free Rate (Real Interest Rate + Inflation Rate).
9. Cost of Equity Residual
In this step the user must estimate the Cost of Equity expected during the Residual Period. This should be closer to Market Returns since it is expected that companies would become Mature Companies during the Residual Period. The user must enter the Cost of Equity for Residual Period in Nominal Terms.
For Z media, we take the Cost of Equity as 13.5% for both the scenarios.
As per the Capital Asset Pricing Model the Cost of Equity can be theoretically broken down into Equity Risk Premium + Risk Free Rate (Real Interest Rate + Inflation Rate).
The FAQs with regard to Know Your Worth will provide a detailed explanation of the terms and value drivers mentioned above.
If we compute the Shareholder Value based on the above expectations we get the following results:
Table 2.1
Expectations Valuation | Scenario | |
1 | 2 | |
Market Capitalization | 2500 | 2500 |
Forecast Period | 15 | 20 |
Expected Inflation Rate | 4% | 4% |
CAGR of Sales | 16% | 14% |
Operating Profit Margin | ||
- Prior Period | 10.00% | 10.00% |
- Target Year | 22.00% | 22.00% |
Incremental Investment Rate | ||
- Fixed Assets | 22.00% | 22.00% |
- Net Working Capital | 22.00% | 22.00% |
Cost of Debt | 8.5% | 8.5% |
Cost of Equity | ||
- Forecast Period | 13.5% | 13.5% |
- Residual Period | 13.5% | 13.5% |
Shareholder Value | 4326 | 4227 |
Shareholder Value Per Share | 28.8 | 28.1 |
After estimating the Expectations Value Drivers, we now compare the Market Capitalization with the Shareholder Value. As it is evident, the Shareholder Value does not equate with the Market Capitalization.
Hence, we now proceed to Iterate the Value Drivers to get the equation between Price and Value.
Summary Illustration - Iterate to Equate Shareholder Value to Market Capitalization
We now address the gap by using our skill and judgment to change any of the Expectations Value Drivers and continue iterating until we equate the Shareholder Value to Market Capitalization under both the Scenarios.
We iterate the Expectations Value Drivers for the two Scenarios as follows:
Table 2.2
Expectations Valuation | Scenario | |
1 | 2 | |
Market Capitalization | 2500 | 2500 |
Forecast Period | 10 | 15 |
Expected Inflation Rate | 4% | 4% |
CAGR of Sales | 15% | 13% |
Operating Profit Margin | ||
- Prior Period | 10% | 10% |
- Target Year | 19.65% | 19.2% |
Incremental Investment Rate | ||
- Fixed Assets | 22% | 22% |
- Net Working Capital | 22% | 22% |
Cost of Debt | 8.5% | 8.5% |
Cost of Equity | ||
- Forecast Period | 13.5% | 13.5% |
- Residual Period | 13.5% | 13.5% |
Shareholder Value | 2504 | 2511 |
Shareholder Value Per Share | 16.7 | 16.74 |
In the above example we have changed the Forecast Period, CAGR of Sales and Target Operating Profit Margin to equate the Shareholder Value to Market Capitalization.
The user can change any of the Expectations Value Drivers to equate.
How frequently should one do Expectations Valuation ?
Expectations Valuation is a continuous and frequent process as companies stock prices respond to earnings, disclosures of new information, competition, strategies and news on a regular basis and in most cases, the magnitude of changes could be significant. The user is able to match the thought process of the market and understand the existing equation between price and value, through the process of Expectations Valuation.
The App helps you to undertake this exercise quickly in minutes in one Screen.
Can we do an Expectations Valuation for a Start-up Company ?
Expectations Valuation can be done for any type of company. In fact, it is very important for both Entrepreneurs and Investors to understand what is getting built in a Valuation and what the Expectations are.
Can Expectations Valuation be done before a Valuation is undertaken ?
Yes it can be done.
In the App, the user can get detailed reports for the two Scenarios on:
- Cash Flow Report
- Valuation Report
The Expectations Valuation FAQs is best understood while undertaking an example in the App and reading it along with the Tool Tips.
PERCEPTION
What is PErception?
PErception is a Concept Module that deals with the Stock Market Prices, Price Earnings Multiple, Cost of Equity and Earnings Growth and based on these it is possible to:
- Value the Company based on its Earnings Growth
- Understand what P/E drivers are built in the Stock Price.
- Compute the Forward P/E Multiples based on the Earnings Growth Forecasted.
This Section of the FAQ assumes that the reader has understood the Discounted Cash Flow (DCF) Valuation explained in the earlier section of the FAQs.
What is P/E?
P/E ratio is Price Earnings Multiple. The Price-Earnings ratio (P/E ratio) is the Price divided by the Earnings Per Share of the Company for the period.
What's Your P/E?
What’s Your P/E?
What's Your P/E is a Module that helps you to arrive at P / E of a Stock based on the Earnings Growth (Net Income or PAT) Forecasted and the Cost of Equity of the Company. The Model discounts the Future Earnings by the Cost of Equity to arrive at the Present Value (Discounted Future Earnings Model). It can also be used to find Equity Value of a stock based on Earnings and its Growth.
What is Expected Inflation Rate?
Expected Inflation is the Expected Inflation Rate of the Currency during the forecast period. It is normally built in to the Risk Free Rate.
What is Net Income?
Net Income is Profit After Taxes and after Preferred Dividend.
What is Forecast Period?
Prior to any Valuation, it is imperative to know the Number of years for which Valuation is to be based on. This could be from a single year to 15 years and if companies have significant competitive advantage then these could be over 15 years and even go upto 30 years.
The model used in the App, assumes that post the Forecast Period, the company will be able to sustain its Net Income (Profit After Tax) in real terms. The App permits the Forecast Period to be a maximum of 30 Years.
When using the App, enter the number of years for which the Valuation is to be based on. The maximum period of forecast in the app is limited to 30 years.
How do you compute Equity Value based on Earning Growth?
Equity Value is the sum of Cumulative Present Value of Earnings during the Forecast Period and the Present Value of Earnings during the Residual period.Here is an illustration to explain the computation
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | ||||
Net Income | 100 | 110 | 121 | 133.1 | 146.41 | 161.05 | 177.15 | ||||
Growth Rate | 10% | 10% | 10% | 10% | 10% | 10% | 10% | ||||
EPS | 1 | 1.1 | 1.21 | 1.33 | 1.46 | 1.61 | 1.77 | ||||
Discount Factor | 1 | 0.833 | 0.694 | 0.579 | 0.482 | 0.402 | 0.335 | ||||
Present Value of Profit After Tax | - | 91.66 | 84.02 | 77.02 | 70.60 | 64.71 | 59.31 | ||||
Total Cumulative Present Value | 447.32 | ||||||||||
Inflation | 4% | ||||||||||
Cost of Equity | 20% | ||||||||||
Residual Value: |
|
||||||||||
Present Value of residual Value | 385.54 | ||||||||||
Equity Valuation | 832.86 |
What is Cost of Equity for Forecast period and Residual Period?
Cost of Equity is an expected rate of return required by the investors to invest in the Company’s shares.
The model that explains the relationship between the systematic risk and the expected return on Assets, particularly stocks, is referred to as The Capital Asset Pricing Model (CAPM). This model is used extensively to evaluate risky securities, expected returns on Assets based on the risk level of the Assets, and for calculating the Cost of Equity for the Forecasted period.
The Equity Investors generally require a Risk-Free Rate plus an additional return called Equity Risk Premium (ERP) for investing in a Company’s shares to compensate for the risk undertaken by the investors.
Equity Risk Premium = Beta (Expected Return on Market - Risk Free Rate).
In case the user finds computing Beta and Cost of Equity under the Capital Asset Pricing Model (CAPM) cumbersome, then the user may use a hurdle rate as Cost of Equity or Stock Market Expected Returns on Equity, or any other reference as the Cost of Equity.
The Cost of Equity varies across investor types. Cost of Equity also depends on the lifecycle stage of a Company.
The Cost of Equity for the Residual period should be closer to Market Returns since it is expected that companies would become Mature Companies during the Residual Period.
What is P/E Forward?
A P/E Forward ratio is a Equity Value (Present Value) of the Stock divided by the EPS for the Forecast Year.
What is Future Value Per Share?
Future Value Per Share is derived by the process of compounding the Present Value Per Share by the Cost of Equity used to discount the Cash flows for that year.
Decrypt Stock P/E
What is Decrypt Stock P/E Concept?
Decrypt Stock P/E is Price to Earnings multiple that deals with the Stock Market Prices, Price Earnings Multiple Cost of Equity and Earnings Growth and based on these it is possible to understand what P/E drivers are built in the Stock Price (Price Scenario) and build own Expectations in the Value Scenario and understand the gap that exists between Price and Value. This supports decision making. This helps the Investors and Businesses to determine whether a stock is undervalued or overvalued and practise Value Investing.
The Model Discounts the Future Earning by the Cost of Equity (Discounted Future Earnings Model).
In the earlier section, What’s Your P/E we showed how to arrive at Equity Value of a Company using Discounted future Earnings. Here, we use the same Concepts, but we start with the Market Capitalization / Estimated Valuation to arrive at the Equity Value. In other words, Decrypt Stock P/E Concept is an inverse computation from Market Capitalization to Expectation P/E Drivers.
What Information or Inputs do I need before Iterating?
We start with the Prior Period information and Basic information and these include Currency in which the company is being value, the Outstanding Shares and the Figures In which the value needs to be computed. Then by using the P/E drivers we can equate the Equity Value with the Market Price in the Price Scenario and determine the difference between the price and value by assuming P/E drivers in the Value Scenario.
The illustration below explains and demonstrates the steps required to arrive at the Expectation P/E Drivers of Z Media under the Price Scenario which will equate the Equity Value equivalent to its Market Price. Under the Value Scenario we build our own Expectations of P/E Drivers and understand the Gap that exists between Price and Value.
Assumptions of Z Media
Currency | INR |
Figures in | Millions |
Outstanding Shares | 150 |
Which are the P/E Drivers one can iterate?
In the app, there are Eight P/E Drivers in the Expectations Valuation Module that can be iterated under Price Scenario to understand what’s built in the Equity Value
-
Market Price
This is the current Market Price of the company which is currently trading in the Stock Market. The Market Price can be last traded Price or the Price on date of the Company’s previous reported Financial Results.
In the case of Z Media, we assume Market Price to be 40 and proceed.
-
P/E Ratio
This is the Ratio of the Price to Earnings of a Company for valuing a company that measures its current share price relative to its per-share earnings.
In the case of Z Media, we assume the P/E Ratio to be 11 and proceed.
-
EPS
This is the Earnings Per Share of the company. This is a computed figure and is computed by dividing the Market Price by the P/E Ratio of the Company.
In the case of Z Media, the EPS is 3.64 i.e. Market Price (40) / PE Ratio (11).
-
Forecast Period
The Forecast Period is the number of years of Free Cash Flows on which the Valuation is based on. This can range from a single year up to 30 years depending upon the industry dynamics, market strategy, opportunity, barriers to entry and competitiveness. This will help to ascertain how many years of Forecast Period the Market is building in the Stock Price.
In the case of Z Media, we assume 10 years Forecast Period and proceed. In case we are unable to equate Equity Value to Market Price then one can also come back and iterate. This is done under the Price Scenario.
-
Expected Inflation Rate
In this step, we need to estimate the Expected Inflation Rate of the Currency we are valuing the Company in.
For instance, the Expected Inflation Rate of Indian Rupee is say 4%.
We must take care of the inflation built in other inputs such as, Cost of Debt and Cost of Equity to be consistent with the inflation assumptions.
-
CAGR of EPS
The next step is estimating the expected CAGR of EPS for the Forecast Period. This is based on the Market Opportunity, Industry dynamics, Company’s Strategy etc.
For Z Media we have assumed a CAGR of Sales to be 7.5% for 10 years.
-
Cost of Equity
In the next step the user needs to estimate the Cost of Equity. This could be based on Capital Asset Pricing Model (CAPM), Other Models or could just be the implicit return rate of the market or as investors require. The user must enter the Cost of Equity in Nominal Terms.
For Z media, we take the Cost of Equity as 13%.
As per the Capital Asset Pricing Model the Cost of Equity can be theoretically broken down into Equity Risk Premium + Risk Free Rate (Real Interest Rate + Inflation Rate).
-
Cost of Equity Residual
In this step the user must estimate the Cost of Equity expected during the Residual Period. This should be closer to Market Returns since it is expected that companies would become Mature Companies during the Residual Period. The user must enter the Cost of Equity for Residual Period in Nominal Terms.
For Z Media, we take the Cost of Equity in Residual Period as 13%.
P/E Stock Decrypt | Scenario | |
Price | Value | |
Market Price | 40 | |
P/E Ratio | 11 | |
EPS | 3.64 | |
Forecast Period | 10 | |
Expected Inflation Rate | 4% | |
CAGR of EPS | 7.5% | |
Cost of Equity | 13% | |
Cost of Equity Residual | 13% | |
Equity Value / Share | 53.42 | |
P/E Forward | 13.66 |
After estimating the P/E Drivers, we can now compare the Market Price with the Equity Value. As it is evident, the Equity Value doesn’t equate with the Market Price.
Hence, we now proceed to Iterate the P/E drivers to get the Equation between Price and Value.
How do we Iterate?
We now address the gap by using our skill and judgment to change any of the P/E Drivers and continue iterating until we equate the Market Price with the Equity Value in the Price Scenario. We iterate the P/E Drivers for Price Scenario and also build our own assumptions under the Value Scenario as follows:
P/E Stock Decrypt | Scenario | |
Price | Value | |
Market Price | 40 | 40 |
P/E Ratio | 11 | 11 |
EPS | 3.64 | 3.64 |
Forecast Period | 10 | 10 |
Expected Inflation Rate | 4% | 4% |
CAGR of EPS | 4.85% | 8.50% |
Cost of Equity | 15% | 14% |
Cost of Equity Residual | 16% | 14% |
Equity Value / Share | 35.18 | 51.23 |
P/E Forward | 9.21 | 12.97 |
After estimating the P/E Drivers, we can now compare the Market Price with the Equity Value. As it is evident, the Equity Value doesn’t equate with the Market Price.
Hence, we now proceed to Iterate the P/E drivers to get the Equation between Price and Value.
In the above example (Price Scenario) we have changed the CAGR of EPS, Cost of Equity in Forecast and Residual Period.
How frequently should one do P/E Stock Valuation?
P/E Stock Valuation is a continuous and frequent process as company’s stock prices respond to earnings, disclosures of new information, competition, strategies and news on a regular basis and in most cases, the magnitude of changes could be significant. The user is able to match the thought process of the market and understand the existing equation between price and value. The App helps you to undertake this exercise quickly in minutes in one Screen.
Can Decrypt Stock P/E be done before a Valuation is undertaken?
Yes, it can be done.
In the App,the user can get detailed reports for the two Scenarios:
- P/E Report
- Valuation Report
The P/E Valuation FAQs is best understood while undertaking an example in the App and reading it along with the Tool Tips.
Decrypt Index P/E
What is Decrypt Index P/E Concept?
Decrypt Index P/E is Price to Earnings multiple that deals with the Index Prices, Price Earnings Multiple, Expected Market Returns and Earnings Growth and based on these it is possible to understand what P/E drivers are built in the Index Price (Price Scenario) and build own Expectations in the Value Scenario and understand the gap that exists between Price and Value. This supports decision making. This helps the Investors to determine whether an Index is undervalued or overvalued and practise Value Investing.
The Model Discounts the Future Earning by the Expected Market Returns (Discounted Future Earnings Model).
What Information or Inputs do I need before Iterating?
We start with the Prior Period information and Basic information and these include Currency in which the Index is being valued, which the value needs to be computed. Then by using the P/E Drivers we can equate the Index Value with the Market Price in the Price Scenario and determine the difference between the Price and Value by assuming P/E drivers in the Value Scenario.
The illustration below explains and demonstrates the steps required to arrive at the Expectations P/E Drivers of Nifty under the Price Scenario which will equate the Index Value equivalent to its Index Price. Under the Value Scenario we build our own Expectations of P/E Drivers and understand the Gap that exists between Price and Value.
Assumptions of Nifty
Currency | INR |
Prior Period | October 2018 |
Which are the P/E Drivers one can iterate?
In the app, there are Eight P/E Drivers in the Decrypt Index P/E Module that can be iterated under Price Scenario to understand what’s built in the Index Value
- Index Price
- P/E Ratio
- EPS
- Forecast Period
- Expected Inflation Rate
- CAGR of EPS
- Expected Market Returns Forecast Period
- Expected Market Returns Residual Period
This is the current Index Price of the Index.
In the case of Nifty, we assume Index Price to be 10,600 and proceed.
This is the Ratio of the Price to Earnings of an index.
In the case of Nifty, the P/E Ratio as on October 31, 2018 to be 24.92 and proceed.
This is the Earnings Per Share of the index. This is a computed figure and is computed by dividing the Index Price by the P/E Ratio of the Index.
In the case of Nifty, the EPS is 425.36 i.e. Index Price (10600) / PE Ratio (24.92).
The Forecast Period is the number of years on which the Valuation is based on. This can range from a single year up to 30 years depending upon the economic and political scenario, future market expectations and global indices. This will help to ascertain how many years of Forecast Period the Market is building in the Index Price.
In the case of Nifty, we assume 10 years Forecast Period and proceed. In case we are unable to equate Index Value to Market Price then one can also come back and iterate. This is done under the Price Scenario.
In this step, we need to estimate the Expected Inflation Rate of the Currency we are valuing the Index in. For instance, the Expected Inflation Rate of Indian Rupee is say 3.11% for October 2018.
We must take care of the inflation built in other inputs such as, Expected Market Returns to be consistent with the inflation assumptions.
The next step is estimating the expected CAGR of EPS for the Forecast Period. This is based on the strength of the economy, GDP growth and economic policies.
The next step is estimating the expected CAGR of EPS for the Forecast Period. This is based on the strength of the economy, GDP growth and economic policies.
The Expected Market Returns or Implicit return rate of the market should be measured in Nominal Terms.
The Real Return (Market Return plus Dividend Yield Less Inflation) for the S&P 500 as analyzed for each span of 30 years over a period of years, has been ranging between 5.23% to 8.02% with a CAGR of about 7.13% for 100 years.
It is possible to compute the Expected Market Returns by adding the Real Return to Expected Inflation Rate. This may vary depending on the risk investors would be willing to bear. Hence, if the inflation rate is 3.11 %, the ERI is 7.13% the Expected Market Return will be 10.24%.
To calculate – please input the Expected Market Returns for the Index, which should be uniform for all the years in the forecast period. It is advisable to check the Risk-Free Rate and the rate of inflation prior to entering the Expected Market Returns.
For Nifty, we take the Expected Market Return as 10.24%
This is the Expected Market Returns during Residual Period (After the Forecast Period). This is in Nominal terms.
For Nifty, we take the Expected Market Return in Residual Period as 10.24%.
P/E Index Decrypt | Scenario | |
Price | Value | |
Index Price | 10600 | |
P/E Ratio | 24.92 | |
EPS | 3425.36 | |
Forecast Period | 10 | |
Expected Inflation Rate | 3.11% | |
CAGR of EPS | 12% | |
Expected Market Return Forecast Period | 10.24% | |
Expected Market Return Residual Period | 10.24% | |
Index Value / Share | 11854.09 | |
P/E Forward | 24.88 |
After estimating the P/E Drivers, we can now compare the Index Price with the Index Value. As it is evident, the Index Value doesn’t equate with the Index Price.
Hence, we now proceed to Iterate the P/E drivers to get the Equation between Price and Value.
How do we Iterate?
We now address the gap by using our skill and judgment to change any of the P/E Drivers and continue iterating until we equate the Index Price with the Index Value in the Price Scenario. We iterate the P/E Drivers for Price Scenario and also build our own assumptions under the Value Scenario as follows:
P/E Index Decrypt | Scenario | |
Price | Value | |
Index Price | 10600 | 10600 |
P/E Ratio | 24.92 | 24.92 |
EPS | 425.36 | 425.36 |
Forecast Period | 10 | 15 |
Expected Inflation Rate | 3.11% | 4% |
CAGR of EPS | 10.49% | 9% |
Expected Market Return Forecast Period | 10.24% | 11.13% |
Expected Market Return Residual Period | 10.24% | 11.13% |
Index Value / Share | 10600.54 | 10123.28 |
P/E Forward | 22.56 | 21.83 |
In the above example (Price Scenario) we have changed the CAGR of EPS to equate the Index Value to Index Price.
In the Value Scenario we have changed Forecast Period to 15 Years, Expected Inflation Rate from 3.11% to 4% thus also changing the Expected Market Returns from 10.24% to 11.13%. The Index Value computed based on the above assumptions comes to 10123 as compared to the current traded price of the Index of 10600.
How frequently should one do P/E Index Valuation?
P/E Index Valuation is a continuous and frequent process as an Index responds to earnings, disclosures of new information and news on a regular basis and in most cases, the magnitude of changes could be significant. The user is able to match the thought process of the market and understand the existing equation between price and value.
The App helps you to undertake this exercise quickly in minutes in one Screen.
Can Decrypt Index P/E be done before a Valuation is undertaken?
Yes it can be done.
In the App,the user can get detailed reports for the two Scenarios on:
- P/E Report
- Valuation Report
The P/E Valuation FAQs is best understood while undertaking an example in the App and reading it along with the Tool Tips.
Value Augmentation
What is Value Augmentation / Value Enhancement ?
Any activity undertaken to:
- Increasing Sales Growth Rate. (Assuming Company Earns > Cost of Capital)
- Increasing Operating Profit Margins
- Reducing Income Tax Rate
- Reducing Cost of Capital such as changing financial mix
- Reducing Incremental Fixed and Working Capital Investment Rate
- Increasing Growth Duration (Forecast Period) through long-term competitive advantages
Will lead to Value Augmentation. In other words, such a process should affect future Cash Flows positively, to augment value.
What is Shareholder Value Augmented?
Shareholder Value Augmented (SVAg) addresses the change in value over the Forecast Period. Value Augmentation can happen only if the Investments earn in excess of the Cost of Capital required by the Capital Market. Thus,
Shareholder Value Augmented = (Cumulative Present Value of Cash Flows + Present Value of Residual Value at the end of Forecast Period)
- (Residual Value in the Prior Period + Cumulative Present Value of Cash Flows in Prior Period)
Value Augmentation is best demonstrated in the example in Table 3.1 where the total Shareholder Value Augmented by this five-year strategy is 334. The year–by–year increase in value is calculated by annual change in the Cumulative Present Value of Cash Flows plus Present Value of Residual Value’s total.
Shareholder Value Augmented for Joy Sweets:
Table 3.1
Valuation of Joy Sweets | ||||||
1 | 2 | 3 | 4 | 5 | ||
Sales | 1000 | 1150 | 1323 | 1521 | 1749 | 2011 |
Operating Profit | 180 | 207 | 238 | 274 | 315 | 362 |
Income Tax | 59 | 68 | 79 | 90 | 104 | 119 |
Incremental Fixed Assets | 53 | 60 | 69 | 80 | 92 | |
Incremental Working Capital | 45 | 52 | 60 | 68 | 79 | |
Net Cash Flow | 41 | 47 | 54 | 63 | 72 | |
Discount Factor | 1 | 0.886 | 0.784 | 0.694 | 0.615 | 0.545 |
PV of Cash Flows | 36 | 37 | 38 | 39 | 39 | |
Cumulative PV of Cash Flows (A) | 36 | 74 | 111 | 150 | 189 | |
PV of Residual Value (B) | 1519 | 1547 | 1575 | 1604 | 1634 | 1664 |
PV of CCF + PV of RV (A + B) | 1519 | 1583 | 1649 | 1716 | 1784 | 1853 |
SVAg | 64 | 66 | 67 | 68 | 69 | |
Total SVAg | 334 |
Where, PV is Present Value, CCF is Cumulative Cash Flow and RV is Residual Value
What are the sub-modules in Value Augmentation module?
There are 3 sub-modules in Value Augmentation:
- Value Impact
- Share Buyback
- Economic Breakeven Margin
Value Impact
What is Value Impact?
The Value Impact module assists in:
- Enabling the user to make a comparative Value Impact Analysis of Value Drivers on Shareholder Value.
- Computing 'What if Analysis' on two Value Drivers and Viewing Shareholder Value through a combination of two Value Drivers in a Shareholder Value Matrix.
- Computing 'What if Analysis' through a combination of Eight Value Drivers and being able to view Shareholder Value in the Value Driver Impact Table.
What is Comparative Value Impact Analysis?
To make a Comparative Value Impact Analysis means ascertaining the effect of the various value drivers on Shareholder Value. Evaluating this process is the case below, demonstrated through the illustration:
Summary Illustration: Comparative Value Impact Analysis
Company | Heritage | |
Forecast Period | years | 5 |
Expected Inflation Rate | % | 5% |
Sales in Prior Period | In Mn | 150 |
CAGR of Sales | % | 11% |
Operating Profit | ||
- Prior Period | % | 10% |
- Target Year | % | 10% |
Incremental Investment Rate | ||
- Fixed Asset | % | 22% |
- Net Working Capital | % | 22% |
Income Tax Rate | ||
- Forecast Period | % | 32% |
- Residual Period | % | 35% |
Cash and Cash Securities | In Mn | 30 |
Investment and Other Assets | In Mn | 10 |
Minority Interest and Other Liabilities | In Mn | 10 |
Debt & Obligations | In Mn | 50 |
Carry Forward Losses | In Mn | 0 |
No of Outstanding Shares | In Mn | 30 |
Estimated Valuation | In Mn | 70 |
Cost of Debt | % | 10% |
Cost of Equity | ||
- Forecast Period | % | 16% |
- Residual Period | % | 16% |
Debt Ratio | % | 41.66% |
Equity Ratio | % | 58.34% |
If we compute Shareholder Value for an increase of 1% (18% becomes 18.18% not 19%) for a Value Driver while keeping other Value Drivers constant, we see the following results in Table 3.2:
We need to input the percentage change (for example 1% change) to view the Comparative Impact of this change, on all Value Drivers on Shareholder Value. (The change while computing will show the effect of each value driver while other value drivers will remain neutral). The input box will display the base and the change percentage for all the value drivers.
Table 3.2
Base Valuation in % | From | To | Shareholder Value | Comparative Value Impact by 1% | |
1 | Sales Growth | 11% | 11.11% | 121.73 | 0.39 |
2 | Target Year OPM | 10% | 10.10% | 122.88 | 1.54 |
3 | Incremental Investment [Capex + NWC] | 44% | 44.44% | 121.03 | -0.31 |
4 | Income Tax Rate Forecast | 35% | 35.35% | 121.16 | -0.18 |
5 | Income Tax Rate Residual | 35% | 35.35% | 120.78 | -0.56 |
6 | Cost of Debt | 10% | 10.10% | 120.74 | -0.60 |
7 | Cost of Equity | 16% | 16.16% | 120.79 | -0.55 |
8 | Debt Ratio | 41.67% | 42.09% | 122.08 | 0.74 |
The maximum positive impact of change appears in the Operating Profit Margin. The Shareholder Value increases from 121.34 to 122.88 and maximum negative impact of change appears in Cost of Debt where Shareholder Value decreases by 0.60
When using the App, the user must enter the basic data requested and enter a common change percentage for all the variables. The App will calculate the Comparative Value Impact of Value Drivers as shown in Table 3.2.
What is Shareholder Value Matrix?
Shareholder Value Matrix allows us to view the impact of two Value Driver combinations on Shareholder Value. The Shareholder Value Matrix is based on a combination of two variables, Sales Growth and Operating Profit Margin.
We must enter the four different percentage rates for each of the Value Drivers as shown below. Table 3.3 and Table 3.4 display the result in form of a Shareholder Value Matrix.
Shareholder Value Matrix Inputs
Sales Growth |
Target Operating Profit Margin |
10% | 9% |
11% | 10% |
12% | 11% |
13% | 12% |
Table 3.3
Shareholder Value Matrix
Sales Growth Rate | |||||
Target Operating Profit Margin | 10% | 11% | 12% | 13% | |
9% | 103.2 | 105.9 | 108.8 | 111.8 | |
10% | 117.9 | 121.3 | 124.9 | 128.6 | |
11% | 132.7 | 136.7 | 140.9 | 145.3 | |
12% | 147.4 | 152.1 | 157.0 | 162.1 |
Table 3.4
Shareholder Value / Share Matrix
Sales Growth Rate | |||||
Target Operating Profit Margin | 10% | 11% | 12% | 13% | |
9% | 3.4 | 3.5 | 3.6 | 3.7 | |
10% | 3.9 | 4.0 | 4.2 | 4.3 | |
11% | 4.4 | 4.6 | 4.7 | 4.8 | |
12% | 4.9 | 5.1 | 5.2 | 5.4 |
When using the App, the user must define the two Value Drivers: Target Operating Profit Margin and Sales Growth, to Compute the Shareholder Value Matrix. Refer Table 3.3 and Table 3.4 as examples.
What is Value Drivers Impact Table?
The Value Driver Impact Table illustrates the What If Analysis of the impact that the varying combinations of the Eight Value Drivers have on Shareholder Value. Four such Senarios are possible per Plan to view the impact on Shareholder Value and Shareholder Value per share.
An illustration for four different Combinations of the Eight Value Drivers is given as an example of Heritage Industries below:
Summary Illustration: Value Driver Impact Table
Table 3.5
Scenario | 1 | 2 | 3 | 4 |
Sales in Prior Year | 150 | 150 | 150 | 150 |
Forecast Period | 2 | 3 | 4 | 5 |
CAGR of Sales | 12% | 12% | 13% | 14% |
Operating Profit Margin in Target Year | 9% | 8% | 11% | 12% |
Incremental Investment Rate | 42% | 43% | 45% | 46% |
Cost of Debt | 11% | 12% | 9% | 8% |
Cost of Equity in Forecast Period | 14% | 15% | 17% | 18% |
Cost of Equity in Residual Period | 14% | 15% | 17% | 18% |
Debt Ratio | 45% | 43% | 42% | 40% |
Shareholder Value | 124.7 | 91.8 | 133.8 | 143.1 |
SV / Share | 4.2 | 3.1 | 4.5 | 4.8 |
If we compute the Shareholder Value for all the Combinations, we can View the results in Table 3.5 where SV / Share denotes Shareholder Value per Share.
When using the App, the user must define up to Four Scenarios of the Eight Value Drivers, and view the Shareholder Value for these combinations.
Share BuyBack
What is a Share Buyback Program?
A Share Buyback is a program by which a Company buys back its own shares from the market place, usually because the management believes the Shares are undervalued.
Why do Companies buy back shares?
There are primarily four reasons why companies buy back their shares:
- When the stock market is valuing the Company way below its Intrinsic or Economic Value
- When there are no value augmenting Investment opportunities available.
- To tax efficiently return excess cash to the shareholders.
- To increase Financial Leverage, reducing its Cost of Capital
Summary Illustration - How does one evaluate a Share Buyback Program?
The following steps illustrate how to evaluate a Share Buyback Program:
- Determine the Economic Value of the Company and Economic Value per share (Based on Discounted Cash Flow (DCF))
- Compare the Value arriving above with the current Market Capitalization to determine extent of under Valuation
- Define the Share Buyback program, Number of Shares and Buyback price per share
- Build the buyback program in the model and compute the Economic Value per share post buy back and compare with Economic Value pre buy back per share.
Summary Illustration: Evaluating a Share Buyback Program of SnapValue
SnapValue (See Table 1.9 assumptions and Valuation of SnapValue) is considering a Buyback Program.
Table 1.9
Valuation of Snap Value | ||||||
1 | 2 | 3 | 4 | 5 | ||
Sales | 150 | 166.50 | 184.82 | 205.14 | 227.71 | 252.76 |
Operating Profit | 16.65 | 18.48 | 20.51 | 22.77 | 25.28 | |
Income Tax | 5.83 | 6.47 | 7.18 | 7.97 | 8.85 | |
Incremental Fixed Assets | 3.96 | 4.40 | 4.88 | 5.42 | 6.01 | |
Incremental Net Working Capital | 3.30 | 3.66 | 4.07 | 4.51 | 5.01 | |
Net Cash Flow | 3.56 | 3.95 | 4.39 | 4.87 | 5.41 | |
Discount Factor | 1 | 0.89 | 0.80 | 0.71 | 0.63 | 0.57 |
Present Value Of Free Cash Flow | 3.18 | 3.15 | 3.12 | 3.09 | 3.06 | |
Cumulative Present Value of Cash Flows | 15.61 | |||||
Residual Value | 222 | |||||
Present Value of Residual Value | 126 | |||||
Cumulative PV of CF + PV of Residual Value | 141 | |||||
Cash Securities &Investments | 30 | |||||
Minority Interest | 10 | |||||
Enterprise Value | 161 | |||||
Less: - Debt & Obligations | 50 | |||||
Shareholder Value | 111 | |||||
No of Shares | 30 | |||||
Shareholder Value per share | 3.7 |
The SnapValue Stock is trading at 1.50 per share and the management is considering a Share Buyback of 6 million shares at 2.25 price per share. The estimated Valuation of SnapValue based on Management Expectation is 3.7 (Table 1.9)
The Valuation of SnapValue Post Buyback is 4.7 Per Share against a Pre Buyback Value of 3.7 Per share thus it creating an Incremental Economic Value of 1.0 Per Share.
The Debt Equity Ratio in the Post Buyback Scenario is assumed and computed based on the Share buyback Valuation and the Company will maintain this ratio in the Long Term.
The Cost of Debt and Cost of Equity – Forecast and Residual is assumed to be the same in the Pre buyback Valuation and Post Buyback Valuation. If the user expects this to change due to the Share Buyback Program the user should change and compute the Post Share buyback Valuation.
See Table 3.7 for Computation of Value of SnapValue Post Buyback
Table 3.7
Valuation of SnapValue Post Buyback | ||||||
1 | 2 | 3 | 4 | 5 | ||
Sales | 150 | 166.50 | 184.82 | 205.14 | 227.71 | 252.76 |
Operating Profit | 16.65 | 18.48 | 20.51 | 22.77 | 25.28 | |
Income Tax | 5.83 | 6.47 | 7.18 | 7.97 | 8.85 | |
Incremental Fixed Assets | 3.96 | 4.4 | 4.88 | 5.42 | 6.01 | |
Incremental Net Working Capital | 3.30 | 3.66 | 4.07 | 4.51 | 5.01 | |
Share Buyback Program | 13.5 | |||||
Net Cash Flow | -9.94 | 3.95 | 4.38 | 4.87 | 5.41 | |
Discount Factor | 1 | 0.89 | 0.80 | 0.71 | 0.63 | 0.57 |
Present Value Of Free Cash Flow | -8.92 | 3.18 | 3.17 | 3.16 | 3.15 | |
Cumulative Present Value of Cash Flows | 3.75 | |||||
Residual Value | 237 | |||||
Present Value of Residual Value | 138 | |||||
Cumulative PV of CF + PV of Residual Value | 141.75 | |||||
Cash Securities &Investments | 30 | |||||
Enterprise Value | 162 | |||||
Less: - Debt & Obligations | 50 | |||||
Minority Interest | 10 | |||||
Shareholder Value | 112 | |||||
No of Shares | 24 | |||||
Price per share | 4.7 |
Note:
It is assumed that the Long Term Debt Equity Ratio will be based on the Share Buyback Valuation. In case, the user thinks that the Long Term Debt Equity Ratio will change then the user would require changing and re-entering a fresh the Debt Ratio and Equity Ratio.
When using the App, the user must enter the required inputs or if the user has already created the Valuation of this Company, then select an existing plan from Know Your Worth Module and proceed directly to fill in the Buyback Program details, Number of Shares, and Price per share.
The App will compute the Pre and Post Buyback price per share.
Economic Breakeven Margin
What is Economic Breakeven Margin?
Economic Breakeven Margin (EBM) is the Minimum Operating Profit Margin a business needs to attain in any period to Maintain Shareholder Value for that period.
What is Incremental Economic Breakeven Margin?
Incremental Economic Breakeven Margin can be defined as the Operating Profit Margin a Company needs to earn on its Incremental Sales equal to its Cost of Capital.
How to compute EBM?
The Economic Break Even Margin can be mathematically expressed as:
BE Margin = (A + B) / C) % , where
A | = | Operating Profit Prior Year Rate * (1 + Expected Inflation Rate) |
(1 / (1 + WACC Nominal)) |
B | = | (Incremental Investment Rate) * (CAGR) * (WACC Real) |
(1 - Income Tax Rate) |
C | = | (1 + CAGR) * ((1 + Expected Inflation Rate) + (WACC Real) |
How to Compute iEBM?
The Incremental Economic Break Even Margin can be mathematically expressed as:
Where Incremental EBM is :
|
Incremental Investment Rate is the sum of Incremental Fixed Asset Investment plus Incremental Net Working Capital Investment Rate.
Summary Illustration: EBM & iEBM
To illustrate the EBM concept we present a Illustration:
Assumptions | |||
Sales in Prior Period | 150 | Incremental Net Working Capital Investment | 20% |
Sales Growth rate | 11% | WACC Nominal | 12.04% |
Operating Profit Margin in Prior Period | 12% | WACC Real | 7.77% |
Income Tax rate in Forecast Year | 35% | Market Capitalization | 70 |
Incremental Fixed Asset Investment | 24% | Expected Inflation Rate | 5% |
Computation of iEBM
The Incremental EBM is computed below. The Computed Incremental EBM for Incremental Sales is 4.6%. You can also see in last Column of Table 3.8, the Present Value of Residual Value equates the Present Value of Free Cash Flows i.e. PV of Cash Flows + PV of Residual Value is Zero implying that if the Company wants to increase its value on Incremental Sales it must earn more than the Incremental Economic Breakeven Margin.
EB Margin | = | 44% x 7.77% | = | 4.66% |
65% x 112.77% |
Computation of Economic Breakeven Margin
The computation of EBM for the business is computed below. In Column 3 of Table 3.8, we substituted the Operating Profit Margin with the computed EBM (11.8%) for the whole business. As is apparent, the Share Value Augmented is near to zero.
A | = | 12% * (1 + 5%) | = | 14.11% |
(1 / (1 + 12.04%)) |
B | = | (44%) * (11%) * (7.77%) | = | 0.57% |
(1 - 35%) |
C | = | (1 + 11%) * ((1 + 5%) + (7.77%)) | = | 125.09% |
BE Margin | = | (14.11% + 0.57%) | = | 11.74% |
(125.09%) |
Table 3.8
Economic Breakeven Margin Report | |||
Particulars | Prior Period | Forecast Year EBM | Incremental Sales iEBM |
Operating Profit Margin | 12% | 11.74% | 4.66% |
Sales | 150 | 1166.5 | 16.5 |
Growth Rate | 11% | ||
Operating Profit | 18 | 19.6 | 0.77 |
Tax | 6.3 | 6.8 | 0.3 |
NOPAT | 11.7 | 12.7 | 0.5 |
Incremental Investment | 7.3 | 7.3 | |
FCF | 5.4 | -6.8 | |
Discount Factor | 1 | 0.892 | 0.892 |
PV of FCF | 4.9 | -6.0 | |
PV of RV | 158.1 | 153.2 | 6.0 |
PV of CF + PV of RV | 158.1 | 158.1 |
In the App, the user must enter the requested data and information and compute:
- Economic Breakeven Margin
- Incremental Economic Breakeven Margin