Search
Search your workspace content.
Scenarios
Acquisition Pro Forma
Year 1EBITDA 67,160Cash Flow 20,279Total ROI 37.2%
Price
Down
%
Closing
Rate
%
Term
yr
Loan$322KCash In$150.5KPayment3,907/mo
| Expand | Line item | Basis | Monthly | Actions | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Growth Rates | |||||||||||||||
Revenue Growth | Yearly | 4.0% | 0.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | |||
Expense Growth | Yearly | 3.0% | 0.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | |||
Appreciation Rate | Yearly | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | |||
RevenuesNet Revenue | 15,582 | 186,984 | 194,463 | 202,242 | 210,332 | 218,745 | 227,495 | 236,594 | 246,058 | 255,901 | 266,137 | ||||
Subscriptions | 14,800 | 177,600 | 184,704 | 192,092 | 199,776 | 207,767 | 216,078 | 224,721 | 233,709 | 243,058 | 252,780 | ||||
Churn | % Gross Subs | 6.0% | (10,656) | (11,082) | (11,526) | (11,987) | (12,466) | (12,965) | (13,483) | (14,023) | (14,583) | (15,167) | |||
Net Subscriptions | 13,912 | 166,944 | 173,622 | 180,567 | 187,789 | 195,301 | 203,113 | 211,237 | 219,687 | 228,474 | 237,613 | ||||
Advisory Retainer | 1,250 | 15,000 | 15,600 | 16,224 | 16,873 | 17,548 | 18,250 | 18,980 | 19,739 | 20,529 | 21,350 | ||||
Onboarding Pack | 420 | 5,040 | 5,242 | 5,451 | 5,669 | 5,896 | 6,132 | 6,377 | 6,632 | 6,898 | 7,173 | ||||
ExpensesTotal Expenses | 9,985 | 119,824 | 123,602 | 127,501 | 131,525 | 135,677 | 139,962 | 144,385 | 148,949 | 153,659 | 158,520 | ||||
Customer Support | 52,800/yr | 52,800 | 54,384 | 56,016 | 57,696 | 59,427 | 61,210 | 63,046 | 64,937 | 66,885 | 68,892 | ||||
Software & Tools | 6,900/yr | 6,900 | 7,107 | 7,320 | 7,540 | 7,766 | 7,999 | 8,239 | 8,486 | 8,741 | 9,003 | ||||
Cloud Hosting | 11.0% | 18,364 | 19,098 | 19,862 | 20,657 | 21,483 | 22,342 | 23,236 | 24,166 | 25,132 | 26,137 | ||||
Account Mgmt | 31,200/yr | 31,200 | 32,136 | 33,100 | 34,093 | 35,116 | 36,169 | 37,254 | 38,372 | 39,523 | 40,709 | ||||
Payment Fees | 480 | 5,760 | 5,933 | 6,111 | 6,294 | 6,483 | 6,677 | 6,878 | 7,084 | 7,297 | 7,515 | ||||
Reserves | 4,800/yr | 4,800 | 4,944 | 5,092 | 5,245 | 5,402 | 5,565 | 5,731 | 5,903 | 6,080 | 6,263 | ||||
EBITDA | 5,597 | 67,160 | 70,861 | 74,741 | 78,807 | 83,068 | 87,532 | 92,210 | 97,110 | 102,242 | 107,617 | ||||
Cash FlowNet Cash Flow | 1,690 | 20,279 | 23,980 | 27,860 | 31,926 | 36,187 | 40,651 | 45,329 | 50,229 | 55,361 | 60,736 | ||||
Cash Available | 5,597 | 67,160 | 70,861 | 74,741 | 78,807 | 83,068 | 87,532 | 92,210 | 97,110 | 102,242 | 107,617 | ||||
Debt Service | (3,907) | (46,881) | (46,881) | (46,881) | (46,881) | (46,881) | (46,881) | (46,881) | (46,881) | (46,881) | (46,881) | ||||
Cash ROI | On Cash In | 13.5% | 15.9% | 18.5% | 21.2% | 24.0% | 27.0% | 30.1% | 33.4% | 36.8% | 40.4% | ||||
ReturnsTotal Return | 55,992 | 61,926 | 68,201 | 74,840 | 81,863 | 89,296 | 97,163 | 105,492 | 114,311 | 123,653 | |||||
Net Cash Flow | 20,279 | 23,980 | 27,860 | 31,926 | 36,187 | 40,651 | 45,329 | 50,229 | 55,361 | 60,736 | |||||
Equity Accrued | 21,913 | 23,732 | 25,701 | 27,835 | 30,145 | 32,647 | 35,356 | 38,291 | 41,469 | 44,911 | |||||
Appreciation | 13,800 | 14,214 | 14,640 | 15,080 | 15,532 | 15,998 | 16,478 | 16,972 | 17,481 | 18,006 | |||||
| Total ROIOn cash in | 37.2% | 41.1% | 45.3% | 49.7% | 54.4% | 59.3% | 64.6% | 70.1% | 76.0% | 82.2% | |||||
Blue figures are inputs. Click one to edit, or paste a range.Year 1 is FY 2027. Click a year to focus it.