Stock Analysis Excel Template (

2,500.00 Inc. GST

This is the customized excel template, which we use to analyse stocks as per our preferred parameters by using the data downloaded from website.

The excel sheet has a dashboard of key analysis parameters, which helps us make an opinion about any stock within a short amount of time (sometimes within a few minutes).

This excel sheet provides the financial data of the stocks from website, in our preferred format, which ensures that an investor has to only make opinions based on the data/dashboard self-populated by the excel template. The excel sheet does away the need to manually input the financial data from the annual reports and therefore, saves a lot of precious time of the investors.


Users/Investors’ Feedback about this Stock Analysis Excel Template:

The stock analysis excel template was initially made available for download on July 11, 2016. Hundreds of investors have downloaded the same and quite a few of them have provided their inputs about the excel template. Here are some of the responses sent by the users of this template:

“This is a great tool for getting down to the heart of a company’s financials. When I was doing my MBA at NYU I had a valuation professor who encouraged everyone in the class of 60 to make their own customized sheet similar to what you’ve made. I was a fan of Buffett so I remember keeping some of his metrics in view and creating a sheet! Of course yours is head and shoulders above anything else I’ve seen – kudos!”

– Uday (via email)

“The excel template is quite useful. It makes things easy for us in not doing the hard labor and calculating all vital data for each company separately. “

– Ashish (in the comments to this page)

“Thank you Dr. Malik. The tool is indeed very useful and super-fast to use. God bless you for creating it! Please use this as part of ur training to perform financial analyses of different types of companies in different performance contexts across industries. I am sure others will also love it.”

– Harsh (via email)

“Dear Sir, I have downloaded the excel. It’s simply AMAZING, EFFORTLESS and AWESOME. Kudos to you and your team for wonderful creation..”

– Vikram (via email)

“I have purchased your excel template and honestly speaking it is just great. Thanks for such a brilliant tool and the lessons you have taught here. This excel is really a great source of analyzing the financial position of the company”

– Krishnendu (as comments at “Ask Your Queries”)

“I am using your excel sheet on screener to analyse stocks. It’s been very useful and the concept of SSGR and FCF helps separate quality stocks from the rest.”

– Hardik (via email)

The structure and sample screenshots of the stock analysis excel template file are as below:

1) Analysis sheet: This sheet presents values of more than 40 key parameters in the form of a dashboard. These parameters cover analysis of profitability, capital structure, valuation, margin of safety, cash flow, creation of wealth, sources of funds, growth rates, return ratios, operating efficiency etc.

Having a quick look at these parameters in the form of the dashboard helps in quick assessment about the company, its historical performance and its current state of affairs.

Screenshot of larger resolution output of the Analysis Sheet: Click Here

2) Description sheet: This sheet contains details about description and interpretation of about each of the more than 40 parameters. It is advised that investors should read this sheet in detail before starting with the analysis of companies by using this template.

Screenshot of the Description Sheet: Click Here

3) Instructions sheet: This sheet contains details about the steps by step apporach to get started with this sheet on website, change in settings for Microsoft Excel to resolve common issues and other instructions for the buyers.

Screenshot of the Instructions Sheet: Click Here

See the step by step guidefor uploading the excel sheet on with screenshots: How to Use Export to Excel tool

4) Version history: This sheet contains details about the changes/updates made in each of the new versions of the sheet.

You may read about various stock analysis articles and see the screenshots of the excel template in the “Author’s Response” segments on the following link: Stock Analysis Articles

How to Download this Excel File

After you have made the payment, you may download the excel in any of the three methods:

  1. After the payment is successfully done on Instamojo (or PayPal), you will be taken to a page showing the successful completion of your order. On this page, you will be given a link to download the excel file.
  2. After the order is successful, you will receive an email from us containing your order receipt and payment details. This order receipt will have a link to download the excel file.
  3. After successful order, you will get an email from us containing your username and password to log in at You may log in to your account using these details and then download the excel file from My Account > Downloads

If you still face any challenges in downloading the excel file, then you may email us at, detailing the issues that you are facing. We would be happy to help you out.


Key Instructions to the Buyer


1) This excel sheet is for the sole use of the buyer from Any copying and sharing of this excel sheet is strictly prohibited.

2) This purchase is limited to the current version of the excel sheet only. Any future updates/versions of the excel sheet need to be bought separately.

If in future, because of any reasons, Screener changes the format of data it provides in the “Data Sheet” or makes this template invalid, then I would not be able to provide resolution of the issues in this excel template.

In such a scenario, I might come up with a new version of the excel template. However, the new version needs to be bought separately by the users.

3) In the original versions of the excel template sheet, all the formula links were locked for editing. However, after request from investors, now all the formula links are unlocked. Nevertheless, I suggest that investors should not make any change to any formula/sheet in this excel workbook. Any change might lead to corruption of the formula links and might lead to erroneous results

4) Links to detailed articles on have been provided under each formula segment in the “Description” sheet, which you may read to learn more about each of the analysis parameters.

In case you have any further query after going through the article links shared in the “Description” sheet, then you may ask your query on as a comment to the “Ask Your Queries” page.

5) Detailed interpretations and descriptions of each of the parameters used for analysis on “Dr Vijay Malik Analysis” sheet are provided in the “Description” sheet

6) Please read the “Description” sheet thoroughly before analysing the data of any company.

7) Steps to use the excel template sheet are detailed in the “Instructions” sheet.

8) Target Company:

The aim of the analysis is to find a debt free company, which is growing at a reasonable pace with sustained/improving profitability margins, which has been showing improvement in operating efficiency and has been generating positive Free Cash Flow over the years.

If an investor is able to find such a company that is available at a cheap price (P/E ratio < 10), then investment in such a company has a high probability of creating wealth for the shareholders.

All the best for your investing journey!


Dr Vijay Malik

Read more details about Dr Vijay Malik’s Stock Analysis Excel Template (compatible with Click Here

You may also like…