Updated almost 6 years ago on . Most recent reply
Excel formula for max offer based off of fixed cashflow
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