This report could be called “Most recent yearly financials for all tradable NASDAQ/NYSE/AMEX companies (~6000) ”.
This will include all the S&P 500 and DOW companies, etc. It does not include non-equity types such as mutual funds and etfs, as they have a different set of financials.
Pro tip. To reiterate, this report is simply showing THE MOST RECENT YEAR for each company. But, if you click on a row, it will show you the last 10 years of financials for that stock, which is useful for spotting trends and gaining a better perspective.
| TXN_DATE | SYM | CURR | NAME | SIZE | SECTOR | PRICE | CURR_PRICE | LAST_PRICE | DCF_IV | DCF_IV2 | CURR_DISC_PCT | CURR_DISC_PCT2 | YR10_FUTURE_YIELD | ACM | EBIT | ENTERPRISEVALUE | BV_IV | DIVIDENDSPAID | DPS | DIVIDENDYIELD | YR5_HIGH | YR5_HIGH_PCT | YR1_HIGH | YR1_HIGH_PCT | SHARES | MARKET_CAP | NCAV | CASH | ROE | RONTA | FCF | NETINCOME | EQUITY | ACTUAL_OWNERS_EARNINGS | SCR_DCFIV | SCR_ACM | SCR_YR5 | SCR_YR1 |
|---|
Generally speaking, we try to simplify things, but when dealing with financial numbers, but often there is no simple answer. Below is a write up on where some of this data came from, how it’s calculated, and, hopefully some tips on how Joe Investor can use it. Here we go…
TXN_DATE – date of the most recent set of YEARLY financials that have been released (which is once per year, and at different times for each company).
PRICE – stock price as of the txn_date (ie, date the yearly financials were released)
CURR_PRICE – Most recent price quote (ie, the price now)
LAST_PRICE – date of curr price (should be close to today)
DCF_IV – intrinsic value of a stock using the discounted count flow method. Or put another way, what the stock is worth today based on future discounted earnings. If the dcf_iv is less than the current stock price, it could arguably be “on sale”. NOTE: This is a user-defined variable and is subjective depending on who does the calculations. We base it on info from the following site, which is based on Warren Buffett / Berkshire annual reports. NOTE2: All our calculations are based on a 10yr history. If the company was not around for the 10 years prior to a given date, the DCF values will be 0. Click here to understand more:
https://www.buffettsbooks.com/how-to-invest-in-stocks/advanced-course/lesson-35/
NOTE: DCF_IV uses a 10% disc_rate (the lower the rate, which should be close to the 10 yr interest rate but not less than 6, the higher the intrinsic value) 10% is good for large cap stocks.
DCF_IV2 – uses a 15% disc_rate (the lower the rate, which should be close to the 10 yr interest rate but not less than 6, the higher the intrinsic value) 15% is good for small cap stocks.
CURR_DISC_PCT – (curr_price/dcf_iv). If this = 50, then the stock is currently trading at a 50% discount to the DCF
CURR_DISC_PCT2 – (curr_price/dcf_iv2). If this = 50, then the stock is currently trading at a 50% discount to the DCF2
ACM – Acquirer’s Multiple: EBIT (earnings) / enterprise_value (total cash to acquire a company). High ACM is good. Here is where you can find more info:
https://acquirersmultiple.com/
EBIT – Revenue – (Cost of goods sold + Selling, general and administrative costs + Depreciation and amortization)
ENTERPRISE_VALUE – total cash to acquire company. ie: Market Cap + Preferred Equity + Non-Controlling Interests + Total Debt – Cash and Equivalents
BV_IV – Intrinsic value based on book value. Very similar to DCF_IV above, but uses the book value method instead of the discounted cash flow method. See the following lesson to understand how we calculated it:
https://www.buffettsbooks.com/how-to-invest-in-stocks/intermediate-course/lesson-21/
DPS – dividends per share
DIVIDENDYIELD – yearly dividends / price
YR5_HIGH – highest stock price the previous 5 years
YR5_HIGH% – (yr5_high / price)
YR1_HIGH – highest stock price the last year
YR1_HIGH% – (yr1_high / price)
ACTUAL_OWNER_EARNINGS – dps+bv_growth (dividends per share + the growth in book value from the previous year). Ie, how much cashflow did this make the owner.
NCAV – net cash asset value
ROE – return on equity
RONTA – return on net tangible assets
FCF – free cash flow