skills.rest
MarbleSodas
MarbleSodasCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

3-statement-model

Build integrated three-statement Excel financial models with reconciling schedules.

Updated Apr 9, 2026
Search Tags:#openpyxl#excel#financial-modeling#working-capital#debt-schedule#three-statement-model#cash-flow-integration
One-click install
npx skills add https://github.com/MarbleSodas/Mavis --skill 3-statement-model-marblesodas
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: 3-statement-model
Source: https://github.com/MarbleSodas/Mavis/tree/main/optional-skills/finance/3-statement-model
Command: npx skills add https://github.com/MarbleSodas/Mavis --skill 3-statement-model-marblesodas

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps you build a fully integrated 3-statement financial model where the Income Statement, Balance Sheet, and Cash Flow Statement tie out correctly, including the schedules and plugs needed for working capital, D&A roll-forwards, and debt.

Core Features & Use Cases

  • Integrated 3-statement build: Populates IS/BS/CF with formula-first linkages so cash and retained earnings reconcile across periods.
  • Supporting schedules & roll-forwards: Produces working capital schedules (AR/AP/Inventory), D&A schedules, and a debt schedule that feeds interest and balances.
  • Scenario-ready integrity: Supports Base/Upside/Downside toggles while preserving spreadsheet integrity via named ranges, formulas, and validation checks.
  • Use case: You have a financial template that needs careful population without breaking cross-tab logic; you want a stepwise build that stops after each statement so errors are caught early.

Quick Start

Use the 3-statement-model skill to complete the template and populate the Income Statement first with Excel formulas that link to the Assumptions tab.

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 three-statement financial model in Excel that balances?▼

To build an integrated three-statement financial model, populate the income statement, balance sheet, and cash flow with dynamic Excel formulas that reconcile working capital, debt schedules, and retained earnings across periods.

What is the best way to link working capital schedules and debt schedules to a cash flow statement?▼

The best way to link working capital and debt schedules to a cash flow statement is using formula-first Excel strings that roll-forward AR/AP/Inventory and debt balances, ensuring ending cash matches across projection periods.

Can I generate scenario-based equity and debt models with Base, Upside, and Downside toggles in Excel?▼

Yes, you can generate scenario-based equity and debt models by using named ranges and dynamic Excel formulas to preserve spreadsheet integrity while toggling between Base, Upside, and Downside projections.

How do I prevent balance sheet errors when populating financial model templates across multiple tabs?▼

To prevent balance sheet errors, populate financial model templates stepwise by completing the income statement first, then stop after each statement to validate cross-statement checks like Assets = Liabilities + Equity.

Does this financial modeling approach write computed values or Excel formula strings into the spreadsheet?▼

This financial modeling approach writes dynamic Excel formula strings rather than computed values, ensuring that assumptions, schedules, and cross-tab linkages remain consistent throughout projection periods.

Why does my cash flow statement not tie out to the ending balance sheet cash balance?▼

Your cash flow statement fails to tie out when depreciation roll-forwards, working capital changes, or debt schedules are not dynamically linked, causing ending cash to mismatch retained earnings and balance sheet balances.

Related Skills

Explore More Finance & Accounting Skills→
anilveersingh1308anilveersingh1308

xlsx

Generate and update Excel workbooks with formula-error-free validation.

Community
Advanced
cwstedctwcwstedctw

3-statement-model

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

Community
Advanced
PlaidmustachePlaidmustache

merger-model

Automate accretion/dilution modeling and pro forma financial analysis in Excel.

Community
Advanced
Fantasia1999Fantasia1999

finance-skills

Analyze financial statements with ratio analysis, DCF valuation, and budget variance tools.

Community
Advanced