JV Investor vs Hard money spreadsheet

[Mark Rios]

I'm a real estate capital provider and private lender on the commercial side as well as NOO single family. I've had more than a few inquiries looking to compare the ROI benefits of a Preferred return JV program we offer vs a straight hard money loan (and a possible JV investor partner)

So I created, using my MINIMAL excel knowledge a simple comparison spreadsheet to help see the benefits of going with easier preferred return type JV money or hard money. It's not ready for primetime yet, but I wanted to run it by the community to get some ideas on what to fix or add.

Inputs in blue text. You can adjust Purchase price, closing costs, JV splits, loan rate, Gap Funding JV Partner contribution and profit splits etc..

Feedback and adjustments are welcome.. Would be interested in seeing how short term IRR or annualized ROI might play here.

JV vs Hard Money BETA spreadsheet

DISCLAIMER -- I am not an excel expert and there may be errors in the formulas here or the layout may be confusing to you.. Use at your own risk and don't use for production unless you've checked formulas for yourself.