Check out what’s new with our spreadsheets:

Fixed:

  • Corrected bugs for Mac users
  • Adjusted VBA & macros
  • Other minor fixes & typo corrections

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

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

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

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

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

Improvement:

  • Redesigned Top Menu

Fixed:

  • Fixed formula of our Sale Date Optimization Tool
  • Other minor fixes & typo corrections

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
  • Release of the Rental Property Analysis Spreadsheet

New:

  • Added ability to change measuring units (Square Meters and Square Feet)

Fixed:

  • Corrected bug in Vendors tab that prevented from adding more than 20 vendors
  • Tables can now be properly filtered in locked sheets

Improvement:

  • Optimized VBA & Macros
  • Refreshed color scheme & design

New:

  • Addition of multiple line items for each category of the Repair tab

Fixed:

  • Other minor fixes & typo corrections

Improvement:

  • Allow resizing of columns in certain tabs
  • Allow for negative expenses (refunds, rebates, etc.) in the Expenses tab
  • Refont of Schedule Tab
  • Refont of Expense Tracker
  • Refont of Repair Tab

Improvement:

  • Expense Tracker – Added feature to source tracker data from the new expense listing tab
  • Scheduler – Added end dates associated with each task
  • Scheduler – Refreshed task status colors
  • Menu – Redesign of top menu

New:

  • Read Me Tab – Added a new tab describing key features of the spreadsheet
  • Expenses Tab – Added a new tab to list all expenses incurred to date (actuals)
  • Vendors Tab – Added a new tab to list all vendors and third parties associated with the project
  • Actuals Report – Added a new report summarizing total expenses incurred to date by category and sub category
  • Actuals Vendors Report – Added a new report listing all project actuals by vendor
  • Actuals Category Report – Added a new report listing all project actuals by category
  • Custom Tab – Added an unlocked custom tab to enable customization of the spreadsheet 
  • Added White labeling feature (via “Add Logo” button) and ability to add photo to summary report

Fixed:

  • Menu Link – Fixed error message when clicking on certain links of the top menu
  • Other minor fixes & typo corrections

Improvement:

  • Dashboard – Changed calculation of commission in Selling Assumptions
  • Other minor fixes & typo corrections
  • Improved compatibility with previous versions of Excel
  • Release of the House Flipping Spreadsheet