Excel formula for max offer based off of fixed cashflow

[Adam Wigdorski]

For the life of me I cant figure out how to write the formula. I have a simple spreadsheet I use to do a quick analysis of any long term hold Anyone know how to write a formula that will tell me based on a fixed cash flow number what me max offer would be? ie max offer for a fixed monthly cash flow of 1000 . I have all the other variables to where I input a purchase price and it tells me the cash flow. but I cant figure how to work it backwards because of the pvt function