A common question we’ve been getting recently is, how do I create printable reports from a real estate financial model in Excel? In this written and video tutorial, I share the three basic steps for creating printable and PDF reports in any real estate model you (or someone else) built in Excel. Are you an […]
Most of the Excel tools we share on Adventures in CRE are real estate financial models, but occasionally we’ll venture into building other CRE-related tools. Over the past several months, I’ve been working on a real estate acquisition checklist that can be used by real estate acquisition teams to track the progress of their due […]
Last year, I shared a Real Estate Acquisition Due Diligence Checklist that was quite popular. Soon after its release, we began getting requests for a similar tool, but for development deals. So allow me to share a Real Estate Development Due Diligence Checklist for those development professionals looking to add a checklist to their due […]
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 […]
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 over the holiday break, I took sometime to learn how to use this feature. And I’m […]
Our library of real estate Excel models has a variety of decent apartment models, including our All-in-One model and our Apartment Development Model – both robust models in their own right. However, if you’re looking for a straight multifamily (apartment) acquisition model, and don’t want all of the unnecessary components of the All-in-One (ie. office, retail, industrial modules), […]
A few years back, on a sleepy Saturday afternoon while my kids were busy eating Halloween candy, I decided to create a simple real estate acquisition model in Excel for office, retail, and industrial deals. Since then, I’ve made various updates, including error fixes and functional improvements. The model calculates returns at the property and […]
In this post, I’d like to show you how to partition the internal rate of return of your real estate investment in Excel. I also throw in a quick equity multiple partition, to highlight how the time value of money affects your returns. I’ve recorded a short Watch Me Build video tutorial to illustrate the […]
At A.CRE, we receive thousands of emails every month from our readers, users of our financial models, and our Accelerator members. The topics of those emails range from career advice, consulting requests, and questions about the Accelerator, to technical issues, bug reports, and modeling questions. And while our administrative staff does a phenomenal job of […]
One of the more difficult aspects of modeling a real estate development is figuring out how to handle equity and debt cash flows. This becomes all the more difficult when a second tranche of debt is introduced. In this Watch Me Build video, I turn on my screen recorder and talk through modeling a capital […]
Virtually every real estate firm in the world uses Microsoft Excel to analyze real estate. It’s the industry standard and if you work in real estate you better know how to model real estate in Excel. So regardless of whether you love Excel or hate it, the hard truth is that this fact isn’t going […]
There are few Excel experiences more frustrating than getting that “this workbook contains links to one or more external sources” alert and not being able to find/break the external links causing it. In this tutorial, I teach you five steps to fix the problem. In the video that follows the written instructions, I fix the […]