3-statement-model

Link income statement, balance sheet, and cash flow with Excel formulas.

Updated May 27, 2026

Search Tags:#financial modeling #model validation #scenario analysis #excel formulas #cash tie-out #three statements

Ready to run

npx skills add https://github.com/cwstedctw/financial-services-tw --skill 3-statement-model-cwstedctw

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: 3-statement-model
Source: https://github.com/cwstedctw/financial-services-tw/tree/main/taiwan-finance/skills/3-statement-model
Command: npx skills add https://github.com/cwstedctw/financial-services-tw --skill 3-statement-model-cwstedctw

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

幫你在三張財務報表之間建立正確連動（綜合損益表、資產負債表、現金流量表），並用公式與校驗確保模型可追溯、可調整、且不會因手填或硬算而破壞完整性。

Core Features & Use Cases

三表模板填寫與串接整合：把財報歷史數據與預測假設填入，並維持各報表間的邏輯連結。
公式優先與避免硬算：所有預測、滾動、連動計算以 Excel 公式產生，不用 Python 計算結果硬塞回格子。
分階段建模流程與驗證：先規劃模板結構與分頁，再分別完成 IS、BS、CF，並依檢查點確認平衡與勾稽。
關鍵檢查與內部一致性：包含 BS 平衡（Assets = Liabilities + Equity）、CF 現金勾稽（Ending Cash 對齊 BS Cash）、損益與現金流的連結（Net Income 鏈結）。

Quick Start

請你先檢查你手上三表模板的分頁與輸入/公式區塊，然後把歷史期（實際值）填入並先確認綜合損益表的計算與小計無誤，再告訴我下一步要接著建立資產負債表。

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

A three-statement model links the income statement, balance sheet, and cash flow statement using Excel formulas. It populates historicals and projections while enforcing balance checks and cash tie-outs to ensure all three financial statements remain fully integrated and dynamically updated.

Why does my balance sheet not balance when linking three financial statements?▼

An unbalanced balance sheet occurs when formula integrity constraints between statements are broken. Enforcing balance checks ensures Assets equal Liabilities plus Equity by validating cross-statement tie-outs and avoiding hardcoded numbers that disrupt the three-statement model linkage.

What is the best way to tie out cash flow ending balance to balance sheet cash?▼

The best way to tie out cash flow ending balance to balance sheet cash is through strict cash tie-out validation. By linking net income from the income statement and rolling forward cash flows via Excel formulas, you ensure the cash flow statement's ending cash exactly matches the balance sheet cash line item.

Can I use Excel formulas for scenario analysis in a three-statement model?▼

Yes, you can implement scenario analysis in a three-statement model using Excel formulas. The workflow supports scenario toggles that dynamically adjust historicals and projections across all three linked financial statements while maintaining internal consistency and formula integrity.

How do I avoid hardcoding numbers when completing an integrated financial model?▼

You avoid hardcoding numbers by generating all projections, rolling calculations, and cross-statement linkages through Excel formulas. This formula-first approach ensures the integrated three-statement financial model remains traceable, adjustable, and structurally sound without manually overriding calculation logic.

What steps are required to validate model integrity in three-statement financial modeling?▼

Validating model integrity in three-statement financial modeling requires checking that Assets equal Liabilities plus Equity on the balance sheet, and performing cash tie-outs to ensure ending cash aligns with balance sheet cash. It also involves verifying that net income correctly links the income statement to cash flows.