skills.rest
open-neko
open-nekoOFFICIAL
Explore all skills by this author →
GitHub

3-statement-model

Automate creation of integrated 3-statement financial models with Excel formulas.

11|Updated May 6, 2026
Search Tags:#financial modeling#openpyxl#excel#financial analysis#valuation#3-statement model#credit metrics
One-click install
npx skills add https://github.com/open-neko/openneko --skill 3-statement-model-open-neko
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: 3-statement-model
Source: https://github.com/open-neko/openneko/tree/main/packages/llm/assets/builtin-skills/3-statement-model
Command: npx skills add https://github.com/open-neko/openneko --skill 3-statement-model-open-neko

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill eliminates the tedious, error-prone work of manually building and linking income statements, balance sheets, and cash flow statements, ensuring all financial statements tie out correctly with proper Excel formulas instead of hardcoded values.

Core Features & Use Cases

  • Integrated 3-Statement Modeling: Builds fully linked income statement, balance sheet, and cash flow statement models with working capital schedules, depreciation and amortization roll-forwards, debt schedules, and proper cash/retained earnings plugs.
  • Validation and Audit Checks: Includes comprehensive cross-statement integrity checks, scenario analysis (base/upside/downside), margin analysis, and credit metric calculations to ensure model accuracy.
  • Use Case: Financial analysts can use this skill to quickly build auditable 3-statement models for company valuations, budgeting, or financial planning, avoiding manual formula errors that break model integrity.

Quick Start

Use the 3-statement-model skill to build a fully integrated 3-statement financial model for your company using the provided historical financial data and key assumption drivers.

Frequently Asked Questions about 3-statement-model

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

FAQPage Schema
How do I build a fully integrated 3-statement financial model in Excel with proper linkages?▼

To build a fully integrated 3-statement model, link the income statement, balance sheet, and cash flow statement using Excel formulas instead of hardcoded values, ensuring proper cash and retained earnings plugs for cross-statement integrity.

Can I automate financial modeling and cross-statement integrity checks using openpyxl?▼

Yes, you can automate 3-statement financial modeling with openpyxl to generate working capital schedules, debt schedules, and cross-statement integrity checks to validate model accuracy without manual formula errors.

What is the best way to add scenario analysis and credit metrics to a 3-statement model?▼

The best way to add scenario analysis and credit metrics is to integrate base, upside, and downside scenarios directly into the 3-statement model, calculating margins and credit metrics alongside depreciation and debt roll-forwards.

How do I create depreciation roll-forwards and working capital schedules for company valuations?▼

Create depreciation roll-forwards and working capital schedules by linking historical financial data and key assumption drivers into the 3-statement model, ensuring accurate cash flow projections for company valuations.

Does this 3-statement modeling approach support both public and private company financial planning?▼

Yes, this 3-statement modeling approach supports both public and private entities for financial planning, budgeting, and credit assessment by applying standardized Excel-based formulas and comprehensive audit validation.

Why do my manually linked income statement and balance sheet models break when updating assumptions?▼

Manual 3-statement models break because of hardcoded values and formula errors; using automated generation with proper cross-statement linkages and integrity checks prevents these update failures.

Related Skills

Explore More Finance & Accounting Skills→
dgkngkdgkngk

3-statements

Populates financial statement templates and validates cross-statement consistency for accurate reporting.

Community
Advanced
r9412460971-cloudr9412460971-cloud
31

3-statement-model

Populate pre-built 3-statement financial model templates with cross-statement linkages.

Community
Advanced
mahyarmalekiimahyarmalekii

3-statement-model

Complete financial model templates for Income Statement, Balance Sheet, and Cash Flow Statement.

Community
Advanced
davpatel605-beepdavpatel605-beep

3-statement-model

Build integrated three-statement financial models with linked Excel formulas and validation checks.

Community
Advanced