huangjia2019/claude-code-engineering / 04-Skills/projects/03-financial-skill
financial-analyzing
VerifiedAnalyze financial data, calculate financial ratios, and generate analysis reports. Use when the user asks about revenue, costs, profits, margins, ROI, financial metrics, or needs financial analysis of a company or project.
| File | Kind | Size |
|---|---|---|
| README.md | markdown | 1.2 KB |
| SKILL.md | skill md | 1.9 KB |
| data/analysis_report.md | markdown | 6.0 KB |
| data/sample_financials.json | config | 1.5 KB |
| reference/costs.md | markdown | 1.4 KB |
| reference/profitability.md | markdown | 1.7 KB |
| reference/revenue.md | markdown | 1.2 KB |
| scripts/calculate_ratios.pyexecutable | script | 1.9 KB |
| templates/analysis_report.md | markdown | 1.1 KB |
data/analysis_report.md
View on GitHub# Financial Analysis Report — TechVision AI
## Executive Summary
TechVision AI 在 2025 年度展现出强劲的增长势头。全年营收 1,370 万元,同比增长 34.31%,属于高增长企业。毛利率 70.53% 位于 SaaS 行业典型区间(70-85%),净利率 19.56%,ROE 高达 43.23%,整体盈利能力优秀。四个季度营收呈持续上升趋势,客户数从 1,200 增长至 1,750。建议关注 Q3 新客获取放缓的信号,并持续优化运营费用率。
## Company/Project Overview
- **Name**: TechVision AI
- **Period Analyzed**: 2025 Q1–Q4
- **Data Sources**: `data/sample_financials.json`
- **Industry**: Software / SaaS
## Key Metrics
| Metric | Value | Industry Avg (SaaS) | Assessment |
|--------|-------|---------------------|------------|
| Revenue Growth | 34.31% | 15-25% | **Above** |
| Gross Margin | 70.53% | 70-85% | On Track |
| Operating Margin | 28.93% | 15-25% | **Above** |
| Net Margin | 19.56% | 10-20% | On Track |
| ROA | 23.30% | >10% Excellent | **Excellent** |
| ROE | 43.23% | >15% Excellent | **Excellent** |
## Detailed Analysis
### Revenue Analysis
**年度总览**
| 指标 | 数值 |
|------|------|
| 2025 年营收 | ¥13,700,000 |
| 2024 年营收 | ¥10,200,000 |
| 同比增长率 | 34.31% (高增长) |
**季度趋势**
| 季度 | 营收 | 环比增长率 |
|------|------|-----------|
| Q1 | ¥2,800,000 | — |
| Q2 | ¥3,200,000 | +14.29% |
| Q3 | ¥3,600,000 | +12.50% |
| Q4 | ¥4,100,000 | +13.89% |
营收逐季稳步增长,环比增长率维持在 12-14% 区间,增长节奏健康且稳定。Q4 单季营收突破 400 万,显示出良好的增长加速迹象。
### Cost Analysis
**成本结构**
| 项目 | 年度金额 | 占营收比 |
|------|---------|---------|
| 营业成本 (COGS) | ¥4,037,000 | 29.47% |
| 运营费用 (OPEX) | ¥5,700,000 | 41.61% |
| **总成本** | **¥9,737,000** | **71.07%** |
**季度 COGS 占比变化**
| 季度 | COGS | COGS 占比 |
|------|------|----------|
| Q1 | ¥840,000 | 30.00% |
| Q2 | ¥928,000 | 29.00% |
| Q3 | ¥1,080,000 | 30.00% |
| Q4 | ¥1,189,000 | 29.00% |
COGS 占比稳定在 29-30%,成本控制良好,未出现随规模扩大而恶化的情况。
**客户获取成本 (CAC)**
| 季度 | 销售营销支出 | 新客户数 | CAC |
|------|------------|---------|-----|
| Q1 | ¥450,000 | 150 | ¥3,000 |
| Q2 | ¥520,000 | 180 | ¥2,889 |
| Q3 | ¥580,000 | 170 | ¥3,412 |
| Q4 | ¥620,000 | 200 | ¥3,100 |
Q3 的 CAC 上升至 ¥3,412 值得关注——新客户数量较 Q2 下降但营销支出增加,获客效率暂时下降。Q4 已有所恢复。
### Profitability Analysis
**利润指标**
| 指标 | 计算 | 结果 |
|------|------|------|
| 毛利润 | ¥13,700,000 - ¥4,037,000 | **¥9,663,000** |
| 毛利率 | ¥9,663,000 / ¥13,700,000 | **70.53%** |
| 营业利润 | ¥13,700,000 - ¥4,037,000 - ¥5,700,000 | **¥3,963,000** |
| 营业利润率 | ¥3,963,000 / ¥13,700,000 | **28.93%** |
| 净利润 | | **¥2,680,000** |
| 净利率 | ¥2,680,000 / ¥13,700,000 | **19.56%** |
**季度净利润趋势**
| 季度 | 净利润 | 净利率 |
|------|--------|--------|
| Q1 | ¥520,000 | 18.57% |
| Q2 | ¥630,000 | 19.69% |
| Q3 | ¥680,000 | 18.89% |
| Q4 | ¥850,000 | 20.73% |
净利率从 Q1 的 18.57% 逐步攀升至 Q4 的 20.73%,盈利能力持续改善。
**资本回报**
| 指标 | 数值 | 基准 | 评估 |
|------|------|------|------|
| ROA | 23.30% | >10% 为优 | 远超基准 |
| ROE | 43.23% | >15% 为优 | 远超基准 |
ROE 显著高于 ROA,说明公司合理运用了财务杠杆放大了股东回报。
## Trend Analysis
**核心指标季度走势**
| 指标 | Q1 | Q2 | Q3 | Q4 | 趋势 |
|------|-----|-----|-----|-----|------|
| 营收 (万元) | 280 | 320 | 360 | 410 | ↑ 稳步上升 |
| 毛利率 | 70.00% | 71.00% | 70.00% | 71.00% | → 稳定 |
| 净利率 | 18.57% | 19.69% | 18.89% | 20.73% | ↑ 改善 |
| 客户数 | 1,200 | 1,380 | 1,550 | 1,750 | ↑ 持续增长 |
| CAC | ¥3,000 | ¥2,889 | ¥3,412 | ¥3,100 | ↕ 波动 |
**关键发现**:
1. 营收和客户数均保持双位数增长,增长动力充足
2. 毛利率稳定在 70-71%,成本管控有效
3. 净利率逐步走高,规模效应开始显现
4. Q3 获客效率短暂下降后 Q4 已修复
## Recommendations
### Immediate Actions
1. **深入分析 Q3 获客效率下降原因** — CAC 从 ¥2,889 跳升至 ¥3,412,需排查是渠道疲劳、竞争加剧还是季节性因素
2. **优化运营费用结构** — OPEX 占比 41.61%,有进一步压缩空间,建议审查各部门预算分配
### Medium-term Improvements
1. **提升客户 ARPU** — 当前年化 ARPU 约 ¥7,829 (¥13,700,000 / 1,750),可通过增值服务和高级功能包提升单客价值
2. **建立 LTV:CAC 监控体系** — 确保客户终身价值与获取成本比 > 3:1
### Long-term Strategy
1. **追求规模效应下的利润率提升** — 营收增长 34% 的同时应推动净利率从 ~20% 向 25% 迈进
2. **多元化收入来源** — 减少对单一产品线的依赖,降低营收集中度风险
## Risk Factors
- **获客成本波动** — Q3 CAC 上升 18% 的波动需要持续监控,若趋势持续将压缩利润空间
- **运营费用增速** — OPEX 从 Q1 ¥120 万增至 Q4 ¥165 万(+37.5%),增速略快于营收增速(+46.4%),需注意控制
- **ROE 远高于 ROA** — 差值较大意味着杠杆率较高,需关注负债结构和偿债能力
- **客户集中度** — 数据中未提供客户分布信息,需确认是否存在大客户依赖风险
## Appendix
### A. 计算过程
```
毛利率 = (13,700,000 - 4,037,000) / 13,700,000 × 100% = 70.53%
营业利润率 = (13,700,000 - 4,037,000 - 5,700,000) / 13,700,000 × 100% = 28.93%
净利率 = 2,680,000 / 13,700,000 × 100% = 19.56%
营收增长率 = (13,700,000 - 10,200,000) / 10,200,000 × 100% = 34.31%
ROA = 2,680,000 / 11,500,000 × 100% = 23.30%
ROE = 2,680,000 / 6,200,000 × 100% = 43.23%
```
### B. 数据来源
原始数据文件:`data/sample_financials.json`
计算工具:`scripts/calculate_ratios.py`
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: 197k | 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 |