, , ,

Excel Tips: Creating Data Tables Part 3: Two Variable Data Tables - How To Display More Than One Return Metric Within a Cell

In the third part of this data table series, I'd like to show you how you can create data tables with multiple return metrics within each cell of the data table as shown in the image below.   The way to do this is actually quite…
, ,

Excel Tips: Creating Data Tables Part 2: Two Variable Data Tables For CRE Underwriting

Back when we first started this website, I wrote a post with a downloadable excel file that walks the reader through how to create a one variable data table. This is a long overdue follow up to that post to show you how to create a two-variable…
, , , , , , , , ,

Construction Draw Schedule: Accounting For True LTC

Mitigating A Common and Potentially Costly Error During Development Underwriting When lenders provide debt for a development project, they lend based on a Loan-to-Cost ratio (LTC), which is simply the percent of the total budget the lender…
a shopping center with robust sales and low occupancy cost
, , , , , ,

Tenant Sales and Occupancy Cost in Retail Underwriting

When underwriting a retail investment, rollover risk is an incredibly important consideration. You, as a prospective debt or equity investor in the property, need to understand how secure the cash flows you're buying are; or in other words,…
, , , , ,

Calculate Residual Land Value in Excel

Here's the scenario. You're a real estate developer. You spot a prime parcel of land that would be perfect for your real estate project. So you approach the owner of the land about selling and she says, "Okay, bring me an offer." How much do…
, , , , , , , ,

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…
, , , , ,

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…
, , , , , , , , ,

After Tax Analysis in Real Estate

When modeling real estate investments, industry practice is generally to stop at before tax cash flow. And this makes sense in most instances. No two owners of real estate have the exact same tax situation and no two properties necessarily…
, , , , , ,

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…