BROCK FINANCE & INVESTMENT GROUP Equity Desk Manual Version 1.0 1/16/2013 This manual is for the training and ongoing educational development for associates and analysts of Brock Finance and Investment Group (BFIG). It is a reference for how research should be conducted and what parameters shareholders, the executive team and faculty will be looking for. Brock Finance & Investment Group EQUITY DESK MANUAL Table of Contents 1.0 RESEARCH PROCESS 2 2.0 CONDUCTING BACKGROUND RESEARCH Business Profile Analysis Financial Profile Analysis 2 2 3 3 4 8 9 Financial Statements Calculating Key Ratios Comparable Companies Analysis Sources of Information 3.0 PRODUCING THE ANALYST REPORT Company Overview Business Risk Analysis Bankruptcy Analysis DCF Valuation Recommendation 10 10 10 13 16 21 4.0 SUBMITTING REPORT FOR REVIEW Sourcing/Referencing Full Disclosure 22 22 22 5.0 DEVELOPING SHAREHOLDER PRESENTATION 22 1 Brock Finance & Investment Group EQUITY DESK MANUAL Research Process This manual is for the training and ongoing educational development for associates and analysts of Brock Finance and Investment Group (BFIG). It is a reference for how research should be conducted and what parameters shareholders, the executive team and faculty would be looking for. Conduct Background Research Produce Analyst Report Submit Report for Review Develop Shareholder Presentation Ongoing Review Conducting Background Research When studying the target company there are two profiles that need to be evaluated: The business profile and the financial profile. This will give an overall of the business practices and financial stability. Business Profile Sector Products and Services Customers and End Markets Distribution Channels Geography Financial Profile Size Profitability Growth Profile Return on Investment Credit Profile Sources of Information Analysts that issue of Buy, Hold, or Sell, recommendations to investors get the majority of their information from EDGAR, the Electronic Data-Gathering, Analysis, and Retrieval system, and SEDAR, the System for Electronic Document Analysis and Retrieval. This depends on whether the company is on the American or Canadian stock exchanges. The U.S. Securities and Exchange Commission, SEC, enforces all publically traded companies in the various American stock exchanges (NASDAQ, NYSE, and AMEX), to disclose all relevant information to investors. The Canadian Securities Administrators (CSA) established SEDAR and is regulated by the Canadian Depository for Securities (CDS). All companies that trade on the various Canadian stock exchanges (TSX, VSE, MX, etc.) are forced to disclose their information to the public. The primary goal for both exchanges is to provide transparency, reliability, and liquidity to investors. 2 Brock Finance & Investment Group EQUITY DESK MANUAL Business Profile Analysis Sector Sector refers to the industry or markets in which a company operates (e.g., chemicals, consumer products, healthcare, industrials, and technology). A company’s sector can be further divided into sub-sectors, which facilitates the identification of the target’s closest comparable. Within the industrials sector, for example, there are numerous sub-sectors, such as aerospace and defense, automotive, building products, metals and mining, and paper and packaging. For companies with distinct business divisions, the segmenting of comparable companies by sub-sector may be critical for valuation. A company’s sector conveys a great deal about its key drivers, risks, and opportunities. For example, a cyclical sector such as oil & gas will have dramatically different earnings volatility than consumer staples. On the other hand, cyclical or highly fragmented sectors may present growth opportunities that are unavailable to companies in more stable or consolidated sectors. Products and Services A company’s products and services are at the core of its business model. Products are commodities or valueadded goods that a company creates, produces, or refines. Examples of products include computers, lumber, oil, prescription drugs, and steel. Services are acts or functions performed by one entity for the benefit of another. Examples of common services include banking, installation, lodging, logistics, and transportation. Many companies provide both products and services to their customers, while others offer one or the other. Similarly, some companies offer a diversified product and/or service mix, while others are more focused. Customers and End Markets Customers A company’s customers refer to the purchasers of its products and services. Companies with a similar customer base tend to share similar opportunities and risks. For example, companies supplying automobile manufacturers abide by certain manufacturing and distribution requirements, and are subject to the automobile purchasing cycles and trends. The quantity and diversity of a company’s customers are also important. Some companies serve a broad customer base while others may target a specialized or niche market. While it is generally positive to have low customer concentration from a risk management perspective, it is also beneficial to have a stable customer core to provide visibility and comfort regarding future revenues. Distribution Channels Distribution channels are the avenues through which a company sells its products and services to the end user. As such, they are a key driver of operating strategy, performance, and, ultimately, value. Companies that sell primarily to the wholesale channel, for example, often have significantly different organizational and cost structures than those selling directly to retailers or end users. 3 Brock Finance & Investment Group EQUITY DESK MANUAL Financial Profile Analysis To fully understand the financial profile and properly analyze a company you must read and understand all reporting and financial statements available. Step 1: Financial statements Financial statements are a company’s way of delivering information to their shareholders. Financial statements are generally released every quarter and are summed by an annual report. Financial statements contain future outlook as well as past performance for a particular company and may give the analyst a lot of information with regards to their current and future value. There are three key components of a financial statement: balance sheet, statement of cash flows and income statement. Balance sheet A balance sheet is a company’s assets, liabilities and shareholders’ equity. It explains what the company is holding in cash and less liquid tangible and intangible assets. Income statement An income statement would be the equivalent of a verb if the balance sheet is a noun where an income statement is all the activity that has occurred during the period. This includes items such as revenue, operating income and as such also includes profit. Statement of cash flows. The statement of cash flows is a further break down of the income statement describing all of the sources of revenue and all expenditures. This can be used to determine investing activities and insight into current and future cash operations. How do the three financial statements tie together? Balance Sheet is a snapshot in time. In other words, it shows the company’s total assets, liabilities, and equity since inception. Income statement shows what the changes are from period to period and the Net income ties into the Balance sheet’s Equity account. Statement of Cash Flows is a summary of the change of Cash on the Balance Sheet from period to period. The sum of that plus the beginning cash period will equal to the total cash in the balance sheet. It is broken down into three parts: Cash Flow from Operations, Cash Flow from Investing, and Cash Flow from Financing. 4 Brock Finance & Investment Group EQUITY DESK MANUAL Step 2: Calculating Key Ratios There are five main categories in which ratios will be calculated: Size, profitability, growth profile return on investment and credit profile. Size Size is typically measured in terms of market valuation (e.g., equity value and enterprise value), as well as key financial statistics (e.g., sales, gross profit, EBITDA, EBIT, and net income). Companies of similar size in a given sector are more likely to have similar multiples than companies with significant size discrepancies. This reflects the fact that companies of similar size are also likely to be analogous in other respects (e.g., economies of scale, purchasing power, pricing leverage, customers, growth prospects, and the trading liquidity of their shares in the stock market). Equity Value: This value is also known as market capitalization.[2] Enterprise Value: This is a measure of a company’s value and is a more accurate representation than the market capitalization.[2] Gross Profit: The residual profit after selling a product or service and subtracting the costs associated.[2] Net Income: This will be found on the bottom line of all income statements. It is the total earning after deducting all business costs, taxes, depreciation/amortization and other expenses. [2] EBITDA: Is the net income with tax, interest depreciation & amortization added back to it. This number is important as allows for a better comparison of companies across similar industries. [2] EBIT: Is a good indicator of a company’s profitability. This calculation can often be referred to as “operating profit” or “operating income”. [2] (excluding tax, interest, depreciation & amortization) 5 Brock Finance & Investment Group EQUITY DESK MANUAL Profitability Gross Profit Margin This ratio explains the business model and how demand driven it is. In a business with a low profit margin we require many more customers. In a business with a high profit margin there doesn’t need to be as many customers. Institutional business (IT solutions, Engineering firms, construction) do not need many clients and tend to have a very high profit margin. Other businesses such as dollar stores have a smaller profit margin and require a lot of customers.[2] EBITDA Margin This ratio provides a measurement of the company’s operating profits. It represents a clean view of core profitability.[2] Net income Margin Return on investment Return on Investment Capital Return on Equity (ROE) The amount of net income returned as a percentage of shareholders equity. Return on equity measures a corporation's profitability by revealing how much profit a company generates with the money shareholders have invested. [2] Return on Asset (ROA) An indicator of how profitable a company is relative to its total assets. ROA gives an idea as to how efficient management is at using its assets to generate earnings. Calculated by dividing a company's annual earnings by its total assets, ROA is displayed as a percentage. Sometimes this is referred to as "return on investment".[2] 6 Brock Finance & Investment Group EQUITY DESK MANUAL What are some of the issues that ROE has compared to ROA? ROE is levered. It includes debt. Therefore, ROE may increase due to an increase of equity leverage, not operating margin. Net income/Assets * Assets/Equity Credit Profile Leverage Ratio: Capitalization Ratio This ratio can be used as a risk measure of financial distress of the firm. A higher ratio is a higher risk. [2] Debt to Capitalization Ratio Coverage The coverage ratio depicts the ability of a firm to pay off its interest expense obligations.[2] Growth Profile To estimate future growth we must look at previous years Diluted EPS and calculate the Compounded Annual Growth Rates (CAGR). This calculation will automatically be done in the excel document provided. Other Key Trading Multiples Price to Earnings (P/E) The P/E ratio is the current stock price divided by the company’s diluted earnings-per-share (EPS). This ratio can be used to determine is the company is overvalued or undervalued. [2] 7 Brock Finance & Investment Group EQUITY DESK MANUAL Price to earning to Growth (PEG) This ratio takes the PE ratio and puts it up against the rate of growth the company’s experiencing. The ratio is PE divided by ROG (rate of growth). If the ratio is high this would mean that the company is highly valued in terms of its growth. If the ratio is low it would be lowly valued in terms of its growth.[2] Enterprise Value-to EBITDA EV/EBITDA serves as a valuation standard for most sectors. It is independent of capital structure and taxes, as well as any distortions that may arise from differences in D&A among different companies. [2] Sector- Specific Multiples Valuation Multiple Sector Enterprise Value/ Access Lines/Fibre Miles/Route Miles Broadcast Cash Flow (“BCF”) Earnings Before Interest Taxes, Depreciation, Amortization, and Rent Expense (“EBITDAR”) Earnings Before Interest Taxes, Depreciation, Depletion, Amortization, and Exploration Expense (“EBITDAX”) Population (“POP”) Production/Capacity (in units) Reserves Subscriber Square Footage Telecommunications Media Telecommunications Casinos Restaurants Retail Natural Resources Oil & Gas Telecommunications Metals & Mining Natural Resources Oil & Gas Paper & Forest Products Metals & Mining Natural Resources Oil & Gas Media Telecommunication Real Estate Retail 8 Brock Finance & Investment Group EQUITY DESK MANUAL Step 3: Comparable Company Analysis Comparisons Many of these ratios do not say much if they stand alone however; they have a lot of value when compared to other similar companies and previous years. The ratios would compare change over years and be benchmarked to industry standards When analyzing competitors it is important to take a breakdown of market share and change in market share over the last 3 years. This helps determine the company’s growth. It is also necessary to compare with the 3 closest competitors. Calculations entail using the trading multiples. Competitors It is important to take a top down approach to be able to properly analyze the markets and competitors. We would start with major economic reports, then sectors, and then news. The Bloomberg website and trading economies dot com is very good for information regarding these reports and certain pieces of news. Companies that are competitors are ones with similar products and services. Bloomberg can help zone in using a stock screener for which companies can be competitors through sector analysis. The internet is a good resource for obtaining information as to who is a direct competitor with such analysed company. Conference Calls Many corporations hold quarterly y conference calls for investors and stake holders to discuss where company is going and to make sense of where the company is. Generally these conference calls will discuss earnings, weather they met expectations, and if they didn’t then why. There is a lot of valuable information and this is information that can be acted on in a timely fashion. Some of the things you can do as an analyst is: 1. Make a calendar of when these conferences take place 2. Ask a lot of questions 3. Find out more information about the financial statements such as who did their auditing if they were not the people who did it. Summarize key points about the conference call and how we can act on them 9 Brock Finance & Investment Group EQUITY DESK MANUAL Sources of Information Income Statement Data Sales Gross Profit EBITDA EBIT Net Income / EPS Research Estimates Balance Sheet Data Cash Balance Debt Balances Shareholders’ Equity Cash Flow Statement Data Depreciation & Amortization Capital Expenditures Share Data Basic Shares Outstanding Options and Warrants Market Data Share Price Data Credit Ratings Most recent 10-K, 10-Q, 8-K, Press Release First Call or IBES, individual equity research reports Most recent 10-K, 10-Q, 8-K, Press Release Most recent 10-K, 10-Q, 8-K, Press Release 10-K, 10-Q, or Proxy Statement, whichever is most recent Data 10-K or 10-Q, whichever is more recent Financial information service Rating agencies’ websites, Bloomberg Producing the Analyst Report The analyst report is the report provided by the analyst and associates to the chief sector analyst for review. Using the collected background research, the finalized report should thoroughly cover a particular company quantitatively and qualitatively. The components of the report consist of the following. Company Overview Business Risk Analysis Bankrupcy Analysis DCF Valuation Recommendation Company Overview This is a key part of the report. It briefly introduces the company and what they do. The introduction should outline what the company’s objectives are and is a general introduction of its functions 10 Brock Finance & Investment Group EQUITY DESK MANUAL Business Risk Analysis Management This is a key part of the report as it outlines who the management is. If management is has a member on their team that have no experience this may say something about the calibre of the company being analyzed. On the other hand, If management is experienced it is generally safe to assume that they have a strong handle on the company. It is also important to research the executive team individually as they may have executive positions in other corporations or may have a history that can undermine the value of the corporation such as a criminal record. [1] Competition Competition is an important part of the report. Generally the key things are who are the competitors and what are they doing. What kind of market share does the current company have and has it been growing. Is the product being analyzed something inelastic (oil) in which competitors are analyzed in terms of supply or is it a fast food chain in which competitors are analyzed in terms of demand. Another important factor to consider is there competitors doing anything that can shift the market share and if so how much would it potentially shift it by. [1] Economic conditions Economic conditions play an integral role in the pricing of a security. It is an important portion of this report. Some of the things to look for are the macro economic outlook and an analysis on how this will affect the company. From the macroeconomic outlook we can then move down to the microeconomic level. For a farfetched example a research article published in a scientific journal and then pushed through to a magazine stating that global warming is not real will affect the increase in car consumption thus increasing the sales in the motor industry. This would translate into Ford’s stock increasing. [1] Distribution This topic tackles who the company’s distributors are and what methods of distribution they use. This is important because an understanding of their distributors and their methodology leads to a better understand of future cash flows. Also the rate of increase for their distribution channels and distributors can offer insights into cash flows.[1] Marketing The marketing department should be analyzed for the reason that it represents the branding image and sales strategy for the company. If there is a faulty marketing department or one that is not innovative it can lead to problems. An understanding of how a company marketing department functions can give insight into how effective they are at increasing sales year after year.[1] Suppliers The suppliers for a corporation are very important as they speak volumes about the product. If a corporation has one supplier and the revenue they provide for this supplier is a very small portion of the supplier’s total revenue then this creates a huge business risk. If for some reason that supplier decides not to offer their product or service anymore, the business is now subject to finding another supplier which can make or break their pricing and product. This analysis is very important to understand the dynamics and function of the corporation. [1] 11 Brock Finance & Investment Group EQUITY DESK MANUAL Customers The customer of a corporation plays the same role as suppliers. If there is one customer that creates 90 percent of the company’s revenue, then this creates a greater risk for the company. A safer company would have multiple clients. This gives an insight into the possible risks that can come up if the service or product provided suffers from a functional problem. [1] Environmental Risk A major business risk is environmental risk. There are many reasons why this risk is important first and foremost is that the more environmentally friendly a company is the more likely it is that they will attract certain accreditations making them more “prestigious”. That is not the most important reason though. The most important reason is the fines and levies those countries in developed countries pose and the lawsuits that can come in from damaging the environment. These play a trivial risk on certain companies and can lead to future problems if misconduct continues. It also means that at some point for these companies to be continuous there would need to be extra costs associated with staying environmentally friendly if the process is already not environmentally friendly. [1] Political risk A major risk is associated with political risk. Generally US and Canadian companies experience political risk not when they conduct their business within their own countries but when they conduct it within other countries. If a mining company in 2008 decided to go into Yemen it currently would have lost all of its investment into finding the resource it was looking for. This is definitely an important aspect of the report and should not go unrecognized. Some of the things looked into is how many countries does this business operate in and what is the political situation in each country. [1] Highlight of annual report The highlight of the annual report within relation to business risk is also very important. The Annual report contains a lot of important information that can help determine exactly the kind of risks that said business may have to deal with. Understanding these risks will help us deal with these investments in a more prudent manner.[1] Bankruptcy Analysis Altman’s Z Score Analysis - Corporate Credit Scoring Model In attempt to predict corporate collapse and assess any signs of looming bankruptcy investors resort to such financial ratios as working capital, profitability, debt levels and liquidity. Issue being with ratio analysis is that each ratio is independent and reflects a different story; Altman’s Z score is a predictive, ratio weighted model that incorporates these concepts from five key performance ratios into a single score. This score gives a snapshot of corporate financial health leading to more informed investment decisions. 12 Brock Finance & Investment Group EQUITY DESK MANUAL The formula consists of an optimal independent weighting assigned to each ratio multiplied by the respective ratio. Z-Score Formula: 1.2 + 1.4 + 3.3 + 0.6 + 1.0 Interpreting the score: Z > 2.99 - “Safe Zone” 1.8 < Z < 2.99 - “Gray Zone” Z < 1.8 - “Distress Zone” Working Capital (Current Assets – Current Liabilities) / Total Assets: A firm with negative working capital is likely to experience problems meeting its short-term obligations because there simply are not enough current assets to cover those obligations. By contrast, a firm with significantly positive working capital rarely has trouble paying its bills. This ratio is a good test for corporate distress. Retained Earnings / Total Assets This ratio measures the amount of reinvested earnings or losses, which reflects the extent of the company's leverage. Companies with low RE/TA are financing capital expenditure through borrowings rather than through retained earnings. Companies with high RE/TA suggest a history of profitability and the ability to stand up to a bad year of losses. Earnings Before Interest and Tax / Total Assets This is a version of return on assets (ROA), an effective way of assessing a firm's ability to squeeze profits from its assets before factors like interest and tax are deducted. Market Value of Equity / Total Liabilities This is a ratio that shows, if a firm were to become insolvent, how much the company's market value would decline before liabilities exceed assets on the financial statements. This ratio adds a market value dimension to the model that isn't based on pure fundamentals. In other words, a durable market capitalization can be interpreted as the market's confidence in the company's solid financial position. Sales / Total Assets This ratio tells investors how efficiently the firm uses assets to generate sales. Failure to grow market share translates into a low or falling S/TA. 13 Brock Finance & Investment Group EQUITY DESK MANUAL A deteriorating Z-score can signal trouble ahead and provide a simpler conclusion than the mass of ratios. The Z-score is probably better used as a gauge of relative financial health rather than as a predictor. Arguably, it's best to use the model as a quick check of financial health, but if the score indicates a problem, it's a good idea to conduct a more detailed analysis. Various statistical errors can arise with discriminant analysis (Altman’s z score) such as Type 1 and Type 2 errors. Type 1 errors occur when something good is deemed bad (firm assessed as non-bankrupt but is bankrupt) and Type 2 errors occur when something bad is deemed good (firm being assessed bankrupt but is not bankrupt). Type 1 errors are much more costly as investors can lose 100% of their investment when a company goes bankrupt; where Type 2 errors leads to 0-10% loss of investment as the severity of the investment failure is much lower. A way to decrease on Type 1 errors is to increase on Type 2 errors, a more economical error. Increasing the passing grade (confidence interval) that firms require to enter the safe zone will lead to less Type 1 errors and save investors’ money. Z’ Score – Private Firm Model Formula: 1.2 + 1.4 + 3.3 + 0.6 + 1.0 When using the Z score to asses a private firm the formula changes the fourth ratio from the market value of equity to book value of equity and the score results can be interpreted as: Z’ > 2.9 = “Safe Zone” 1.23 < Z’ < 2.9 = “Grey Zone” Z’ < 1.23 = “Distress Zone” Z” Score – Manufactures, Non-Manufacturers, Industrials & Emerging Market Credit Formula: 1.2 + 1.4 + 3.3 + 0.6 Z” > 2.6 - “Safe Zone” 1.1< Z” < 2.6 - “Grey Zone” Z” < 1.1 - “Distress Zone” 14 Brock Finance & Investment Group EQUITY DESK MANUAL Discounted Cash Flow Valuation The Discounted Cash Flow (DCF) valuation model is a widely used technique in the industry to determine an intrinsic value for a target company. This is done through the process of forecasting future free cash flows to determine an intrinsic value of the target company. i. Free Cash Flow Model The steps taken to project a company's FCF into the future are as follows: 1. Calculate the Industry's Revenue growth to as far back as possible. You can accomplish this by getting access to Bloomberg or historical charts in Google finance and using the S&P/TSX composite index tickers. For example for the S&P/TSX Capped Financials Index the ticker is - ^SPTTFS. Once you have found the historical chart you will take the earliest index price and exact date as well as the latest index price and most recent date. You now have enough information to calculate the annualized compounded growth rate. FV = PV(1+r)^n PV FV n r = (FV/PV)^(1/n)-1 31/10/2000 17/10/2012 103.3 183.05 11.96986301 4.90% This is an example done in excel to show how we used the FV compound growth formula, re-arranged to get us our r, or our compound annual growth rate. This gives us our industry growth rate, and we can base our projections around this figure. For example, if you are dealing with a larger company in the industry a lower than industry average rate would be a more accurate number. In contrast a smaller company may have a higher growth model and a higher than industry average growth rate may be more accurate. 2. Next we have to calculate the company's weighted average cost of debt. We need to pull up the company's latest report. We are looking for the notes to financial statements; this is found after the financial statements. There will be a note that is specific to the company’s debt. Sometimes the liabilities section of the balance sheet will reference the debt as to which note it is, they are labelled in numbers. For example, “Note 10”. When you read the debt not there will be specific loans stated at different interests’ rates. You need to calculate a weighted average of these loans to find an absolute interest rate for the total outstanding debt. This number will be in a percentage. 3. You will now calculate the cost of equity. This equation fluctuates compared to each sector and takes a lot of industry and specific company knowledge. The formula is as follows: Cost of Equity = ( ) 15 Brock Finance & Investment Group EQUITY DESK MANUAL Rf - This is the risk free rate, use the 10 year bond yield for the country you are investing in. For Canada use, http://www.bankofcanada.ca/rates/interest-rates/lookup-bond-yields/ β - Beta measures the volatility of a specific stock compared to the market. A beta of 1 would be the stock generally moves with the market. A beta of less than 1 would mean it is less volatile than the market, meaning if the market goes up 1% the stock would only rise by 0.8% and vice versa. A beta of more than 1 would be it is more volatile than the market, the market drops by 1% it would drop by 1.2%. This can be found by using the Bloomberg terminal at the school. You can also visit www.yahoo.ca/finance , type in the company ticker and click summary in the top left corner. This will display beta in its general information. Rm - Is the expected market return. This number is different for the risk tolerance each investor has. Someone with a larger portfolio that is more diversified might be willing to take an 8% return (closer to the historical market return), whereas someone only invested in that one stock would need a larger return to compensate for the risk of only holding that one stock. This rate is variable and subject to industry and specific stock knowledge. For example, an investor might require a higher return for the risk they are taking on with a company based out of a politically unstable country as there is higher concern for the operations of the business. In contrast the same investor might not require such a high return in Canada as our country has good market regulations and little to no political risk. 4. Now that you have weighted average cost of debt and the cost of equity we can plug these numbers into our Weighted Average Cost of Capital (WACC) equation. This gives us our discount rate that we will be discounted our cash flows back to present value with. WACC = (Equity / (E+D)) * Re + (Debt / (D+E)) * Rd * (1 - tx) WACC - Weighted Average Cost of Capital (or discount rate) Equity (E) - Is found on the latest balance sheet. Make sure you read all recent news since the latest report came out to find out if you have to change the equity value, because of issued shares for capital etc.* Debt (D) - Is found on the latest balance sheet. Make sure you read all recent news since the latest report came out to find out if the company has secured more debt for financing. If this is the case you have to include this debt in your weighted average cost of debt calculation to make sure your discount rate will reflect real-time company conditions. Re – This is your cost of equity. The description is in note 3. Rd – This is your cost of debt. The description is in note 2. 16 Brock Finance & Investment Group EQUITY DESK MANUAL Tx - This is your tax rate, and it can be found on your latest ANNUAL report. This figure is not in the quarterly reports. You will find this in the tax note below the financial statements. * Make sure you talk to your sector analyst or the person training sector analysts about this. If there is news out that shares have been issues you need to change the capital structure of the business. It will not be as simple as taking the number off the balance sheet and plugging it in, this would be inaccurate in that case. 5. The next step is to calculate the specific companies Free Cash Flows. You need to bring up the company's latest annual report and quarters (if any more recent) financial statements. You will need the income statement, balance sheet, and cash flow statement. ( ) FCF - Free Cash Flow Dividends - The money the company has promised to continue to pay (although they could stop paying the dividends, we subtract dividends in order to get a more conservative estimate). We find this variable in the cash flow statement under financing activities. Capex - We only use the capital expenditures for the up keep on the already owned assets, we exclude any new purchases of Property Plant & Equipment, because the firm chose to use the free cash for those investments. You will need to check the footnotes, after the financial statements, for any long-term assets to find out if they purchased new assets. These new assets should not be included, unless they are used specifically for a project they are building (that they have to put money into) etc. Use the full amount of PP&E from the cash flow statement if nothing is disclosed and you did not find any further information in the annual report. You need to dig deeper to understand where there money is going and why. Do you believe that spending the money on that project is a waste of the free cash flow they are bringing in? Could they allocate their capital in a more effective manner? This variable is different for different sectors industry knowledge is important, it is not set in stone. Non-cash Working Capital - This is found on the cash flow statement under investing activities. It can be a negative or a positive, because it is the change in non-cash working capital. Note that change in working capital is located under operating activities, subtract NWC from investing activities if it is negative if it is positive subtract from 0 in order to give a more conservative estimate on how much FCF the company is bringing in. ( ) ( ) EBIT - Is found on the income statement and is called “Earnings before Interest and Taxes”. On the income statement it is: Sometimes the income statement will not disclose EBIT so you would have to calculate it yourself. 17 Brock Finance & Investment Group EQUITY DESK MANUAL Tax Rate - This is found in the footnotes after the financial statements on the annual report (DO NOT look for this in the quarterly report). D&A - Depreciation and Amortization is a non-cash expense from the company's net income. Since this lowers company profits, but does not actually affect the company's cash flow we have to exclude this number. This is always found in the operating section of the cash flow statement. Changes in Working Capital - This is calculated from the balance sheet (always use the most current balance sheet): ( ) Capex - See Capex in note 4. 6. Now that you know how to calculate FCF we will find out how much FCF the company has had in previous years to show a trend. If you are finding a value for a business in the middle of the year you have to calculate any new information on the FCF's that have already been made that year and project the FCF's for the rest of the year. For example: The company has released its first quarterly report, you can calculate the company's FCF's for the first 3 months. You will need to project the remaining 9 months of the year to complete the total year. We will come back to this. Once all year years and any partial years are calculated you should show them in a row to get a look at how much they are increasing or decreasing. For example: 2009 2010 2011 2012 (9 months) 10000 11000 12000 9750 In real life you will not see numbers this accurate; this is to make the calculation easier. Now we have to calculate the last 3 months of cash flows for year 2012. If you watch the trend you can assume another 3250 in this calculation, but when the numbers are not so obvious we will have to project the rest of the cash flows. This is subject to creativity and is more of an art. You could simply do as I did above by taking a percentage of the existing FCF's and apply the left over 33% from the 9750. This is a fair projection as the company has proven to make that amount this year and as long as no news affecting earnings have come out it is a reasonable assumption. This is to finish the final year. 18 Brock Finance & Investment Group EQUITY DESK MANUAL 7. Now that we have the 2012 year completed of $13,000 in FCF we need to project the future 10 years of cash flows. We project the next 10 years, because we would like to have a longer term outlook to find a true value for the stock today. Try to ignore the fact that this company has been rising by $1000 every year and imagine you could not make the numbers out. We need to apply the industry's growth rate to project future cash flows. Using the rate alone is not an accurate judgment. For example, if you are investing in a big player in the industry their FCF's may not grow as fast, because they do not have much room to grow larger. Another example would be a high growth smaller company that is taking market share fast, they should have a higher than industry growth rate. This is subject to knowledge about the company and the industry. For simplicity in the following calculation we will use the industry growth rate we calculated earlier. ( ) Latest FCF - Is the latest year whether a portion is projected or not. r - The growth rate for the industry in this case (subject to change with company and industry knowledge) For example: 13000 * (1 + .049) = 13637 This gives us year 2013 FCF projections. You will project the next ten years of cash flows in excel. *This FCF projection is based on the margins of the business staying the same (ex. no COGS increases). 8. Now that we have projected our cash flows we need to calculate a terminal value for the business. This is done by taking the last cash flow growing it by a perpetual growth rate into the future. We need to add the terminal value, because the company is not finished after the 10 years of cash flows. After the 10th year there will be more cash flows assuming the business is still in operations. Calculate terminal value as follows: ( ( ) ) TV - This is the terminal value of the business. This is all the cash flows projected past the 10th year of future cash flows. This number will always be a significant portion of your total value of the business. It is very sensitive to the projected growth rate into the future. Always be very conservative with this number, using the 10 year bond yield or the current GDP growth rate is a fair assumption. Although the company should grow cash flows at a faster rate this will ensure that you are giving a very conservative value for the business. g – This is the growth rate in perpetuity after the 10th year cash flow. This rate is very sensitive. 19 Brock Finance & Investment Group EQUITY DESK MANUAL WACC – Weighted Average Cost of Capital is the discount rate you are discounting the future cash flows of the business by. The full description is in note 4. *Remember the terminal value will be a great deal larger than the sum of the projected cash flows. 9. The next step is to discount the terminal value and all the future cash flows of the business back to present value. We need to discount the cash flows back, because those cash flows will be worth less today than in the future. For the terminal value: ( ) *We use 10 for our period because the TV is based on the last year’s cash flows so we would need to bring it back for the 10 years we projected the cash flows. Next we discount each individual cash flow back to present value. This is done in excel and the formula is copied down the list of cash flows: ( ) n - This is the period for each cash flow. For example, year 2 cash flows n = 2, and for year 9 of cash flows n = 9. *In excel you will be able to project the cash flows individually Add all the present value cash flows and the present value terminal value to get the company's enterprise value. 10. Now that you have the enterprise value, subtract net debt from it. This will give you the company's equity value, ultimately what you are purchasing as a common shareholder. Divide the equity value by the diluted shares outstanding and you will have a per share intrinsic value for the business. You can now make an investment decision based on the quantitative research you have performed. 20 Brock Finance & Investment Group EQUITY DESK MANUAL Submitting Report for Review All of the sections mentioned should be in the report with clear headers. The report should not contain syntax, spelling or grammar errors as they may be shown to faculty and employers. The reports should also contain a table of contents and should have a recommendation of what price to buy it at and what our target price is and how many shares. The report should also include a method for ongoing review. Developing Shareholder Presentation The majority of presentation will be taking place during the weekly general meetings. A copy of the report should be given to each executive member for review 2 days at most before the presentation. Within that time frame the executive team will investigate the validity of the report along with several ideal issues that will be discussed. These things may include a bankruptcy analysis, a debt analysis and an acquisition or merger. There will also be an analysis regarding the weight allocation of the portfolio if necessary. If the investment proposal is time sensitive, a report with a recommendation should be sent out to all shareholders for a vote. Shareholders will then have 24 hours to respond with an answer. 21 Brock Finance & Investment Group EQUITY DESK MANUAL Sources 1 Joshua Rosenbaum, J. P. (2009). Investment Banking: Valuation, Leveraged Buyouts, and Mergers & Acquisitions. Hoboken, New Jersey: Wiley & Sons Inc. 2 Merriam-Webster. (2013). Investopedia. Retrieved from http://www.investopedia.com/dictionary/#axzz2IAhX5Mao 22
© Copyright 2024