Tag Archives: etf

Stock Valuation And The Gordon Growth Model

Valuing Stocks with the Gordon Growth Model Preface Hedge funds and financial analysts typically use a variety of approaches to determine the intrinsic value of shares. With that being said, the Gordon Growth Model is a subcategory of a larger group of mathematical models commonly known as the dividend discount models. The idea of the model states that the value of a stock is the expected future sum of all of the dividends. The model, named after Myron J. Gordon, is quite fascinating since it provides a relatively simple yet intuitive method of valuing the intrinsic value of a stock to be compared to the current market price. In this article, we will be discussing the core formula and how it serves as a benchmark for short or long decisions. Afterwards I will give insight on how to setup an Excel spreadsheet to perform the calculations so that the valuation can be obtained within a matter of seconds. Assumptions Before we begin the valuation, there are some assumptions that a stock must fulfill in order for this model to function properly. The assumptions are: Gordon Growth Model allows you to disregard all current market factors and focus strictly on the fundamentals. With that being said, the model does not account for special products or branding that may allow a company to stand out relative to its competitors. The model assumes that the stock of the company in question has and will pay dividends. Certain variations of the model work around this, however, the one presented in this article must include a stock that historically pays dividends. The expected dividend growth rate must be smaller than the expected rate of return. If this is not the case, then the valuation would be negative, which is impossible (Those terms will be explained once we discuss the core formula). The dividend growth rate must be estimated. Although this seems risky, I will provide information explaining what and how a dividend growth rate is estimated and how it can be done easily on Excel. The dividend growth rate is assumed to be constant. The sensitivity of the difference between the required rate of return and the dividend growth rate is quite high. This means one small alternation in the difference can lead to a radically different valuation (So we must be careful). The Formula Now that the boring rules are out of the way, it is time to take a look at the formula behind the Gordon growth model’s intrinsic valuation of a stock. First, let’s denote the current value of the dividend as “D0” and a constant dividend grow rate by “g”. The dividend in “n” number of years will be represented as the following: Assuming now that we require some compounded rate of return represented by the variable “r”, we simply take the ratio from the previously mentioned dividend in “n” year’s equation shown below (See next header for calculations of “r”): If we now add every single dividend from year “n” back to the present day, we reach a total present value resembling the following: Click to enlarge If we then project this geometric series equation to “n=infinity”, we can rewrite the above in the following infinite sum (We can think of this as a simpler version of the above series): Click to enlarge Interestingly, if we extract the geometric series portion of the above equation, we are left with a remarkably simple formula, representing the intrinsic value of a stock as the following: If the expected dividend of (let’s say) year 1 has already been determined (calculated), then the equation can be further simplified to simply the following: Deriving the Dividend Growth Rate Now it’s time to define the way in which we obtain “g” or the dividend growth rate. First, we must acquire historical dividend data (Preferably from Yahoo). Second, we add up the quarterly dividend data per year in order to give us annualized or “yearly” data. Third, we input the relevant information into the equation below. Once “g” has been obtained, we then proceed to calculate the arithmetic average of the annual dividend, which can be done as follows: This process is easily done in Excel since the summations of sets of data can easily be calculated and tweaked if needed (For information on how to calculate the dividend growth rate and even a compounded dividend growth rate, refer to the Excel guidelines in the final header). Obtaining Required Rate of Return Although the model is pretty intuitive, variables such as “r” representing the required rate of return must be calculated separately before being integrated in the formula. To calculate the value of “r”, refer to the equation below: The values of the variables are determined by the user. Generally, they are obtained through the preferences and research done by the user. For example, “rf” or the “risk-free rate” is generally a US Daily Treasury long-Term Rate, however, it is up to the user to make such a decision. This is therefore the same for determining the “market risk premium”. The “the stock beta” on the other hand must be calculated by the user with results being relative to a certain benchmark. Ok, cool, so how does one calculate Beta? Calculating Beta ( β) When we talk about beta being relative to a benchmark, we are specifically highlighting the geometric slope of the closing prices of a stock in a given period relative to those closing prices of popular index within the corresponding exchange. For example, shares of Exxon Mobil (NYSE: XOM ) can be compared to the S&P 500 as a benchmark. When calculating beta, I personally gather 37 monthly prices (for the chosen ticker and Index) from a specific start date to an end date (You can pick as many monthly prices as you wish). In my preferred calculations, returns will be calculated from months 2 to 37 since in order to calculate the return for month 2, I need month 1 and therefore I would need 37 prices in order to get 36 results. Returns for a specific number of months, denoted as “n”, can be calculated with the equation below: To be specific, let’s note that the monthly prices should be the close price on the first trading day of each month (This may not be the first day of each month). Once we have the returns for our ticker and our index, we can now calculate the Beta by using Excel’s Slope function to make the calculation easier and quicker. Calculating the Gordon Growth Model in Excel Please refer to the links below to download the spreadsheets (They are free). The Excel spreadsheets that I am providing calculate the dividend growth rates, the Beta of selected stocks and the Gordon Growth Model valuation of a stock. There is one separate spreadsheet used for calculating Beta and another one which includes both the dividend growth rate and the Gordon Growth Model valuation integrated together. Essentially, a potential investor begins by opening the “calculate beta” worksheet and inputs the respective parameters. The user must input the desire stock ticker, benchmark index ticker and both start and end dates. The user then clicks the “Download Data button” and receives the respective information in the “results” section of the current sheet. This process is all powered by sophisticated VBA coding, allowing for the spreadsheet to download data from Yahoo Finance and make the appropriate calculation. A user should end up with the following: Click to enlarge Once a potential investor has the relevant Beta calculation, he or she can copy and paste that value into the next worksheet. By opening the “Gordon Growth” worksheet, the user can insert the Beta calculation in the parameters section of the Gordon Growth Model section. Within the Gordon Growth Model spreadsheet, the investor begins by entering the respective stock in the ticker section and proceeding to click the “get bulk dividend button” in order for the VBA coding to provide both a dividend growth rate and a compounded dividend growth rate in the preceding sheets. View the graphic below: Click to enlarge Once the user obtains their required dividend growth rate, they can now input the given result into the Gordon Growth Model parameters. By inserting the remaining information listed to the right of the parameters section, the investor obtains a theoretical valuation in the “results” section. This theoretical value represents the intrinsic value of the stock, and by comparing such a value with the current market price, the investor can determine whether they believe the stock is over or underpriced. That is to say, if the predicted value is higher than the actual trading price, then the share is priced fairly. However, if the predicted value is lower than the current stock price, then the Model predicts the stock to be overpriced. Keeping those results in mind, this model can now serve as a benchmark in determining the sentiment that an investor would have towards a long or short position for a given share price. Link to download the spreadsheet. Side Notes This process generally takes me less than two minutes to input and calculate. I have tested these spreadsheets on my phone and they work just fine. Mobile investors will especially find the spreadsheets of this model useful for when they are on the move. Disclosure: I/we have no positions in any stocks mentioned, and no plans to initiate any positions within the next 72 hours. I wrote this article myself, and it expresses my own opinions. I am not receiving compensation for it. I have no business relationship with any company whose stock is mentioned in this article. Additional disclosure: I do not claim ownership of the mathematical formulas used. I am simply writing this article to provide the community with a better understanding of the model and the techniques that can be used in excel. I am not the original creator of the excel files, I simply edited them to fit with the functions of this mathematical model

Common Mistakes Most Investors Make

Individuals are consistently promised that investing in the financial markets is the only way to financial success. After all, it’s so easy. Financial pundits across the country state that one simply buys a basket of mutual funds and they will make 8, 10 or 12% a year. On a nominal basis, it is true that if one bought an index and held it for 20 years, they would have made money. Unfortunately, for most, it has not worked out that way. Why? Because no matter how resolute people think they are about buying and holding, they usually fall into the same emotional pattern of buying high and selling low . Investors are human beings. Human beings naturally want to be in the winning camp when markets are rising and seek to avoid pain when markets are falling. As Sy Harding says in his excellent book ” Riding The Bear ,” while people may promise themselves at the top of bull markets that this time they’ll behave differently : no such creature as a buy and hold investor ever emerged from the other side of the subsequent bear market .” Statistics compiled by Ned Davis Research back up Harding’s assertion. Every time the market declines more than 10% (and “real” bear markets don’t even officially begin until the decline is 20%) , mutual funds experience net outflows of investor money. Fear is a stronger emotion than greed . The research shows that it doesn’t matter if the bear market lasts less than 3 months ( like the 1990 bear ) or less than 3 days ( like the 1987 bear ). People will still sell out, usually at the very bottom, and almost always at a loss. The only way to avoid the “buy high/sell low” syndrome – is to avoid owning stocks during bear markets. If you try to ride a bear market out, odds are you’ll fail. And if you believe that we are in a new era where Central Bankers have eliminated bear market cycles, your next of kin will have my sympathies. Let’s look at some of the more common trading mistakes to which people are prone. Over the years, I’ve committed every sin on the list at least once and still do on occasion. Why? Because I am human too. 1) Refusing To Take A Loss – Until The Loss Takes You When you buy a stock, it should be with the expectation that it will go up – otherwise, why would you buy it? If it goes down instead, you’ve made a mistake in your analysis. Either you’re early, or just plain wrong. It amounts to the same thing. There is no shame in being wrong, only in STAYING wrong . This goes to the heart of the familiar adage: “let winners run, cut losers short.” Nothing will eat into your performance more than carrying a bunch of dogs and their attendant fleas , both in terms of actual losses and in dead, or underperforming, money. 2) The Unrealized Loss From whence came the idiotic notion that a loss “on paper” isn’t a “real” loss until you actually sell the stock? Or that a profit isn’t a profit until the stock is sold and the money is in the bank? Nonsense! Your portfolio is worth whatever you can sell it for, at the market, right at this moment. No more. No less . People are reluctant to sell a loser for a variety of reasons. For some, it’s an ego/pride thing, an inability to admit they’ve made a mistake . That is false pride, and it’s faulty thinking. Your refusal to acknowledge a loss doesn’t make it any less real. Hoping and waiting for a loser to come back and save your fragile pride is just plain stupid . Realize that your loser may NOT come back. And even if it does, a stock that is down 50% has to put up a 100% gain just to get back to even. Losses are a cost of doing business, a part of the game. If you never have losses, then you are not trading properly. Take your losses ruthlessly, put them out of mind and don’t look back, and turn your attention to your next trade . 3) More Risk It is often touted that the more risk you take, the more money you will make. While that is true, it also means the losses are more severe when the tide turns against you. In portfolio management, the preservation of capital is paramount to long-term success. If you run out of chips, the game is over. Most professionals will allocate no more than 2-5% of their total investment capital to any one position. Money management also pertains to your total investment posture. Even when your analysis is overwhelmingly bullish, it never hurts to have at least some cash on hand, even if it earns nothing in a ” ZIRP ” world. This gives you liquid cash to buy opportunities and keeps you from having to liquidate a position at an inopportune time to raise cash for the ” Murphy Emergency :” This is the emergency that always occurs when you have the least amount of cash available – Murphy’s Law #73) If investors are supposed to “sell high” and “buy low,” such would suggest that as markets become more overbought, overextended, and overvalued, cash levels should rise accordingly. Conversely, as markets decline and become oversold and undervalued, cash levels should decline as equity exposure is increased. Unfortunately, this is something never addressed by the mainstream media. 4) Bottom Feeding Knife Catchers Unless you are really adept at technical analysis, and understand market cycles, it’s almost always better to let the stock find its bottom on its own, and then start to nibble. Just because a stock is down a lot doesn’t mean it can’t go down further. In fact, a major multi-point drop is often just the beginning of a larger decline. It’s always satisfying to catch an exact low tick, but when it happens it’s usually by accident. Let stocks and markets bottom and top on their own and limit your efforts to recognizing the fact ” soon enough .” Nobody, and I mean nobody, can consistently nail the bottom tick or top tick . 5) Averaging Down Don’t do it. For one thing, you shouldn’t even have the opportunity, as that dog should have already been sold long ago. The only time you should average into any investment is when it is working. If you enter a position on a fundamental or technical thesis, and it begins to work as expected thereby confirming your thesis to be correct, it is generally safe to increase your stake in that position. 6) You Can’t Fight City Hall OR The Trend Yes, there are stocks that will go up in bear markets and stocks that will go down in bull markets, but it’s usually not worth the effort to hunt for them. The vast majority of stocks, some 80+%, will go with the market flow. And so should you. It doesn’t make sense to counter trade the prevailing market trend. Don’t try and short stocks in a strong uptrend and don’t own stocks that are in a strong downtrend . Remember, investors don’t speculate – ” The Trend Is Your Friend .” 7) A Good Company Is Not Necessarily A Good Stock There are some great companies that are mediocre stocks, and some mediocre companies that have been great stocks over a short time frame. Try not to confuse the two. While fundamental analysis will identify great companies, it doesn’t take into account market, and investor, sentiment. Analyzing price trends, a view of the ” herd mentality ,” can help in the determination of the “when” to buy a great company which is also a great stock. 8) Technically Trapped Amateur technicians regularly fall into periods where they tend to favor one or two indicators over all others. No harm in that, so long as the favored indicators are working, and keep on working. But always be aware of the fact that as market conditions change, so will the efficacy of indicators. Indicators that work well in one type of market may lead you badly astray in another. You have to be aware of what’s working now and what’s not, and be ready to shift when conditions change. There is no ” Holy Grail ” indicator that works all the time and in all markets. If you think you’ve found it, get ready to lose money. Instead, take your trading signals from the ” accumulation of evidence ” among ALL of your indicators, not just one. 9) The Tale Of The Tape I get a kick out of people who insist that they’re long-term investors, buy a stock, then anxiously ask whether they should bail the first time the stocks drops a point or two. More likely than not, the panic was induced by listening to financial television. Watching ” the tape ” can be dangerous. It leads to emotionalism and hasty decisions. Try not to make trading decisions when the market is in session. Do your analysis and make your plan when the market is closed. Turn off the television, get to a quite place, and then calmly and logically execute your plan. 10) Worried About Taxes Don’t let tax considerations dictate your decision on whether to sell a stock. Pay capital gains tax willingly, even joyfully. The only way to avoid paying taxes on a stock trade is to not make any money on the trade. If you are paying taxes – you are making money…it’s better than the alternative.” Steps to Redemption Don’t confuse genius with a bull market. It’s not hard to make money in a roaring bull market. Keeping your gains when the bear comes prowling is the hard part . The market whips all our butts now and then. The whipping usually comes just when we think we’ve got it all figured out. Managing risk is the key to survival in the market and ultimately in making money. Leave the pontificating to the talking heads on television. Focus on managing risk, market cycles and exposure. STEP 1: Admit there is a problem … The first step in solving any problem is to realize that you have a problem and be willing to take the steps necessary to remedy the situation. STEP 2: You are where you are … It doesn’t matter what your portfolio was in March of 2000, March of 2009 or last Friday. Your portfolio value is exactly what it is rather it is realized or unrealized. The loss is already lost and understanding that will help you come to grips with needing to make a change. STEP 3: You are not a loser … You made an investment mistake. You lost money. It has happened to every person that has ever invested in the stock market and anyone who says otherwise is a liar! STEP 4: Accept responsibility … In order to begin the repair process, you must accept responsibility for your situation. Continue to postpone the inevitable only leads to suffering further consequences of inaction. STEP 5: Understand that markets change … Markets change due to a huge variety of factors from interest rates to currency risks, political events to geo-economic challenges. Does it really make sense to buy and hold a static allocation in a dynamic environment? The law of change states : that change will occur and the elements in the environment will adapt or become extinct and that extinction in and of itself is a consequence of change . Therefore, even if you are a long-term investor, you have to modify and adapt to an ever-changing environment otherwise, you will become extinct. STEP 6: Ask for help … Don’t be afraid to ask or get help – yes, you may pay a little for the service but you will save a lot more in the future from not making costly investment mistakes. STEP 7: Make change gradually … Making changes to a portfolio should be done methodically and patiently. Portfolio management is more about ” tweaking ” performance rather than doing a complete ” overhaul .” STEP 8: Develop a strategy … A goal-based investment strategy looks at goals like retirement, college funding, new house, etc. and matches investments and investment vehicles in an orderly and designed portfolio to achieve those goals in quantifiable and identifiable destinations. The duration of your portfolio should match the “time” frame to your goals. Building an allocation on 80-year average returns for a 15-year goal could leave you in a very poor position. STEP 9: Learn it…Live it…Love it … Every move within your investment strategy must have a reason and purpose, otherwise, why do it? Adjustments to the plan, and the investments made, should match performance, time and value horizons. Most importantly, you must be committed to your strategy so that you will not deviate from it in times of emotional duress. STEP 10: Live your life … The whole point of investing in the first place is to ensure a quality of life at some specific point in the future. Therefore, while you work hard to earn your money today, it is important that your portfolio works just as hard to earn your money for tomorrow.

Forget Production Cut: Short Oil And Energy ETFs

The free fall in oil prices for over the past one-and-a-half years had taken a brief pause in recent sessions on hopes of an output freeze by the Organization of the Petroleum Exporting Countries (OPEC). The biggest oil-producing countries – Saudi Arabia and Russia – along with Qatar and Venezuela had agreed to freeze oil output at the January level if other countries joined them in the initiative. Had the move materialized, the oil patch – which has long been suffering from higher supplies and lower demand on weak global growth – would see prices shoring up and losses paring down. Many had started to view the move as the beginning of the long-wished production cut. However, all optimism went down the drain after Iran called the OPEC top-brass Saudi Arabia-led initiative a ” joke “. In any case, chances of Iran joining the treaty were slim as the country has been trying to boost production after the sanctions on it were lifted last month. This is because it was producing below its capacity and pre-sanction levels since 20 1 1 while the other countries had raised their output limit to record levels in the mean time. After Iran’s remark, Saudi Arabia also scrapped the option of output cuts by major producers in the near term. However, Saudi oil minister Al-Naimi also noted that he expects more countries to agree on the output freeze scheme by next month. So, while output cut has taken a backseat, investors should also keep in mind that there is no improvement in the demand scenario either. Earlier this month, the International Energy Agency (IEA) slashed its estimates for global oil demand for 20 15 and 20 16, by 100,000 barrels a day. This represents flat demand growth ( 1.2 million barrels a day) this year. Market Impact Following the dimming prospects of an output cut and limited benefits from a likely output freeze at record levels, oil prices started giving up prior gains. The United States Oil ETF (NYSEARCA: USO ) – which looks to track the daily changes of the spot price of the U.S. crude – lost over 4.8% on February 23 while it lost about 1.3% after hours. On the other hand, the United States Brent Oil ETF (NYSEARCA: BNO ) – which looks to track the daily changes in percentage terms of the spot price of Brent crude oil – was off 3.5% on February 23. Short Oil Given the situation, investors may want to consider shorting oil or the entire energy space. So, for investors seeking to make an inverse bet on oil as a commodity or on the energy equities, below are three ETFs pertaining to each case. Any of these will prove gainful amid declining oil prices. However, investors should keep in mind that a short play in the futures market requires a strong appetite for risks. ProShares UltraShort Bloomberg Crude Oil ETF (NYSEARCA: SCO ) SCO is the most popular option in the short oil ETF space. The fund tracks the Dow Jones-UBS Crude Oil Sub-Index to provide twice the inverse performance on a daily basis of WTI crude oil. The fund was up 8.5% on February 23 while it added 2.7% after hours. DB Crude Oil Double Short ETN (NYSEARCA: DTO ) The note follows a benchmark of crude oil futures contracts to provide -2x exposure. The fund added more than 7.4% on February 23, 20 16. VelocityShares 3x Inverse Crude Oil ETN (NYSEARCA: DWTI ) DWTI is one of the riskier ways to play the short oil market, utilizing -3x exposure with daily rebalancing. The fund tracks the S&P GSCI Crude Oil Index to provide exposure to crude oil. The product surged 14.4% on February 23, obviously for its triple-leverage strategy and advanced 4.8% after hours. Short Energy ProShares Short Oil & Gas ETF (NYSEARCA: DDG ) This fund provides unleveraged inverse (or opposite) exposure to the daily performance of the Dow Jones U.S. Oil & Gas Index. The ETF makes a profit when the energy stocks decline and is suitable for hedging purposes against the fall of these stocks. DDG was up 3.3% on February 23. ProShares UltraShort Oil & Gas ETF (NYSEARCA: DUG ) This fund seeks two times (2x) leveraged inverse exposure to the Dow Jones U.S. Oil & Gas Index. DUG returned more than 6.5% on February 23. Direxion Daily Energy Bear 3x Shares ETF (NYSEARCA: ERY ) This product provides three times (3x) inverse exposure to the Energy Select Sector Index. The fund surged over 10% on February 23 and added 1.9% in after-market trading. Original post