메뉴
Use when answering "when do we run out of cash", building a 13-week cash forecast, sizing a credit line, or analyzing near-term liquidity and payment timing in openfpa.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
Use when the user wants their model in Excel with real working formulas - "export this to Excel", "a workbook I can hand my board", "something that recalculates when I change an assumption". Produces a live-formula workbook generated from the model structure and verified against the engine before delivery.
Use when producing a board deck, investor update, or CFO briefing from an openfpa forecast - turning model output into a board-ready narrative and exportable artifacts.
Use when building a new openfpa forecast model from a company's financials - a trial balance, a P&L export, or a pasted income statement - and you need a runnable config to exist before any forecasting or analysis.
Use when modeling a multi-segment company that discloses segment net sales and segment Adjusted EBITDA (ASU 2023-07) but not segment COGS or operating income - rolls segment P&Ls into a consolidated forecast and reconciles total segment Adjusted EBITDA to the disclosed total. Generated for Fox Factory (PVG/AAG/SSG).
Use when you want the model to learn from how its past forecasts actually turned out - scoring forecasts against the company's real actuals, backtesting assumptions on history, and proposing ratified improvements. Runs at/after monthly close.
Use when a human reviewing a forecast catches something off ("December always spikes", "you're double-counting deferred revenue", "that Q3 number was a one-time contract") - captures it as a durable, typed correction in the company's memory so future forecasts are grounded by it.
| name | fpa-cash-runway |
| description | Use when answering "when do we run out of cash", building a 13-week cash forecast, sizing a credit line, or analyzing near-term liquidity and payment timing in openfpa. |
Build the 13-week direct-method cash forecast - the operator's near-term liquidity view. Schedule the known weekly receipts and disbursements, show the raw cash position (no automatic LOC draws), and report the trough and first negative week.
Core principle: Show the unfinanced position. A visible shortfall is the whole point - it sizes the credit line.
openfpa entrypoint-list <company-root> --kind cash. Use the registered cash
workflow when one exists.Cash13Config: opening_cash, weeks (default 13), and receipts/disbursements lists of WeeklyFlow(name, amount, start_week, recurrence). Recurrence is once, weekly, or biweekly. Model what you actually know: AR collections on their expected weeks, payroll on its cadence, inventory POs on their due dates, quarterly tax.import pyfpa
from pyfpa.io.loaders import load_cash13_config
weekly = pyfpa.cash13_forecast(load_cash13_config("examples/ridgeline/cash13.yaml"))
runway = pyfpa.runway_summary(weekly)
# {'min_cash': -146000.0, 'min_week': 7, 'first_negative_week': 3}
min_cash means "needs a draw of at least this much," not "insolvent." first_negative_week is the deadline to act. Size the credit line to the trough plus a buffer.Feed runway into fpa-board-briefing for the writeup.