## **Course Overview**

This five-day bootcamp delivers an intensive, hands-on immersion into the technical skills that define high-performing finance professionals. The curriculum moves systematically from building core three-statement models to advanced valuation, LBO, and M&A applications, culminating with pro forma capital structures. By the end of the week, participants will have mastered the modeling techniques used daily by investment bankers, private equity investors, and corporate finance teams to evaluate transactions and assess value creation.

Through step-by-step instruction and modeling, participants will not only learn technical mechanics but also develop the confidence to apply these skills in high-stakes professional environments.

### **Key Disciplines Covered**

##### **Three-Statement Modeling**

- Build fully integrated financial statements including the income statement, balance sheet, and cash flow statement.
- Incorporate working capital, depreciation, and debt schedules.
- Audit and sensitize assumptions to maintain model integrity.

##### **Valuation Modeling**

- Apply core valuation methodologies including DCF, comparables, and precedent transactions, and LBO.
- Construct robust valuation models from the ground up.
- Interpret multiples, discount rates, and value drivers in context.

##### **LBO Modeling**

- Build leveraged buyout models incorporating debt tranches, covenants, and repayment.
- Analyze IRR/MOIC drivers, exit multiples, and leverage sensitivities.
- Conduct paper LBOs and back-of-the-envelope math to sharpen intuition.

##### **M&A Modeling**

- Construct accretion/dilution models for mergers and acquisitions.
- Model synergies, purchase accounting, and goodwill adjustments.
- Evaluate strategic and financial implications of transaction structures.

##### **Pro Forma Capital Structures**

- Design and evaluate pro forma balance sheets for transactions.
- Assess debt capacity, credit metrics, and refinancing options.
- Analyze trade-offs between leverage, liquidity, and shareholder returns.

##### **Who Should Attend**

- Analysts and associates in investment banking, private equity, or corporate development.
- Professionals seeking to refine their transaction modeling expertise.
- Students or early-career professionals preparing for finance recruiting and technical interviews.

##### **Program Benefits**

- Deal-Focused Training: Learn to model the core transactions driving corporate finance and private equity.
- Hands-On Skill Development: Build models directly in Excel, step by step, with instructor guidance.
- Comprehensive Coverage: Gain mastery across multiple valuation methodologies in one intensive program.

## Overview
 
This course will introduce participants to Excel and the fundamentals of 3 statement modeling. Participants will learn how to forecast the 3 financial statements, balance a model and handle issues related to circularities. Best practices will be incorporated throughout the course.

- Excel and modeling fundamentals
  - Optimal excel settings
  - Key shortcuts
  - Formula construction
  - Matrix integrity
- 3 statement modeling
  - Steps to building a model
  - Income statement construction
  - Supporting calculations and debt schedule
  - Balance sheet and cash flow statement construction
  - Balancing the model
  - Understanding circular references and building a circ breaker

Learn how to use Excel and the fundamentals of 3 statement modeling

Introduction to Excel and 3 Statement Modeling

## Overview

This course covers Pillars’ 12 steps to building a 3 statement non-cash sweep operating model. Emphasis is placed on the complexities associated with a real company model.

- Steps to building a model
- Income statement construction
- Supporting calculations and debt schedule
- Balance sheet and cash flow statement construction
- Balancing the model
- Modeling noncontrolling interest and equity method investments

Learn how to build a non-cash sweep 3 statement operating model for a real company

3 Statement Real Company Modeling (Non-Cash Sweep)

## Overview

The goal of this course is to introduce participants to corporate valuation. The course focuses on the strengths and weaknesses of the 4 primary valuation methodologies as well as the calculation of equity and enterprise value.

- What is enterprise value
  - The link between the balance sheet equation and valuation
  - Invested capital, net operating assets and the links to enterprise value
  - Book value vs. market value
- What is equity value
- Diluted shares outstanding
- Fundamental vs. relative valuation
- 4 primary valuation techniques
  - Trading comparables
  - Transaction comparables
  - DCF
  - LBO
- Strengths and weaknesses of each valuation technique
- Minority vs. majority stake valuation
- Key multiples
- Valuation football field

Learn about equity value, enterprise value and the 4 primary valuation techniques

Valuation Fundamentals - Live

Learn how to build a complete Discounted Cash Flow (DCF) model from scratch in this on-demand, hands-on Excel course! Develop the skills used by investment bankers, equity analysts, and finance professionals to determine a company’s intrinsic value.

✅ Free Cash Flow (FCF) Calculations – Project future cash flows with precision
✅ Discount Rate (WACC) Analysis – Learn how to properly discount cash flows
✅ Terminal Value Calculations – Apply Gordon Growth & Exit Multiple methods
✅ Sensitivity Analysis – Stress test key assumptions for a dynamic valuation

Whether you're an aspiring financial analyst, investor, or finance enthusiast, this course will give you the confidence to build and interpret DCF models with ease. Start mastering valuation today!

Master DCF Modeling in Excel—Value Companies Like a Pro!

DCF Modeling

## Overview

Principles of LBO valuation will be covered and participants will build a short-form LBO model. How private equity firms create value and the unique attributes of LBO valuation are examined.

- How LBO’s and private equity firms create value
- What makes a good LBO candidate
- Common valuation drivers
  - Buyer’s return requirements
  - Availability of leverage in credit markets
  - Sustainable company cash flows for debt repayment
  - Ability of buyer to achieve operating synergies
  - Exit opportunities (sale or IPO)
- Building a flexible sources and uses of funds table
- Determining debt capacity
- Calculating the exit value
- Calculating the IRR and deriving football field valuation range
- Sensitivity analysis

Learn about LBO theory and PE value creation, and then build a short-form LBO model

Short-Form LBO Valuation and Modeling

## Overview

Participants will construct a streamlined M&A model while diving into the core principles of deal analysis. The session highlights critical drivers such as accretion/dilution impact and assessing deal feasibility through ability-to-pay metrics.

- Key assumptions and drivers needed to build a short-form M&A model
- Building a flexible sources and uses of funds table
- Stock vs. cash financing
-  Relative P/E’s: acquirer P/E vs. debt P/E vs. acquisition P/E
- Earnings accretion/dilution analysis
- Sensitivity analysis
- Synergies-to-break-even analysis
- Analysis at various prices
- Ability to pay analysis

Learn M&A theory and then build a short-form M&A model, with an emphasis on accretion-dilution

Short-Form M&A Modeling Live

An immersive, Excel-based program designed to master core modeling methodologies required by modern finance.

Modeling and Valuation Bootcamp

Modeling and Valuation Bootcamp

An immersive, Excel-based program designed to master core modeling methodologies required by modern finance.

Course Overview

Key Disciplines Covered

Three-Statement Modeling

Valuation Modeling

LBO Modeling

M&A Modeling

Pro Forma Capital Structures

Who Should Attend

Program Benefits