, , , , , , , , , , , ,

All-in-One (Ai1) Underwriting Model for Real Estate Development and Acquisition (Updated 8.12.17)

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 Tool for Real Estate Development and Acquisition in Excel (catchy name, I know!).

Since that release, I’ve continued to update the model almost weekly, correcting errors and adding features you, the user, are asking for. The model has been downloaded thousands of times and dozens of you are actively contributing to continuous and substantive improvements. As I find time and as your suggestions come in, I’ll continue to update the model with the hope that it one day, it might have its permanent place in commercial real estate underwriting.

Download the Model | Guide to Getting Started | Video Intro | Version Notes | Support Forum

Read about the limitations of Excel compared to the non-Excel based alternatives.

Get Notified When We Publish New Content

So, What’s in the Model?

Download the Model | Guide to Getting Started | Video Intro | Version Notes | Support Forum

With all the talk about limitations in Excel, you’d think I’m setting you up for just another back-of-the-envelope acquisition model. But fear not. This is like no model I’ve built before. I set out to build a model that does it all and right now, its pretty dang close! Acquisition, value-add/redevelopment, ground-up development, industrial, office, retail, apartment, student housing, seniors housing, various partnership structures, advanced underwriting modules, tabs that automatically hide/unhide depending on the selections you make, and the list goes on.

Plus I’ll be adding additional modules as I find time (contribute your ideas in the model’s support forum). For example I recently added a robust multifamily module capable of modeling apartment, student housing, and seniors housing deals. In the future will added functionality for mixed-use valuations of any combination of retail, office, industrial, and multifamily uses that you could think of. I also plan to continue to add property-specific analysis sections for each property type using modules we’ve shared on A.CRE.

So let’s have a look at what is included in the model. First, download the model and open it up alongside your browser. Then, read through the ‘Getting Started‘ sections below to get a basic understanding of how the model works. Finally watch the ‘Video Introduction‘ at the end of this post. I’ll be following this post up with model updates and additional training videos and posts.

Friendly Request: If you find errors, have suggestions for how I can improve this model, or have a question about the model, please drop me a note in the All-in-One’s Support Forum and I’ll get back to you as soon as possible.

Download The Model

To make this model accessible to everyone, it is offered on a "Pay What You're Able" basis with no minimum (enter $0 if you'd like) or maximum (your support helps keep the content coming - typical real estate models sell for $100 - $300 each). Just enter a price together with an email address to send the download link to, and then click 'Continue'. If you have any questions about our "Pay What You're Able" program or why we offer our models on this basis, please reach out to either Mike or Spencer.

Note (especially for Gmail users): The model is sent via email and occasionally is blocked by spam filters. If you don't see the email arrive within five minutes, check your spam folder.

We’re regularly updating the model (see version notes). Paid contributors to the model receive a new download link via email each time the model is updated.

A.CRE All-In-One (Ai1) Underwriting Model (Beta version v0.5.2)

  • The most comprehensive real estate Excel model on www.AdventuresinCRE.com
  • Model acquisition, value-add, redevelopment, or development scenarios
  • Currently built for office, retail, industrial, apartment, student housing, and seniors housing property types
  • Partnership return module with three-tier waterfall using either IRR or equity multiple hurdles; plus double promote module
  • Robust development module with detailed cash flow forecasting using linear, s-curve, or manual input
 
   
By clicking Continue, I agree to the following Terms & Conditions.
This Excel file (the "software") is distributed as is, completely without warranty or service support. www.AdventuresinCRE.com and its authors are not liable for the condition or performance of the software.
www.AdventuresinCRE.com owns the copyright and grants users a perpetual, irrevocable, worldwide, non-exclusive, royalty-free license with respect to the software as set forth below.

www.AdventuresinCRE.com and its authors hereby disclaim all implied warranties. www.AdventuresinCRE.com grants the users the right to modify, copy, and redistribute the software and documentation, both within the user's organization and externally, subject to the following restrictions:

1. The users agree not to charge others for use of the software, regardless of whether users have altered and/or improved the software in anyway
2. In any use of the software, the users agree to acknowledge the www.AdventuresinCRE.com authors that developed the software.
3. The users agree to obey all government restrictions governing redistribution or export of the software.
4. The users agree to reproduce any copyright notice which appears on the software and documentation on any copy or modification of such made available to others.

Guide to Getting Started

Download the Model | Guide to Getting Started | Video Intro | Version Notes | Support Forum

Excel Version Compatibility

  • Excel 2016 for PC (Compatible)
  • Excel 2013 for PC (Compatible)
  • Excel 2010 for PC (?)
  • Excel 2007 for PC (Incompatible)
  • Excel for MAC (?)

Summary Tab

*Quick tip: as always the blue font cells are input cells while all others are output cells. However, orange font cells are also used here which are optional input cells with default formulas*

When you open the model, you’ll begin at the ‘Summary’ page. In this tab, you’ll drop in the physical attributes of the property, choose whether to use or not use various modules, enter the project timing and analysis period, and input your valuation assumptions. The summary tab reports a few key risk and return metrics including annual rollover, debt coverage, debt yield, internal rate of return, equity multiple, average cash-on-cash return, among others. The summary page also includes a basic sources and uses table.

To see the rest of the tabs in the model, you’ll need to turn on every module. To do this, in the Summary tab first go to the ‘Include Modules?’ section and set Permanent Financing Module to ‘Yes’. Next, move to the ‘Navigation’ module and set each to ‘Show’. Finally, make the Construction Length under Timing greater than 0 months to turn on the development tab.

Beta version 0.3 includes a Retail Analysis module that can be seen by changing the property type to ‘Retail.’ In subsequent versions, I’ll be adding additional property-type specific modules that will hide/unhide those tabs depending on which property type you select.

In beta version 0.3.3 I added a Residual Land Value module, which can be turned on under the Include Modules? section. This module is only available if the investment is a development/redevelopment project (e.g. Development Length in cell M13 of the Summary tab is greater than 0). To learn more about this module, read and watch the Residual Land Value Calculation Module Walkthrough.

In beta version 0.3.4 I added a ‘Rate Matrix’ concept to determine the base cap rate and base discount rate used for valuation purposes. You can learn more about this module by reading and watching the Rate Matrix Module walkthrough.

Beta version 0.4.0 includes the newly released Multifamily module (apartment, student housing, seniors housing). Toggle on or off the multifamily module in the Include Modules? section by setting the ORI (Office/Retail/Industrial) Module on or off. When the ORI Module is on, the MF Module by default is off and vice versa. Both modules can not be on at the same time.

In beta version 0.4.3, I added a Ground Lease Valuation module. This module gives the user the option to place the ground lease payments below NOI, and reduce the stabilized and residual value of the investment by the present value of the ground lease.

Beta version 0.5.0 adds additional functionality for modeling Student Housing and Seniors Housing investments. No changes were made to the base methodology of the model in modeling these property types, however nomenclature specific to these property types and labels were updated. Also, in the case of Student Housing, ‘Units’ are changed to ‘Beds’ to reflect that leases/rents are per bed, not per unit with this property type.

Beta version 0.5.2 adds a Tenancy Analysis Report for office, retail, and industrial underwriting. The report uses a fully dynamic column chart, an auto-updating PivotTable, and various other sections to help the user analyze the strengths and weaknesses of the rent roll.

Perm. Debt tab (see Permanent Debt walkthrough)

Model up to two tiers of debt.

With the ‘Permanent Financing Module’ toggle on the Summary tab set to ‘Yes’, the Perm. Debt tab will be visible. In this tab, you’ll add assumptions for up to two tiers of permanent debt. If the Summary tab includes a construction period (Summary!M10>0 months), then the permanent debt will fund in the stabilization month (Summary!K14) and the construction debt module will be activated. Otherwise, permanent debt will fund in time 0 of the analysis.

All inputs for this tab are entered in column E of the Perm. Debt tab. Assumptions include loan amount, loan fees, fixed interest rate (if variable, enter the average expected rate over the term), amortization period in months, and the number of months the payment is interest-only. Upon entering the inputs, you can see the loan-to-value of both the senior piece (cell D11) and the combined senior plus secondary debt (cell D22) pieces.

In addition to loan-to-value, other outputs on this tab include a detailed amortization schedule for both the senior and secondary loans, loan-to-cost for the senior and the combined loans, amortization and interest-only monthly payments, loan payoff at maturity, among others.

Reports and Analysis Tabs

The number of Report and Analysis tabs will continue to grow as I find time to add more.

As of beta version 0.3, the model includes two report tabs (Equity CF and Property CF) plus one retail analysis tab (tenant rollover, retail sales, occupancy cost, % of NRA, etc). I fully expect to continue to add analysis tabs as I find time and per your suggestions.

The Equity CF tab includes a few minor inputs related to the partnership structure and promote. It is here that you’ll spell out the equity contribution percentage between the sponsor group and the investor group or limited partner(s). Use cell D7 to change between IRR and equity multiple hurdles and cells D18:F20 to detail out the promote. This tab is an adaptation of my equity waterfall model. The Equity CF tab models the waterfall both on an annual basis as well as on a monthly basis.

The Property CF tab includes two basic inputs: whether to cap net operating income or cash flow from operations in determining the residual (terminal) value and the selling costs percentage. Otherwise, the Property CF tab is purely to report the projected annual and monthly cash flow of the investment. The annual cash flow is shown at the top. The monthly cash flow is below the annual cash flow and is defaulted as hidden. To reveal the monthly cash flow, click the + sign located left of row 88.

The optional Sponsor CF tab (activate on the Summary tab under ‘Include Modules?’) allows the user to model a second waterfall (double promote) for situations where the real estate investor raises both LP equity and sponsor equity. In this scenario, the LP would promote the sponsor, and then the equity investors in the sponsor would promote the GP for hitting certain IRR or equity multiple hurdles. Assumptions on the Sponsor CF tab are similar to that of the Equity CF tab. The Sponsor CF tab models the 2nd waterfall both on an annual basis as well as on a monthly basis.

Other report tabs include the Retail Analysis Report and the Tenancy Analysis Report.

Operation Section Tabs (MF-OpSt and ORI-OpSt)

The meat of your underwriting takes place in the Operation Section

Sections are distinguished by their unique color; the first tab in each new section is an empty tab colored slightly darker than its counterparts in the same section and labeled with —> at the end, such as the ‘ORI—>’ tab. The Operation section is the first section after the Reports and Analysis tabs as you move along the tab ribbon from left to right and includes an ORI (Office/Retail/Industrial) section and an MF (Multifamily) section. To reveal the operation section you intend to work with, turn on the Operation Module (either ORI or MF) in cells F29 or F30 of the Summary tab then set cell F36 or F37 to ‘Show’.

The Operation section contains the meat of the underwriting. This section currently is only compatible with industrial, office, retail, and multifamily property types but will be expanded to include other property types such as student housing, senior housing, self-storage, and manufactured housing.

This section includes the ‘ORI-Settings’ and ‘MF-Settings’ tabs where the user can change property type specific settings and nomenclature; the ‘ORI-RR’ and ‘MF-RR’ tabs where the user enters tenant/unit specific inputs; and the ‘ORI-OpSt’ and ‘MF-OpSt’ tabs where the historical operating statements, stabilized pro forma, and residual pro forma are modeled.

The ‘RR’ and the ‘OpSt’ tabs are essential to properly using this model and it is here where you’ll spend the bulk of your time. I’ll follow up this post with videos specific to properly completing these tabs, as there’s not time to go too deep into specifics here. Check out tutorials and walkthroughs of the model.

One wrinkle introduced on the ‘OpSt’ tabs is the orange font cell. These are cells that have default calculations but require the user to review the calculation and adjust the cell accordingly. For instance, cell I7 of the ‘ORI-OpSt’ outputs the”Stabilized Year” and then is used by the model to calculate the stabilized value. There may be instances when you’ll want to change the stabilized year to some other value, in which case you’d manually change cell I7 (an orange font cell) to the year of your choosing.

Development Section Tabs

The Development Section immediately follows the Operation section as you move along the tab ribbon from left to right. To turn this section/module on, be sure the Construction Length cell on the summary tab (Summary!M10) is greater than zero. This development section includes a Sources and Uses tab, a Budget tab, and a Gantt chart tab. Only the Sources and Uses and Budget tabs have inputs, with the majority of the inputs coming on the Budget tab.

The development section is a variation of my Construction Draw and Interest Calculation Model. In building that model, I recorded a video tutorial that is likewise relevant here:

Tip: If the development module is turned on, no ‘Acquisition Price’ is set and therefore the sum of the items in the ‘Budget’ tab will be the total cost of acquiring the investment. So, if your project is a value-add investment, you will need to include the cost of purchasing the property in the budget tab plus include the cost of renovation and lease-up. Also note, that the construction loan assumes an interest-only loan through to stabilization after which the parameters set in the Perm. Debt tab are used.

Calculation Tabs

Grey colored tabs are calculation tabs, and are hidden by default unless set to show (cell F35 in the Summary tab). It is in these tabs that the more complex calculations are undertaken. Especially of note is the ‘O-Calc’ tab. It is here that lease cash flows are computed such as future leasing assumptions, expense reimbursement, rollover and leasing costs, contractual and market rent increases, etc.

If you’re to truly become proficient at using this model for your own purposes, I’d suggest digging into each of the calculation tabs to better understand the methodology behind the model.

Video Introduction

Download the Model | Guide to Getting Started | Video Intro | Version Notes | Support Forum

As a companion to the above ‘Getting Started’, I thought I’d record a video introduction of the model. This will stand as the first in a coming series of instructional videos on how-to use the All-in-One Underwriting Model.

Note that this video introduction is based off of an earlier version of the model – many changes have since been made. I’ll get an updated video up in the near future.

Provide Feedback, Get Your Questions Answered

We’ve launched a tool exclusively dedicated to answering questions and taking requests related to this model. Rather than doing so one-on-one via email, we felt it would better serve the entire A.CRE community if questions and requests related to this model were handled for all to read and learn from. So if you have a question, request, or comment, please head over to the Support Forum and drop us a line. We’ll work to get back to you as soon as our schedules’ permit.

Check out the Support Forum

About the Author: Born and raised in the Northwest United States, Spencer Burton has over 15 years of real estate investment and development experience. In his current position, Spencer assesses new investments for a $40bn real estate fund. He resides in Dallas, TX.


Version Notes

Download the Model | Guide to Getting Started | Video Intro | Version Notes | Support Forum

Version 0.5.2 (August 12, 2017)

  • O11:U11 on the Summary tab was mislabeled when Development module is on, issue has been fixed
  • Fixed error on ORI-CALC tab, formulas in columns AHF:AMR were modeling one too many renewal income months
  • Added a “Tenancy Analysis” tab with rollover analysis for Office/Retail/Industrial underwriting (Tenancy Analysis Report)
  • Updated the Summary tab worksheet code to auto hide/show the Tenancy Analysis Report
  • Changed font of ORI Module drop-down on Summary tab from blue to orange (from required input to optional input)

Version 0.5.1 (July 29, 2017)

  • Changed font color of monthly ‘Other CapEx’ cash flows on MF-RR tab to denote an optional input
  • Added Capital Expenditure, ‘Other CapEx’, to ORI module and set font for monthly cash flows to orange to denote an optional input
  • Added four ‘Other Land Costs’ lines to the Residual Land Value module to analyze land value exclusive of other land costs
  • Modeled double promote for scenarios with (Sponsor + LP) and (Sponsor with GP + Investors)
  • Misc. formatting and tab placement cleanups
  • Replaced rollover table on Summary tab with NOI and valuation graph; necessary now with MF module
  • Fixed issue where graphs on ‘Sources and Uses’ tab were no longer dynamic to construction length

Version 0.5.0 (July 22, 2017)

  • Linked equity contribution table (Equity CF rows 10-13) to Annual/Monthly toggle on Summary tab cell S27
  • Removed redundant macro running on Sources and Uses tab
  • Removed data validation from budget timing, as it conflicted with add rows macro
  • Created Student Housing and Seniors Housing Module
    • Updated Rate Matrix
    • Added Student Housing and Seniors Housing to property type drop-down on Summary tab
    • Expanded MF-Settings tab to include nomenclature for Student Housing and Seniors Housing
    • Updated labels on MF-RR and MF-OpSt tabs to account for Student Housing tracking ‘Beds’ instead of ‘Units’
    • Added calculation on MF-RR tab H8/F8 (Column AT) for Units vs. Beds for Student Housing
    • Misc. Formatting Updates

Important: The Student Housing and Seniors Housing modules are functional but have not yet been fully tested for errors

Version 0.4.6 (July 14, 2017)

  • Linked labels on Uses graph to labels on Budget tab to make the graphs dynamic
  • Fixed Forecast Method and S-Curve Rate drop-down menus; data validation had broken with recent changes to the Budget tab
  • Added a link on the Version tab to the new support forum for asking questions and making suggestions related to this model

Version 0.4.5 (July 8, 2017)

  • Simplified Gantt chart such that only categories are shown, logic changed to only track categories with budget >0
  • Moved Dev-SCurve Calc from its own tab to Budget tab to accommodate adding addt’l budget items
  • Coded macros to add additional budget line items to Budget tab (to delete, simply delete the item row)
  • Added drop-down menu and ‘Add Item’ button to execute ‘Add Budget Item’ macros
  • Misc. formatting cleanups

Version 0.4.4 (June 24, 2017)

  • Modeled monthly equity waterfall cash flows on Equity CF tab
  • Added toggle to select between Monthly or Annual partnership return calculation (Summary tab cell S27)
  • Removed most uses of ‘$’ (USD) to accommodate non-US based users
  • Made Sources/Uses table labels on Summary tab dynamic to property type (i.e. MF = /Unit, otherwise PSF or /M)
  • Added Quick Start Guide to Summary tab for first-time users
  • Added Rate Matrix Setup toggle to Navigation section of Summary tab
  • Protected Summary tab without password, to unprotect go to Review>Unprotect Sheet
  • Wrote Macro that sizes construction loan amount to LTC input on Sources and Uses tab, eliminating need for Goal Seek
  • Misc. formatting fixes, sorted MSA list by A-Z

Important: The Ground Lease Valuation module is functional but has not yet been fully tested for errors

Version 0.4.3 (June 17, 2017)

  • Added ground lease valuation module
  • Subtracting value of ground lease from reversion value in each month and year
  • Added ground lease payments below NOI; figured into DSCR, DY, CoC, IRR, and EMx calculations
  • Summary tab, changed purchase price input to orange (optional)
  • Summary tab adjacent to purchase price input, added drop-down to set purchase price based on Direct Cap or DCF valuation
  • Added print areas to make model printer-friendly

Important: The Ground Lease Valuation module is functional but has not yet been fully tested for errors

Version 0.4.21 (June 10, 2017) – Minor Update

  • Corrected F12 (NRA) on Summary tab to display multifamily NRA when applicable
  • Fixed data validation error in column P of the MF-RR tab

Version 0.4.2 (June 3, 2017)

  • Fixed error where 2nd generation concessions were not calculating correctly
  • Eliminated Downtime Vacancy / Loss-to-Lease line from ORI-OpSt; downtime vacancy now included in Gross Potential Rent
  • Discount rate assumption now hidden when in Development mode
  • Fixed formatting error; Property Value on Property CF was showing an error in post-analysis end years when analysis period was less than 10 years
  • Formatting change; Removed USD signs from values on Budget tab
  • Corrected error in MF Loss-to-Lease where it was not calculating correctly during lease-up period

Version 0.4.1 (May 29, 2017)

  • Added data validation and an error check to the MF-RR to avoid situation where Units Leased exceeds total units
  • Removed ‘# Tenants’ and ‘Largest Tenant (% of NRA)’ outputs from Summary tab
  • Changed year 1 cap rate on Property CF tab to be equal to stabilized cap rate on Summary tab
  • Fixed error where ORI cash flows were not appearing on ORI-OpSt tab

Version 0.4.0 (May 20, 2017) – Fully functional MF module!

  • Fixed error in how Downtime Vacancy / Loss to Market was calculated on the ORI-OpSt tab
  • Added an “Total Actual Income” section on the ORI-Calc tab to sum Contract/Spec Income and Renewal Income totals
  • Multifamily Module Progress:
    • Changed logic for turning on ORI and MF modules such that if ORI Module = On, then MF Module = Off and vice versa
    • Added MF property-level cash flows to Property CF report tab
    • MF cash flows now flowing through to return tabs (Equity CF, Summary)
    • Multifamily Module is fully functional, although the ORI and MF modules can not be on at the same time

Important: The MF module is functional but has not yet been fully tested for errors

Version 0.3.7 (May 13, 2017)

  • Added MF cap rate and discount rate; Rate Matrix ONLY applicable to Office, Retail, and Industrial property type (for now)
  • Fixed issue where Variable Income/Expenses were not calculating currently in unstabilized periods
  • Multifamily Module Progress:
    • Modeled Loss-to-Lease on MF-Calc tab
    • Modeled untrended Make Ready costs on MF-Calc tab
    • Added Free Rent on 2nd Generation Leases input to allow for stabilized free rent (MF-RR tab)
    • Modeled lease-up free rent and stabilized free rent on MF-Calc tab
    • Modeled stabilized downtime
    • Linked cash flows from MF-Calc to MF-OpSt tab
    • Completed MF-OpSt tab
    • Completed MF Operation Section (MF Property-Level Cash Flows)

Important: The MF module is still under construction. Multifamily property-level cash flows are completed and can be seen in the MF-OpSt tab. However, MF cash flows do not flow up to the model level. This means you will not see MF cash flows reflected on the Summary tab or in the Report tabs.

Version 0.3.6 (April 29, 2017)

  • Corrected error in Sources and Uses table on Summary tab
  • Added conditional formatting where, if only one partner exists, Equity CF and Partnership Returns sections are turned off
  • Dev. calc tabs no longer appear when Calculation Tabs are set to “Show” unless development module is on
  • Multifamily Module Progress:
    • Completed MF-RR
    • Modeled market rent on MF-Calc tab
    • Modeled lease-up (“Units Occupied”) on MF-Calc tab
    • Modeled Actual Rent per Unit and Actual Rent om MF-Calc tab

Important: The MF module is still under construction. No multifamily calculations are made in this version.

Version 0.3.5 (April 15, 2017)

  • Added fallback cap rate and discount rate in the event Rate Matrix is not properly modeled/setup
  • Fixed a minor calculation error in row 20 of the Dev-Interest Calc tab
  • Improved Rate Matrix table to allow adding and deleting locations and property types
  • Added MF—>, MF-Settings, MF-RR, and MF-OpSt tabs to facilitate the creation of the Multifamily module
  • Added MF Module and MF tabs lines to ‘Include Modules?’ and ‘Navigation’ sections of Summary tab
  • Renamed Operation tabs to ORI (Office/Retail/Industrial) so as to be used for office, retail and industrial properties only
  • Began modeling MF calculations

Important: The MF module is still under construction. No multifamily calculations are made in this version.

Version 0.3.4 (April 8, 2017)

  • Added functionality to make Other Income and Operating Expenses variable to occupancy; see column I on O-OpSt tab
  • Added MSA input on Summary tab for use in developing cap rate and discount rate matrix
  • Added Rate Matrix tab, linked property type, MSA, Base Cap Rate, Base Discount Rate to Rate Matrix tab
  • Important: the rates used in the template ARE NOT accurate; set your own rate assumptions on the ‘Rate Matrix’ tab

Version 0.3.3 (April 1, 2017)

  • Changed label for 1st generation leasing costs from ‘Leasing Assumption’ to ‘Unpaid Leasing Cost (1st Gen. Lease)’
    Corrected Analysis Period heading
    Added residual land value analysis (see Summary tab) – only available in development mode

Version 0.3.2 (March 25 2017)

  • Changed monthly header date function on S-Curve Calc tab from EDATE() to EOMONTH()
  • Set Development Budget Start Date (Budget tab) to Analysis Start Date
  • Fixed error in development module where residual value wasn’t calculating correctly
  • Converted residual pro forma on O-OpSt tab to blue font (input cells), default equal to residual year
  • Revised timing section, added residual year, changed analysis period assumption from months to years
  • Extended calculation out to 11 years to allow for year 11 residual calculation
  • Added multi-year market rent growth assumption (see Future Leasing Section of O-RR tab for input)
  • Added development yield/returns section to summary tab (cells O22:U23)
  • Fixed issue where cap rate inputs on Summary tab weren’t available in development module

Version 0.3.12 (March 17, 2017)

  • Fixed an error where 1st generation detailed rent wasn’t calculating correctly in last year of lease
  • Removed drop-down menu in cell Summary!F30
  • Changed the return of capital “Error” message on the Equity CF to “Insufficient Cash Flow”

Version 0.3.1 (March 11, 2017)

  • Added version notes section
  • Misc. formatting fixes
  • Added link to model documentation online
  • Added data validation to construction length on Budget tab
  • Changed label: Construction to Development in Timing on Summary tab
  • Made Development start date (Summary M11) equal to Analysis start date
  • Fixed error where 1st generation lease income wasn’t calculating correctly in development mode
  • Added Development Yield to return metrics

Download the Model | Guide to Getting Started | Video Intro | Version Notes | Support Forum