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

Follow Us

© 2021 RealEstateSpreadsheets.com – All rights reserved.