At the top: gross revenue, cost of goods, and net profit for recurring revenue, with placeholders for the down payment, the term in months, and the share of monthly gross that goes to the seller. Duplicate the line for project revenue, and add lines for any other service you want to price at its own rate.
Below that, it reads like a mortgage amortization schedule. Months run down the left, with projected gross, cost of goods, profit, and earnout payment across, plus a column for the actual payment as you make it. Apply monthly profit against the down payment to see when you’re paid back.
Copy the sheet to new tabs and change the term to build scenarios at 12, 18, and 24 months. Then offer the seller a few options you can live with.
Download the sample worksheet (Excel) ↓