Generic Mortgage Loan Calculator


This calculator will create a loan schedule if you give it any loan amount, any rate, any term, any compounding frequency. To match the math that banks use, I am always going UP with partial pennies on calculated interest so that $99.002 becomes $99.01, not $99.00 like I used to calculate when I rounded to the nearest penny. Those extra pennies add up! Here is a prettier PHP version and here is one that writes the output to a PDF file for saving/printing.

Loan Amount

Annual Interest Rate

Payment Each Period ( to let calculate*)

Periods per Year (12 for monthly, 26 for bi-weekly, 52 for weekly, etc.)

Total Number of Payments OR Total Number of Years

 

Your interest rate per period is 0.3125 % for 12 total periods ( 1.0000 years)

PeriodYearsBalanceInterestPrincipal
1 0.08310000.00 31.25 -31.25
2 0.16710031.25 31.35 -31.35
3 0.25010062.60 31.45 -31.45
4 0.33310094.05 31.55 -31.55
5 0.41710125.60 31.65 -31.65
6 0.50010157.25 31.75 -31.75
7 0.58310189.00 31.85 -31.85
8 0.66710220.85 31.95 -31.95
9 0.75010252.80 32.04 -32.04
10 0.83310284.84 32.15 -32.15
11 0.91710316.99 32.25 -32.25
12 1.00010349.24 32.35 -32.35
13 1.08310381.59 32.45 -32.45

Total Payments: $ 0.00
Total Interest $ 414.04


DISCLAIMER: This information is for illustrative purposes only. Numbers may be off by $0.01 per month due to differing methods of rounding so the results are not exact. Also note that the schedule generated here applies only to a loan where all payments are made in full in a timely manner. It does not include any late fees or additional accrued interest due to late payments.

Hugh  -  To Calculators