Enterprise Financial Modeling & Scenario Analysis
Build multi-scenario financial models with variance analysis and executive summaries
What You Can Do
You can rapidly build comprehensive multi-dimensional financial models spanning multiple business units and geographies, then run parallel scenario analysis (base case, bull case, bear case, regulatory) with automated variance testing. Claude structures complex financial logic, validates model assumptions, identifies formula dependencies, and generates executive summaries that distill strategic insights for board-level decisions—eliminating spreadsheet bottlenecks and manual recalculation errors.
Features
Build base case, bull case, bear case, and regulatory scenarios simultaneously with linked assumptions and drivers
Automatically calculate and explain variances against actuals, prior forecasts, and strategic targets with trend commentary
Isolate key value drivers and quantify bottom-line impact of assumption changes (pricing, volume, margin, capex)
Generate one-page summaries with key assumptions, P&L waterfall, cash flow drivers, and decision-critical metrics highlighted
Detect circular references, broken dependencies, and logical inconsistencies before models reach stakeholders
Document assumption changes and their cascade impact to ensure transparency for board review and regulatory compliance
Produce financial models in standardized formats (Excel-ready, markdown tables) with formula logic clearly documented
Example Output
Input: "Model a 5-year strategic plan for a $500M software company assuming 25% YoY growth in base case, with bull case (40% growth + market share gain) and bear case (10% growth + margin compression from competition)."
Output:
Base Case P&L (Years 1-5)
├── Revenue: $500M → $1.53B (25% CAGR)
├── Gross Margin: 72% → 73% (leverage from scale)
├── EBITDA: $85M → $275M (expansion from ops efficiency)
└── FCF: $60M → $215M
Bull Case Impact vs. Base
├── Additional Revenue: +$230M (Year 5)
├── Margin accretion: +250bps (enhanced negotiating power)
└── Year 5 EBITDA: +$180M (+65%)
Sensitivity: -1% pricing impact = -$15.3M revenue; -2% CAC efficiency = -$8.2M EBITDA
What's Included
- SKILL.md instruction file with model-building methodology:
- Multi-scenario template framework (base/bull/bear case structure):
- Variance analysis checklist and commentary generators:
- Sensitivity analysis template with key driver identification:
- Executive summary template (one-pager for board distribution):
- Model validation checklist (circular reference detection, assumption documentation):
Who It's For
- CFOs and VP Finance — Strategic planning, capital allocation, and board reporting
- Corporate Development — M&A due diligence, acquisition integration planning, and value case modeling
- Business Unit Leaders — Unit-level forecasting and scenario planning for operational decisions
- FP&A Managers — Building detailed financial models and variance analysis for stakeholder presentations
- Investment professionals — Creating investment theses and stress-testing return assumptions
Best For
- Strategic financial forecasting (3-5 year plans with clear assumption documentation)
- Scenario planning (acquisition integration, market downturns, operational improvements, regulatory impacts)
- Sensitivity and stress testing (isolating key value drivers and quantifying impact)
- Variance analysis and forecasting updates (actual-to-budget and prior-forecast comparisons)
- M&A financial due diligence and deal modeling
- Capital allocation decisions and investment case development
You might also like
You can systematize your monthly bank and credit card reconciliations, cutting reconciliation time by 40-50% while catching errors before they compound. This skill matches transactions between your accounting software and bank statements, explains variances, identifies outstanding items, and maintains clean financial records across checking accounts, savings accounts, business credit cards, and lines of credit.
by skyremote
This skill structures raw trial balances and transaction logs into consolidated financial statements with documented elimination entries and variance explanations. You submit entity-level data and intercompany transaction records, and Claude identifies reconciliation gaps, flags material variances (>$25K thresholds), and generates audit-defensible consolidation workpapers. It reduces close cycle time by 40-60% while improving control documentation for SOX compliance and external audit reviews.
by skyremote
You can move beyond simple variance reporting to conduct root-cause analysis that separates temporary fluctuations from structural changes in your budget. This skill enables you to rebuild forecasts with documented assumptions, materiality thresholds, and decision logic—ensuring your budget guidance remains credible with leadership while staying responsive to business changes. You'll create audit-ready variance explanations and reforecasting narratives that bridge accounting actuals and operational planning.
by skyremote
You can establish proper fund accounting structures that distinguish between restricted donations (mission trips, building funds, benevolence) and unrestricted giving, then reconcile your church's bank statements against pledge and donation records monthly. Claude generates detailed reconciliation reports, identifies discrepancies between cash received and recorded pledges, and produces financial statements that demonstrate sound stewardship to your church council, donors, and tax authorities.
by skyremote
You can calculate exact financial runway in days and months with confidence ranges, stress-test assumptions across conservative/base/aggressive scenarios, and determine optimal fundraising timing and target amounts. The skill generates monthly cash position forecasts, sensitivity analyses showing impact of key assumption changes, and board-ready financial dashboards that inform both internal strategy and investor communications.
by skyremote
You can systematically analyze endowment spending policies against UPMIFA standards and trust document requirements, calculate sustainable annual distributions using total return, formula-based, or percentage-of-market-value methods, and stress-test policy assumptions across historical and projected market scenarios. The skill generates board-ready compliance documentation that demonstrates prudent decision-making and identifies policy conflicts before distributions are executed.
by skyremote
You can efficiently reconcile contractor expense reports against receipts and bank statements, manage reimbursements across multiple clients or project codes, and automate billing workflows that reduce errors and accelerate payment cycles. The system validates documentation for audit readiness, tracks contractor tax obligations, and maintains separate audit trails for each client—protecting you from compliance exposure while streamlining your freelance bookkeeping operations.
by skyremote
You can parse complex appropriations language to identify spending authority, time restrictions, and compliance requirements specific to your agency's funds. This skill extracts key constraints from appropriations bills, congressional committee reports, and guidance documents, then maps them to your fund structure to create actionable compliance frameworks. It helps you evaluate whether proposed obligations comply with legislative language and reduces the risk of anti-deficiency violations before funds are committed.
by skyremote