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 […]
Frequently Asked Questions about the Development Associate Role at a U.S. CRE Development Firm
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 […]
Frequently Asked Questions about the Day in the Life of a VP and Principal at a Real Estate Private Equity Firm
Frequently Asked Questions about the Day in the Life of a Development Associate at a U.S. Development Firm
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 […]
The feedback has been positive on the ‘Watch Me Build a Multifamily Model’ video I recorded earlier this year. So I thought I’d follow that up with another. This time I build a Real Estate Tenant Rollover Analysis Model and talk through the methodology, keyboard shortcuts, and formulas I use as I build the model. […]
This walkthrough, our second in the series, will detail how to use the office/retail/industrial rent roll (see ORI-RR Tab). The rent roll tab is arguably the most important, and most complex, tab in the All-in-One model. Below we post a video of the walkthrough together with a brief description of the key components of this tab. Video […]
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 at what I do. I remember sitting with a friend, watching him zip back […]
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 fit their specific needs. But what about when you want a […]
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 the past, I’ve created similar tutorials for hiding worksheets or creating dynamic buttons […]