The video below and corresponding downloadable templates will walk you through how to build a basic construction draw schedule. Basic Construction Financing & Draw schedules: A Conceptual Overview A standard draw schedule with a basic capital stack of debt and equity works as follows: The development budget is created and projected out over the anticipated […]
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, […]
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 […]
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 […]
At the bottom of this post is a downloadable practice tool for the A.CRE Method for doing cap rate mental math. The tool will generate an endless number of random cap rates and NOIs to practice with and will walk you step by step through how to solve for each scenario you are working in. […]
The Discounted Cash Flow Method is a method to value a project by taking all future projected cash flows of the project and discounting them back to time zero (date of purchase) using a predetermined discount rate (the discount rate when used in a DCF to look at an investment can be looked at as […]
After receiving a few requests, I’ve finally gotten around to adding an equity waterfall module to the Condominium Development Model. This module allows you to model partnership splits up to three tiers using either equity multiple hurdles or IRR hurdles. Additionally, you can model for a preferred return for the limited partner where either (1) […]
In the third part of this data table series, I’d like to show you how you can create data tables with multiple return metrics within each cell of the data table as shown in the image below. The way to do this is actually quite simple. If you are unfamiliar with how to create […]
Back when we first started this website, I wrote a post with a downloadable excel file that walks the reader through how to create a one variable data table. This is a long overdue follow up to that post to show you how to create a two-variable data table. This will be part 2 of […]