Best use case
excel-finance is best used when you need a repeatable AI agent workflow instead of a one-off prompt.
Excel 财务模型技能 - Excel 财务模型模板、自动化报表生成
Teams using excel-finance should expect a more consistent output, faster repeated execution, less prompt rewriting.
When to use this skill
- You want a reusable workflow that can be run more than once with consistent structure.
When not to use this skill
- You only need a quick one-off answer and do not need a reusable workflow.
- You cannot install or maintain the underlying files, dependencies, or repository context.
Installation
Claude Code / Cursor / Codex
Manual Installation
- Download SKILL.md from GitHub
- Place it in
.claude/skills/excel-finance/SKILL.mdinside your project - Restart your AI agent — it will auto-discover the skill
How excel-finance Compares
| Feature / Agent | excel-finance | Standard Approach |
|---|---|---|
| Platform Support | Not specified | Limited / Varies |
| Context Awareness | High | Baseline |
| Installation Complexity | Unknown | N/A |
Frequently Asked Questions
What does this skill do?
Excel 财务模型技能 - Excel 财务模型模板、自动化报表生成
Where can I find the source code?
You can find the source code on GitHub using the link provided at the top of the page.
Related Guides
AI Agents for Marketing
Discover AI agents for marketing workflows, from SEO and content production to campaign research, outreach, and analytics.
AI Agents for Startups
Explore AI agent skills for startup validation, product research, growth experiments, documentation, and fast execution with small teams.
AI Agents for Coding
Browse AI agent skills for coding, debugging, testing, refactoring, code review, and developer workflows across Claude, Cursor, and Codex.
SKILL.md Source
# 📊 Excel 财务模型技能
**Excel 财务模型模板与自动化工具**
**作者：** 滚滚家族 🌪️
**版本：** 1.0.0
**主页：** https://aigogoai.com
---
## 🎯 技能描述
**一个帮助财务人快速创建 Excel 财务模型的工具。**
**核心功能：**
- 📊 Excel 财务模型模板
- 📈 自动化报表生成
- 💰 财务预测模型
- 📉 敏感性分析
- 🎯 图表自动生成
---
## 🛠️ 使用方法
### 1. 创建财务模型
```python
from excel_finance import create_financial_model
# 创建三表模型
model = create_financial_model(
company_name="XX 公司",
forecast_years=5,
output_file="financial_model.xlsx"
)
# 输出：Excel 文件路径
```
### 2. 生成财务报表
```python
from excel_finance import generate_reports
# 生成财务报表
reports = generate_reports(
stock_code="600519.SH",
report_types=["balance_sheet", "income_statement", "cash_flow"],
output_file="reports.xlsx"
)
```
### 3. 敏感性分析
```python
from excel_finance import sensitivity_analysis
# 敏感性分析
result = sensitivity_analysis(
base_case={"revenue_growth": 0.15, "margin": 0.5},
scenarios={
"bull": {"revenue_growth": 0.20, "margin": 0.55},
"bear": {"revenue_growth": 0.10, "margin": 0.45}
},
output_file="sensitivity.xlsx"
)
```
---
## 📋 模板列表
### 财务模型模板
| 模板 | 描述 | 适用场景 |
|------|------|----------|
| **三表模型** | 资产负债表 + 利润表 + 现金流量表 | 全面财务分析 |
| **DCF 估值** | 现金流折现模型 | 股票估值 |
| **预算模型** | 年度预算编制 | 企业预算管理 |
| **盈利预测** | 未来 3-5 年盈利预测 | 投资研究 |
### 分析报表模板
| 模板 | 描述 | 适用场景 |
|------|------|----------|
| **财务比率分析** | 盈利能力/偿债能力/营运能力 | 财务健康诊断 |
| **趋势分析** | 3-5 年财务数据趋势 | 成长性分析 |
| **同业对比** | 同行业多公司对比 | 竞争地位分析 |
| **杜邦分析** | ROE 分解分析 | 盈利能力深度分析 |
---
## 📚 参考文档
- [Excel 财务模型教程](https://aigogoai.com/knowledge/excel-models)
- [财务预测方法](https://aigogoai.com/knowledge/financial-forecasting)
- [敏感性分析指南](https://aigogoai.com/knowledge/sensitivity-analysis)
---
## 🌪️ 滚滚的话
**"你只管 do it，Excel 模型交给滚滚！"**
**这个技能是滚滚家族为财务人打造的 Excel 自动化利器，**
**希望能帮助你更高效地完成财务建模工作！**
**如有问题或建议，欢迎反馈！**
**翻滚的地球人，一直在！** 🌪️💚
---
**创建人：** 滚滚 6 号（数据分析师）
**创建时间：** 2026-03-28
**状态：** ✅ 完成Related Skills
afrexai-personal-finance
Complete personal finance system — budgeting, debt payoff, investing, tax optimization, net worth tracking, and financial independence planning. Use when managing money, building wealth, paying off debt, planning retirement, or optimizing taxes. Zero dependencies.
akshare-finance
AKShare财经数据接口库封装，提供股票、期货、期权、基金、外汇、债券、指数、加密货币等金融产品的基本面数据、实时和历史行情数据、衍生数据。
shumen_finance
Mainland China A-share stock and sector analysis tool (中国A股个股与板块分析). Provides real-time stock snapshots, financial statement analysis (财务分析/财报解读), unusual price movement detection (异动分析/支撑压力位), sector and theme analysis (板块分析/概念解读), and market news lookup (市场新闻). Covers price, K-line, money flow, valuation, earnings forecast, and industry ranking for Shanghai and Shenzhen listed equities.
excel-data-import
Import, merge, and transform data from Excel (.xlsx/.csv) files using YAML-driven configuration. Use when the user asks to: (1) import data from Excel/CSV into a template, (2) batch-process multiple files in a directory, (3) merge/consolidate data from multiple sources, (4) map and transform columns with validation rules, (5) do incremental data updates on existing spreadsheets. 当用户要求导入Excel、CSV导入、表格数据导入、Excel数据合并、批量处理Excel、字段映射、数据校验、 表头自动检测、增量更新Excel、多sheet合并时使用此技能。 Supports Chinese field names, multi-layer merged cell headers, auto header detection, CSV (auto-encoding), custom validators, and multi-source imports.
maybe-finance
Personal finance management skill using Maybe Finance OS. Use when users need to track expenses, analyze budgets, monitor net worth, or manage personal finances through the Maybe Finance self-hosted platform. Supports transaction tracking, account management, budget analysis, and financial reporting.
finance
Track stocks, ETFs, indices, crypto (where available), and FX pairs with caching + provider fallbacks.
simple-excel
简单的 Excel 文件处理工具。用于读取、创建、编辑 .xlsx 和 .csv 文件，适合基本的数据操作任务，如读取数据、简单计算、生成表格等。
Konto — Personal Finance API
Query personal finance data from Konto (bank accounts, investments, assets, loans, transactions).
personal-finance
Manage personal finances, track spending by category, set budgets, and receive reminders for EMIs and one-time annual expenses. Use for logging expenses, checking budget status, or setting up financial reminders.
yahoo-finance
Get stock prices, quotes, fundamentals, earnings, options, dividends, and analyst ratings using Yahoo Finance. Uses yfinance library - no API key required.
airoom-ltd-global-finance-data-platform
No description provided.
airoom.ltd-Global-Finance-Data-Platform Product Manual
① Project Vision: