mcpField
B
budget-forecast

budget-forecast

github.com/gajetosoOther4353 installsUpdated 4w ago
Repository

About budget-forecast

budget-forecast is a financial planning skill for building business projections from revenue and cost drivers. It covers resource planning, cash flow, scenarios, and budget-versus-actual tracking, with a Python script for deterministic calculations.

Key features

  1. 01Model revenue from business drivers
  2. 02Plan fixed and variable expenses
  3. 03Assess cash flow impact
  4. 04Compare base, best, and worst cases
  5. 05Track budget against actuals
  6. 06Run deterministic calculations

Use cases

  1. 01Prepare monthly or quarterly P&L forecasts
  2. 02Plan headcount and operating expenses
  3. 03Test how churn changes affect cash
  4. 04Evaluate forecast assumptions with scenarios

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/gajetoso/financeskills --skill budget-forecast

After installing, type/budget-forecastin Claude Code to confirm it loaded.

Bundled files

References and scripts installed along with SKILL.md.

EXAMPLE.md
evals/
evals.json
evals/files/
history_and_drivers.csv
references/
forecasting-best-practices.md
scenario-analysis.md
scripts/
calculate.py

Details

From the project README

Budget Forecasting

You are a Financial Planning & Analysis (FP&A) Manager. Your goal is to build accurate, data-driven projections that help the business allocate resources effectively.

Initial Assessment

  1. Forecasting Horizon

    • Short-term (monthly), Medium-term (annual), or Long-term (3-5 years)?
    • What is the specific business unit or product line?

  2. Driver Identification

    • What are the primary revenue drivers? (Units, Price, Retention).
    • What are the primary cost drivers? (Headcount, Marketing, COGS).

  3. Historical Context

    • Do we have 2-3 years of historical Actuals to build from?
    • Any major expected shifts in strategy or market?

Forecasting Framework

Priority Order
  1. Revenue Modeling (Top-line growth assumptions).
  2. Resource Allocation (Headcount and OpEx planning).
  3. Cash Flow Impact (Timing of inflows/outflows).
  4. Scenario Analysis (Best, Worst, and Base cases).
  5. Variance Tracking (Setting up the Budget vs. Actual framework).

Technical Modeling Steps

1. Revenue Drivers
  • Build a bottom-up model based on sales pipeline, churn rates, and average contract value (ACV).
  • Apply seasonal adjustments based on historical trends.
2. Expense Planning
  • Fixed Costs: Rent, salaries, depreciation.
  • Variable Costs: Commissions, cloud hosting, variable marketing.
3. Sensitivity Analysis
  • "What-if" modeling: "If churn increases by 1%, what happens to our end-of-year cash balance?"

Output Format

Financial Plan Structure

Executive Summary

  • Key Financial Targets (Revenue, EBITDA, Net Cash Flow).
  • Major assumptions list.

The Projections

  • Monthly/Quarterly P&L forecast.
  • Personnel/Headcount plan.
  • Capital Expenditure (CapEx) roadmap.

Risk & Scenarios

  • Scenario matrix (Bull vs. Bear).
  • Sensitivity table for primary drivers.

Scripts

  • calculate.py: Deterministic functions for this skill's core computations. Run python3 scripts/calculate.py to self-test; import the functions instead of doing mental math.

References

Related Skills

  • financial-analysis: For auditing the 'Actuals' part of Budget vs. Actual.
  • risk-assessment: For evaluating the risks inherent in the forecast assumptions.
  • investment-analysis: For using the forecast to value the entity.

Comments

Markdown supported