Real Estate Investing Basics

Finding the Missing Pieces in Seller-Financed Notes

Expertise:
54 Articles Written

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.

Want more articles like this?

Create an account today to get BiggerPocket's best blog articles delivered to your inbox

Sign up for free

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

    Craig Grella
    Replied almost 9 years ago
    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
    Replied almost 9 years ago
    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
    Replied almost 9 years ago
    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
    Replied almost 9 years ago
    Great simple article with a great spreadsheet! Bravo! Thanks for the contribution, Kevin!
    Arnold
    Replied almost 9 years ago
    Great simple article with a great spreadsheet! Bravo! Thanks for the contribution, Kevin!
    MH
    Replied almost 9 years ago
    great post! thanks for taking something so daunting and simplifying the heck out of it. 🙂