- Home
- Skills
- Finance & Accounting
- t2s three statement model builder
Works with the AI Agents you already use
t2s three statement model builder
Manual financial modeling is prone to broken links, circular references, and hidden funding gaps.
$10
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
| Driver | 2025 | 2026 | 2027 | Source |
|---|---|---|---|---|
| Revenue Growth | 10.0% | 10.0% | 10.0% | User (E1) |
| Gross Margin | 40.0% | 40.0% | 40.0% | User (E1) |
| Opex % Revenue | 15.0% | 15.0% | 15.0% | User (E1) |
| DSO (Base) | 30.0 | 30.0 | 30.0 | User (E1) |
2. Income statement
| Line | 2024A | 2025E | 2026E | 2027E |
|---|---|---|---|---|
| Revenue | 1000.00 | 1100.00 | 1210.00 | 1331.00 |
| COGS | (600.00) | (660.00) | (726.00) | (798.60) |
| Gross Profit | 400.00 | 440.00 | 484.00 | 532.40 |
| EBITDA | 250.00 | 275.00 | 302.50 | 332.75 |
5. Schedules and financing plug
The revolver was drawn in 2025 due to the DSO shock scenario.
| Financing Plug | 2025E | 2026E | 2027E |
|---|---|---|---|
| Revolver Opening | 0.00 | 45.20 | 48.10 |
| Period Draw / (Paydown) | 45.20 | 2.90 | (10.50) |
| Revolver Closing | 45.20 | 48.10 | 37.60 |
6. Audit checks
| Period | Balance Check | Cash Check | Status |
|---|---|---|---|
| 2025E | 0.00 | 0.00 | PASS |
| 2026E | 0.00 | 0.00 | PASS |
| 2027E | 0.00 | 0.00 | PASS |
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
- Data collection involves gathering a starting balance sheet and revenue along with documented drivers.
- Schema validation creates a
request.jsonfile mapping historical figures to specific evidence sources. - Deterministic execution runs a self-contained Python script to calculate all periods using exact decimals.
- 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
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 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