Special Topics in Real Estate

All | A.CRE 101 | College Education | Special Topics | Book Reviews | CRE Terms | Find a Job

All | Investment Analysis | Interesting Deals | Leases | Taxes

real estate financial modeling courses

, , ,

Real Estate Financial Modeling Accelerator (Updated April 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…
,

Industrial Real Estate Investments in Emerging Markets

E-commerce isn’t a new innovation, it has been around since the early 90s and was actually first created in the 1960s. Since then, many e-commerce companies have come and gone but in the past few years, there have been a few stable companies…
, , , , , ,

Deep Dive – Land Acquisition and Assemblage

This is a topic I'm all too familiar with. You see, I cut my teeth in real estate largely sourcing and negotiating residential and mixed-use land acquisition opportunities.  I've put land deals together both as a fiduciary and as a principal,…
, , , ,

Could You Be Exiting Too Early? Don’t Forget to Analyze Your Reinvestment Rate

When attempting to maximize the value of your money invested in real estate, the timing of your exit is key to maximize your return. Exit too early, and you might leave money on the table. Exit too late, and you might have better used that capital…
, ,

The Earnest Money Deposit – From Contract to Close Series

https://youtu.be/BIrK6pfvqGA What is an Earnest Money Deposit The earnest money deposit, also known as the good faith deposit or good faith money, is a sum of money that gets deposited by the buyer of a property into an escrow account…
, , ,

Using Excel’s New LAMBDA Feature to Create Custom Functions for Real Estate Financial Modeling

In December 2020, Excel rolled out a new featured called LAMBDA as part of the Office Insiders (i.e. beta) program. This feature allows the user to create custom functions, which can greatly reduce duplicative formulas and reduce errors. Well…
, ,

How to Quickly Evaluate Real Estate Opportunities (Without Opening Excel)

We regularly respond to questions from A.CRE and Accelerator members as it relates to analyzing and evaluating real estate investment opportunities. Recently, in an Accelerator forum post a young professional marveled at how certain individuals…
, , , ,

Analyzing Value-Add Investments in Real Estate Using Yield-on-Cost

So a question recently came in around why a commercial real estate investor would use the Yield-on-Cost metric to assess a value-add real estate investment. This question came on the heals of several other questions also related to development…
, , ,

All You Need to Know About Real Estate Gross-Ups

"Gross-up" clauses have caused confusion, and occasionally consternation, amongst tenants signing commercial leases for the first time. While many tenants are happy to pay for building services they use on a daily basis, many are riled when…
, , ,

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

Roll Up Your Monthly Cash Flow Line Items Into Annual Periods Using Only One Formula For The Whole Sheet

While building out my hotel development model (currently underway), I decided to take a break and record a video about how I roll up the monthly cash flow line items on my Monthly Cash Flow sheet into annual cash flow line items on a separate…
, , , , , ,

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

(Updated August 7, 2019 to include a Watch Me Build video and Downloadable file) 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…
, , , , ,

Through The Entitlement Process: Identifying Risks and Strategies For Mitigation

Investing in and developing an unentitled site, broadly speaking, is one of the riskiest, yet rewarding, endeavors in the commercial real estate industry. The entitlement process, in particular, is fraught with the potential for setbacks and…
, , ,

Deep Dive: Understanding Acquisitions: The Letter of Intent (LOI)

The Letter of Intent - Legal Issues The letter of intent is a critical document that is written up at the beginning of a potential real estate transaction between either a prospective buyer and seller or a prospective tenant and landlord.…
, , , ,

Excel-Based Restaurant Selection Tool for the Overly Indecisive

We're celebrating some much deserved time off from work, and so what better way to spend the time than to make a completely unnecessary (but fun!) Excel model. I call this the indispensable Excel tool for the overly indecisive, and it's basically…