hey dzi921 how do u calculate ur profit???
sorry noob question
Public Mutual, PM/PB series fund
Public Mutual, PM/PB series fund
|
|
Oct 8 2007, 10:09 PM
|
![]() ![]()
Junior Member
259 posts Joined: Apr 2006 From: kl |
hey dzi921 how do u calculate ur profit???
sorry noob question |
|
|
|
|
|
Oct 8 2007, 10:10 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]()
All Stars
52,874 posts Joined: Jan 2003 |
He posted his Excel formula somewhere in this section.
|
|
|
Oct 8 2007, 10:28 PM
|
![]() ![]()
Junior Member
259 posts Joined: Apr 2006 From: kl |
can he posted here or provide link...
hehehehe This post has been edited by mr_ashraf: Oct 8 2007, 10:28 PM |
|
|
Oct 8 2007, 10:32 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]()
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 |
|
|
Oct 8 2007, 11:08 PM
|
![]() ![]() ![]() ![]() ![]() ![]()
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 ![]() This is the overview ![]() 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 ![]() 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 % |
|
|
Oct 9 2007, 09:33 AM
|
|
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%) What about putting in some figures..?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 % talak syok.. 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.. |
|
|
|
|
|
Oct 9 2007, 09:51 AM
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,997 posts Joined: Jul 2007 From: Kuala Lumpur |
|
|
|
Oct 9 2007, 09:59 AM
|
|
Elite
5,626 posts Joined: Nov 2004 From: Klang, Selangor |
|
|
|
Oct 9 2007, 10:45 AM
|
![]() ![]() ![]() ![]() ![]() ![]()
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..? The 12k is net profit if I were to sell off all my funds based on last fri's resultHow long it took you to gain this much..? 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 |
|
|
Oct 9 2007, 10:47 AM
|
![]() ![]() ![]() ![]() ![]() ![]()
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
|
|
|
Oct 9 2007, 01:23 PM
|
|
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 Once you achieve your target, have you got any plans for it..?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 You invested less than me and at around the same time as me, but my profit is still only half of yours.. I went in on Aug 21, I guess you got them at around Aug 17..? Then your profit is wonderful.. 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 I invest a bit to try try only.. Don't know wanna go full force or not.. Still considering.. |
|
|
Oct 9 2007, 01:53 PM
|
![]() ![]() ![]() ![]() ![]() ![]()
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 |
|
|
Oct 9 2007, 02:24 PM
|
![]() ![]() ![]() ![]() ![]() ![]()
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..? Yes, I was lucky to made my first sai lang on 17/08You invested less than me and at around the same time as me, but my profit is still only half of yours.. I went in on Aug 21, I guess you got them at around Aug 17..? Then your profit is wonderful.. 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. No problemo and not to forget..nice Portfolio! haha |
|
|
|
|
|
Oct 9 2007, 02:30 PM
|
|
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 Too bad my money hasn't came on Aug 17, else I could be getting almost 20k profit.. 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) |
|
|
Oct 9 2007, 02:39 PM
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,997 posts Joined: Jul 2007 From: Kuala Lumpur |
|
|
|
Oct 9 2007, 02:55 PM
|
|
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? I have only settled part of it, ie RM6k..So settle already? If not yet, then How do you plan to settle? 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.. |
|
|
Oct 9 2007, 05:39 PM
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,997 posts Joined: Jul 2007 From: Kuala Lumpur |
![]() ![]() ![]() KLCI All Time & Current High: 24/07/2007 1392.18 Correction Low : 17/08/2007 1191.55 |
|
|
Oct 9 2007, 05:39 PM
|
![]() ![]() ![]() ![]() ![]() ![]()
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.. How much is your interest on the debt?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.. |
|
|
Oct 9 2007, 07:49 PM
|
|
Elite
5,626 posts Joined: Nov 2004 From: Klang, Selangor |
|
|
|
Oct 9 2007, 08:10 PM
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,997 posts Joined: Jul 2007 From: Kuala Lumpur |
QUOTE(Jordy @ Oct 9 2007, 07:49 PM) Oh, interest free la.. True 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.. But you really have good rich friends. Can borrow you so much money |
|
Topic ClosedOptions
|
| Change to: | 0.0274sec
0.28
6 queries
GZIP Disabled
Time is now: 8th December 2025 - 07:20 PM |