How this worksheet works
Closing cash = headline consideration − seller note − maximum earnout − rollover − debt − fees − holdback + other adjustment. Available cash then subtracts the tax reserve you enter.
Use the result in context
This is a simplified seller cash bridge. It does not calculate taxable gain, value private equity, predict earnout payment or determine working-capital treatment. Negative cash means the entered scenario requires additional funding or revised assumptions. Avoid counting a debt or adjustment twice.
Changing an input clears the previous result so you do not mistake an old calculation for the current scenario. Load the illustrative example to explore the method, then replace it with your own figures. Download before leaving if you want to keep your worksheet.
Read the supporting guide →