Track The Performance Of Your Mutual Fund investments Month By Month

Use this Excel sheet to track and compare the annualized return (XIRR) of your mutual fund investments with that of a benchmark. This is the updated version of the Mutual Fund SIP XIRR Tracker thanks to Krishna Chaitanya who pointed out an error in the sheet. The Nifty strategic indices have also be updated up to April 10th 2017. The sheet…

Continue reading →

Stock Market Overheated? Worry About What is Invested and Not When to Invest!

Concerned that the stock market is overheated? Here is why it makes sense to focus on the risk associated with the money already invested and not worry about investing more. Suppose, I have a long-term goal and I can only spare Rs. 500 towards an equity SIP. I choose a nondescript mid-cap mutual fund and start…

Continue reading →

Total Return Benchmark Indices Are Welcome, But There Are Bigger Issues To Solve

There were reports yesterday regarding SEBI thinking about asking fund houses to use benchmark indices where the dividends are assumed to be reinvested. Such total return benchmark indices (TRI) offer anywhere between 1-2% higher return each year over the normally used price indices (for large cap stocks) which do not consider dividends. While this is…

Continue reading →

Moneycontrol Stock Price History Update for Stock Analysis Spreadsheets

Freefincal has two automated stock analysis and valuation spreadsheets. One that obtains financial data from screener.in and another which obtains financials from morningstar. Both sheets also get stock price data from moneycontrol. This is an important update to both these modules due to a change in moneycontrol web layout. Thanks to swanand  pointing this out. Before…

Continue reading →

Should I Invest A Lump Sum In One Shot Or Systematically via STP

The systematic transfer plan (STP) is a way for an asset management company to lock into some “business”, just as jewel shop does with a “gold scheme”. It can be used to withdraw from one mutual fund to either generate regular income or transfer that money to another fund (typically equity) in the name of “reducing risk”…

Continue reading →

Mutual Fund Star Ratings are Flawed, but Investors are to blame for taking them at face value

Why blame Value Research For awarding Taurus Liquid Fund that is in trouble for continuing to buy a near-junk bond (Ballarpur Industries), five stars (four stars when commissions are removed)? That is like blaming someone because they could not predict a market crash! Before we go any further, it is important to recognise that many…

Continue reading →