tag:blogger.com,1999:blog-138358822018-12-28T09:35:37.736-08:00My LifeLife and Times of Abhilash Kushwaha :)Abhilash Kushwahahttps://plus.google.com/115009519773261030125noreply@blogger.comBlogger21015abhikushhttps://feedburner.google.comtag:blogger.com,1999:blog-13835882.post-16863246190264885962012-05-22T09:58:00.001-07:002012-05-22T09:58:41.506-07:00007 James Bond - SKYFALL - Official Teaser Trailer<iframe allowfullscreen="" frameborder="0" height="270" src="http://www.youtube.com/embed/24mTIE4D9JM?fs=1" width="480"></iframe><br /><br /><span class="fullpost"></span><img src="http://feeds.feedburner.com/~r/abhikush/~4/d5tVArqCV80" height="1" width="1" alt=""/>Abhilash Kushwahahttps://plus.google.com/115009519773261030125noreply@blogger.com0http://abhikush.blogspot.com/2012/05/007-james-bond-skyfall-official-teaser.htmltag:blogger.com,1999:blog-13835882.post-9028453188693614962012-04-03T15:34:00.003-07:002012-04-03T15:34:59.588-07:00Indian Stock Market StoryDeepak Shenoy has a <a href="http://capitalmind.in/2012/04/chart-the-great-indian-stock-market-story-was-only-5-good-years/">great chart which he uses to conclude</a> that all of Indian Stock Market returns can be explained by 4 years 2003-2007. Here is the chart.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="http://4.bp.blogspot.com/-Xweecg27kcY/T3t5-QNTRFI/AAAAAAAAGv0/3gJzqzQ6a9c/s1600/Capture8.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="388" src="http://4.bp.blogspot.com/-Xweecg27kcY/T3t5-QNTRFI/AAAAAAAAGv0/3gJzqzQ6a9c/s640/Capture8.PNG" width="640" /></a></div>(Source: CapitalMind.in)<br /><br />However, the chart only tells a part of the story. Here is the same chart along with earnings growth. I have normalized both earnings and price to 100 in the beginning so that you can clearly see the relationship.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="http://2.bp.blogspot.com/-Bd0SuJgy1eI/T3t6H8znTSI/AAAAAAAAGv8/MniW90mSslo/s1600/Capture7.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="464" src="http://2.bp.blogspot.com/-Bd0SuJgy1eI/T3t6H8znTSI/AAAAAAAAGv8/MniW90mSslo/s640/Capture7.PNG" width="640" /></a></div>(Data Source: BSEIndia.com)<br /><br /><br />As you can see that prices have tracked earnings over the last 20 years (1991 to 2012). So over the long term your returns in the stock market will depend on earnings growth, which in turn will depend on how the economy is doing. India’s GDP averaged over 9% from 2003 to 2007 and around 5.3% from 1991 to 2002. Attached is a chart of India’s GDP growth during this period.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="http://2.bp.blogspot.com/-3oBhlaOJLdA/T3t6TxmPQlI/AAAAAAAAGwE/FfLTZCPUtU4/s1600/Capture10.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="258" src="http://2.bp.blogspot.com/-3oBhlaOJLdA/T3t6TxmPQlI/AAAAAAAAGwE/FfLTZCPUtU4/s640/Capture10.PNG" width="640" /></a></div>(Source: Google Public Data & World Bank)<br /><br /><br />Earnings Growth (left axis) and GDP Growth (right axis) is attached here.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="http://2.bp.blogspot.com/-KoNUUTl3VU8/T3t6eM8_msI/AAAAAAAAGwM/YIps0dMpn6M/s1600/Capture11.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="464" src="http://2.bp.blogspot.com/-KoNUUTl3VU8/T3t6eM8_msI/AAAAAAAAGwM/YIps0dMpn6M/s640/Capture11.PNG" width="640" /></a></div><br />Let me recap, over long terms prices track earnings which tracks GDP growth. Thus, expected returns will more or less depend on GDP growth.<br /><br />However it is important to note this is <strong>expected long term returns</strong> and should not be confused with you actual point to point return. In addition to earnings growth point to point return will also depend on PE multiple expansion (or compression). I had done a <a href="http://abhikush.blogspot.com/2012/03/dividend-yield-long-term-total-returns.html">detailed post</a> on this earlier.<br /><br />This brings me back to Deepak’s chart. From May 2003 to Dec 2007 the market went from 3,180.25 to 20,286.99 (up 7 times) and PE went from 13.21 to 26.94. If the PE multiple remained the same (i.e. had markets tracked earnings) then the market should be at 9,947.70 (up 3 times). Thus, PE expansion was responsible for most of the returns we saw.<br /><br />Similarly, from Dec 2007 to Apr 2012 the market went from 20,286.99 to 17,597.42 and PE multiple went from 26.94 to 17.92. If the PE multiple had remained the same the market would have been at 26,455.05. Here is a chart of Price, Earnings and PE. Again Price and Earnings have been normalized at 100 in 1991.<br /><br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="http://4.bp.blogspot.com/-puzJhJ6MxMc/T3t6pGtHLvI/AAAAAAAAGwU/wklgpYldsI4/s1600/Capture9.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="464" src="http://4.bp.blogspot.com/-puzJhJ6MxMc/T3t6pGtHLvI/AAAAAAAAGwU/wklgpYldsI4/s640/Capture9.PNG" width="640" /></a></div><br />Thus, point to point returns will depend on valuations in addition to expected returns. If the stock market goes from undervalued to overvalued (as it happened from 2003 to 2007) your returns will be higher than expected returns and vice versa.<br /><br />Currently market PE is around 17 whereas historically it has been around 21 and median is around 19 (averages are impacted by high PE multiples resulting from early 90s scams and 2000s bubble so median may be a better approximation). This indicates that markets are slightly undervalued. So (and I mean over 5 to 10 years) when PE expands to its historical value (around 19) then returns will be higher than what you expect.<br /><br />This post can be reduced to following mathematical equations:<br /><strong>Point to Point Return = Expected Future Returns + Returns due to Multiple Expansion</strong><br /><strong>Expected Future Return = Earnings Growth ~ ~ GDP Growth</strong><br /><br />Finally, though I haven’t discussed it in this post but it can be shown that<br /><strong>GDP Growth = Population Growth + Productivity Increases</strong><br /><br />Valuations will tell you what will happen to PE multiple (e.g. I would expect it to go up from here).<br />Population Growth is really predictable and is around 1.3% for India.<br />So, to predict returns all you really need is Productivity Increase <img alt="Smile" class="wlEmoticon wlEmoticon-smile" src="http://lh4.ggpht.com/-ub8pFsMve0c/T3t5veBPUOI/AAAAAAAAGvk/T9W2rxuFmHU/wlEmoticon-smile%25255B2%25255D.png?imgmax=800" style="border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none;" />.<br />Let me know if you can predict it <img alt="Open-mouthed smile" class="wlEmoticon wlEmoticon-openmouthedsmile" src="http://lh3.ggpht.com/-rC8C9gyoSdQ/T3t5vpWF1CI/AAAAAAAAGvs/vtHo6aFG8Ho/wlEmoticon-openmouthedsmile%25255B2%25255D.png?imgmax=800" style="border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none;" />.<img src="http://feeds.feedburner.com/~r/abhikush/~4/HdryjmGVPRU" height="1" width="1" alt=""/>Abhilash Kushwahahttps://plus.google.com/115009519773261030125noreply@blogger.com0http://abhikush.blogspot.com/2012/04/indian-stock-market-story.htmltag:blogger.com,1999:blog-13835882.post-2837743582298559942012-04-01T23:15:00.001-07:002012-04-01T23:15:54.255-07:00Hussman Interview Q3<div align="left">Please see solutions to <a href="http://abhikush.blogspot.com/2012/04/hussman-strategic-advisors-financial.html">Q1</a> & <a href="http://abhikush.blogspot.com/2012/04/hussman-advisors-financial-analyst-pre.html">Q2</a>.</div><div align="left"><br /></div><strong>3) A vehicle is filled with fuel. One gallon of fuel can propel every 10 pounds of vehicle weight a<br />distance of 2 miles (5 pounds of weight 4 miles, etc). A gallon of fuel weighs 8 pounds.</strong><br /><br /><strong>a) Write a general expression for the distance traveled by the vehicle</strong><br /><br /><strong>b) If f0 is the starting amount of fuel, write an analytic equation for the total distance traveled</strong><br /><br /><strong>c) If the vehicle weighs 100 pounds when empty, and has traveled 1 mile after expending half<br />of its starting amount of fuel, what is the starting amount of fuel, and how far does it<br />ultimately take the vehicle (round to 4 decimal places)?</strong><br /><br /><strong>d) Suppose you didn’t discover that an analytic solution to this problem requires calculus (now<br />there’s a hint!). Write a short program in C++, Basic, Matlab or pseudocode to approximate<br />the amount of fuel required to move the vehicle (100 pounds when empty) 5 miles.</strong><br /><br />Weight of Vehicle = V; Weight of Fuel/Gallon = F; Gallons of Fuel = G; Distance Travelled = D; Weight of Vehicle and Fuel = W<br /><br />I am not sure the difference between part a and b but here is my attempt.<br /><br />a) D is directly proportional to G and inversely proportional to W<br />D ~ G/W => D = KG/W, where K is proportionality constant<br />In this case when D = 2; G = 1; W = 10. Therefore, K = 20. <br />Thus, when W = 5; D = 20*1/5 = 4<br /><br />b) W = V + F*G => D = KG/(V+FG)<br />Total distance travelled is tricky because as soon as you burn a little fuel the weight reduces and the further you can travel.<br />Therefore, to find distance travelled we first need to know what happens when fuel changes by small amount i.e. differentiate the above equation with respect to G<br /><a href="http://lh5.ggpht.com/-mkQ-tE3ZIFE/T3lD0uHVjQI/AAAAAAAAGrg/Uut87hItbUg/s1600-h/clip_image002%25255B10%25255D%25255B3%25255D.png"><img alt="clip_image002[10]" height="39" src="http://lh6.ggpht.com/-Un9M81uRfqM/T3lD1FhYqYI/AAAAAAAAGro/Sp8xccKPLWE/clip_image002%25255B10%25255D_thumb%25255B1%25255D.png?imgmax=800" style="display: inline;" title="clip_image002[10]" width="207" /></a> <br />Now to find total distance travelled we have to integrate when fuel G ranges from f<sub>0</sub> to 0 <br />Let us first solve indefinite integral <br /><a href="http://lh5.ggpht.com/-ifvYju89LqQ/T3lD1TrWVBI/AAAAAAAAGrw/WwkjAQwztg8/s1600-h/clip_image002%25255B20%25255D%25255B3%25255D.png"><img alt="clip_image002[20]" height="30" src="http://lh4.ggpht.com/-bP4GfKmiqao/T3lD1sTYkCI/AAAAAAAAGr4/gwKOd6xZ07w/clip_image002%25255B20%25255D_thumb%25255B1%25255D.png?imgmax=800" style="display: inline;" title="clip_image002[20]" width="240" /></a> <br />Now adding limits total distance travelled is <br /><a href="http://lh3.ggpht.com/-oLGuFSykTHg/T3lD17GyZoI/AAAAAAAAGsA/XjRh64tXHRw/s1600-h/clip_image002%25255B22%25255D%25255B3%25255D.png"><img alt="clip_image002[22]" height="39" src="http://lh3.ggpht.com/-FTBUXj1LAhY/T3lD2OwVySI/AAAAAAAAGsI/Biq7yrTGgvU/clip_image002%25255B22%25255D_thumb%25255B1%25255D.png?imgmax=800" style="display: inline;" title="clip_image002[22]" width="240" /></a> <br /> <br />c) Weight of Vehicle = V = 100lbs; Weight of Fuel/Gallon = F = 8lbs/g; Gallons of Fuel = G = f<sub>0</sub> –> f<sub>0</sub>/2; Distance Travelled = D = 1 and K = 20<br /><a href="http://lh3.ggpht.com/-rjouM72D5Ek/T3lD2eQIlpI/AAAAAAAAGsQ/8vwFpRtn-aE/s1600-h/clip_image002%25255B24%25255D%25255B3%25255D.png"><img alt="clip_image002[24]" height="44" src="http://lh3.ggpht.com/-E3XTWPEeu8o/T3lD29E6QOI/AAAAAAAAGsY/9_YG_D2V_xQ/clip_image002%25255B24%25255D_thumb%25255B1%25255D.png?imgmax=800" style="display: inline;" title="clip_image002[24]" width="240" /></a> <br />Substituting, <br /><a href="http://lh6.ggpht.com/-tDHECcm7B1g/T3lD3GVAC-I/AAAAAAAAGsg/Jk_1p_1IDW4/s1600-h/clip_image002%25255B26%25255D%25255B3%25255D.png"><img alt="clip_image002[26]" height="39" src="http://lh4.ggpht.com/-empnJ-29fd8/T3lD3S8Zv5I/AAAAAAAAGso/TwIf2gzoNBc/clip_image002%25255B26%25255D_thumb%25255B1%25255D.png?imgmax=800" style="display: inline;" title="clip_image002[26]" width="227" /></a> <br />10000+1200f<sub>0</sub>+32f<sub>0</sub><sup>2</sup> = 250*(-4f<sub>0</sub>) <br />32 f<sub>0</sub><sup>2</sup> + 2200f<sub>0</sub> + 100 = 0 <br />f<sub>0</sub> ~ –63.8562 & –4.8938<br />The equation has 2 roots and both negative. So, it is clear I have made a mistake. However, my calculus is a little rusty and I will leave the solution so that the internet can explain the mistake <img alt="Smile" class="wlEmoticon wlEmoticon-smile" src="http://lh6.ggpht.com/-tbH2qi0WI1w/T3lD3sGa3zI/AAAAAAAAGsw/3ZmqG3PPjuI/wlEmoticon-smile%25255B2%25255D.png?imgmax=800" style="border-bottom-style: none; border-left-style: none; border-right-style: none; border-top-style: none;" /> <br /> <br />d) This will only make sense if I have the correct equation. So, I will not attempt to solve it.<img src="http://feeds.feedburner.com/~r/abhikush/~4/jqkPwdl6pyY" height="1" width="1" alt=""/>Abhilash Kushwahahttps://plus.google.com/115009519773261030125noreply@blogger.com0http://abhikush.blogspot.com/2012/04/hussman-interview-q3.htmltag:blogger.com,1999:blog-13835882.post-2918116844322614462012-04-01T19:44:00.002-07:002012-04-01T19:44:26.478-07:00Hussman Advisors Financial Analyst Pre Interview Question 2I am solving question 2 of Hussman Advisors Financial Analyst pre interview question. Question 1 was solved <a href="http://abhikush.blogspt.com/2012/04/hussman-strategic-advisors-financial.html">earlier</a>. <br /><br /><strong>Q2 Let the value of a firm’s equity be equal to the discounted stream of deliverable cash flows</strong><b><br /><strong>(“DCF”) and assume that firm</strong></b><strong>‐</strong><strong>wide DCF grows at rate g, so Vt = DCFt+1 / (k</strong><strong>‐</strong><strong>g). Let Nt be the</strong><b><br /><strong>number of shares of stock at time t, so the per</strong></b><strong>‐</strong><strong>share stock price Pt is simply Vt/Nt. Each year, the</strong><b><br /><strong>company pays a proportion d of DCF to existing shareholders as dividends, and then uses the</strong><br /><strong>remaining proportion (1</strong></b><strong>‐</strong><strong>d) to repurchase shares. Assume that shares are repurchased at price</strong><b><br /><strong>Pt, which simultaneously determines Nt.</strong></b> <br /><strong><br /></strong><br /><strong>a) Derive a simple expression for the per</strong><strong>‐</strong><strong>share dividend growth rate g*, in terms of k, d and g</strong><b><br /><strong>only, and give a simple interpretation (Hint: Write down expressions involving DCF, don’t be</strong><br /><strong>afraid to substitute equivalent expressions, and notice that all growth rates will be constant</strong><br /><strong>given the assumptions above. In particular, Nt/Nt+1 = Nt</strong></b><strong>‐</strong><strong>1/Nt).</strong> <br /><strong><br /></strong><br /><strong>b) Show algebraically that if the per</strong><strong>‐</strong><strong>share dividend growth rate g* is used, the standard</strong><b><br /><strong>dividend discount model holds even in the presence of share repurchases, so that adding in</strong><br /><strong>repurchases as if they were a separate payment to shareholders would actually represent</strong><br /><strong>double</strong></b><strong>‐</strong><strong>counting. Specifically, show that Vt/Nt = Dt+1 / k</strong><strong>‐</strong><strong>g*.</strong> <br /><br />a) From the problem statement we have the following equation: <br /><br />P<sub>0</sub> = V<sub>0</sub> / N<sub>0</sub> = (DCF<sub>1</sub>/N<sub>0</sub>) / (k-g) <br /><br />I will use g’ instead of g* as * is generally used as multiplication sign and may confusion i.e. g’ = g* <br />We can also drive the price per share using dividend discount method i.e. if Dividends D<sub>t</sub> grow at constant rate g’ then <br /><br />P<sub>0</sub> = D<sub>1</sub>/k-g’ <br /><br />Also, from the problem statement D<sub>t</sub> = d*DCF<sub>t</sub> <br />Therefore, P<sub>0</sub> = D<sub>1</sub>/k-g’ = (d*DCF<sub>1</sub>/N<sub>0</sub>) / (k-g’) <br /><br />The price per share obtained from both the methods should be same. <br /><br />Therefore, k-g’ = d*(k-g) or <strong>g’ = g* = k - d*(k-g)</strong> <br /><br />I am not sure if the question expected me to prove that P<sub>0</sub> obtained from two methods is same or not. <br />However, there is an entire <a href="http://papers.ssrn.com/sol3/papers.cfm?abstract_id=1051281">paper</a> that goes on to show the equivalence of Cash Flow Method and Dividend Discount Method. <br /><br /><br />b) From the result above: d * (k-g) = (k-g’) <br /><br />V<sub>t</sub>/N<sub>t</sub> = DCF<sub>t+1</sub>/(k-g) = D<sub>t+1</sub> / d*(k-g) = D<sub>t+1</sub> / (k-g’) <br /><br />This makes sense since we assumed P<sub>t</sub> (V<sub>t</sub>/N<sub>t</sub>) is equivalent to derive g’ in the first case.<img src="http://feeds.feedburner.com/~r/abhikush/~4/zFFUKEv_PJM" height="1" width="1" alt=""/>Abhilash Kushwahahttps://plus.google.com/115009519773261030125noreply@blogger.com0http://abhikush.blogspot.com/2012/04/hussman-advisors-financial-analyst-pre.htmltag:blogger.com,1999:blog-13835882.post-81924803248133302802012-04-01T01:06:00.001-07:002012-04-01T01:11:09.201-07:00Hussman Strategic Advisors Financial Analyst Pre Interview QuestionsHussman Strategic Advisors has a bunch of pre-interview questions for Financial Analyst / Financial Engineer position. I will try my best to answer some of those questions. I will tackle the 1st question in this post. <br /><br /><strong>What is the payment on a 12‐year, $400,000 mortgage that compounds on the payment date every 73 days at 6%? (show your formula and calculations, and ignore leap year)</strong> <br /><br />I do not really understand the question so here is my best guess. I am assuming I do not have to worry about individual days in a month. Also, I am assuming 6% is the annual rate. <br /><strong><br /></strong><br /><strong>Step 1</strong>: Calculate relationship between annual rate, 73 days rate and monthly rate. <br /><br />365 Days = 12 months => 73 Days = 12*(73/365) months = 2.4 months <br /><br />Let R be the annual rate in decimal (0.06 in this case); r be the monthly rate in decimal and R* is the rate every 73 days (or every 2.4 months) <br /><br />To convert rates lets start with something familiar. <br />If a loan compounds every 6 months (half yearly) then 6 months rate is R/2 i.e. R/(12/6) <br />If a loan compounds every 3 months (quarterly) the 3 months rate is R/4 i.e. R/(12/3) <br />If a loan compounds every month then monthly rate is R / 12 i.e. R/(12/1) <br /><br />So, if a loan compounds ever 2.4 months (73 days) the 73 day rate is R/(12/2.4) = R/5 = R* <br /><br />Now, monthly rate r compounded for 2.4 months = R* i.e. (1+r)<sup>2.4 </sup>= 1 + R* <br /><br />r = (1+R*)<sup>(1/2.4)</sup> – 1 = (1+(R/5))<sup>(1/2.4)</sup> – 1 = (1+(0.06/5))<sup>(1/2.4)</sup> – 1 = 0.004983 = 0.4983% <br /><br />If the loan had compounded every month instead of 73 days then r = R/12 = 0.5% <br /><strong><br /></strong><br /><strong>Step 2</strong>: Derive Payment Formula <br /><br />Let L be the loan amount ($400,000) and P be the payment every month <br /><br />At the end of the 1st month: <br />Outstanding Loan Amount, L<sub>1</sub> = L*(1+r) – P <br />Let (1+r) = X <br />L<sub>1</sub> = L*X – P <br /><br />At the end of 2nd month: <br />Outstanding Loan Amount, L<sub>2</sub> = L<sub>1</sub>*X – P = L*X<sup>2</sup> – P*X – P <br /><br />At the end of 3rd month: <br />Outstanding Loan Amount, L<sub>3</sub> = L<sub>2</sub>*X – P = L*X<sup>3</sup> – P*(X<sup>2</sup> – X – 1) <br /><br />At the end of nth month: <br />Outstanding Loan Amount, L<sub>n</sub> = L<sub>n-1</sub>*X – P = L*X<sup>n</sup> – P*(X<sup>n-1</sup> – X<sup>n-2</sup> – … 1) <br /><br />Sum of Geometric Progression (GP) 1+x+x<sup>2</sup>+x<sup>3</sup>+…x<sup>n-1</sup> = (x<sup>n</sup> – 1)/(x – 1) <br />Using the GP formula and replacing X by (1+r)<br /><br />L<sub>n</sub> = L*(1+r)<sup>n</sup> – P*(((1+r)<sup>n</sup> – 1) / r) <br /><br />At the end of loan term (n = 144 months in this case) outstanding amount = 0 <br />When L<sub>n</sub> = 0 then P = L*r*(1+r)<sup>n</sup> / ((1+r)<sup>n</sup> – 1) = L*r / (1 – 1/(1+r)<sup>n</sup>) <br />Therefore, P = 400,000*0.004983 / (1-1/(1+0.004983)<sup>144</sup>) = 3899.39<img src="http://feeds.feedburner.com/~r/abhikush/~4/V2C_Hwa1feA" height="1" width="1" alt=""/>Abhilash Kushwahahttps://plus.google.com/115009519773261030125noreply@blogger.com0Burbank, CA 91502, USA34.1772371 -118.308203434.150964099999996 -118.3476854 34.2035101 -118.26872139999999http://abhikush.blogspot.com/2012/04/hussman-strategic-advisors-financial.html