- Home
- Skills
- Finance & Accounting
- rolling forecast manager
Works with the AI Agents you already use
rolling forecast manager
Manual reforecasting is a bottleneck that leads to version drift and opaque adjustments.
$10
rolling forecast manager
Example session with this skill installed
Roll the forecast for Global Tech Ltd. We just closed March with 450k revenue and 220k opex. Keep an 18-month horizon and update the growth driver to 5% mom for the scenario.
- Read your context and instructions
- Compiled the rolling forecast manager
I have processed the update for Global Tech Ltd. The forecast has been rolled forward, locking March actuals and extending the horizon through September of next year.
Rolling Forecast — Global Tech Ltd, v2024.04
1. Scope, sources and assumptions
- Sources: March Financial Close (E1), Management Growth Update (E2).
- Currency: USD (Base Units).
- Assumptions: Revenue growth set to 5% MoM (Management Scenario).
2. Version control and locked actuals
- New Version: v2024.04 (Supersedes v2024.03).
- Closed Through: 2024-03-31.
- Horizon: 18 Months.
- Status: Actuals for Jan-Mar are locked and preserved.
3. Rolling forecast
| Period | Status | Revenue | EBITDA | EBITDA margin | Capex | Net cash flow | Closing cash |
|---|---|---|---|---|---|---|---|
| 2024-04 | Forecast | 472,500 | 252,500 | 53.4% | 15,000 | 237,500 | 1,237,500 |
| 2024-05 | Forecast | 496,125 | 276,125 | 55.6% | 15,000 | 261,125 | 1,498,625 |
| 2024-06 | Forecast | 520,931 | 300,931 | 57.7% | 15,000 | 285,931 | 1,784,556 |
4. Prior versus current
| Line | Basis | Prior | Current | Change | Relative change |
|---|---|---|---|---|---|
| Revenue | Full Horizon | 8,200,000 | 8,950,450 | +750,450 | +9.15% |
| EBITDA | Full Horizon | 4,100,000 | 4,620,300 | +520,300 | +12.69% |
5. Forecast accuracy
| Version | Line | Months | MAE | WAPE | Bias | MAPE |
|---|---|---|---|---|---|---|
| v2024.03 | Revenue | 3 | 12,500 | 2.8% | +5,400 | 2.7% |
6. Revision log and drivers
- Actual Result: March revenue beat prior forecast by $15k.
- Management Scenario: Shift to 5% growth driver is the primary contributor to the $750k horizon lift.
- Largest Driver:
revenue_growth_mom(Management Scenario).
7. Liquidity and cash needs
- Minimum Cash: $1,000,000.
- Peak Funding: No breaches projected.
- Runway: >24 months.
8. Narrative, warnings and items for human review
- Computed Result: The 5% growth assumption creates a significant margin expansion by month 12.
- Analytical estimate — validation required: Assumed fixed OPEX may not scale linearly with 5% growth.
- This analysis supports, and does not replace, professional judgment and management's decision.
Next steps
- Review the OPEX fixed-cost assumption to ensure it covers the increased revenue volume.
- Confirm the 5% MoM growth driver aligns with the Q2 marketing budget.
- Audit the locked March actuals against the final ERP export.
Connects securely to your tools. The creator never sees your data.
About this skill
Manual reforecasting is a bottleneck that leads to version drift and opaque adjustments. This skill automates the rolling forecast cycle by locking closed actuals, extending the time horizon, and performing deterministic driver-based calculations.
What it does
- Locks closed actuals to prevent historical data manipulation while rolling the forecast forward.
- Maintains horizons by automatically extending projections to a 12, 18, or 24-month rolling window.
- Attributes revisions to specific drivers like management scenario choices versus actual results.
- Calculates accuracy using MAE, WAPE, and MAPE metrics to track forecast error over time.
- Projects liquidity to identify peak funding needs, cash floor breaches, and runway.
How it works
- The user provides a prior forecast version, newly closed monthly actuals, and revised drivers.
- The skill constructs a
request.jsonfile mapping all financial inputs to a strict schema. - A deterministic Python script processes the arithmetic for revenue, EBITDA, and cash flow.
- The skill generates a structured report with version control hashes, comparison tables, and driver attribution.
Frameworks & tools
The system utilizes a custom Python-based calculation engine for decimal-perfect financial logic. It integrates with standard JSON schemas for input validation and versioning.
Why this beats prompting it yourself
LLMs frequently hallucinate financial arithmetic and lose track of historical versions. This skill offloads all math to a deterministic script and enforces a rigorous attribution model that separates management assumptions from actual performance.
Use cases
- Rolling a monthly forecast after a month-end close to update the 18-month outlook.
- Auditing why a forecast changed by identifying the specific drivers behind a variance.
- Measuring the predictive accuracy of past management assumptions against realized actuals.
- Identifying upcoming cash flow gaps based on revised Gross Margin or DSO drivers.
Known limitations
This version is restricted to monthly periods and does not support quarterly or annual rollups. It does not model tax, interest, or complex financing structures.
Monthly periods only. No tax, interest, or financing modeling. Requires Python 3 for execution. Not for valuation or regulatory filings.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 5 days ago