corsair prep - DCF
How do you calculate WACC?
Cost of Equity * (% Equity) + Cost of Debt * (% Debt) * (1 - Tax Rate) + Cost of Preferred * (% Preferred) In all cases, the percentages refer to how much of the company's capital structure is taken up by each component For Cost of Equity, you can use the Capital Asset Pricing Model (CAPM - see the next question) and for the others you usually look at comparable companies/debt issuances and the interest rates and yields issued by similar companies to get estimates
How can we calculate Cost of Equity WITHOUT using CAPM?
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 for companies where dividends are more important or when you lack proper information on Beta and the other variables that go into calculating Cost of Equity with CAPM
How do you calculate the Cost of Equity?
Cost of Equity = Risk-Free Rate + Beta * Equity Risk Premium The risk-free rate represents how much a 10-year or 20-year US Treasury should yield; Beta is calculated based on the "riskiness" of Comparable Companies and the Equity Risk Premium is the % by which stocks are expected to out-perform "risk-less" assets Normally you pull the Equity Risk Premium from a publication called Ibbotson's Note: This formula does not tell the whole story. Depending on the bank and how precise you want to be, you could also add in a "size premium" and "industry premium" to account for how much a company is expected to out-perform its peers is according to its market cap or industry Small company stocks are expected to out-perform large company stocks and certain industries are expected to out-perform others, and these premiums reflect these expectations.
risk free rate
represents how much a 10-year or 20-year US Treasury should yield
What types of sensitivity analyses would we look at in a DCF?
- Revenue Growth vs. Terminal Multiple - EBITDA Margin vs. Terminal Multiple - Terminal Multiple vs. Discount Rate - Long-Term Growth Rate vs. Discount Rate And any combination of these (except Terminal Multiple vs. Long-Term Growth Rate, which would make no sense)
Walk me through a DCF.
A DCF values a company based on the Present Value of its Cash Flows and the Present Value of its Terminal Value 1. First, you project out a company's financials using assumptions for revenue growth, expenses and Working Capital 2. Then you get down to Free Cash Flow for each year, which you then sum up and discount to a Net Present Value, based on your discount rate - usually the Weighted Average Cost of Capital 3. Once you have the present value of the Cash Flows, you determine the company's Terminal Value, using either the Multiples Method or the Gordon Growth Method, and then also discount that back to its Net Present Value using WACC 4. Finally, you add the two together to determine the company's Enterprise Value.
Would you expect a manufacturing company or a technology company to have a higher Beta?
A technology company, because technology is viewed as a "riskier" industry than manufacturing
Why do you have to un-lever and re-lever Beta?
Again, keep in mind our "apples-to-apples" theme. When you look up the Betas on Bloomberg (or from whatever source you're using) they will be levered to reflect the debt already assumed by each company 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 get that, we need to un-lever Beta each time But at the end of the calculation, we need to re-lever it because we want the Beta used in the Cost of Equity calculation to reflect the true risk of our company, taking into account its capital structure this time
Why would you not use a DCF for a bank or other financial institution?
Banks use debt differently than other companies and do not re-invest it in the business - they use it to create products instead Also, interest is a critical part of banks' business models and working capital takes up a huge part of their Balance Sheets - so a DCF for a financial institution would not make much sense For financial institutions, it's more common to use a dividend discount model for valuation purposes
Why would you use Gordon Growth rather than the Multiples Method to calculate the Terminal Value?
In banking, you almost always use the Multiples Method to calculate Terminal Value in a DCF It's much easier to get appropriate data for exit multiples since they are based on Comparable Companies - picking a long-term growth rate, by contrast, is always a shot in the dark However, you might use Gordon Growth if you have no good Comparable Companies or if you have reason to believe that multiples will change significantly in the industry several years down the road. For example, if an industry is very cyclical you might be better off using long-term growth rates rather than exit multiples
What about a 1% change in revenue vs. a 1% change in the discount rate?
In this case the discount rate is likely to have a bigger impact on the valuation, though the correct answer should start with, "It could go either way, but most of the time..."
We're creating a DCF for a company that is planning to buy a factory for $100 in cash (no debt or other financing) in Year 4. Currently the present value of its Enterprise Value according to the DCF is $200. How would we change the DCF to account for the factory purchase, and what would our new Enterprise Value be?
In this scenario, you would add CapEx spending of $100 in year 4 of the DCF, which would reduce Free Cash Flow for that year by $100 The Enterprise Value, in turn, would fall by the present value of that $100 decrease in Free Cash Flow The actual math here is messy but you would calculate the present value by dividing $100 by ((1 + Discount Rate)^4) - the "4" just represents year 4 here. Then you would subtract this amount from the Enterprise Value
Should Cost of Equity be higher for a $5 billion or $500 million market cap company?
It should be higher for the $500 million company, because all else being equal, smaller companies are expected to outperform large companies in the stock market (and therefore be "more risky") Using a Size Premium in your calculation would also ensure that Cost of Equity is higher for the $500 million company
Which method of calculating Terminal Value will give you a higher valuation?
It's hard to generalize because both are highly dependent on the assumptions you make In general, the Multiples Method will be more variable than the Gordon Growth method because exit multiples tend to span a wider range than possible long-term growth rates
Let's say that you use Levered Free Cash Flow rather than Unlevered Free Cash Flow in your DCF - what is the effect?
Levered Free Cash Flow 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)
What's the relationship between debt and Cost of Equity?
More debt means that the company is more risky, so the company's Levered Beta will be higher - all else being equal, additional debt would raise the Cost of Equity, and less debt would lower the Cost of Equity
How do you select the appropriate exit multiple when calculating Terminal Value?
Normally you look at the Comparable Companies and pick the median of the set, or something close to it As with almost anything else in finance, 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 from 6x to 10x
What do you usually use for the discount rate?
Normally you use WACC (Weighted Average Cost of Capital), though you might also use Cost of Equity depending on how you've set up the DCF
What's an appropriate growth rate to use when calculating the Terminal Value?
Normally you use the country's long-term GDP growth rate, the rate of inflation, or something similarly conservative For companies in mature economies, a long-term growth rate over 5% would be quite aggressive since most developed economies are growing at less than 5% per year
If I'm working with a public company in a DCF, how do I calculate its per-share value?
Once you get to Enterprise Value, ADD cash and then subtract debt, preferred stock, and minority interest (and any other debt-like items) to get to Equity Value. Then, you need to use a circular calculation that takes into account the basic shares outstanding, options, warrants, convertibles, and other dilutive securities. It's circular because the dilution from these depends on the per-share price - but the per-share price depends on number of shares outstanding, which depends on the per-share price To resolve this, you need to enable iterative calculations in Excel so that it can cycle through to find an approximate per-share price
Walk me through how you get from Revenue to Free Cash Flow in the projections.
Subtract COGS and Operating Expenses to get to Operating Income (EBIT) Then, multiply by (1 - Tax Rate), add back Depreciation and other non-cash charges, and subtract Capital Expenditures and the change in Working Capital Note: This gets you to Unlevered Free Cash Flow since you went off EBIT rather than EBT. You might want to confirm that this is what the interviewer is asking for.
What's an alternate way to calculate Free Cash Flow aside from taking Net Income, adding back Depreciation, and subtracting Changes in Operating Assets / Liabilities and CapEx?
Take Cash Flow From Operations and subtract CapEx - that gets you to Levered Cash Flow To get to Unlevered Cash Flow, you then need to add back the tax-adjusted Interest Expense and subtract the tax-adjusted Interest Income
The formula for Terminal Value using Gordon Growth
Terminal Value = Year 5 Free Cash Flow * (1 + Growth Rate) / (Discount Rate - Growth Rate)
Why do you use 5 or 10 years for DCF projections?
That's usually about as far as you can reasonably predict into the future Less than 5 years would be too short to be useful, and over 10 years is too difficult to predict for most companies
How do you know if your DCF is too dependent on future assumptions?
The "standard" answer: if significantly more than 50% of the company's Enterprise Value comes from its Terminal Value, your DCF is probably too dependent on future assumptions In reality, almost all DCFs are "too dependent on future assumptions" - it's actually quite rare to see a case where the Terminal Value is less than 50% of the Enterprise Value But when it gets to be in the 80-90% range, you know that you may need to re-think your assumptions...
Walk me through a Dividend Discount Model (DDM) that you would use in place of a normal DCF for financial institutions.
The mechanics are the same as a DCF, but we use dividends rather than free cash flows: 1. Project out the company's earnings, down to earnings per share (EPS) 2. Assume a dividend payout ratio - what percentage of the EPS actually 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. Discount each dividend to its present value based on Cost of Equity - NOT WACC - and then sum these up 5. Calculate terminal value based on P / E and EPS in the final year, and then discount this to its present value based on Cost of Equity 6. Sum the present value of the terminal value and the present values of the dividends to get the company's net present per-share value
What's the flaw with basing terminal multiples on what public company comparables are trading at?
The median multiples may change greatly in the next 5-10 years so it may no longer be accurate by the end of the period you're looking at This is why you normally look at a wide range of multiples and do a sensitivity to see how the valuation changes over that range This method is particularly problematic with cyclical industries (e.g. semiconductors)
What discount period numbers would I use for the mid-year convention if I have a stub period - e.g. Q4 of Year 1 - in my DCF?
The rule is that you divide the stub discount period by 2, and then you simply subtract 0.5 from the "normal" discount periods for the future years
What about WACC - will it be higher for a $5 billion or $500 million company?
This is a bit of a trick question because 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 and such, then WACC should be higher for the $500 million company for the same reasons as mentioned 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
How do you calculate WACC for a private company?
This is problematic because private companies don't have market caps or Betas In this case you would most likely just estimate WACC based on work done by auditors or valuation specialists, or based on what WACC for comparable public companies is
Two companies are exactly the same, but one has debt and one does not - which one will have the higher WACC?
This is tricky - the one without debt will have a higher WACC up to a certain point, because 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 holders would be paid first in a liquidation or bankruptcy - Intuitively, interest rates on debt are usually lower than the Cost of Equity numbers you see (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 will
Two companies are exactly the same, but one has debt and one does not - which one will have the higher WACC? the one without debt will have a higher WACC up to a certain point
This is true only to a certain point Once a company's debt goes up high enough, the interest rate will rise dramatically to reflect the additional risk and so the Cost of Debt would start to increase - if it gets high enough, it might become higher than Cost of Equity and additional debt would increase WACC It's a "U-shape" curve where debt decreases WACC to a point, then starts increasing it
When you're calculating WACC, let's say that the company has convertible debt. Do you count this as debt when calculating Levered Beta for the company?
Trick question If the convertible debt is in-the-money then you do not count it as debt but instead assume that it contributes to dilution, so the company's Equity Value is higher If it's out-of-the-money then you count it as debt and use the interest rate on the convertible for Cost of Debt
Cost of Equity tells us what kind of return an equity investor can expect for investing in a given company - but what about dividends? Shouldn't we factor dividend yield into the formula?
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
A company has a high debt load and is paying off a significant portion of its principal each year. How do you account for this in a DCF?
Trick question. You don't account for this at all in a DCF, because paying off debt principal shows up in Cash Flow from Financing on the Cash Flow Statement - but we only go down to Cash Flow from Operations and then subtract Capital Expenditures to get to Free Cash Flow If we were looking at Levered Free Cash Flow, then our interest expense would decline in future years due to the principal being paid off - but we still wouldn't count the principal repayments themselves anywhere
How does the terminal value calculation change when we use the mid-year convention?
When you're discounting the terminal value back to the 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 the fact 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, because you're assuming the cash flows grow into perpetuity and that they are still received throughout the year rather than just at the end
How do you calculate the Terminal Value?
You can either apply an exit multiple to the company's Year 5 EBITDA, EBIT or Free Cash Flow (Multiples Method) or you can use the Gordon Growth method to estimate its value based on its growth rate into perpetuity
What should you do if you don't believe management's projections for a DCF model?
You can take a few different approaches: - You can create your own projections - You can modify management's projections downward to make them more conservative - You can show a sensitivity table based on different growth rates and margins and show the values assuming managements' projections and assuming a more conservative set of numbers In reality, you'd probably do all of these if you had unrealistic projections.
How do you get to Beta in the Cost of Equity calculation?
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 it based on your company's capital structure Then you use this Levered Beta in the Cost of Equity calculation For your reference, the formulas for un-levering and re-levering Beta are below: Un-Levered Beta = Levered Beta / (1 + ((1 - Tax Rate) x (Total Debt/Equity))) Levered Beta = Un-Levered Beta x (1 + ((1 - Tax Rate) x (Total Debt/Equity)))
Which has a greater impact on a company's DCF valuation - a 10% change in revenue or a 1% change in the discount rate?
You should start by saying, "it depends" but most of the time the 10% difference in revenue will have more of an impact That change in revenue doesn't affect only the current year's revenue, but also the revenue/EBITDA far into the future and even the terminal value
Explain why we would use the mid-year convention in a DCF.
You use it to represent the fact that a company's cash flow does not come 100% at the end of each year - instead, it comes in evenly throughout each year In a DCF without mid-year convention, we would use discount period numbers of 1 for the first year, 2 for the second year, 3 for the third year, and so on With mid-year convention, we would instead use 0.5 for the first year, 1.5 for the second year, 2.5 for the third year, and so on
If you use Levered Free Cash Flow, what should you use as the Discount Rate?
You would use the Cost of Equity rather than WACC since we're not concerned with Debt or Preferred Stock in this case - we're calculating Equity Value, not Enterprise Value
stub period
a length of time over which interest accrues are not equal to the usual interval between bond coupons These periods normally occur because the interval between coupons does not fit neatly into the period for which the bond was issued, thus sometimes a bond's final or first coupon period may be adjusted to make the bond start and mature on the desired dates
beta
calculated based on the "riskiness" of Comparable Companies and the Equity Risk Premium is the % by which stocks are expected to out-perform "risk-less" assets
gordon growth method
values a company's stock using an assumption of constant growth in dividends