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.

The post Are there any limitations in the ORI Module of the All-In-One Model? appeared first on Adventures in CRE Support.

The post Which model, tool, or tutorial would be most helpful for my scenario? appeared first on Adventures in CRE Support.

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.

• View more details on Microsoft’s website here

Can I use an A.CRE Model without enabling macros?

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

1. Download and save the Excel model (i.e. Excel file) to a local hard drive, network share, or cloud share drive.
2. Open Windows File Explorer and go to the folder where you saved the file.
3. Right-click the file and choose Properties from the context menu.
4. At the bottom of the General tab, you should see a section for Security. Select the Unblock checkbox and select OK.
5. Open the file and click ‘Enable Content’

The post Why do I get a message that Microsoft has blocked macros? appeared first on Adventures in CRE Support.

The two sections are, however, largely independent of 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 2.0, we’ve included a menu link entitled ‘My A.CRE Downloads’ that will take you back to the frontend to download models you’ve purchased from there. In Accelerator 3.0, you will find a menu link titled ‘Accelerator Membership Details,’ where you can access the ‘My Downloads’ tab.

The post How do I access my downloads from the Accelerator? appeared first on Adventures in CRE Support.

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:

https://www.lifewire.com/xlsb-file-2622534

The post Why did you send a zipped file (i.e. compressed file)? And why can’t I access (unzip) the file? appeared first on Adventures in CRE Support.

The post Does A.CRE provide consulting services or model customization? appeared first on Adventures in CRE Support.

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!

Browse the world’s largest library of readily available real estate Excel models

The post Can I download real estate Excel models without taking the Accelerator? appeared first on Adventures in CRE Support.

• Review the Terms and Conditions of Use for models downloaded from A.CRE

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:

1. You don’t resell the Excel model or any of the modules therein.
2. When you share the file, you continue to credit the original authors. That means, keeping the Version tab in the Workbook.
3. 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.

The post What do the Terms and Condition state for use of your models in CRE? appeared first on Adventures in CRE Support.

Here are a few examples of comprehensive training materials created for models:

• All-in-One Model tutorials
• Apartment Development Model tutorials

To find the training material for any model, simply read through that models description page.

The post Where do I find tutorials for the All-in-One and other Excel Models? appeared first on Adventures in CRE Support.

• 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.

The post Can I use your models as a foundation and add other things? appeared first on Adventures in CRE Support.