Prompt

You are a financial planning specialist creating a comprehensive budget and financial forecast for [BUSINESS_UNIT/PROJECT] for [TIME_PERIOD].

Develop a complete financial planning package:

## Revenue Forecasting

**Revenue Streams Analysis:**
- Stream 1: [Description] | Historical: $[amount] | Projected: $[amount] | Growth: [%]
- Stream 2: [Description] | Historical: $[amount] | Projected: $[amount] | Growth: [%]
- Stream 3: [Description] | Historical: $[amount] | Projected: $[amount] | Growth: [%]

**Revenue Drivers:**
- Unit volume projections
- Pricing assumptions
- Market share assumptions
- Seasonality factors
- New product/service impact

**Scenario Analysis:**
- Conservative Case: $[amount] (probability: %)
- Base Case: $[amount] (probability: %)
- Optimistic Case: $[amount] (probability: %)

## Expense Budget

**Fixed Costs:**
- Personnel: $[amount] ([% of revenue])
- Facilities: $[amount] ([% of revenue])
- Technology: $[amount] ([% of revenue])
- Insurance: $[amount] ([% of revenue])
- Other Fixed: $[amount] ([% of revenue])

**Variable Costs:**
- Cost of Goods Sold: $[amount] ([% of revenue])
- Sales Commissions: $[amount] ([% of revenue])
- Marketing: $[amount] ([% of revenue])
- Other Variable: $[amount] ([% of revenue])

**One-Time Investments:**
- Capital expenditures: $[amount]
- System implementations: $[amount]
- Market expansion: $[amount]
- Strategic initiatives: $[amount]

## Cash Flow Projections

**Monthly Cash Flow:**
Month 1-12: [Monthly breakdown of inflows and outflows]

**Working Capital Requirements:**
- Accounts Receivable: [Days outstanding] = $[amount]
- Inventory: [Days on hand] = $[amount]
- Accounts Payable: [Days outstanding] = $[amount]
- Net Working Capital: $[amount]

**Funding Requirements:**
- Peak cash needs: $[amount] in [month]
- Ongoing financing needs: $[amount]
- Recommended credit facilities: $[amount]

## Profitability Analysis

**Income Statement Projection:**
- Revenue: $[amount]
- Gross Profit: $[amount] ([% margin])
- Operating Expenses: $[amount]
- EBITDA: $[amount] ([% margin])
- Net Income: $[amount] ([% margin])

**Key Performance Indicators:**
- Revenue per employee: $[amount]
- Customer acquisition cost: $[amount]
- Customer lifetime value: $[amount]
- Payback period: [months]
- Return on investment: [%]

## Variance Analysis & Controls

**Budget vs. Actual Tracking:**
- Monthly variance reports format
- Key variance thresholds
- Root cause analysis process
- Corrective action protocols

**Performance Dashboards:**
- Daily metrics to monitor
- Weekly management reports
- Monthly financial package
- Quarterly business reviews

## Risk Management

**Financial Risks:**
- Revenue shortfall risk: Impact $[amount] | Mitigation: [strategy]
- Cost overrun risk: Impact $[amount] | Mitigation: [strategy]  
- Cash flow risk: Impact $[amount] | Mitigation: [strategy]

**Sensitivity Analysis:**
- If revenue drops 10%: Impact on profit $[amount]
- If costs increase 5%: Impact on profit $[amount]
- If timing delays 30 days: Impact on cash $[amount]

**Contingency Planning:**
- Cost reduction options: $[amount] available
- Revenue acceleration tactics
- Emergency funding sources
- Scenario-based action plans

Provide specific numbers, assumptions, and monitoring frameworks throughout.