anyone still got wongmunkeong's xls file on how to calculate IRR?
Fund Investment Corner v3, Funds101
Fund Investment Corner v3, Funds101
|
|
Nov 27 2012, 09:36 PM
Return to original view | Post
#1
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
2,429 posts Joined: Jul 2007 |
anyone still got wongmunkeong's xls file on how to calculate IRR?
|
|
|
|
|
|
Nov 28 2012, 08:47 PM
Return to original view | Post
#2
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
2,429 posts Joined: Jul 2007 |
QUOTE(Pink Spider @ Nov 28 2012, 08:40 AM) Hi Pink Spider,I've seen this article before i post the query. Not too sure how to calc XIRR in terms of unit trust investment. Let's say i have RSP of RM1000 every month. At the end of the year, the value of my unit trust is 15,000. So how do i calculate XIRR? |
|
|
Nov 30 2012, 11:52 PM
Return to original view | Post
#3
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
2,429 posts Joined: Jul 2007 |
|
|
|
Feb 11 2014, 02:10 PM
Return to original view | Post
#4
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
2,429 posts Joined: Jul 2007 |
Who knows FTIM might be on FSM platform soon
|
|
|
Aug 8 2021, 08:18 PM
Return to original view | Post
#5
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
2,429 posts Joined: Jul 2007 |
aurora97 how do you buy HLVF? What's the sales charge?
QUOTE(aurora97 @ Aug 8 2021, 05:09 PM) Helo everyone, would like to know your thoughts and strategy on my current portfolio. Portfolio currently limited to AffinHwang and Hong Leong, will add on Principal in the future. AffinHwang Fund - allocated - return SAQF - 30% - 9.35% SAPDF - 20% - 5.70% SIF - 40% - 3.74% SIPG - 5% - 5.65% SIPI - 5% - 5.66% GLBF (MYR-H) - less than 1% -5.49% 1TF - less than 1% - 3.24% PRS Growth -100% - 58.74% (abt 7% p.a.) SIPG & SIPI are mainly for long term savings. SIF is as a safe harbour to collect gains and DCA for other funds. Hong Leong Fund - allocated - return HLVF - 100% - 1% Missed the boat on China and Tech story but a bit apprehensive on themed based funds. It's like a one trick pony. Ideally, the idea was to profit take from funds such as SAQF, SAPDF and 1TF then park it in SIF and then go out and whack some more when the NAV of the funds drop. The target for SAQF and 1TF are 10%, whereas for SAPDF is 8%. SAQF is quite interesting, as I observed throughout the portfolio building process, it's hit -3% and jumps as high as 12%, within a span of a few months. There are opportunities to cash in the peaks and come back in when valleys appear. HLVF still observing. The target is 10% as well. Is profit taking the way or just invest conservatively as observe with PRS Growth, which gives a somewhat decent return of 7% p.a over a period of 8 years. What you guys think? |
|
|
Aug 8 2021, 09:07 PM
Return to original view | Post
#6
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
2,429 posts Joined: Jul 2007 |
|
| Change to: | 0.0297sec
0.55
7 queries
GZIP Disabled
Time is now: 11th December 2025 - 09:07 PM |