How different is a large cap equity mutual fund from an exchange-traded fund (ETF) that tracks an equity index?  The portfolio of an index ETF is likely to be nearly identical to that of the index at any point of time. Typically the portfolio of all large cap mutual funds will have a good amount of…

Use this automated mutual fund rolling returns calculator to evaluate the consistency in performance of a mutual fund over any interval from April 3rd 2006 onward. You can compare results with benchmarks like Sensex, CNX Nifty, CNX Small-cap, and CNX Mid-Cap. This version is a major improvement over the previous Excel Rolling Returns Calculator.  The analysis…

Use this tool to analyze the returns from monthly SIP investments in mutual funds for investment periods ranging from one to seven years.  For comparison, SIP returns of an equity index (choose among Sensex, Nifty, CNX small cap and CNX mid cap) is also calculated. Features  Choose the mutual fund you need to analyze, click…

In the last couple of days AMFI has changed it web address! From www.AMFI.com,  it is now http://portal.amfiindia.com Therefore, I had to make this change in the mutual fund NAV history downloader. Also, while working on a mutual fund SIP returns analyzer, I noticed minor bugs in the mutual fund account statement generator and returns calculator….

This is an update to the Excel Mutual Fund NAV History Downloader posted a few days ago. I have now included the possibility of retrieving NAV history from the AMFI website in addition to Yahoo! Finance. Can retrieve NAV history of all mutual funds from AMFI up to April 3rd 2006 If you need NAV history from…

Unfortunately, Value Research Online changed their website format shortly after this tool was released. I often wonder if they did that because of this tool! So this tool does not work anymore. I only keep this post for sentimental reasons. If you wish you to analyse your mutual funds try these: Mutual Fund Rolling Returns…

Use this tool to download mutual fund NAV history from Yahoo! Finance. Features Get full historical NAV from inception – not possible with the painful to use AMFI site. Fast download! Select frequency: daily/weekly/monthly Sort ascending or descending For dividend mutual funds obtain dividend history alone Suitable for Indian Mutual Funds only. Uses of Mutual…

Here is a list of calculators and resources related to fixed deposit (FD), recurring deposit (RD) and debt mutual funds. 1. Fixed Deposit and Recurring Deposit Calculators FD-Maturity value Comprehensive Fixed Deposit Calculator – I: Total and Advance Tax Liability Comprehensive Fixed Deposit Calculator – II: The Income Clubbing Headache  Variable RD Calculator Comprehensive Recurring…

Use this excel tool to generate an account statement and calculate returns for your mutual fund SIP investments using NAV history. First, a few thoughts about calculating SIP returns. There are many ways to calculate returns from a SIP investment using Excel. Many prefer to use a function known as XIRR to estimate returns. Yes,…

Analyzing the performance of a mutual fund is not rocket science.  Anybody can do it, just as anybody can select a mutual fund following a few simple rules. I would like to prove my point with a do it yourself mutual fund analysis using HDFC Top 200 fund – one of the most popular mutual funds in…

XLMFTrackerAG, an Excel based mutual fund portfolio tracker, is another excellent offering by Satish Mistry, financial planner at MoneyCare Financial Planning. Satish recently developed a comprehensive financial planning tool. XLMFTrackerAG is suitable for individual investors, financial planners and independent financial advisors to manage a mutual fund portfolio. Financial planners can easily process the portfolios of clients…

Use this Excel based rolling returns calculator to evaluate the consistency in performance of your mutual funds and stocks by comparing them with their benchmark indices. Returns for a financial instrument that fluctuate can be calculated in two ways: Point-to-point returns: The effective annual compounded growth rate (CAGR) is calculated between any two dates. You…

It is now seven months since direct mutual fund plan were introduced. Using NAV history of HDFC Top 200, I have calculated the actual difference in returns between the regular-plan and direct-plan (growth option) obtained so far (Excel sheet attached). Let use recall that regular funds will have a higher expense ratio than direct funds. …

Warren Buffet, in a letter to his shareholders said, ‘do not ask a barber if you need a haircut’. This applies to many situations in life. In the present context, ‘never ask someone in the financial advisory business, if mutual fund selection is hard’. Selecting a mutual fund is not rocket science. It can be…