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
Forecasting Horizon
- Short-term (monthly), Medium-term (annual), or Long-term (3-5 years)?
- What is the specific business unit or product line?
Driver Identification
- What are the primary revenue drivers? (Units, Price, Retention).
- What are the primary cost drivers? (Headcount, Marketing, COGS).
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
- Revenue Modeling (Top-line growth assumptions).
- Resource Allocation (Headcount and OpEx planning).
- Cash Flow Impact (Timing of inflows/outflows).
- Scenario Analysis (Best, Worst, and Base cases).
- 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.pyto self-test; import the functions instead of doing mental math.
References
- Forecasting Best Practices: Evidence-backed modeling standards.
- Scenario Analysis Guide: How to structure what-if models.
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.