, , ,

Real Estate Financial Modeling Accelerator (Enrollment Open)

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

Best Practices in Real Estate Financial Modeling

Before you use one of our real estate financial models (i.e. Excel templates), or before you set out to build your own real estate analysis tool in Excel, it's important to keep in mind a few real estate financial modeling best practices. This…
, , , , ,

Deep Dive - Sources of Capital: Real Estate Private Equity

Capital for commercial real estate investments is generally sourced from one or more of the following buckets: public equity, public debt, private equity, or private debt. In my experience, few people fully understand these four buckets of capital,…
,

Textbook Review: Real Estate Finance and Investments (5th Edition)

The Non-Textbook, Textbook There are two dead giveaways that a book is a textbook - the length of it's title and the thickness of its bindings. Based on those metrics - a long title and thick bindings - this book passes the textbook…
vintage Walgreens on corner of two busy california streets
, , , , , , , , ,

Single Tenant NNN Lease Valuation Model (Updated 9.18.2018)

I originally built this single tenant net lease (NNN) valuation Excel model back in 2016. Based on some feedback from a few of our readers, I've since made a few updates. This model is an attempt to re-think how the industry underwrites single-tenant…
, , , ,

Understanding Treatment of Time 0 in the All-in-One Model

I received a very astute question/concern from a user of our All-in-One(Ai1) model in our Ai1 Support Forum late last month. I initially set out to answer the question in writing, but the more I thought about my response, the more I concluded…
, , , , ,

MBA or MRE? Why I Chose to Get Both and Some Considerations for What Might Be Right For You

Ever since Spencer wrote his post about why he chose to do an MRE as opposed to an MBA or a dual Master’s degree, I have been asked a lot by our readers about why I chose to go for both an MBA and MRE. Below I will discuss my rationale and…
, , , ,

All About Cap Ex

In this post, we are going to take a deeper look into capital expenditures. What it is and how we account for it in cre underwriting.Capital expenditures, commonly referred to as Cap Ex, are expenses that occur outside of normal operating…
, ,

A.CRE 101: CRE Risk Profiles

In this post we will go into detail about the four CRE risk profiles commonly ascribed to commercial real estate opportunities. In order of least risky to most risky, they are as follows:Core Core Plus Value Add OpportunisticThis…
, , , , ,

30/360, Actual/365, and Actual/360 - How Lenders Calculate Interest on CRE Loans – Some Important Insights

Commercial real estate lenders commonly calculate loans in three ways: 30/360, Actual/365 (aka 365/365), and Actual/360 (aka 365/360). Real estate professionals should be aware of these methods if they want to understand the real interest…
, , ,

A.CRE User Insights Survey

We need your help! As Adventures in CRE (A.CRE) has grown and evolved over the years, so have the needs of our readers. The challenge for Michael and I as we contemplate what new content to create, is knowing what resources will be most beneficial…
, , , , , ,

Watch Me Build: Construction Draw Schedule

The video below and corresponding downloadable templates will walk you through how to build a basic construction draw schedule.Basic Construction Financing & Draw schedules: A Conceptual Overview A standard draw schedule with a basic…
, ,

Keyboard Shortcuts I Use Constantly When Modeling in Excel (Formatting)

The more you model real estate in Microsoft Excel, the faster and more accurate you become - and hopefully as a consequence the more valuable you become to real estate employers and investors. Part of the process of mastering real estate financial…
, , , , , , , , , , ,

Development Draw Schedule - Visually Customize Each Line Item

Working a lot with development draw schedules, I have always been looking for a catch all solution as to how one could easily model all the unique ways cash actually flows over time during the process. The norm for many is to model cash flows…
bite-sized real estate tutorials
, , ,

Bite-Sized CRE Lessons - A.CRE 30 Second Video Tutorials

As we continue to build out our A.CRE 101 series and our Glossary of Commercial Real Estate terms, we've started to supplement these initiatives with short (<30 second) video clips on how to do various CRE calculations and modeling tasks…
, , ,

Using the Cash-on-Cash Return in Real Estate Investment Analysis

I’ve fielded a handful of Cash-on-Cash (CoC) return questions of late. So, I thought it would be worthwhile to write a post on what the Cash-on-Cash return metric tells me about a potential real estate investment. This article is a primer,…