Update 1/6/2024: This post seems to be getting attention lately. A huge thank you to everyone who's engaged with the model; your insights and feedback have been incredibly valuable. I've noticed a couple of hiccups with some formulas on the public file and corrected them (probably from the enthusiastic tinkering—by over 150 folks!). I've made some tweaks to the latest version, focusing on helping with understanding of different deal scenarios. Feel free to drop me a message on LinkedIn and I'll share the most up-to-date copy with you. Here's to more collaborative learning!

Hi All - I've created a basic financial model to help me evaluate deals against a few capital structure scenarios (debt, private equity). I would appreciate feedback on my assumptions (ie, am I realistic about private equity payment structure?), as well as other possible scenarios that could be built into the model.

Thanks ^redacted‌, ^redacted‌, ^redacted‌, ^redacted‌, ^redacted‌, ^redacted‌, ^redacted‌, ^redacted‌, ^redacted‌, and ^redacted‌ for all the feedback on the Pre-LOI model. Version #2 is up - would appreciate further feedback if you have it in you :)

Here is the updated workbook: redacted

redacted

Thanks!