Dear All,
We have released new valuation factors that offer both functions and pre-built factors. Some of the factors are brand new, others are just additions to existing ones to make them all consistent. All these factors now include a function like Factor(offset,type), and several pre-built factors for TTM,Q,PQ, etc. These factors are located in FUNDAMENTALS->RATIOS->VALUATION
Brand NEW
EV2EBITDA – Enterprise value to EBITDA
EV2Sales – Enterprise value to Sales
PEInclRD – Price to Earnings Incl R&D (aka Innovation PE)
Pr2CFInclRD – Price to Cash Flow Incl R&D (aka Innovation Pr2CF)
Pr2NetFrCashFl – Price to Net Free Cash Flow
Added to existing
PEExclXor – Price to Earnings (PE) Excl Xor
PEInclXor – Price to Earnings (PE) Incl Xor
Pr2Book – Price to Book Value
Pr2CashFl – Price to Cash Flow
Pr2FrCashFl – Price to Free Cash Flow
Pr2Sales – Price to Sales
Pr2TanBk – Price to Tangible Book Value
We added the following valuation ‘yield’ factors.
These are single factors and are located in FUNDAMENTALS->RATIOS->YIELD
EBITDAYield – EBITDA yield
FCFYield – Free Cash flow yield
OCFYield – Operating cash flow yield
OpIncYield – Operating income yield
ShareholderYield – ShareholderYield
We made the following changes to existing factors.
EarnYield was modified to use the same scale as these other yield functions. For example, EarnYield for AAPL was returning .03 and now it is 3.03. We replaced the existing EarnYield in your formulas with EarnYieldOld which returns the value in the original scale.
FCF is now calculated as “OperCashFl-Capex” instead of “OperCashFl-Capex-DivPaid”. New ‘NetFCF’ factors have been created that use the original FCF formula. We replaced existing FCF factors in user’s formulas with these new ‘’NetFCF’ factors.
We changed the logic for PTM factors that include price in the numerator. The new logic uses an average 3 month price following the end of the PTM quarters. There are other subtle differences that will be explained in the documentations. This change might cause some differences in your results, but we think it’s more correct. The existing factors that are affected by this are Pr2SalesPTM, Pr2CashFlPTM, PEExclXorPTM, Pr2FrCashFlPTM. If you must have the previous version of this factor you can use FHist like this: FHist (“Pr2SalesTTM”,52)
Let us know of any issues or questions.
We will update the documentation for the factors in the next few days.