How to Find the Max Offer Price for a Rental Property in Excel or Google Sheets (Cash Flow, Cash-on-Cash, DSCR, Tested)

Instead of testing prices one at a time, solve for the highest purchase price that still meets your minimum monthly cash flow, cash-on-cash return and DSCR, see which target binds, and check the deal at that price. Exact formulas, tested in LibreOffi