Final Review

Final Review

Created by David Moore, PhD

Study Tips

  • Go over the Silk, Gentex, Stitch Fix, and Yeti Examples
  • Practice Problems and Homeworks for extra work (and more miscellaneous topics)
  • Your Final Project is good practice (two birds with one stone!!)
  • Focus on intuition and process
  • Focus on your problem areas
  • Start big picture and work to small details

Oral Exam Tips

  • Take your time responding
  • If you are unsure about the answer talk about what you do know first
  • Arrive to room early.
  • If unsure about a response it is better to only say what you know rather than making knowingly false claims.
  • It is ok to take a few moments before responding
  • Try to structure your response (i.e create a roadmap for the answer)
  • Keep answers concise

Structure

  • 5 question categories
    1. Excel/Accounting (40 points)
    2. Financial Statement Analysis (40 points)
    3. DCF (120 points: will be two part question 100-20)
    4. Relative Valuation (60 points)
    5. Summary (20 points)
  • 280 total points
  • 30-45 minutes to complete

Lifeline

You have one lifeline to replace a question (cannot be used for DCF Part 1, RV, or Summary)

Example Question

How does an intrinsic valuation deal with the infinite horizon problem?

Excellent Answer Part 1 (100%)

In a DCF we address the fact that the firm is assumed to continue in perpetuity by calculating a terminal value, i.e. an estimate of the value of the firm at the end of the forecast window. We have two standard ways of estimating a terminal value: 1) Perpetuity growth and 2) Exit multiple.

Excellent Answer Part 2

Under the first method we continue an intrinsic approach and simply calculate the present value of expected future cash flows assuming a stable growth rate in perpetuity and continue to discount using the appropriate discount rate (WACC if UCF). We employ a perpetuity growth formula of CF/(r-g) This approach requires an assumption of the stable growth rate that is usually bounded by the risk free rate and overall growth rate of the company (historically 2-5%) and that the growth rate does not exceed the risk estimate.

Excellent Answer Part 3

Under the second approach we deviate from the intrinsic philosophy of focusing on cash flows and essentially use a relative (or comps) valuation. It is common to use an EV/EBITDA as the exit multiple, where an industry (comp set) peer average is used in conjunction with the estimated operating metric, in this case EBITDA, from the terminal year of the forecast window. Under either approach it is important that the firm has reached stable growth at this point in its life cycle and the value that is estimated than needs to be discounted back, as it sits in the terminal year, to the valuation date.

Bare Minimum Answer (70-80%)

(while still discussing terminal values and not saying anything incorrect)

There are two terminal value calculations. The first one is CF/(r-g) and the second one is EV/EBITDA times EBITDA. We estimate the inputs using our model. The first approach is called perpetuity growth and the second approach is called exit multiple. They are both good methods and can be used in an intrinsic valuation.



This response would have follow up questions to help student potentially earn more points.

Incorrect or Lacking Response (<70%)

A response not hitting the bare minimum criteria or containing incorrect statements will result in a lower grade than bare minimum.

Final Tips

  • Get a good night sleep
  • Take your time responding
  • Take a deep breath if you get nervous
  • Don't be afraid to ask for clarification
  • Have fun!!! Chance to show me everything you've learned this semester!

Thanks for being a great class and giving your best effort!!!

Key Concepts

THE ENTIRE COURSE!!!
Final Study Guide
  1. Basic Excel
  2. Financial Statements Review
  3. Financial Statement Analysis
  4. Discounted Cash Flow Valuation (Module 4-6)
  5. Relative Valuation
  6. Model Selection and Football Field Chart
  7. Advanced Excel (not on Oral Exam)

Basic Excel Modeling

This module will likely be very small portion of oral exam.
  • Must know standard formatting!!!!
  • Other skills that will come up in modeling:
    • References
    • TVM functions
    • Statistical functions
    • Logical functions
    • Lookup functions

Good Review: Class worksheet, Homework 1, practice exercises, and P.P.
Excel Videos: #1 Formatting, #2 Functions, #3 HW1 #4 PE #5 PP1
Lecture Videos: #1-#10

Financial Statement Review

  • Accounting basics (Assumption, Principles, and Constraints)
  • Financial Reporting
  • Financial Statements
    • What they are?
    • Items or Accounts
    • Go from Transactions to completed Financial Statements
    • How a transaction flows through statements.
    • Issues?

Good Review: Lemonade Stand (HW2 and in-class) and PP
Excel Videos: #1:HW2 #2:Lem Stand Exercise #3:PP
Lecture Videos: #1-#9

Financial Statement Analysis

  • Common-size
    • Why, how, what?
  • Ratio analysis
    • Know what the ratios mean (4 main groups)
    • Dupont Identity
    • Need to be able to interpret
    • Benchmarking
    • Issues?

Good Review: PP3, Ratio Game Handout, California Choppers case, two example problems under Excel Videos below, and HW 3 reading .
Excel Videos: #1:EW, #2:SFIX, #3:YETI, #4:SILK
Lecture Videos: #1-#8

DCF Valuation: Cash Flows

DCF Valuation: Discount Rate

  • Terminal Value
    • Perpetuity growth vs Exit Multiple
  • Cost of Capital (WACC)
    • Cost of Equity
    • Cost of Debt
    • Capital Structure Weights
    • Know how to estimate and calculate using ALL methods
  • Enterprise Value

Good Review: PP, Gentex, Alaska, Stryker, HW6, HW7, Stitch Fix and Yeti
Excel Videos: #1:Gentex, #2:Alaska, #3 Stryker Beta, #4:HW6, #5:SFIX, #6:SILK, #7:HW8, and Yeti
Lecture Videos: #1-#9

DCF Valuation: Diluted Shares and Loose Ends

  • Equity Compensation and Shares outstanding
    • Treasury Stock, with a twist, and Option Drag
    • Restricted Stock
  • Mid-year Discounting, Cross Holdings, Estimating MV of debt, Dual Class Stock
  • Levered Free cash flows (FCFE)
  • Sensitivity Analysis
  • What makes a good valuation?
  • Will not be tested on premium/discount cash

Good Review: PP, Gentex, Stitch Fix, Silk and Yeti (See videos below)
Excel Videos: #1-2 GNTX, #3-4:SFIX, #5-6: SILK, #7:PP and Yeti
Lecture Videos: #1-#9

Relative Valuation: Multiples

  • What is it?
  • Steps
  • Know Issues and Value drivers of Multiples
  • LTM calculation
  • Transaction Comps
  • Excess Cash (not tested)

Good Review: PP, LTM, Gentex, Stitch Fix, Silk, and Yeti, and HW8 reading.
Excel Videos: #1:LTM #2:Gentex, #3:SFIX, #4:SILK, and Yeti
Lecture Videos: #1-#8

Model Selection and Football Field Chart

  • Intrinsic vs Relative Valuation
    • Definition, Assumptions, Pros/Cons, Application, When to use
  • Pricing and Value/Price Gap
  • Football Field Chart
  • Investment Recommendation


Excel Videos: #1 Gentex, #2:SFIX, #3:SILK, and Yeti FFC Lecture Videos: #1-#5

Advanced Excel

  • Pivot Table
  • Sort and Filter
  • Conditional Formatting
  • Using Charts
  • Concatenate/INDIRECT
  • Text Functions
  • Goal Seek

Good Review: Exercises and Additional Practice
Videos: #1 Advanced Excel #2 Additional Practice
THIS WILL NOT BE TESTED ON ORAL FINAL