codexkit-fpa-rolling-forecast

Automate rolling financial forecasts with locked actuals and variance waterfalls.

21|12|Updated Mar 20, 2026
One-click install
npx skills add https://github.com/hoavdc/CodexKit --skill codexkit-fpa-rolling-forecast
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: codexkit-fpa-rolling-forecast
Source: https://github.com/hoavdc/CodexKit/tree/main/skills/codexkit-fpa-rolling-forecast
Command: npx skills add https://github.com/hoavdc/CodexKit --skill codexkit-fpa-rolling-forecast

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill automates rolling financial forecasting to maintain a forward-looking 12–18 month horizon by locking completed periods, reforecasting remaining periods, and generating a waterfall bridge that highlights prior-to-new variance.

Core Features & Use Cases

  • Lock actuals and extend horizons to sustain continuous planning.
  • Reforecast drivers (revenue, COGS, OpEx) with scenario support (Base/Bull/Bear) and variance logging.
  • Generate a waterfall bridge and summarize top variance drivers for management reviews.

Quick Start

Provide your YTD actuals, prior forecast, and driver updates, then run the rolling forecast to produce the updated horizon.

Frequently Asked Questions about codexkit-fpa-rolling-forecast

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How does a rolling financial forecast maintain a continuous planning horizon?

A rolling financial forecast maintains a continuous planning horizon by locking completed periods as actuals and reforecasting the remaining months to sustain a forward-looking 12–18 month view.

How do I generate a variance waterfall bridge for management reviews?

Generate a variance waterfall bridge by comparing your prior forecast against new driver updates and YTD actuals. This highlights the prior-to-new variance, summarizing top drivers for management reviews.

Can I run scenario analysis with Base, Bull, and Bear cases in a rolling forecast?

Yes, you can run scenario analysis by reforecasting revenue, COGS, and OpEx drivers with Base, Bull, and Bear scenario support, while logging variances and assumptions with confidence levels for each case.

What data do I need to start reforecasting P&L drivers?

To start reforecasting P&L drivers, provide your YTD actuals, prior forecast, and driver updates. Running the rolling forecast with these inputs produces the updated horizon and variance bridge.

What is the best way to manage assumptions and confidence levels in financial forecasting?

The best way to manage forecasting assumptions is using an integrated assumption log that tracks confidence levels alongside reforecasted drivers, ensuring variance management and scenario analysis remain transparent.