Fundamentals & Valuation

three-statement-model-builder

The Three-Statement Model Builder generates driver-based, fully integrated financial models linking the income statement, balance sheet, and cash flow statement for multi-year projections.

45 天前更新1 分鐘內設定完

總覽

The Three-Statement Model Builder generates driver-based, fully integrated financial models linking the income statement, balance sheet, and cash flow statement for multi-year projections.

The Three-Statement Model Builder generates driver-based, fully integrated financial models linking the income statement, balance sheet, and cash flow statement for multi-year projections. It ingests historical financials (3–5 years) and business assumptions to produce revenue and cost driver forecasts, working capital schedules (DSO, DPO, inventory), capex and depreciation roll-forwards, debt and interest schedules, and reconciled cash balances. Key features include automated free cash flow and EPS calculations, circular-reference resolution (debt/interest iteration, cash sweep, revolver mechanics), convergence verification, and scenario/sensitivity analysis for base, upside, and downside cases. Typical use cases are FP&A forecasting, valuation, M&A diligence, LBO/transaction modeling, and board reporting. Core advantages are driver transparency, rapid scenario development, robust auditability, and reliable balance-sheet balancing under complex financing interactions.

Skill.md

這個 Skill 如何運作

The Three-Statement Model Builder generates driver-based, fully integrated financial models linking the income statement, balance sheet, and cash flow statement for multi-year projections.

SKILL.mdALPHIO / 已驗證

Three-Statement Model Builder

Overview

The Three-Statement Model Builder skill creates fully integrated financial models that dynamically link the income statement, balance sheet, and cash flow statement. It handles complex circular references between debt, interest expense, and cash balances while maintaining model integrity.

Capabilities

Income Statement Projection

Revenue drivers and growth modeling
Cost structure analysis (fixed vs. variable)
Gross margin forecasting
Operating expense projections
Interest expense calculation
Tax expense computation
EPS and diluted EPS calculation

Balance Sheet Forecasting

Working capital modeling (AR, AP, inventory)
Fixed asset roll-forward
Debt schedule construction
Equity account tracking
Deferred tax assets/liabilities
Goodwill and intangibles

Cash Flow Statement Derivation

Operating cash flow from net income
Working capital changes
Investing activities (capex, acquisitions)
Financing activities (debt, dividends, buybacks)
Beginning and ending cash reconciliation
Free cash flow calculation

Circular Reference Resolution

Debt/interest iterative calculation
Cash sweep mechanisms
Revolver draws and paydowns
Interest income on excess cash
Convergence verification

Working Capital Modeling

Days sales outstanding (DSO) analysis
Days payable outstanding (DPO) modeling
Inventory turnover projections
Prepaid and accrued expense forecasting
Seasonal adjustment factors

Capital Expenditure and Depreciation

Capex as percentage of revenue
Asset category breakdowns
Depreciation method selection
Useful life assumptions
Asset retirement modeling

Usage

Model Construction

Input: Historical financials (3-5 years), business assumptions
Process: Build integrated statements with driver-based forecasts
Output: Multi-year projections with automatic balance sheet balancing

Scenario Development

Input: Base case assumptions, scenario parameters
Process: Create linked scenarios with consistent assumptions
Output: Comparable financial projections across scenarios

Integration

Used By Processes

Financial Statement Preparation
Financial Modeling and Scenario Planning
Annual Budget Development

Tools and Libraries

Python pandas
openpyxl
Financial modeling templates
xlwings for Excel automation

Best Practices

Establish clear historical period and projection period boundaries
Use driver-based assumptions rather than hard-coded values
Implement error checks and balance verification
Maintain assumption documentation separate from calculations
Build in flexibility for scenario switching
Use consistent sign conventions throughout

最適合用於

何時使用

The Three-Statement Model Builder generates driver-based, fully integrated financial models linking the income statement, balance sheet, and cash flow statement for multi-year projections.