# Financial Modeling Bootcamp

Canonical URL: <https://www.graduateschool.edu/courses/financial-modeling-bootcamp>

## Overview

This intensive Financial Modeling Bootcamp blends advanced Excel instruction with practical finance and accounting fundamentals. Across three days, you’ll build full-scale financial models—covering 3-statement and discounted cash flow (DCF)—while developing the core capabilities required for high-stakes analysis.

 
- **Strengthen Excel for Finance:** Master advanced Excel features for financial modeling, including CHOOSE and Data Tables, auditing tools, data validation, and Goal Seek to produce dynamic, reliable models.
- **Understand Core Finance & Accounting:** Examine essential concepts such as enterprise value, accrual accounting, and market capitalization. Learn to analyze financial statements and structure your models effectively.
- **Build Real-World Financial Models:** Construct an integrated 3-statement model and DCF valuation using real company data. Produce detailed forecasts and apply terminal value and sensitivity analysis to evaluate outcomes.
- **Apply Your Skills to Valuation:** Practice conducting valuation analyses and deriving share prices from model outputs. Learn to sanity-check your model and adapt it for professional use in corporate settings.

## What you'll learn

- Financial concepts, market capitalization, and enterprise value
- Financial accounting, including accrual versus cash accounting
- Discounted cash flow (DCF) modeling: assumptions, projecting cash flows, sensitivities, auditing
- Excel techniques, including Data Validation, CHOOSE, Data Tables, and Goal Seek
- Leveraged buyout (LBO) modeling
- Real company analysis
- Setting up the financial model and model projections
- Corporate valuation and how to derive a value per share
- How to analyze the model output

## Prerequisites

Prior financial experience is helpful, but not required. Those without a finance or accounting background will receive a short guide prior to the course (available in the online student portal) to acclimate themselves to terminology.

Excel proficiency equivalent to [Intermediate Excel for Business](/courses/intermediate-excel-classes) is required, including VLOOKUP, Pivot Tables, and IF statements. Our [Financial Analyst Training Program](/courses/financial-analyst-training-program) includes beginner and intermediate Excel along with this 3-day bootcamp.

## Curriculum

### Day I: Advanced Excel for Financial Modeling

#### Advanced techniques to Expedite Workflow

- Efficient formula writing
- Formula & model auditing
- Advanced cell locking
- Hot Keys to work without the mouse
- Windows & work with multiple applications
- Go To Special
- Paste Special
- Project #1: Revenue build-up by store count and same store sales growth

#### Advanced Analytical Tools & Sensitivity Analysis

- Goal Seek
- Data Tables
- Scenario Manager
- Project #2: Cash flow modeling & sensitivity analysis

#### Database Functions for Finance

- Advanced SUMIFS
- VLOOKUP-MATCH
- INDEX-MATCH

#### Functions for Financial Modeling

- Financial functions
- Date functions
- Nested IF statements
- IF Statements with AND/OR
- CHOOSE function
- Weighted average calculations
- IFERROR
- Projects #3: Loan amortization model

### Day II: Intro to Corporate Finance, Accounting, & Modeling

#### Intro to Corporate Finance

- Net Present Value (NPV) and Internal Rate of Return (IRR)
- How are PV and IRR used in financial modeling?
- How companies raise capital through debt and equity issuances

#### Enterprise value

- Stocks, dividend yields, trading terminologoy, and valuation metrics
- Market Capitalization: Calculate the market cap for public companies
- Shares outstanding: How does share count change over time?
- Enterprise Value: Calculate the enterprise value for public companies

#### Financial Accounting & Statement Analysis

- Cash vs. accrual accounting
- Assets = Liabilities + Shareholder's Equity
- Annual and quarterly filings, and press releases
- Income Statement: Analyze line items on an income statement; calculate growth rates, and TTM
- Balance Sheet: Review assets, liabilities and shareholder's equity
- Cash Flow Statement: Analyze a public company cash flow statement
- Working Capital: Calculate and understand working capital

#### Integrated Financial Modeling

- Calculate historical ratios for revenue growth, margins, and working capital
- Project cash flows based on historical metrics
- Create debt, equity, and working capital supporting schedules
- Review how financial statements tie together and balance the model
- Integrate the income statement, balance sheet, and cash flow statement in Excel

#### Intro to DCF Modeling

- Calculate unlevered free cash flow from the integrated model
- Discount cash flows using the WACC
- Derive a share price from total company value

#### Sensitivity Analysis

- Use Data Tables to sensitize the model's key inputs
- Conditional Format with formulas to highlight cells that meet certain criteria
- Calculate the revenue growth required to hit a certain share price

#### Intro to LBO Modeling

- Review Leveraged Buyouts (LBOs) basics
- Create a simple LBO model
- Calculate the IRR and Equity Multiple

### Day III: In-depth Financial Modeling & Valuation

#### Company Analysis

- Discuss the business model and value drivers of a public restaurant company
- Capital Structure: Calculate the total enterprise value and build a capital structure table
- Historical Financials: Populate the historical financials
- Ratios: Calculate the financial ratios

#### Financial projections

- Create financial projections for revenues
- Create financial projections for expenses
- Create projections for the working capital items

#### Terminal Value

- Estimate the company's terminal value using the Gordon Growth Model

#### Discounting Cash Flows

- Use CAPM to estimate the company's cost of equity
- Calculate the weighted average cost of capital (WACC)
- Discount future cash flows with the midpoint convention

#### Corporate Valuation

- Calculate the diluted shares outstanding using the treasury stock method
- Derive a value per share from total enterprise value

#### Final Analysis & Reasonability Testing

- Where does our model need additional analysis?
- How does our value per share compare to the current price?
- How do our financial projections compare to management's and the analyst community
- Analyze the output and determine reasonability of the model and assumptions
- What areas or assumptions require additional research?
- What assumptions drive the valuation and how would changes impact our thesis
- Should we invest in the stock at current prices?

## Schedule
- Jun 24, 2026 – Jun 26, 2026 — Live Online
- Aug 26, 2026 – Aug 28, 2026 — Live Online
- Oct 21, 2026 – Oct 23, 2026 — Live Online

## Pricing

**Tuition:** $995