Skip to content
×
PRO
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
$0
TODAY
$69.00/month when billed monthly.
$32.50/month when billed annually.
7 day free trial. 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 3 years ago, 10/15/2021

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...