Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    Three Statement Model Builder

    1

    Use to build an integrated three-statement financial model (income statement, balance sheet, cash flow) in Python or a spreadsheet, with revenue drivers, operat

    Free

    4 usesSecurity scanned
    Three Statement Model Builder

    Three Statement Model Builder

    Example session with this skill installed

    Build a 5-year annual three-statement model in Python. Revenue is $5M with 20% growth, 60% gross margin, 45 days DSO, and a $1M loan at 5% interest. Assume $200k opening cash.

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

    Final Model Summary (Year 5):
    Revenue: $10,368,000
    Net Income: $3,142,000
    Cash: $8,450,000
    AR: $1,278,000
    Total Assets: $9,728,000
    Debt: $1,000,000
    Equity: $8,728,000
    Balance Check: PASSED (Delta = 0)

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

    About this skill

    The problem

    Building integrated financial models is error-prone. A single disconnected cell or missing interest flow causes the balance sheet to break, forcing hours of manual debugging.

    What it does

    • Generates integrated three-statement models (IS, BS, CFS) that maintain the accounting identity: Assets = Liabilities + Equity.
    • Calculates working capital schedules using DSO, DPO, and inventory turnover drivers.
    • Builds debt schedules with automated interest expense and repayment logic.
    • Produces the Indirect Method Cash Flow statement, reconciling net income to ending cash.
    • Includes a balance check mechanism to verify model integrity across every period.

    Frameworks & tools

    Python (Pandas), Microsoft Excel, and Google Sheets.

    Why this beats prompting it yourself

    Generic prompts often forget the circularity of interest or fail to bridge net income to the balance sheet correctly. This skill enforces specific accounting procedures and verification checks that ensure the model stays balanced across multiple years.

    Use cases

    • Creating five-year fundraising projections for VC pitches.
    • Building annual budget cycles with dynamic revenue and cost drivers.
    • Running M&A pro forma scenarios to see the impact of debt on cash flow.
    • Testing loan covenant compliance under different growth assumptions.

    Known limitations

    This is a forecasting tool, not a replacement for accounting software or tax compliance filings. It requires a baseline set of opening balances and assumptions to function.

    Requires initial opening balance sheet data and clear growth assumptions. Does not handle complex tax filings or specific jurisdictional GAAP/IFRS nuances.

    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 any payment.

    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

    4 uses

    Times used to date

    Free forever

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 3 months ago

    • Free with an Agensi account

    Permissions

    No special permissions declared or detected

    Listed3 months ago

    What's inside

    Frequently Asked Questions

    The skill generates a fully integrated Income Statement, Balance Sheet, and Cash Flow Statement, ensuring the accounting equation remains balanced through automated debt and working capital schedules.

    The skill is designed for use with AI agents that support Python (Pandas) code execution or can export structured data to Microsoft Excel and Google Sheets formats.

    You will receive the logic to generate a multi-year forecast including revenue drivers, a balance check mechanism, and indirect method cash flow reconciliation.

    While it handles complex circularities like interest expense and debt repayment, it is a forecasting tool and does not support real-time syncing with accounting software or tax filing automation.

    To get the most accurate results, you should provide a set of opening balances from your latest balance sheet and projected assumptions for revenue growth and operating margins.

    New in Finance & Accounting