I’m reading through the book “Weekend Millionaire’s Secrets to Investing in Real Estate”, and have been plugging some of the formulas (such as NOI, and ROI) into a spreadsheet, so I can show my reluctant DH some numbers (and give him reasons why we NEED to get started in REI), and also just get myself familiar with some of the calculations that are used in REI, so I have a better handle on the math of it.

A calculation that has me stumped is the chart on page 151 in the book, titled “Amounts you can pay off with a $750 mortgage”. In the example given, if you know that the asking price of a property is 90K, you can see, using the chart, that you can pay this price for 15 yrs at 5-6%, over 20 yrs at 7-8%, or over 25 yrs at 8-9%.

So with the formula that I am looking for, I can enter the desired mortgage pmt., the interest rate, and the length of the loan, and the result should be the amount to be mortgaged.

I really am not great at math, so I hope that I’m explaining the formula that I’m looking for well. If you know what I’m talking about, you can either tell me the formula in a way that would work in Excel, or just spell it out for me for use with a calculator.

Hope you can help, and thanks in advance for trying!