Wealth tracking: Manage your wealth with Spf wealthTrack

wealth tracking _sikasem.org

Wealth tracking and monitoring can be very useful in reviewing your financial situation and determining how successful you are at growing your wealth. By tracking and updating the performance of your investments on a regular basis, you can be able to estimate the stage or status of your financial independence. Over time, you will notice the gradual growth of your wealth. Watching the steady growth of your wealth alone can be motivating. Even if this growth is observed to be in the negative direction, it could still guide you to make the necessary corrections in your financial planning. Wealth tracking can therefore make you accountable and responsible in your investment decisions. In addition, tracking your wealth makes you take control of whatever you own. At a particular stage in life, your assets may be broadly spread out especially if you take particular attention to investment diversification. During this stage, wealth tracking remains a practical option to keep proper inventory of the numerous assets.

About Spf wealthTrack

Spf wealthTrack is a Spreadsheet template simply designed for wealth tracking. It can be used to track various asset categories and compute some metrics related to one’s wealth. Spf wealthTrack can be edited to suit the needs of different individuals. Due to the frequent ups and downs on the market (which reflects on personal investments), it may be appropriate to update the Spreadsheet less frequently, at least every month. Basically, Spf wealthTrack comprise of two main parts- assets’ columns and metrics’ columns. Data in the assets’ columns are to be manually entered by the user. The input data are then computed in the metrics’ columns to yield useful information for decision making. For easy identification and differentiation, all data that are manually entered by a user are colour-coded BLACK (with exception of liabilities which is coloured in RED). On the other hand, data that are computed by the software are colour-coded GREEN.

Spf wealthTrack is available on our downloads page. Click on this link to download.

Assets’ columns of Spf WealthTrack

The assets’ columns cover the various asset categories (and liabilities) usually owned by an investor. These are, but not limited to, fixed deposits, Treasury bills, mutual funds, stocks, bank accounts (Savings and Current), cash, and real estate. Asset could also be the value of one’s business or any venture with earning potential. Liabilities include loans, credit card debts, pending taxes, pending insurance premium payments, pending rentals to your landlord, etc. Different liabilities can be add up and entered as a whole in the liability column.

Figure 1: A snapshot displaying assets’ columns of Spf wealthTrack

As noticed from Figure 1, various asset categories are already listed. However, the names of these assets can be edited to suit the needs of the user. For example, instead of Stock 1, Stock 2, Stock 3, etc., the user may rename them as GCB stock, CAL stock, GOIL stock, etc. Similarly, a user may edit rental property 1 and rental property 2 as Kasoa land, Adenta store, etc.

What really counts as an asset can sometimes be debatable. For instance, while many consider their personal belongings such as wardrobes, electronics, etc. in their assets list, I personally don’t support this idea due to their depreciating nature. That is, the values of such possessions keep decreasing over time instead of growing. The issue of whether personal property (primary residence) can be classified as an asset or not is similarly arguable. It should be noted that primary residence or any form of personal accommodation can only generate cash when turned into rental property or sold out. If you don’t intend to sell your primary residence, why would you then list it as an asset? As you may agree, many would prefer not to sell (liquidate) their primary residence. Nevertheless, in a dire situation, one may be forced to sell his primary residence for survival. The computed total assets in Spf wealthTrack is therefore categorised into two- The first computation (TOTAL ASSETS) exclude the value of primary residence while the second computation, (ASSETS, BANKERS VIEW) adds up the value of primary residence.

Metrics’ columns of Spf WealthTrack

The metrics’ columns consist of total assets, net worth, month-on-month gain, and various portfolio percentages.

wealth tracking _sikasem.org
Figure 2: A snapshot showing metrics’ columns of Spf wealthTrack

The net worth computation in column W (see Figure 2) excludes primary residence while that of column X (bankers’ view) considers primary residence.

The month-on-month gain (or loss), as shown in column Y refers to the net worth increment between the current and the previous month. The portfolio % refers to how the net worth is distributed over the various assets categories. For example, in the snapshot above (Figure 2), real estate contributes to at least 91% of the user’s net worth.

4 DUMB financial decisions I had made in the past

dumb financial decisions

Just about three months ago, I wrote on four smart financial decisions I had made in the past. As humans, we also make mistakes in some aspects of our lives, which include finances too. In the previous post, I mentioned how useful it was to learn from other people’s mistakes. You may therefore find it worthwhile to go through the following financial mistakes I made in the past, especially if you’re of the younger generation.

  1. Closing my first mutual fund account within just 2 months of opening

dumb financial decision_nokia 2300
Over-excitement propelled me to sell my first fancy phone to fund my first investment account

In reference to the previous post about SMART financial decisions, I made it known that I opened my first investment account in my early twenties, after attending an investment seminar. In fact, over-excitement from the seminar propelled me to sell my then multi-coloured phone to fund the investment account. This was a Nokia (2300) brand phone which I had used for just five months. Due to the strong passion to begin investing, I ignored the fact that I bought the phone for far more than the price I resold it. Imagine buying a phone at GH¢150 (then ¢1,500,000) and then selling it just after five months of usage, for GH¢60 (then ¢600,000). That was exactly what I did. As you can see, this was surely not financially prudent. What made it worse was that the investment account could not last as it should have been. Selling my first fancy phone to fund my first investment account appeared to be easy. However, coping with the ‘phoneless’ life afterwards could not stand the test of time. I couldn’t even wait for three months- I promptly went back to the financial institution for the account’s closure.

Even though it was a good initiative on my side to open an investment account at an early stage, it was also dumb to close the said account just after two months of opening. By now, you may be aware of the cost implications of closing an investment account prematurely. First, the investment fund (an equity mutual fund) had made losses during the two-month period I stayed invested. Hence, the GH¢60 invested had significantly reduced in value to my disappointment. In addition, I was charged 3% of the remaining amount as early withdrawal fee (which I was not made aware of during the account opening). As if what I went through was not enough, I further topped up the retrieved money with additional fund sourced from my SSNIT (students’) loan instalment to purchase another fancy phone. This was Nokia 6610i, bought for GH¢200 (then ¢2,000,000). Imagine what GH¢200 could do if invested in 2006. Certainly, this was a clear example of opportunity cost [the profit I could have gained from investing the GH¢200 but gave up and rather chose to spend the GH¢200 on a luxury phone].

  1. Not diversifying my investment portfolio sufficiently

dumb financial decisions _diversificationBack in the olden days, I would be staying glued to the television set on Saturday evenings awaiting the NLA (National Lottery Authority) lottery draw on GTV. Just like other kids at the time, the only means to be part of the lottery game was to randomly pick 5 out of the 90 numbers to be drawn and watch if any of them would stand a chance of being drawn. Imagine staking 5 out of 90 lotto numbers. The chances of winning are definitely less as compared to staking many numbers such as 10, 20, or even 30 out of the 90 lotto numbers. Realising how difficult it was to get any of my selected numbers being drawn, I henceforth decided to go beyond five numbers. I quite remember writing down at least 10 different numbers just to increase my chances of ‘wining’ and indeed, I did ‘win’ on many occasions 🙂

I’m sure by now you’re wondering what lotto numbers has got to do with investment diversification. Now, let’s take a look at the Ghana Stock Exchange. Imagine owning stocks in just a couple of the 40 listed companies and regularly sitting close to your computer screen to monitor stock prices on the market. You would realise that your chances of having your stocks being among the gaining list are very less. The situation is different when you own stocks of several listed companies instead of few ones. That is the relationship I’m trying to draw between the lotto numbers and investment (stocks) diversification. During my early stage of investing, my investment picks were confined to few products, in particular stocks. Similar to the lottery story above, I would be staying close to the television watching the GSE updates section of business news. Unfortunately, the few companies from which I owned some stocks were outside the winning team most of the time. Besides that, my portfolio was easily subjected to avoidable shocks and turbulence effects of the stock market in times of bad economy.

See also: My bad experience with a long-term bond: The lessons learnt

  1. Not taking advantage of market falls

dumb financial decisions _market fallsAlthough history shows that stock markets always come out of crisis, we try to shy away from bad markets, either consciously or unconsciously. A number of seasoned investors advise us to take advantage of falling markets. One such key person is Warren Buffet who is noted for the statement that “the key to successful investing is to buy low, [and] sell high”. Nonetheless, the fear to lose one’s investment forces us to do otherwise. This was a similar situation I found myself in- I ignored the opportunities in fallen markets. In fact, I had witnessed the stock market fall a number of times but failed to take advantage of that.

As explained earlier, the lack of diversification exposed my investment portfolio to turbulence effects of the stock market in bad times. This effect could have been minimised or neutralised if I had purchased more of the fallen-priced stocks at the time. One means to mask stocks’ losses is to buy more of the fallen-priced stocks. In doing so, you aim to neutralise the negative effects (losses) posed on the currently owned stocks.


  1. Selling stocks at the wrong time

The lack of proper investment diversification resulted in the sale of stocks during needy circumstances. Surely, selling stocks without making any gain is not worth it. The worse part is that fees and commissions would be paid irrespective of the negative returns. Buying or selling stocks on the GSE attracts a commission of up to 2.5% of the traded amount (This, I never knew at the time though). Thus, within a short period of holding the stocks, a total commission of 5% (for both buying and selling) was paid to the stockbrokers. Even though I sold them to make ends meet, the timing was not right to make some gains. This could have been avoided if I had properly diversified my investment (by including other investment categories such as short-term products). At least, I could have waited for a while so as to make some capital gains.

   Lessons that could be learnt

Failure, they say, becomes a progress when we learn from it. Although I failed to maintain my first investment account, at least, the passion seemed to be still latent. This passion resurrected a few years later when I opened another account which is still active to date. Like the saying goes, ‘don’t let your fall turn to be your downfall’. Furthermore, limit your expenses on luxuries.

Again, don’t be a victim of poor investment diversification. With a well-diversified portfolio, you stand a greater chance of winning many times. Proper diversification is essential for the resistance of shocks on investment portfolio.

Finally, take advantage of market falls. Purchase more of good companies’ stocks when prices go down. In that way, you minimise the negative effects (losses) on currently owned stocks.