Welcome Guest ( Log In | Register )

140 Pages < 1 2 3 4 5 > » Bottom
Bump TopicReply to this topicRSS feed Start new topic Start Poll

Outline · [ Standard ] · Linear+

> Fund Investment Corner v3, Funds101

Pink Spider
post Nov 28 2012, 08:40 AM

Formerly known as Prince_Hamsap
********
Group: Senior Member
Posts: 16,872

Joined: Jun 2011


QUOTE(jutamind @ Nov 27 2012, 09:36 PM)
anyone still got wongmunkeong's xls file on how to calculate IRR?
*
This will help: icon_rolleyes.gif

http://office.microsoft.com/en-us/excel-he...P005209341.aspx
renomael
post Nov 28 2012, 03:12 PM

New Member
*
Group: Junior Member
Posts: 6

Joined: Oct 2008


Gurus, any comment on Hwang Select Income Fund ?

I saw their performance is quite consistent over the year. Any fund holder here ?

This post has been edited by renomael: Nov 28 2012, 03:13 PM
Pink Spider
post Nov 28 2012, 05:36 PM

Formerly known as Prince_Hamsap
********
Group: Senior Member
Posts: 16,872

Joined: Jun 2011


QUOTE(renomael @ Nov 28 2012, 03:12 PM)
Gurus, any comment on Hwang Select Income Fund ?

I saw their performance is quite consistent over the year. Any fund holder here ?
*
Invested since 2008, my IRR (after including 3% SC) = 10.6%

Very low volatility
A fund for all seasons. thumbup.gif
jutamind
post Nov 28 2012, 08:47 PM

Regular
******
Group: Senior Member
Posts: 1,519

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?



Pink Spider
post Nov 28 2012, 11:36 PM

Formerly known as Prince_Hamsap
********
Group: Senior Member
Posts: 16,872

Joined: Jun 2011


QUOTE(jutamind @ Nov 28 2012, 08:47 PM)
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?
*
Let's use an example...

01-Jan-12 invest RM500

Assuming SC of 2%, u will be getting only RM490.20 worth of units. But for the purpose of calculating IRR, I'd prefer to use CASH FLOWS, in this case I'd use RM500 instead of RM490.20. Thus, our IRR calculation would be on cash flows basis, which will be very different to the Fund Fact Sheet returns. Understand? icon_idea.gif

07-Feb-12 invest RM300
08-May-12 invest RM400
14-Sep-12 invest RM250
27-Nov-12 value: RM1,567

A B
1 01-Jan-12 -RM500
2 07-Feb-12 -RM300
3 08-May-12 -RM400
4 14-Sep-12 -RM250
5 27-Nov-12 RM1,567

=XIRR(Value Range,Date Range)
=XIRR(B1:B5,A1:A5)
=12.25%

When u invest, it's a cash OUTFLOW, thus negative value.

Just put the dates of purchase in 1 column, with the amounts in next column. Value and date of valuation on the same columns but lowest row within the range.

Got it? icon_rolleyes.gif

This post has been edited by Pink Spider: Nov 28 2012, 11:46 PM
Kaka23
post Nov 30 2012, 07:28 PM

Look at all my stars!!
*******
Group: Senior Member
Posts: 7,807

Joined: Sep 2009


QUOTE(dewVP @ Nov 28 2012, 02:32 AM)
Would you suggest Hwang Asia Quantum or Hwang Select opportunity Fund as equity fund?
*
Based on my overall portfolio, I would go for Asia Quantum as it has more out of MY exposure. Their MY exposure Is approx 40%. I got too many MY funds. Select opportunity is 60% MY focus for now.
Pink Spider
post Nov 30 2012, 08:29 PM

Formerly known as Prince_Hamsap
********
Group: Senior Member
Posts: 16,872

Joined: Jun 2011


QUOTE(Kaka23 @ Nov 30 2012, 07:28 PM)
Based on my overall portfolio, I would go for Asia Quantum as it has more out of MY exposure. Their MY exposure Is approx 40%. I got too many MY funds. Select opportunity is 60% MY focus for now.
*
If u include the cash holdings, Select Opportunity Fund can never hold >30% in offshore investments, as it is EPF-approved. As most of us should know, EPF-approved funds can invest offshore up to 30% only.

Asia Quantum is a small-mid cap equity fund, and HwangIM has proven itself as an able stock-picker.
Kaka23
post Nov 30 2012, 11:18 PM

Look at all my stars!!
*******
Group: Senior Member
Posts: 7,807

Joined: Sep 2009


Today AmDynamc bond drop around 1%! This is the worst drop I ever seen...
jutamind
post Nov 30 2012, 11:52 PM

Regular
******
Group: Senior Member
Posts: 1,519

Joined: Jul 2007
QUOTE(Kaka23 @ Nov 30 2012, 11:18 PM)
Today AmDynamc bond drop around 1%! This is the worst drop I ever seen...
*
eh...where got? i thot the NAV is 0.6253?

Kaka23
post Dec 1 2012, 12:11 AM

Look at all my stars!!
*******
Group: Senior Member
Posts: 7,807

Joined: Sep 2009


QUOTE(jutamind @ Dec 1 2012, 12:52 AM)
eh...where got? i thot the NAV is 0.6253?
*
http://www.bloomberg.com/quote/AMDYMIC:MK

Or if you have Bloomberg app for tablet, can also get it from there..
Pink Spider
post Dec 1 2012, 12:16 AM

Formerly known as Prince_Hamsap
********
Group: Senior Member
Posts: 16,872

Joined: Jun 2011


Steady lar...even if it really did dropped 1%, will u have to sell your home and pawn your car because of it? doh.gif
Kaka23
post Dec 1 2012, 12:25 AM

Look at all my stars!!
*******
Group: Senior Member
Posts: 7,807

Joined: Sep 2009


QUOTE(Pink Spider @ Dec 1 2012, 01:16 AM)
Steady lar...even if it really did dropped 1%, will u have to sell your home and pawn your car because of it? doh.gif
*
Bro.. the waiting again part for it to slowly climb up is painful ma..
Pink Spider
post Dec 1 2012, 12:28 AM

Formerly known as Prince_Hamsap
********
Group: Senior Member
Posts: 16,872

Joined: Jun 2011


Investing is for long-term...u are not trading...

What goes up must come down, and vice versa
David83
post Dec 1 2012, 04:05 PM

Witch Doctor
Group Icon
Group: Elite
Posts: 49,395

Joined: Jan 2003
From: New Tristram
Any reason why it dropped 1%? Distribution?
Pink Spider
post Dec 1 2012, 05:50 PM

Formerly known as Prince_Hamsap
********
Group: Senior Member
Posts: 16,872

Joined: Jun 2011


Looking at the historical distribution trend, unlikely to be the case.

AmDynamic Bond August 6, 2012 August 6, 2012 0.020005 Dividend Payout
AmDynamic Bond March 12, 2012 March 12, 2012 0.020009 Dividend Payout
AmDynamic Bond August 1, 2011 August 19, 2011 0.020052 Dividend Payout
AmDynamic Bond February 16, 2011 March 7, 2011 0.020031 Dividend Payout
AmDynamic Bond August 3, 2010 - 0.02 Dividend Payout
AmDynamic Bond January 12, 2010 - 0.02 Dividend Payout
AmDynamic Bond July 16, 2009 - 0.040021 Dividend Payout
AmDynamic Bond August 20, 2008 - 0.02 Dividend Payout
AmDynamic Bond February 20, 2008 - 0.02 Dividend Payout
AmDynamic Bond August 17, 2007 - 0.02 Dividend Payout
AmDynamic Bond February 22, 2007 - 0.02 Dividend Payout
AmDynamic Bond July 11, 2006 - 0.02 Dividend Payout
AmDynamic Bond February 8, 2006 - 0.02 Dividend Payout
AmDynamic Bond July 28, 2005 - 0.04 Dividend Payout


Added on December 1, 2012, 5:54 pmAmIncome Plus, a short-dated bond fund also kena, but just by 0.06%. AmIncome Plus rarely drops, there must be something happening in the bond market.

This post has been edited by Pink Spider: Dec 1 2012, 05:54 PM
Kaka23
post Dec 1 2012, 05:56 PM

Look at all my stars!!
*******
Group: Senior Member
Posts: 7,807

Joined: Sep 2009


Ya unlikely... My overall total portfolio XIRR drop 1.2% due to AmDynamic drop.


Pink Spider
post Dec 1 2012, 06:09 PM

Formerly known as Prince_Hamsap
********
Group: Senior Member
Posts: 16,872

Joined: Jun 2011


QUOTE(Kaka23 @ Dec 1 2012, 05:56 PM)
Ya unlikely... My overall total portfolio XIRR drop 1.2% due to AmDynamic drop.
*
Mine from 5% dropped to 4.67% because of that drop tongue.gif
Kaka23
post Dec 2 2012, 10:39 AM

Look at all my stars!!
*******
Group: Senior Member
Posts: 7,807

Joined: Sep 2009


Mine overall portfolio IRR is now 4.52%
holybo
post Dec 2 2012, 01:50 PM

Regular
******
Group: Senior Member
Posts: 1,448

Joined: Dec 2007
bubble burst in bond market?
Pink Spider
post Dec 2 2012, 02:41 PM

Formerly known as Prince_Hamsap
********
Group: Senior Member
Posts: 16,872

Joined: Jun 2011


Let's see how my other bond fund, OSK-UOB Income Fund fares when its 30-Nov-12 NAV is published tomorrow. Then we'll be able to see whether its the bond market or just AmInvestment's holdings.

140 Pages < 1 2 3 4 5 > » Top
Bump TopicReply to this topicTopic OptionsStart new topic
 

Switch to:
| Lo-Fi Version
0.0648sec    7.54    6 queries    GZIP Disabled
Time is now: 23rd January 2019 - 12:23 AM