{"id":2088013,"date":"2018-10-02T12:26:24","date_gmt":"2018-10-02T06:56:24","guid":{"rendered":"http:\/\/stockviz.biz\/index.php\/?p=2088013"},"modified":"2018-10-02T15:53:21","modified_gmt":"2018-10-02T10:23:21","slug":"lumpsum-vs-sip-thinking-in-probabilities","status":"publish","type":"post","link":"https:\/\/stockviz.biz\/index.php\/2018\/10\/02\/lumpsum-vs-sip-thinking-in-probabilities\/","title":{"rendered":"Lumpsum vs. SIP: Thinking in Probabilities"},"content":{"rendered":"<p>This is a continuation of <a href=\"https:\/\/stockviz.biz\/2018\/06\/23\/lumpsum-vs-dollar-cost-averaging-sip\/\" rel=\"noopener\" target=\"_blank\">Lumpsum vs. Dollar Cost Averaging (SIP)<\/a> that modeled different return series and concluded that a prudent investor would be better off with a SIP because of a smaller probability of incurring a large loss. However, we stopped short of comparing different indexes to see if the conclusion held.<\/p>\n<h3>The &#8216;average&#8217; return<\/h3>\n<p>What happens if we take the average weekly return of an index and create a synthetic index that just gives those average returns without any variance? We end up with a parabolic looking cumulative return profile below:<br \/>\n<a href=\"https:\/\/github.com\/stockviz\/blog\/raw\/master\/lumpsum%20vs%20sip%20(dca)\/cumulative.raw.NIFTY%20SMLCAP%20100.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/github.com\/stockviz\/blog\/raw\/master\/lumpsum%20vs%20sip%20(dca)\/cumulative.raw.NIFTY%20SMLCAP%20100.png\" width=\"1200\" height=\"600\" alt=\"cumulative small cap returns\" class=\"alignnone size-full\" \/><\/a><br \/>\nThe small cap index was chosen on purpose to illustrate how &#8216;average&#8217; returns relate to real returns on an extremely volatile index.<\/p>\n<p>The average return series is, of course, a fantasy. What we are interested in is in the probability of getting those returns.<\/p>\n<h3>Probabilities<\/h3>\n<p>Just like our first post, we start by modeling the returns of the NIFTY 50, MIDCAP and SMLCAP indexes as a Generalised Lambda Distribution and running a 10,000 path simulation to obtain a series of DCA vs lumpsum investment returns. We then feed that into a empirical cumulative distribution function so that we can query it for probabilities under different thresholds. To put that in a picture:<br \/>\n<a href=\"https:\/\/github.com\/stockviz\/blog\/raw\/master\/lumpsum%20vs%20sip%20(dca)\/cumulative.simulation.avg.NIFTY%20SMLCAP%20100.2004-01-09.2018-09-28.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/github.com\/stockviz\/blog\/raw\/master\/lumpsum%20vs%20sip%20(dca)\/cumulative.simulation.avg.NIFTY%20SMLCAP%20100.2004-01-09.2018-09-28.png\" width=\"1200\" height=\"700\" alt=\"lumpsum vs SIP returns on small caps\" class=\"alignnone size-full\" \/><\/a><\/p>\n<p>The vertical lines mark the different thresholds we are interested in. <\/p>\n<ul>\n<li>The grey line on the left is at zero. We have SIP showing a 4.44% probability of negative returns and lumpsum showing 3.49%. Yes, there is a non-trivial possibility that SIPs will give negative returns. However, looking at the shapes below zero, SIP losses may not be as large as lumpsum losses.<\/li>\n<li>The red line in the middle is the start to finish return of the index. Here, we have SIP showing a 22.69% probability of exceeding those point-to-point returns and lumpsum showing 57.50%.<\/li>\n<li>The orange line on the right is the compounded &#8216;average&#8217; return. We have SIP showing a 7.82% probability of exceeding that and lumpsum showing 37.20%.<\/li>\n<\/ul>\n<p>Here is the same MIDCAP:<br \/>\n<a href=\"https:\/\/github.com\/stockviz\/blog\/raw\/master\/lumpsum%20vs%20sip%20(dca)\/cumulative.simulation.avg.NIFTY%20MIDCAP%20100.2001-01-12.2018-09-28.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/github.com\/stockviz\/blog\/raw\/master\/lumpsum%20vs%20sip%20(dca)\/cumulative.simulation.avg.NIFTY%20MIDCAP%20100.2001-01-12.2018-09-28.png\" width=\"1200\" height=\"700\" alt=\"MIDCAP lumpsum vs. SIP return densities\" class=\"alignnone size-full\" \/><\/a><\/p>\n<p>And for NIFTY 50:<br \/>\n<a href=\"https:\/\/github.com\/stockviz\/blog\/raw\/master\/lumpsum%20vs%20sip%20(dca)\/cumulative.simulation.avg.NIFTY%2050.1990-07-13.2018-09-28.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/github.com\/stockviz\/blog\/raw\/master\/lumpsum%20vs%20sip%20(dca)\/cumulative.simulation.avg.NIFTY%2050.1990-07-13.2018-09-28.png\" width=\"1200\" height=\"700\" alt=\"NIFTY 50 lumpsum vs. SIP densities\" class=\"alignnone size-full\" \/><\/a><\/p>\n<h3>What does all this mean?<\/h3>\n<ol>\n<li>It is possible for SIP returns to be negative over large periods of time. Enough to cover your entire investing lifetime. So, if you are investing in small-caps, make sure you are not 100% allocated to it.<\/li>\n<li>Lumpsum investing gives you a higher probability of higher returns across all indexes. The probability of negative returns are on par with that of SIP&#8217;s.<\/li>\n<li>Lumpsums have fatter left tails. However, if you are looking only at NIFTY 50 and MIDCAP, those probabilities are tiny.<\/li>\n<li>Lumpsums have a higher probability of achieving &#8216;average&#8217; returns compared to SIPs.<\/li>\n<li>Lumpsums seem to be benefiting from &#8220;time in the market&#8221; on indexes that rise over a period of time.<\/li>\n<\/ol>\n<p>Code and charts on <a href=\"https:\/\/github.com\/stockviz\/blog\/tree\/master\/lumpsum%20vs%20sip%20(dca)\" rel=\"noopener\" target=\"_blank\">github<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is a continuation of Lumpsum vs. Dollar Cost Averaging (SIP) that modeled different return series and concluded that a prudent investor would be better off with a SIP because of a smaller probability of incurring a large loss. However, we stopped short of comparing different indexes to see if the conclusion held. The &#8216;average&#8217; &hellip; <\/p>\n","protected":false},"author":2,"featured_media":2088023,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3471],"tags":[3843,960,3833],"class_list":["post-2088013","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-investing-insight","tag-lumpsum","tag-returns","tag-sip","entry"],"_links":{"self":[{"href":"https:\/\/stockviz.biz\/index.php\/wp-json\/wp\/v2\/posts\/2088013","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stockviz.biz\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stockviz.biz\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stockviz.biz\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/stockviz.biz\/index.php\/wp-json\/wp\/v2\/comments?post=2088013"}],"version-history":[{"count":0,"href":"https:\/\/stockviz.biz\/index.php\/wp-json\/wp\/v2\/posts\/2088013\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/stockviz.biz\/index.php\/wp-json\/wp\/v2\/media\/2088023"}],"wp:attachment":[{"href":"https:\/\/stockviz.biz\/index.php\/wp-json\/wp\/v2\/media?parent=2088013"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stockviz.biz\/index.php\/wp-json\/wp\/v2\/categories?post=2088013"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stockviz.biz\/index.php\/wp-json\/wp\/v2\/tags?post=2088013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}