skills.rest
AlexZWANG1
AlexZWANG1COMMUNITY
Explore all skills by this author →
GitHub

3-statement-model

Automate building and linking integrated Income Statement, Balance Sheet, and Cash Flow models.

Updated Mar 17, 2026
Search Tags:#financial-modeling#cash-flow#scenario-analysis#income-statement#balance-sheet#template-audit#3-statement
One-click install
npx skills add https://github.com/AlexZWANG1/Prism --skill 3-statement-model-alexzwang1
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: 3-statement-model
Source: https://github.com/AlexZWANG1/Prism/tree/main/financial-services-plugins/financial-analysis/skills/3-statement-model
Command: npx skills add https://github.com/AlexZWANG1/Prism --skill 3-statement-model-alexzwang1

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill enables finance teams to build and validate fully integrated IS/BS/CF models by preserving live linkages, reducing errors, and speeding up scenario-based analyses.

Core Features & Use Cases

  • Automated template completion and linkage for Income Statement, Balance Sheet, and Cash Flow components
  • Scenario analysis and auditing capabilities with formula-driven projections and assumption tracking
  • Use Case: a finance analyst refreshes a 3-statement model with updated revenue drivers and tests multiple scenarios without breaking formulas

Quick Start

Input your historical data and assumptions, then run the model template to generate projected IS/BS/CF outputs.

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 an integrated 3-statement financial model without breaking formulas?▼

To build an integrated 3-statement financial model without breaking formulas, you input historical data and assumptions into an automated template that preserves live linkages across the Income Statement, Balance Sheet, and Cash Flow Statement.

What's the best way to automate scenario analysis for an integrated income statement and balance sheet?▼

Automating scenario analysis for an integrated income statement and balance sheet requires formula-driven projections that maintain data integrity, allowing you to test multiple revenue driver scenarios without manual recalculation errors.

How does a 3-statement model audit check data integrity and assumption tracking?▼

A 3-statement model audit checks data integrity by validating formula-driven projections across linked statements, ensuring that documented assumptions match outputs and identifying broken linkages between the Income Statement, Balance Sheet, and Cash Flow.

Do I need historical data to generate projected IS/BS/CF outputs for a template completion?▼

Yes, you need historical data and updated revenue drivers to generate projected IS/BS/CF outputs, serving as the foundational inputs for the formula-driven projections and assumption tracking within the template completion process.

Can I refresh a 3-statement model with updated revenue drivers using automated template completion?▼

You can refresh a 3-statement model with updated revenue drivers using automated template completion, which dynamically updates projected IS/BS/CF outputs while preserving the live linkages and data integrity of the integrated financial model.

Related Skills

Explore More Finance & Accounting Skills→
claude-office-skillsclaude-office-skills
368

financial-modeling

Build integrated 3-statement financial models with projections for income statement, balance sheet, and cash flow.

Official
Advanced
AngelP17AngelP17
1

analyzing-financial-statements

Calculate financial ratios from CSV, JSON, text, or Excel data.

Community
Intermediate
icyzhicyzh
1

3-statement-model

Construct integrated three-statement financial models with formula-driven linkages using openpyxl.

Community
Advanced
davpatel605-beepdavpatel605-beep

3-statement-model

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

Community
Advanced