tag:blogger.com,1999:blog-8911815931562346570.post387965732032415324..comments2023-06-19T10:37:49.372-07:00Comments on Yaruzi's Learn 2 Live: November 2016 - Low Cost Portfolio ScorecardYaruzihttp://www.blogger.com/profile/00655103480152780191noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-8911815931562346570.post-43975690724444148572016-12-23T04:53:39.727-08:002016-12-23T04:53:39.727-08:00Yes SMOL fully aware.
The intention is not to man...Yes SMOL fully aware.<br /><br />The intention is not to manipulate KPI :-), but to avoid significant injection especially late in the year to skew the actual return. I think the XIRR YTD gives me a better feel on the weighted return.Yaruzihttps://www.blogger.com/profile/00655103480152780191noreply@blogger.comtag:blogger.com,1999:blog-8911815931562346570.post-84966584313367335782016-12-23T04:18:18.418-08:002016-12-23T04:18:18.418-08:00Yaruzi,
I see.
Have you noticed that if you inpu...Yaruzi,<br /><br />I see.<br /><br />Have you noticed that if you input cash injection on 28th Feb instead of 30th Nov, the XIRR YTD changes?<br /><br />Don't mind me.<br /><br />I used to be an unofficial Business Navigator and I had great fun "manipulating" the KPIs and statistical reports just to see which top management is alert and know how to read beyond the figures ;)<br /><br />Singapore Man of Leisurehttps://www.blogger.com/profile/13774067113884418001noreply@blogger.comtag:blogger.com,1999:blog-8911815931562346570.post-17524381689051227712016-12-22T21:31:11.274-08:002016-12-22T21:31:11.274-08:00Hi SMOL, Merry Christmas and Happy New Year to you...Hi SMOL, Merry Christmas and Happy New Year to you too!<br /><br />I used XIRR YTD to give me the weighted return for the year from 1st January. I give you example:<br />Return YTD <br />Portfolio starting value 1st Jan 200,000<br />Inject fresh fund 30th Nov 200,000<br />Portfolio value+fresh fund+profit 31st Dec 410,000<br /><br />Return YTD as of 31st Dec=10,000/40,0000=2.5%<br /><br />XIRR YTD <br />Portfolio starting value 1st Jan 200,000<br />Inject fresh fund 30th Nov 200,000<br />Portfolio value+fresh fund+profit 31st Dec 410,000<br /><br />XIRR YTD as of 31st Dec 4.62%<br /><br />The XIRR YTD will reset every 1st Jan, and I hope it will give me a feel on how volatile the annualized weighted return of the portfolio year by year.<br /><br />Thanks for coming by.Yaruzihttps://www.blogger.com/profile/00655103480152780191noreply@blogger.comtag:blogger.com,1999:blog-8911815931562346570.post-43883946457528150602016-12-22T19:15:02.705-08:002016-12-22T19:15:02.705-08:00Yaruzi,
A very clear representation of your portf...Yaruzi,<br /><br />A very clear representation of your portfolio performance than some other bloggers out there.<br /><br />1) Clearly shows capital injection.<br /><br />2) Profits and losses in $ amount out in the open. <br /><br /><br />I can understand % for Return YTD and XIRR since inception.<br /><br />But I've no clue why you have XIRR YTD?<br /><br />Unless you just want to feel good about the higher percentages ;) <br /><br />If you average out the XIRR YTD with the number of years, it will look even better than XIRR since inception. Now that's statistical manipulation for ownself cheat ownself! LOL!<br /><br />Its a good example where the dollar amount returned does not change, how we calculate and what formula we use can make a big difference in percentages.<br /><br />Wishing you happy holidays and Merry Christmas!<br />Singapore Man of Leisurehttps://www.blogger.com/profile/13774067113884418001noreply@blogger.comtag:blogger.com,1999:blog-8911815931562346570.post-15731771944585082812016-12-22T15:45:59.769-08:002016-12-22T15:45:59.769-08:00Thanks UN, we wish you & family a Merry Christ...Thanks UN, we wish you & family a Merry Christmas and a Happy New Year too! God blessYaruzihttps://www.blogger.com/profile/00655103480152780191noreply@blogger.comtag:blogger.com,1999:blog-8911815931562346570.post-82674873040266549972016-12-22T02:58:42.731-08:002016-12-22T02:58:42.731-08:00You are back from your holiday!
Merry Christmas t...You are back from your holiday!<br /><br />Merry Christmas to you and your family! :)Unintelligent Nerdhttps://www.blogger.com/profile/17797052565143872922noreply@blogger.com