القائمة
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.