If you plan on expanding on this particular model and adding things like sensitivity analysis or any type of simulation then I'd back track a bit and create separate input screens that then feeds your actual model.

@Jackie Lange Thank you so much for the rundown on the foundation issue and to @Joseph Weisenbloom for the reality check.I didn't do a good job of communicating that as I'm abroad for the time being, I'm just using the data at my finger tips to do simulations and practice the math.

Just run a ton of simulations off of zillow in your area and find what numbers can work.

In the old days before digital mapping, computerized flood simulations, and years of rainfall data, the floodplains were not as precise.

Yes I've been thinking this for years, I do run a lot of complex economic simulations, DST is not interested in the QE environment but DST becoming sexy in QT environment. 

I'll definitely go back to the drawing board with the inclusion of the acquisition fee and simulation the various split scenarios you described. 

When I hover over the tab, I'm seeing a gray and white box that simulated a page load animation.

I've bounced the numbers on this deal (as well as a few others I've looked at and done simulations on) by experienced investors and contractors and have said it feels like I'm in the right ballpark.

As for analysis, even if you cannot invest in properties at the moment, nothing keeps you from practicing your analysis skills (just like people simulate trading stocks to learn).

I always assumed they have different title insurance companies that they write through.Even if you have trouble finding a title company to allow the simul close, you can just use transactional funding and make your closing on the A to B go through with a wire from your one day loan.