Fundamental analysisValuation Models

Stock Health Checkup

Written by admin

Sat Mar 27 2021

See how MarketXLS helps you take advantage in the markets.

Download Option Templates →

Investors need to judge the stocks on various parameters before they invest in them. This template will provide investors with tools to analyze the stock based on its numbers from financial statements and also compare the performance of the company with its peers from the industry.

The template provides the following analysis:
> EPS growth (Basic and Dilutive)
> Revenue and Net Income Growth
> Comparison of EPS, P/E ratio with peers
> Profitability Margins relative to the peer

Interested in building, analyzing and managing Portfolios in Excel?

Download our Free Portfolio Template

Download Option Templates

Real gdp Real personal consumption exp Real private investment Real govt expenditure Real net exports Real exports Real imports Federal receipts Federal outlays Federal surplus or deficit Federal debt Real private investment nonresidential Real private investment residential Real potential gdp Real personal income Real personal consumption exp monthly Rpce durable goods Rpce nondurable goods Rpce services Personal savings rate Monetary base Currency in circulation Bank reserves Money supply m1 Money supply m2 Sp500 Djia Wilshire index Vix Financial stress index Corporate bond index aa Corporate bond index bbb Federal funds rate Treasury rate 3m Treasury rate 1y Treasury rate 5y Treasury rate 10y Tips 5y Tips 10y Bond yield aaa Bond yield baa Mortgage rate 15y Mortgage rate 30y Us dollar weighted average Usdollar to euro Usdollar to pound Yuan to usdollar Canadiandollar to usdollar Yen to usdollar Cpi Cpi wo food energy Cpi food Cpi energy Chain price index Chain price index wo food energy Gdp price deflator Ppi final demand Ppi finished goods Ppi material Ppi crude goods Ppi final demand wo food energy Ppi finished goods wo food energy House price index House price index 20city Crude oil price Gasoline price Natural gas price Industrial production Capacity utilisation Inventories Sales retail food Vehicle sales light weight Manufacture orders durables Manufacture orders capital goods Loans Consumer credit outstanding Corporate profits Housing starts Building permits Residential construction Employees nonfarm Employees private Employees goods producing Employees service providing Employees government Unemployment rate Initial cliams Average weeks unemployed Job openings Hires Separations Quits Layoffs discharges Hours of production Hourly earnings Real output Population Labor force Labor force participation rate

Search for a stock

Top MarketXLS Rank stocks

More Features