I am building my pro-forma investment model for an acquisition and am planning to utilize the following financing structure:

Funding: 80% Seller Debt at 12%, 15% Preferred Equity at 10%, 5% Common equity.
Returns: 50-50 catch-up to a 20% IRR, then 80%-20% Common-Preferred split

I wanted to see if anyone would be willing to share their excel model that contains an equity waterfall section for a scenario anywhere close to this.