Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
BasicsFundamental analysisStock investments

Stock Health Check-Up (Is The Stock Healthy To Invest?)

Written by Vanshika Kothari
Mon Apr 26 2021
Stock Health Check-Up (Is The Stock Healthy To Invest?) - MarketXLS
See how MarketXLS helps you take advantage in the markets.
Download Option Template →
Stock Health Check-Up (Is The Stock Healthy To Invest?) - MarketXLS

“The stock market is filled with individuals who know the price of everything, but the value of nothing.” ― Phillip 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. The higher the P/E means the company has been overbought, and investors can compare it with the average P/E ratio of the peers. 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 the ratio of Gross profits (Revenues – Operational Expenses) to Total revenue. It tells investors how much margin the company gains over its operational expenses.

The EBITDA margin is similar to the Gross margin, but instead of only operational expenses, it includes the other fixed costs as well and excludes only Depreciation & Amortization, Interest, and Tax expenses.

Net profit margin includes all expenses in the calculation and gives the idea of the company’s overall profitability.

Check the Stock Health Using Excel (MarketXLS Template)

Stock Health Check-Up

Find this template here https://marketxls.com/marketplace/product/stock-health-checkup/

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. 

EPS Analysis

Stock Health Checkup

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.Graphical Analysis



Lastly, all the different segments of the 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 Line

Before 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, but with the help of MarketXLS, you can do that comfortably and hassle-free. You can get all the historical data (EOD, Intraday) you may need with MarketXLS functions in a few clicks.

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.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today
Search for a stock

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

Top MarketXLS Rank stocks

Rush Enterprises Inc. Class A Common Stock logo

Rush Enterprises Inc. Class A Common Stock

Optionable: Yes
Market Cap: 2,812 M
Industry: Auto & Truck Dealerships
52 week range    
PulteGroup Inc. logo

PulteGroup Inc.

Optionable: Yes
Market Cap: 11,760 M
Industry: Residential Construction
52 week range    
Williams-Sonoma Inc. (DE) logo

Williams-Sonoma Inc. (DE)

Optionable: Yes
Market Cap: 8,021 M
Industry: Specialty Retail
52 week range    
Moelis & Company Class A logo

Moelis & Company Class A

Optionable: Yes
Market Cap: 2,906 M
Industry: Asset Management
52 week range    
Houlihan Lokey Inc. Class A logo

Houlihan Lokey Inc. Class A

Optionable: Yes
Market Cap: 6,656 M
Industry: Capital Markets
52 week range    
Coca-Cola European Partners plc logo

Coca-Cola European Partners plc

Optionable: Yes
Market Cap: 25,255 M
Industry: Beverages - Soft Drinks
52 week range    
Dun & Bradstreet Corporation (The) logo

Dun & Bradstreet Corporation (The)

Optionable: Yes
Market Cap: 6,031 M
Industry: Business Services
52 week range    
Dick's Sporting Goods Inc logo

Dick's Sporting Goods Inc

Optionable: Yes
Market Cap: 10,470 M
Industry: Specialty Retail
52 week range    
Columbia Sportswear Company logo

Columbia Sportswear Company

Optionable: Yes
Market Cap: 5,627 M
Industry: Apparel Manufacturing
52 week range    
CNX Coal Resources LP logo

CNX Coal Resources LP

Optionable: Yes
Market Cap: 7,105 M
Industry: All Other Business Support Services
52 week range    

More Features