vintage Walgreens on corner of two busy california streets
, , , , , , , , ,

Single Tenant NNN Lease Valuation Model

I've been meaning for some time to put together a single tenant net lease (NNN) valuation Excel model for the blog. I had some post-turkey day free time and so I sat down and hammered out a model that I think is pretty cool. The model is…
, , , , , , , ,

Watch Me Build a Tenant Rollover Analysis Model

The feedback has been positive on the ‘Watch Me Build a Multifamily Model’ video I recorded earlier this year. So I thought I’d follow that up with another. This time I build a Real Estate Tenant Rollover Analysis Model and talk through…
, , , , , ,

Real Estate Acquisitions Model - 2.0

I've decided to do a major overhaul of my last acquisitions model for office, industrial, and retail properties. There were a lot of things I wanted to change as well as add to the model and finally had a weekend to do it. This new and improved…
, , , , , , ,

Physical Occupancy Calculation Model for Real Estate

As many of you know, I'm in the midst of moving my family from Milwaukee to Dallas, and quite frankly I'm getting sick of eating out and sleeping in hotel rooms. So what better way to unwind from hours of whining kids and tiresome travel, than…
, , , , ,

Using an IRR Matrix to Determine Hold Period

When building a real estate financial pro forma, it's important to model for and include a summary of various return and risk metrics. Among the different return metrics, the internal rate of return (IRR) - both on an unlevered and levered…
, , , ,

3-Tiered Acquisition Debt Module

This is a debt module that will allow the user to add one to three tiers of debt to his or her DCF model. This excel file should be fairly intuitive and easy to understand and the entire model is on one sheet. Download it from the link below…
, , , , , ,

Watch Me Build a Multifamily Real Estate Model

One way to become a better real estate financial modeling professional, is to watch other professionals model. I know in my career being able to physically see how others tackle different modeling problems has shaped my methods and made me better…
, , , , , , , , ,

Create A Dynamic Revenue Row to Calculate Multiple Tenant Leases

I recently received an email from one of our readers asking how to create a dynamic revenue row for a pro forma that can capture rent changes for multiple tenants. I thought that this would make a great post for the site and would be a good…
, , , , ,

Apartment Acquisition Model with Monte Carlo Simulation Module

I'd like to share an apartment acquisition model I built that includes a Monte Carlo Simulation module. This method of analysis, a type of stochastic modeling rarely used in real estate, allows the analyst to better understanding the risk-adjusted…