deck_4629073-DCF

Question 1

What is the basic concept behind a Discounted Cash Flow Analysis?

Answer 1

• The concept is that you value a company based on the present value of its Free Cash Flows far into the future.• You divide the future into a “near future” period of 5-10 years and then calculate, project, discount, and add up those Free Cash Flows; and then there’s also a “far future” period for everything beyond that, which you can’t estimate as precisely, but which you can approximate using different approaches.• You need to discount everything back to its present value b/c money today is worth more than money tomorrow.

Question 2

Walk me through a DCF.

Answer 2

• A DCF values a company based on the present value of its Cash Flows and the present value of its Terminal Value.• First, you project a company’s financials using assumptions for revenue growth, margins, and the Change in Operating Assets and Liabilities; then you calculate FCF for each year, which you discount and sum up to get to the NPV. The Discount Rate is usually the WACC.• Once you have the present value of the FCFs, you determine the company’s Terminal Value, using either the Multiples Method or the Gordon Growth Method, and then you discount that back to its NPV using the Discount Rate.• Finally, you add the two together to determine the company’s Enterprise Value.

Question 3

Walk me through how you get from Revenue to Free Cash Flow in the projections.

Answer 3

• First, confirm that they are asking for Unlevered FCF (FCF to Firm). If so:• Subtract COGS and Operating Expenses from Revenue to get to Operating Income (EBIT) - or just use the EBIT margin you’ve assumed.• Then, multiply by (1 - Tax Rate), add back D&A and other non-cash charges, and factor in the Change in Operating Assets and Liabilities. If Assets increase by more than Liabilities, this is negative; otherwise, it’s positive.• Finally, subtract CapEx to calculate Unlevered FCF.• Levered FCF is similar, but you must also subtract the Net Interest Expense before multiplying by the (1 - Tax Rate), and you must also subtract Mandatory Debt Repayments at the end.

Question 4

What’s the point of Free Cash Flow anyway? What are you trying to do?

Answer 4

• The idea is that you’re replicating the SCF but only including recurring, predictable items. And in the case of Unlevered FCF, you also exclude the impact of Debt entirely.• That’s why everything in CFI except for CapEx is excluded, and why the entire CFF is excluded (the only exception being Mandatory Debt Repayments for Levered FCF).

Question 5

Why do use 5 or 10 years for the “near future” DCF projections?

Answer 5

That’s about as far as you can reasonably predict for most companies. Less than 5 years would be too short to be useful, and more than 10 years is too difficult to project for most companies.

Question 6

Is there a valid reason why we might sometimes project 10 years or more anyway?

Answer 6

You might sometimes do this if it’s a cyclical industry, such as chemicals, b/c it may be important to show the entire cycle from low to high.

Question 7

What do you usually use for the Discount Rate?

Answer 7

• In an Unlevered DCF analysis, you use WACC, which reflects the “Cost” of Equity, Debt, and Preferred Stock.• In a Levered DCF analysis, you use Cost of Equity instead.

Question 8

If I’m working with a public company in a DCF, how do I move from Enterprise Value to Implied per Share Value?

Answer 8

• Once you get to Enterprise Value, ADD Cash and then SUBTRACT Debt, Preferred Stock, and Noncontrolling Interests (and any other debt-like items) to get to Equity Value.• Then you divide by the company’s share count (factoring in all dilutive securities) to determine the implied per-share price.

Question 9

Let’s say we do this [move from Enterprise Value to Implied per Share Value for a public company] and find that the Implied per Share Value is $10. The company’s current share price is $5. What does this mean?

Answer 9

• By itself, this does not mean much - you have to look at a range of outputs from a DCF rather than just a single number. So you would see what the Implied per Share Value is under different assumptions for the Discount Rate, revenue growth, margins, and so on.• If you consistently find that it’s greater than the company’s current share price, then the analysis might tell you that the company is undervalued; it might be overvalued if it’s consistently less than the current share price across all ranges.

Question 10

An alternative to the DCF is the Dividend Discount Model (DDM). How is it different in the general case (i.e. for a normal company, not a commercial bank or insurance firm?)

Answer 10

• The setup is similar: you still project revenue and expenses over a 5-10 year period, and you still calculate Terminal Value.• The difference is that you do NOT calculate FCF - instead, you stop at NI and assume that Dividends Issued are a percentage of NI, and then you discount those Dividends back to their present value using the Cost of Equity.• Then, you add those up and add them to the present value of the Terminal Value, which you might base on a P/E multiple instead.• Finally, a Dividend Discount Model gets you the company’s Equity Value rather than its Enterprise Value since you’re using metrics that include interest income and expense.

Question 11

Is it always correct to leave out most of the Cash Flow from Investing section and all of the Cash Flow from Financing section?

Answer 11

• Most of the time, yes, because all items other than CapEx are generally non-recurring, or at least do not recur in a predictable way.• If you have advance knowledge that a company is going to sell or buy a certain amount of securities, issue a certain amount of stock, or repurchase a certain number of shares every year, then sure, you can factor those in. But it’s extremely rare to do that.

Question 12

Why do you add back non-cash charges when calculating Free Cash Flow?

Answer 12

For the same reason you add them back on the SCF: you want to reflect the fact that they save the company on taxes, but that the company does not actually pay the expense in cash.

Question 13

What’s an alternate method for calculating Unlevered Free Cash Flow (Free Cash Flow to Firm)?

Answer 13

There are many “alternate” methods - here are few common ones:• EBIT * (1 - Tax Rate) + Non-Cash Charges - Changes in Operating Assets & Liabilities - CapEx• CFO + Tax-Adjusted Net Interest Expense - CapEx• NI + Tax-Adjusted Net Interest Expense + Non-Cash Charges - Changes in Operating Assets and Liabilities - CapEx• NOTE: The difference with these is that the tax numbers will be slightly different as a result of when you exclude the interest.

Question 14

What’s an alternate method to calculate Levered Free Cash Flow?

Answer 14

• NI + Non-Cash Charges - Changes in Operating Assets & Liabilities - CapEx - Mandatory Debt Repayments• (EBIT - Net Interest Expense) * (1 - Tax Rate) + Non-Cash Charges - Changes in Operating Assets & Liabilities - CapEx - Mandatory Debt Repayments• CFO - CapEx - Mandatory Debt Repayments

Question 15

As an approximation, do you think it’s OK to use (EBITDA - Changes in Operating Assets & Liabilities - CapEx) to approximate Unlevered Free Cash Flow?

Answer 15

• This is inaccurate b/c it excludes taxes completely. It would be better to use EBITDA - Taxes - Changes in Operating Assets & Liabilities - CapEx.• If you need a very quick approximation, yes, this formula can work and it will get you closer than EBITDA by itself. But taxes are significant and should not be overlooked.

Question 16

What’s the point of that “Changes in Operating Assets and Liabilities” section? What does it mean?

Answer 16

• All it means is that if Assets are increasing by more than Liabilities, the company is spending cash and therefore reducing its cash flow, whereas if Liabilities are increasing by more than Assets, the company is increasing its cash flow.• For example, if it places a huge order of Inventory, sells products, and records revenue, but hasn’t received the cash from customers yet, Inventory and A/R both go up and represent uses of cash.• Maybe some of its Liabilities, such as A/P and Deferred Revenue also increase, but think about what happens: if the Assets increase by, say, $100, and the Liabilities only increase by $50, it’s a net cash flow reduction of $50.• So that is what this section is for - we need to take into account the cash changes from these operationally-linked B/S items.

Question 17

What happens in the DCF if Free Cash Flow is negative? What if EBIT is negative?

Answer 17

• Nothing “happens” b/c you still run the analysis as-is. The company’s value will certainly decrease if one or both of these turn negative, b/c the present value of FCF will decrease as a result.• The analysis is not necessarily invalid even if cash flow is negative - if it turns positive after a point, it could still work.• If the company never turns cash flow-positive, then you may want to skip the DCF b/c it will always produce negative values.

Question 18

Let’s say that you use Levered Free Cash Flow rather than Unlevered Free Cash Flow in your DCF - what changes?

Answer 18

Levered FCF gives you Equity Value rather than Enterprise Value, since the cash flow is only available to Equity Investors (Debt Investors have already been “paid” with the interest payments and principal repayments).

Question 19

If you used Levered Free Cash Flow, what should you use as your discount rate?

Answer 19

You would use Cost of Equity rather than WACC since we’re ignoring Debt and Preferred Stock and only care about the Equity Value for Levered FCF.

Question 20

• Let’s say that you use Unlevered Free Cash Flow in a DCF to calculate Enterprise Value. Then, you work backwards and use the company’s Cash, Debt, and so on to calculate its implied Equity Value.• Then you run the analysis using Levered Free Cash Flow instead and calculate Equity Value at the end. Will the implied Equity Value from both these analyses be the same?

Answer 20

• No, most likely it will not be the same. In theory, you could pick equivalent assumptions and set up the analysis such that you calculate the same Equity Value at the end.• In practice, it’s difficult to pick “equivalent” assumptions, so these two methods will rarely, if ever, produce the same value.• Think about it like this: when you use Unlevered FCF and move from Enterprise Value to Equity value, you’re always using the same numbers for Cash, Debt, etc.• But in a Levered FCF analysis, the terms of the Debt will impact FCF - so simply by assuming a different interest rate or repayment schedule, you’ll alter the Equity Value. That’s why it’s difficult to make “equivalent assumptions.”

Question 21

How do you calculate WACC?

Answer 21

• WACC = Cost of Equity * (% Equity) + Cost of Debt * (1 - Tax Rate) * (% Debt) + Cost of Preferred Stock * (% Preferred)• In all cases, the percentages refer to how much each component comprises of the company’s capital structure.• For Cost of Equity, you can use CAPM and for the others you usually look at comparable companies and comparable debt issuances and the interest rates and yields issued by similar companies to get estimates.

Question 22

How do you calculate Cost of Equity?

Answer 22

• Cost of Equity = Risk-Free Rate + Equity Risk Premium * Levered Beta• The Risk-Free Rate represents how much a 10-year or 20-year US Treasury (or equivalent “safe” government bond in your own country) should yield; Beta is calculated on the “riskiness” of Comparable Companies and the Equity Risk Premium is the percentage by which stocks are expected to out-perform “risk-less” assets like US Treasuries.• Normally, you pull the Equity Risk Premium from a publication called Ibbotson’s• NOTE: Depending on your bank and group, you might also add in a “size premium” and “industry premium” to account for additional risk and expected returns from either of those. • Small-cap stocks are expected to out-perform large-cap stocks and certain industries are expected to out-perform others, and these premiums reflect these expectations.

Question 23

Cost of Equity tells us the return that an equity investor might expect for investing in a given company - but what about dividends? Shouldn’t we factor dividend yield into the formula?

Answer 23

Trick question. Dividend yields are already factored into Beta, because Beta describes returns in excess of the market as a whole - and those returns include Dividends.

Question 24

How can we calculate Cost of Equity WITHOUT using CAPM?

Answer 24

There is an alternate formula:• Cost of Equity = (Dividends per Share / Share Price) + Growth Rate of Dividends• This is less common than the “standard” formula but sometimes you use it when the company is guaranteed to issue Dividends (e.g. Utilities companies) and/or information on Beta is unreliable.

Question 25

How do you calculate Beta in the Cost of Equity calculation?

Answer 25

• First off, note that you don’t have to calculate anything - you could just take the company’s Historical Beta, based on its stock performance vs. the relevant index.• Normally, however, you come up with a new estimate of Beta based on the set of Public Comps you’re using to value the company elsewhere in the Valuation, under the assumption that your estimate will be more accurate.• You look up the Beta for each Comparable Company (usually on Bloomberg) un-lever each one, take the median of the set and then lever that median based on the company’s capital structure. Then you use this Levered Beta in the Cost of Equity calculation.• The formulas for un-levering and re-levering Beta are as follows:• Unlevered Beta = Levered Beta / (1 + [(1 - Tax Rate) x (Total Debt/Equity)])• Levered Beta = Unlevered Beta * (1 + [(1 - Tax Rate) x (Total Debt/Equity)])

Question 26

Why do you have to un-lever and re-lever Beta when you calculate it based on the comps?

Answer 26

• When you look up the Betas on Bloomberg (or whatever source you’re using) they will already be levered b/c a company’s previous stock price movements reflect the Debt they’ve taken on.• But each company’s capital structure is different and we want to look at how “risky” a company is regardless of what % debt or equity it has.• To do that, we need to un-lever Beta each time. We want to find the inherent business risk that each company has, separate from the risk created by Debt.• But at the end of the calculation, we need to re-lever the median Unlevered Beta of that set b/c we want the Beta used in the Cost of Equity calculation to reflect the total risk of our company, taking into account its capital structure this time as well.

Question 27

Would you still use Levered Beta with Unlevered Free Cash Flow? What’s the deal with that?

Answer 27

• They are different concepts (yes, the names get very confusing here). You always use Levered Beta with Cost of Equity b/c Debt makes the company’s stock riskier for everyone involved.• And you always use that same Cost of Equity number for both Levered FCF, where Cost of Equity itself is the Discount Rate, and also for Unlevered FCF, where Cost of Equity is a component of the Discount Rate (WACC).

Question 28

How do you treat Preferred Stock in the formulas above for Beta?

Answer 28

It should be counted as Equity there because Preferred Dividends are NOT tax-deductible, unlike interest paid on Debt.

Question 29

Can Beta ever be negative? What would that mean?

Answer 29

• Theoretically, yes, Beta could be negative for certain assets. If Beta is -1, for example, that would mean that the asset moves in the opposite direction from the market as a whole. If the market goes up by 10%, this asset would go down by 10%.• In practice, you rarely, if ever, see negative Betas with real companies. Even something labeled as “counter-cyclical” still follows the market as a whole; a “counter-cyclical” company might have a Beta of 0.5 or 0.7, but not -1.

Question 30

Would you expect a manufacturing company or a technology company to have a higher Beta?

Answer 30

A technology company, because technology is viewed as a “riskier” industry than manufacturing.

Question 31

Shouldn’t you use a company’s targeted capital structure rather than its current capital structure when calculating Beta and the discount rate?

Answer 31

• In theory, yes. If you know that a company’s capital structure is definitely changing in a certain, predictable way in the future, sure, go ahead and use that.• In practice, you rarely know this information in advance, so it’s not terribly practical to make this kind of assumption.

Question 32

The “cost” of Debt and Preferred Stock make intuitive sense because the company is paying for interest or for the Preferred Dividends. But what about the Cost of Equity? What is the company really paying?

Answer 32

The company “pays” for Equity in two ways:1. It may issue Dividends to its common shareholders, which is a cash expense.2. It gives up stock appreciation rights to other investors, so in effect it’s losing some of that upside - a non-cash but very real “cost.”• It is tricky to estimate the impact of both of those, which is why we usually use the Risk-Free Rate + Equity Risk Premium * Beta formula to estimate the company’s expected return instead.

Question 33

If a firm is losing money, do you still multiply the Cost of Debt by (1 - Tax Rate) in the WACC formula? How can a tax shield exist if they’re not even paying taxes?

Answer 33

This is a good point, but in practice you will still multiply by (1 - Tax Rate) anyway. What matters is not whether the Debt is currently reducing the company’s taxes, but whether there’s potential for that to happen in the future.

Question 34

How do you determine a firm’s Optimal Capital Structure? What does it mean?

Answer 34

• The “optimal capital structure” is the combination of Debt, Equity, and Preferred Stock that minimizes WACC.• There is no real way to determine this formulaically b/c you’ll always find that Debt should be 100% of a company’s capital structure since it’s always cheaper than Equity and Preferred Stock, but that can’t happen b/c all companies need some amount of Equity as well.• Plus, taking on additional Debt will impact the Cost of Equity and the Cost of Preferred, so effectively it is a multivariable equation with no solution.• You may be able to approximate the optimal structure by looking at a few different scenarios and seeing how WACC changes - but there’s no mathematical solution.

Question 35

Let’s take a look at companies during the financial crisis (or really, just any type of crisis or economic downturn). Does WACC increase or decrease?

Answer 35

• Break it down and think of the individual components of WACC: Cost of Equity, Cost of Debt, Cost of Preferred, and the percentages for each one. Then, think about the individual components of Cost of Equity: the Risk-Free Rate, the Equity Risk Premium & Beta.• The Risk-Free Rate would decrease b/c governments worldwide would drop interest rates to encourage spending; but then Equity Risk Premium would also increase by a good amount as investors demand higher returns before investing in stocks; Beta would also increase due to all the volatility; so overall, we can guess that the Cost of Equity would increase b/c the latter two increases would likely more than make up for the decrease in the risk-free rate.• Now for WACC, the Cost of Debt and Cost of Preferred Stock would both increase as it would become more difficult for companies to borrow money; the Debt to Equity ratio would likely increase because companies’ share prices would fall, meaning that Equity Value decreased for most companies while Debt stayed the same; so proportionally, yes, Debt and Preferred would likely make up a higher percentage of a company’s capital structure; but remember: the Cost of Debt and Cost of Preferred both increase, so that shift doesn’t matter too much; as a result, WACC almost certainly increases b/c almost all these variables push it up - the only that pushes it down is the reduced risk-free rate.• There’s a simpler way to think about it as well: all else being equal, did companies become more valuable or less valuable during the financial crisis? Less valuable - because the market discounted their future cash flows at a higher rates, so WACC must have increased.

Question 36

How do you calculate Terminal Value?

Answer 36

• You can either apply an exit multiple to the company’s Year 5 EBITDA, EBIT, or FCF (Multiples Method) or you can use the Gordon Growth Method to estimate the value based on the company’s growth rate into perpetuity.• The formula for Terminal Value using the Gordon Growth method: Terminal Value = Final Year FCF * (1 + Growth Rate) / (Discount Rate - Growth Rate)• Note that with either method, you’re estimating the same thing: the present value of the company’s FCF from the final year into infinity, as of the final year.

Question 37

Why would you use the Gordon Growth Method rather than the Multiples Method to calculate the Terminal Value?

Answer 37

• In banking, you almost always use the Multiples Method to calculate Terminal Value in a DCF. It’s easier to get appropriate data for exit multiples since they are based on Comparable Companies - picking a long-term growth rate involves more guesswork.• However, you might use Gordon Growth if you have no good Comparable Companies or if you believe that multiples will change significantly in the industry several years down the road. For example, if an industry is cyclical (e.g. chemicals or semiconductors) you might be better off using long-term growth rate rather than exit multiples.

Question 38

What’s an appropriate growth rate to use when calculating the Terminal Value?

Answer 38

• Normally you use the country’s long-term GDP growth rate, the rate of inflation, or something similarly conservative.• For companies in developed countries, a long-term growth rate over 5% would be quite aggressive since most developed economies are growing at less than 5% per year.

Question 39

How do you select the appropriate exit multiple when calculating Terminal Value?

Answer 39

• Normally you look at the Public Comps and pick the median of the set, or something close to it.• You always show a range of exit multiples and what the Terminal Value looks like over that range rather than picking one specific number.• So if the median EBITDA multiple of the set were 8x, you might show a range of values using multiples ranging from 6x to 10x.

Question 40

Which method of calculating Terminal Value will produce a higher valuation?

Answer 40

It’s impossible to say b/c it could go either way depending on the assumptions. There’s no general rule that always applies, or that even applies most of the time.

Question 41

Can you explain the Gordon Growth formula in more detail? I don’t need a full derivation, but what’s the intuition behind it?

Answer 41

• Terminal Value = Final Year FCF * (1 + Growth Rate) / (Discount Rate - Growth Rate)• Here’s the intuition behind it: Let’s say that we know for certain that we’ll receive $100 every year indefinitely, and we have a required return of 10%.• That means we can “afford” to pay $1000 now ($100/10%) to receive $100 in Year 1 and $100 in every year after that forever.• But now let’s say that the stream of $100 were actually growing each year - if that’s the case, then we could afford to invest more than the initial $1000.• Let’s say that we expect the $100 to grow by 5% every year - how much can we afford to pay now to capture all those future payments, if our required return is 10%?• Well that growth increases our effective return, so now we can pay more and still get the same 10% return. We can estimate the $100 by (10% - 5%). 10% is our required return and 5% is the growth rate. So in this case, $100 / (10% - 5%) = $2000.• This corresponds to the formula above: $100 represents Final Year FCF * (1 + Growth Rate), 10% is the Discount Rate, and 5% is the Growth Rate.• The higher the expected growth, the more we can afford to pay upfront. And if the expected growth is the same as the required return, theoretically, we can pay an infinite amount (you get a divide by zero error in the equation) to achieve that return.

Question 42

What’s the flaw with basing the Terminal Multiple on what the Public Comps are trading at?

Answer 42

The median multiples may change greatly in the next 5-10 years, so they may no longer be accurate by the end of the period you’re looking at. This is why you look at a wide range of multiples and run sensitivity analyses to see how these variables impact the valuation.

Question 43

Why isn’t the present value of the Terminal Value, by itself, just the company’s Enterprise Value? Don’t you get Enterprise Value if you apply a multiple to EBITDA?

Answer 43

• Yes, you do get Enterprise Value - but that only represents the company’s “far in the future” value. Remember that in a DCF, a company’s value is divided into “near future” and “far future.”• If you leave out the present value of FCFs in the projection period, you’re saying “For the next 5 years, this company has no value. But then at the end of Year 5, the company is miraculously worth something again.” And that doesn’t make sense.

Question 44

How do you know if a DCF is too dependent on future assumptions?

Answer 44

• Some people claim that if over 50% of a company’s value comes from the present value of the Terminal Value, the DCF is too dependent on future assumptions.• The problem, though, is that in practice this is true in almost all DCFs. If the present value of the Terminal Value accounts for something like 80-90%+ of the company’s value, then maybe you need to re-think your assumptions.

Question 45

How can you check whether your assumptions for Terminal Value using the Multiples Method vs. the Gordon Growth Method make sense?

Answer 45

• The most common method here is to calculate Terminal Value using one method, and then to see what the implied long-term growth rate or implied multiple via the other method would be.• Example: You calculate Terminal Value with a long-term growth rate assumption of 4%. Terminal Value is $10,000. You divide that Terminal Value by the final year EBITDA and get an implied EBITDA multiple of 15x - but the Public Comps are only trading at a median of 8x EBITDA. In this case, your assumption is almost certainly too aggressive and you should reduce that long-term growth rate.

Question 46

You’re looking at two companies, both of which produce identical TOTAL Free Cash Flows over a 5-year period. Company A generates 90% of its Free Cash Flow in the 1st year and 10% over the remaining 4 years. Company B generates the same amount of Free Cash Flow in each year. Which one has the higher net present value?

Answer 46

Company A b/c money today is worth more than money tomorrow. All else being equal, generating higher cash flow earlier on will always boost a company’s value in a DCF.

Question 47

Should Cost of Equity be higher for a $5B or $500M Market Cap company?

Answer 47

It should be higher for the $500M company, because all else being equal, smaller companies are expected to outperform large companies in the stock market (and are therefore “riskier”).

Question 48

What about WACC - will it be higher for a $5B or $500M company?

Answer 48

• This is a bit of a trick question b/c it depends on whether or not the capital structure is the same for both companies. If the capital structure is the same in terms of percentages and interest rates, then WACC should be higher for the $500M company for the same reasons stated above.• If the capital structure is NOT the same, then it could go either way depending on how much debt/preferred stock each one has and what the interest rates are.

Question 49

What’s the relationship between Debt and Cost of Equity?

Answer 49

More Debt means that the company is riskier, so the company’s Leveraged Beta will be higher - so all else being equal, Cost of Equity would increase. Less Debt would decrease Cost of Equity.

Question 50

Two companies are exactly the same, but one has Debt and one does not - which one will have the higher WACC?

Answer 50

The one without Debt will generally have a higher WACC b/c Debt is “less expensive” than Equity. Why?• Interest on Debt is tax-deductible - hence the (1 - Tax Rate) multiplication in the WACC formula.• Debt is senior to Equity in a company’s capital structure - debt investors would be paid first in a liquidation or bankruptcy scenario.• Intuitively, interest rates on Debt are usually lower than Cost of Equity numbers (usually over 10%). As a result, the Cost of Debt portion of WACC will contribute less to the total figure than the Cost of Equity portion.

Question 51

So are you saying that a company that does not take on Debt is at a disadvantage to one that does? How does that make sense?

Answer 51

• The one w/o Debt is not “at a disadvantage” - but it won’t be valued as highly b/c of the way the WACC formula works.• Keep in mind that companies do not make big decisions based on financial formulas. If a company has no reason to take on Debt (e.g. it is very profitable and does not need funds to expand its business), then it won’t take on Debt.

Question 52

Let’s say that we assume 10% revenue growth and a 10% discount rate in a DCF analysis. Which change will have a bigger impact: reducing revenue growth to 9% or reducing the discount rate to 9%?

Answer 52

The Discount Rate change will almost certainly have a bigger impact b/c that affects everything from the present value of FCFs to the present value of Terminal Value - and even a 10% change makes a huge impact.

Question 53

Let’s say that we assume 10% revenue growth and a 10% discount rate in a DCF analysis. Which change will have a bigger impact: reducing revenue growth to 1% or reducing the discount rate to 9%?

Answer 53

In this case, the change in Revenue is likely to have a bigger impact b/c you’ve change it by 90% but you’ve only changed the Discount Rate by 10% - and that lower revenue growth will push down the present value of the Terminal Value (EBITDA and the FCF growth rate will both be lower) as well as the present value of the FCFs.

Question 54

The Free Cash Flows in the projection period of a DCF analysis increase by 10% each year. How much will the company’s Enterprise Value increase by?

Answer 54

A percentage that’s less than 10%, for two reasons:1. Remember that we discount all those FCFs - so even if they increase by 10%, the present value change is less than 10%.2. There’s still the Terminal Value and the present value of that. That has NOT increased by 10%, so neither has the company’s total value.• You can’t give an exact number for the increase without knowing the rest of the numbers (Discount Rate, Terminal Value, etc.) in the analysis.

Question 55

Let’s say that we want to analyze all these factors in a DCF. What are the most common sensitivity analyses to use?

Answer 55

Common Sensitivities:• Revenue Growth vs. Terminal Multiple• EBITDA Margin vs. Terminal Multiple• Terminal Multiple vs. Discount Rate• Terminal Growth Rate vs. Discount Rate

Question 56

A company has a high Debt balance and is paying off a significant portion of its Debt principal each year. How does that impact a DCF?

Answer 56

• Trick question. You don’t account for this at all in an Unlevered DCF b/c you ignore interest expense and debt principal repayments.• In a Levered DCF, you factor it in by reducing the interest expense each year as the Debt goes down and also by reducing FCF by the mandatory repayments each year.• The exact impact - i.e. whether the implied Equity Value goes up or down - depends on the interest rate and the principal repayment percentage each year; however, in most cases the principal repayments far exceed the net interest expense, so the Equity Value will most likely decrease b/c Levered FCF will be lower each year.

Question 57

So if you’re using Levered FCF to value a company, is the company better off paying off Debt quickly or repaying the bare minimum required?

Answer 57

• It’s always better to pay the bare minimum. Think about the math for a second: interest rates on Debt rarely go above 10-15%. Let’s just assume that they’re 10% and that the Company has $1000 in debt.• Initially, it pays $100 in Interest Expense, and after taxes that’s only $60 [$100 * (1 - 40%)]. So Levered FCF is reduced by $60 each year assuming no principal repayment.• What happens if the company decides to repay $200 of that Debt each year? Levered FCF is down by at least $200 each year, and the company still pays interest, albeit lower interest, until the end of the period.• So the company is always better off, valuation-wise, waiting as long as possible to repay Debt.

Question 58

Explain why we use the mid-year convention in a DCF.

Answer 58

• You use it to represent the fact that a company’s cash flow does not arrive 100% at the end of each year - instead, it comes in evenly throughout each year.• In a DCF w/o the mid-year convention, we would use discount period numbers of 1 for the 1st Year, 2 for the 2nd Year, 3 for the 3rd Year and so on.• WITH the mid-year convention, we would instead use 0.5 for the 1st Year, 1.5 for the 2nd Year, 2.5 for the 3rd Year and so on.• The end result is that the mid-year convention produces higher values since the discount periods are lower.

Question 59

What’s the point of a “stub period” in a DCF? Can you give an example?

Answer 59

• You use a stub period when you’re valuing a company before or after the end of its fiscal year and there are 1 or more quarters in between the current date and the end of the fiscal year.• For example, it’s currently Sep. 30 and the company’s fiscal year ends on Dec. 31.• In this case, it wouldn’t be correct to assume that FCF only starts on Jan. 1 of the next year - there are still 3 months between now and the end of the year, the company still generates FCF in those 3 months, and you need to account for it somewhere in your model.• So you would calculate FCF in that 3-month period, use 0.25 for the discount period, and then use 1.25 for the discount period for the first full year of the model, 2.25 for the next year, and so on.

Question 60

What discount period numbers would you use for the mid-year convention if you had a stub period - e.g. Q4 of Year 1 - in a DCF?

Answer 60

• The rule is that you divide the stub discount period by 2, and then you simply subtract 0.5 from the “normal” discount periods of the future years. (See p. 53 for example of a Q4 stub).• See (p. 53-54) another example for a Q2-Q4 stub (e.g. we’re valuing the company on Mar. 31 and its Fiscal Year ends on Dec. 31)• What is the logic here? Think about it like this: let’s take the example of the normal discount period for Year 1 being 1.75, representing 3 quarters and then a full year.• Now ask yourself when you receive that cash flow in Year 1. You’re still receiving it midway through that 1st Year, in other words, you still use 0.5 of that period.• However, you also need to take into account the 3/4 of this partial year b/c 3 quarters pass between now and the start of Year 1. So you still have 0.75 there, and the mid-year discount period with the stub period is 0.75 + 0.5, or 1.25.• That is why it’s not 1.75/2 like you might expect: it’s about when you receive that cash flow in a given Year, from the perspective of the start of Year 1 - and then you add the total amount of time that passes between now and the start of Year 1. There’s no mid-year discount applied there b/c we don’t receive any Year 1 cash in this 1st partial year.

Question 61

How does the Terminal Value calculation change when we use the mid-year convention?

Answer 61

When you’re discounting the Terminal Value back to its present value, you use different numbers for the discount period depending on whether you’re using the Multiples Method or Gordon Growth Method:• Multiples Method: You add 0.5 to the final year discount number to reflect that you’re assuming the company gets sold at the end of the year.• Gordon Growth Method: You use the final year discount number as is, b/c you’re assuming the FCFs grow into perpetuity and that they are still received throughout the year rather than just at the end.

Question 62

What if you have a stub period AND you’re using a mid-year convention - how does Terminal Value change?

Answer 62

It’s the same as what’s described previously - a stub period in the beginning does not make a difference.

Question 63

How does a DCF for private company differ?

Answer 63

• The mechanics are the same, but calculating Cost of Equity and WACC is problematic b/c you can’t find the market value of Equity or Beta for private companies.• So you might estimate WACC based on the median WACC of its Public Comps, and do the same for Cost of Equity if you’re using that as the Discount Rate.

Question 64

How do you factor in one-time events such as raising Debt, completing acquisitions, and so on in a DCF?

Answer 64

• Normally, you ignore these types of events b/c the whole point of calculating FCF is to determine the company’s cash flow on a recurring, predictable basis.• If you know for a fact that something is going to occur in the near future, then you could factor that in - issuing Debt or Equity would change Cost of Equity and WACC (and the company’s FCF in a levered DCF); completing an acquisition or buying an asset would reduce cash flow initially but perhaps boost it later on.

Question 65

What should you do if you don’t believe management’s projections in a DCF model?

Answer 65

You can take a few different approaches:• You could create your own projections.• You could “hair-cut” management’s projections (reduce them by a certain percentage) to make them more conservative.• You could show a sensitivity table based on different growth rates and margins, and show the values using both management’s projections and a more conservative set of numbers.

Question 66

Why would you not use a DCF for a bank or other financial institution?

Answer 66

• Banks use Debt differently than other companies and do not use it to finance their operations - they use it to create their “products” - loans - instead.• Also, interest is a critical part of banks’ business models and changes in “Operating Assets and Liabilities” can be much larger than a bank’s Net Income. Finally, CapEx does NOT correspond to reinvestment in business for a bank, and is often negligible.• For financial institutions (commercial banks and insurance firms), it’s more common to use a Dividend Discount Model or Residual Income Model instead of a DCF.

Question 67

Walk me through a Dividend Discount Model (DDM) that you would use in place of a normal DCF for financial institutions.

Answer 67

The mechanics are the same as a DCF, but we use Dividends rather than Free Cash Flows:1. Project the company’s earnings, down to Earnings per Share (EPS).2. Assume a Dividend Payout Ratio - what percentage of the EPS gets paid out to shareholders in the form of Dividends - based on what the firm has done historically and how much regulatory capital it needs.3. Use this to calculate Dividends over the next 5-10 years.4. Do a check to make sure that the firm still meets its required Tier 1 Capital Ratio and other capital ratios - if not, reduce Dividends.5. Discount the Dividends in each year to their present value based on Cost of Equity - not WACC - and then sum these up.6. Calculate Terminal Value based on P/BV and Book Value in the final year, and then discount this to its present value based on the Cost of Equity.7. Sum the present value of the Terminal Value and the present values of the Dividends to calculate the company’s net present value per share.• The key difference compared to a DDM for normal companies is the presence of capital ratios - you can’t just blindly make Dividends per Share a percentage of EPS.

Question 68

Do you think a DCF would work well for an oil & gas company?

Answer 68

If it’s an Exploration & Production (E&P)-focused company, generally a DCF will not work well b/c:1. CapEx needs are enormous and will push FCF down to very low levels.2. Commodity prices are cyclical and both revenue and FCF are difficult to project.• For other types of energy companies - services-based or downstream companies that just refine and market oil and gas - a DCF might be more appropriate.• For more on this topic and the alternative to a DCF that you use for oil & gas companies (called a Net Asset Value, NAV, analysis) see the industry-specific guides.

Question 69

How does a DCF change if you’re valuing a company in an emerging market?

Answer 69

• The main difference is that you’ll use a much higher Discount Rate, and you may not even necessarily link it to WACC or Cost of Equity, because there may not even be a good set of Public Comps in the country.• You might also add in a premium for political risk and uncertainty, and you might severely reduce management’s growth or profit expectations, especially if they have a reputation for being overly optimistic.

Question 70

When you’re calculating WACC, do you count Convertible Bonds as real Debt?

Answer 70

• Trick question. If the Convertible Bonds are in-the-money then you do not count them as Debt, but instead assume that they contribute to dilution, so the company’s Equity Value is higher.• If they’re out-of-the-money, then you count them as Debt and use the interest rate on the Convertible Bonds for the Cost of Debt (and include them in Debt in the formula for Levered Beta).

Question 71

What about the treatment of other securities, like Mezzanine and other Debt variations?

Answer 71

• If interest is tax-deductible, you count them as Debt in the Levered Beta calculation; otherwise, they count as Equity, just like Preferred Stock.• For WACC itself, you normally look at each type of Debt separately and assume that the “Cost” is the weighted average effective interest rate on that Debt.

Question 72

Should you ever factor in off-Balance Sheet Assets and Liabilities in a DCF?

Answer 72

• Potentially, yes, especially if they have a big impact on Enterprise Value and Equity Value (i.e. if they’re something that the acquirer would have to repay).• But it’s not terribly common to see them, partially b/c when off-B/S items are more important (for commercial banks w/ derivative books, for example), you don’t even use DCF.

Question 73

How do Pension Obligations and the Pension Expense factor into a DCF?

Answer 73

• If you’re running an Unlevered DCF and you’re counting Unfunded Pension Obligations as Debt, you should exclude pension-related expenses from Unfunded Obligations on the I/S and SCF, for the same reason you exclude interest payments on Debt.• For a Levered FCF, you would do the opposite and leave in these expenses b/c they’re a form of “interest expense.”

Question 74

Can you explain how to create a multi-stage DCF, and why it might be useful?

Answer 74

• You use a multi-stage DCF if the company grows at much different rates, has much different profit margins, or has a different capital structure in different periods.• For example, maybe the company grows at 15% in the first 2 years, then 10% in Years 2-4, and then 5% in Year 5, w/ decreasing growth each year after that.• So you might separate that into 3 stages and then make different assumptions for FCF and the Discount Rate in each one.• Note that a Standard DCF, by itself, is actually a two-stage DCF b/c you divide it into the “near future” and “far future.”• You can divide it into more periods if you want, and it would just be an extension of this concept.

Question 75

How does Net Income Attributable to Noncontrolling Interests factor into the Free Cash Flow calculation?

Answer 75

• It doesn’t - or more specifically, it has no net impact b/c you subtract it at the bottom of the I/S but then add it back on the SCF.• Just be careful that you do BOTH of those, or that you leave it out altogether - it would be incorrect to only subtract it or to only add it back, which might happen if you’re not careful with the calculation.

Question 76

What about Net Income from Equity Interests?

Answer 76

Again, this should have no net impact on FCF b/c you add it at the bottom of the I/S and then subtract it out in the SCF.

Question 77

Which tax rate should you use when calculating Free Cash Flow - statutory or effective?

Answer 77

• Normally, you use the effective tax rate b/c you want to capture what the company is actually paying out in taxes, not what it “should” be paying out according to standard federal and state rates.• Sometimes you may adjust the tax rate if it’s an unusual situation (e.g. the company is a sole proprietorship LLC and therefore income is taxed at the owner’s personal income tax rate, but a large corporation is considering acquiring the company).

Question 78

When calculating FCF, you always take into account taxes. But when you calculate Terminal Value, you don’t do that - isn’t this inconsistent? How should you treat it?

Answer 78

Here’s how to think about this one:• First off, if you use the Gordon Growth method to calculate Terminal Value, you are taking into account taxes b/c you’re valuing the company’s FCF into perpetuity.• And if you’re using the Terminal Value Method, you’re implicitly taking into account taxes b/c you’re assuming that [Relevant Metric] * [Relevant Multiple] IS the company’s present value from that point onward, as of the fiscal year. You’re not assuming that the company IS actually sold, just estimating what a buyer MIGHT pay for it, fully taking into account the value that the buyer would receive from its far-in-the-future, after-tax cash flows.

Question 79

We’re creating a DCF for a company that is planning to buy a factory for $100 in Cash in Year 4. Currently the net present value of this company, according to the DCF, is $200. How would we change the DCF to account for the factory purchase, and what would the new Enterprise Value be?

Answer 79

• In this scenario, you would include additional CapEx spending of $100 in Year 4 of the DCF, which would reduce FCF for that year by $100. The Enterprise Value, in turn, would decrease by the present value of $100 in Year 4.• The math gets messy, but you would calculate the difference by dividing $100 by (1 + Discount Rate)^4. Then you would subtract this amount from the Enterprise Value.