Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    t2s three statement model builder

    1

    Manual financial modeling is prone to broken links, circular references, and hidden funding gaps.

    $10

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    t2s three statement model builder

    t2s three statement model builder

    Example session with this skill installed

    Build a 3-year forecast for ABC Corp based on the attached 2024 balance sheet. Use 10% revenue growth, 40% gross margin, and 15% opex. I need to see what happens if DSO increases from 30 to 45 days.

    • Read your context and instructions
    • Compiled the t2s three statement

    The 3-statement model for ABC Corp has been generated for the 2025-2027 period. The calculation engine completed with a financing plug for the increased DSO scenario.

    Three-Statement Financial Model — ABC Corp, 2025-05-20

    1. Scope, sources and assumptions

    Driver202520262027Source
    Revenue Growth10.0%10.0%10.0%User (E1)
    Gross Margin40.0%40.0%40.0%User (E1)
    Opex % Revenue15.0%15.0%15.0%User (E1)
    DSO (Base)30.030.030.0User (E1)

    2. Income statement

    Line2024A2025E2026E2027E
    Revenue1000.001100.001210.001331.00
    COGS(600.00)(660.00)(726.00)(798.60)
    Gross Profit400.00440.00484.00532.40
    EBITDA250.00275.00302.50332.75

    5. Schedules and financing plug

    The revolver was drawn in 2025 due to the DSO shock scenario.

    Financing Plug2025E2026E2027E
    Revolver Opening0.0045.2048.10
    Period Draw / (Paydown)45.202.90(10.50)
    Revolver Closing45.2048.1037.60

    6. Audit checks

    PeriodBalance CheckCash CheckStatus
    2025E0.000.00PASS
    2026E0.000.00PASS
    2027E0.000.00PASS

    Next steps

    • Review the DSO shock scenario in Section 8 to evaluate peak borrowing requirements.
    • Confirm if the default interest rate for the revolver (revolver_rate) matches current bank terms.
    • Validate the initial 2024 balance sheet cash position.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Manual financial modeling is prone to broken links, circular references, and hidden funding gaps. This skill builds a strictly linked three-statement forecast using a deterministic execution script to ensure accounting integrity. It handles the arithmetic of income statements, balance sheets, and cash flow statements for up to ten periods, forcing an explicit revolver plug to highlight financing needs.

    What it does

    • Integrated forecasting generates linked financial statements from one year of actuals and user drivers.
    • Financing plug logic uses an explicit revolver draw to cover cash shortfalls instead of hiding gaps.
    • Automated audit checks performs balance sheet and cash flow validation for every projected period.
    • Scenario modeling applies shocks to growth, margins, or capex to compare outcomes across variants.
    • Financing schedules builds granular views for working capital, PP&E, term debt, and equity movements.

    How it works

    1. Data collection involves gathering a starting balance sheet and revenue along with documented drivers.
    2. Schema validation creates a request.json file mapping historical figures to specific evidence sources.
    3. Deterministic execution runs a self-contained Python script to calculate all periods using exact decimals.
    4. Result reporting outputs a structured markdown report including schedules, ratios, and audit passes.

    Frameworks & tools

    This skill uses a Python-based execution environment to run the scripts/run.py engine. Data structures follow strict JSON schemas for input and output validation.

    Why this beats prompting it yourself

    Standard LLM prompts often hallucinate arithmetic or fail to maintain balance sheet integrity across multiple years. This skill offloads calculations to a dedicated script, ensuring the balance sheet always balances and every financing gap is visible.

    Use cases

    • Project multi-year cash and debt needs under varying revenue growth assumptions.
    • Stress test liquidity by modeling slower collections (DSO) or higher inventory days.
    • Forecast the impact of large capital expenditures on future revolver utilization.
    • Generate pro forma statements for internal planning based on documented drivers.

    Known limitations

    Does not support quarterly or monthly modeling. Excludes complex accounting like deferred tax, leases, or share-based compensation. Drivers must be provided by the user and cannot be invented.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Finance & Accounting.

    Supports annual periods only (max 10). Excludes deferred tax, leases, and share-based pay. Requires at least one balanced historical year. Calculations performed via external Python script.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Money-back guarantee

    Doesn't do what its page promises? You get your money back.

    Trust & safety

    Security scan

    Security scan passed 5 days ago

    Permissions

    Terminal / Shell
    Read Files
    Write Files
    Environment Variables
    Listed5 days ago

    What's inside

    Frequently Asked Questions

    Unlike standard AI prompts that often struggle with math, this skill uses a deterministic Python script to ensure your balance sheet always balances and eliminates circular reference errors common in manual spreadsheets.

    You will receive the complete Python execution engine, the JSON schema for data input, and the script required to generate the integrated three-statement reports.

    The skill requires a one-year starting balance sheet and a set of user-defined growth and margin drivers; it cannot 'hallucinate' or invent your historical financial data for you.

    The current version is optimized for annual forecasting for up to ten periods; it does not currently support monthly or quarterly granularity or complex accounting treatments like deferred taxes.

    The skill uses a 'revolver plug' logic, meaning it automatically calculates and displays the exact amount of financing required to cover any cash shortfalls identified in your projections.

    New in Finance & Accounting