Skip to content

huangjia2019/claude-code-engineering / 04-Skills/projects/03-financial-skill

financial-analyzing

Verified

Analyze 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.

FileKindSize
README.mdmarkdown1.2 KB
SKILL.mdskill md1.9 KB
data/analysis_report.mdmarkdown6.0 KB
data/sample_financials.jsonconfig1.5 KB
reference/costs.mdmarkdown1.4 KB
reference/profitability.mdmarkdown1.7 KB
reference/revenue.mdmarkdown1.2 KB
scripts/calculate_ratios.pyexecutablescript1.9 KB
templates/analysis_report.mdmarkdown1.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`
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: 197kUpdated Claude CodeCodexVerifiedInstall
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: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
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: 194kUpdated Claude CodeCodexVerifiedInstall