Dcf Errors

In: Other Topics

Submitted By mayankanand
Words 5194
Pages 21


March 16, 2006

Michael J. Mauboussin

Common Errors in DCF Models
Do You Use Economically Sound and Transparent Models?
Discounted cash flow analysis is the most accurate and flexible method for valuing projects, divisions, and companies. Any analysis, however, is only as accurate as the forecasts it relies on. Errors in estimating the key ingredients of corporate value . . . can lead to mistakes in valuation. Tim Koller, Marc Goedhart, and David Wessels Valuation: Measuring and Managing the Value of Companies 1

A Return to First Principles mmauboussin@lmfunds.com Say you had to come up with a fair offer to buy your local dry cleaner and the seller limited the extent of your financial information to the answers to five questions. Which questions would you ask? Chances are you wouldn’t ask how the quarter is progressing or about last year’s earnings, but you would focus on the prospects for cash coming in versus cash going out over time. Sole proprietors understand intimately that the value of their business hinges on the cash flow the business generates. No distributable cash, no value. Cash puts food on the table and pays the mortgage; earnings do not. Equity investors are business buyers. While most shareholders own only a small fraction of a company, they are owners nonetheless. The source of shareholder value, and value changes, is no different than the sole proprietor’s: it’s all about the cash. Most investors don’t think this way. In part, this is because market exchanges readily allow investors to trade cash today for claims on future cash flows, and vice versa, encouraging them to forget they are evaluating, buying, and selling businesses. Yet investors, as opposed to speculators, should never lose sight of their objective: buying a stream of cash flows for less than what it is worth. Given that cash inflows…...

Similar Documents

Error Management

...ERROR MANAGEMENT Error Management Cassandra Galarneau June 1, 2013 BCOM/275 Morris Polston Abstract When faced with having to manage errors, an immediate and organized response is of the utmost importance. Following company protocols will aid in controlling and rectifying the situation at hand. Communicating the facts surrounding the incident will provide the needed assistance in managing the issue, decreasing down-time and maintaining safety. Utilization of safety protocols will protect the employees involved and reduce the risk to outside vendors and the general public. My actions and reactions to this problem can have a positive or negative impact on the final outcome. Error Management As a plant manager that has just learned a mistake has been made in the release of quarantined products, it is my responsibility to act in a professional, responsible and communicative manner. My decisions must be timely, expeditious and intuitive. “Being decisive in a crisis can mean the difference between success and failure” (Claiborne, 2011). I must take into consideration such issues as: Why did this happen? How did it transpire? When did it occur? What must be changed to ensure this will not happen in the future? How can this situation be controlled so our company does not lose the clients’ respect and trust? A situation such as this can make or break my future with this company. I will base my decisions and actions on what is best for the company, the......

Words: 854 - Pages: 4

Medication Errors

...In the 1999 research studies began to review the problem of medical errors and how they occurred. Studies and reports, such as the Institute of Medicine IOM report in 1999, strongly suggest that most medical errors are related to systems and processes and not individual negligence or misconduct. The IOM report recommended that the key to addressing medical errors is to focus on improving the processes used to deliver healthcare and not placing blame on the individuals involved. Approximately 1.3 million people are injured annually in the United States following "medication errors". The FDA defines a medication error as “any preventable event that may cause or lead to inappropriate medication use or harm to a patient”. The U.S. Food and Drug Administration (FDA) currently review medication error reports that come from drug manufacturers and through Med Watch, the agency's safety information and adverse event reporting program. The agency also receives reports about medication errors from the Institute for Safe Medication Practices (ISMP) and the U.S. Pharmacopeia. Some things the FDA has put into place to prevent medication errors: * Drug Name Review: To minimize drug name confusion, FDA reviews about 400 drug names a year that companies submit as proposed brand names. The agency rejects about one-third of the names that drug companies propose. * Drug Labels: FDA regulations require all over-the-counter (OTC) drug products (more than 100,000) to have a......

Words: 896 - Pages: 4

Excel Errors

...2. Spreadsheet Errors: What we think we can do What we know? 1. What are the leading causes of Spreadsheet errors? The leading causes of spreadsheet errors are a) Human incapability of doing complex cognitive tasks with accuracy, this is a limitation in human capability and this contributes partly to the errors that are caused in spreadsheets b) Lack of disciplined development practices is one of the most common reasons why spreadsheet contains errors. Many organization has policies in general about end user development in general, much less spreadsheet development c) Many developers build the models and hardwire it to one end result they are working without considering the constraints or different possible scenarios. This ultimately leads to the fact that the model doesn’t work for any other input variables other than the one that is being used to. d) Another common reason of spreadsheet errors is due to the overconfidence of the developers in the accuracy of the spreadsheets. They don’t spend time to test the spreadsheet for any possible errors e) We could also say innocence (in a sense of not knowing the excel capabilities) as one of the common reasons why spreadsheets has errors, people tend to learn from friends and coworkers without any proper training on Excel and its capabilities which ultimately lead in unstructured spreadsheet development 2. Why these errors are typically not detected? a)......

Words: 1657 - Pages: 7

Errors in Communcation

...All three critical errors in communication identified by Hynes are correct in all types of work environments. Communication is the key to success, I believe that without a critical understanding a person cannot function or proceed to their daily operations. As an assistant manager at Wal-Mart, I deal with all of the three critical errors. Out of the three critical errors in communication I deal with the most at work has to be the assumption observation error. As an assistant manager, I have to plan out what to do with the items that are coming in on the trucks daily. The items can range from anywhere being hundreds to thousands items per day. I have to plan where to put the items with my other managers and department managers. The easiest way to plan is to get a print out of a truck listing that breaks down the items by departments. Then, we delegate the listing by departments to each individual department manager; for example: I give the electronics items listing to the electronics department manager and he or she gives me feedback on where to put the item. Then we have an afternoon meeting to type what items will go where, when it is unloaded from the truck. The assumption observation error comes into play when the overnight manager uses the information given to him or her on where to put the item. Usually all the trucks get the items unloaded by 7 pm and the employees start taking the items out at 9 pm, since it is less customer traffic at that time. Even with all the......

Words: 401 - Pages: 2

Medication Errors

...My involvement in the drug error is as follows. I was working on the night shift as the only qualified nurse with 2 nursing assistants. The late shift decided to administer the 10pm medications as a way of helping me. This however was key in me making the error that I did. If I had been left to do the 10pm medications by myself, this error would not have occurred. Patient PF was given her medication by the late staff, however she had spat them out. On going to give her these again, I also repeated her liquid medication which she had actually taken with the late shift before she spat out her tablets. PF took half the liquid before giving it back to me saying that she had already taken it and it was just her tablets that she didn’t take. She accepted the tablets no problem from me. I checked the BNF to see limits of medication and knew the extra that she had was well within the maximum dose. I also knew that she was not naive to medication and had been taking this medication for some time without any adverse effects. I checked her observations and BP, pulse and temp were all within normal limits. I continued with getting the other ladies ready for bed and carried on with my regular night time duties and once the ward was settled I filled in the datix form to report the error. It was at this time that I realised I should have notified someone earlier of the error. I contacted the AMART team as it was my understanding that they triage the calls to the duty doctor overnight. I...

Words: 496 - Pages: 2

Under Armour Dcf

...Comparables | P/E | P/S | P/B | Stock Price | Under Armour | 71.60 | 5.03 | 11.81 | 70.00 | Jarden | 62.29 | 1.58 | 3.3 | 66.78 | Finish Line | 16.26 | 0.68 | 2.01 | 28.45 | I have chosen Jarden and Finish Line as companies to compare to Under Armour as the industry average. I believe that these companies will be good choices because they provide similar products in the Athletic Apparel and Shoe industry. As a whole, Under Armour compares very favorable to the rest of the industry. On average, its ratios are approximately five times higher than the ratios of Finish Line and it has more impressive ratios in Jarden as well. This is due to the widespread success of their increased influence in the Outdoor Sporting Apparel. For this DCF model I used a 5-year growth rate of 14.86%, with a 6% growth rate for the sixth (as was requested). The 14.86 percent growth rate was determined because after researching, according to Guru Focus, most companies’ short term growth rate is between 8.35 and 17.74 percent. I chose 14.86 because I wanted to signify that Under Armour is still growing at a high rate, but did not want to risk overinflating my stock evaluation. To calculate the projected FCF, I took Under Armour’s Free Cash Flow average over the past five years. To find this I took UA’s Cash Flow from Operations and subtracted out its capital expenditures (James Madison University). I then took this number and had it grow yearly by the previously stated growth rate. By......

Words: 546 - Pages: 3

Aging Out of Dcfs

...or neglect, and were placed into the Child Welfare System may experience difficult challenges upon emancipation. Comprehensive research suggest that the development of a secure attachment in the first two years of life is related to effective emotional regulation, and higher sociability with adults and peers ( Pearce and Pezzot-Pearce, 2001). According to the U.S Department of Health and Human Services, Administration for Children and Families, “aging out”, the system reports that once a Ward turns eight or twenty-one; regardless if they have developed all the skills and tools imperative for survival, they are no longer under the systems care. Christy Gutowski (2012) an editor from the Chicago Tribune reported that prior to emancipation, DCFS pushes for older wards to move quickly towards Transitional Living Programs even if they have not developed the social/environmental skills to live independently. This has become increasingly problematic because most of these young adults continue to depend on others and need continued support as they transition to adulthood. According to Pottick et al. (2008), between 25,000 and 30,000 youth age out of the Child Welfare System annually in the Untied States. At least 70% of those individuals have been diagnosed with Sever Mental Health Conditions. As a result of these traumatic experiences, many of these young adult, will be diagnosed with sever mental health conditions. Post- traumatic stress disorder, Attention......

Words: 1801 - Pages: 8

Medication Error

...process in improving patient care and safety during hospitalization. Medication-related errors are serious and occur at a rate of about one per patient per day (Allan, 1990). It is a harmful practice affecting patient’s health and life. Some of these errors may result in death or inefficiency of organs functions. In addition, medication errors may financially affect the health care organization due to long patient stay in the hospital for advanced treatment (Presto, 2004). This research paper will provide highlights on medication errors definition, importance of safety during medication process, factors contributing to medication errors and effective factors in preventing medication errors. Medication errors were defined as a fault in medication that may occur at any stage of the process in ordering or delivering medications (Bates, Boyle, Vliet, Scheider & Leape, 1995), either an injury occurred or the potential for injury was present (Bates et al, 1999). These errors could occur in dosing error, which is common (Lesar, Briceland & Stein, 1997), or wrong route, or wrong time, or error in medicine rate and omission error (O’Shea, 1998). Also there are some situations such as missing a dose of medication or the correct medication given too many times to the patient. Both of these situations are considered as medication error (Bates, Boyle, Vliet, Schneider & Leape, 1995). These errors can happen anywhere, it can occur at home, pharmacies and hospitals or doctor’s......

Words: 2061 - Pages: 9

Dcf Tutorial

...should always strive to challenge our beliefs through a feedback mechanism. To test our existing constructs with new potentially better ones. It is with this in mind that we explore the classic or naive discounted cash flow modelling techniques. 1 Introduction The essential steps for a DCF are: 1. Gather information: Use historic Income, Balance Sheet & Cash Flow Statements to calculate ‘earnings’, ‘cash flows’ or any other variable you’re trying to obtain data for, 2. Generate Forecast Assumptions: based on our historical observations generate a starting cash flow range, growth rate and discount rate assumptions . . . 3. Actually forecast earnings/EBITDA, cash flows etc. Keep in mind earning/cash flow forecasts must be linked to the underlying asset base. ROC, ROA, ROE cross-checks should be consistent with competitive industry foreces. 4. Discount the cash flows/earnings to generate a valuation estimates, 5. Perform sensitivity analysis (usually altering growth rates and discount rates). However, to decrease forecasted errors terms concentrate on likely cash flow ranges both at t1 and tn . Be mindful of your starting point t1 cash flows. For our class we will focus on DCF to the firm and to equity holders. Other approaches include: dividend discount, adjusted present value, economic value added, HOLT process, residual income and Monte Carlo based direct cash flow models, are alternative approaches. Background To facilitate communicating the essential......

Words: 3461 - Pages: 14

Dcf Analysis

...DCF analysis The value of a company today, based on how much money it’s going to make in the future Dividend discount model (DDM) Free cash flow to equity – determine the fair value of companies One must consider * Future sales growth, profit margins * Discount rate – depends on a risk-free interest rate 1. Forecast period & forecasting revenue growth * How far we should project cash flows * Excessive return period * One can guess based on the company’s competitive and market position Company competitive position * 1 year: * Slow-growing company * Operates in highly competitive, low margin industry * 5 years: * Solid company * Operates with advantage such a strong marketing channels, recognizable brand name, or regulatory advantage * 10 years: * Outstanding growth company * Operates with very high barriers to entry, dominant market position or prospects Revenue growth also depends on * Whether the company’s market is expanding or contracting * How its market share is performing Look historically - Example: The company has grown revenue at 20% for the past two years It could decrease over time as a result of increasing international competition and industry commoditization 20% for the first two years 15% for the next two years 10% for the last year 2. Forecasting Free Cash Flows * Estimate the free cash flow * The cash that through a......

Words: 598 - Pages: 3

Accounting Errors

...The Accounting Errors of Overstock.com In 2008, the companyOverstock.com (NASDAQ: OSTK) received some publicity when they made decisions that violate the Generally Accepted Accounting Principles (GAAP). Their internal accounting policies and their relationship with external auditors caused the company to have to restate their financial statements dating back to 2003. Overstock.com improperly took income that it earned but under-billed its fulfillment partners during earlier reporting periods (Q3 2008 and earlier) and moved the income to future reporting periods (Q4 2008, Q1 2009, Q2 2009, and Q3 2009). Basically, Overstock.com took the income that they should have reported in earlier reporting periods (Q3 2008 and before) and moved it to future reporting periods (Q4 2008 and later). This action materially overstated their financial performance in later reporting periods. “Overstock.com admitted that they “incorrectly amortized the expense related to restricted stock units based on the actual three year vesting schedule rather than a three year straight line amortization and applied an outdated forfeiture rate in calculating its expense under the plans.” Accounting errors are not unusual for a business. When an accounting error occurs that is at the level of the error of Overstock.com, it is an indication that involves some high-level company officials may be involved. The responsibility of the accounting department is to provide managers and investors with the...

Words: 1193 - Pages: 5

Dcf Solution

...1. DCF Year sales COGS SGA D EBIT EBIT after tax D CAPEX Inventory A/R A/p NWC change in NWC FCF TV DFCF EV 95.55 0 55.3 37.9 12.3 2.1 3.0 2.2 2.1 2.3 18.0 6.6 1.2 23.4 2 57.5 37.4 9.8 1.8 8.6 6.2 1.8 2.4 3 58.7 38.1 10.0 1.8 8.7 6.3 1.8 2.5 4 59.9 38.9 10.2 1.9 8.9 6.4 1.9 2.5 22.6 -0.8 6.3 23.0 0.5 5.1 23.5 0.5 5.2 5.9 1.9 1 56.4 36.7 9.6 1.7 8.4 6.1 1.7 2.4 5.1 5.2 23.9 0.5 5.3 122.7 5.3 117.2 acquisition price Shares outstanding Debt Cash 5.71 22.8 52.3 8.15 3.3 7.1 11.2 11.1 13.4 5.25 7.2 4.8 2.95 54.6 8.6 Premium offer price 37% 75.8 1. DCF Year sales COGS 0 55.3 37.9 36 2.7 2.5 2.9 1.6 Net debt EV 16.3 146.488 4.4 31.295 10.9 135.22 1.9 39.7 7 168.07 1 56.4 36.7 2 57.5 37.4 3 58.7 38.1 4 59.9 38.9 SGA D EBIT EBIT after tax D CAPEX Inventory A/R A/p NWC change in NWC FCF TV DFCF EV 12.3 2.1 3.0 2.2 2.1 2.3 18.0 6.6 1.2 23.4 58.3 12.7 1.8 5.7 5.7 0.1 2.4 12.9 1.8 5.8 5.8 0.1 2.5 13.2 1.9 5.9 5.9 0.1 2.5 22.6 -0.8 4.1 23.0 0.5 2.9 23.5 0.5 2.9 3.8 1.9 12.4 1.7 5.6 5.6 0.1 2.4 2.9 2.9 23.9 0.5 3.0 60.0 3.0 Assumptions: Growth rate slaes COGS/SALES SGA/SALES WACC D/SALES Tax rate Capex/sales NWC/SALES Growth rate slaes 2% 65% 17% 6.40% 3.10% 28% 4.20% 40% 2.00%......

Words: 503 - Pages: 3

Capm Dcf

...sdf Calculating Returns: CAPM vs. DCF Kalen Hickey American Military University The Capital Asset Pricing Model (CAPM) and Discounted Cash Flows Method are different techniques for determining returns on an investment. These concepts deal with the time value of money and the other investment factors. “If decisions are made that ignore the interaction of scale and risk, then cash flows are misvalued and suboptimal operations decisions are made” (Lederer & Mehta). Companies use CAPM and DCF to figure out the greatest potential for highest yield of an investment based on average market returns. The Capital Asset Pricing Model (CAPM) takes the two factors of time value of money and market risk into account for determining risk of investment and returns. “One is the risk of being in the market which is called systematic risk. The other-unsystematic risk-is specific to a company’s fortunes” (Burton, p.20). The two risks are married together, otherwise one would expect to see a positive return on every risk which is never the case. The expected rate of return for the CAPM takes into account risk-free interest rate, a stock beta that determines the relationship between the entire market and an individual investment, and an expected return from a typical market such as the Dow Jones. “The formula states that the expected return of a stock is equal to the risk-free rate of interest, plus the risk associated with all common stocks (market premium risk), adjusted......

Words: 654 - Pages: 3

Fi512 Dcf Valuation Assignment

...1. [DCF Valuation and Ownership Concepts] The venture investors and founders of ACE Products, a closely held corporation, are contemplating merging the successful venture into a much larger diversified firm that operates in the same industry. ACE estimates its free cash flows that will be available to the enterprise next year at $5,200,000. Since the venture is now in its maturity stage, ACE’s free cash flows are expected to continue to grow at a 6 percent annual compound growth rate in the future. A weighted average cost of capital (WACC) for the venture is estimated at 15 percent. Interest-bearing debt owed by ACE is $17.5 million. In addition, the venture has surplus cash of $4 million. ACE currently has five million shares outstanding, with three million held by venture investors and two million held by founders. The venture investors have an average investment of $2.50 per share while the founders’ average investment is $.50 per share. A. Based on the above information, estimate the enterprise value of ACE Products. What would be the value of the venture’s equity? According to Chapter 9 of the text: the current value of a growing perpetuity is the next period’s cash flow (VCFT) divided by the spread between the assumed constant discount (r∞) and growth (g) rates: Enterprise operating value would equal: Enterprise next year at $5,200,000/ (WACC for the venture is estimated at 15 percent - expected to continue to grow at a 6 percent) 5,200,000 / (...

Words: 1755 - Pages: 8

Dcf Theory

...DCF теория (статья написана для D')  В соответствии с DCF (модель дисконтированных денежных потоках), справедливая стоимость компании равна всем денежным средствам, которые эта компания сгенерирует за все время своего существования. Эти денежные средства называются денежным потоком. Но мало знать, какой будет денежный поток. Дело в том, что 100 рублей, получаемые через год, для инвестора не равны 100 рублям, которые у него есть сейчас.  Ведь разумный человек, имея эту сумму, может положить ее в банк и получить за этот самый год еще и процентный доход. Пусть положить деньги можно под 12%. Тогда 100 рублей, которые инвестор получит через год, равны = 100/(100%+12%) = 89,29 сегодняшних рублей (или наоборот, 89,29 рублей сегодня*1.12 = 100 через год). То, что мы сделали, чтобы определить, сколько сейчас стоят 100 рублей, получаемых через год, называется дисконтированием, а 12% — ставкой дисконтирования. Так как нам нужно узнать, сколько составляет справедливая стоимость предприятия сейчас, придется весь получаемый денежный поток привести к сегодняшним деньгам — дисконтировать. Формула дисконтирования:   q – это ставка дисконтирования, CF – денежный поток в i-м году.   Таблица 1 Дисконтирование денежных потоков за пять лет   Годы Всего Текущий (0) +1 +2 +3 +4 +5 Денежный поток 100 105 110 115 120 125   Ставка дисконтирования q=10%   Дисконтный......

Words: 539 - Pages: 3