borghei/Claude-Skills / finance/financial-analyst
financial-analyst
VerifiedPerforms financial ratio analysis, DCF valuation, budget variance analysis, and rolling forecast construction for strategic decision-making
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 20.5 KB |
| assets/dcf_analysis_template.md | markdown | 5.8 KB |
| assets/expected_output.json | config | 5.1 KB |
| assets/forecast_report_template.md | markdown | 5.1 KB |
| assets/sample_financial_data.json | config | 6.3 KB |
| assets/variance_report_template.md | markdown | 3.8 KB |
| references/financial-ratios-guide.md | markdown | 9.0 KB |
| references/forecasting-best-practices.md | markdown | 9.8 KB |
| references/valuation-methodology.md | markdown | 7.7 KB |
| scripts/budget_variance_analyzer.py | script | 14.2 KB |
| scripts/dcf_valuation.py | script | 16.4 KB |
| scripts/forecast_builder.py | script | 18.6 KB |
| scripts/ratio_calculator.py | script | 15.7 KB |
assets/variance_report_template.md
View on GitHub# Budget Variance Report
## Report Header
| Field | Value |
|-------|-------|
| **Company** | [Company Name] |
| **Period** | [Reporting Period] |
| **Prepared By** | [Analyst Name] |
| **Date** | [Report Date] |
| **Materiality Threshold** | [X]% or $[Y]K |
## Executive Summary
[2-3 sentence overview of overall performance vs budget, highlighting whether the company is tracking ahead or behind plan and the primary drivers of variance.]
### Key Metrics
| Metric | Actual | Budget | Variance ($) | Variance (%) | Status |
|--------|--------|--------|-------------|-------------|--------|
| Total Revenue | $[X] | $[X] | $[X] | [X]% | [Fav/Unfav] |
| Total Expenses | $[X] | $[X] | $[X] | [X]% | [Fav/Unfav] |
| Net Income | $[X] | $[X] | $[X] | [X]% | [Fav/Unfav] |
| Operating Margin | [X]% | [X]% | [X]pp | - | [Fav/Unfav] |
## Material Variances
### [Variance Item 1 - e.g., Product Revenue]
| | Actual | Budget | Variance | |
|---|--------|--------|---------|---|
| Amount | $[X] | $[X] | $[X] | [X]% |
**Root Cause:** [Detailed explanation of why this variance occurred]
**Impact:** [Quantified impact on profitability and cash flow]
**Corrective Action:** [Specific steps being taken to address the variance]
**Responsible:** [Owner] | **Target Date:** [Date]
---
### [Variance Item 2]
| | Actual | Budget | Variance | |
|---|--------|--------|---------|---|
| Amount | $[X] | $[X] | $[X] | [X]% |
**Root Cause:** [Explanation]
**Impact:** [Impact]
**Corrective Action:** [Action items]
**Responsible:** [Owner] | **Target Date:** [Date]
---
## Department Performance
| Department | Actual | Budget | Variance ($) | Variance (%) | Favorable | Unfavorable |
|-----------|--------|--------|-------------|-------------|-----------|-------------|
| Sales | $[X] | $[X] | $[X] | [X]% | [N] | [N] |
| Operations | $[X] | $[X] | $[X] | [X]% | [N] | [N] |
| Marketing | $[X] | $[X] | $[X] | [X]% | [N] | [N] |
| Engineering | $[X] | $[X] | $[X] | [X]% | [N] | [N] |
| Finance | $[X] | $[X] | $[X] | [X]% | [N] | [N] |
| HR | $[X] | $[X] | $[X] | [X]% | [N] | [N] |
## Category Breakdown
| Category | Actual | Budget | Variance ($) | Variance (%) |
|----------|--------|--------|-------------|-------------|
| Revenue | $[X] | $[X] | $[X] | [X]% |
| COGS | $[X] | $[X] | $[X] | [X]% |
| Personnel | $[X] | $[X] | $[X] | [X]% |
| Sales & Marketing | $[X] | $[X] | $[X] | [X]% |
| Technology | $[X] | $[X] | $[X] | [X]% |
| G&A | $[X] | $[X] | $[X] | [X]% |
| R&D | $[X] | $[X] | $[X] | [X]% |
## Prior Year Comparison
| Metric | Current Actual | Prior Year | YoY Change ($) | YoY Change (%) |
|--------|---------------|-----------|---------------|---------------|
| Revenue | $[X] | $[X] | $[X] | [X]% |
| Gross Profit | $[X] | $[X] | $[X] | [X]% |
| Operating Income | $[X] | $[X] | $[X] | [X]% |
| Net Income | $[X] | $[X] | $[X] | [X]% |
## Risks and Opportunities
### Risks
1. [Risk description with quantified impact]
2. [Risk description with quantified impact]
### Opportunities
1. [Opportunity description with quantified upside]
2. [Opportunity description with quantified upside]
## Forecast Impact
Based on current variances, the full-year forecast is adjusted as follows:
| Metric | Original FY Forecast | Revised FY Forecast | Change |
|--------|---------------------|--------------------|---------|
| Revenue | $[X] | $[X] | $[X] |
| EBITDA | $[X] | $[X] | $[X] |
| Net Income | $[X] | $[X] | $[X] |
## Action Items
| # | Action | Owner | Due Date | Status |
|---|--------|-------|----------|--------|
| 1 | [Action description] | [Name] | [Date] | [Open/In Progress/Complete] |
| 2 | [Action description] | [Name] | [Date] | [Open/In Progress/Complete] |
| 3 | [Action description] | [Name] | [Date] | [Open/In Progress/Complete] |
---
*Report generated using Financial Analyst Skill - Budget Variance Analyzer*
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |