Skip to content
SkillReady to runFinance

Capital-Call Cash Forecast

Written in-house · editorially graded

Every SkillsBank offering is written in-house — never scraped or crowd-sourced — and graded against a fixed editorial rubric in a separate grading step.

Dry-run test passed · Jun 15, 2026

Trigger check passed

Editorially graded · Jun 15, 2026

Takes a fund's existing monthly cash-flow forecast workbook (.xlsx) and a capital-call schedule, inserts LP contribution inflows (and any scheduled distributions) into the correct month columns, recalculates every downstream net-cash and surplus/shortfall formula, and appends a Summary tab with an unfunded-commitment tracker and a combo trend chart. Returns the enriched, editable .xlsx preserving the user's original formatting, tab structure, and formulas. Use when a fund controller or finance team member has received a capital-call notice and needs the live forecast updated before an IC meeting, LP report, or treasury review.

What you get

An installable SKILL.md file for your AI assistant. Produces an Excel workbook (.xlsx).

Works in
Claude Code · Cursor
Native — drops into .claude/skills/
Copilot · Codex · Gemini CLI
Native — reads .agents/skills/
claude.ai — web & desktop
Upload the .zip in Customize → Skills
ChatGPT
Via a Project — paste into its instructions

See it in action

A real input → output sample

Sample input
Attach file FundABC_CashForecast_2025.xlsx and provide the message: 'Please update my fund’s cash flow forecast with these capital calls: 1) Anchor LP, settlement 2026-01-15, $5,000,000 2) Co-Investor B, settlement 2026-03-01, $2,500,000 I think total committed is $50M but not sure. There’s no LP contributions row yet. Can you add a Summary tab? No distributions to include at this point.'
Sample output
Sample Excel output produced by the Capital-Call Cash Forecast skill
Produced by an AI assistant following this skill on the sample input above.
View the full output as text
Example Output
Your workbook has been updated with the two capital calls ($5M in Jan 2026, $2.5M in Mar 2026). A new 'LP Capital Contributions' row was added in Financing Activities. One hardcoded Ending Cash Balance (Apr 2026, original $8,100,000) was replaced with a live formula – please confirm the original value wasn’t intentional. No scenario columns were detected. Would you like me to add a stress-case column? (Default assumption: calls accelerated by one month, distributions unchanged.) [MISSING: Total Committed Capital — $50,000,000 was assumed from your estimate; please confirm or correct this figure.] [ASSUMED: Called To Date of $12,000,000 taken from Assumptions tab cell B12 — please verify.] **Needs input: 2 item(s)**

Goes well with

Related