Triangulating value creation in a buyout (leveraged buyout)

Use the following spreadsheet below to understand where the sources of values are during an exit.

Note: The above represents illustrative numbers and not for use in a pure commercial setting.

Data sources: Capex and working capital datasets from http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datacurrent.html