菜单
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.
用 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 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.
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.
| name | fpa-board-briefing |
| description | 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. |
Turn forecast output into a board/investor-grade briefing: the headline numbers, the cash story, what changed, and the risks - as markdown and Excel. Make the operator look like they have a CFO.
Core principle: A board wants the story and the three things that matter, not a data dump.
openfpa entrypoint-list <company-root> --kind report. Use a registered
briefing workflow when one exists.import pyfpa
from pyfpa.io.loaders import load_cash13_config
monthly = pyfpa.cashflow_from_config(pyfpa.load_config("examples/ridgeline/config.yaml"))
runway = pyfpa.runway_summary(pyfpa.cash13_forecast(load_cash13_config("examples/ridgeline/cash13.yaml")))
from pyfpa.io.reporting import to_briefing_md, forecast_to_excel
md = to_briefing_md(monthly, title="Acme Inc.", runway=runway)
forecast_to_excel(monthly, "forecast.xlsx")
to_briefing_md emits a headline (revenue, EBITDA, net income, ending cash), an optional 13-week runway section, and a monthly table.to_briefing_md emits only the headline, the optional runway section, and the monthly table - it has no narrative slot. So author your own markdown around it: prepend a ## What changed section (the 3 things that moved) and append ## Risks (3 forward risks) and ## The ask (e.g. "approve a $200K line to bridge the spring build"). The rendered briefing is the data spine; you supply the story.ebitda as true EBITDA if D&A matters.python examples/ridgeline/run_demo.py runs this whole path on the synthetic demo and writes docs/demo/briefing.md + forecast.xlsx.