SaaS Private Equity Acquisition Model v1.0
SaaS Private Equity Acquisition Model v1.0
A fully integrated, 84-month SaaS Private Equity Acquisition Model built for scenario analysis, translating operational drivers directly into linked financials to bypass the need for arbitrary top-down revenue assumptions.
⚙️ Core Forecast Engines
Customer Churn & Revenue: Calculates recurring revenue dynamically using starting customers, ARPU, compounding growth, and explicit monthly churn attrition.
Role-Based Payroll: Forecast exact workforce expansion via specific roles, start months, baseline salaries, annual increments, and hiring frequencies.
Growth Scenario Controls: Automate long-term assumptions via a built-in growth regressor, or use "Manual Mode" for granular year-by-year overrides.
📊 Financial & Return Framework
Integrated Financials: Fully forecasted Monthly and Annual Income & Cash Flow Statements, paired with a Pre- and Post-Acquisition Balance Sheet snapshot, validated by automated variance checks.
Advanced Control Panel: Customize expense timing and allocation for advanced scenario modeling.
Institutional LP/GP Waterfall: A mathematically sealed European waterfall featuring dynamic PIK shortfall accruals, a preferred LP hurdle, and a Month 84 "Terminal Sweep" that executes exact capital extinguishment.
Validation & Integrity: A dedicated checks dashboard verifies financial, operational, and investment calculations, ensuring your model remains balanced and error-free.
💡 Model Boundaries & Limitations
Designed for transparency, Version 1.0 includes the following structural boundaries:
Fixed Horizon: The model runs on a locked 84-month timeline with the terminal exit executed in Month 84.
Capital Structure: Built for a standard LP/GP equity structure and a single senior debt facility (excludes mezzanine debt, multiple tranches, or multi-tiered catch-ups).
Simplified Accounting: Assumes a flat corporate tax rate and straight-line depreciation, excluding dynamic working capital roll-forwards or deferred tax schedules.
📦 Deliverables
1x Master File: Fully unlocked, dynamically linked Excel workbook.
1x User Guide: Comprehensive 43-page PDF detailing the mechanics of every schedule.
1x Case Study: A 2-page practical scenario explaining the pre-populated data.
The fully unlocked master file and accompanying documentation are available for purchase below.
⚖️ Legal Disclaimer: This model and its accompanying documentation are provided for educational, analytical, and internal research purposes only. It is licensed, not sold. Nothing contained within this workbook constitutes investment, financial, legal, or tax advice. Forecasts and valuations are estimates based on user inputs. Users assume full responsibility for all assumptions, interpretations, and business decisions made using this tool.