assets/forecast_report_template.md
Revenue Forecast Report
Report Header
| Field | Value | |-------|-------| | Company | [Company Name] | | Forecast Period | [Start] to [End] | | Prepared By | [Analyst Name] | | Date | [Report Date] | | Forecast Type | [Driver-Based / Trend-Based / Blended] |
Executive Summary
[2-3 sentence overview of the revenue forecast, key assumptions, and confidence level. Highlight the base case total revenue, expected growth rate, and any significant departures from prior forecast or budget.]
Key Metrics at a Glance
| Metric | Value | |--------|-------| | Base Case Total Revenue | $[X]M | | Expected Growth Rate | [X]% | | Forecast Confidence | [High / Medium / Low] | | Revenue Range (Bear to Bull) | $[X]M - $[X]M | | Primary Revenue Driver | [Driver description] |
Historical Trend Analysis
Revenue Trend
| Period | Revenue | Growth Rate | Gross Margin | |--------|---------|------------|-------------| | [Q/Year-4] | $[X]M | - | [X]% | | [Q/Year-3] | $[X]M | [X]% | [X]% | | [Q/Year-2] | $[X]M | [X]% | [X]% | | [Q/Year-1] | $[X]M | [X]% | [X]% | | [Current] | $[X]M | [X]% | [X]% |
Trend Statistics
| Metric | Value | |--------|-------| | Average Growth Rate | [X]% | | Trend Direction | [Upward / Flat / Downward] | | R-squared (fit quality) | [X] | | Seasonality Detected | [Yes / No] |
Revenue Drivers
Primary Drivers
| Driver | Current Value | Projected Value | Growth | |--------|-------------|-----------------|--------| | [Units / Customers / etc.] | [X] | [X] | [X]% | | [Price / ARPU / etc.] | $[X] | $[X] | [X]% | | [Conversion / Retention] | [X]% | [X]% | [X]pp |
Driver Assumptions
- [Driver 1]: [Assumption and rationale]
- [Driver 2]: [Assumption and rationale]
- [Driver 3]: [Assumption and rationale]
Scenario Comparison
Summary
| Scenario | Total Revenue | Growth Rate | Op. Income | Gross Margin | Probability | |----------|-------------|-------------|-----------|-------------|-------------| | Bull | $[X]M | [X]% | $[X]M | [X]% | [X]% | | Base | $[X]M | [X]% | $[X]M | [X]% | [X]% | | Bear | $[X]M | [X]% | $[X]M | [X]% | [X]% |
Scenario Assumptions
Bull Case:
- [Key assumption 1]
- [Key assumption 2]
- [Trigger: what conditions would cause this scenario]
Base Case:
- [Key assumption 1]
- [Key assumption 2]
Bear Case:
- [Key assumption 1]
- [Key assumption 2]
- [Trigger: what conditions would cause this scenario]
Monthly/Quarterly Forecast Detail (Base Case)
| Period | Revenue | COGS | Gross Profit | OpEx | Op. Income | |--------|---------|------|-------------|------|-----------| | [Period 1] | $[X] | $[X] | $[X] | $[X] | $[X] | | [Period 2] | $[X] | $[X] | $[X] | $[X] | $[X] | | [Period 3] | $[X] | $[X] | $[X] | $[X] | $[X] | | [Period 4] | $[X] | $[X] | $[X] | $[X] | $[X] | | ... | ... | ... | ... | ... | ... | | Total | $[X] | $[X] | $[X] | $[X] | $[X] |
13-Week Rolling Cash Flow
Summary
| Metric | Value | |--------|-------| | Opening Cash Balance | $[X] | | Projected Closing Balance | $[X] | | Net Cash Change | $[X] | | Minimum Cash Balance | $[X] (Week [N]) | | Cash Runway | [N] weeks |
Weekly Cash Flow Projection
| Week | Inflows | Outflows | Net Cash Flow | Closing Balance | |------|---------|----------|--------------|----------------| | 1 | $[X] | $[X] | $[X] | $[X] | | 2 | $[X] | $[X] | $[X] | $[X] | | 3 | $[X] | $[X] | $[X] | $[X] | | ... | ... | ... | ... | ... | | 13 | $[X] | $[X] | $[X] | $[X] |
Cash Flow Notes
- Week [N]: [Description of any significant one-time items]
- Week [N]: [Description of any significant one-time items]
Forecast Accuracy Tracking
vs Prior Forecast
| Metric | Prior Forecast | Current Forecast | Change | |--------|---------------|-----------------|--------| | Revenue | $[X]M | $[X]M | [X]% | | Growth Rate | [X]% | [X]% | [X]pp | | Gross Margin | [X]% | [X]% | [X]pp |
Historical Forecast Accuracy (MAPE)
| Period | Forecast | Actual | Error | MAPE | |--------|----------|--------|-------|------| | [Period-3] | $[X] | $[X] | $[X] | [X]% | | [Period-2] | $[X] | $[X] | $[X] | [X]% | | [Period-1] | $[X] | $[X] | $[X] | [X]% | | Average MAPE | | | | [X]% |
Key Risks and Assumptions
Upside Risks
- [Risk/opportunity with quantified potential impact]
- [Risk/opportunity with quantified potential impact]
Downside Risks
- [Risk with quantified potential impact]
- [Risk with quantified potential impact]
Critical Assumptions
- [Assumption that if wrong would materially change the forecast]
- [Assumption that if wrong would materially change the forecast]
Recommendations
- [Recommendation 1]: [Specific action with expected impact]
- [Recommendation 2]: [Specific action with expected impact]
- [Recommendation 3]: [Specific action with expected impact]
Next Steps
| # | Action | Owner | Due Date | |---|--------|-------|----------| | 1 | [Action item] | [Name] | [Date] | | 2 | [Action item] | [Name] | [Date] | | 3 | [Action item] | [Name] | [Date] |
Report generated using Financial Analyst Skill - Forecast Builder