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.
Private Lending & Conventional Mortgage Advice
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 about 5 years ago on . Most recent reply

User Stats

109
Posts
42
Votes
Julian Sanchez
  • Rental Property Investor
  • Aventura, FL
42
Votes |
109
Posts

Lender Amortization misunderstanding

Julian Sanchez
  • Rental Property Investor
  • Aventura, FL
Posted

Good evening BP, 30 year amortization on a refinance on a 825k loan, lender parent company large REIT

Interest locked based on the swap rate

10 Yr Swap Rate 1.57%
Credit Spread 3.81%
Interest Rate 5.38%

Here is the issue 

Every Amortization schedule out there puts out a $4,622.33 monthly payment. 

The lender is telling us that the payment is gonna be  $4,660. 
We went as far as getting the amortization equation and manually plug in the numbers,

In any case their response is:

You are calculating payment using a 365 calculation.

=PMT(5.38%/12,360,-825000) = $4,622 payment (excel defaults to a 365 calculation)

=PMT(5.38%/12(365/360),360,-825000) = $4,660 payment (this is how we calculate payment)

From the amortization formula the underlined part of the equation should not be there, but they insist that's the payment and any online amortization schedule is incorrect

Anybody come across a situation like this?

Loading replies...