Need help building this model to where I can make options 0-3 in microsoft excel as variables that can be adjusted, where $40MM is invested by the LPs of a private equity company on say for example, 1/1/2020 and another $40MM is contributed 7/1/2021 and all assets of oil and gas company are sold 1/1/2025 for $160MM; calculating what the preferred would be owed plus paying back the LPs, the different scenarios are chanfinf the waterfall amount, the preferred amount, and number 3 is a catch up provision.

need to be able to calculate what amount owed back to private equity company would be if a total of $80MM is invested at 2 different points in time, and all assets sold for $160MM on 1/1/2025. After the investors are paid back their $80MM plus the 8% preferred, how woild the remaining profits be split up (if management of the oil and gas company gets 20% and the LPs of the equity company get 80%)

Back in vedere = 160 40 yo sell 5 lo zbog S 80 EQ yr hold on 6150 Return 160 (1:1) 6% + Current 2ox. 20=4 8/20 until total AVAD > 20% of all returns Vilo 41/25 025% Tier? 38 anything As is ... 8% preffered 20% (waterfall) O " +255 (No waterfall) 6% 7206 ( water fall) . 8% - 20% (water Gall) but "catch up" parison mo s LPS Mamt 0 80 A 80MM 20-7 Pret : ~20mm 20% 80% Guntil Cumulative a's returned (Post Bloom) = 807 / 20% thin 90%/10% Post 8% Mant Back in vedere = 160 40 yo sell 5 lo zbog S 80 EQ yr hold on 6150 Return 160 (1:1) 6% + Current 2ox. 20=4 8/20 until total AVAD > 20% of all returns Vilo 41/25 025% Tier? 38 anything As is ... 8% preffered 20% (waterfall) O " +255 (No waterfall) 6% 7206 ( water fall) . 8% - 20% (water Gall) but "catch up" parison mo s LPS Mamt 0 80 A 80MM 20-7 Pret : ~20mm 20% 80% Guntil Cumulative a's returned (Post Bloom) = 807 / 20% thin 90%/10% Post 8% Mant