The spreadsheet below aims to solve for the lowest possible equity outlay in a buyout based on a few high level parameters.