Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 Fund Investment Corner v3, Funds101

views
     
mmweric
post Jan 20 2020, 07:53 PM

Getting Started
**
Junior Member
156 posts

Joined: Jan 2020
QUOTE(Gravity @ Jan 10 2020, 04:46 PM)
I'd say 2nd one is better due to better R&R ratio.  hmm.gif
*
Can you educate me on how you get your numbers for your CAGR and IRR? I am just a bit curious.
mmweric
post Jan 24 2020, 04:22 PM

Getting Started
**
Junior Member
156 posts

Joined: Jan 2020
QUOTE(keanoppy @ Jan 22 2020, 08:24 PM)
Hi, need advice from Sifus.

ASB1,2,3 these days give around 5-6% dividend. And after deducting zakat, that gives me around 2.5-3.5% p.a.

My housing loan left around 380k, 30 years at 4.3%.
Should I just pay off? Or refinance? But then again, nothing low risk will generate me above 4.3+2.5%.
*
Normally it makes sense to pay off your debts in the following order from highest interest to lowest interest

1. Credit Card/Personal Loan
2. Car Loan
3. Housing Loan

I am not familiar with how zakat works just now researching it sounds complicated but if you. If you have to continue paying the same zakat amount even if you pay off your housing loan doesn't sound worth it. If your effective return is 2.5-3.5% and your loan has a higher interest guess it would be better to pay off your loans.


Whether it is worth it to refinance you really need to work out the figures whether it is cheaper.

Just make sure you have 6 months of living expenses first before you pay off your loan as money in ASB is liquid money in your loan is only liquid if you have a Flexi loan.

This is just my opinion you either need to look at the actual numbers yourself or get someone to look for you to get a proper recommendation.



mmweric
post Feb 28 2020, 12:40 AM

Getting Started
**
Junior Member
156 posts

Joined: Jan 2020
QUOTE(Yggdrasil @ Feb 27 2020, 11:51 PM)
That person used website to calculate.

CAGR formula = (Investment value/Total deposit)^(1/no. of years)

IRR is harder to calculate because you need the timing of cash flows to be accurate.
Generally, IRR is the discount rate which gives an NPV of 0.
*
If there was a single lump sum investment two years ago the CAGR and the IRR should be the same.

Since it is different there must have been multiple inflows and outflows of cashflow.

Hence it would not be possible to calculate CAGR and you would need to calculate the money-weighted return which is equivalent to the IRR.

So what I am trying to figure out as the IRR and CAGR is not the same, how did he manage to calculate CAGR or if there was only 1 lump sum
investment why is CAGR and IRR not the same

If you also look at the Sharpe ratio

which is Sharpe Ratio = (Return - Risk Free Rate) / Standard Deviation

I would assume he is using the IRR to calculate the Sharpe Ratio as the number would roughly be correct if he used IRR and not CAGR. So I am wondering
where the CAGR came from.

The numbers from the Sharpe ratio are also inconsistent. I calculated for
a. portfolio 1 the Risk Free Rate = 2.1801
b. portfolio 2 the Risk Free Rate = 1.7716

The only way the two portfolios can have a different risk free rate is if the time periods are different in which case you can't compare both the portfolioos.
If the numbers don't tally I don't think it is possible to give a reasonable opinion till it is confirmed whether to use CAGR or IRR and
to confirm what is the standardized risk free rate base on the same time period to calcualte the relavant Sharpe and Sortino ratios..

For example if I used a risk free rate of 2%. Portfolio 1 would have a higher sharpe ratio (1.13) then portfolio 2 (1.09) but in the above example
portfolio 2 (1.12) has a higher sharpe ratio then portfolio 1 (1.11).

Not sure whether my understanding of the concepts or calculations are correct so please correct me if I am wrong.






mmweric
post Feb 28 2020, 12:05 PM

Getting Started
**
Junior Member
156 posts

Joined: Jan 2020
QUOTE(Yggdrasil @ Feb 28 2020, 09:21 AM)
I think it's still possible to calculate CAGR.

For example, Portfolio Visualiser was able to calculate it.

user posted image
I'm not 100% sure which website that person used to calculate but I tried using this website and still got conflicting risk free rates  blink.gif  biggrin.gif
*
I calculate using excel or a financial calculator. Need the base data to see how it is calculated.


 

Change to:
| Lo-Fi Version
0.0969sec    0.75    7 queries    GZIP Disabled
Time is now: 13th December 2025 - 11:13 AM