skills.rest
Duzhenyang111
Duzhenyang111COMMUNITY
Explore all skills by this author →
GitHub

3-statement-model

Populate and link income statement, balance sheet, and cash flow templates.

Updated Jun 5, 2026
Search Tags:#financial modeling#Excel#financial analysis#financial reporting#model completion
One-click install
npx skills add https://github.com/Duzhenyang111/stock_money --skill 3-statement-model-duzhenyang111
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: 3-statement-model
Source: https://github.com/Duzhenyang111/stock_money/tree/main/financial-services-main/plugins/vertical-plugins/financial-analysis/skills/3-statement-model
Command: npx skills add https://github.com/Duzhenyang111/stock_money --skill 3-statement-model-duzhenyang111

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, office-js, python, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill streamlines the process of completing financial models by automating the filling out of Income Statement, Balance Sheet, and Cash Flow Statement templates.

Core Features & Use Cases

  • Automated Model Completion: Populate financial model templates with data, ensuring proper linkages between statements.
  • Customizable Environments: Supports both Office JS and Python environments for different use cases.
  • Professional Formatting: Implements a blue/grey palette for a consistent, professional look.
  • Quality Checks: Includes validation for cross-tab linkages, balance checks, and cash tie-outs.

Quick Start

Use the 3-statement-model skill to populate the financial model template 'financial_model.xlsx'.

Frequently Asked Questions about 3-statement-model

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate financial model completion in Excel?▼

Automating financial model completion in Excel is done by using this Skill to populate Income Statement, Balance Sheet, and Cash Flow Statement templates while ensuring proper formula integrity and cross-tab linkages.

Can I use Python to link integrated financial statements?▼

Yes, you can use Python to link integrated financial statements as this Skill supports Python environments alongside Office JS to populate financial models and validate cross-tab data.

What is the best way to validate balance checks in a 3-statement model?▼

Validating balance checks in a 3-statement model is handled natively by this Skill through automated quality checks that verify cross-tab linkages, balance sheets, and cash tie-outs.

Does this financial modeling tool work with Office JS?▼

Yes, this financial modeling tool works with Office JS, allowing users to execute model completion, apply professional blue/grey formatting, and validate data directly within supported environments.

Do I need Excel or Python to run the financial reporting automation?▼

You need either Excel or Python to run the financial reporting automation, as the Skill requires one of these environments to execute scripts and populate the financial model templates.

Why are my financial model cross-tab linkages not balancing?▼

Financial model cross-tab linkages may not balance due to broken formula integrity, but this Skill prevents this by automating data validation and running balance checks during model completion.

Related Skills

Explore More Finance & Accounting Skills→
rpoole-devrpoole-dev

3-statement-model

Automate integrated financial statement completion using Excel formulas and Python scripts.

Community
Advanced
Fantasia1999Fantasia1999

financial-analyst

Calculate financial ratios, DCF valuations, budget variances, and rolling forecasts.

Community
Advanced
VoDaiLoczVoDaiLocz
24

xlsx

Create, edit, and analyze Excel files using openpyxl and pandas.

Community
Advanced
519lab519lab
2

3-statement-model

Automates construction of integrated IS, BS, CF financial models in Excel.

Official
Intermediate