PMT Forum
Do you want to make money today? :)

### How to Invest in UITF (Unit Investment Trust Funds) - Part 2

iam · 768 · 237956

#### hipyyy

• Newbie
• Posts: 8
Hi to all.....

I don't know if this is the right forum to ask this. I'm a new member and sawakas after looking for a forum for UITF investing, I found this site na pinoy pa.

My question is how to compute earning in percentage if you have invested several times in a product over a period of time. I'm an investor of BPI-Short Term Fund since 2006 but buying units from time to time if may sobrang money. How then do I compute my earning per year in percentage since different buying prices ko?

Thanks

#### allanmm13

• Forum Champion 900
• Posts: 948

Hi to all.....

I don't know if this is the right forum to ask this. I'm a new member and sawakas after looking for a forum for UITF investing, I found this site na pinoy pa.

My question is how to compute earning in percentage if you have invested several times in a product over a period of time. I'm an investor of BPI-Short Term Fund since 2006 but buying units from time to time if may sobrang money. How then do I compute my earning per year in percentage since different buying prices ko?

Thanks

Use excel sheet to do this task. PM me so i can share yung gamit ko excel tracker. This may help you getting your funds % return

#### hipyyy

• Newbie
• Posts: 8

Use excel sheet to do this task. PM me so i can share yung gamit ko excel tracker. This may help you getting your funds % return

I can't send you a PM.... newbie pa daw ako

pls email me at hipyyy@yahoo.com

Posted on: Aug 13, 2010, 03:57 PM
Thanks a lot allanmm13 for the help
Posted on: Aug 13, 2010, 05:21 PM
Thanks a lot allanmm13
Posted on: Aug 13, 2010, 05:23 PM
allanmm13

after using the calculator you sent.... i have a 33.9% output from an investment since June 2005. Is the 33.9% yearly profit? or I need to divide 33.9 by 5 years to have an annual 6.78% earning of my investment as of this June 2010?

#### allanmm13

• Forum Champion 900
• Posts: 948

after using the calculator you sent.... i have a 33.9% output from an investment since June 2005. Is the 33.9% yearly profit? or I need to divide 33.9 by 5 years to have an annual 6.78% earning of my investment as of this June 2010?

33.9% is total (cummulative) return of all of your investments. Mahirap makuha yung annualize using the excel kasi as you mentioned you invest when you have funds and I assume this is not regular.

Ang pinakamaganda eh you compute separately yung investment mo and then compute for returns.

Ex.

2005; bought X1 NAVPu that time; X2 is current NAVPu
% = (X2-X1)/X1 to get total return (+/- %).

2008; bought Y1 NAVPu that time; Y2 is current NAVPu
% = (Y2-Y1)/Y1 to get total return (+/- %).

« Last Edit: Aug 13, 2010, 06:33 PM by allanmm13 »

#### hipyyy

• Newbie
• Posts: 8

33.9% is total (cummulative) return of all of your investments. Mahirap makuha yung annualize using the excel kasi as you mentioned you invest when you have funds and I assume this is not regular.

Ang pinakamaganda eh you compute separately yung investment mo and then compute for returns.

Ex.

2005; bought X1 units; divide that with current NAVPu to get total return (X1%).

2005; bought X2 units; divide that with current NAVPu to get total return (X2%).

allan,

i'm using the calculator for a single uitf product bough units at different time from 2005 to 2009. 33.9% is income for a single uitf product...... do i divide by 5 to get yearly?

Pero thanks for that answer also... it will give me an idea of my percentage income for my total holdings in different uitf product.

#### allanmm13

• Forum Champion 900
• Posts: 948

allan,

i'm using the calculator for a single uitf product bough units at different time from 2005 to 2009. 33.9% is income for a single uitf product...... do i divide by 5 to get yearly?

Pero thanks for that answer also... it will give me an idea of my percentage income for my total holdings in different uitf product.

To get annualized: Use this template

Annualized Return Formula

APY = (principal + gain/principal) ^ (365/days) - 1

So, for example, suppose our initial investment (ie. principal) is \$10,000, and after 2.5 years we are sitting on \$14,000. What is our annual return? Let's plug our numbers into our formula using the following values:

* principal = \$10,000
* gain = \$4,000
* days = (365 * 2.5) = 913 (rounding our half-day up)

APY = (\$14,000 / \$10,000) ^ (365 / 913) - 1 = 14%

#### mxherr5

• PMT Idol 1000
• Posts: 1,407
^

You might want to look into Excel's XIRR function.
Its specifically used for irregular investments/cash flow. It will give

Good luck

#### hipyyy

• Newbie
• Posts: 8

To get annualized: Use this template

Annualized Return Formula

APY = (principal + gain/principal) ^ (365/days) - 1

So, for example, suppose our initial investment (ie. principal) is \$10,000, and after 2.5 years we are sitting on \$14,000. What is our annual return? Let's plug our numbers into our formula using the following values:

* principal = \$10,000
* gain = \$4,000
* days = (365 * 2.5) = 913 (rounding our half-day up)

APY = (\$14,000 / \$10,000) ^ (365 / 913) - 1 = 14%

Thanks for this annualized computation
Posted on: Aug 13, 2010, 07:01 PM

^

You might want to look into Excel's XIRR function.
Its specifically used for irregular investments/cash flow. It will give

Good luck

Tried it...thanks. Do I divide the answer to number of years invested?
What's IRR?

#### mxherr5

• PMT Idol 1000
• Posts: 1,407
^

Nope, if you noticed, it takes into account the dates
of the investment so there's no need to do anything else

I think IRR is like the interest rate if you had placed your
money in the bank or that's how I understand it at least

So if you get 4% when you do an XIRR then that means
its like you had placed your money in a bank deposit with
a 4%p.a. rate(with no tax)

Hope that helps

#### hipyyy

• Newbie
• Posts: 8
Thank you very much allanmm13 and mxherr5 for helping me.

Ive been investing in UITF since 2005 but I don't have the right pictrue of my investment as I rely what my account manager presents to me. Syempre....each bank has its own way of computing para ma entice and investor. Now I have an accurate idea of my portfolio. Pero minsan not knowing the exact figure masnakabuti pa...hahahha! After 5 years....ok naman ang kita....buti na lang!

Thank You .....Thank You

#### janasan08

• Newbie
• Posts: 8
hi po newbi din po ako sa forum nato...ask ko lng po un product ng metrobnk na uitf METROFUNDSTARTER pano mgcompute kung nakita na po kc nakakailang labas at pasok po ako di po ako nakita ng malaki..gaya po ng last,,,kumita lng ako ng 6000.ipinasok ko po un ng Jan.tapos po inilabas ko ng August..bale 7 mnths.pero nun pong bagong labas un metrobnk starter na yun kumita po ako ng 25 tawsand in 3 mnths n un perang ipinasok ko 400k

#### fattybearyus

• Probie
• Posts: 10
Hi. I want to invest in UITF, I already invested in FAMI SALEF and want another UITF. Can someone get suggest somewhere I can deposit around 10-20k only?
Posted on: Oct 10, 2010, 07:47 PM
I read somewhere that you should not just rely on the most recent performance of UITFs. Then how will we know? What's a good indicator?

#### DonT

• PMT Idol 1000
• Posts: 1,477
^ Buy when its low...sell when its high.

You cannot just buy when you want to...and sell when you need to....
Well of course you can do that if you aint bothered if you lose money.
« Last Edit: Oct 11, 2010, 11:53 AM by DonT »

#### mxherr5

• PMT Idol 1000
• Posts: 1,407
^

How would you know if its low enough to buy and
high enough to sell?

Thanks

#### kyutrefinedz

• Newbie
• Posts: 1
How would you think the investors would react about the news now that BPI lowered their minimum initial investment for Peso UITFs from PHP50,000 to PHP10,000, and dollar UITFs from USD1,000 to USD500?

### PMT Shoutbox

• Niel Jhacoubs: Can someone save me?
Mar 24, 2020, 01:39 PM
• Niel Jhacoubs: I'm tired.
Mar 24, 2020, 01:39 PM
• Victorvargas: Hello sa lahat po new lang po dito. Hope na marami matutunan ako about business.
Mar 21, 2020, 09:43 PM
• Niel Jhacoubs: Yoh, its been a while.
Mar 17, 2020, 10:33 AM
• demi07: Hello everyone! New in pinoymoneytalk
Mar 14, 2020, 01:24 PM
• theappswitch: Hi!
Feb 25, 2020, 03:14 PM
• mike2020: hi po sa inyo lahat
Feb 23, 2020, 11:52 PM
• Jayjayqwe: hi po
Feb 19, 2020, 11:27 PM
• tirs d pip: hello
Feb 18, 2020, 02:32 PM
• Ace1105: Hello sa lahat...
Feb 07, 2020, 09:46 AM
• FREYAHYARA: Anyone knows where Ig shops like styledom.ph, thriftme, instashoppeavenu and the likes get their items for selling. Would like to venture in the same business but would like to know where and who the suppliers are
Jan 28, 2020, 09:38 PM
• Niel Jhacoubs: To bpc85 kung nakalagay ang inyong names sa beneficiary list ng iyong ama kay may makukuha po kayo.
Nov 28, 2019, 02:18 PM
• Niel Jhacoubs: Hellooooo, its been a while.
Nov 28, 2019, 02:16 PM
• miakashidou31: hi , meron po ba ditong nagta transfer sa paypal?
Nov 05, 2019, 01:46 PM
• whennedy: good noon po
Oct 18, 2019, 12:04 PM
• edzlpdac: goood day po sa lahat!
Oct 12, 2019, 03:37 PM
• bpc85: ask lng sana ako kung may makukuha ba kami ng Mama ko at ako or mga kapatid ko sa benepisyo ng aming Ama bilang membro ng AFPSLAI. thank you po.
Sep 27, 2019, 12:52 PM
• bpc85: Hi guys, im new here,.
Sep 27, 2019, 12:52 PM
• Anaperdi: Hi just want to know if meron dito who is into boundary hulog ng motorcycle? For mga riders ng courier. Pwede ba magpashare how it works? Naisip ko lang baka pwede ko ibusiness, meron na pala mga posts online pero di pa clear ang system sa akin. thank  you sa makakapansin
Sep 21, 2019, 11:32 AM
• Anaperdi: Hi newbie here..
Sep 21, 2019, 11:19 AM
• jprios: May contact ba kayo kung sakali?
Sep 18, 2019, 06:11 PM
• jprios: Sino pwedeng mahiraman dito?
Sep 18, 2019, 06:09 PM
• kfg52: Present!
Sep 15, 2019, 07:26 PM
• juju31: san po ba may nag papahiram dito
Sep 14, 2019, 07:18 PM
• juju31: hello
Sep 14, 2019, 07:18 PM
• FutureGizmo: Thanks julz! Medyo ganun nga trabaho namin ngayon, to monitor spam posts kasi ang daming spam bots. But thanks for reporting. Auto-ban agad ang spammers sa amin haha
Sep 07, 2019, 12:17 PM
• julz: @FutureGizmo si @nikkikv18 just posted more than 10 posts about porn sites. hay, spam.
Sep 03, 2019, 01:05 PM
• Cid_brent: sino po dyan pwede magbigay send ng paypal funds and I will pay you using gcash?
Aug 25, 2019, 08:58 PM
• Meghan91811: Sino po may alam about Rice Farming...
Aug 25, 2019, 07:44 AM
• roselove: hello po sa inyo... newbie here
Aug 06, 2019, 03:31 PM
• Niel Jhacoubs: Sino palaging active dito?
Jul 30, 2019, 04:15 PM
• dagocjasonrey: Anong update dito?
Jul 22, 2019, 08:49 PM
• mark_Lee: anong bago dito
Jun 28, 2019, 01:03 AM
• mark_Lee: balita
Jun 28, 2019, 01:03 AM
• Lovelyprincess72: hi everyone , I'm newbie here
Jun 27, 2019, 02:36 PM
• Niel Jhacoubs: Musta?
Jun 26, 2019, 01:43 PM
• Forexanalysis: Hello
Jun 25, 2019, 06:33 PM
• Niel Jhacoubs: Hello sa mga online jan!
Jun 15, 2019, 02:58 PM
• oragon:
May 20, 2019, 03:53 PM
• FutureGizmo: Thank you for reporting those spam posts, oragon! Spam posts now deleted.
May 20, 2019, 01:59 PM
• oragon: Admin kindly monitor some peps! posting and sharing inappropriate nude photos and website links
May 20, 2019, 01:52 PM
• @culinary10: Hello I am new here! Regarding sa bdo life insurance for 8 years, pwede pa kaya ma refund yung binayad ko na 50k last year? Gusto ko sana icancel kasi lack of financial na, last may 15 2018 po un nag start ako ng life insurance, pinili ko annually kaso etong may 15 2019 wala nako ma ipay so gusto ko sana icash out, may alam ba kayo kung pano marerefund?
May 17, 2019, 07:56 PM
• FutureGizmo: Hi Sonny, the posting issue is now resolved. Thanks for informing us! We're currently testing a new, mobile-ready theme so let us us know kung may problema pa sa Forum.
Apr 04, 2019, 10:40 AM
• sonny.wapak: Nakaka receive din ba kayo nito pag gawa ng new post? "Please try again. If you come back to this error screen, report the error to an administrator."
Apr 03, 2019, 10:56 PM
• leonine_zafiro: what product nun?
Apr 01, 2019, 10:25 PM
• dhondiex27: hi
Mar 30, 2019, 10:55 PM
• lusart: jayrob i agree 200%. hulog ng langit organico. legit na legit
Mar 29, 2019, 09:08 AM
• palemelch: Hi
Mar 28, 2019, 04:08 PM
• O.C.W._AK: Magandang Araw sa Lahat! Blessings! (",)
Mar 28, 2019, 08:42 AM
• thor15: hello everyone, newbie here
Mar 25, 2019, 01:47 AM