Rental Property Analysis Spreadsheet
Changelog
Check out what’s new with our spreadsheet
This is the Rental Property Analysis Spreadsheet changelog. If you are looking for the House Flipping Spreadsheet changelog, you can find it here.
Version 2.0.0
New:
- New Dashboard design with lighter features
- Added custom Property Growth Rate – You can now customize the growth rate of your property’s value year by year
- Added custom Fixed Expenses Increase – You can now adjust the rate of increase of each of your operating expenses, year by year
- Added custom Variable Expenses – You can now adjust each of your variable expenses year by year
- Added custom capex assumptions in multi-units tab (Pro Version only)
- Added custom Other Income – You can now apply a custom annual growth rate for your Other Income
- Added ability to resize columns as desired for key tabs of the spreadsheet
- Added new line of cumulative Levered Cash Flow (total) in the Forecasts tab
Fixed:
- Updated links to our documentation throughout the spreadsheet
- Other minor fixes & typo corrections
Improvement:
- Optimized VBA & macros
Version 1.5.1
New:
- Unit Data Tab – Added feature to customize rental income growth rate per year and unit type
Fixed:
- Improved Dashboard
- Corrected formulas in Multi-Units Tab
- Other minor fixes & typo corrections
Version 1.5.0
New:
- New Pro Version – Includes advanced tools and features to review large multi-family properties & buildings
- Multi-Units Tab – Added new tab for detailed operating assumptions for an unlimited number of units and up to 10 unit types
- Unit Data Tab – Added detailed forecasts per unit type
- Unit Tab – Added a Multi-Unit report with portfolio overview and per-unit details
- Refinancing Feature – Added feature to refinance property mortgage during the life of the project
- Dashboard – Added a selector to choose between Advanced Module and Simple Module
Improvement:
- Improved Max Purchase Price Analysis Tool
- Other minor fixes & typo corrections
Version 1.4.0
New:
- Forecasts Tab – Added 4 custom lines for custom operating and non-operating expenses
- Mortgage Tab – Added a detailed monthly mortgage schedule with prepayment option
- Amortization Tab – Added a loan amortization schedule as a new report
- Read Me Tab – Added a read me tab providing information about the spreadsheet’s structure
Improvement:
- Added a “Remove Logo” button on all reports
- Improved Scenario Analysis tool
- Improved spreadsheet compatibility with previous versions of Excel
- Adjusted formulas for variable expenses in Forecasts Tab
- Added % GSI column in the Forecasts Tab
- Added Information Boxes throughout the spreadsheet
Version 1.3.0
Improvement:
- Redesigned Top Menu
New:
- Report Tabs – Added a button to add your own logo to the reports
- Custom Tab – Added an empty unlocked custom tab to customize the spreadsheet
Fixed:
- Fixed formula of our Sale Date Optimization Tool
- Other minor fixes & typo corrections
Version 1.2.0
New:
- Scenarios Tab – Added a Scenarios Tab to quickly run acquisition scenarios
- Max Price Tab – Added a Max Price Tab to easily estimate how much you can offer for a property
Fixed:
- Other minor fixes & typo corrections
Version 1.0.0
- Release of the Rental Property Analysis Spreadsheet
