Stock Analysis Worksheet V2.1.6.1

Use this worksheet to analyse your stocks. Just copy and paste the financial data of stocks in this worksheet, and it will do the rest. What it will do? It will estimate the stocks intrinsic value. Recommended: Kindly read all FAQ’s before purchasing the worksheet.

How to Buy?

Pay using the buy button. You can also pay using UPI & get discount Once the payment is made, the download link will be emailed to your email id. Check your Inbox/Spam box after payment. 

  • Pay online
  • Provide your Email ID
  • Download Link will be emailed
  • Check your inbox/spam box
  • Email 'll be from "Instamojo"
  • Download before link expires
  • Link expires in 24Hrs of Payment

Why to Buy?

This worksheet is one of its kind. It helps its user to convert financial data into “intrinsic value“. This eventually helps the user to check if the stock is fairly priced (undervalued) or not. Buy to:

  • Analyze Indian stocks
  • Experience fundamental analysis
  • Estimate Intrinsic Value
  • Know if stock is Overvalued
  • Gives stock an overall rating
  • Calculates financial ratios
  • Plots 10 year price trend

Introduction

What a layman can do with Balance sheet of companies? Very less. Reading financial reports, and estimating intrinsic value from those numbers is a challenge. This is where my “stock analysis worksheet” can help its users. Watch its introduction video & read this article to know more about it.

Tips

  • Copy data using "Chrome" Browser
  • Read all FAQ's before use
  • Take'ur time to enter data (15 min)
  • Must watch data entry video guide
  • Watch the video guide before use
  • Never remove password protection
  • Basic MS Excel skill is required

Limitations

  • Stock must have 10 year data
  • Full editing rights is not provided
  • Gives no investment advice
  • Runs only on "MS EXCEL"
  • Copy data using Chrome browser
  • Works only for non-banking stocks
  • It's built for Indian Stocks

Data Entry

Data entry must be done manually in the worksheet. Majority data is available in moneycontrol. Please watch the video guide to know “how to enter data” into the worksheet. This is a must to use the worksheet correctly. 

Utility of sheet

To get a feel of the utility of this worksheet, you are suggested to read this blog post. It will highlight the key aspects of this worksheet. 

Testimonials

"Your sheet is terrific once you know how to insert value. Stock Analysis Worksheet is the best time-saver sheet I have ever invested in"
Archit Jain
JUN 17, 2020 AT 4:39 PM
"The stock analysis sheet+ product includes excellent tools which one can use for managing personnel finance without requiring any other support. The best of this package is a stock analysis worksheet which is very handy to analyze the stocks and one can make decisions based on underlying value. initially a bit tricky to enter data but after watching the help video all got resolved. thanks for providing these tools at a reasonable cost which is very useful for retail investors.i would definitely recommend these tools to my friends."
Amit Magadum
JUN 12, 2020 AT 9:41 PM
"The work sheet has been of great help for me could analyse quite a bit of stocks"
Suresh J.R
JUN 5, 2020 AT 11:22 PM
...I got benefited from this sheet a lot.. Thank you Mr.Mani.. keep up your good work.
Vaitheeshwaran Manickam (Youtube)
JUN 04, 2020 AT 08:15 PM
Brillant Excellent, I suggest and recommend , if anyone want to do value investment, i suggest buy his stock analysis worksheet, I have been using and have benefited a lot and made my investment safe good work Mr Mani, it is so simple
Kavish Shah (Youtube)
JUN 04, 2020 AT 5:21 PM
I purchased your sheet even without any commerce background, your excel sheet can be used and it works well, Thanks for your great work
Muhammed k veerankutty
MAY 31, 2020 AT 12:08 PM
I found Mani's Excel Stock Analysis Worksheet to be very useful in estimating the intrinsic value of companies. It is easy to use, and easy to understand even for someone from a non financial background. I especially appreciate the quick responses I received from Mr. Mani when I had some doubts regarding the usage of the worksheet. I wish him well and hope he continues to improve the worksheet in the future as well.
Arjun
FEB 02, 2020 AT 10:28 AM
"I have brought stock analysis worksheet. Analysed around 10-15 stocks using and taken some investment decisions. I would like to tell you that , Past few months I was going through your blogs on getmoneyrich.com. I came to know importance of undervalued stocks with good fundamentals.I am basically a software engineer who wants to invest in stock market but does not have that much time and knowledge to analyse the stock.Your excel sheet has made it simple.I can also understand hard work behind this excel sheet"
Pravin Mogare
OCT 28, 2019 AT 5:32 PM
"I've to admit (having used it for a year now), this worksheet makes the monotonous work of data entry and computing ratios and other metrics a breeze and really easy once you get used to it. Barely a matter of 5-7 mins, once you get the hang of it , cheers to mani for making it so intuitive and user friendly. "
Raj
OCT 24, 2019 AT 11:27 AM
"Toolkit is very impressive and it is one pit stop providing all actionable inputs to make a sound discussion in this ever-changing dynamics of stock exchange. I recommend every one to try this out at least once."
Saurabh MISRA
OCT 16, 2019 AT 10:46 PM
" Guy's, seriously! this tool does the task it is meant for very effectively. Till now (since 20 July 2019, my date of purchase) I have done an analysis of almost 40 stocks with it and observed the performance of many and purchased some stocks too (many of them are in green since starting & few in red that too with negligible loss). This tool is value for money and will help you (Retail Investors) in value investing. Thanks to Mani for his efforts he has put into it, and again guys do check out his website also for original great learning content. Thankyou!."
NEERAJ MANDLOI
OCT 1, 2019 AT 2:35 PM
"Many people (like me) want to earn money from stock market without any knowledge about the stock market. So we followed the other people’s advice. In this situation some stocks will gain. Most of the stocks will fail. Now the situation is got an END. Yes now I bought your excel sheet. Here after there is no more red in my portfolio. The God will give all the prosperity to Mr. Mani and his family. Thanking you."
R V Aravintraj
AUG 23, 2019 AT 07:52 AM
"I am writing this feedback after using the tool for almost a year. To be honest, it's a wonderful tool which provides complete picture of Vitals of Stock and intrinsic value by various methods, which covers required risk factors. In my opinion, the values calculated indicate what a conservative investor will follow and hence any type of investor can take this tool to check parameters of a stock before deciding on investment. Overall a great tool and really helps to help in putting forward structured method behind investment"
GAURAV TALWAR
AUG 12, 2019 AT 09:50 AM
“It is a guiding tool for investors and I appreciate you efforts and for meaningfully sharing your knowledge. A very complicated process of analysing a stock from various angles, incorporating the huge available data, has been much simplified and designed in such a way the user need not have an in depth knowledge of Stock or the MS Excel”
MANICKAM PARI
AUG 05, 2019 AT 01:41 PM
"STOCK ANALYSIS WORKSHEET is loaded with handpicked stock analysis techincal element. This is a great place for any investers to start with to understand basics or build further from it. The "STOCK ANALYSIS WORKSHEET" is your first assest in the wealth creation process. Good Work Mr.Mani for all your efforts put in to morph this sheet. very well done. "
Subramaniya Karayalar
AUG 03, 2019 AT 1:48 PM
"Mani has made so complex thing so simple. I need not spend years and years learning all the basics. Use the excel, enter the data and boom !! I have the recommendation for which a professional adviser would have charged thousands of rupees. I was in search of similar excel and just landed on this. Thanks Mani for making my investment life super easy !! And yes, the articles on Mani's website are very useful as well"
Lalit Rawat
JUL 19, 2019 AT 6:03 AM
"This tool is good to get optimal price. As a long time invester, i can wait till the optimum price to buy shares. I will stop investing many share eventhough those are good company shares. Most of the times those are available in overprice rate."
Ashok
JUN 26, 2019 AT 11:00 PM
"Good work Mani, keeping it simple for people like. Really clear instructions provided and keep up the good work."
Aditya Rana
JUN 25, 2019 AT 11:01 AM
"The analysis procedure and thought process that has gone into compiling this worksheet is very commendable. It is very useful for all equity investors"
CAPTAIN KENJLE
APR 04, 2019 AT 1:31 PM

FAQ's

Have made the payment, how to get the worksheet?

Check your Inbox/Spam box [Read: how to buy]. The download link is provided in the email. The downloadable file is zipped. Use the link to download the file into your laptop or desktop device. The worksheet works only on device which has MS OFFICE loaded on it. Read about limitations.

Why the download link in the email is not working?

The Download link will work only for the first 24 hours from the point of payment. This feature is necessary to limit the number of downloads, and unjust circulation. [Read: how to buy]

How to use the worksheet?

Before using the worksheet, first read all the FAQ's listed here. Once done, see every minute of the “video guide” on data entry. Also read the "good practices" listed in this FAQ.

Getting #DIV/O Error. What to do?

DIV Error will appear only when the data entry has not been done properly. Before using the worksheet, first see every minute of the “video guide” on data entry. The video has been embedded in this page itself. See section “Data Entry” above. ​

Upon data entry why worksheet is indicating password protection?

The worksheet is password protected. But the message related to password protection will appear only “if copy/pasting of data is not done properly”. Solution is, watch the Video guide related to data entry. Read about other limitations.

What are the "good practices" while starting to use this worksheet?

(a) Download the worksheet. (b) Make a duplicate Copy. (c) Go Step by Step. (d) Do not start analysing stocks from day one. (5) First, see every minute of the “video guide” related to how to enter data. (e) Try to implement it simultaneously in the worksheet. (f) Idea should be to learn to “paste data” as suggested in video. Read about other quick Tips here.

Does This Product Offer Investment Advice?

None of the articles or products of this Blog offers any investment advice. Please make sure to read the disclaimer before use.

Why the sheet is showing errors for stocks like HDFC Bank, Axis Bank etc?

This worksheet can be used only for non-banking stocks.​ In case you want to know about how to analyse banking stocks, you can read this article. Also read about other limitations of this worksheet.

In addition to banking stocks, all stocks which does not have 10 years data will show errors (check all limitations here).

Which browser to use to copy data from internet?

Always use Google's Chrome to copy data from internet as instructed in the video guide. Other browsers like Firefox, Safari, Microsoft Edge etc will renders errors in the worksheet. Read about other limitations.

The Data Entry process is time taking, can it not be reduced?

For a new user, data entry process may look slightly daunting. But with time, when the user gets used to the work, it will become easy. Generally speaking, for a trained hand, it will not take more than 10 minutes to enter data.

What is the Refund Policy?

Considering that Stock Analysis Worksheet is a "Digital Product", the paid money cannot be refunded. Having said that, this is also true that the question of refund will not arise if the "DATA ENTRY" is done properly. Why? Because when data entry is proper, worksheet will render the results. Please make sure to read the "limitations" of the worksheet.

I do not know MS EXCEL, can I use the worksheet?

Basic knowledge of MS Excel is necessary. The level of skill necessary can be understood by watching the video guide. The user is only asked to copy data from internet and paste it in worksheet.

Bought the worksheet sometime back, how to get the updated version?

The worksheet gets updated with time. Occasionally we give offers to existing users, but there is no promise that existing users will get the future updates. But I wish, some day I will be able to extend this facility to all users.​

Which range of dates should be selected for the price sheet?

Selection of 10 years “monthly” data is necessary. For details watch the video guide. Example: Current date: 23-08.2018, Back date: 24-08-2008.

Whom to contact in case of problem?

In case of problem, I will suggest you to first read all the FAQ's. Also, read about the "Good Practices". In case your problem is not covered in FAQ's, & video guide kindly email me at mani@getmoneyrich.com.​

Why my E-mails are not replied?

Generally I'try to answer all emails related to problems faced by users. But requests for resending worksheet, queries on sheet's algorithm, finding the cause of error, commercial emails, personalised queries, general queries etc may not get a reply.

Version Logs

It’s a minor update. A reporting format showing 10Y snapshot of Balance Sheet, Profit & Loss account, and Cash Flow Statement is introduced. 

This is a major update where changes are made both in worksheet’s back-end and front end. Some mathematical models have been improved while couple of the old ones are also discontinued.

This update takes care of how how free cash flow and intrinsic value of stocks is estimated by the worksheet using Discounted Cash Flow (DCF) method. Know More about it here.

Management, profitability & financial health grading algorithm has been updated. It bring changes to the “overall score” given to stock in the “Cover” sheet (Oct-2019)

Effect of recent “Price trends & PE trends” has been considered to estimate intrinsic value (fair price) of stocks (Aug-2019)