Toolkit Store Courses Take Assessment About Blog
Take Assessment

3 Scenarios, Fully Linked

Financial Model Auditor

P&L, Balance Sheet, Cash Flow linked

Get the Skill

Scenario Model Builder: Full Walkthrough

 

Features List

3

Integrated Scenarios

15

Linked Excel Tabs

3

Financial Statements

Why FP&A Teams Build Scenario Models with This Skill

Fully Linked Statements

All three statements tie together automatically. A change in a revenue growth assumption in the Assumptions tab flows through the P&L, into working capital on the Balance Sheet, and into operating cash flow — across all three scenarios at once.

15-Tab Excel Output

The skill generates a clean, structured 15-tab workbook: Instructions, Assumptions, Historical, three P&L tabs, three Balance Sheet tabs, three Cash Flow tabs, a Comparison tab, and a Dashboard. All colour-coded and ready to share.

Base, Upside, Downside

Each scenario gets its own P&L, Balance Sheet, and Cash Flow. The Comparison tab shows the spread across scenarios side by side, so leadership can see the full range of outcomes in a single view.

Three Input Tiers

Start with just a P&L if that's all you have. Add balance sheet and cash flow data when it's available. The skill scales from a basic revenue projection to a full driver-based 3-statement model without starting over.

Balance Sheet Always Ties

The skill applies strict 3-statement linkage rules: CF closing cash feeds back to BS cash, reserves roll forward correctly, and working capital changes flow through CFO. No manual reconciliation required.

What You Get

  • Scenario Model Builder Skill (.skill file)

    The core Claude Custom Skill. Upload once to Claude and use it on any company's historical financials to build a 15-tab integrated scenario model.

  • Sample Input File (Excel)

    Historical financials for GE Vernova T&D India used as the skill demo input. Shows exactly how to format your own data before running the skill.

  • Sample Output Model (Excel)

    The completed 15-tab GE Vernova scenario model the skill produces. Review every tab, formula, and linkage before running it on your own data.

  • Walkthrough Video

    Full product demo covering how to prepare input data, run the skill, and read the completed model. Hosted on your Kajabi product page.

  • Quick-Start Guide (PDF)

    Setup guide covering skill installation, input formatting requirements, and how to interpret the three scenario outputs.

When to Use This Skill

Annual Budget & Planning Cycle

Stop presenting a single-number plan to leadership. Build Base, Upside, and Downside scenarios from your actuals and assumptions in one session. The Comparison tab gives the board everything it needs to make a funding decision.

Board and Investor Presentations

Investors want to see how the business performs under different conditions. The skill produces a clean, structured model with a Dashboard tab built for sharing. No reformatting needed.

M&A and Due Diligence

You've received a target's three years of financials. Build a forward scenario model in hours, not days. Test upside synergy assumptions and downside integration risk in the same file.

Strategic Planning Off-Sites

Leadership debates revenue and cost assumptions in a room. The skill lets you build a new scenario model on the spot, so the debate becomes a live financial planning session.

Lender and Covenant Reporting

Banks want to see how the business performs if revenue drops 20%. Run the Downside scenario, pull the Cash Flow tab, and show exactly where the debt service coverage ratio lands.

What Each Tab Does

Tab Name What It Does
1 Instructions Model overview, navigation guide, and colour legend. Blue cells are inputs; black cells are formulas. Start here.
2 Assumptions Single source of truth for all editable inputs. Revenue growth, margins, working capital days, and CapEx — all three scenarios side by side.
3 Drivers Auto-calculated historical metrics: gross margin, EBITDA margin, DSO, DIO, DPO. Used to set realistic assumption ranges.
4 Historical Three years of audited financials entered as the model baseline. P&L, Balance Sheet, and Cash Flow in one structured view.
5 P&L Base Base case Income Statement projected forward. Revenue, COGS, EBITDA, and PAT driven by Assumptions tab.
6 P&L Upside Upside Income Statement. Higher growth, better margins. Assumptions tab controls the spread versus Base.
7 P&L Downside Downside Income Statement. Lower growth, compressed margins. Shows the realistic floor.
8 BS Base Base case Balance Sheet. Working capital, PPE, cash, equity, and debt — all linked to P&L and Cash Flow.
9 BS Upside Upside Balance Sheet. Faster receivables collection, leaner inventory. Reflects the best-case working capital position.
10 BS Downside Downside Balance Sheet. Stretched payables, higher inventory, lower cash. Shows the worst-case liquidity position.
11 CF Base Base case Cash Flow. CFO, CFI, and CFF fully reconciled to the Balance Sheet. Closing cash ties back to BS Cash.
12 CF Upside Upside Cash Flow. Higher operating cash generation from improved margins and tighter working capital.
13 CF Downside Downside Cash Flow. Shows operating cash drain and whether the business can service debt in a stress scenario.
14 Comparison Side-by-side scenario summary. Revenue, EBITDA, PAT, and cash across all three scenarios for each projection year.
15 Dashboard Executive KPI summary built for board presentations. Charts and key metrics formatted for direct copy-paste into slides.

Common Questions

Stop Presenting One Number. Show the Full Range.

Updated for 2026. Build a fully linked 3-scenario model from your actuals in one session.

Get the Scenario Model Builder