Learning Objectives

What You'll Learn Today

By the end of this session, you will be able to:

Section 1

What is Financial Modeling?

Understanding the foundation of quantitative decision-making

πŸ’­
Think About It

If you had to value a company like Apple or Tesla, what factors would you consider?

Take 30 seconds to think before we discuss as a class

πŸ“– Definition

Financial Modeling is the process of creating a mathematical representation (a model) of a company's financial performance, position, and prospects. It involves building a spreadsheet or program that incorporates historical data, assumptions, and calculations to project future financial outcomes.

πŸ’‘ Key Insight

A financial model is not just a spreadsheetβ€”it's a decision-making tool that helps answer critical business questions like "What is this company worth?" or "Should we proceed with this investment?"

Types of Financial Models

πŸ“Š

Three-Statement Model

Integrated Income Statement, Balance Sheet, and Cash Flow Statement

πŸ’°

DCF Valuation

Discounted Cash Flow analysis for intrinsic valuation

πŸ”„

M&A Model

Mergers & acquisitions analysis with accretion/dilution

πŸ“ˆ

LBO Model

Leveraged Buyout analysis for private equity

πŸ›οΈ

Credit Model

Credit analysis and debt capacity assessment

πŸ“‰

Comps Model

Comparable company and precedent transaction analysis

The Financial Modeling Process

Historical Data Assumptions & Drivers Calculations & Formulas Output & Analysis
Section 2

Applications in Finance

Where and why financial models are used

🏦

Investment Banking

  • IPO valuation and pricing
  • M&A deal analysis and fairness opinions
  • Raise capital (debt/equity) analysis
  • Pitch books and presentations
πŸ’Ό

Private Equity

  • LBO analysis and returns modeling
  • Due diligence and valuation
  • Portfolio company monitoring
  • Exit strategy planning
🏒

Corporate Finance

  • Budgeting and forecasting
  • Capital budgeting decisions
  • Business planning and strategy
  • Investor relations
πŸ“ˆ

Equity Research

  • Company valuation and price targets
  • Earnings forecasts
  • Industry analysis
  • Investment recommendations

🌍 Real-World Example: Tesla Valuation

Financial analysts use models to value Tesla (TSLA). In 2020, Tesla's stock price increased by over 700%. Different models gave vastly different valuations:

  • DCF Model: $300-$500 per share (based on future cash flows)
  • Comps Model: $150-$200 per share (based on peer comparison)
  • Market Price: Reached over $800 per share

This illustrates how different assumptions and methodologies can lead to dramatically different valuations!

Section 3

Core Principles of Financial Modeling

The four pillars that separate good models from great ones

🎯

Accuracy

Formulas must be correct. Always double-check calculations and use error-checking mechanisms.

πŸ”§

Flexibility

Models should handle different scenarios. Use input cells and avoid hardcoding values.

πŸ”

Transparency

Others should understand your model. Use clear labels, comments, and documentation.

πŸ“

Consistency

Follow the same structure throughout. Use consistent formatting, colors, and conventions.

πŸ“š Key Terms - Click to Flip

Section 4

Best Practices

Industry standards for professional financial models

Color Coding Standards

Blue

Hardcoded inputs/assumptions

Black

Formulas and calculations

Gold/Green

Links to other sheets

πŸ’‘ Pro Tip

Always use blue font for inputs you can change, and black for formulas. This helps users instantly identify what they can modify versus what's calculated.

Model Structure

1. Cover Sheet

Project name, version, author, date, and key outputs summary

2. Assumptions Sheet

All inputs in one place - growth rates, margins, discount rates

3. Calculation Sheets

Working schedules, supporting calculations

4. Output Sheets

Financial statements, valuation summary, sensitivity tables

Error Checking Techniques

1
Balance Sheet Check

Assets = Liabilities + Equity (should always equal zero difference)

2
Cash Flow Check

Ending cash matches balance sheet cash

3
Circular Reference Check

Identify and resolve intentional vs unintentional circularities

4
Reasonability Test

Do the numbers make sense? Compare to historicals and industry

Error Check Example
Item Value A Value B Difference Status
Total Assets $1,000,000
Total L + E $1,000,000
Check =B3-C4 βœ“ Balanced

Documentation Standards

  • 1
    Cell Comments

    Add comments to explain complex formulas or assumptions

  • 2
    Model Map

    Create a flowchart showing how sheets are linked

  • 3
    Version Control

    Save versions with dates (Model_v1_20260304.xlsx)

  • 4
    Change Log

    Track what changed and why in each version

Section 5

Excel Basics Review

Essential functions and shortcuts for financial modeling

πŸ”’ Essential Functions

Ξ£
SUM

=SUM(A1:A10) - Add a range of numbers

IF
IF

=IF(A1>100,"High","Low") - Conditional logic

V
VLOOKUP

=VLOOKUP(value,table,col,FALSE) - Look up values

IDX
INDEX-MATCH

=INDEX(range,MATCH(value,lookup,0)) - Flexible lookup

⌨️ Must-Know Shortcuts

1
Ctrl + C/V

Copy/Paste

2
Ctrl + Z/Y

Undo/Redo

3
Ctrl + `

Show/Hide Formulas

4
F4

Toggle Absolute Reference ($A$1)

5
Ctrl + [

Go to Precedents (formula sources)

🎯 Practice: Match the Function to Its Use

Knowledge Check

Test Your Understanding

Let's see what you've learned!

Summary

Key Takeaways

πŸ“ What We Covered Today

  • Financial modeling is creating mathematical representations to support decision-making
  • Models are used in investment banking, private equity, corporate finance, and equity research
  • The four core principles: Accuracy, Flexibility, Transparency, Consistency
  • Best practices include color coding, proper structure, error checking, and documentation
  • Essential Excel skills: SUM, IF, VLOOKUP, INDEX-MATCH and keyboard shortcuts
πŸ“š Next Session

Lecture 2: Excel Advanced Functions for Modeling
We'll dive deeper into VLOOKUP, XLOOKUP, INDEX-MATCH, logical functions, and more hands-on Excel practice. Read: Excel 2019 Bible, Ch. 5–7