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 over 6 years ago on . Most recent reply

User Stats

3
Posts
0
Votes
Vince May
  • Sunnyvale, CA
0
Votes |
3
Posts

Note payment amount doesn't match with what I calculated

Vince May
  • Sunnyvale, CA
Posted

Hi,

I'm new to investing in notes and found a note on FCIexchange and was trying to understand why the payment amount differs from what I calculated the monthly payment should be using the PMT equation. Based on the original balance and the monthly APR, I see that the loan was originally a interest only loan that entered it's fixed rate period. However, when I try to calculate the monthly amount based on the UPB at the start of the fixed period, the monthly amount I calculate with the PMT equation is lower than the payment amount based on the pay history.

I thought I was using the wrong number of periods, however when I built the amortization table, I find the end date to be on target with what was reported. Not sure what I'm missing.

Most Popular Reply

User Stats

553
Posts
490
Votes
Mike Hartzog
  • Lender
  • Redmond, WA
490
Votes |
553
Posts
Mike Hartzog
  • Lender
  • Redmond, WA
Replied

First of all, kudos for doing the math!  It's an essential part of DD that gets overlooked frequently by new investors.  Could there be a escrow component of the  payment in there that is skewing things?  Another possibility is that the borrower is making bigger payments for a time to bring the loan current.  

In the pay history you should see how each payment is allocated to principal, interest, escrow, late, etc.  Use just the P&I portion to do your math and see what that changes things.

  • Mike Hartzog
  • Loading replies...