Private Lending & Conventional Mortgage Advice
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback
Updated almost 5 years ago,
Lender Amortization misunderstanding
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?