Tax Liens & Mortgage Notes
Market News & Data
General Info
Real Estate Strategies
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/hospitable-deef083b895516ce26951b0ca48cf8f170861d742d4a4cb6cf5d19396b5eaac6.png)
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/equity_trust-2bcce80d03411a9e99a3cbcf4201c034562e18a3fc6eecd3fd22ecd5350c3aa5.avif)
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/equity_1031_exchange-96bbcda3f8ad2d724c0ac759709c7e295979badd52e428240d6eaad5c8eff385.avif)
Real Estate Classifieds
Reviews & Feedback
Updated almost 7 years ago on . Most recent reply
![David Hite's profile image](https://bpimg.biggerpockets.com/no_overlay/uploads/social_user/user_avatar/966182/1694708513-avatar-davidh582.jpg?twic=v1/output=image/cover=128x128&v=2)
Estimated Payments Remaining
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
![Chris Seveney's profile image](https://bpimg.biggerpockets.com/no_overlay/uploads/social_user/user_avatar/329845/1674401826-avatar-7einvestments.jpg?twic=v1/output=image/crop=4480x4480@0x336/cover=128x128&v=2)
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](https://bpimg.biggerpockets.com/no_overlay/uploads/marketplace/business/profile_image/3856/1731163014-company-avatar.jpg?twic=v1/output=image/contain=65x65)