Paweł Dudek, BalancewrightEvery model ships with its own integrity checks and an independent re-derivation of every output. Follow
- views 966
- downloads 0
- reviews 0
- Downloadable Best Practices 18
Paweł Dudek, Balancewright
Every model ships with its own integrity checks and an independent re-derivation of every output.
Discuss with Paweł Dudek, Balancewright!
Follow
Cap Table, SAFE & Convertible Note Dilution Waterfall (Excel)
Converts SAFEs and notes into a priced round and solves the price-per-share circularity in visible columns, never by enabling iterative calculation.69Discussadd_shopping_cart$49.00Startup Runway & Burn Planner: Cash-Out Date & Burn Multiple (Excel)
Tells you the month the money runs out, and what each hire and each spending cut does to that date. Payroll built from a 30-row headcount plan.27Discussadd_shopping_cart$29.00ESOP & Stock Option Pool Model: Vesting, IFRS 2 Expense & Exit Value (Excel)
Option grants into a vesting schedule with cliffs and leavers, the IFRS 2 / ASC 718 expense, pool genuinely left, and exit value per holder.37Discussadd_shopping_cart$29.00VC & PE Fund Distribution Waterfall: Carried Interest, Catch-Up & Clawback (Excel)
Whole-of-fund European waterfall tier by tier: exact GP catch-up, the deal-by-deal American comparison, and the clawback the GP owes back.131Discussadd_shopping_cart$59.0013-Week Direct Cash Flow Forecast with Working Capital Bridge & Revolver (Excel)
The 13-week forecast lenders ask for first: receipts from your receivables book, a revolver defending minimum cash, and a working capital bridge.90Discussadd_shopping_cart$29.00Feasibility Study Financial Model with Debt Sizing, DSCR, NPV and IRR (Excel)
Is the project worth doing, and can it be financed? Sizes funding including construction interest in 12 visible columns, then tests DSCR.91Discussadd_shopping_cart$59.00Budget vs Actual Variance Analysis with Price, Volume, Mix & Rolling Forecast (Excel)
Splits the gap between budget and actual into price, volume and mix, flexes the budget to actual volume, and rolls the rest of the year forward.75Discussadd_shopping_cart$29.00Solar PV & Battery (BESS) Project Finance Model with DSCR-Sculpted Debt (Excel)
Solar and battery project finance without a circular reference: construction interest and DSCR-sculpted debt both solved in closed form, in visible columns.56Discussadd_shopping_cart$69.00Subscription Cohort, Churn & Retention Analyzer with NRR, GRR and LTV/CAC (Excel)
One row per customer per month becomes cohort triangles, NRR and GRR, an MRR movement bridge that ties, and LTV:CAC split by segment and channel.36Discussadd_shopping_cart$79.00SaaS ARR Bridge & Net Revenue Retention Model with Quick Ratio and Rule of 40 (Excel)
An ARR walk that reconciles on every month and every quarter, retention measured three independent ways, and the efficiency metrics investors ask for.39Discussadd_shopping_cart$69.00Data Centre Project Finance & Colocation Model with Power-Constrained Capacity (Excel)
Grid connection divided by design PUE sets the sellable IT load, and debt is sized on DSCR capacity against an LTV cap rather than typed in.38Discussadd_shopping_cart$79.00Mining Project Finance Model with Reserve Tail Ratio and DSCR Debt Sizing (Excel)
Open-pit mine project finance: the reserve caps production, the reserve tail covenant caps the tenor, and DSCR capacity against a gearing cap sizes the debt.53Discussadd_shopping_cart$79.00Availability Payment PPP (DBFM) Project Finance Model with Deduction Headroom (Excel)
Availability-based PPP: the unitary charge is contractual, so the risk is deductions - and this model computes the headroom before the covenant breaks.33Discussadd_shopping_cart$79.00Integrated Three-Statement Operating Model - 10 Years, Revolver, Covenant Headroom, Cross-Checked Valuation
Ten-year three-statement model: revolver and cash sweep with zero circular references, covenant headroom in dollars, a DCF that cross-checks itself.34Discussadd_shopping_cart$79.00Multifamily Value-Add Apartment Acquisition Model with LTV/DSCR Loan Sizing and Promote Waterfall (Excel)
Underwrite an apartment value-add deal: the loan sized by all three lender tests, renovation unit by unit, and a four-tier promote waterfall.28Discussadd_shopping_cart$79.00Financial Model Audit Checklist and Scorecard - 61 Tests, Severity Weighting, Grade and Findings Log (Excel)
A checklist you run against a financial model: 61 tests in 8 categories, weighted by severity, with a scorecard, a grade and a findings log.39Discussadd_shopping_cart$29.00
