While the All-in-One is meant to handle more complex lease scenarios and therefore can do a lot of the things that people turn to non-Excel solutions for, it still has Excel-specific limitations that it’s important to be aware of.
First, the ORI module does not support reimbursement of management fees. The complexity of handling the circular nature of reimbursing management fees outweighs the benefit. As a workaround, we’ve included an Admin Fee that when modeled as approximately the same amount as the management fee gets you to approximately the same outcome.
Second, the ORI module is limited to three generations of leases. This is to avoid exceeding Excel’s memory capacity. Given that the max analysis period in the All-in-One is 10 years, and most long-term leases are 3+ years long with downtime between leases, this limitation shouldn’t affect most people. But if your scenario includes leases shorter than three years, you’ll likely need to use a different solution or shorten your analysis period.
Finally, the lease reimbursement module in the All-in-One has limitations. While NNN and Gross leases generally model well, when you get into gross modified/base year type leases, the reimbursement amounts or more approximations that an accurate forecast of the reimbursements. This again is due to the limitations of Excel. If you need an exact forecast of future reimbursement cash flows, you’ll need to use a non-Excel solution.
When downloading and opening an Excel model from A.CRE, some users get the ominous message: “Microsoft has blocked macros from running because the source of this file is untrusted.” Now you’re probably asking, “Why did this message appear, and can I use the file without macros?”
A bit of background on Excel Macros
First off, we assure you that you can enable Macros in our models with confidence. We use Macros in our Excel models to improve the user experience, speed up the models in cases where there are circular references, and to handle various real estate modeling tasks (e.g. calculating reserve accounts) that Excel out-of-the-box can’t.
Sometime in late 2021/early 2022, Microsoft released an updated version of Microsoft Excel that includes greater security protection related to Excel Macros. This update is meant to protect Excel users from downloading files from the internet that contain malicious macros. Unfortunately, in their zeal to protect Excel users from bad actors, they’ve made using A.CRE models a bit more difficult.
Unfortunately, the A.CRE Models that we’ve built with macros won’t function properly unless you enable the macros. Therefore, you will need to enable the macros in order to use the models. Below, we’ve recorded a video and shared instructions (from Microsoft’s website) on how to enable macros in models downloaded from A.CRE.
How to enable macros in models downloaded from A.CRE
Download and save the Excel model (i.e. Excel file) to a local hard drive, network share, or cloud share drive.
Open Windows File Explorer and go to the folder where you saved the file.
Right-click the file and choose Properties from the context menu.
At the bottom of the General tab, you should see a section for Security. Select the Unblock checkbox and select OK.
The A.CRE site is broken up into two sections, the A.CRE frontend (i.e. the blog frontend of the site) and the Accelerator program section. The frontend is where, among other things, you download/purchase Excel models from our Library while the Accelerator section is where you access/take real estate financial modeling courses. As an Accelerator member, you have access to both sections of the website and your login credentials are the same for both.
The two sections are, however, largely independent from one another. Materials you purchase/download on the frontend are saved to your ‘My Downloads’ page on the frontend. Materials related to Accelerator courses, such as case studies and Excel models, are downloaded directly from the Accelerator courses (not from your ‘My Downloads’ page on the frontend).
For ease of navigation back to the frontend, in the Accelerator section we’ve included a menu link entitled ‘My A.CRE Downloads’. That link will take you back to frontend to download models you’ve purchased from the frontend. Likewise, on the frontend we’ve included a menu item entitled ‘Accelerator’ that includes a ‘Members Only’ sub-menu item that will take you back to the Accelerator.
While your login credentials are the same for both sections of the site, occasionally when you navigate from one section to the other, you will be required to log back in. So for instance, if you’re in your ‘My Downloads’ page and you want to return to the Accelerator, you could go to the Accelerator menu link, select ‘Members Only’, and then click ‘Login’. You will then be taken to the Accelerator section, and if your Accelerator session had ended, you will be prompted to log back in. Simply use your A.CRE username and password to log back in.
The file you received is NOT a .zip file (or .cpgz file in the case of Mac users). The file you downloaded is an Excel .XLSB file (i.e. Excel Binary Workbook file).
Since XLSB files are binary, they can be read from and written to much faster, making them extremely useful for very large spreadsheets. XLSB files are also generally smaller than typical XLSX or XLSM Excel. As a result, the A.CRE team prefers to use the .XLSB file format for many of their more complex models.
However, to open a .XLSB file you must have a version of Excel 2013 or newer. If you don’t have a compatible version of Excel, and since the XLSB file is a compressed version of an Excel file, your operating system (i.e. Windows or iOS) confuses the XLSB file for a zipped file and attempts to extract the file.
To correct this issue, upgrade your Excel to the latest version. If you prefer to open the file in a different spreadsheet tool or find a workaround, you might check out this online guide:
Absolutely. Consider hiring the team that trains the industry for your real estate analysis needs! Our real estate financial modeling consulting group offers services ranging from crafting bespoke models to adapting our existing models to support your specific requirements. Availability and pricing vary depending on the project’s specific needs and complexity. For further details and to arrange a discovery consultation with our experts, please follow the link below:
Yes. Adventures in CRE was started as a medium for Spencer and Michael to openly share their (growing) library of institutional-quality real estate Excel models. The Accelerator training program was launched years later, in response to requests from A.CRE readers asking for more comprehensive and structured training.
Nevertheless, A.CRE’s mission of making industry-standard models readily available to all continues. New models continue to be added to the library and existing models are regularly updated, thanks to the feedback from A.CRE readers such as yourself!
First as background, Spencer and Michael build and share models on Adventures in CRE more as educational tools than as investment tools. Nevertheless, they recognize that many of the models have been sufficiently vetted that they can very much serve both purposes. Thus, we created the terms of use for how the models might be used outside of educational purposes and made clear that models likely contain errors.
Adventures in CRE provides great leeway in how the models are used, in that you can share and edit the models as you see fit so long as:
You don’t resell the Excel model or any of the modules therein.
When you share the file, you continue to credit the original authors. That means, keeping the Version tab in the Workbook.
You don’t use the file for illegal purposes.
So in practice, what the above means is that the outcomes of your analysis can go in OMs and be shared with lenders/ investors, etc without issue. And no credit is necessary in that sharing, since you’re sharing the outcomes, not that actual files. When/if you share the actual Excel file, or some derivative of the Excel file, just make sure you leave the Version tab unchanged in the Workbook and you’re good to go.
All models shared to our Library of Real Estate Excel models include written and video instruction for using the model. Some models includes those tutorials directly on the model’s description page, while others include a separate tutorials page with multiple video tutorials.
Here are a few examples of comprehensive training materials created for models:
Yes, all of our models are unlocked and fully customizable. If you adapt our models and choose to use that adaptation professionally, we only ask that you follow the terms and conditions of use agreed to upon downloading the model. Namely:
The users agree not to charge others for use of the software, regardless of whether users have altered and/or improved the software in anyway.
In any use of the software, the users agree to acknowledge the www.AdventuresinCRE.com authors that developed the software.
The users agree to obey all government restrictions governing redistribution or export of the software.
The users agree to reproduce any copyright notice which appears on the software and documentation on any copy or modification of such made available to others.
The user agrees to not modify, delete, or password protect access to the Versions tab, and any use of an A.CRE model, whether in part or in whole, must include a copy of the Version tab for that model used, modified, adapted, or shared by user.
When an Excel model crashes upon opening, or when Excel returns a “the file is corrupt and cannot be opened” error message upon attempting to open a model, it’s generally due to one of two issues:
You’re running a version of Excel incompatible with the model. Make sure you’re running Excel 2013 or newer.
A security setting on your system is blocking the file. Here are a few options for correcting the security setting:
Once you purchase/request to download a model via the model’s download checkout page, you should receive a download link via email. Occasionally, that email will get routed to spam or blocked by your ISP. In either case, you can also find all models you purchase/request in your ‘A.CRE My Downloads‘ page.
The team at A.CRE has built the world’s largest library of readily accessible real estate Excel models. In fact, this was A.CRE’s initial primary mission – to make institutional-quality models available to all. As a result, we provide all Excel models in our Library on a “Pay What You’re Able” basis, with no minimum.
Click on the model to read the description page; all models include written and video tutorials (either on the description page or on a separate page) on how to use it.
In the description page of the model, find and click the green “Proceed to Download Page” button.
On the model download page, choose either the ‘Free (Educational Use)’ or ‘Paid (Unlimited Downloads + Updates)’ option and then enter a price. A.CRE readers who choose to support the mission of A.CRE by choosing the Paid version of the model, are provided unlimited downloads and lifetime updates of that model. Otherwise, there is no difference between the Educational and Paid versions of the model.
Once you’ve clicked ‘Proceed to Download’ you will be taken to your Download Queue (i.e shopping cart).
Select ‘Proceed to Download’ in the Download Queue or return to the Library of Real Estate Excel Models to add more models to your queue.
Once you’re ready to “checkout”, return to the Download Queue and click ‘Proceed to Download’ to be taken to the checkout page.
If you’re an existing A.CRE user and you’re not logged in, use the ‘Click here to login’ button to log into your account from the checkout page.
If you’re new to A.CRE, within the ‘Account Details’ section, enter your name, zip code, country, and email address and click ‘Complete Checkout’.
Review the ‘Download Details’ box and confirm that you’re downloading the correct model and price. If not, or there are other products within the ‘Download Details’ section you don’t intend to buy/download, simply click the green X next to the product to remove it from the transaction.
Check the ‘I have read and agree to the terms and conditions’ button, and then click the ‘Complete Checkout’ button.
The system will then process the download, and take you to a page with further instructions. A link to download the model will be added to your A.CRE My Downloads page and will also be emailed directly to you.
