Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    rolling forecast manager

    1

    Manual reforecasting is a bottleneck that leads to version drift and opaque adjustments.

    $10

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    rolling forecast manager

    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

    PeriodStatusRevenueEBITDAEBITDA marginCapexNet cash flowClosing cash
    2024-04Forecast472,500252,50053.4%15,000237,5001,237,500
    2024-05Forecast496,125276,12555.6%15,000261,1251,498,625
    2024-06Forecast520,931300,93157.7%15,000285,9311,784,556

    4. Prior versus current

    LineBasisPriorCurrentChangeRelative change
    RevenueFull Horizon8,200,0008,950,450+750,450+9.15%
    EBITDAFull Horizon4,100,0004,620,300+520,300+12.69%

    5. Forecast accuracy

    VersionLineMonthsMAEWAPEBiasMAPE
    v2024.03Revenue312,5002.8%+5,4002.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

    1. Review the OPEX fixed-cost assumption to ensure it covers the increased revenue volume.
    2. Confirm the 5% MoM growth driver aligns with the Q2 marketing budget.
    3. 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

    1. The user provides a prior forecast version, newly closed monthly actuals, and revised drivers.
    2. The skill constructs a request.json file mapping all financial inputs to a strict schema.
    3. A deterministic Python script processes the arithmetic for revenue, EBITDA, and cash flow.
    4. 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. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 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

    Permissions

    Terminal / Shell
    Read Files
    Write Files
    Environment Variables
    Listed5 days ago

    What's inside

    Frequently Asked Questions

    This skill eliminates 'version drift' and manual calculation errors by using a deterministic Python engine to lock historical actuals and project future months based on your specific financial drivers.

    The skill requires a prior forecast version, your newly closed monthly actuals, and updated drivers provided in a structured format (JSON) to ensure data integrity.

    No, this version is specifically optimized for monthly cycles and does not currently support quarterly or annual rollup logic or tax/interest modeling.

    You receive the logic-driven calculation engine, the structured JSON schemas for data validation, and the automated reporting module that generates version-controlled comparisons.

    The skill performs a deterministic attribution analysis that separates variances caused by management's scenario choices from those caused by actual performance trends.

    Yes, the skill automatically calculates Mean Absolute Error (MAE) and other accuracy metrics to help you track how well your projections match reality over time.

    New in Finance & Accounting