Skip to content
×
Pro Members Get
Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
ANNUAL Save 16%
$32.50 /mo
$390 billed annualy
MONTHLY
$39 /mo
billed monthly
7 day free trial. Cancel anytime
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 over 3 years ago on . Most recent reply

User Stats

3
Posts
0
Votes
Ann Tavsanli
0
Votes |
3
Posts

amortization schedule question.

Ann Tavsanli
Posted

Hello,

I just got a mortgage and am trying to generate an amortization schedule but have been unable to match the banks first payment information. Does anyone know of a good program or have an excel sheet that will match. I get close but it bugs me that I can't get it to match. This is what info I have from the promissory note:

Principal: $750,000

Beg Date: 09/14/2021

Interest Calculation Method: 365/360 basis

Interest rate: 3.650%

Final Payment due on September 14, 2051

When I plug info into the online amortization schedule, the payment comes out to be $3,453.28, $2,2281.25 (interest), and  $1,172.03(principal)

However the email I have from the bank has the information below:
Summary of Account
Current Balance: $750,000.00
Interest Rate: 3.6500%
YTD Interest Paid: 0
Maturity Date: 9/14/51
Payment Information
Current Principal Due: $1,627.26
Current Interest Due: $1,825.00
TOTAL DUE: $3,452.26
Payment Due Date: 10/14/21


Thanks,

Loading replies...