Financial Analyst Skill
When to Use
Use this skill when the user wants to:
- run ratio analysis or valuation work
- build or review a DCF
- analyze budget variance or forecast performance
- turn financial statement data into executive insights
Usage
Recommended flow:
scope analysis goal
-> collect and validate inputs
-> run the appropriate model
-> interpret outputs
-> present insights and follow-up actions
Overview
Production-ready financial analysis toolkit providing ratio analysis, DCF valuation, budget variance analysis, and rolling forecast construction. Designed for financial analysts with 3-6 years experience performing financial modeling, forecasting & budgeting, management reporting, business performance analysis, and investment analysis.
5-Phase Workflow
Phase 1: Scoping
- Define analysis objectives and stakeholder requirements
- Identify data sources and time periods
- Establish materiality thresholds and accuracy targets
- Select appropriate analytical frameworks
Phase 2: Data Analysis & Modeling
- Collect and validate financial data (income statement, balance sheet, cash flow)
- Calculate financial ratios across 5 categories (profitability, liquidity, leverage, efficiency, valuation)
- Build DCF models with WACC and terminal value calculations
- Construct budget variance analyses with favorable/unfavorable classification
- Develop driver-based forecasts with scenario modeling
Phase 3: Insight Generation
- Interpret ratio trends and benchmark against industry standards
- Identify material variances and root causes
- Assess valuation ranges through sensitivity analysis
- Evaluate forecast scenarios (base/bull/bear) for decision support
Phase 4: Reporting
- Generate executive summaries with key findings
- Produce detailed variance reports by department and category
- Deliver DCF valuation reports with sensitivity tables
- Present rolling forecasts with trend analysis
Phase 5: Follow-up
- Track forecast accuracy (target: +/-5% revenue, +/-3% expenses)
- Monitor report delivery timeliness (target: 100% on time)
- Update models with actuals as they become available
- Refine assumptions based on variance analysis
Tools
1. Ratio Calculator (scripts/ratio_calculator.py)
Calculate and interpret financial ratios from financial statement data.
Ratio Categories:
- Profitability: ROE, ROA, Gross Margin, Operating Margin, Net Margin
- Liquidity: Current Ratio, Quick Ratio, Cash Ratio
- Leverage: Debt-to-Equity, Interest Coverage, DSCR
- Efficiency: Asset Turnover, Inventory Turnover, Receivables Turnover, DSO
- Valuation: P/E, P/B, P/S, EV/EBITDA, PEG Ratio
python scripts/ratio_calculator.py sample_financial_data.json
python scripts/ratio_calculator.py sample_financial_data.json --format json
python scripts/ratio_calculator.py sample_financial_data.json --category profitability
2. DCF Valuation (scripts/dcf_valuation.py)
Discounted Cash Flow enterprise and equity valuation with sensitivity analysis.
Features:
- WACC calculation via CAPM
- Revenue and free cash flow projections (5-year default)
- Terminal value via perpetuity growth and exit multiple methods
- Enterprise value and equity value derivation
- Two-way sensitivity analysis (discount rate vs growth rate)
python scripts/dcf_valuation.py valuation_data.json
python scripts/dcf_valuation.py valuation_data.json --format json
python scripts/dcf_valuation.py valuation_data.json --projection-years 7
3. Budget Variance Analyzer (scripts/budget_variance_analyzer.py)
Analyze actual vs budget vs prior year performance with materiality filtering.
Features:
- Dollar and percentage variance calculation
- Materiality threshold filtering (default: 10% or $50K)
- Favorable/unfavorable classification with revenue/expense logic
- Department and category breakdown
- Executive summary generation
python scripts/budget_variance_analyzer.py budget_data.json
python scripts/budget_variance_analyzer.py budget_data.json --format json
python scripts/budget_variance_analyzer.py budget_data.json --threshold-pct 5 --threshold-amt 25000
4. Forecast Builder (scripts/forecast_builder.py)
Driver-based revenue forecasting with rolling cash flow projection and scenario modeling.
Features:
- Driver-based revenue forecast model
- 13-week rolling cash flow projection
- Scenario modeling (base/bull/bear cases)
- Trend analysis using simple linear regression (standard library)
python scripts/forecast_builder.py forecast_data.json
python scripts/forecast_builder.py forecast_data.json --format json
python scripts/forecast_builder.py forecast_data.json --scenarios base,bull,bear
Knowledge Bases
| Reference |
Purpose |
references/financial-ratios-guide.md |
Ratio formulas, interpretation, industry benchmarks |
references/valuation-methodology.md |
DCF methodology, WACC, terminal value, comps |
references/forecasting-best-practices.md |
Driver-based forecasting, rolling forecasts, accuracy |
Templates
| Template |
Purpose |
assets/variance_report_template.md |
Budget variance report template |
assets/dcf_analysis_template.md |
DCF valuation analysis template |
assets/forecast_report_template.md |
Revenue forecast report template |
Industry Adaptations
SaaS
- Key metrics: MRR, ARR, CAC, LTV, Churn Rate, Net Revenue Retention
- Revenue recognition: subscription-based, deferred revenue tracking
- Unit economics: CAC payback period, LTV/CAC ratio
- Cohort analysis for retention and expansion revenue
Retail
- Key metrics: Same-store sales, Revenue per square foot, Inventory turnover
- Seasonal adjustment factors in forecasting
- Gross margin analysis by product category
- Working capital cycle optimization
Manufacturing
- Key metrics: Gross margin by product line, Capacity utilization, COGS breakdown
- Bill of materials cost analysis
- Absorption vs variable costing impact
- Capital expenditure planning and ROI
Financial Services
- Key metrics: Net Interest Margin, Efficiency Ratio, ROA, Tier 1 Capital
- Regulatory capital requirements
- Credit loss provisioning and reserves
- Fee income analysis and diversification
Healthcare
- Key metrics: Revenue per patient, Payer mix, Days in A/R, Operating margin
- Reimbursement rate analysis by payer
- Case mix index impact on revenue
- Compliance cost allocation
Key Metrics & Targets
| Metric |
Target |
| Forecast accuracy (revenue) |
+/-5% |
| Forecast accuracy (expenses) |
+/-3% |
| Report delivery |
100% on time |
| Model documentation |
Complete for all assumptions |
| Variance explanation |
100% of material variances |
Input Data Format
All scripts accept JSON input files. See assets/sample_financial_data.json for the complete input schema covering all four tools.
Dependencies
None - All scripts use Python standard library only (math, statistics, json, argparse, datetime). No numpy, pandas, or scipy required.
1---
2name: financial-analyst
3description: 'Performs financial ratio analysis, DCF valuation, budget variance analysis, and rolling forecast construction for strategic decision-making'
4zh_description: "分析财务报表、经营表现、估值和情景假设。"
5version: "1.0.1"
6author: "seaworld008"
7source: "in-house"
8source_url: ""
9tags: '["analyst", "finance", "financial"]'
10created_at: "2026-03-18"
11updated_at: "2026-09-06"
12quality: 4
13complexity: "intermediate"
14metadata:
15 source: https://skillmd.com/skills/seaworld008/financial-analyst
16---
17
18# Financial Analyst Skill
19
20## When to Use
21
22Use this skill when the user wants to:
23
24- run ratio analysis or valuation work
25- build or review a DCF
26- analyze budget variance or forecast performance
27- turn financial statement data into executive insights
28
29## Usage
30
31Recommended flow:
32
33```text
34scope analysis goal
35-> collect and validate inputs
36-> run the appropriate model
37-> interpret outputs
38-> present insights and follow-up actions
39```
40
41## Overview
42
43Production-ready financial analysis toolkit providing ratio analysis, DCF valuation, budget variance analysis, and rolling forecast construction. Designed for financial analysts with 3-6 years experience performing financial modeling, forecasting & budgeting, management reporting, business performance analysis, and investment analysis.
44
45## 5-Phase Workflow
46
47### Phase 1: Scoping
48- Define analysis objectives and stakeholder requirements
49- Identify data sources and time periods
50- Establish materiality thresholds and accuracy targets
51- Select appropriate analytical frameworks
52
53### Phase 2: Data Analysis & Modeling
54- Collect and validate financial data (income statement, balance sheet, cash flow)
55- Calculate financial ratios across 5 categories (profitability, liquidity, leverage, efficiency, valuation)
56- Build DCF models with WACC and terminal value calculations
57- Construct budget variance analyses with favorable/unfavorable classification
58- Develop driver-based forecasts with scenario modeling
59
60### Phase 3: Insight Generation
61- Interpret ratio trends and benchmark against industry standards
62- Identify material variances and root causes
63- Assess valuation ranges through sensitivity analysis
64- Evaluate forecast scenarios (base/bull/bear) for decision support
65
66### Phase 4: Reporting
67- Generate executive summaries with key findings
68- Produce detailed variance reports by department and category
69- Deliver DCF valuation reports with sensitivity tables
70- Present rolling forecasts with trend analysis
71
72### Phase 5: Follow-up
73- Track forecast accuracy (target: +/-5% revenue, +/-3% expenses)
74- Monitor report delivery timeliness (target: 100% on time)
75- Update models with actuals as they become available
76- Refine assumptions based on variance analysis
77
78## Tools
79
80### 1. Ratio Calculator (`scripts/ratio_calculator.py`)
81
82Calculate and interpret financial ratios from financial statement data.
83
84**Ratio Categories:**
85- **Profitability:** ROE, ROA, Gross Margin, Operating Margin, Net Margin
86- **Liquidity:** Current Ratio, Quick Ratio, Cash Ratio
87- **Leverage:** Debt-to-Equity, Interest Coverage, DSCR
88- **Efficiency:** Asset Turnover, Inventory Turnover, Receivables Turnover, DSO
89- **Valuation:** P/E, P/B, P/S, EV/EBITDA, PEG Ratio
90
91```bash
92python scripts/ratio_calculator.py sample_financial_data.json
93python scripts/ratio_calculator.py sample_financial_data.json --format json
94python scripts/ratio_calculator.py sample_financial_data.json --category profitability
95```
96
97### 2. DCF Valuation (`scripts/dcf_valuation.py`)
98
99Discounted Cash Flow enterprise and equity valuation with sensitivity analysis.
100
101**Features:**
102- WACC calculation via CAPM
103- Revenue and free cash flow projections (5-year default)
104- Terminal value via perpetuity growth and exit multiple methods
105- Enterprise value and equity value derivation
106- Two-way sensitivity analysis (discount rate vs growth rate)
107
108```bash
109python scripts/dcf_valuation.py valuation_data.json
110python scripts/dcf_valuation.py valuation_data.json --format json
111python scripts/dcf_valuation.py valuation_data.json --projection-years 7
112```
113
114### 3. Budget Variance Analyzer (`scripts/budget_variance_analyzer.py`)
115
116Analyze actual vs budget vs prior year performance with materiality filtering.
117
118**Features:**
119- Dollar and percentage variance calculation
120- Materiality threshold filtering (default: 10% or $50K)
121- Favorable/unfavorable classification with revenue/expense logic
122- Department and category breakdown
123- Executive summary generation
124
125```bash
126python scripts/budget_variance_analyzer.py budget_data.json
127python scripts/budget_variance_analyzer.py budget_data.json --format json
128python scripts/budget_variance_analyzer.py budget_data.json --threshold-pct 5 --threshold-amt 25000
129```
130
131### 4. Forecast Builder (`scripts/forecast_builder.py`)
132
133Driver-based revenue forecasting with rolling cash flow projection and scenario modeling.
134
135**Features:**
136- Driver-based revenue forecast model
137- 13-week rolling cash flow projection
138- Scenario modeling (base/bull/bear cases)
139- Trend analysis using simple linear regression (standard library)
140
141```bash
142python scripts/forecast_builder.py forecast_data.json
143python scripts/forecast_builder.py forecast_data.json --format json
144python scripts/forecast_builder.py forecast_data.json --scenarios base,bull,bear
145```
146
147## Knowledge Bases
148
149| Reference | Purpose |
150|-----------|---------|
151| `references/financial-ratios-guide.md` | Ratio formulas, interpretation, industry benchmarks |
152| `references/valuation-methodology.md` | DCF methodology, WACC, terminal value, comps |
153| `references/forecasting-best-practices.md` | Driver-based forecasting, rolling forecasts, accuracy |
154
155## Templates
156
157| Template | Purpose |
158|----------|---------|
159| `assets/variance_report_template.md` | Budget variance report template |
160| `assets/dcf_analysis_template.md` | DCF valuation analysis template |
161| `assets/forecast_report_template.md` | Revenue forecast report template |
162
163## Industry Adaptations
164
165### SaaS
166- Key metrics: MRR, ARR, CAC, LTV, Churn Rate, Net Revenue Retention
167- Revenue recognition: subscription-based, deferred revenue tracking
168- Unit economics: CAC payback period, LTV/CAC ratio
169- Cohort analysis for retention and expansion revenue
170
171### Retail
172- Key metrics: Same-store sales, Revenue per square foot, Inventory turnover
173- Seasonal adjustment factors in forecasting
174- Gross margin analysis by product category
175- Working capital cycle optimization
176
177### Manufacturing
178- Key metrics: Gross margin by product line, Capacity utilization, COGS breakdown
179- Bill of materials cost analysis
180- Absorption vs variable costing impact
181- Capital expenditure planning and ROI
182
183### Financial Services
184- Key metrics: Net Interest Margin, Efficiency Ratio, ROA, Tier 1 Capital
185- Regulatory capital requirements
186- Credit loss provisioning and reserves
187- Fee income analysis and diversification
188
189### Healthcare
190- Key metrics: Revenue per patient, Payer mix, Days in A/R, Operating margin
191- Reimbursement rate analysis by payer
192- Case mix index impact on revenue
193- Compliance cost allocation
194
195## Key Metrics & Targets
196
197| Metric | Target |
198|--------|--------|
199| Forecast accuracy (revenue) | +/-5% |
200| Forecast accuracy (expenses) | +/-3% |
201| Report delivery | 100% on time |
202| Model documentation | Complete for all assumptions |
203| Variance explanation | 100% of material variances |
204
205## Input Data Format
206
207All scripts accept JSON input files. See `assets/sample_financial_data.json` for the complete input schema covering all four tools.
208
209## Dependencies
210
211**None** - All scripts use Python standard library only (`math`, `statistics`, `json`, `argparse`, `datetime`). No numpy, pandas, or scipy required.