Chapter 1

Excel for Financial Modeling

Best practices in spreadsheet modeling

medium • 1 min read

Advanced Excel functions (INDEX, MATCH, OFFSET, INDIRECT)

medium • 2 min read

Data tables, goal seek, and scenario manager

medium • 3 min read

Error checking and circular references

medium • 4 min read

Formatting and structural guidelines for models

medium • 5 min read

Chapter 2

Building Financial Statements

Historical data analysis and common sizing

medium • 1 min read

Revenue forecasting approaches

medium • 2 min read

Projecting operating expenses and working capital

medium • 3 min read

Building PP&E schedules and depreciation modeling

medium • 4 min read

Debt schedules, interest loops, and balancing the balance sheet

medium • 5 min read

Chapter 3

DCF Valuation Modeling

Calculating Free Cash Flow to Firm (FCFF) and Equity (FCFE)

medium • 1 min read

Estimating the discount rate (WACC)

medium • 2 min read

Terminal value calculations (Perpetuity growth and exit multiple)

medium • 3 min read

Discounting mid-year versus end-of-year conventions

medium • 4 min read

Sensitivity and scenario analysis on DCF outcomes

medium • 5 min read

Chapter 4

Relative Valuation Models

Selecting comparable public companies (Trading Comps)

medium • 1 min read

Selecting precedent transactions (Transaction Comps)

medium • 2 min read

Spreading financials and calculating multiples (EV/EBITDA, P/E, P/B)

medium • 3 min read

Adjusting for non-recurring items and normalization

medium • 4 min read

Football field chart creation for valuation synthesis

medium • 5 min read

Chapter 5

Specialized Modeling Scenarios

LBO modeling basics (Sources and uses, IRR calculation)

medium • 1 min read

M&A accretion/dilution modeling

medium • 2 min read

Project finance modeling (Cash flow waterfalls)

medium • 3 min read

Valuation of startups and high-growth companies

medium • 4 min read

Sum-of-the-parts (SOTP) valuation

medium • 5 min read