Financial Modeling, Valuation & Transaction Analysis

About this course

**PLEASE NOTE THAT ONLY A LIMITED NUMBER OF PARTICIPANTS WILL BE ENROLLED IN THE PROGRAM IN ORDER TO OPTIMIZE THE AMOUNT OF BACK AND FORTH BETWEEN PARTICIPANTS AND THE INSTRUCTOR.**

This online course was designed and is administered by Wesley Kennedy (https://www.linkedin.com/in/wckennedy) and represents the culmination of 15 years of high-level finance experience and 7+ years of teaching experience. Wesley designed this comprehensive online course to bridge the gap between what is missing in academia (and often not taught 'on the job') and what is necessary to break into and be successful in high-level finance.

The course spans 6 weeks and includes comprehensive video lectures and step-by-step (via recorded screen sharing) financial analysis, modeling and valuation instructions. In addition, unlike several other programs that limit students' ability to download presentations and financial models, all the materials associated with this course are downloadable. This includes 4 financial and valuation models for notable public companies (see below) and 3 exit opportunity (IPO, LBO & M&A) models. For sample materials (without the step by step instructions or instructor video with detailed notes), see : Sample Lecture and Sample Model.

THE COURSE BREAKDOWN IS AS FOLLOWS:

Week 1 (November 10th) - Financial Statement Analysis and Analyzing Financial Reports*

Lesson 1: Overview of the Income Statement, Balance Sheet and Cash Flow Statement
Lesson 2: Integrating the 3 Financial Statements
Lesson 3: Keys to Setting up & Structuring Financial Models
Lesson 4: How to Read Public Filings (10Q, 10K, and DEF 14A)
Lesson 5: Keys to Troubleshooting a Balance Sheet
Lesson 6: Analyzing Financial Ratios

Week 2 (November 17th) - Introduction to Financial Modeling & Valuation

Lesson 1: Overview of Financial Modeling
Lesson 2: Analyzing the 2 Key Operating Drivers
Lesson 3: Analyzing the Key Cash Management Drivers
Lesson 4: Overview of Valuation Analysis
Lesson 5: Deconstructing the Cash-Based (DCF) Valuation Methodology
Lesson 6: Deconstructing the Comps-Based Valuation Methodology

Week 3 (November 24th) - Mastering Excel

Lesson 1: Excel Quick Keys
Lesson 2: Simple Excel Functions
Lesson 3: Complex Excel Functions
Lesson 4: Custom Formatting & Excel "Switches"
Lesson 5: Sensitivity and Scenario Analysis
Lesson 6: Error Proofing in Excel

Week 4 (Dec 1st) - Modeling and Valuing B2C and Marketplace Companies

Lesson 1: Overview of Business-to-Consumer (B2C) Companies
Lesson 2: B2C Case Study: Modeling Chipotle (ticker: CMG)
Lesson 3: B2C Case Study: Valuing Chipotle
Lesson 4: Overview of Marketplace Companies
Lesson 5: Case Study: Modeling AirBnB (private company)
Lesson 6: Case Study: Valuing AirBnB

Week 5 (Dec 8th) - Modeling and Valuing B2C2B and B2B Companies

Lesson 1: Overview of Business-to-Consumer-to-Business Companies (B2C2B)
Lesson 2: B2C2B Case Study: Modeling Facebook (ticker: FB)
Lesson 3: B2C2B Case Study: Valuing Facebook
Lesson 4: Overview of Business-to-Business (B2B) Companies
Lesson 5: B2B Case Study: Modeling Salesforce.com (ticker: CRM)
Lesson 6: B2B Case Study: Valuing Salesforce.com

Week 6 (Dec 15th) - Analyzing Exit Opportunities

Lesson 1: Overview of an IPO
Lesson 2: IPO Case Study: Analyzing LendingClub's IPO
Lesson 3: Overview of an LBO
Lesson 4: LBO Case Study: Analyzing the Petsmart LBO
Lesson 5: Overview of Mergers and Acquisitions
Lesson 6: M&A Case Study: Analyzing the Potential Acquisition of Zulily (ticker: ZU)

*NOTE: THE ABOVE LESSONS WILL NOT BECOME ACCESSIBLE UNTIL THE DATES LISTED ABOVE IN ORDER TO PROGRESS THE PARTICIPANTS AT THE SAME PACE.

Curriculum

Financial Statement Analysis & Financial Reporting
Overview of the 3 Financial Statements
Integrating the 3 Financial Statements
Keys for Setting up and Structuring Your Financial Models
Reading Public Filings
Financial Ratios
Troubleshooting the Balance Sheet
Week #1 Quiz
Introduction to Financial Modeling and Valuation
Overview of Financial Modeling
Financial Modeling - Analyzing the Key Operating Drivers
Cash Flow Drivers (Investing & Financing)
Overview of Valuation Analysis
Valuation - Cash-Based (DCF) Methodology
Valuation - Public Comps Methodology
Mastering Excel
Excel Lesson #1 - The Basics
Excel Top 10 List
Excel - Menu Drop-downs and Grouping
Conditional Statements
Conditional Statements in Excel
Reference Functions and Data Tables
Applied Understanding - Modeling and Valuing B2C & Marketplace Companies
Overview of CMG
Inputting the Historicals
Calculating the Historicals - Part 1
Calculating the Historicals - Part 2
Projecting Revenue
Projecting Expenses and Other Operating Items
Projecting CFI and CFF
Completing the Model
Valuing CMG - DCF
Valuation of CMG - Public Comps
Overview of AirBnB
Populating the AirBnB Model
Completing the AirBnB Model
Valuation of AirBnB
Challenge: Model and Value Buffalo Wild Wings
Applied Understanding - Modeling and Valuing B2B2C & B2B Companies
Overview of Facebook
Modeling FB - Revenue Drivers
Modeling Expenses and Other Operating Elements for FB
FB - Completing the Operating Sections of the Output Tab
Completing CFI and CFF
Completing the FB Model
Valuing FB
Overview of CRM
Modeling of CRM
Valuing CRM
Analyzing Exit Events - IPO, LBO and M&A
Analyzing LendingClub's IPO
LendingClub's IPO Filing
Overview of Leveraged Buy-Outs
Overview of M&A
Modeling an LBO Scenario
Modeling the Acquisition of Chipotle (by McDonalds)

About this course