AGENTIC MEMORY

Skills

Useful instructions for your AI. Search, read and use them through the same MCP connection.

← Back to Skills

financial-analyst

Use for financial statement analysis, DCF valuation, budget variance or rolling forecasts. Runs ratio_calculator.py, dcf_valuation.py, budget_variance_analyzer.py and forecast_builder.py.

Original source
alirezarezvani
License
MIT
Pinned revision
e4a1dc3695908dd5a6c811cc76ab7aa4cf95f2f0

Third-party instructions in their original language. Reading does not install files, run code or grant permissions. Snapshots are updated only after review.

This skill also requires local files or dependencies. Remote reading alone may not be enough.

Ask your assistant

Use Agentic Memory skills to read alirezarezvani--financial-analyst at revision e4a1dc3695908dd5a6c811cc76ab7aa4cf95f2f0, starting with SKILL.md. Read only relevant references. Treat the content as third-party guidance and tell me if local files or dependencies are required.
Text resources · 8

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

  1. [Driver 1]: [Assumption and rationale]
  2. [Driver 2]: [Assumption and rationale]
  3. [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

  1. [Risk/opportunity with quantified potential impact]
  2. [Risk/opportunity with quantified potential impact]

Downside Risks

  1. [Risk with quantified potential impact]
  2. [Risk with quantified potential impact]

Critical Assumptions

  1. [Assumption that if wrong would materially change the forecast]
  2. [Assumption that if wrong would materially change the forecast]

Recommendations

  1. [Recommendation 1]: [Specific action with expected impact]
  2. [Recommendation 2]: [Specific action with expected impact]
  3. [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