VC Fund Modelling - 20/04/2023 06:10 EDT

Prepare a fund waterfall model considering the following inputs (all in millions) -
1 Fund Size - 100,00 €
2 GP contribution - 2,00 €
3 1st Close LP commitment - 58,00 € (31/12/19)
4 2nd Close LP commitment - 40,00 € (1.5 years post 1st close) (30/6/21)
5 2nd Close investors are required to make payments for equalization of both capital and fees. They are also required to compensate the existing LPs with annualized interest @- 10,00%
6 Drawdown 1 - 30,00 € (T=0) (31/1/20)
Drawdown 2 - 30,00 € (T=1.5 years) (30/6/21)
Drawdown 3 - 30,00 € (T= 2 years) (31/12/21)
7 Investment period - 3 years
Harvest period - 3 years
Fund life - 10 years
8 Management Fee - 2,00% (across fund life)
Carry - 20,00%
Other operational expenses - 0,15 € per year
9 Hurdle rate - 8,00%
Catch-up for GP - 100,00%
10 You Can consider three distributions (50%, 30%, 20% after 6,8,10 years respectively after launch)
You are also required to calculate the MOIC and IRR for the GP, 1st close LP and 2nd Close LPs.

Kindly make the model as flexible as possible and make necessary assumptions wherever necessary.