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