A stock health check-up tests whether a company's fundamentals support investing in it, using four groups of metrics: basic and diluted EPS over five years, P/E and EPS compared with sector peers, five-year growth (CAGR) in EPS, revenue, and net income, and profitability margins (gross, EBITDA, and net). The MarketXLS Stock Health Check-Up template pulls all four for a ticker and year you enter and charts them against peers.
Try it in your own spreadsheet
Get the free MarketXLS sample workbook (.xlsx).
No account needed. MarketXLS live data requires a paid plan. Preview workbook
Explore more videos
“The stock market is filled with individuals who know the price of everything, but the value of nothing.” ― Philip Fisher. Investors need to judge the stocks on various parameters before they invest in them. A proper understanding of the company and its performance is essential before investing, which can be done by a Stock Health Checkup. Buffett advises investors to not think of their investments as “stocks” but to think of buying a stock as purchasing an entire business. Hence, before investing, investors should take a thorough look at the company’s health and evaluate the industry with the help of various metrics.
The stock price is majorly driven by the company’s future prospects and growth. It is imperative to check for the company’s fundamentals. The Financial Statements reveal a lot about the company’s business and health. Financial statements offer a window into the health of a company, which can be challenging to gauge using other means. To accurately assess a company’s financial health and long-term sustainability, investors must consider several financial metrics in tandem.
Key Areas To Look For
Quite often, evaluating the financial statements can be strenuous and cumbersome, involving numerous pages containing facts and figures. So, which are the right areas to look for and the correct metrics to assess?
-
Basic and Diluted EPS Basic and Diluted EPS analysis helps investors gauge the income that the company can generate per outstanding share. Basic EPS gives information about how much a company’s net income was allotted to a share of common stock. Diluted EPS is used to measure a company’s earnings per share (EPS) if all outstanding convertible securities such as convertible preferred shares, convertible debentures, stock options, and warrants. were exercised.
-
Peer P/E and Peer EPS Analysis The P/E (Price to Earnings) ratio is equal to the market price of the company divided by its EPS. The investor gets an idea about the company’s valuation concerning its peers chosen in the list. A P/E well above the peer average means investors are paying more for each dollar of earnings, usually because they expect faster growth; it does not by itself mean the stock is overbought. Investors can also analyze the company’s EPS with the average of its peers to get an idea about the relative earning capability of the firm.
-
Relative Growth analysis It is always good to invest in companies with better operational efficiency. The profitability ratios like Gross margin, EBITDA margin, and Profit Margin give this idea to the investors.Gross margin is gross profit (revenue minus cost of goods sold) divided by revenue. It shows how much the company keeps from each sales dollar after direct production costs. EBITDA margin is earnings before interest, taxes, depreciation, and amortization divided by revenue, so it also subtracts operating expenses such as selling and administrative costs.Net profit marginincludes all expenses in the calculation and gives the idea of the company’s overall profitability.
Check the Stock Health Using Excel (MarketXLS Template)
With the help of MarketXLS, investors can evaluate the Stock’s Health without any hassle. By entering the Stock Ticker and the year, investors can get the metrics for assessing the stock’s health. The tedious work of data collection and processing gets simplified with the help of this template. It also provides interactive graphs, which makes the interpretation much easier and more perceivable.
Breaking Down The Template Into Segments:
-
EPS Analysis: This segment will highlight the EPS values of stock over the past five years. Both the Basic and Diluted EPS are calculated and displayed.
-
Industry PE & Peer EPS Analysis: The second segment requires users to enter the Sector peers as per their discretion. The template will calculate the EPS (basic and diluted) and P/E ratio for the specified year. Users can compare these values with peers and the average of all as well.
-
Relative Growth Analysis The template will calculate the CAGR growth rates in EPS, Revenue, and Net Income (Profit) over the last five years in this segment.
-
Profitability Analysis The template will calculate the Gross Margin, EBITDA Margin & Net Income Margin for the company and its peers in the industry for users to compare the firm’s profitability.
Lastly, all the different segments of the Stock Health Checkup template are put into various charts and graphs that provide an interactive visual dashboard for the user to get all the information at a glance.The Bottom LineBefore investing, just knowing the price will not be enough for investors; as Phisher rightly pointed out, the knowledge value of the company is a must.
Selecting the right company to invest in can be a strenuous task. Analyzing companies and their performance using their financial statements takes a lot of time and effort, and MarketXLS functions pull the historical price and financial statement data into Excel so the template fills itself.** Disclaimer**
None of the content published on marketxls.com constitutes a recommendation that any particular security, portfolio of securities, transaction, or investment strategy is suitable for any specific person. The author is not offering any professional advice of any kind. The reader should consult a professional financial advisor to determine their suitability for any strategies discussed herein. The article is written to help users collect the required information from various sources deemed authority in their content. The trademarks, if any, are the property of their owners, and no representations are made.
