Title: | Equity Valuation using Methods of Fundamental Analysis |
---|---|
Description: | Methods of Fundamental Analysis for Valuation of Equity included here serve as a quick reference for undergraduate courses on Stock Valuation and Chartered Financial Analyst Levels 1 and 2 Readings on Equity Valuation. Jerald E. Pinto (“Equity Asset Valuation (4th Edition)”, 2020, ISBN: 9781119628194). Chartered Financial Analyst Institute ("Chartered Financial Analyst Program Curriculum 2020 Level I Volumes 1-6. (Vol. 4, pp. 445-491)", 2019, ISBN: 9781119593577). Chartered Financial Analyst Institute ("Chartered Financial Analyst Program Curriculum 2020 Level II Volumes 1-6. (Vol. 4, pp. 197-447)", 2019, ISBN: 9781119593614). |
Authors: | MaheshP Kumar [aut, cre] |
Maintainer: | MaheshP Kumar <[email protected]> |
License: | GPL-3 |
Version: | 1.0.1 |
Built: | 2025-02-16 04:00:46 UTC |
Source: | https://github.com/cran/stockAnalyst |
The holding period rate of return (for short, the holding period return) is the return earned from investing in an asset over a specified time period. The specified time period is the holding period under examination, whether it is one day, two weeks, four years, or any other length of time (Jerald E. Pinto, 2020).
annulizedHPR(totalPershareDividendHP, spH, spNot, n)
annulizedHPR(totalPershareDividendHP, spH, spNot, n)
totalPershareDividendHP |
A number. |
spH |
A number. |
spNot |
A number. |
n |
A number. |
In the example given by Jerald E. Pinto (2020), it is assumed that a share is purchased at the price of 10 dollars each, and held for three years. The company paid a per share dividend of 0.10 dollars each of the three years. So, the total per share dividend for the Holding period of 3 years comes out to be 0.30 dollars. At the end of the three years unit share price was 12 dollars. So, the total dollar value of return per share over the holding period is 2.30 dollars (0.30 as total dividend yield plus 2.00 dollars as price appreciation return). In percentage terms, HPR for 3 years is 23 percent (2.30 dollars of total return divided by 10 dollars which was unit share price in the beginning of the investment). This return of 23 percent when annualized works out to be 7.14 percent. Based on this understanding, the method annulizedHPR
is developed for computing annualized Holding Period Return of the Stock for the values passed to its four arguments. Here, totalPershareDividendHP
is the total dollar value of per share dividend for the Holding period, spH
is unit share price at the end of holding period, and spNot
represents unit share price in the beginning of the investment and n
is number of years of the holding period.
Input values to four arguments totalPershareDividendHP
, spH
,spNot
and n
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
annulizedHPR(totalPershareDividendHP=0.30,spH=12,spNot=10,n=3)
annulizedHPR(totalPershareDividendHP=0.30,spH=12,spNot=10,n=3)
Calculates Residual Income using given values of Earnings Per Share (EPS) and beginning Book Values Per Share(bgnBVPS) for a specified number of years.
computingAbsRI(EBIT, debt, equity, r, rd, t)
computingAbsRI(EBIT, debt, equity, r, rd, t)
EBIT |
A number vector. |
debt |
A number vector. |
equity |
A number vector. |
r |
A number. |
rd |
A number. |
t |
A number. |
Residual Income is computed in three steps. Here, Step 1 is to compute preTaxIncome
as (EBIT minus rd
multiplied with debt). Step 2 is to get netIncome
as (preTaxIncome
minus (t
multiplied with preTaxIncome
) ), and finally step 3 is to obtain the Residual Income (RI) as netIncome
minus (r
times equity
).
According to information provided by Jerald E. Pinto (2020), the method computingAbsoluteRI
is developed to compute absolute value of Residual Income. Here, EBIT
is a number vector that hold values of EBIT in millions of dollars, debt
is a number vector that has dollar value of debt (expressed in millions of dollars), equity
is a number vector that holds dollar value of equity (expressed in millions of dollars), r
required rate of return on equity (expressed in decimal terms), rd
is cost of debt (expressed in decimal terms), and t
is rate of taxes. Output gives dollar value of Residual Income (expressed in millions of dollars).
Input values to six arguments bgnBVPS
RI
, r
, , times
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
computingAbsRI(EBIT=c(0.5,1.5,2.25),debt=c(1,2.2,2.5),equity=c(1,2.2,2.5), r=0.12,rd=0.07,t=0.30)
computingAbsRI(EBIT=c(0.5,1.5,2.25),debt=c(1,2.2,2.5),equity=c(1,2.2,2.5), r=0.12,rd=0.07,t=0.30)
Analysts commonly define that enterprise value is equal to Market value of common equity (Number of shares outstanding multiplied with Price per share) plus, the Market value of preferred stock (if any) plus, the Market value of debt less, the cash and investments (specifically: cash, cash equivalents, and short- term investments. Cash and investments (sometimes termed non-earning assets) are subtracted because EV is designed to measure the net price an acquirer would pay for the company as a whole. The acquirer must buy out current equity and debt providers but then receives access to the cash and investments, which lower the net cost of the acquisition. (For example, cash and investments can be used to pay off debt or loans used to finance the purchase.) The same logic explains the use of market values: In repurchasing debt, an acquirer has to pay market prices. Some debt, however, may be private and it does not trade; some debt may be publicly traded but trade infrequently. When analysts do not have market values, they often use book values obtained from the balance sheet (Jerald E. Pinto, 2020).
computingEVdollarVal(commonEquityMV, prefStockMV, debtMV, cashNequi)
computingEVdollarVal(commonEquityMV, prefStockMV, debtMV, cashNequi)
commonEquityMV |
number. |
prefStockMV |
number. |
debtMV |
number. |
cashNequi |
number. |
According to information provided by Jerald E. Pinto (2020), the method computingEVdollarVal
is developed for computing absolute amount of Enterprise Value for the values passed to its four arguments. Here, commonEquityMV
is market value of Common Equity, prefStockMV
is market value of Preference Stock,debtMV
is market value of the Debt , and cashNequi
is amount of Cash and cash equivalents.
Input values to four arguments commonEquityMV
, prefStockMV
, debtMV
, , cashNequi
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
computingEVdollarVal(commonEquityMV=15008,prefStockMV=0,debtMV=2013,cashNequi=4060)
computingEVdollarVal(commonEquityMV=15008,prefStockMV=0,debtMV=2013,cashNequi=4060)
Enterprise value to EBITDA is by far the most widely used enterprise value multiple.Analysts use EV/EBITDA is usually more appropriate than PE alone for comparing companies with different financial leverage (debt), because EBITDA is a pre- interest earnings figure, in contrast to EPS, which is post-interest.Enterprise value to sales is a major alternative to the price- to- sales ratio. The PS multiple has the conceptual weakness that it fails to recognize that for a debt- financed company, not all sales belong to a company’s equity investors. Some of the proceeds from the company’s sales will be used to pay interest and principal to the providers of the company’s debt capital. For example, a PS for a company with little or no debt would not be comparable to a PS for a company that is largely financed with debt. EV/S
would be the basis for a valid comparison in such a case. So, EV/S is an alternative sales- based ratio that is particularly useful when comparing companies with diverse capital structures (Jerald E. Pinto, 2020).
computingEVmultiple(basis = c("sales", "EBITDA"), EV, EBITDA, sales)
computingEVmultiple(basis = c("sales", "EBITDA"), EV, EBITDA, sales)
basis |
character vector. |
EV |
number. |
EBITDA |
number. |
sales |
number. |
According to information provided by Jerald E. Pinto (2020), the method computingEVmultiple
is developed for computing Enterprise Value Multiple as EV to EBITDA or EV to sales for the values passed to its four arguments. Here, basis
is character string, either "sales" or "EBITDA" , EV
is absolute amount of Enterprise Value (in millions of dollars),EBITDA
is absolute amount of Earnings Before Interest,Taxes, Depreciation, and Amortization (in millions of dollars), and sales
is absolute amount of sales (in millions of dollars).
Input values to four arguments basis
, EV
, EBITDA
,and sales
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
computingEVmultiple("sales",EV=14411,EBITDA=3320,sales=18962) computingEVmultiple("EBITDA",EV=14411,EBITDA=3320,sales=18962)
computingEVmultiple("sales",EV=14411,EBITDA=3320,sales=18962) computingEVmultiple("EBITDA",EV=14411,EBITDA=3320,sales=18962)
Because the dividend growth rate affects the estimated value of a stock using the Gordon growth model, differences between estimated values of a stock and its actual market value might be explained by different growth rate assumptions. Given price, the expected next-period dividend, and an estimate of the required rate of return, the dividend growth rate reflected in price can be inferred assuming the Gordon growth model. An analyst can then judge whether the implied dividend growth rate is reasonable, high, or low, based on what he or she knows about the company. In effect, the calculation of the implied dividend growth rate provides an alternative perspective on the valuation of the stock to see whether it is fairly valued, overvalued, or undervalued (Jerald E. Pinto, 2020).
computingGusingGGM(divNot, r, sharePrice)
computingGusingGGM(divNot, r, sharePrice)
divNot |
A number. |
r |
A number. |
sharePrice |
A number. |
According to information provided by Jerald E. Pinto (2020), the method computingGusingGGM
is developed for computing the Growth Rate Implied by the Current Stock Price for the values passed to its three arguments. Here, divNot
is dollar value of the current dividend, r
is required rate of return, and sharePrice
is price of the share.
Input values to three arguments divNot
, r
and sharePrice
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
computingGusingGGM(divNot=2,r=0.122,sharePrice=40)
computingGusingGGM(divNot=2,r=0.122,sharePrice=40)
The ratio of market price per share to book value per share (PB), like PE, has along history of use in valuation practice as discussed by Graham and Dodd in 1934 (as cited in Jerald E. Pinto, 2020).In the measure of value in the PB denominator (book value per share) is a stock or level variable coming from the balance sheet. (Book refers to the fact that the measurement of value comes from accounting records or books, in contrast to market value.) Analysts use PB because book value is a cumulative balance sheet amount, book value is generally positive even when EPS is zero or negative. An analyst can generally use PB when EPS is zero or negative, whereas P/E based on a zero or negative EPS is not meaningful.
computingPB(PB = c("trailing", "GGM"), BV0, currentShPrice, ROE, g, r)
computingPB(PB = c("trailing", "GGM"), BV0, currentShPrice, ROE, g, r)
PB |
character vector. |
BV0 |
number. |
currentShPrice |
number. |
ROE |
number. |
g |
number. |
r |
number. |
According to information provided by Jerald E. Pinto (2020), the method computingPB
is developed for computing Price to Book Value (PB) Multiple as trailing PB or GGM based PB for the values passed to its six arguments. Here, PB
is character string, either trailing or GGM , currentShPrice
is current Share Price , BV0
is initial Book Value,ROE
is return on equity, g
is sustainable growth rate under the Gordon growth model, and r
is required rate of return on equity.
Input values to six arguments PB
, currentShPrice
, ROE
,BV0
, g
, and r
.
MaheshP Kumar, [email protected]
computingPB("trailing", currentShPrice=81.23,BV0=49.67,ROE=0.12,g=0.07,r=0.10) computingPB("GGM", currentShPrice=81.23,BV0=49.67,ROE=0.12,g=0.07,r=0.10)
computingPB("trailing", currentShPrice=81.23,BV0=49.67,ROE=0.12,g=0.07,r=0.10) computingPB("GGM", currentShPrice=81.23,BV0=49.67,ROE=0.12,g=0.07,r=0.10)
Certain types of privately held companies, including investment management companies and many types of companies in partnership form, have long been valued by a multiple of annual revenues. In recent decades, the ratio of price to sales has become well known as a valuation indicator for the equity of publicly traded companies as well. Analyst use PS Multiple as Sales are generally less subject to distortion or manipulation than are other fundamentals, such as EPS or book value. For example, through discretionary accounting decisions about expenses, company managers can distort EPS as a reflection of economic performance. In contrast, total sales, as the top line in the income statement, is prior to any expenses.Although the determination of sales is more straightforward than the determination of earnings, the analyst should evaluate a company’s revenue recognition practices, in particular, those tending to speed up the recognition of revenues—before relying on the P/S multiple. Trailing PS is calculated as price per share divided by annual net sales per share (net sales is total sales minus returns and customer discounts).Like other multiples, PS can be based on forecasted fundamentals like growth based on Gordon growth model (Jerald E. Pinto, 2020).
computingPS(PS = c("trialing", "GGM"), currentShPrice, payout, EPS0, S0, g, r)
computingPS(PS = c("trialing", "GGM"), currentShPrice, payout, EPS0, S0, g, r)
PS |
character vector. |
currentShPrice |
number. |
payout |
number. |
EPS0 |
number. |
S0 |
number. |
g |
number. |
r |
number. |
According to information provided in Jerald E. Pinto (2020), the method computingPS
is developed for computing Price to Sales (PS) Multiple as trailing PS or GGM based PS for the values passed to its seven arguments. Here, PS
is character string, either trialing or GGM , currentShPrice
is current Share Price , payout
is payout ratio,EPS0
is current earnings per share, S0
is sales per share, g
is earnings growth rate, and r
is required rate of return on equity.
Input values to seven arguments PS
, currentShPrice
, payout
, EPS0
,S0
, g
, and r
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
computingPS("trailing", currentShPrice=20,payout=0.35,EPS0=0.9,S0=10,g=0.07,r=0.09) computingPS("GGM", currentShPrice=20,payout=0.35,EPS0=0.9,S0=10,g=0.07,r=0.09)
computingPS("trailing", currentShPrice=20,payout=0.35,EPS0=0.9,S0=10,g=0.07,r=0.09) computingPS("GGM", currentShPrice=20,payout=0.35,EPS0=0.9,S0=10,g=0.07,r=0.09)
Calculates per share Residual Income using given values of Earnings Per Share (EPS) and beginning Book Values Per Share (bgnBVPS) for a specified number of years.
computingRI(bgnBVPS, EPS, r)
computingRI(bgnBVPS, EPS, r)
bgnBVPS |
A number vector. |
EPS |
A number vector. |
r |
A number. |
According to information provided by Jerald E. Pinto (2020), the method computingRI
is developed to compute value of share using Residual Income Model with given values of Earnings Per Share (EPS) and beginning Book Values Per Share (bgnBVPS) for a specified number of years for the values passed to its four arguments. Here, bgnBVPS
is a vector of the beginning or current book value per share for a specified number of years, EPS
is a vector of the given values of Earnings Per Share for a specified number of years, and r
is the required rate of return on the stock. The computingRI
computes Residual Incomes as EPS minus per share equity charge for specified number of years and then computes sum of discounted values of Residual Income that is added to current Book value per share to arrive at the share value.
Input values to three arguments bgnBVPS
EPS
,and r
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
computingRI(bgnBVPS=c(6,7,8.25),EPS=c(2,2.5,4),r=0.10 )
computingRI(bgnBVPS=c(6,7,8.25),EPS=c(2,2.5,4),r=0.10 )
The CAPM is an equation for required return that should hold in equilibrium (the condition in which supply equals demand) if the assumptions of the model are met; among the key assumptions are that investors are risk averse and that they make investment decisions based on the mean return and variance of returns of their total portfolio. The chief insight of the model is that investors evaluate the risk of an asset in terms of contribution of the asset to the systematic risk of their total portfolio (systematic risk is risk that cannot be shed by portfolio diversification). Because the CAPM provides an economically grounded and relatively objective procedure for required return estimation, it has been widely used in valuation (Jerald E. Pinto, 2020).
computingRwithCAPM(RFR, marketBeta, ERP)
computingRwithCAPM(RFR, marketBeta, ERP)
RFR |
A number. |
marketBeta |
A number. |
ERP |
A number. |
The CAPM based Required return on share is equal to currently expected Risk Free Return (RFR) plus market beta that is multiplied with Equity Risk Premium (ERP).For example, if the current expected risk-free return is 3 percent, the market beta of the asset is 1.20, and the equity risk premium is 4.5 percent, then the required return is 0.030 + 1.20*(0.045) = 0.084 or 8.4 percent.Based on this information provided by Jerald E. Pinto (2020), the method computingRwithCAPM
is developed for computing CAPM based required rate of return for the values passed to its three arguments.Here, RFR
is currently expected Risk Free Return, marketBeta
the market beta of the asset and, ERP
represents Equity Risk Premium.
Input values to three arguments RFR
, marketBeta
and ERP
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
computingRwithCAPM(RFR=.049,marketBeta=0.74,ERP=0.045) computingRwithCAPM(RFR=.05,marketBeta=1.00,ERP=0.041)
computingRwithCAPM(RFR=.049,marketBeta=0.74,ERP=0.045) computingRwithCAPM(RFR=.05,marketBeta=1.00,ERP=0.041)
By the end of the 1980s, empirical evidence had accumulated that, at least over certain long time periods, in the US and several other equity markets, investment strategies biased toward small-market capitalization securities and/or value might generate higher returns over the long run than the CAPM predicts. In 1993, researchers Eugene Fama and Kenneth French addressed these perceived weaknesses of the CAPM in a model with three factors, known as the Fama–French model (FFM). The FFM is among the most widely known non-proprietary multi-factor models. The factors are RMRF, standing for RM minus RF, the return on a market value(RM)-weighted equity index in excess of the one-month T-bill rate based on face value (RF); this is one way the equity risk premium(ERP) can be represented and ERP is the factor that FFM shares with the CAPM. The second factor is SMB (small minus big), which is a size (market capitalization) factor. SMB is the average return on three small-cap portfolios minus the average return on three large-cap portfolios. Thus SMB represents a small-cap return premium.Third factor is HML (high minus low), the average return on two high book-to-market portfolios minus the average return on two low book-to-market portfolios. With high book-to-market (equivalently, low price-to-book) shares representing a value bias and low book-to-market representing a growth bias, in general, HML represents a value return premium (Jerald E. Pinto, 2020).
computingRwithFFM(RFR, marketBeta, sizeBeta, valBeta, RMRF, SMB, HML)
computingRwithFFM(RFR, marketBeta, sizeBeta, valBeta, RMRF, SMB, HML)
RFR |
A number. |
marketBeta |
A number. |
sizeBeta |
A number. |
valBeta |
A number. |
RMRF |
A number. |
SMB |
A number. |
HML |
A number. |
Based on the information provided by Jerald E. Pinto (2020), the method computingRwithFFM
is developed for computing required rate of return on equity based on Fama–French Model for the values passed to its seven arguments. Here, RFR
is risk free return, marketBeta
is market beta, sizeBeta
is size beta,valBeta
is value beta, RMRF
represents equity risk premium, SMB
represents small cap risk premium and HML
represents value premium.
Input values to seven arguments RFR
, marketBeta
, sizeBeta
, valBeta
, RMRF
, SMB
and HML
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
computingRwithFFM(RFR=0.041,marketBeta=1.2,sizeBeta=0.5,valBeta=0.8,RMRF=0.055,SMB=0.02,HML=0.043)
computingRwithFFM(RFR=0.041,marketBeta=1.2,sizeBeta=0.5,valBeta=0.8,RMRF=0.055,SMB=0.02,HML=0.043)
Under the assumption of efficient prices, the Gordon growth model has been used to estimate a stock’s required rate of return, or equivalently, the market-price-implied expected return (Jerald E. Pinto, 2020).
computingRwithGGM(divN1, g, spNot)
computingRwithGGM(divN1, g, spNot)
divN1 |
A number. |
g |
A number. |
spNot |
A number. |
According to information provided by Jerald E. Pinto (2020), the method computingRwithGGM
is developed for computing Required Rate of Return using the Gordon Growth Model for the values passed to its three arguments. Here, divN1
is dollar value of the dividend in one year, g
is dividend growth rate, and spNot
is current share price.
Input values to three arguments divN1
, g
and spNot
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
computingRwithGGM(divN1=2.363,g=0.055,spNot=56.60)
computingRwithGGM(divN1=2.363,g=0.055,spNot=56.60)
Calculates the required rate of return on equity using two stage H-Model.
computingRwithHmodel(divNot, spNot, n, H, gS, gL)
computingRwithHmodel(divNot, spNot, n, H, gS, gL)
divNot |
A number. |
spNot |
A number. |
n |
A number. |
H |
A number. |
gS |
A number. |
gL |
A number. |
According to information provided Jerald E. Pinto (2020), the method computingRwithHmodel
is developed to compute the required rate of return on equity using two stage H-Model for the values passed to its six arguments.Here, divNot
is dollar value of the current dividend , spNot
is current share price, n
is number of years of super-normal growth period, H
is which is one-half of n (that is the length of the super-normal growth period), gS
is initial short-term dividend growth rate, and gL
is normal long-term dividend growth rate after Year 2H (that is n
).
Input values to six arguments divNot
, spNot
, n
, H
, gS
and gL
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
computingRwithHmodel(divNot=1,spNot=20,n=10,H=10/2,gS=0.10,gL=0.06)
computingRwithHmodel(divNot=1,spNot=20,n=10,H=10/2,gS=0.10,gL=0.06)
Sustainable growth rate as the rate of dividend (and earnings) growth that can be sustained for a given level of return on equity, assuming that the capital structure is constant through time and that additional common stock is not issued. The reason for studying this concept is that it can help in estimating the stable growth rate in a Gordon growth model valuation.Sustainable growth rate(g) is equal to earnings retention rate , represented by b
(that is equal to 1 minus dividend payout ratio) multiplied with return on equity (Jerald E. Pinto, 2020).
computingSustainableG(retentionRate, ROE)
computingSustainableG(retentionRate, ROE)
retentionRate |
A number. |
ROE |
A number. |
According to information provided in Jerald E. Pinto (2020), the method computingSustainableG
is developed for computing Sustainable Growth Rate for the values passed to its two arguments.Here, retentionRate
is retention rate (that is equal to 1 minus dividend payout ratio), and ROE
is return on equity.
Input values to two arguments retentionRate
and ROE
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
computingSustainableG(retentionRate=0.60,ROE=0.25)
computingSustainableG(retentionRate=0.60,ROE=0.25)
The overall required rate of return of a suppliers of capital is usually referred to as cost of capital. The cost of capital is most commonly estimated using the after-tax weighted average cost of capital, or weighted average cost of capital (WACC) for short; a weighted average of required rates of return for the component sources of capital.It is interesting fact to note that in many jurisdictions, corporations may deduct net interest expense from income in calculating taxes owed, but they cannot deduct payments to shareholders, such as dividends. Because capital structure (the proportions of debt and equity financing) can change over time, WACC may also change over time. In addition, the company’s current capital structure may also differ substantially from what it will be in future years. For these reasons, analysts often use target weights instead of the current market-value weights when calculating WACC (Jerald E. Pinto, 2020)
computingWACC(dollarValDebt, dollarValCEquity, rDebt, rCEquity, taxRate)
computingWACC(dollarValDebt, dollarValCEquity, rDebt, rCEquity, taxRate)
dollarValDebt |
A number. |
dollarValCEquity |
A number. |
rDebt |
A number. |
rCEquity |
A number. |
taxRate |
A number. |
Based on the information provided by Jerald E. Pinto (2020), the method computingWACC
is developed for computing Weighted Average Cost of Capital(WACC) for the values passed to its five arguments. Here, dollarValDebt
is dollar value of the debt, dollarValCEquity
is dollar value of the common equity, rDebt
before-tax required return on debt,rCEquity
is required return on equity, and taxRate
is corporate tax rate.
Input values to five arguments dollarValDebt
, dollarValCEquity
, rDebt
, rCEquity
, and taxRate
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
computingWACC(dollarValDebt=35,dollarValCEquity=65,rDebt=0.056,rCEquity=0.127,taxRate=0.29)
computingWACC(dollarValDebt=35,dollarValCEquity=65,rDebt=0.056,rCEquity=0.127,taxRate=0.29)
If an analyst is interested in a ranking, however, one solution (applicable to any ratio involving a quantity that can be negative or zero) is the use of an inverse price ratio which is the reciprocal of the original ratio (which places price in the denominator). The use of inverse price multiples addresses the issue of consistent ranking because price is never negative. In the case of the PE, the inverse price ratio is earnings to price (EP), known as the earnings yield. Ranked by earnings yield from highest to lowest, the securities are correctly ranked from cheapest to most costly in terms of the amount of earnings one unit of currency buys (Jerald E. Pinto, 2020).
earningYieldEP(currentShPr, TTMdilutedEPS)
earningYieldEP(currentShPr, TTMdilutedEPS)
currentShPr |
number. |
TTMdilutedEPS |
vector. |
According to information provided by Jerald E. Pinto (2020), the method earningYieldEP
is developed for computing Earning to Price Ratio, also known as Earning Yield, for the values passed to its two arguments. Here, currentShPr
is current Share Price and TTMdilutedEPS
is trailing 12 month (TTM) diluted EPS. Output of 0.0638 represents an Earning Yield of 6.38 percent.
Input values to two arguments currentShPr
and TTMdilutedEPS
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
earningYieldEP(currentShPr=49.19,TTMdilutedEPS=3.14)
earningYieldEP(currentShPr=49.19,TTMdilutedEPS=3.14)
Amount of estimated total equity value is obtained by deducting the given Market Value of Debt from Value of firm based on single stage constant growth of FCFF. Consider that FCFF grows at a constant rate, g
, such that FCFF in any period is equal to FCFF in the previous period multiplied by (1 + g). This means that this method is based on single stage constant growth model. So, FCFFt = FCFF(t–1) times (1 + g). If FCFF grows at a constant rate, firm value(FCFF1) is FCFF0 times (1+g) divided by (WACC-g).
equityValueConstantG(FCFF0, g, WACC, debtVal)
equityValueConstantG(FCFF0, g, WACC, debtVal)
FCFF0 |
A number. |
g |
A number. |
WACC |
A number. |
debtVal |
A number. |
According to information provided by Jerald E. Pinto (2020), the method equityValueConstantG
is developed to compute estimated value of the firm if FCFF is growing at a constant rate for the values passed to its three arguments. Here, FCFF0
is given amount of future Free Cash Flow to the Firm in millions of dollars, g
is constant rate of growth under single stage constant growth model, and WACC
is Weighted Average Cost of Capital.
Input values to tfour arguments FCFF0
g
, and WACC
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
equityValueConstantG(FCFF0=1.8,g=0.08,WACC=0.12,debtVal= 18 ) equityValueConstantG(FCFF0=700,g=0.05,WACC=0.102,debtVal=2200)
equityValueConstantG(FCFF0=1.8,g=0.08,WACC=0.12,debtVal= 18 ) equityValueConstantG(FCFF0=700,g=0.05,WACC=0.102,debtVal=2200)
The FCFF valuation approach estimates the value of the firm as the present value of future FCFF discounted at the weighted average cost of capital. Because FCFF is the cash flow available to all suppliers of capital, using WACC to discount FCFF gives the total value of all of the firm’s capital. The value of equity is the value of the firm minus the market value of its debt (Jerald E. Pinto, 2020).
equityValueGivenDebtMV(FCFF, t, WACC, debtMV)
equityValueGivenDebtMV(FCFF, t, WACC, debtMV)
FCFF |
A vector. |
t |
A vector. |
WACC |
A number. |
debtMV |
A number |
According to information provided by Jerald E. Pinto (2020), the method equityValueGivenDebtMV
is developed to compute estimated total equity value by deducting the given Market Value of Debt from Discounted Value of FCFF for the values passed to its four arguments. Here, FCFF
is given amount of future Free Cash Flow to the Firm (FCFF) in millions of dollars. For example, a value of 0.04 means 0.4 millions or 400,000 dollars , t
is a vector of number of years ranging from 1 to any specified number of years for which FCFF is to be discounted, WACC
is Weighted Average Cost of Capital and debtMV
is Market Value of the debt. Values used for FCFF, Market Value of Debt and the output obtained are in millions of dollars. An output of 1.00494 means 1,004,940 dollars.
Input values to three arguments FCFF
, t
,debtMV
, and WACC
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
equityValueGivenDebtMV(FCFF=c(0.4,0.4,0.4,0.4),t=c(1,2,3,4),WACC=0.12,debtMV= 0.21)
equityValueGivenDebtMV(FCFF=c(0.4,0.4,0.4,0.4),t=c(1,2,3,4),WACC=0.12,debtMV= 0.21)
Assume that free cash flow to the firm (FCFF) grows at a constant rate, g
, in such a way that FCFF in any period is equal to FCFF of the previous period multiplied by (1 + g). This means this method is based on single stage constant growth model. So, FCFFt is equal to FCFF of period (t–1) multiplied with (1 + g). If FCFF grows at a constant rate, firm value (FCFF1) is equal to FCFF0*(1+g)/(WACC-g).
firmValueConstantG(FCFF0, g, WACC)
firmValueConstantG(FCFF0, g, WACC)
FCFF0 |
A number. |
g |
A number. |
WACC |
A number. |
According to information provided by Jerald E. Pinto (2020), the method firmValueConstantG
is developed to compute estimated value of the firm when FCFF is growing at a constant rate for the values passed to its three arguments. Here, FCFF0
is given amount of future Free Cash Flow to the Firm in millions of dollars, g
is constant rate of growth under single stage constant growth model, and WACC
is Weighted Average Cost of Capital.
Input values to three arguments FCFF0
g
, and WACC
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
firmValueConstantG(FCFF0=1.8,g=0.08,WACC=0.12) firmValueConstantG(FCFF0=700,g=0.05,WACC=0.102)
firmValueConstantG(FCFF0=1.8,g=0.08,WACC=0.12) firmValueConstantG(FCFF0=700,g=0.05,WACC=0.102)
Discounted cash flow (DCF) valuation views the intrinsic value of a security as the present value of its expected future cash flows. When applied to dividends, the DCF model is the discounted dividend approach or dividend discount model (DDM). Free Cash Flow Approach extends DCF analysis to value a firm (company) and its equity securities by valuing free cash flow to the firm (FCFF) and free cash flow to equity (FCFE). Whereas, dividends are the cash flows actually paid to stockholders; however, free cash flows are the cash flows available for distribution to shareholders. Common equity can be valued directly by using FCFE or indirectly by first using a FCFF model to estimate the value of the firm and then subtracting the value of non-common-stock capital (usually the debt) from FCFF to arrive at an estimate of the value of equity. Free cash flow to the firm is the cash flow available to the company’s suppliers of capital after all operating expenses (including taxes) have been paid and necessary investments in working capital (e.g., inventory) and fixed capital (e.g., equipment) have been made. FCFF is the cash flow from operations minus capital expenditures. A suppliers of capital include common stockholders, bondholders, and sometimes, preferred stockholders. Unlike dividends, FCFF and FCFE are not readily available data. The equations analysts use to calculate FCFF depend on the accounting information available. Analysts need to compute these quantities from available financial information which requires a clear understanding of free cash flows and the ability to interpret and use the information correctly. Forecasting future free cash flows is also a rich and demanding exercise and requires understanding of a corporate financial statements, its operations, investments, and financing (Jerald E. Pinto, 2020).
firmValueUsingDiscFCFF(FCFF, times, WACC)
firmValueUsingDiscFCFF(FCFF, times, WACC)
FCFF |
A vector. |
times |
A vector. |
WACC |
A number. |
According to information provided by Jerald E. Pinto (2020), the method firmValueUsingDiscFCFF
is developed to compute the estimated value of the firm as the present value of given amount of FCFF that is discounted at WACC for the values passed to its three arguments. Here, FCFF
is given amount of future Free Cash Flow to the Firm (FCFF) in millions of dollars at time t
. For example a value of 0.04 means 0.4 millions or 400,000 dollars, times
is a vector of number of years ranging from 1 to any specified number of years for which FCFF is to be discounted, and WACC
is Weighted Average Cost of Capital. Values used for FCFF and the output obtained are in millions of dollars. An output of 1.21494 means 1,214,940 dollars.
Input values to three arguments FCFF
, times
, and WACC
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
firmValueUsingDiscFCFF(FCFF=c(0.4,0.4,0.4,0.4),times=c(1,2,3,4),WACC=0.12)
firmValueUsingDiscFCFF(FCFF=c(0.4,0.4,0.4,0.4),times=c(1,2,3,4),WACC=0.12)
A metric that appears to address the impact of earnings growth on PE is the PE-to-growth (PEG) ratio. PEG is calculated as the PE of the stock divided by the expected earnings growth rate (in percentage terms). The ratio, in effect, is a calculation of PE per percentage point of expected growth. Stocks with lower PEGs are more attractive than stocks with higher PEGs, all else being equal. Some consider that a PEG ratio less than 1 is an indicator of an attractive value level. PEG is useful but must be used with care ad PEG assumes a linear relationship between PE and growth. The model for PE in terms of the DDM shows that, in theory, the relationship is not linear (Jerald E. Pinto, 2020).
forwardPEG(leadingPE, percentEPSgrowth)
forwardPEG(leadingPE, percentEPSgrowth)
leadingPE |
number. |
percentEPSgrowth |
number. |
According to information provided by Jerald E. Pinto (2020), the method forwardPEG
is developed for computing PE-to-growth (PEG) ratio for the values passed to its two arguments. Here, leadingPE
is leading PE Multiple and percentEPSgrowth
is five-year EPS growth forecast (in percentage terms).
Input values to two arguments leadingPE
and percentEPSgrowth
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
forwardPEG(leadingPE=43.97,percentEPSgrowth=25.30)
forwardPEG(leadingPE=43.97,percentEPSgrowth=25.30)
The Long-term Earning Growth Model given by Yardeni in 2000 (as cited in Jerald E. Pinto, 2020) incorporates the expected growth rate in earnings, a variable that is missing in the Fed Model. This model is known as Yardeni Model and it incorporates the impact of long-term expected growth rate of earnings on PE and thereby overcomes the issue that was limitation of the US FED Model (Jerald E. Pinto, 2020).
impliedPEbyYardeniModel(CBY, b, LTEG, residualVal)
impliedPEbyYardeniModel(CBY, b, LTEG, residualVal)
CBY |
number. |
b |
number. |
LTEG |
number. |
residualVal |
number. |
According to information provided by Jerald E. Pinto (2020), the method impliedPEbyYardeniModel
is developed for computing Price to Earnings Multiple by Yardeni Model that that incorporates the expected growth rate of earnings for values passed to its four arguments. Here, CBY
is corporate bond yield, b
is given coefficient of LTEG.The coefficient b
measures the weight the market gives to five- year earnings projections, LTEG
is Long Term Earning Growth.LTEG is taken as the consensus five- year earnings growth rate forecast for the market index and residualVal
is residual value of the estimator that tends to zero.
Input values to four arguments CBY
b
, LTEG
,and residualVal
.
MaheshP Kumar, [email protected]
impliedPEbyYardeniModel(CBY=0.06,b=0.2,LTEG=0.025,residualVal=0)
impliedPEbyYardeniModel(CBY=0.06,b=0.2,LTEG=0.025,residualVal=0)
The price-to-earnings ratio (P/E) is perhaps the most widely recognized valuation indicator, familiar to readers of newspaper financial tables and institutional research reports. Using the Gordon growth model, an expression for P/E in terms of the fundamentals can be developed. When used with forecasts of the inputs to the model, the analyst obtains a justified (fundamental) P/E ; the P/E that is fair, warranted, or justified on the basis of fundamentals (given that the valuation model is appropriate). The analyst can then state his or her view of value in terms not of the Gordon growth model value but of the justified P/E. Because P/E is so widely recognized, this method may be an effective way to communicate the analysis. Leading and trailing justified P/E expressions can be developed from the Gordon growth model. Assuming that the model can be applied to valuation of a particular stock, the dividend payout ratio is considered fixed. In leading P/E, current price is divided by earnings of next year (Jerald E. Pinto, 2020).
justifiedLeadingPE(rCAPM, payoutRatio, g)
justifiedLeadingPE(rCAPM, payoutRatio, g)
rCAPM |
A number. |
payoutRatio |
A number. |
g |
A number. |
According to information provided by Jerald E. Pinto (2020), the method justifiedLeadingPE
is developed for computing Justified Leading P/E Based on the Gordon Growth Model for the values passed to its three arguments. Here, rCAPM
is required rate of return based on CAPM (Capital Asset Pricing Model), payoutRatio
is payout ration, and g
is dividend growth rate.
Input values to three arguments rCAPM
, payoutRatio
and g
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
justifiedLeadingPE(rCAPM=0.09,payoutRatio=0.32,g=0.07) justifiedLeadingPE(rCAPM=0.125,payoutRatio=0.90,g=0.03)
justifiedLeadingPE(rCAPM=0.09,payoutRatio=0.32,g=0.07) justifiedLeadingPE(rCAPM=0.125,payoutRatio=0.90,g=0.03)
The price-to-earnings ratio (P/E) is one of the most widely recognized valuation indicator and is familiar to readers of newspaper financial tables and institutional research reports. Using the Gordon growth model, an expression for P/E in terms of the fundamentals can be developed. Because P/E is so widely recognized, this method may be an effective way to communicate the analysis. Leading and trailing justified P/E expressions can be developed from the Gordon growth model. Assuming that the model can be applied to valuation of a particular stock, the dividend payout ratio is considered fixed. In trailing P/E, current price is divided by trailing (current year) earnings (Jerald E. Pinto, 2020).
justifiedTrailingPE(rCAPM, payoutRatio, g)
justifiedTrailingPE(rCAPM, payoutRatio, g)
rCAPM |
A number. |
payoutRatio |
A number. |
g |
A number. |
According to information provided by Jerald E. Pinto (2020), the method justifiedTrailingPE
is developed for computing Justified Trailing P/E Based on the Gordon Growth Model for the values passed to its three arguments. Here, rCAPM
is required rate of return based on CAPM (Capital Asset Pricing Model), payoutRatio
is payout ration and g
is dividend growth rate.
Input values to three arguments rCAPM
, payoutRatio
and g
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
justifiedTrailingPE(rCAPM=0.09,payoutRatio=0.32,g=0.07)
justifiedTrailingPE(rCAPM=0.09,payoutRatio=0.32,g=0.07)
Applying the fiscal-year concept, Leading PE can be computed in two ways: first, based on the mean of the current fiscal year (FY1 = Fiscal Year 1) forecasts, for which analysts may have actual EPS in hand for some quarters; second, based on the following fiscal year (FY2 = Fiscal Year 2) forecasts, which must be based entirely on forecasts by analysts (Jerald E. Pinto, 2020).
leadingFY1PE(currentShPr, FY1EPS)
leadingFY1PE(currentShPr, FY1EPS)
currentShPr |
number. |
FY1EPS |
number. |
According to information provided by Jerald E. Pinto (2020), the method leadingFY1PE
is developed for computing Leading PE Multiple based on the mean of the current fiscal year (FY1) for the values passed to its two arguments. Here, currentShPr
is the current Share Price and FY1EPS
is the mean of the current fiscal year (FY1 = Fiscal Year 1) forecasts, for which analysts may have actual EPS in hand for some quarters.
Input values to two arguments currentShPr
and FY1EPS
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
leadingFY1PE(currentShPr=184.15,FY1EPS=16.19)
leadingFY1PE(currentShPr=184.15,FY1EPS=16.19)
Applying the fiscal-year concept, Leading PE can be computed in two ways: first, based on the mean of the current fiscal year (FY1 = Fiscal Year 1) forecasts, for which analysts may have actual EPS in hand for some quarters; second, based on the following fiscal year (FY2 = Fiscal Year 2) forecasts, which must be based entirely on forecasts by analysts (Jerald E. Pinto, 2020).
leadingFY2PE(currentShPr, FY2EPS)
leadingFY2PE(currentShPr, FY2EPS)
currentShPr |
number. |
FY2EPS |
number. |
According to information provided by Jerald E. Pinto (2020), the method leadingFY2PE
is developed for computing Leading PE Multiple based on the mean of the following fiscal year (FY2 = Fiscal Year 2) forecasts for the values passed to its two arguments. Here, currentShPr
is the current Share Price and FY2EPS
is the mean of following fiscal year (FY2 = Fiscal Year 2) forecasts by the analysts.
Input values to two arguments currentShPr
and FY2EPS
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
leadingFY2PE(currentShPr=184.15,FY2EPS=18.35)
leadingFY2PE(currentShPr=184.15,FY2EPS=18.35)
The Leading PE, also know as forward PE is a major and logical alternative to the trailing PE because valuation is naturally forward looking. In the definition of forward PE, analysts have interpreted, “expected earnings of next year” as expected EPS for the next four quarters or the next 12 months or the next fiscal year (Jerald E. Pinto, 2020). In this method, first definition of Leading PE (i.e., the next four quarters) is used.
leadingPEnext4Qs(currentShPr, Q1EPS, Q2EPS, Q3EPS, Q4EPS)
leadingPEnext4Qs(currentShPr, Q1EPS, Q2EPS, Q3EPS, Q4EPS)
currentShPr |
number. |
Q1EPS |
number. |
Q2EPS |
number. |
Q3EPS |
number. |
Q4EPS |
number. |
In the given example, forecasts of EPS are $0.15 for the quarter ending 31 March 2019, $0.18 for the quarter ending 30 June 2019, $0.18 for the quarter ending 30 September 2019, and $0.24 for the quarter ending 31 December 2019. The sum of the forecasts for the next four quarters is $0.15 + $0.18 + $0.18 + $0.24 = $0.75, and the leading PE for this stock is $15/$0.75 = 20.0.
Input values to five arguments currentShPr
, Q1EPS
, Q2EPS
,Q3EPS
, and Q4EPS
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
leadingPEnext4Qs(currentShPr=15,Q1EPS=0.15,Q2EPS=0.18,Q3EPS=0.18,Q4EPS=0.24)
leadingPEnext4Qs(currentShPr=15,Q1EPS=0.15,Q2EPS=0.18,Q3EPS=0.18,Q4EPS=0.24)
While studying PE through cross-country comparisons the main differences in inflation rates and in the ability of companies to pass through inflation in their costs in the form of higher prices to their customers plays a vital role. For two companies with the same inflation pass-through ability, the company operating in the environment with higher inflation will have a lower justified PE; if the inflation rates are equal but pass-through rates differ, the justified PE should be lower for the company with the lower pass-through rate (Jerald E. Pinto, 2020).
PEforPassThroughInflation(realROR, I, passThruRate)
PEforPassThroughInflation(realROR, I, passThruRate)
realROR |
number. |
I |
number. |
passThruRate |
number. |
According to information obtained from Jerald E. Pinto (2020), the method PEforPassThroughInflation
is developed for computing PE Multiple of the companies with different abilities to pass through the inflation to customers for values passed to its three arguments. Here, realROR
is real Rate of Return, I
is rate of Inflation, and passThruRate
is percentage of inflation in costs that the company can pass through to its customers through higher prices.
Input values to three arguments realROR
, I
, and passThruRate
.
MaheshP Kumar, [email protected]
PEforPassThroughInflation(realROR=0.03,I=0.06,passThruRate=0.70) PEforPassThroughInflation(realROR=0.03,I=0.06,passThruRate=0.90)
PEforPassThroughInflation(realROR=0.03,I=0.06,passThruRate=0.70) PEforPassThroughInflation(realROR=0.03,I=0.06,passThruRate=0.90)
The US FED model based on a paper written by three analysts, Lander, Orphanides, and Douvogiannis in 1997, at the US Federal Reserve, predicts the return on the S&P 500 on the basis of the relationship between forecasted earnings yields and yields on bonds (as cited in Jerald E. Pinto, 2020).
predictedPEbyFEDmodel(tenYrBondYield)
predictedPEbyFEDmodel(tenYrBondYield)
tenYrBondYield |
number. |
According to information provided by Jerald E. Pinto (2020), the method predictedPEbyFEDmodel
is developed for computing predicted value of Price to Earning Multiple based on yields on bonds.
Input values to tenYrBondYield
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
predictedPEbyFEDmodel(tenYrBondYield=0.0293)
predictedPEbyFEDmodel(tenYrBondYield=0.0293)
A predicted PE, which is conceptually similar to a justified PE, can be estimated from cross-sectional regressions of PE on the fundamentals believed to drive security valuation. This approach is pioneered by experts Kisor and Whitbeck 1963 and Malkiel and Cragg in 1970 (as cited in Jerald E. Pinto, 2020). The studies measured PEs for a group of stocks and the characteristics which determine PE such as: growth rate in earnings, payout ratio, and a measure of volatility, such as standard deviation of earnings changes or beta. An analyst can conduct such cross-sectional regressions by using any set of explanatory variables considered to determine investment value. The analyst must bear in mind; however, the potential distortions that can be introduced by multi-collinearity among independent variables (Jerald E. Pinto, 2020).
predictedPEonCSR(b0, b1, b2, b3, x1DRP, x2Beta, x3EGR)
predictedPEonCSR(b0, b1, b2, b3, x1DRP, x2Beta, x3EGR)
b0 |
number. |
b1 |
number. |
b2 |
number. |
b3 |
number. |
x1DRP |
number. |
x2Beta |
number. |
x3EGR |
number. |
According to information provided by Jerald E. Pinto (2020), the method predictedPEonCSR
is developed for computing Cross-Sectional Regression for values passed to its seven arguments. Here, b0
is intercept, b1
is given coefficient of x1DRP, b2
is given coefficient of x2Beta, b3
is given coefficient of x3EGR, x1DRP
is Dividend Payout Ratio that is taken as first variable X1, x2Beta
is company beta that is taken as variable X2, and x3EGR
is five-year earnings growth rate that is taken as variable X3 of the regression equation.
Input values to seven arguments b0
, b1
, b2
, b3
,x1DRP
,x2Beta
, and x3EGR
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
predictedPEonCSR(b0=12.12, b1=2.25, b2= -0.20, b3=14.43, x1DRP=0.45, x2Beta=0.9, x3EGR=0.08)
predictedPEonCSR(b0=12.12, b1=2.25, b2= -0.20, b3=14.43, x1DRP=0.45, x2Beta=0.9, x3EGR=0.08)
The single-stage (constant-growth) residual income model assumes that a company has a constant return on equity and constant earnings growth rate through time.
singleStageR(ROErate, bgnBVPS, r, g)
singleStageR(ROErate, bgnBVPS, r, g)
ROErate |
A number. |
bgnBVPS |
A number. |
r |
A number. |
g |
A number. |
According to information provided by Jerald E. Pinto (2020), the method singleStageR
is developed to compute value of a share based on single-stage (constant-growth) residual income model for the values passed to its four arguments. Here, ROErate
is rate of Return on Equity, g
is constant rate of growth under single stage constant growth model, bgnBVPS
is beginning Book Value per Share, r
is required rate of return on equity.
Input values to four arguments bgnBVPS
RI
, r
,and g
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
singleStageR(ROErate=0.16, bgnBVPS=18.81,r=0.11,g=0.08)
singleStageR(ROErate=0.16, bgnBVPS=18.81,r=0.11,g=0.08)
Terminal Value at time n
is calculated by taking benchmark value of trailing PE that is multiplied by EPS of the stock at time n
where the final growth stage begins . This also means that Terminal Value of the stock is obtained by using comparable benchmark PE without considering growth or using multistage GGM and thereby incorporating the impact of growth (Jerald E. Pinto, 2020).
terminalValueUsingPE( avg = c("comparable", "GGM"), benchmarkPE, En, payout, g, r )
terminalValueUsingPE( avg = c("comparable", "GGM"), benchmarkPE, En, payout, g, r )
avg |
character vector. |
benchmarkPE |
number. |
En |
number. |
payout |
number. |
g |
number. |
r |
number. |
According to information obtained from Jerald E. Pinto (2020), the method terminalValueUsingPE
is developed for computing Terminal Value (TV) of the stock using PEs for the values passed to its six arguments. Here, avg
is character string, either comparable or GGM , benchmarkPE
is benchmark PE Multiple,En
is EPS of the stock at time n
where the final growth stage begins, payout
is payout ratio, g
is sustainable growth rate from GGM, and r
is required rate of return on the equity.
Input values to six arguments avg
, benchmarkPE
,En
,payout
,g
, and r
.
MaheshP Kumar, [email protected]
terminalValueUsingPE("comparable",benchmarkPE=14.3,En=3,payout=0.45,g=0.0715,r=0.10) terminalValueUsingPE("GGM", benchmarkPE=14.3,En=3,payout=0.45,g=0.0715,r=0.10)
terminalValueUsingPE("comparable",benchmarkPE=14.3,En=3,payout=0.45,g=0.0715,r=0.10) terminalValueUsingPE("GGM", benchmarkPE=14.3,En=3,payout=0.45,g=0.0715,r=0.10)
In the first edition of Security Analysis (by Graham and Dodd, 1934, as cited in Jerald E. Pinto, 2020), Benjamin Graham and David L. Dodd described common stock valuation based on PEs as the standard method of that era, and the PE is still the most familiar valuation measure today. Two chief variations of the PE: the trailing PE and the forward PE (also called the leading PE) are available. A trailing PE (sometimes referred to as a current PE) is its current market price divided by the most recent four quarters EPS. In such calculations, EPS is sometimes referred to as trailing 12 month (TTM) EPS. Companies are themselves required to present both basic EPS and diluted EPS. Basic earnings per share data reflect total earnings divided by the weighted average number of shares actually outstanding during the period. (Jerald E. Pinto, 2020). In this method, trailing PE on basic Earnings Per Share (EPS) is being computed (Jerald E. Pinto, 2020).
trailingPEbasicEPS(currentShPr, basicEPS)
trailingPEbasicEPS(currentShPr, basicEPS)
currentShPr |
number. |
basicEPS |
vector. |
According to information provided by Jerald E. Pinto (2020), the method trailingPEbasicEPS
is developed for computing trailing Price to Earnings Multiple based on basic EPS for the values passed to its two arguments. Here, currentShPr
is current Share Price and basicEPS
is basic EPS as defined in the description above.
Input values to two arguments currentShPr
and basicEPS
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
trailingPEbasicEPS(currentShPr=596.5,basicEPS=15.1)
trailingPEbasicEPS(currentShPr=596.5,basicEPS=15.1)
Companies are themselves required to present both basic EPS and diluted EPS. Diluted earnings per share reflects division by the number of shares that would be outstanding if holders of securities such as executive stock options, equity warrants, and convertible bonds exercised their options to obtain common stock. The diluted EPS measure also reflects the effect of such conversion on the numerator, earnings. Because companies present both EPS numbers, the analyst does not need to make the computation. Companies also typically report details of the EPS computation in a footnote to the financial statements (Jerald E. Pinto, 2020).
trailingPEdilutedEPS(currentShPr, dilutedEPS)
trailingPEdilutedEPS(currentShPr, dilutedEPS)
currentShPr |
number. |
dilutedEPS |
vector. |
According to information provided by Jerald E. Pinto (2020), the method trailingPEdilutedEPS
is developed for computing trailing Price to Earnings Multiple based on diluted EPS for the values passed to its two arguments. Here, currentShPr
is current Share Price and dilutedEPS
is diluted EPS as defined in the description above.
Input values to two arguments currentShPr
and dilutedEPS
.
MaheshP Kumar, [email protected]
Pinto, J. E. (2020). Equity Asset Valuation (4th ed.). Wiley Professional Development (P&T). https://bookshelf.vitalsource.com/books/9781119628194
trailingPEdilutedEPS(currentShPr=596.5,dilutedEPS=15.7)
trailingPEdilutedEPS(currentShPr=596.5,dilutedEPS=15.7)