Welcome Guest ( Log In | Register )

166 Pages < 1 2 3 4 5 > » Bottom

Outline · [ Standard ] · Linear+

 Fund Investment Corner v3, Funds101

views
     
SUSPink Spider
post Nov 28 2012, 08:40 AM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

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
*
Junior Member
6 posts

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
SUSPink Spider
post Nov 28 2012, 05:36 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

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

Look at all my stars!!
*******
Senior Member
2,203 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?



SUSPink Spider
post Nov 28 2012, 11:36 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

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!!
*******
Senior Member
8,251 posts

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.
SUSPink Spider
post Nov 30 2012, 08:29 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

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!!
*******
Senior Member
8,251 posts

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

Look at all my stars!!
*******
Senior Member
2,203 posts

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!!
*******
Senior Member
8,251 posts

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..
SUSPink Spider
post Dec 1 2012, 12:16 AM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

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!!
*******
Senior Member
8,251 posts

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..
SUSPink Spider
post Dec 1 2012, 12:28 AM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


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

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

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

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

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

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!!
*******
Senior Member
8,251 posts

Joined: Sep 2009


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


SUSPink Spider
post Dec 1 2012, 06:09 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

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!!
*******
Senior Member
8,251 posts

Joined: Sep 2009


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

Regular
******
Senior Member
1,449 posts

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

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

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.

166 Pages < 1 2 3 4 5 > » Top
 

Change to:
| Lo-Fi Version
0.0135sec    0.56    6 queries    GZIP Disabled
Time is now: 28th March 2024 - 08:03 PM