, , ,

Real Estate Financial Modeling Accelerator (Updated Nov 2024)

Prior to launching the Accelerator program, Michael and I fielded email after email requesting a more structured real estate financial modeling training program on the site. Over the years, we've covered hundreds of real estate modeling…
,

Your Career’s Next Level with Jeff Wittenberg – S2E7

 About this Episode - Your Career's Next Level with Jeff Wittenberg Welcome to the A.CRE Audio Series! On this episode, I am here once again with the creators of the Adventures in CRE website, Spencer Burton and Michael…
,

A Day with Developer Vicky Lee – S2E8

 About this Episode - A Day with Developer Vicky Lee Welcome to the A.CRE Audio Series! On this episode, I am here once again with the creators of the Adventures in CRE website, Spencer Burton and Michael Belasco. Today…
,

The Journey of a CRE Entrepreneur with Alex Zikakis Part I – S2E9

https://www.youtube.com/watch?v=z_hVRuCtMXI&feature=youtu.be About this Episode - The Journey of a CRE Entrepreneur with Alex Zikakis Part I Welcome to the A.CRE Audio Series! On this episode, I am here once again with the creators…
,

The Journey of a CRE Entrepreneur with Alex Zikakis Part II – S2E10

 About this Episode - The Journey of a CRE Entrepreneur with Alex Zikakis Part II Welcome to the A.CRE Audio Series! On this episode, I am here once again with the creators of the Adventures in CRE website, Spencer Burton…
,

Model Like A Deal Seasoned Pro [UPDATED] – S2E11

 About this Episode - [UPDATED] Model Like A Deal Seasoned Pro Welcome to the A.CRE Audio Series! On this episode, I am here once again with the creators of the Adventures in CRE website, Spencer Burton and Michael Belasco.…
, , ,

Letter of Intent for Office Leasing

Today we’re going to be diving into what is typically the very first legal document presented to a Landlord who is renting commercial office space: the letter of intent for leasing. At the end of this post, find a link to download a template…
, , ,

LIHTC (Low Income Housing Tax Credits) Overview and Calculator

Below is an overview of how LIHTC (low income housing tax credits) are calculated and applied to affordable housing projects. At the bottom of the post you will find downloadable excel files that correspond with the videos. LIHTC - An Overview LIHTC…
, , , , , , , ,

Watch Me Build a Multifamily Real Estate Model (Updated Feb 2020)

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 Dynamic Sub-Property Type Drop-Down Menus in Excel

A few years ago, I created a tutorial on building smart drop-down menus in Excel using dynamic named ranges and data validation lists. This offered a great way to have drop-down menus in your model that could be easily changed by the user to…
, , ,

Dynamic Amortization Schedule (Updated 2.06.2020)

This is a dynamic amortization schedule for debt that gives the user the capability to model a loan with an interest only period up front and an amortizing floating rate debt repayment period once the interest only period is over. This module…
, ,

A.CRE Audio Series Season Two – Coming March 2020

Michael, Spencer, and series host Sam Carlson met in Frisco, TX Jan 18th - 20th to record the second season of the Adventures in CRE Audio Series. This new season includes 11 episodes with guest interviews, real estate financial modeling insights,…
, ,

Using VBA to Hide Rows in Excel

Over the next few minutes, I will show you two techniques for automatically hiding and showing rows in Excel using VBA code. These techniques I use regularly in my real estate financial models to make for a more intuitive user experience. In…
, , , , ,

Watch Me Build Data Tables For Real Estate Sensitivity Analysis

This is a 3 part mini-series on using data tables in Excel to perform real estate sensitivity analysis. In this series, I'll walk you through how to build both one-variable and two-variable data tables in parts 1 and 2. And in Part 3, I'll walk…
,

Modeling a Mortgage Loan Assumption Using the All-in-One

I recently had a discussion in the All-in-One support forum about how to model a mortgage loan assumption using my All-in-One Model for Underwriting Acquisitions and Development. Prior to version 0.77, this required manually overriding various…
, , , , , ,

Watch Me Build A Construction Draw Schedule (Updated Jan 2020)

In the following video, I record my screen and narrative my steps as I build a basic construction draw schedule. I've also included the template and completed worksheets from this Watch Me Build exercise. Are you an Accelerator member? See…