Rental Property Cash Flow Calculator Spreadsheet, Cap Rate, Cash on Cash Return, DSCR, Rental Analysis Excel
Enter price, financing, rent and costs to get the mortgage payment, NOI, monthly cash flow, cap rate, cash-on-cash return and debt coverage. A rent scenario table shows cash flow if rent moves 5 or 10 percent.
Works in Excel and Google Sheets. No macros, no external links. Yellow cells are inputs, blue cells are formulas. Tabs: Start Here, Analyzer, Rent Scenarios.
If the file does not work as described and we cannot fix it within 3 days, we refund the order.