Hi Spencer,
Your blog is a high-quality and professionally-executed resource for aspiring RE professionals, such as myself! Thank you so much for the great articles and models you have shared here!
I have a pretty basic question re: Excel Version Compatibility. I realize on the “ALL-IN-ONE (AI1) UNDERWRITING MODEL FOR REAL ESTATE DEVELOPMENT AND ACQUISITION (UPDATED 7.14.17)” web page, it says that the model is not compatible with Excel 2007. Does this mean “complete incompatibility” or “partial incompatibility”? I ask b/c I am working with your model on Excel 2003 (an even earlier of Excel), yet the model still seems to work. The tabs show up as new modules are selected, the numbers calculate etc. What is the part of the model that is “incompatible” with older versions of Excel?
Thank you,
Chee H
Appreciate the kind words and great question! I built the model in Excel 2016 for Windows using functions and features available in that version of Excel. As a result, I can’t guarantee that the model will work with earlier versions of Excel. I have relied on user comments to find whether the model is fully compatible with earlier versions and have been told by numerous users (here is one example) that the model has issues with Excel 2007 – largely related to the development module, s-curve forecasting, and the construction interest calculation macro. I can’t personally confirm because I don’t have Excel 2007 – just what I’ve been told by other users.
My recommendation is to upgrade to a more recent version of Excel to be sure all current and future functions work properly.
