FNCE 3415 Valuation & Financial Modeling

Slides are meant as a template for lectures and should not be used in lieu of coming to class. Slides are constructed based on topics from Wall Street Prep Materials.

Final Project Presentation Skills Review Final Study Guide

Financial Statements Review

This lecture is a review of accounting and financial statements. It covers key concepts and terms about the balance sheet, income statement, and cash flow statement. It also covers financial reporting.

View Slides Example of Annual Report Printer Friendly Slides Topics Practice Problems Lemonade Stand

Basic Excel Modeling

This lecture covers basic excel skills. It introduces keyboard shortcuts as well as modeling best practices. It also reviews time value of money.

View Slides Printer Friendly Slides Class Worksheet Practice Exercises Topics Practice Problem

Financial Statements Analysis

This lecture covers the use of standardized financial statements and financial ratios. We will also cover California Choppers Case.

View Slides Printer Friendly Slides Financial Ratios Topics Practice Problems Case Template

Financial Statements Modeling

This lecture covers the basics of projecting future cash flows. Discussion includes pro-forma financial statement modeling as well as modeling free cash flows directly.

View Slides Printer Friendly Slides Topics Practice Problems Gentex Template Gentex Material Alaska Template Pro-forma Template

Discounted Cash Flow Valuation (DCF) Part 1

Introduction to Discounted Cash flow valuation. Discussion focused on estimating terminal value and cost of capital and calculating enterprise value.

View Slides Printer Friendly Slides Topics Practice Problems Gentex Terminal Value Gentex WACC Alaska Airlines Stryker Beta

Discounted Cash Flow Valuation (DCF) Part 2

Tying up loose ends up valuation, including discussion of employee equity grants, cash, mid-year discounting, and cross holdings. We will also discuss the importance of and the tools to conduct sensitivity analysis

View Slides Printer Friendly Slides Topics Practice Problems Case Template

Relative Valuation: Multiples

Introduction to relative valuation using multiples. Includes discussion of selecting trading or transaction comparables, using several common multiples, and calculating LTM. Also introduces estimation of excess cash.

View Slides Printer Friendly Slides Topics Practice Problems LTM Example Gentex Template

Advanced Excel

This section covers miscellaneous Excel skills including Pivot Tables, conditional formatting, basic graphing skills, concatenating, INDIRECT function, the group of TEXT based functions, and goal seek.

View Slides Printer Friendly Slides Topics Practice Problems Link to Video

Model Selection and Football Field Chart

This section finishes with a discussion of Intrinsic vs Relative valuation and creating a "football field" chart to display the ranges of your valuation relative to the market price range.

View Slides Printer Friendly Slides Topics Link to Video