Automated Stock Analysis with MoneyControl Financials

Use this Excel sheet to automatically download stock financial data from Moneycontrol for analysis. This sheet was prepared many months ago, but I did not come around to complete it. Regular readers may be aware that automated stock analyzers using screener.in and morningstar.in are available with multiple valuation methods. In the current edition, I have not…

Continue reading →

What is the guarantee that MF will always give positive returns and beat inflation 10 years or above?

Each week I try and answer generic questions from readers. Here is this weeks edition. If you have a question, you can use the form below and I will address it next week (if I can). Abhi: Hello Mr. Pattabhiraman, Trust you are doing good! In the first chapter of your book “You can be rich…

Continue reading →

Long Term Capital Gains Computation with base year 2001

Budget 2017 has proposed a slew of benefits related to long-term capital gains. The most important is the shift of the base year to be used for long-term capital gains computation for all asset classes. Here is a summary and illustration of long-term capital gains computation with base year 2001. 1: Change in duration for computation…

Continue reading →

Budget 2017: Calculate Revised Return from Your Rental Income

The rent received from a house property is treated as income and taxed as per slab. However, certain deductions are eligible for this taxable amount. Budget 2017  had restricted the amount of deduction one can claim. Here is an illustration and a revised real estate returns calculator. The taxable income is given by:  rent –…

Continue reading →

Fat Tails: The True Nature of Stock Market Returns – Part 1

In a two-part post, I discuss the nature of stocks market returns, first by pointing out the influence of extreme market events and then by considering their fractal or self-similar nature. Readers may recall that last week, we considered self-similarity in wealth distribution where I had mentioned their universal nature. Both posts in this series shall deal with…

Continue reading →

Be Aware: ELSS Mutual Funds Are Just as Risky/Rewarding as Other Funds

In the last quarter of the financial year, we are likely to encounter advertisements and sales pitches for how ELSS mutual funds are better than other tax saving instruments. A common sales pitch is that ELSS mutual fund investments are locked for three years and hence the fund manager can deploy funds without worrying about redemption…

Continue reading →