Real Estate Deal Analysis & Advice
Market News & Data
General Info
Real Estate Strategies

Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal


Real Estate Classifieds
Reviews & Feedback
Updated over 11 years ago on . Most recent reply

Can someone help me to analyse this Note?
A seller finance note:
Property buying price: 315k;
Down:100k;
Financed amount:215k;
Term:15 yrs;
Terms remaining 14 yrs and 5 months; (174 payments)
Interest Rate:5.75%
Monthly payment: $1748
Note asking price 200k
The property buyer ofc can pay off the equity any time.
BTW, I can finance at 45k down at 4.75% rate on a 20 yr term
Most Popular Reply

Brian Stone this isn't really a percentages issue. Determining the value is the same calculation as for a mortgage payment. There are four variables involved: The loan amount, or, more formally, the "present value", the interest rate, the term (number of payments) and the payment amount. Often you know the first three and can calculate the fourth. But knowing any three, you can calculate the fourth. In determing the value of the note, all I did was use the payment and number of payments provided by Richard Lee and what I would consider a possible rate (10%). From those three, I can compute the "present value" of the note, $159.847.52. Using the correct value of the payment, $1784.23 by my calculations, I get a PV of $163,160.60. You can do these calculations in Excel (PMT (payment), PV (present value), RATE (interest rate) and NPER (term)). The related FV (future value) will let you compute the loan balance of a loan at some point in the future. For instance, after 7 payment. I get an actual loan balance on this loan of $209,632.77. You can usually do these calculations on a financial calculator, but Excel is much easier.