Home
cd ../playbooks
Finance & AccountingIntermediate

3-Statement Financial Model Builder

Build integrated 3-statement financial models with proper cross-statement linkages, scenario analysis, and professional formatting in Excel.

5 minutes
By anthropicSource
#financial modeling#3-statement model#income statement#balance sheet#cash flow#scenario analysis

Building a fully linked 3-statement model from scratch means getting dozens of cross-statement references exactly right — one broken link between the income statement and cash flow statement can silently cascade errors through every projection year.

Who it's for: financial analysts, investment banking associates, FP&A professionals, equity research analysts, corporate finance teams

Example

"Build a 3-statement model for Nike with 5-year projections" → Integrated Excel workbook with Income Statement, Balance Sheet, Cash Flow Statement, Debt Schedule, Working Capital, D&A Schedule, Scenarios tab, and Ratios dashboard — all cross-linked with formula-driven projections

CLAUDE.md Template

New here? 3-minute setup guide → | Already set up? Copy the template below.

Or install from your terminal:
npx ccplaybooks add fa-3-statement-model
# 3-Statement Financial Model Builder

**Important**: This workflow assists with financial model construction but does not provide financial advice. All models should be reviewed by qualified financial professionals before use in decision-making.

Build and populate integrated 3-statement financial models (Income Statement, Balance Sheet, Cash Flow Statement) with proper cross-statement linkages, scenario analysis, and professional formatting.

## Model Architecture

### Tab Structure

| Tab | Purpose |
|-----|---------|

Get new playbooks like this one

One email a week with new Claude Code workflows. Free, like everything here.

No spam. Unsubscribe anytime.

README.md

What This Does

Builds and populates integrated 3-statement financial models (Income Statement, Balance Sheet, Cash Flow Statement) with proper cross-statement linkages, scenario analysis, and professional formatting. The model includes supporting schedules for debt, working capital, and depreciation, plus a ratios dashboard and scenario toggle.


Quick Start

Step 1: Create a Project Folder

Create a folder for your financial model and place the downloaded template inside as CLAUDE.md.

Step 2: Download the Template

Click Download above, then move the file into your project folder as CLAUDE.md.

Step 3: Start Working

"Build a 3-statement model for Apple with 5-year projections"
"Create an integrated financial model for Tesla using historical data from 2021-2024"
"Build a 3-statement model with base, upside, and downside scenarios for Microsoft"

Model Architecture

The model produces a 10-tab Excel workbook: Cover, Assumptions, Income Statement, Balance Sheet, Cash Flow Statement, Debt Schedule, Working Capital, Depreciation & Amortization, Ratios & Output, and Scenarios. All tabs are interconnected with formula-driven linkages.

Critical linkage points:

  • Net Income flows from IS to BS (Retained Earnings) and to CFS (top line)
  • D&A flows to IS (expense) and CFS (add-back)
  • CapEx flows from CFS to BS (PP&E rollforward)
  • Working Capital changes flow from BS to CFS
  • Debt issuance/repayment flows from Debt Schedule to CFS and BS
  • Cash ending balance on CFS must equal Cash on BS

Formatting Standards

Color Meaning
Blue font Hard-coded input / assumption
Black font Formula / calculated cell
Green font Link to another tab
Red font Error check or warning

Validation Checks

The model includes built-in validation: BS balance check (must equal zero), cash tie-out between CFS and BS, retained earnings rollforward, debt schedule ties, D&A ties, working capital ties, and reasonableness checks on tax rates, revenue growth, and margins.

Tips & Best Practices

  • Always place assumptions in blue font on a dedicated Assumptions tab — no hard-coded numbers in formula cells
  • Use a scenario toggle (1 = Base, 2 = Upside, 3 = Downside) with CHOOSE or INDEX functions
  • Place the Balance Check prominently with conditional formatting (green if zero, red if non-zero)
  • For the debt schedule, use beginning balance for interest calculations to avoid circular references
  • Historical years go on the left, projected years on the right, with a clear separator between them

$Related Playbooks

Finance & Accounting

Spreadsheet and Financial Model Auditor

Systematically audit spreadsheets and financial models for formula errors, broken linkages, logic issues, and reasonableness problems with severity-based reporting.

5 minutes
Beginner
Finance & Accounting

Spreadsheet Data Cleaner

Detect and fix messy spreadsheet data including whitespace issues, inconsistent casing, numbers stored as text, date problems, duplicates, and encoding issues.

5 minutes
Beginner
Finance & Accounting

Competitive Landscape Analysis Deck

Build institutional-quality competitive landscape presentations with market positioning, competitor deep-dives, moat assessment, and strategic synthesis.

5 minutes
Beginner
Finance & Accounting

Comparable Company Analysis Builder

Build institutional-grade comparable company analyses in Excel with operating metrics, valuation multiples, quartile statistics, implied valuation, and professional formatting.

5 minutes
Intermediate
Finance & Accounting

DCF Model Builder for Equity Valuation

Create institutional-quality discounted cash flow models with WACC calculations, sensitivity analysis, and professional Excel output for equity valuation.

5 minutes
Intermediate
Finance & Accounting

Presentation Deck Number Refresh

Update numbers across an existing presentation deck — quarterly refreshes, earnings updates, comp rolls, and rebased market data — while preserving all formatting.

5 minutes
Beginner
Finance & Accounting

Investment Banking Deck Quality Checker

Comprehensive QC review of pitch decks and client presentations covering number consistency, data-narrative alignment, language polish, and visual formatting.

5 minutes
Beginner
Finance & Accounting

LBO Model Builder for Private Equity

Build leveraged buyout models in Excel with Sources & Uses, operating projections, debt schedules, returns analysis (IRR/MOIC), and sensitivity tables following investment banking standards.

5 minutes
Intermediate
Finance & Accounting

PowerPoint Template Skill Creator

Turn a branded PowerPoint template into a reusable skill that can generate on-brand presentations programmatically, with precise placeholder mapping and layout documentation.

5 minutes
Beginner
Finance & Accounting

Expense Report Generator

Organize business expenses into categorized reports for reimbursement, accounting, and tax preparation.

10 minutes
Intermediate
Finance & Accounting

Expense Tracker & Categorizer

Automate expense tracking, receipt processing, approval workflows, and reimbursement management

10 minutes
Advanced
Finance & Accounting

Personal Finance Manager — AI Budget Tracker from Bank Statements

Import bank statements (CSV or PDF) and get instant spending breakdowns, budget analysis using the 50/30/20 rule, savings recommendations, and interactive charts. All data stays local on your machine.

10 minutes
Beginner

Browse all Finance & Accounting playbooks →