← Back to work
ModelCraft
A structured financial modeling environment — business reality in, financial statements out, with built-in ratio analysis and workbook export.
Financial ModelingThree-StatementRatio AnalysisExcel Export
Impact Highlights
3-statement
Model engine
Ratio analysis
Built-in
Workbook export
Skeleton output
LBO / IPO ready
Extensions
Before vs After
Before
- • Modeling starts from blank Excel sheets with no enforced structure
- • Assumptions scattered across tabs with inconsistent conventions
- • Ratio analysis done ad hoc — different analysts, different metrics
- • No clean handoff between model builder and reviewer
After
- • Guided assumption entry with structured revenue, cost, and capital inputs
- • Income statement, balance sheet, and cash flow statement generated in lockstep
- • Ratio dashboard covering profitability, leverage, liquidity, and efficiency
- • Workbook skeleton export for offline review and extension
- • Gotcha flags for common modeling errors and circular logic
Key Decisions
1
Started from business drivers — not line items — so the model reflects operating reality
2
Built ratio analysis into the core loop rather than bolting it on after the fact
3
Designed the export as a skeleton, not a finished product — reviewers should extend, not just read
What I'd do next (given more time)
- →Add bridge analysis for period-over-period variance decomposition
- →Build LBO module with debt schedule, PIK, and IRR waterfall
- →Support IPO scenario modeling with dilution and offer price sensitivity
- →Include scenario manager for base / bull / bear toggling