# Finding the Missing Pieces in Seller-Financed Notes

by on February 2, 2011

It was a typical phone call, “I understand you purchase land contracts notes?” I replied, “Absolutely! What can you tell me about the terms of the note?” The response I got was one I was well prepared for, and you should be too. “Well, the note is for 10 years, with a \$25,000 balance, payments are \$403.34 a month”. I didn’t have to ask what the interest rate is because I know how to calculate it….. 15%.  Learning how to calculate missing information can give you a leg up on everyone else when it comes to buying notes.  I created an easy to use Excel spreadsheet here that you can use to calculate missing values of a note.

Using the Excel spreadsheet or not, remember the four components that are key to determining what the note is worth. These four components are also your starting point for determining how much you can pay for the note.

Number of Payments (N): Tells you how many payments in the note you can expect to receive based on the other variables provided. If expressed in years, you must multiply by 12.

Interest Rate (I): Gives the effective interest rate on the note. One thing to remember when calculating interest rates, always divide the interest rate by 12. (For each month of the year)

Payment (PMT): Identifies the current monthly payment you can expect to receive of principle and interest over the life of the note.

Present Value (PV): The present value of the note based on a series of future payments.

Once you know these four components, you can start analysis to determine how much you can afford to pay when purchasing the note. You can also determine what your rate of return will be. Next week, we will use this framework to calculate how much we can pay for the note based on the four components and our own expected rate of return.

Photo Credit: Horia Varlan

New to Real Estate Investing?
This free eBook from BiggerPockets.com will give you the steps needed to begin your investing career! (BiggerPockets Members can access this through the BiggerPockets FilePlace!)

Craig Grella February 2, 2011 at 9:23 am

Great article and easy to use spreadsheet.
We’ve used partial purchases to get some of our investors their money back quick for new deals that offer higher interest rates. That would be a great follow up article for note investors who haven’t ventured into partials or assignments yet.

Emmanuel Soarez February 2, 2011 at 1:37 pm

This spreadsheet is a godsend to people like me. Math isn’t exactly my strong suite. I really could use some more easy methods such as these for calculating expenses.

Kevin Kaczmarek February 2, 2011 at 3:39 pm

Thanks Craig and Emmanuel!

@Craig. I will definitely do a topic on partials. Partials are probably my single favorite ways to work with notes.

@Emmanuel, email me and lets talk. I will see what I can do to help.

Arnold February 2, 2011 at 8:33 pm

Great simple article with a great spreadsheet! Bravo! Thanks for the contribution, Kevin!