If you intend to distribute 30% to the GP in a given hurdle, be sure that the ‘Distribution %’ for the GP is set to 30%.
Contributions are assumed to be made pari passu (at the same time). So if capital is going out investor-first, you would need to customize the model.
To be upfront, my suggestion would be to request a refund for the model and do this analysis custom. This model isn’t really meant for the type of structure you’re describing. Spencer’s cash-on-cash waterfall model is probably the closest, although that model also assumes pari passu equity contributions and uses annual periods. So you’d have to customize that model as well.
The challenge with waterfall model templates is that every partnership structure is different. We have numerous waterfall models, but even so those only cover a certain range of common partnership structures. Waterfall modeling is a custom exercise in many cases – either building something from scratch or modifying existing models to cover a given structure.