Ask Your Questions

This page is meant to encourage you to ask your questions related to personal finance, investment, money management etc.

I know, a lot of readers of my blogs are quite young. When I was that age, I had hundreds of questions on the topic of investment and money management.

At that time I could not find a place where I could put-up my queries. In those days internet was also not as advanced as it is today.

But today the internet has really evolved in terms of the contents & solutions it delivers. The speed of internet has also increased several folds, as a result, these days contents are shared in the from of audios & videos as well.

Today 14-May’2017, a thought came in my mind that why not use getmoneyrich as a Q&A forum. In this forum people can ask questions and it will be open for answering by anyone on internet.

This idea really excited me because there is nothing more exciting for me than solving problems of my readers. For sure, I may not have all the answers. So the questions asked in this forum will be a learning ground for me as well.

But more than that, if I could solve even one problem each day of a needy person, I will consider this forum a success.

I encourage you to pen down your doubts about investments regularly on a separate notebook. Try to find answers of them on internet. If you are not able to get a solution, ask your questions in the comments section below. I will do my best to answer your queries.


97 Comments on "Ask Your Questions"

  1. Hello… Sir can i know what are the indicators used in stock market

  2. ANAND PENDHARKAR | March 3, 2018 at 9:43 am | Reply

    Could you please guide me to an article about investing in Gold (ETF Or F of F), PROS and CONS, taxation, time frame etc.

  3. Dear Shri Mani,
    I had purchased new worksheet from you and started analyzing.To my surprise, most companies not scored even 50%.To check myself I am requesting a small help from you.Can you send me the intrinsic value and overall score of HATSUN AGRO PRODUCTS for cross-checking?
    Thank you,

    • In the present levels in stock market, most of the stocks are trading at overvalued price levels. Though there are stocks which which will score higher (than 50%).

  4. Hi,

    I have been reading your blog. It is quite useful?
    Can you throw some detailed analysis on the crypto currency and how to invest in it?

    But many good companies do not cross even 60%, yes that may be because of overvalued stock.
    In some of these companies i have found all scores good except for the future growth, which is negative is them. How do this worksheet calculate future growth? and if everything is good scoring except for the future growth what does it mean??

    • Companies may have strong business fundamentals, but if they will not grow sufficiently fast in future, they may not be as profitable for the investors. Hence low score.

      Please note that predicting future is not possible. But looking at the past results, we can assume future growth rates. The stock analysis worksheet does just that.

      Thanks for your compliments.

  6. Susovan Chowdhuri | February 11, 2018 at 10:05 pm | Reply

    Sir I want to Buy “Stock Analysis Worksheet V2.0.5”,and I want to know that if this worksheet get any update By you, then will I have to buy it again or it will be free for me as I paid for it once.

    • Worksheet gets updated gradually. Time and again we issue offers for existing buyers. When such offers come you, will notify the existing users.

  7. Hi Mani,

    I have been reading your blog posts for last few months and found those quite helpful.
    I read your analysis on Lupin. I understand that the company is facing various challenges with situations like USFAD compliance, acquisitions and those may be affecting the overall performance. Do you still believe with 5 years horizon company has good future? and stand by your previous analysis?


    • There are some excellent companies operating in India in the pharma sector. They have been competing with international markets since many years now. I personally believe that in long term they will shine again.

  8. In the context of the present budget; could you reccomend how to generate a fixed quarterly income in Mutual funds(both equity and debt)?
    Could you give a few reccomendations based on your assessment?

    • Fixed income generation plans of mutual funds are mainly debt based plans. They already had DDT imposed on them. So the present budget 2018 doesn’t change much.

  9. Dear Mani
    Thanks for all the inspiring and informative content that you are sharing with us. I had a query :
    I had bought a flat two years back as an investment with 50 percent loan .I would like to know how long should one hold on to property for financial benefits.Thanks for your support

    • Thanks for your kind words.

      Hold the flat till your investment goal is achieved. If you have not though of a goal, do it now and compare the performance of your investment. It will be worth an effort. Try it…

  10. I used the stock analysis worksheet for Tata Motors and it is throwing up some wierd numbers. Like EPS(TTM) of 0 and market cap of INR 2889 crores! The intrinsic value by most of the methods is showing as zero. It is also showing a few 0/DIV errors. Where did I go wrong? Can we contact by email for any support with the excel sheet?

    • Dear Prashant,
      I have checked the numbers for Tata Motors. The worksheet is not throwing weird numbers. I have send you a separate email. Please check the same. You must check if you are entering the data correctly in the worksheet. Please make sure to watch the Video Guide on “how to enter data into the sheet”.

      I can understand your confusion:
      – EPS TTM:
      Moneycontrol is showing a EPS (TTM) of 35.15.
      But when you will see companies last few quarterly reports, EPS of last 4 quarters are all negative. In this case how EPS(TTM) can be 35.15? By the way, the worksheet is showing EPS (TTM) for Tata Motors as -7.77.

      – Market Cap
      I have checked, the worksheet is doing the calculations correctly.
      Though it is possible that it will not match one on one with moneycontrol etc datas.
      Have you copied the price history correctly from
      I think this is the cause of error. Please check.

      – Intrinsic value
      You are right, for Tata Motors, the worksheet is estimating intrinsic value as zero. This is on account of its negative free cash flow for last many FY’s. When sheet calculates the intrinsic value in negative, it displays it as Zero. I am sorry, but its the numbers of Tata Motors to blame 🙂

      By the way check if you have entered the valves indicated in red cells of the CF-Old report. It cannot be zero.

      I hope the clarification helps.

      [By the way, make sure to watch the video guide on how to enter data into the sheet before usage.]

  11. Hi,

    By using your worksheet I got intrinsic price of Bajaj electricals is 768 RS.

    But when using Graham’s formula it is somewhere around 260 rs. Could please explain where I am doing wrong.

    Could you please explain EPS growth % calculation for next 5 years in Grahams formulae.

    • Different calculation methods will divulge their own unique intrinsic value number.
      Stock analysis worksheet gives different weightage to each of the methods used, and comes up with it own estimated intrinsic value number.

  12. Is the stock analysis worksheet useful for insurance, NBFCs, housing finance companies? I have bought it but would like to know if it is useful for above type of companies.
    Also, if the cash flow is 0 for preceding two years, what am I supposed to do? The worksheet advises to put the value of the third preceding year in the above two slots. Is that correct?
    Thank you.

    • The worksheet cannot be used for core Banking Stocks.
      But this worksheet can be used for other stocks.

      Cash flow cannot be zero for any company.
      When data is being displayed as zero, it means moneycontrol has not been able to source the right data.
      This is the reason why I have asked to put values of preceding years. There is the best way.
      The other way is to wait for moneycontrol to update their database.

  13. Sir, can u please tell me basic books for investing in equity stocks

    • You can read “One Up on Wall Street” by Peter Lynch. If you are new to stock market, I will suggest you to read some good blogs first, develop some basics, then invest in the book.

  14. Mani,
    I am intend to buy NEW Stock Analysis Worksheet – V2.0 but on video listen that if by mistake even if you copy/paste data in place of key-in/typing file will be corrupt. So my question is what is remedy in that case or do I have to buy again? How to resolve it. Kindly Reply ASAP.

    • Solution is ver simple. Always keep the master file handy. Make changes only in the duplicate file. Nevertheless, I will be accessible for support.

  15. Dear Mani,
    This is great Blog for investments ! keep going !!
    I have one query…i will get 2L this months from my RD investment, my Wife willing to take Bank bond but i m not interested on this…atleast i would like to go Balanced Funds or ETF Bonds. Please advise what is the best option for long term investment?


  16. Sir my age is 20 years and I want to start a Sip for 35 years and I want to invest 2000 per month. So tell me the best sip plans.

  17. Regarding Franklin India Bluechip Fund (D) dividend of 8.23%, could you please explain how this is calculated.
    If I had invested Rs100 in the fund what actual return would I have got after the last dividend announcement?

    • For every Rs.100 invested, the fund will yield a dividend of Rs.8.23 per annum.

      1. NAV of this fund is Rs.45.0348/unit
      2. In year 2017, it paid only once (on 27-Jan’17) a dividend of Rs.3.5/unit
      3. Dividend Yield for year 2017 = 7.77% (3.5/45.0348)
  18. Sir , can i know any mobile application available for share market if, available please mention it sir…

  19. HI,

    Thank you very much for the blog.
    Today I bought your excel sheet. I worked out. I got the intrinsic value for both the companies as Negative. Page industries and Bajaj Electrical’s. I double checked the data entry. but still I doubt that negative intrinsic Value. Could you help me in this?

    one more thing is that_ how to calculate 3 years return or 5 years returns. it is not shown in the excel. I was wondering it would be good add in the excel.

    • Please check (in Data_Entry Sheet – Cash Flow Statement) if the “Net Cash from Operating Activity” is showing as zero? These days this error is common in Economic Times. If it is zero, please get the data from moneycontrol.

  20. Thank you sir can i know what’s the difference between mutual funds and stock market

  21. Thank you mr.mani.iam a engineering student, can I invest my pocket money in a share market, it is possible or please give a good idea for me sir….

    • People over 18 years of age can invest in stocks. But considering that you are young, it will be better to start with mutual funds, and then gradually take up stocks. You can open an account in FundsIndia etc who offer both stocks and mutual funds as investment options. You will requires your PAN and AADHAR.

  22. Continue with the Capital gains tax exemption article- If after 5 years, I re-invest my proceeds in NHAI or REC Bond and lock in for another 3 years and then after after three years, if I claim a redemption. I hope that will not be taxable , even if it is- should be a small amount. please correct me if i am wrong.

  23. Hi Mani,
    I’ve purchased the excel today. Further worked up 2 companies. Inspite of following the steps, i find the IValue as -ve. Further the video & excel do not collaborate on Ratio section. Do suggest how can I share the same so that it can be checked..

    Awaiting revert

    • -ve intrinsic value is possible if the company is not growing, or its cash flow from operations is not enough. You will have to check in the companies financial copied from the Economic times.

  24. Hi Mani,
    I am 27 year old working girl from Pune. Many thanks for your blog and efforts to make people aware about personal finance.By nature girls wont take financial decision alone and rely on someones decision. Request you to please wirte articals for gilrs regarding managing personal finance in each stage of life single, wife and mother. Every stage is different and need different perspective. Hoping and waiting for new artical.

    • Thanks for your suggestion. I also agree that such article will be a good value addition for the readers. I will plan for it. Thanks again.

  25. What is a equidity share and what’s difference between Penny stocks and equidity share

  26. chandrashekar kothlapuram | November 8, 2017 at 2:36 pm | Reply

    Hello Mani
    Is it possible to create Excel worksheet based on Joel Greenblatt’s magic formula investing strategy(Indian Stocks)?
    Could you please let me know the difference between yours Stock Analysis Worksheet and this strategy?


    • Greenblatt’s is a big man. This is a big difference 🙂 He has written a whole book on this concept which has been a international best seller for years now.
      But there is a difference between a book (concept) and practical use. My worksheet is a tool which is ready to use.

      Moreover, to highlight the difference, Greenblatt’s approach is to shortlist good stocks. My worksheet does fundamental analysis of the shortlisted stocks.

      To know more about how my worksheet works, please see the video guides.

  27. HI Mani ,

    Your blogs are so informative , appreciate your efforts . Do we have any recommended and reputed financial services company in India to recommend any long term stocks for investments [ Period of 10 to 15 years ]

    • Dear Mathu,
      Most reachable option is your bank.
      If you want to explore more, a reliable alternative can be

  28. Dear Mani,

    Well done for a very informative website.
    I have 2 questions about the stock valuation spreadsheet:
    1. Can it be used on global stocks (European, Asian etc.)?
    2. Can it be used to evaluate stocks without a dividend yield (often found in small cap stocks)?
    Thanks in advance,

    • Dear Anthony,
      The worksheet has been prepared considering Indian stocks only.
      The worksheet can analyse stocks with zero dividend yield.

  29. Dear Mr Mani: I live in my own apartment in Cochin. I sold my flat in Delhi and after paying up all loans, I have Rs 50 lakhs with me. I’m 69 and my wife is 63. We want to live rest of our life without financial worries. I wish to invest this money that should generate enough income to maintain a car, pay the driver and housemaid, driver, health insurance and travel. How do I invest this amount that would give me Rs 60,000 a month after tax deduction? Regards

    • Dear Mr. KSNayar,

      Generating a fixed income of Rs.60K/month from a corpus of Rs.50Lakhs is difficult (almost impossible). Considering you are a retired person, I will assume that Rs.50L can generate around Rs.25-30K/month in India.

      I will suggest you to read this blog post that specifically talks about ‘how to invest retirement money in India’:
      I hope it will help.

      Thanks for your query.

    • Thanks Mr Mani. I’m going to read the posting that you suggested. One more request: Can you kindly suggest a financial instrument/s where I can invest Rs 5 lakhs for my 3 year old grandson which on maturity after ten years would give him a corpus that he can use for higher studies. Warmly Nayar

  30. Hello Mani, Its impressive to see your blogs and products, Good service to the people. Keep it up.

    I would like to invest in Mutual Funds for the period of 3-5 Years. Could you suggest me the best options? Monthly investment range is 20,000 INR.

    Is it also possible to meet you in person?

    Thank you so much.

    • Dear Murugesan,
      I will suggest you to try investing in those mutual funds those are attracting good ratings from agencies like CRISIL and VRO (Value Research Online). Depending upon your risk profile, you can opt for equity based, debt based, or balanced mutual funds. Considering that your investment time horizon is 3-5 years, you can invest 35% in equity based funds, and balance 65% in balanced mutual funds (balanced mutual funds are also exposed to equity).
      Thanks for your query.

  31. Gurpreet Singh | October 30, 2017 at 10:49 am | Reply

    Please give information that which state in India have given Stamp Duty relaxation to Real Estate Investment Trust and upto what extent.

    • Dividend distribution tax (DDT) and stamp duty on properties are still not removed from the ambit of REITs. But to make REIT’s effective in India, I assume that these taxes will eventually go.

  32. V RAMACHANDRAN | October 5, 2017 at 8:19 pm | Reply



    • Sorry. I do not have historical data of Sintex Industries and Sintex Plastics as separate entities. Hence, I am not in a position to put my observations here.
      Now Sintex Industries will work only in Textile segment.
      Thanks for your query.

  33. Hi Mani, great blog & very informative. Can yiu suggest what are the best sectors currently to invest in for long term right now?

    • Yesterday our PM launched ‘Saubhagya’ scheme to make ‘electricity for all’ a reality. Rightful implementation will boost our weakened power sector.

  34. Dear sir,
    It will be kind of you, if you can teach me to calculate Earning Per Share growth rate (EPSG) in last 5 years with an example.


  35. DEEPANSHU GUPTA | September 18, 2017 at 7:20 pm | Reply


    • In all probability, stock valuation is an activity that investors must do by self. The tip is to learn fundamental analysis of stocks. Estimating intrinsic value of stocks is a skill that can be build with study and practice.

  36. With the recent interest in Artificial Intelligence, can you tell me which Indian companies listed on the stock market are actively working in this field? Also, would it be the right time to buy their shares?

    • Hi Shruti, nice observation. A lot of companies are planning to increase their budget towards Machine Learning. In India, I assume, that it is still early days for AI. But one company that I have read is working heavily on AI, and is also listed in Indian stock market is BOSCH LTD (NSE: BOSCHLTD).

      Moreover, India being an IT hub for the world, software development companies of India must also benefit when more work on AI based programming starts to take place.

  37. Hi Mani,
    At the age of 47 is too old to invest in SIP or Mutual Fund? If yes which is the best option? please advise.

    • SIP is in a suitable mutual fund is for everybody. Select a right fund (debt vs equity balance) as per your risk taking capability and start investing through SIP.

  38. Where can I get the Intrinsic value of an Indian company?

    • Intrinsic value calculation is a complex task. People who know it will never publish. But there are financial ratios which will give a hint of what can be an estimated intrinsic value of a company.

  39. Sukdev Chandra | September 2, 2017 at 8:35 pm | Reply

    Hello !Mani sir . your blogs are wonderful learning path for me. I am 38. I have been investing Rs. 1500 in hdfc balanced, uti mid and utimnc per month. my tenure is 15 to 20 years. Do u think my fund selection is right ? Eagerly waiting for ur reply.

    • If this is all the investment you are doing, I will suggest you to slightly diversify your portfolio.
      You said your age is 38, so have at least 38% of your total invested funds in debt linked plans (like FD, debt funds etc).

  40. Hi Mani

    How reliable stock analyst sheet that your provide to pick the stocks ? I would like to invest in stocks

  41. Hello Sir, I’m 38 years and thinking of investing in MF through SIP of 1lakh every month (60%equity & 40%debt). Is it right time to do, as we are hearing correction is due & will happen in market. Can you please guide.

    • This is not a time we must start a SIP.
      Better will be to wait for the correction to happen. Till then, let those Rs.1L/month idle in your recurring deposit.
      Though I am no financial advisor, but I would have done like this with my money.
      Thanks Ashish for the query.

  42. Harvinder Singh | August 15, 2017 at 11:32 am | Reply

    Helo, I have read your blog on various topics, very useful for an investor. My question is is there any site where I can see the returns of a particular stocks for the previous years, which will be useful for investing in that particular stock.

  43. ASHISH SINGH | July 27, 2017 at 9:38 pm | Reply


  44. Hello Mani, provide us very informative and productive. I am from IT technical field. I also want to start a blog in IT technical areas so that I can create a good asset. Can you please put some light on topic that how to start a blog and various ways to get income from blog writting. Or can write a blog about this topic. This will be very beneficial for us.

  45. Hello Mani,
    The information provided on is really productive enough for a beginner like me. I am interested to invest into REIT but very less information is available on the which REIT’s should one invest. Could you please list down some good REITs companies in India to invest in them?

    • Hello Rohan, thanks for the compliment. It means a lot for me. Talking about REIT’s, its still not open for retail investors as on today. If I am not wrong, probably by end of year 2017, some listing is possible.

  46. Hi Mani Sir,

    I need your guidance and help in investing in share market and mutual funds which can give good returns as per the investment. Kindly let me know how to start investing as I am new to the field but very eager to invest in financial market.


    • Hello Srinivas, You can open an account in or scripbox. They guide new investors in mutual fund investment. You can also use Fundsindia to buy stocks. But I will recommend you to start with mutual funds for initial 2 years.

  47. hello mani sir, thanks a lot!!!!
    pls guide me 1. whethere we should always take balance sheet figures of standalone or consolidated ?
    2. different site shows different data e.g. p/e ratio, which should we take as reliable?
    3. is sensex p/b ratio different for different companies ?

    • Hello Amit,
      Standalone is better.
      You can take P/E ratio of economictimes in case of confusion.
      Sensex P/B will be same for all companies.

  48. Abdus Salam Biswas | May 30, 2017 at 1:27 am | Reply

    Sir, Could you please let me know the few company names those are having grade 94+? I have seen your video about the technical worksheet analysis.

  49. Anjan Sharma | May 21, 2017 at 1:40 pm | Reply

    Hi Mani,
    I am a teacher. I want to invest 5 lacs per year in stocks to grow money aggressively with high risk and high gain formula for 3 to 5 years. Can you suggest something? There are many advisors on net like ……assets etc,…….master etc. How to go about?

    • Hello Anjan, If idea is to earn high returns, for sure there will be high risk attached with it. But when we add a factor of “long term holding”, the risk factor becomes manageable.

      If you are not a pro investor, I will suggest you to invest in equity linked mutual funds. There is a website called value Research Online (VRO) which offers their services by rating top mutual funds. I will suggest you to consider picking funds from their website. CRISIL also provides ratings to mutual funds. You can use both CRISIL ratings and VRO ratings to select a great equity linked mutual fund and start investing in them. Following a SIP route will be a better option.

  50. jairam Ramesh | May 14, 2017 at 8:39 pm | Reply

    Hello Mani, I often hear the term beta when dealing with stock. Please explain me, what is beta all about. A common investor should be worried about beta? Thanks.

    • I am sure you are not interested to know the financial definition of beta. So I will try to explain beta with an example. Beta of Tata Steel is 1.32, & Beta of RIL if 0.95, what does it mean?

      Lets assume a hypothetical condition where our BSE Index (Sensex) has given a return of +8% in last financial year. In this case, Tata Steel is most likely to give a return of 10.56% per annum (8% x 1.32). Similarly, Reliance industries is most likely to give a return of 7.6% per annum (8% x 0.95).

      Lets assume another hypothetical condition where our BSE Index (Sensex) has given a return of -12% in last financial year. In this case, Tata Steel is most likely to give a return of -15.84% per annum (-12% x 1.32). Similarly, Reliance industries is most likely to give a return of -11.76% per annum (-12% x 0.95).

      A common investor must be aware of the beta value of their security. When I invest in a mutual fund, I surely look at its beta. If I am investing defensively, I would like to keep beta below 1. If I am investing aggressively I would like to see beta above 1.

Please post your comments here. It fuel us to write better...