Before launching the Accelerator program, Michael and I received countless emails requesting a more structured, step-by-step real estate financial modeling training program.
Over the years, we've covered hundreds of real estate modeling…
Arguably the most powerful, and least appreciated and understood, functionality in Excel is its use of boolean logic. Or in other words, the use of TRUE and FALSE binary logic. This form of logic can be used to dramatically simplify formulas…
https://www.adventuresincre.com/wp-content/uploads/2018/07/boolean-logic.jpg10801624Spencer Burtonhttps://adventuresincre.com/wp-content/uploads/2022/04/logo-transparent-black-e1649023554691.pngSpencer Burton2021-02-26 19:10:192023-01-18 10:01:41Using Boolean Logic to Model Multiple Generations of Tenant Improvements
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…
https://www.adventuresincre.com/wp-content/uploads/2021/01/printable-report-excel-model.jpg10001500Spencer Burtonhttps://adventuresincre.com/wp-content/uploads/2022/04/logo-transparent-black-e1649023554691.pngSpencer Burton2021-01-25 06:00:112023-01-18 10:03:38Create Printable and PDF Reports in Excel for Real Estate Financial Modeling
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…
https://www.adventuresincre.com/wp-content/uploads/2019/10/due-diligence-notebook.jpg10801827Spencer Burtonhttps://adventuresincre.com/wp-content/uploads/2022/04/logo-transparent-black-e1649023554691.pngSpencer Burton2021-01-19 14:02:032024-09-06 09:54:42Real Estate Acquisition Due Diligence Checklist
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…
https://www.adventuresincre.com/wp-content/uploads/2020/03/Real-Estate-Development-Checklist-cover.jpg7701280Spencer Burtonhttps://adventuresincre.com/wp-content/uploads/2022/04/logo-transparent-black-e1649023554691.pngSpencer Burton2021-01-17 06:30:102024-09-06 09:55:31Real Estate Development Due Diligence Checklist
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…
https://www.adventuresincre.com/wp-content/uploads/2016/02/classic-1-1220296.jpg7501000Spencer Burtonhttps://adventuresincre.com/wp-content/uploads/2022/04/logo-transparent-black-e1649023554691.pngSpencer Burton2021-01-06 17:40:112024-09-04 17:13:21Apartment Acquisition Model with Monte Carlo Simulation Module (Updated Jan 2021)
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…
https://www.adventuresincre.com/wp-content/uploads/2021/01/LAMBDAfunction_Microsoft_Excel.png313800Spencer Burtonhttps://adventuresincre.com/wp-content/uploads/2022/04/logo-transparent-black-e1649023554691.pngSpencer Burton2021-01-02 14:28:382023-01-18 10:42:59Using Excel’s New LAMBDA Feature to Create Custom Functions for Real Estate Financial Modeling
For one reason or another, there is a perfectly functioning and pretty valuable formula that can be utilized in Excel that Microsoft has chosen to exclude from Excel's list of functions: the DateDif function. This function is a valuable…
https://www.adventuresincre.com/wp-content/uploads/2016/04/calendar-series-4-1192550-640x480.jpg480640Michael Belascohttps://adventuresincre.com/wp-content/uploads/2022/04/logo-transparent-black-e1649023554691.pngMichael Belasco2020-11-14 14:23:282023-01-18 10:40:55DateDif: The “Secret” Excel Formula (Updated 11.14.2020)
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…
https://www.adventuresincre.com/wp-content/uploads/2020/09/Partitioning-IRR-in-Excel-scaled.jpg15211920Spencer Burtonhttps://adventuresincre.com/wp-content/uploads/2022/04/logo-transparent-black-e1649023554691.pngSpencer Burton2020-09-16 15:25:332024-04-02 21:30:44Watch Me Build – IRR Partitioning in Excel
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,…
https://www.adventuresincre.com/wp-content/uploads/2020/08/a.cre-help-knowledge-base.jpg9201358Spencer Burtonhttps://adventuresincre.com/wp-content/uploads/2022/04/logo-transparent-black-e1649023554691.pngSpencer Burton2020-08-28 11:37:482023-01-18 10:47:31Announcing the New A.CRE Help Section
I've decided to do a major overhaul of my last acquisitions model for office, industrial, and retail properties. There were a lot of things I wanted to change as well as add to the model and finally had a weekend to do it. This new and improved…
https://www.adventuresincre.com/wp-content/uploads/2016/08/rockys-view-1186570-1280x1920-1.jpg924840Michael Belascohttps://adventuresincre.com/wp-content/uploads/2022/04/logo-transparent-black-e1649023554691.pngMichael Belasco2020-08-26 06:43:072024-09-06 09:55:01Real Estate Acquisitions Model #2 for Office, Retail, Industrial (Updated Aug 2020)
This topic has come up on Adventures in CRE various times over the years. I first blogged about my decision to pursue a Masters in Real Estate over an MBA five years ago. And last year Michael, discussed his thought process around getting dual…
https://www.adventuresincre.com/wp-content/uploads/2020/07/Square-Making-the-Masters-Thumbnail.png10801080A.CREhttps://adventuresincre.com/wp-content/uploads/2022/04/logo-transparent-black-e1649023554691.pngA.CRE2020-07-07 08:00:142023-01-18 10:50:44Making the Masters in Real Estate Decision
This is an Excel model I originally built from scratch back in 2015 for quickly assessing multifamily redevelopment opportunities. It was designed to work best for scenarios where individual units will be rehabbed over the hold at varying times.…
https://www.adventuresincre.com/wp-content/uploads/2015/05/multifamily-building.jpg10801620Michael Belascohttps://adventuresincre.com/wp-content/uploads/2022/04/logo-transparent-black-e1649023554691.pngMichael Belasco2020-06-27 00:00:472024-09-05 13:36:09Multifamily Redevelopment Model (Updated June 2020)
Just like any skill in life, there are tips and tricks to learning that skill. Some suggestions are more helpful than others, although all contribute in some way. In this episode, we share one of the more valuable tips - what our marketing team…
https://www.adventuresincre.com/wp-content/uploads/2020/06/Square-The-Secret-to-Learning-Real-Estate-Financial-Modeling-Thumbnail.png10801080A.CREhttps://adventuresincre.com/wp-content/uploads/2022/04/logo-transparent-black-e1649023554691.pngA.CRE2020-06-24 08:00:342023-01-18 10:51:06The “Secret” to Learning Real Estate Financial Modeling
If you are investing in real estate, it's only a question of when and not if you will need a lawyer. However, many clients do not always have significant experience in the past. As a commercial real estate attorney, I'm going to walk through…
https://www.adventuresincre.com/wp-content/uploads/2020/06/how-to-hire-an-attorney.png10801080Ron Rohdehttps://adventuresincre.com/wp-content/uploads/2022/04/logo-transparent-black-e1649023554691.pngRon Rohde2020-06-01 18:25:322023-01-18 10:51:15Ask a Pro: How to Hire Your Next CRE Attorney
Many A.CRE readers are young professionals and college students trying to navigate the job market in a recession. Finding a job in commercial real estate amidst the craziness of the COVID-19 pandemic can be challenging, especially for those…
https://www.adventuresincre.com/wp-content/uploads/2020/05/landing-a-job-in-CRE-in-a-recession.png10801080A.CREhttps://adventuresincre.com/wp-content/uploads/2022/04/logo-transparent-black-e1649023554691.pngA.CRE2020-05-12 07:00:372023-01-18 10:51:30From College to a Job Amidst the COVID-19 Recession
