1 |
The down payment = The price of the home multiplied by the percentage down divided by 100 (for 5% down becomes 5/100 or 0.05)
$6,000,000.00 = $20,000,000.00 X (30 / 100)
|
2 |
The interest rate = The annual interest percentage divided by 100
0.12 = 12% / 100
|
The monthly factor = The result of the following formula:
|
3 |
The monthly interest rate = The annual interest rate divided by 12 (for the 12 months in a year)
0.01 = 0.12 / 12
|
4 |
The month term of the loan in months = The number of years you've taken the loan out for times 12
360 Months = 30 Years X 12
|
5 |
The montly payment is figured out using the following formula:
Monthly Payment = 1400000000 * (00100 / (1 - ((1 + 00100)-(360))))
The amortization breaks down how much of your monthly payment goes towards the bank's interest, and how much goes into paying off the principal of your loan.
|
Amortization For Monthly Payment: $144,005.76 over 30 years
Totals for year 1 |
|
You will spend $1,728,069.16 on your house in year 1
$1,677,266.05 will go towards INTEREST
$50,803.11 will go towards PRINCIPAL
|
|
Totals for year 2 |
|
You will spend $1,728,069.16 on your house in year 2
$1,670,822.95 will go towards INTEREST
$57,246.21 will go towards PRINCIPAL
|
|
Totals for year 3 |
|
You will spend $1,728,069.16 on your house in year 3
$1,663,562.70 will go towards INTEREST
$64,506.47 will go towards PRINCIPAL
|
|
Totals for year 4 |
|
You will spend $1,728,069.16 on your house in year 4
$1,655,381.66 will go towards INTEREST
$72,687.50 will go towards PRINCIPAL
|
|
Totals for year 5 |
|
You will spend $1,728,069.16 on your house in year 5
$1,646,163.07 will go towards INTEREST
$81,906.10 will go towards PRINCIPAL
|
|
Totals for year 6 |
|
You will spend $1,728,069.16 on your house in year 6
$1,635,775.32 will go towards INTEREST
$92,293.84 will go towards PRINCIPAL
|
|
Totals for year 7 |
|
You will spend $1,728,069.16 on your house in year 7
$1,624,070.15 will go towards INTEREST
$103,999.01 will go towards PRINCIPAL
|
|
Totals for year 8 |
|
You will spend $1,728,069.16 on your house in year 8
$1,610,880.48 will go towards INTEREST
$117,188.69 will go towards PRINCIPAL
|
|
Totals for year 9 |
|
You will spend $1,728,069.16 on your house in year 9
$1,596,018.02 will go towards INTEREST
$132,051.14 will go towards PRINCIPAL
|
|
Totals for year 10 |
|
You will spend $1,728,069.16 on your house in year 10
$1,579,270.63 will go towards INTEREST
$148,798.53 will go towards PRINCIPAL
|
|
Totals for year 11 |
|
You will spend $1,728,069.16 on your house in year 11
$1,560,399.25 will go towards INTEREST
$167,669.91 will go towards PRINCIPAL
|
|
Totals for year 12 |
|
You will spend $1,728,069.16 on your house in year 12
$1,539,134.51 will go towards INTEREST
$188,934.66 will go towards PRINCIPAL
|
|
Totals for year 13 |
|
You will spend $1,728,069.16 on your house in year 13
$1,515,172.86 will go towards INTEREST
$212,896.30 will go towards PRINCIPAL
|
|
Totals for year 14 |
|
You will spend $1,728,069.16 on your house in year 14
$1,488,172.28 will go towards INTEREST
$239,896.88 will go towards PRINCIPAL
|
|
Totals for year 15 |
|
You will spend $1,728,069.16 on your house in year 15
$1,457,747.36 will go towards INTEREST
$270,321.81 will go towards PRINCIPAL
|
|
Totals for year 16 |
|
You will spend $1,728,069.16 on your house in year 16
$1,423,463.78 will go towards INTEREST
$304,605.38 will go towards PRINCIPAL
|
|
Totals for year 17 |
|
You will spend $1,728,069.16 on your house in year 17
$1,384,832.20 will go towards INTEREST
$343,236.96 will go towards PRINCIPAL
|
|
Totals for year 18 |
|
You will spend $1,728,069.16 on your house in year 18
$1,341,301.16 will go towards INTEREST
$386,768.00 will go towards PRINCIPAL
|
|
Totals for year 19 |
|
You will spend $1,728,069.16 on your house in year 19
$1,292,249.30 will go towards INTEREST
$435,819.87 will go towards PRINCIPAL
|
|
Totals for year 20 |
|
You will spend $1,728,069.16 on your house in year 20
$1,236,976.43 will go towards INTEREST
$491,092.73 will go towards PRINCIPAL
|
|
Totals for year 21 |
|
You will spend $1,728,069.16 on your house in year 21
$1,174,693.58 will go towards INTEREST
$553,375.59 will go towards PRINCIPAL
|
|
Totals for year 22 |
|
You will spend $1,728,069.16 on your house in year 22
$1,104,511.70 will go towards INTEREST
$623,557.46 will go towards PRINCIPAL
|
|
Totals for year 23 |
|
You will spend $1,728,069.16 on your house in year 23
$1,025,429.01 will go towards INTEREST
$702,640.15 will go towards PRINCIPAL
|
|
Totals for year 24 |
|
You will spend $1,728,069.16 on your house in year 24
$936,316.65 will go towards INTEREST
$791,752.51 will go towards PRINCIPAL
|
|
Totals for year 25 |
|
You will spend $1,728,069.16 on your house in year 25
$835,902.61 will go towards INTEREST
$892,166.55 will go towards PRINCIPAL
|
|
Totals for year 26 |
|
You will spend $1,728,069.16 on your house in year 26
$722,753.56 will go towards INTEREST
$1,005,315.60 will go towards PRINCIPAL
|
|
Totals for year 27 |
|
You will spend $1,728,069.16 on your house in year 27
$595,254.38 will go towards INTEREST
$1,132,814.78 will go towards PRINCIPAL
|
|
Totals for year 28 |
|
You will spend $1,728,069.16 on your house in year 28
$451,585.11 will go towards INTEREST
$1,276,484.05 will go towards PRINCIPAL
|
|
Totals for year 29 |
|
You will spend $1,728,069.16 on your house in year 29
$289,694.99 will go towards INTEREST
$1,438,374.18 will go towards PRINCIPAL
|
|
Totals for year 30 |
|
You will spend $1,728,069.16 on your house in year 30
$107,273.14 will go towards INTEREST
$1,620,796.03 will go towards PRINCIPAL
|
|
Totals for interest paid: $37,842,074.89 |
This mortgage calculator can be used to figure out monthly payments of a home mortgage loan, based on the home's sale price, the term of the loan desired, buyer's down payment percentage, and the loan's interest rate. This calculator factors in PMI (Private Mortgage Insurance) for loans where less than 20% is put as a down payment. Also taken into consideration are the town property taxes, and their effect on the total monthly mortgage payment.
Credits to: Dave Tufts
|