Version Notes: All-in-One Underwriting Model
Version notes for the All-in-One Underwriting Model for Real Estate Development and Acquisition are found here as well as in the ‘Version’ tab of the Excel model.
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
Frequently Asked Questions about the All-in-One Underwriting Model – Version 0.3.1
What is the purpose of the All-in-One Underwriting Model?
The model is designed for underwriting both real estate development and acquisition scenarios. It includes functionality for analyzing project budgets, timing, income, and return metrics in a single Excel-based tool.
What changes were made in version 0.3.1 of the model?
Version 0.3.1 introduced multiple updates, including:
Addition of a version notes section
Miscellaneous formatting fixes
A link to model documentation
Data validation on the construction length input (Budget tab)
Label change from “Construction” to “Development” on the Summary tab
Auto-linking of the development start date to the analysis start date
A fix for 1st generation lease income not calculating correctly in development mode
Addition of “Development Yield” to return metrics
Where can I find the version notes in the model file?
The version notes are included directly in the Excel model under the ‘Version’ tab as well as published online alongside the download page.
What is the purpose of the “Development Yield” metric?
The Development Yield is a return metric added in version 0.3.1. It helps evaluate the profitability of a development project by comparing income to total development costs.
What issue was fixed with lease income in this version?
Version 0.3.1 corrected an error where 1st generation lease income was not calculating correctly when the model was in development mode.
How does the model handle construction timing now?
The model now includes data validation on the construction length input in the Budget tab to ensure valid entries, and the Development start date in the Summary tab is automatically set equal to the Analysis start date.
