skills.rest
jason660519
jason660519COMMUNITY
Explore all skills by this author →
GitHub

3-statement-model

Populate and validate end-to-end 3-statement financial models from input data.

Updated May 11, 2026
Search Tags:#openpyxl#excel#financial-modeling#scenario-analysis#three-statement#debt-schedule
One-click install
npx skills add https://github.com/jason660519/Project-Manager --skill 3-statement-model-jason660519
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: 3-statement-model
Source: https://github.com/jason660519/Project-Manager/tree/main/hermes-agent/optional-skills/finance/3-statement-model
Command: npx skills add https://github.com/jason660519/Project-Manager --skill 3-statement-model-jason660519

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Building end-to-end 3-statement financial models (IS, BS, CF) in Excel with accurate linkages, scenario analysis, and governance so finance teams can forecast and stress-test plans without breaking formulas.

Core Features & Use Cases

  • Automated construction of integrated IS/BS/CF templates with formula-driven linkages (Net Revenue, COGS, D&A, NOL, working capital, debt, and equity).
  • Scenario analysis support with toggles for Base/Upside/Downside cases to test financial health under varying assumptions.
  • Validation and reconciliation checks to ensure Balance Sheet equality, cash tie-outs, and reconciled NI to CFO.

Quick Start

Provide a ready-to-run 3-statement template populated with your historicals and assumptions using the excel-author flow.

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 building a 3-statement financial model in Excel?▼

Automate 3-statement financial modeling by using openpyxl to populate integrated IS, BS, and CF templates with formula-driven linkages directly from your input data.

Can I run scenario analysis on a three-statement model with openpyxl?▼

Scenario analysis is supported through toggles for Base, Upside, and Downside cases, allowing you to stress-test financial health and forecasts under varying assumptions.

How do you ensure a balance sheet balances when generating a financial model?▼

Validation and reconciliation checks enforce Balance Sheet equality, cash tie-outs, and reconciled Net Income to CFO, ensuring assets equal liabilities plus equity.

Does this financial modeling approach support debt schedules and NOL tracking?▼

The modeling approach populates debt schedules, D&A, working capital, and features a specific DTA/NOL schedule to handle deferred tax assets and net operating losses.

What do I need to start generating an integrated three-statement model?▼

You need to provide historical financial data and assumptions to populate a ready-to-run 3-statement template using the excel-author flow.

What is the best way to validate cash tie-outs in an automated financial model?▼

Cross-check validations automatically verify cash tie-outs and balance sheet equality within the generated model to ensure end-to-end financial accuracy.

Related Skills

Explore More Finance & Accounting Skills→
robertbr123robertbr123

3-statement-model

Automate construction of integrated 3-statement financial models in Excel using openpyxl.

Community
Advanced
KaakatiKaakati
3

financial-modeling

Construct DCF, LBO, comparable companies, and three-statement financial models.

Community
Advanced
anilcan-karaanilcan-kara

3-statement-model

Create integrated Excel 3-statement financial models with linked IS, BS, and CF.

Community
Advanced
bomberoxenviosdosruedasbomberoxenviosdosruedas

agency-financial-analyst

Build financial models and forecasts for strategic decision-making.

Community
Advanced