Friday, July 19, 2013

Computing Your Mutual Fund / UITF investment manually (E.g. FAMI)

For this entry, I will be using FAMI (First Metro) SALFIF (Save and Learn Fixed Income Fund) for my sample computation.

It is very easy to compute your profit/loss. Just get the number of shares you got (it should be in the receipt sent to you) and multiply it by the current NAVPS.

For FAMI, the NAVPS is listed in the FAMI Website.

Example:

Last October, 2012, you placed 5,000 Pesos in your FAMI SALFIF Account. After you got the receipt, take note of the details in the receipt and note it somewhere, like in your journal or in an excel / Google docs spreadsheet.

Amount: P5000
Number of Shares: 2771
NAVPS: 1.7683

So last October, 2012 the value of my investment was 2771 x 1.7683 = P4899.9593, it means I immediately incurred a loss of ~P100 or 2% because FAMI has a sales load of 2% (more on this in another blog entry).

Now, let's compute how much it is today. Go to FAMI website and get the NAVPS of SALFIF, which is currently 2.2073. So I multiply the number of shares 2771 by the current NAVPS 2.2073. 2771 x 2.2073 = P6116.4283. So in 9 months, my P5000 last October 2012 is now worth P6116, which is a 22% gain. (Not bad!)

Take note of the terms and conditions in your mutual fund/UITF though. For example, FAMI has an exit fee of 1.5% if you withdraw your funds within 6 months.

For convenience, I shared a sample computation sheet using Google spreadsheets. You may access it here.


Want to start investing in a mutual fund? I can help you with that, email me.


4 comments:

  1. Thank you for writing this blog Manny :)

    I will start computing my shares in a spreadsheet now.

    God Bless
    http://jingjingjourneytofrugality.blogspot.com/

    ReplyDelete
  2. The spreadsheet is just what I've been looking for!

    ReplyDelete
  3. I'm glad you find it useful. :)

    ReplyDelete
  4. This is a helpful tool when monitoring your mutual funds offline. Thanks for this.

    ReplyDelete