Excel Tips

All | Argus | All-in-OneExcel Models | Excel TipsStochastic Modeling

publish or post a commercial real estate job including acquisitions, development, asset management to the acre job board

, , ,

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

Using COUNTIFS, SUMIFS, and AVERAGEIFS Excel Functions in Real Estate Underwriting

Why use COUNTIFS, SUMIFS, and AVERAGEIFS functions in real estate? When real estate analysts first start their careers, they're often required to work with large data sets and to transpose property and portfolio information from one format to…
, , , , , , , ,

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…
a gantt chart for real estate built in Excel
,

Bonus Content - Gantt Chart and Weighted Average with Multiple Conditions

I have two updates/improvements to previous posts I thought I'd share with our readers today; call it, bonus content! The first, is a dynamic Gantt Chart tool I recently added to my Construction Draw and Interest Calculation Model. The second,…
,

The Conditional Weighted Average – SUMPRODUCT with SUMIF

Consider this scenario: you have a 50 tenant rent roll, consisting of various tenant types (i.e. small inline, large inline, junior anchor, anchor, etc.), and you want to calculate the weighted average rent for each tenant type. If I asked you,…
,

DateDif: The "Secret" Excel Formula

For one reason or another, there is a perfectly functioning and pretty valuable formula that can be utilized in Excel that Microsoft has chosen to exclude from Excel's list of functions: the DateDif function. This function is a valuable…
, , ,

How to Prepare for the Real Estate Technical Interview

So you've made it past the HR screening interview. You have the education and experience the company is looking for, but now they want to be sure you possess the real estate financial modeling skills necessary to do the job. They've asked…
, , , , , ,

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…