Skip to content
×
Try PRO Free Today!
BiggerPockets Pro offers you a comprehensive suite of tools and resources
Market and Deal Finder Tools
Deal Analysis Calculators
Property Management Software
Exclusive discounts to Home Depot, RentRedi, and more
$0
7 days free
$828/yr or $69/mo when billed monthly.
$390/yr or $32.5/mo when billed annually.
7 days free. Cancel anytime.
Already a Pro Member? Sign in here

Join Over 3 Million Real Estate Investors

Create a free BiggerPockets account to comment, participate, and connect with over 3 million real estate investors.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
The community here is like my own little personal real estate army that I can depend upon to help me through ANY problems I come across.
Tax Liens & Mortgage Notes
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

Updated almost 7 years ago on . Most recent reply

User Stats

40
Posts
6
Votes
David Hite
  • Commerce City, CO
6
Votes |
40
Posts

Estimated Payments Remaining

David Hite
  • Commerce City, CO
Posted

Good morning everyone!

  I am reviewing my potential first note purchase, and there is an equation I want some input on.  

  In determining how many payments are left, many tapes will have a note maturity date.  There are two types of equations I can run in Excel to estimate the number of payments left on the note.  Both will run from Today's Date until the maturity date and show us the number of months in between.   One will round up, and the other will round down.

  Which one do you use to help understand total number of remaining payments?  I would assume that using the rounding down would be the most effective in predicting returns.  Because its better to underestimate number of payments remaining by one than overestimating by 1.  As well the final payment may only be a portion of the normal payment amount (since last payment on an amort schedule is always smaller/different).

Any info/input on this?

Thank you!

David Hite

Most Popular Reply

User Stats

17,764
Posts
15,292
Votes
Chris Seveney
  • Investor
  • Virginia
15,292
Votes |
17,764
Posts
Chris Seveney
  • Investor
  • Virginia
ModeratorReplied

David Hite do not go off of the origination date or due date if it is non performing - that is useless.

Use the NPER formula in excel. Make sure to divide the interest rate by 12 and the UPB should be negative

  • Chris Seveney
business profile image
7e investments
5.0 stars
16 Reviews

Loading replies...