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 […]
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 […]
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 […]
Since releasing the first beta version of the All-in-One Underwriting Model, we’ve fielded hundreds of emails related to the model. Inquiries range from questions to feature requests to thank yous. We welcome the chance to interact with our readers, and acknowledge that the model will only become as good as the feedback we receive from […]
This walkthrough, our seventh in the series, explains how the Ground Lease Valuation Module works and how to implement this tool into your analysis. The All-in-One Model includes two methods to account for a ground lease. The first is to simply include the ground lease payments in the operating expenses (above NOI), thus reducing the value […]
In the unlikely event you’ve visited my LinkedIn page lately or happened upon the REFM Certification Holders, you might have noticed that over the last year I’ve completed my REFM Excel for Real Estate certification. In coming across this obscure fact you might have further wondered – uh, why? I mean, I already have a full-time […]
A series of posts on what commercial real estate professionals do. These posts cover a variety of job functions including acquisitions, development, asset management, consulting, investment banking, advisory, academia, and much more.
This walkthrough, our sixth in the series, takes you through the entire process of underwriting an apartment acquisition opportunity using the All-in-One Model’s new multifamily module. I’ve created hypothetical assumptions for this exercise written out in PDF format (download link below) and then use those assumptions to assess an appropriate purchase price for this opportunity. […]
Michael and I are excited to announce the release of the Adventures in CRE Job Board. This effort is the culmination of almost of a year’s worth of deliberation, planning, design, and networking effort. And while this is only the beginning (we’re calling this phase our “Early Launch”), we’re nonetheless enthusiastic about the potential for this new […]
I think its important to point out that my All-in-One (Ai1) Underwriting Model for Real Estate Development and Acquisition is not a surefire replacement for your non-Excel valuation/underwriting solutions. In fact, it’s likely you (or your employer) chose to use another tool in large part because of the limitations of Excel. And Excel certainly has its […]
This walkthrough, our fifth in the series, explains how the Residual Land Value Calculation module works and how to implement this tool into your analysis. You might recall, a few months back we discussed the concept of residual land value and shared a basic residual land value model. This module expands on the concepts discussed in that […]
This walkthrough, our fourth in the series, explains how the Rate Matrix module works and how to implement this tool into your analysis. The rate matrix concept is new to this site, and not commonly used in the industry. Nonetheless, given that the All-in-One strives to one day become a template model for use by organizations, […]