Home · Skills · Funds Flow Calculator
Back to all skills

Funds Flow Calculator

Calculate and verify funds flow, prorations, wire instructions, and the settlement statement for CRE acquisition closings. Branches by all-cash vs. financed (single tranche vs. multiple), 1031 exchange proceeds, number of funding sources, and proration method (per diem vs. actual/365 vs. 30/360). Triggers on 'funds flow', 'prorations', 'settlement statement', 'wire instructions', 'cash to close', 'net proceeds', 'security deposit transfer', 'closing statement', 'ALTA statement', or when given a closing date, rent roll, tax bill, and purchase price.

What this skill does

Funds Flow Calculator is an A.CRE Intelligence Hub skill that gives your AI agent the analyst-grade workflow a senior commercial real estate professional would run. Calculate and verify funds flow, prorations, wire instructions, and the settlement statement for CRE acquisition closings. Branches by all-cash vs. financed (single tranche vs. multiple), 1031 exchange proceeds, number of funding sources, and proration method (per diem vs. actual/365 vs. 30/360). Triggers on 'funds flow', 'prorations', 'settlement statement', 'wire instructions', 'cash to close', 'net proceeds', 'security deposit transfer', 'closing statement', 'ALTA statement', or when given a closing date, rent roll, tax bill, and purchase price. Calculate and verify funds flow, prorations, wire instructions, and the settlement statement for CRE acquisition closings. Branches by all-cash vs. financed single tranche vs. Activate it inside ChatGPT, Claude, Manus, or OpenClaw by saying something like "Use the Funds Flow Calculator skill" — the Hub routes the request to this skill and the underlying primary-source CRE data feeds backends automatically.

How you'll use it

"Use the Funds Flow Calculator skill"

Say something like this to your AI agent in the Hub, Claude, or ChatGPT to activate this skill.

Skill activation rules

Detailed routing logic, prompts the skill responds to, and operational guardrails as documented by the author.

Calculate and verify funds flow, prorations, wire instructions, and the settlement statement for CRE acquisition closings. Branches by all-cash vs. financed (single tranche vs. multiple), 1031 exchange proceeds, number of funding sources, and proration method (per diem vs. actual/365 vs. 30/360). Triggers on 'funds flow', 'prorations', 'settlement statement', 'wire instructions', 'cash to close', 'net proceeds', 'security deposit transfer', 'closing statement', 'ALTA statement', or when given a closing date, rent roll, tax bill, and purchase price.

What's inside

Funds Flow Calculator

You are a CRE closing attorney and settlement specialist with deep expertise in commercial real estate funds flow memos, HUD-1 / ALTA settlement statements, proration mechanics, and closing wire coordination. Given a closing date, deal structure, rent…

Show full previewShow less

Funds Flow Calculator

You are a CRE closing attorney and settlement specialist with deep expertise in commercial real estate funds flow memos, HUD-1 / ALTA settlement statements, proration mechanics, and closing wire coordination. Given a closing date, deal structure, rent roll, and cost schedule, you produce a precise, audit-ready funds flow memo that balances to the dollar, eliminates wire errors, and eliminates closing-day surprises. Sources always equal uses. Buyer and seller columns always reconcile.

When to Activate

Explicit triggers: "funds flow", "prorations", "settlement statement", "wire instructions", "cash to close", "net proceeds to seller", "security deposit transfer", "closing statement", "ALTA statement", "HUD-1", "prorate taxes", "rent proration", "payoff letter", "payoff calculation", "per diem interest"

Full instructions and any reference files ship in the .skill bundle.

Bundle structure
funds-flow-calculator/
├── SKILL.md                              # Required: instructions + metadata
└── references/                           # Optional: documentation
    ├── closing-cost-allocation.yaml      # 15.7 KB
    ├── proration-methods.md              # 11.3 KB
    └── settlement-statement-template.md  # 15.6 KB

Who built it

With contributions from Avi Hacker.

How to run it

Not in the Hub? Download the .skill bundle above and follow the A.CRE skills install guide → to load it into Claude Desktop, ChatGPT, Cursor, or any other agent that supports skills.

Already in the Hub. If you're an AI.Edge Pro or A.CRE Accelerator member, this skill is bundled into the A.CRE Intelligence Hub direct connector (MCP server) — just ask your agent.

About this skill

Third-Party skill. This skill is redistributed under the Apache-2.0 license and is not authored or endorsed by Adventures in CRE. Use is governed by the upstream license and the original creator's terms. Original attribution: Mario Urquia (link) and contributors (Avi Hacker).