, , ,

Real Estate Financial Modeling Accelerator (Updated Dec 2020)

Since starting A.CRE, Michael and I have 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 topics in our blog,…
, , ,

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

University of California-Berkeley – Undergraduate Real Estate Profile

U.C. Berkeley has a wonderful real estate community with members from all colleges on campus, expert faculty, and a plethora of extracurricular opportunities. I came into Berkeley as a pre-med student and fell in love with real estate through…
, ,

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…