Dynamic Asset Allocation Mutual Funds: Yield Gap vs. P/E Ratio

While investing periodically for long-term goals, an investor should be aware of two factors: The power of compounding oh-hum, boring!¬† I am sure most people reading this are tired of see how a small investment grows to an unimaginably large value ‚Ķ after several decades! Volatility Most of us must invest in volatile instruments like…

Continue reading →

Sensex Total Returns Index as a Mutual Fund Benchmark

Recently I had posted an analysis of Franklin Indian Blue Chip fund (FIBCF). In response, Swapnil suggested that I compare the fund with Sensex or Nifty including dividends. In the same post, I was able to include a comparison with the Nifty total returns index, as the data is conveniently available¬† (as Swapnil pointed out)….

Continue reading →

How to select mutual fund categories suitable for your financial goals?

You might be wondering why the title refers to mutual fund ‚Äėcategories‚Äô.¬† Would it not be more enticing and perhaps more useful had it read, ‚Äėhow to select mutual funds suitable for your financial goals‚Äô? Perhaps so.¬† However, I choose to focus on how to select mutual fund categories first, for two reasons I am…

Continue reading →

Visualizing Mutual Fund Volatility Measures

Mutual fund investments are subject to market risk!¬† Haven‚Äôt we heard that one before?! If we wish to analyze the performance of a mutual fund, we should know how to evaluate returns and how to evaluate volatility. Volatility, not risk.¬†Risk pertains to your financial goal.¬† Volatility pertains to the instrument. There are many ways to…

Continue reading →

Index ETF vs. Large Cap Funds: The huge cost of ‚Äėactive‚Äô management

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…

Continue reading →

Mutual Fund Rolling Returns Calculator

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…

Continue reading →

Calculator Updates: AMFI MF NAV history downloader and MF account statement generator

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….

Continue reading →

Excel Mutual Fund NAV History Downloader

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…

Continue reading →

FD, RD, Debt Mutual Fund

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…

Continue reading →

Generating Mutual Fund SIP Account Statements and Calculating Returns With NAV History

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,…

Continue reading →