QUOTE(Gravity @ Jan 10 2020, 04:46 PM)
Can you educate me on how you get your numbers for your CAGR and IRR? I am just a bit curious.Fund Investment Corner v3, Funds101
Fund Investment Corner v3, Funds101
|
|
Jan 20 2020, 07:53 PM
Return to original view | IPv6 | Post
#1
|
![]() ![]()
Junior Member
156 posts Joined: Jan 2020 |
|
|
|
|
|
|
Jan 24 2020, 04:22 PM
Return to original view | IPv6 | Post
#2
|
![]() ![]()
Junior Member
156 posts Joined: Jan 2020 |
QUOTE(keanoppy @ Jan 22 2020, 08:24 PM) Hi, need advice from Sifus. Normally it makes sense to pay off your debts in the following order from highest interest to lowest interestASB1,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%. 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. |
|
|
Feb 28 2020, 12:40 AM
Return to original view | Post
#3
|
![]() ![]()
Junior Member
156 posts Joined: Jan 2020 |
QUOTE(Yggdrasil @ Feb 27 2020, 11:51 PM) That person used website to calculate. If there was a single lump sum investment two years ago the CAGR and the IRR should be the same.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. 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. |
|
|
Feb 28 2020, 12:05 PM
Return to original view | Post
#4
|
![]() ![]()
Junior Member
156 posts Joined: Jan 2020 |
QUOTE(Yggdrasil @ Feb 28 2020, 09:21 AM) I think it's still possible to calculate CAGR. I calculate using excel or a financial calculator. Need the base data to see how it is calculated.For example, Portfolio Visualiser was able to calculate it. ![]() 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 |
| Change to: | 0.0969sec
0.75
7 queries
GZIP Disabled
Time is now: 13th December 2025 - 11:13 AM |