Financial Model
Build 3-5 year financial models with integrated P&L, balance sheet, and cash flow statements
What You Can Do
You can generate complete financial models that integrate P&L statements, balance sheets, and cash flow forecasts from a business plan or strategic initiative. The skill systematizes revenue drivers, cost structures, and cash dynamics into models with transparent, stress-testable assumptions. You'll receive base case, downside, and upside scenarios with working capital dynamics and debt schedules ready for board presentations or investor analysis.
Features
automatically links P&L, balance sheet, and cash flow statements with formula consistency checks
breaks down revenue projections by customer segment, product line, or geography with documented assumptions
builds COGS and operating expense models with sensitivity variables for margin analysis
generates rolling 12-month and annual cash flow projections with working capital and debt schedule tracking
creates base case, downside, and upside scenarios with variance documentation for stress testing
maintains source documentation and audit trails for all financial inputs and calculations
tests model outputs against key variable changes (pricing, volume, discount rates) for risk assessment
Example Output
Example 1: SaaS Revenue Model
- Monthly recurring revenue grows from $500K (Year 1) to $2.8M (Year 5) with 8% monthly churn
- P&L shows EBITDA margin expanding from -45% to +28% as CAC payback improves
- Cash flow breakeven in Month 18; sensitivity shows profitability swings $400K based on ±10% pricing
Example 2: Acquisition Target Analysis
- Integrated model shows 30% IRR over 5-year hold period under base case assumptions
- Sensitivity matrix reveals downside scenario (15% pricing pressure) yields 18% IRR
- Balance sheet shows debt paydown from $25M to $8M; covenant compliance confirmed across all scenarios
Example 3: Capital Expenditure Justification
- $5M equipment investment increases production capacity 40%; FCF improves $2.1M annually
- NPV analysis at 10% discount rate shows $8.3M present value of incremental cash flows
What's Included
- SKILL.md instruction file with financial modeling principles and workflow:
- Three-statement model template (Excel/Google Sheets) with pre-built formulas and links:
- Assumption documentation workbook with driver definitions and audit trail tracking:
- Scenario framework with base/downside/upside case setup and variance analysis:
- Sensitivity matrix template for testing key variables and stress scenarios:
Who It's For
- CFOs and controllers building budgets, forecasts, and capital allocation models
- Investment bankers and private equity analysts evaluating acquisition targets and DCF valuations
- Corporate development teams quantifying strategic initiatives and business case ROI
- Credit officers and lenders assessing borrower repayment capacity and covenant compliance
- Equity research analysts modeling public company performance and intrinsic value
Best For
- 3-5 year financial projections from business plans or strategic initiatives
- Valuation and DCF analysis for M&A, lending, or investment decisions
- Scenario and sensitivity testing to stress-test financial assumptions
- Working capital and cash flow forecasting for operational and liquidity planning
- Assumption documentation and audit trails for board presentations and regulatory compliance
You might also like
You can systematically validate employee payroll records, cross-check tax withholding calculations against current tax brackets, verify regulatory compliance across federal/state/local requirements, and flag anomalies that could trigger penalties—all before executing payment runs. This reduces processing time by 40-60% while catching errors that manual spreadsheet reviews typically miss, working across ADP, Workday, Gusto, and manual payroll systems.
by eryet
You can analyze transaction clusters to identify layering, placement, and integration schemes using proven AML methodologies. Claude applies typology frameworks to suspicious fund flows, cross-border movements, and beneficiary ownership chains—transforming raw transaction flags into regulatory-grade narratives that justify SAR escalation and withstand compliance audits.
by eryet
You systematically extract financial red flags from claim submissions, construct causal narratives linking evidence to fraud conclusions, and quantify potential loss exposure. This skill helps you distinguish between legitimate claim variations and fraud indicators, enabling you to generate investigation summaries defensible in litigation, settlement negotiations, or Special Investigation Unit (SIU) presentations.
by eryet
You'll construct defensible, driver-based revenue forecasts that link operational metrics (customer count, contract value, churn, win rates) directly to revenue outcomes. Claude helps you build base, upside, and downside scenarios with transparent assumptions, perform sensitivity analysis to quantify business variable impacts, and automatically document variance explanations—enabling you to respond confidently to CFO and board-level scrutiny.
by fastclaw-ai
This skill helps you audit nexus comprehensively by analyzing physical presence rules, economic thresholds, affiliate connections, and marketplace facilitator statutes across all 50 states and relevant localities. You'll document nexus triggers specific to your client's business model—whether they're selling through marketplaces, using drop-shipping, hiring remote employees, or expanding operations. The result is an actionable filing calendar and remediation strategy that minimizes compliance gaps and protects against substantial back-tax assessments, penalties, and interest.
by eryet
You can allocate indirect costs (administration, utilities, depreciation, maintenance) across clinical and non-clinical departments using activity-based costing (ABC) and traditional allocation methodologies. This skill helps you calculate precise allocation rates, model reimbursement scenarios, validate cost driver selections, and document allocation methods for compliance—enabling data-driven decisions on service line profitability, pricing strategies, and payer contract negotiations.
by eryet
You can execute structured compliance audits that map regulatory requirements to operational controls, test control effectiveness with documented evidence, quantify compliance risk exposure, and track remediation progress with clear accountability. The framework produces audit findings in regulatory-acceptable format, transforming ad-hoc reviews into defensible procedures that satisfy internal audit standards (IIA) and regulatory expectations.
by eryet
You can systematically prepare tax provisions that survive audit scrutiny by calculating current and deferred tax impacts, reconciling effective tax rates from statutory to reported amounts, and documenting uncertain tax positions with FIN 48 support. The skill guides you through multi-jurisdictional tax exposure analysis and helps you create audit-ready workpapers with clear audit trails for quarterly (10-Q) and annual (10-K) financial statement filings.
by eryet