Stock Analysis Spreadsheet with Moneycontrol Financials

Dear reader, I write this to make two requests: (a) help beta test an Excel sheet that automatically downloads standalone or consolidated financials data (in new format or old) from MoneyControl, and (b) provide your feedback on how to improve the freefincal stock analysis spreadsheet. MoneyControl Financials Downloader The aim behind making this sheet is…

Continue reading →

Understanding Mutual Fund Investment Risk vs Reward

Although it has limited technical utility, the standard deviation is probably the simplest measure of understanding investment risk. Therefore, it has great practical value when it comes to ‘product positioning’ as the fund industry calls it. ‘Where does a given fund fall in the risk vs reward map?’. AMC often given a product positioning risk vs…

Continue reading →

How & when to choose Equity Savings Funds & Arbitrage Funds

Equity savings funds are the latest type of asset allocation mutual funds introduced first in late 2014 when the government made the duration for debt mutual fund capital gains to be classified as ‘long-term’ from 1-year to 3-years. Equity savings funds are basically arbitrage+equity+ debt  funds. They would hold a minimum of 65% equity (most…

Continue reading →

Review Your Financial Freedom Portfolio in Seven Easy Steps

All long-term financial goals require periodic review to ensure that they are on track and in line with expectations and assumptions made while planning for the goal. Here are seven easy steps to review the health of your financial freedom or retirement portfolio. First posted on Mar 25 2014, now republished with updates. Retirement is…

Continue reading →

Financial Freedom Calculator version 2: When can I retire?

Use this financial freedom calculator spreadsheet to answer questions like, “When can I retire?” and “When should I retire?” and hopefully understand the difference between them with minimal inputs. For a given age and life expectancy, along with other standard investment and inflation details, the years to retirement is calculated by determining when the monthly income…

Continue reading →

Are fixed income investors financially illiterate?

Any keen follower of personal finance space would have encountered their fair share of ‘why you should invest in equity?’ articles and ‘why equity alone is capable of beating inflation over the long-term’ arguments.  Things have come to such an end that fixed income investors are considered as not being financial literate. This kind of…

Continue reading →

Features of the freefincal mutual fund and financial goal tracker

A little over two years ago, an automated mutual fund & financial goal tracker was released. It was made with extensive beta testing by readers and is reasonably popular despite the availability of user-friendly online trackers. Update: This file does not work anymore since the historical NAV download from AMFI has been discontinued. I am working on a…

Continue reading →

Latest Sukanya Samriddhi Account Rules

The withdrawal rules of the Sukanya Samriddhi Account has been modified with effect from March 18th  2016. Thanks to Muthu Krishnan for alerting me about it. They are discussed in this post in case you missed them like I did. Old withdrawal rule: (Source: Gazette of India 2nd December 2014) To meet the financial requirements of the account holder…

Continue reading →

Mutual Fund SIP and Lump Sum Rolling Returns Calculators

This is a triple update announcement – to two rolling returns calculators and to the Google spreadsheet for tracking financial independence. First two updates: The mutual fund lump sum and SIP rolling returns calculators have been updated with additional benchmarks. Rolling returns calculators provide a simple, easy to understand visual representation of how consistently a…

Continue reading →