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 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