PDF Financial Statements to Excel Model
Turn PDF statements into a traceable Excel model with reconciled historicals, linked forecasts, scenarios, and an audit report.
Before & after
Same prompt, same agent — the only difference is the skill.
I can help you build that model. First, I'd want to extract the key data from your 10-K—income statement, balance sheet, cash flow. Then we'd set up a standardized spreadsheet structure with historical data and build out a forecast section based on assumptions about revenue growth, cost structure, and capital expenditure. What time period do you want to forecast? And do you have assumptions about growth rates or margins you want to bake in? Once I understand those, I can build out the model structure and walk you through it.
10-K TO FORECAST MODEL: Complete Build Output: 5-sheet Excel workbook with automated formulas SHEET 1: RAW DATA EXTRACTION • Imported from 10-K PDF: 12 quarters of financials • Line items parsed: Revenue by segment, COGS, OpEx, CapEx, debt, equity • OCR'd accuracy: 98% (3 lines flagged for manual verification) • Notes: Three acquisitions detected in Q2 2025, isolated impact SHEET 2: STANDARDIZED FORMAT • Columns: Quarter, Revenue, Gross Profit, Operating Income, Net Income, Free Cash Flow • Rows: 12 historical quarters + 12 forecast quarters • Reconciliation checks: Sum of gross profit components = stated gross profit (within 0.1%) • Validation: Cash flow formula ties to balance sheet movements SHEET 3: FORECAST ASSUMPTIONS & SCENARIOS BASE CASE (Mid-market assumptions) • Revenue growth: Year 1 +12%, Year 2 +10%, Year 3 +8% (mature rate) • Gross margin: Hold at 72% (historical average) • OpEx as % of revenue: Year 1 35%, Year 2 32%, Year 3 30% (operating leverage) • CAPEX: 2% of revenue (infrastructure, equipment) • Tax rate: 21% • Result: Net income margin 8% by Year 3 AGGRESSIVE CASE (market expansion) • Revenue growth: +18%, +15%, +12% • Gross margin: Improve to 74% (scale efficiency) • Result: Net margin 12% by Year 3 CONSERVATIVE CASE (competition, pricing pressure) • Revenue growth: +5%, +4%, +3% • Gross margin: Decline to 69% (price competition) • Result: Net margin 3% by Year 3 SHEET 4: FINANCIAL DASHBOARD • 8 charts automated to refresh from forecast • Revenue growth trajectory (base vs. aggressive vs. conservative) • Margin expansion over 36 months • Free cash flow projection (base case: 120M by Year 3) • Debt-to-EBITDA trend (target: <2.0x for financing) • Working capital requirements by quarter SHEET 5: AUDIT REPORT • Reconciliation checks: All formulas verified • Assumptions documented: Source, confidence level (high/medium/low) • Sensitivity analysis: How much does 1% change in growth impact net income? → Result: 1% growth change = 15M USD net income impact by Year 3 • Red flags: None detected; margins are sustainable DELIVERABLES • Workbook saved: 10k_forecast_model.xlsx • Formulas: All dynamic (change growth assumption, dashboard updates automatically) • Scenario comparison: One-click switch between base/aggressive/conservative • Print-ready: Dashboard and summary page format for board presentation
About this skill
Your PDFs look readable, but the Excel model still has missing figures, mixed reporting periods, or a balance sheet that will not balance. This workflow traces numbers back to their source, reconciles historical statements, and builds forecasts that carry through earnings, working capital, financing, and cash.
What it does
- Extracts statement figures with document, page, period, currency, and unit references, while flagging uncertain OCR and missing disclosures.
- Separates annual, quarterly, and year-to-date figures, including valid quarter derivations and restatement handling.
- Maps inconsistent account names into a standardized structure without losing reported totals or double-counting subtotals.
- Links income statements, balance sheets, cash flow statements, and supporting schedules through Excel formulas.
- Builds base and downside scenarios from shared assumptions, including working capital, capital spending, debt, and funding needs.
- Checks accounting ties, formula errors, scenario behavior, and source traceability, then reports unresolved issues explicitly.
What you get
An Excel workbook when file creation is available, with source data, mapped historicals, supporting schedules, assumptions, forecasts, scenarios, a dashboard, and an audit report. If workbook creation is unavailable, you receive an implementation-ready cell map and formulas with the execution limits stated clearly.
Best for
Financial analysts, controllers, and FP&A teams converting annual reports, scanned financial statements, or exported financial reports into an auditable operating model.
SKILL.md preview
---
name: pdf-financial-statements-to-excel-model
description: Converts PDF financial statements and exported reports into a traceable Excel three-statement model by normalizing periods and units, reconciling historicals, and linking forecast schedules and scenarios. Use when the user says "turn these financial statements into Excel", "build a model from this annual report", "my balance sheet will not balance", "these PDFs have inconsistent account names", "my quarterly cash flow numbers look wrong", "add forecasts to these historical statements", or "audit this model against the filings".
---
# PDF Financial Statements to Excel Model
… (sign up to view the full skill)Featured in
More finance skills
View all Finance skills →Portfolio Rebalance Advisor
Drop in your current holdings and target allocation — get the exact buy/sell list, tax-loss opportunities, and drift alert.
Personal Finance Q&A
Ask any personal-finance question and get a plain-English answer tailored to your bracket, timeline, and risk appetite.
Earnings Report Analyzer
Paste a 10-K, 10-Q, or earnings call transcript — get the numbers that matter, the narrative changes, and what the CFO tried to bury.
Investment Committee Decision Memo
Turn deal materials into an investment memo with traced evidence, reconciled financials, downside cases, and decision gates.