Please build a dynamic equity waterfall model per the instructions below

Please provide the IRR and EM for both Sponsor and LP Intial Investment is $1MM.

The investment will generate $100k in Y1, with 5% increases annually thereafter. The initial capital outlay will appreciate at a 7% annually before being sold in year 5.

Initial Investment funded as follows: Sponsor funds 10%, LP 90%, and will split cashflow pro-rata until a 10% IRR 25/75 Split up to a 12% IRR 50/50 Split thereafter.