Our build-vs-buy guide gives one formula for deciding whether to replace a subscription with your own automation: break-even months = B / (S β R β M). B is the one-time build cost, S the subscription per month, R what the build costs to run, M monthly maintenance. In a sheet it is one cell: =B2/(B1-B3-B4) .
Run it with a small tool's numbers: 10 seats at $12, a $12,000 build quote, and maintenance at the guide's fallback of 15% of the build a year. The cell comes out at -400 . Put the obvious check next to it, =IF(B5<=36,"BUILD","BUY") , and it says BUILD . Upkeep alone was $150 a month against a $120 subscription, so the build never pays back, and the sheet recommended it anyway.
The guide also says to project the subscription forward with renewal price rises and headcount, because that "often halves the break-even". I built that projection too.β¦