- Home
- Skills
- Finance & Accounting
- Three Statement Model Builder
Works with the AI Agents you already use
Three Statement Model Builder
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
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
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
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 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