I am beginning the search for my first rental property and I recently became a premium member to utilize the functionality of the Rental Property Calculator, but want to be sure I can speak to the math behind the numbers. I have attempted to replicate the calculator in Excel so that I understand where the inputs are driving the outputs. I have managed to replicate the calculator for most of the outputs, however, there is variance between the Profit and Annualized Return results from the BP Calculator and my own spreadsheet. Can anyone help me discern where my calculation is off?
Excel Workbook: See Worksheet 'Output Reference' Rows 66-67
BP Calculator: See Page 2"Total Profit if Sold" and "Annualized Total Return"