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 rapidly design, document, and validate internal control frameworks aligned with COSO 2013, SOX compliance, and audit standards. Claude helps you map business processes to control objectives, create control matrices linking risks to preventive and detective controls, generate control narratives for auditors, and identify control gaps for remediation planning—compressing what typically takes 200+ annual hours into a fraction of that time while improving control design quality.
by eryet
Analyze your organizational spending across departments and cost categories to uncover waste and inefficiencies. Identify specific, actionable cost-saving opportunities with quantified savings potential and implementation feasibility. Build professional, data-driven business cases with detailed ROI calculations, payback periods, and strategic recommendations to justify and accelerate your cost reduction initiatives.
by eryet
You can systematically process court orders, IRS levies, and child support withholdings by validating order authenticity, calculating accurate deductions accounting for state exemptions and federal limits, sequencing multiple garnishments by legal priority, and generating compliant documentation for courts and creditors. This skill handles the highest-risk payroll functions—reducing legal exposure, audit risk, and manual processing time while ensuring every deduction meets federal and state regulations.
by eryet
You receive a comprehensive framework for evaluating diversified passive income streams, assessing client risk profiles, and recommending portfolio structures that maximize income while maintaining alignment with financial objectives. The skill analyzes income sources (real estate, dividends, bonds, peer lending, digital assets), models cash flow projections, evaluates tax efficiency, and provides data-driven strategy recommendations ranked by performance potential.
by eryet
You can trace financial transactions across multiple accounts and entities, document complete chain-of-custody for audit evidence, identify fraud indicators and anomaly patterns, and construct defensible audit conclusions that satisfy both forensic rigor and legal admissibility requirements. This skill provides structured protocols for adversarial skepticism, hostile cross-examination preparation, and quantification of losses or damages with transparent methodologies.
by eryet
You can systematically validate payroll calculations against state-specific tax codes, withholding rules, and overtime thresholds across all 50 states plus DC. This skill cross-references your employee data against current regulatory requirements, identifies compliance gaps before submission, and generates documentation for audit purposes—reducing penalty exposure and audit risk for multi-state payroll operations.
by eryet
You can input invoice data, PO details, and receipt information to automatically identify variance types, trace root causes, and generate resolution recommendations. The skill creates documented audit trails for each discrepancy, enabling faster month-end close and reducing manual investigation time from hours to minutes. It handles quantity mismatches, pricing discrepancies, duplicate submissions, GL coding errors, and tax/freight charge validation.
by eryet
You'll systematically segment your delinquent portfolio using risk-based criteria including account value, days past due, payment history, customer type, and collection effort ROI. This allows you to apply differentiated collection strategies that maximize recovery dollars per hour invested, increase DSO recovery, reduce write-offs, and prevent agent burnout by eliminating pursuit of uncollectible accounts.
by eryet