We’ve shared a handful of apartment models over the years. Several of those are capable of analyzing apartment acquisitions but none was built for the express purpose of modeling value-add apartment deals. As a result, each has its limitations in value-add scenarios. So today, I’m excited to share a new apartment model; this one built […]
We have a few stochastic modeling tools for real estate on the website, but none as robust as this Apartment Acquisition Model with Monte Carlo Simulation Module. I originally built the model in 2016 by taking my standard apartment acquisition model, and assigning probabilities to various assumptions. I then added a Monte Carlo Simulation module […]
I’m excited to share my Office Development Model in Excel. This pro forma analysis tool comes as I’ve continued to build and share specialty real estate models, tailor-made for specific investment scenarios and property types. This model is an adaptation of my Industrial Development Model. It’s specifically built to analyze both merchant-build and build-to-core, ground-up […]
I’ve been working on a project to make our library of Excel models AI-ready. The idea is straightforward: pair every A.CRE Excel model with an AI Skill, a packaged set of instructions and reference files that teaches an AI assistant how to operate that specific model on your behalf. The Advanced Mortgage Amortization Module is […]
In recent months, I’ve been working on an advanced real estate investment amortization table with interest-only capability, fixed and variable interest rates, multiple interest calculation methods (i.e. 30/360, Actual/Actual, Actual/365, Actual/360), monthly and annual periods, duration calculation, lender yield calculation, average life calculation, static and dynamic debt service payments, loan assumptions, and more. This module […]
Over the years, this real estate equity waterfall with annual periods and IRR or Equity Multiple hurdles has been one of the most popular models in our library of real estate Excel models. It’s been downloaded thousands of times and we’ve received dozens of suggestions for how to improve the model. As a result, we […]
We’ve received numerous requests over the years for a Self Storage Development Model in Excel. With strong investment and development activity in this niche property type, I recognize a self storage model on A.CRE is long overdue. But with so many other projects on our plates and limited experience with self storage, we just hadn’t […]
One of the reasons Michael and I blog, is to force ourselves to be continually learning. I built the first version of my real estate waterfall model, because I wanted to better understand the mechanics of modeling an equity waterfall with IRR hurdles. Michael started his Understanding Leases Series, because there were nuances of modeling […]
I’ve been working on a project to make our library of Excel models AI-ready. The idea is straightforward: pair every A.CRE Excel model with an AI Skill, a packaged set of instructions and reference files that teaches an AI assistant how to operate that specific model on your behalf. The Commercial Mortgage Loan Analysis Model […]
Over the years, I’ve received various requests to augment our library of real estate Excel models to include a model for underwriting and analyzing commercial mortgage loans. Specifically, people have asked for a tool to calculate the loan amount (ie. loan sizing) based on a combination of tests – debt service coverage ratio, loan-to-value, and […]
I’ve been working on a project to make our library of Excel models AI-ready. The idea is straightforward, pair every A.CRE Excel model with an AI Skill, a packaged set of instructions and reference files that teaches an AI assistant how to operate that specific model on your behalf. The Residential Land Development Model is […]
As many of you know, I started my career in residential land development first as a broker and later as a principal. During that time, I built my fair share of residential land development Excel pro formas, modeling returns and forecasting cash flows for my clients and investor partners. I’ve since transitioned into the institutional […]
In a recent post, I made the case that AI and financial modeling follow the same logic as long division and calculators. Learn the mechanics first. Once you’ve got them, the tool multiplies your output. The calculator only helps if you understand what it’s computing. That post was the argument. This one is the demo. […]
If you use Claude often, Claude Skills are how you teach it to work the way you do, without repeating yourself every time. Instead of pasting long instructions in every new chat, you write down your process once as a reusable Skill, save it, and then call that behavior with a short, natural request whenever […]
In Mrs. Jackson’s fourth grade class, and I’m guessing each of you had your own Mrs. Jackson, I learned to do long division by hand. Three-digit numbers, four-digit numbers, the whole bit. Pencil, paper, and that little ladder of subtraction and bring-downs that took forever and felt, even as a nine-year-old, like the most inefficient […]