Excel Home Loan Amortization Schedule Template

Use this Excel-based template for creating an amortization schedule for your home loan. It allows you to visualize the monthly and yearly evolution of interest and principle components and the balance of the loan. It can accommodate regular (monthly, quarterly, bi-annual and annual) and irregular (random months) pre-payment schedules. It can also handle a loan…

Continue reading →

Notes on Financial Fortification

Life insurance, health insurance, accident insurance and critical illness insurance  are tailor-made fortification products that help a family tackle unpleasant and unexpected developments. Be it expenses due to hospitalization, or loss or decrease  in income due to death, accident or a critical illness.  I refer to them as fortification products because they protect the families…

Continue reading →

Backtesting a three stock portfolio: L&T, ITC, Axis Bank

R. Balakrishnan is a person of great renown in the banking and financial services space.  He helped set up CRISIL and  the Malaysian credit bureau, was head of equity research at DSP Merrill Lynch, executive vice president of Edelweiss,  to name just a few. He is now an organic farmer, writes a blog and has a column at MoneyLife….

Continue reading →

Herd Instinct: ICICI Pru Focused Blue Chip vs. ICICI Pru Top 100

In this post, let us compare two large cap funds from the  same fund house. One a consistent performer with a terrific track record and the other a young superstar. The results will hopefully show how herd instincts among investors (and perhaps amcs  and therefore(?) intermediaries too?) can obscure good funds from the same fund house….

Continue reading →

Part II: Here is why you should ignore mutual fund star ratings

In the first part on why you should ignore mutual fund star ratings, I had stressed on the importance of focusing on our portfolio health and performance of the fund with its benchmarks. In this post I would like to add a couple more reasons to strengthen the argument. Let us assume that an investor named Tom has chosen…

Continue reading →

Here is why you should ignore mutual fund star ratings

‘Should I choose only five star rated mutual funds?’, ‘Should I switch funds each time my funds rating is downgraded?’. These are extremely common questions among mutual fund investors.  In this post, let us discuss how star fund ratings are irrelevant to the goal-based investor. Any action, buy, sell, hold, switch etc. should be based on…

Continue reading →