I recently received an email from one of our readers asking how to create a dynamic revenue row for a pro forma that can capture rent changes for multiple tenants. I thought that this would make a great post for the site and would be a good piece of information to share with our readers. What […]
Excited to share the new A.CRE Hotel Development Model with everyone. As evidenced by the numerous requests we have gotten for this over the years, this model is long overdue so I’m quite happy to get it out there finally. At the core, the hotel development model is basically a hybrid of our Hotel Acquisition […]
I am excited to introduce our new Hotel Valuation (Acquisition) Model to underwrite both stabilized and value-add hotel opportunities. This hotel pro forma is designed to allow users to do everything from a quick back of the envelope exercise to a fulsome and detailed underwriting exercise in which the user can get into the weeds […]
In this post and corresponding video, I am going to walk you through a revamped tenant health worksheet that I shared a long time ago on the site. I spent some time giving it a makeover and decided to put together a video walkthrough for it. Publicly Traded Tenant Analysis Valuable Insights At Your Fingertips […]
One of the many challenges of both analyzing real estate development deals and managing development projects is understanding and tracking the numerous differing but intertwining work streams. The more a development team takes the time to understand and map out the processes, the better chance there is of the project being successful. It is with that […]
Here is a simple, yet very powerful, 4-tier equity multiple waterfall module. This post contains both a completed version of the module ready to plug into a real estate financial model as well as a ‘Watch Me Build’ template and companion video where I walk the user step by step through building it out. EM […]
Working a lot with development draw schedules, I have always been looking for a catch all solution as to how one could easily model all the unique ways cash actually flows over time during the process. The norm for many is to model cash flows using a straight line method with even payments over time, […]
When lenders provide debt for a development project, they lend based on a Loan-to-Cost ratio (LTC), which is simply the percent of the total budget the lender will agree to lend to the borrower. So, if a project costs $10MM, and a lender loans $6MM, the lender is lending at a 60% LTC. However, the […]
A 1031 Exchange, or Like-kind Exchange, is a strategy in which a real estate investor can defer both capital gains tax and depreciation recapture tax upon the sale of a property and use that money, which has not been taxed, to purchase a like-kind property. THE ADVANTAGES OF THE 1031 EXCHANGE Using a 1031 Exchange […]
With all the continued and growing interest in single family rentals these past few years, I decided to spend some time these past few days diving into building a single family rental proforma. Prior to getting underway, and what we encourage all of you to do, is I poked around on our website as I […]
After posting the construction draw module that demonstrates how to calculate the true LTC of a development loan, I decided that since we have yet to publish a condo development model, to build upon that module to create one. This condominium model has a lot of really great functionality that will allow the user to get a […]
I’m excited to share the Pro Forma for Multifamily Renovation model with all of you. This multifamily renovation model is made to analyze value add apartment acquisition opportunities and has a lot of functionality that is meant to provide you an ability to get into the details and go unit by unit for up to […]
Welcome to this episode of the Contract to Close series! This episode features Josh Roling, a real estate attorney and an expert in all things commercial real estate acquisitions. Josh is a close friend and colleague of mine with whom I’ve done 48 deals! In this episode, I speak to Josh about title insurance. It’s […]
The internal rate of return is one of the most commonly used return metrics to analyze real estate investment opportunities. Simply put, the IRR is the anticipated, project-determined discount rate an investor is expected to earn over the life of the investment if the investment performs as projected. An example of how it works is […]
In this post, I’d like to share a method that, with a little practice, will enable you to quickly do cap rate math in your head; whether it’s quickly figuring out what the sale or purchase price would be of a property based on the NOI and cap rate or, inversely, figuring out what the […]