How to Use Excel to Choose the Right Fund for Your Insurance Policies


June 1st, 2009 by admin admin

When was the last time you reviewed your investment-linked policy? For me, it was about two to three years back. I was disappointed at the review because I discovered that the investment tied to my insurance policy was making losses. I took a bet and switched to a fund based on pure gut feel. There was no detailed analysis on all the funds to make sure that the fund I have chosen was the best option.

The market indices (e.g Straits Times Index) tell you whether the funds are performing better or worse than the previous indices and do not offer any insight or analysis to decide whether it is worthwhile to hold on to the unit trust or switch to another.

It was an uphill task to review the funds’ performance again this year. Every unit trust has its own set of numbers and flipping through the annual report to make comparison across all the funds was a pain and highly confusing. After making comparison across the unit trusts on the income earned, I moved on to review the funds valuation. In the midst of reviewing, I decided to refer back to my income analysis. Guess what? I have lost track of the analysis done earlier. It was very frustrating and I almost gave up until an Excel-lent idea struck me. Why not make the comparison with Excel?

Putting them on tables was a great way to compare the performance across funds. I could scroll left and right to find out the funds ranking. However, moving from one end of the table to another became a strain after some time. In the end, I decided to develop a one pageĀ dashboard …

Leave a Reply

You must be logged in to post a comment.

s2Member®