Maximum Purchase Price Calculator Based on Cashflow

[Sam Tato]

I'm not sure if this exists somewhere already but I couldn't find anything in the FilePlace. This is my Maximum Purchase Price Calculator for buy and holds. Basically it looks at your desired Cashflow and determines what is left for your mortgage payment. Once you put in an interest rate it will calculate the Present Value which will give you your MPP. I created this because I've heard many people say that one of their minimum requirements is a certain amount of Cashflow per unit (say $100) at 100% financing. This calculator will allow you to quickly see your MPP based on your minimum Cashflow requirements.

There are some limitations. For one, it only allows you to put in one loan... But I hope some of you can give suggestions on how to expand and improve the spreadsheet.

Hope you guys find this useful!

MPP Calculator Based on Cashflow