forecast

Generate rolling forecasts and scenario analyses for financial planning.

2|Updated Mar 26, 2026
One-click install
npx skills add https://github.com/tmcga/alpha-stack --skill forecast-tmcga
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: forecast
Source: https://github.com/tmcga/alpha-stack/tree/main/skills/forecast
Command: npx skills add https://github.com/tmcga/alpha-stack --skill forecast-tmcga

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Rolling forecasts, scenario planning, and cash flow forecasting are essential for FP&A, treasury, and executive decision-making. This skill provides a structured, driver-based approach to project financial performance under uncertainty, enabling proactive liquidity management and strategic planning.

Core Features & Use Cases

  • Rolling forecasts across 13-week, quarterly, and annual horizons with driver-based models.
  • Scenario planning (base/bull/bear) and Monte Carlo simulations to quantify uncertainty.
  • Direct and indirect cash flow forecasting, liquidity runway analysis, and covenant testing.
  • Working capital forecasting (DSO/DPO/DIO) integrated with revenue and expense drivers.
  • Variance analysis, forecast accuracy tracking, and continuous improvement loops.

Use cases include operational planning, board reporting, liquidity management, and capital allocation.

Quick Start

Provide your historical finance data and driver assumptions, and I will generate a rolling forecast, scenarios, and cash flow projections to help you plan with confidence.

Frequently Asked Questions about forecast

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

FAQPage Schema
How do I build a 13-week rolling cash flow forecast?

A 13-week rolling cash flow forecast requires driver-based modeling to project operating, investing, and financing cash flows. You provide historical finance data and driver assumptions to generate continuous liquidity projections and runway analysis.

What is Monte Carlo simulation in scenario planning and forecasting?

Monte Carlo simulation in scenario planning quantifies uncertainty by running thousands of randomized probability models on your driver assumptions. It validates base, bull, and bear scenarios to provide a confidence interval for revenue and cost projections.

How do I forecast working capital using DSO, DPO, and DIO drivers?

Working capital forecasting integrates Days Sales Outstanding (DSO), Days Payable Outstanding (DPO), and Days Inventory Outstanding (DIO) with revenue and expense drivers to project cash conversion cycles across multiple financial horizons.

Can I use driver-based forecasting for liquidity runway and covenant testing?

Driver-based forecasting supports liquidity runway analysis and covenant testing by projecting future cash balances against operational driver assumptions. This enables proactive treasury management and ensures compliance with financial covenants.

What is the best way to track forecast accuracy and perform variance analysis?

Tracking forecast accuracy involves comparing projected driver-based outcomes against actual historical financial data to identify variances. This continuous improvement loop refines your rolling forecast models and enhances future scenario planning reliability.

Does rolling forecast planning require integrating existing FP&A planning processes?

Rolling forecast planning integrates with existing FP&A processes by applying driver-based models to your current operational data. It structures multi-period revenue and cost projections to align seamlessly with board reporting and capital allocation workflows.