Financial Analysis

Build a financial model for [business/project]:

Purpose: [valuation, budgeting, forecasting, etc.]
Business: [description]
Timeframe: [forecast period]
Key drivers: [revenue and cost drivers]
Data available: [historical data]

Model structure:
- Revenue projections by stream
- Cost structure (fixed vs variable)
- Capital requirements
- Working capital assumptions
- Depreciation and amortization
- Tax considerations
- Sensitivity analysis variables
- Scenario modeling (base, optimistic, pessimistic)
- Key metrics (IRR, NPV, payback, margins)
- Output summaries and dashboards

Analyze variances for [department/company] for [period]:

Actual results: [summarize]
Budget/forecast: [planned amounts]
Key variances: [which line items]
Material threshold: [what's significant]

Analyze:
- Revenue variances (volume vs price)
- Expense variances by category
- Favorable vs unfavorable
- Root cause analysis for material variances
- Trend vs prior periods
- Impact on full-year outlook
- Management actions taken/needed
- Forecast revisions recommended
- Executive summary

Format for leadership review.

Analyze profitability for [product/customer/segment]:

Scope: [what you're analyzing]
Cost data: [available cost information]
Revenue: [sales data]
Time period: [period]
Goal: [what decision needs to be made]

Analysis components:
- Revenue by category
- Direct costs allocation
- Indirect costs allocation methodology
- Contribution margin by segment
- Gross vs net profitability
- Customer/product ranking
- Profitability trends
- Benchmark comparison
- Strategic recommendations
- Action items

Develop scenario analysis for [business decision/situation]:

Decision: [what you're evaluating]
Base case assumptions: [current plan]
Uncertainties: [key variables]
Time horizon: [period]
Stakeholders: [decision makers]

Create scenarios:
- Scenario definitions (3-4 scenarios)
- Key assumption differences
- Financial impact modeling
- Probability assessment
- Risk and opportunity identification
- Strategic implications
- Trigger points for each scenario
- Recommended actions by scenario
- Monitoring metrics
- Decision framework

Evaluate this investment opportunity:

Investment: [description]
Amount required: [capital]
Expected returns: [projections]
Timeframe: [holding period]
Risk factors: [risks]
Alternatives: [other options]

Evaluate:
- Cash flow projections
- NPV calculation (with discount rate rationale)
- IRR and MIRR
- Payback period
- Profitability index
- Risk assessment (qualitative and quantitative)
- Sensitivity analysis
- Break-even analysis
- Strategic fit
- Recommendation with rationale

Create a cash flow forecast for [business/project]:

Business: [description]
Forecast period: [timeframe]
Seasonality: [patterns]
Growth plans: [expansion plans]
Payment terms: [AR/AP terms]
Current cash: [starting position]

Forecast components:
- Operating cash flows (weekly/monthly)
- Receivables collection schedule
- Payables payment schedule
- Capex requirements
- Debt service
- Minimum cash balance requirement
- Peak funding needs
- Surplus/deficit periods
- Financing strategy
- Scenario analysis

Design a financial KPI dashboard for [audience/purpose]:

Audience: [executives, board, department]
Business: [type and size]
Current challenges: [what needs visibility]
Decisions supported: [what dashboard informs]
Data sources: [available systems]

Dashboard design:
- 5-8 key metrics with definitions
- Leading vs lagging indicators
- Visualization type for each
- Comparison periods (YoY, budget, etc.)
- Drill-down capabilities
- Alert thresholds
- Update frequency
- Layout and grouping
- Narrative/commentary section
- Action items tracking

Create an executive financial summary for [period]:

Period: [timeframe]
Audience: [board, investors, executives]
Performance: [high-level results]
Key events: [significant items]
Format: [presentation, memo, report]

Summary components:
- Headlines (3-4 key takeaways)
- Financial highlights (revenue, profit, cash)
- Performance vs expectations
- Key metrics and trends
- Significant events/transactions
- Outlook and guidance
- Risks and opportunities
- Strategic initiatives update
- Appendix items

Keep to 1-2 pages with visuals.