One Excel feature real estate financial modeling professionals use often is the data validation list. Where data validation is a method of limiting the possible inputs of a cell, the data validation list limits those inputs to a pre-defined list created by the financial modeling professional. In real estate financial modeling, these lists are essential […]
This walkthrough, our tenth in the series, takes you through the entire process of underwriting a hypothetical office value-add opportunity using the All-in-One (Ai1) Model. This walkthrough comes as a response to a question we recently received in the Ai1 Support Forum. Here is the question: We are exploring the route of acquiring a value […]
Going back to graduate school is a huge commitment. First there’s the admissions process, which means spending hours and hours studying for the GMAT or GRE, filling out lengthy admissions applications, writing dozens of mindless essays, preparing for and doing informal and formal admissions interviews, and enduring the stress of not knowing if you’re in, or […]
Several years ago, we published a careers in real estate series where we discussed the various job sectors, business fields, and job functions that exist in the real estate industry. Additionally, we broke down compensation in real estate (salary + bonus) by position and level for 2014. Since then, each year we’ve followed up that series with […]
As has been our habit since starting Adventures in CRE a few years back, we try to keep our readers updated on our progress and direction. Many of you have been with us since the start and we’ve personally communicated with hundreds of you. So we think its important to regularly cue you in on […]
As many of you recall, in 2015 I set out to build an Excel alternative to the widely-used (and now discontinued) ARGUS DCF. With career moves and a lot of other A.CRE-related side projects, this undertaking has been slow going. Alas, in 2016 I released the first beta-version of the model – my All-in-One (Ai1) Underwriting […]
In commercial real estate, there are a few generally accepted methods for appraising (or valuing) real property. The three most common are the Cost Approach, the Sales Comparison Method, and the Income Approach. The Income Approach includes two methods, the simpler of the two is the Direct Capitalization method, which this post will cover. The […]
This walkthrough, our ninth in the series, touches on the newly added (beta v0.5.3) ‘Print Mode’ and IRR Matrix Report in our All-in-One (Ai1) model. Print mode further enhances the printability of the model while the IRR Matrix Report adds another tool to help you assess prospective investments. Video Walkthrough – Using ‘Print Mode’ Video Walkthrough […]
This walkthrough, our eight in the series, explains how the Tenancy Analysis report for office, retail, and industrial real estate underwriting works in our All-in-One (Ai1) model. The Tenancy Analysis report includes a tenant rollover schedule, a graph illustrating cumulative expiration of net rentable area by year, a summary of weighted average lease term and remaining […]