Welcome Guest ( Log In | Register )

Bump Topic Topic Closed RSS Feed
128 Pages « < 13 14 15 16 17 > » Bottom

Outline · [ Standard ] · Linear+

 Public Mutual, PM/PB series fund

views
     
mr_ashraf
post Oct 8 2007, 10:09 PM

Getting Started
**
Junior Member
259 posts

Joined: Apr 2006
From: kl



hey dzi921 how do u calculate ur profit???
sorry noob question
SUSDavid83
post Oct 8 2007, 10:10 PM

20k VIP Club
*********
All Stars
52,874 posts

Joined: Jan 2003
He posted his Excel formula somewhere in this section.
mr_ashraf
post Oct 8 2007, 10:28 PM

Getting Started
**
Junior Member
259 posts

Joined: Apr 2006
From: kl



can he posted here or provide link... ohmy.gif
hehehehe

This post has been edited by mr_ashraf: Oct 8 2007, 10:28 PM
SUSDavid83
post Oct 8 2007, 10:32 PM

20k VIP Club
*********
All Stars
52,874 posts

Joined: Jan 2003
Found it out:

QUOTE
Here is my Excel code:

="Investments (Valued On "&TEXT(C4,"dd/mm/yyyy")&"):- FD ("&TEXT(F10,"#0.00%")&"), PSMALLCAP ("&TEXT(F4,"#0.00%")&"), PIOF ("&TEXT(F5,"#0.00%")&"), PRSF ("&TEXT(F6,"#0.00%")&"), PGF ("&TEXT(F7,"#0.00%")&"), PIEBF ("&TEXT(F8,"#0.00%")&"), PISBF ("&TEXT(F9,"#0.00%")&") = 100% (Net Profit = "&TEXT(I12,"#0.00%")&")"

Courtesy of dzi921

TSdzi921
post Oct 8 2007, 11:08 PM

I'm broke and poor
******
Senior Member
1,997 posts

Joined: Jul 2007
From: Kuala Lumpur


I have an excel to keep track of my investment. It is quite heavily linked and formulated to calculate the exact performance of each transaction

For a brief idea, here is the screen shots

user posted image
This is the overview

user posted image
This is the accumulated overview of this fund performance. Green means distribution. At the bottom I will know how much total investment, total units, and total returns

user posted image
This is the breakdown of the fund performance based on the purchased date. It will calculate based on month and how much the fund is supposed to perform base on the target growth %. When there is a green, the extra units should be divided equally to the funds before

Extra things I've added to my excel is that I've added a monthly compound calculator to calculate how much I need to invest monthly and how much it will get in the future base on a target growth %

Jordy
post Oct 9 2007, 09:33 AM

Entrepreneur
Group Icon
Elite
5,626 posts

Joined: Nov 2004
From: Klang, Selangor


QUOTE(dzi921 @ Oct 8 2007, 09:41 PM)
Investments (Valued On 21/09/2007):- FD (17.40%), PSMALLCAP (15.99%), PIOF (15.76%), PRSF (25.65%), PGF (23.68%), PIEBF (0.76%), PISBF (0.75%) = 100% (Net Profit = 11.25%)

Investments (Valued On 28/09/2007):- FD (16.92%), PSMALLCAP (16.13%), PIOF (15.72%), PRSF (25.86%), PGF (23.89%), PIEBF (0.74%), PISBF (0.73%) = 100% (Net Profit = 14.38%)

Investments (Valued On 05/10/2007):- FD (16.59%), PSMALLCAP (16.32%), PIOF (15.72%), PRSF (25.87%), PGF (24.06%), PIEBF (0.73%), PISBF (0.72%) = 100% (Net Profit = 16.65%)

Seem good but too bad today KLCI drops sad.gif
*
What about putting in some figures..?
% talak syok.. tongue.gif
My current paper profit is RM6k+..

Reminder for you, you forgot to cover the amount invested for your PSMALLCAP..
People will know how much you're investing from there.. wink.gif
TSdzi921
post Oct 9 2007, 09:51 AM

I'm broke and poor
******
Senior Member
1,997 posts

Joined: Jul 2007
From: Kuala Lumpur


QUOTE(Jordy @ Oct 9 2007, 09:33 AM)
What about putting in some figures..?
% talak syok.. tongue.gif
My current paper profit is RM6k+..

Reminder for you, you forgot to cover the amount invested for your PSMALLCAP..
People will know how much you're investing from there.. wink.gif
*
I know smile.gif

My net profit now is around 12k only
Jordy
post Oct 9 2007, 09:59 AM

Entrepreneur
Group Icon
Elite
5,626 posts

Joined: Nov 2004
From: Klang, Selangor


QUOTE(dzi921 @ Oct 9 2007, 09:51 AM)
I know smile.gif

My net profit now is around 12k only
*
Mind if I ask, this 12k was cumulative realised profit or paper profit..?
How long it took you to gain this much..?
TSdzi921
post Oct 9 2007, 10:45 AM

I'm broke and poor
******
Senior Member
1,997 posts

Joined: Jul 2007
From: Kuala Lumpur


QUOTE(Jordy @ Oct 9 2007, 09:59 AM)
Mind if I ask, this 12k was cumulative realised profit or paper profit..?
How long it took you to gain this much..?
*
The 12k is net profit if I were to sell off all my funds based on last fri's result

I started investing since mid last year but mainly bond funds. I switched all bonds and topup into equity funds on August correction low. Consider quite fast return for me

I'm aiming 20 to 25 percent net profit. Once hit will switch all equity to bond. If my fund can touch 30 percent then my overall portfolio will touch 100k liao, but doubt I got guts to wait till so high la
leekk8
post Oct 9 2007, 10:47 AM

Regular
******
Senior Member
1,059 posts

Joined: Mar 2006
From: KL


You all really quite good in portfolio management and monitoring. I can see some of you really have a huge amount of investment smile.gif Profit also can reach 12k...my investment capital not even half of 12k smile.gif
Jordy
post Oct 9 2007, 01:23 PM

Entrepreneur
Group Icon
Elite
5,626 posts

Joined: Nov 2004
From: Klang, Selangor


QUOTE(dzi921 @ Oct 9 2007, 10:45 AM)
The 12k is net profit if I were to sell off all my funds based on last fri's result

I started investing since mid last year but mainly bond funds. I switched all bonds and topup into equity funds on August correction low. Consider quite fast return for me

I'm aiming 20 to 25 percent net profit. Once hit will switch all equity to bond. If my fund can touch 30 percent then my overall portfolio will touch 100k liao, but doubt I got guts to wait till so high la
*
Once you achieve your target, have you got any plans for it..?
You invested less than me and at around the same time as me, but my profit is still only half of yours.. rclxub.gif
I went in on Aug 21, I guess you got them at around Aug 17..?
Then your profit is wonderful.. icon_rolleyes.gif

QUOTE(leekk8 @ Oct 9 2007, 10:47 AM)
You all really quite good in portfolio management and monitoring. I can see some of you really have a huge amount of investment smile.gif Profit also can reach 12k...my investment capital not even half of 12k smile.gif
*
I invest a bit to try try only.. tongue.gif
Don't know wanna go full force or not..
Still considering.. rclxub.gif
justin_nys
post Oct 9 2007, 01:53 PM

Regular
******
Senior Member
1,192 posts

Joined: Jan 2003
From: Bandar Utama


Hey dzi921, Nice excel chart and formula.. I need to start to construct one to organize better. Thanks for sharing.

and not to forget..nice Portfolio! haha
TSdzi921
post Oct 9 2007, 02:24 PM

I'm broke and poor
******
Senior Member
1,997 posts

Joined: Jul 2007
From: Kuala Lumpur


QUOTE(Jordy @ Oct 9 2007, 01:23 PM)
Once you achieve your target, have you got any plans for it..?
You invested less than me and at around the same time as me, but my profit is still only half of yours.. rclxub.gif
I went in on Aug 21, I guess you got them at around Aug 17..?
Then your profit is wonderful.. icon_rolleyes.gif
*
Yes, I was lucky to made my first sai lang on 17/08

When I achieved my target I will switch to Bond and wait for next correction. I have no plans to use my money there. This part of portfolio is meant for very long term investment. Retirement plan

After I achieved the Gold Mutual status by next year, I'll move into another type of investment. Most likely Stocks (Blue chips)

QUOTE(justin_nys @ Oct 9 2007, 01:53 PM)
Hey dzi921, Nice excel chart and formula.. I need to start to construct one to organize better. Thanks for sharing.

and not to forget..nice Portfolio!  haha
*
No problemo smile.gif
Jordy
post Oct 9 2007, 02:30 PM

Entrepreneur
Group Icon
Elite
5,626 posts

Joined: Nov 2004
From: Klang, Selangor


QUOTE(dzi921 @ Oct 9 2007, 02:24 PM)
Yes, I was lucky to made my first sai lang on 17/08

When I achieved my target I will switch to Bond and wait for next correction. I have no plans to use my money there. This part of portfolio is meant for very long term investment. Retirement plan

After I achieved the Gold Mutual status by next year, I'll move into another type of investment. Most likely Stocks (Blue chips)
*
Too bad my money hasn't came on Aug 17, else I could be getting almost 20k profit.. wink.gif
TSdzi921
post Oct 9 2007, 02:39 PM

I'm broke and poor
******
Senior Member
1,997 posts

Joined: Jul 2007
From: Kuala Lumpur


QUOTE(Jordy @ Oct 9 2007, 02:30 PM)
Too bad my money hasn't came on Aug 17, else I could be getting almost 20k profit.. wink.gif
*
Hope you don't mind me asking, last I remember you owed a debt on a previous failed business right?

So settle already? If not yet, then How do you plan to settle?
Jordy
post Oct 9 2007, 02:55 PM

Entrepreneur
Group Icon
Elite
5,626 posts

Joined: Nov 2004
From: Klang, Selangor


QUOTE(dzi921 @ Oct 9 2007, 02:39 PM)
Hope you don't mind me asking, last I remember you owed a debt on a previous failed business right?

So settle already? If not yet, then How do you plan to settle?
*
I have only settled part of it, ie RM6k..
I'm hoping to get more profit from UT to settle another part of it..
In 1-2 months time, I'll set up another 1 or 2 business(es) to slowly repay the debt..
I'm waiting to sit the FMUTM exam on 27th of this month, then I'll be a UT agent..
In the meantime, I'm securing as many investors as possible..
I have secured half a million worth of investment, so I hope to get my licence as soon as possible..
Then I can repay a big chunk of the debt..
That's my plan for now.. smile.gif
TSdzi921
post Oct 9 2007, 05:39 PM

I'm broke and poor
******
Senior Member
1,997 posts

Joined: Jul 2007
From: Kuala Lumpur


user posted image

user posted image

user posted image

KLCI
All Time & Current High: 24/07/2007 1392.18
Correction Low : 17/08/2007 1191.55
TSdzi921
post Oct 9 2007, 05:39 PM

I'm broke and poor
******
Senior Member
1,997 posts

Joined: Jul 2007
From: Kuala Lumpur


QUOTE(Jordy @ Oct 9 2007, 02:55 PM)
I have only settled part of it, ie RM6k..
I'm hoping to get more profit from UT to settle another part of it..
In 1-2 months time, I'll set up another 1 or 2 business(es) to slowly repay the debt..
I'm waiting to sit the FMUTM exam on 27th of this month, then I'll be a UT agent..
In the meantime, I'm securing as many investors as possible..
I have secured half a million worth of investment, so I hope to get my licence as soon as possible..
Then I can repay a big chunk of the debt..
That's my plan for now.. smile.gif
*
How much is your interest on the debt?
Jordy
post Oct 9 2007, 07:49 PM

Entrepreneur
Group Icon
Elite
5,626 posts

Joined: Nov 2004
From: Klang, Selangor


QUOTE(dzi921 @ Oct 9 2007, 05:39 PM)
How much is your interest on the debt?
*
Oh, interest free la..
I was lucky I could get to borrow some money from friends..
But we need to repay them as soon as possible too right..?
We need to be responsible, so I still need the money fast.. smile.gif
TSdzi921
post Oct 9 2007, 08:10 PM

I'm broke and poor
******
Senior Member
1,997 posts

Joined: Jul 2007
From: Kuala Lumpur


QUOTE(Jordy @ Oct 9 2007, 07:49 PM)
Oh, interest free la..
I was lucky I could get to borrow some money from friends..
But we need to repay them as soon as possible too right..?
We need to be responsible, so I still need the money fast.. smile.gif
*
True smile.gif Must return else people will not trust you liao

But you really have good rich friends. Can borrow you so much money

128 Pages « < 13 14 15 16 17 > » Top
Topic ClosedOptions
 

Change to:
| Lo-Fi Version
0.0274sec    0.28    6 queries    GZIP Disabled
Time is now: 8th December 2025 - 07:20 PM