This is a very Beta ROI comparison model for a Preferred equity JV investment with profit split vs a straight hard money loan. Inputs in blue text. You can adjust Purchase price, closing costs, JV splits, loan rate, Gap Funding JV Partner contribution and profit splits etc.. Please edit and use as you wish. DISCLAIMER -- I am not an excel expert and there may be errors in the formulas here.. Use at your own risk