Land Loan Calculator
Payment
871.11
Loan Payment Calculator
Total interest
56,798.89
Total of payments
156,798.89
Number of payments
180
Payoff time
15 years
Rate per period
0.541667 %
Interest per unit borrowed
0.568
Interest saved by extra payments
0
Payments saved
0
Loan amount
100,000.00
Annual interest rate
6.5 %
Months to repay
180
Fees deducted at closing
0.00
Net amount advanced
100,000.00
APR
6.5 %
Worked out from Standard annuity-immediate payment formula, PMT = P i / (1 - (1+i)^-n) and 4 other sources.
How this is worked out
3 steps
- Rate per period = 6.5% / 12 = 0.541667%
- Payment = P i / (1 - (1+i)^-n) = 871.11
- Over 180 payments the total paid is 156798.89, of which 56798.89 is interest.
Amortisation scheduletable
| period | payment | interest | principal | balance |
|---|---|---|---|---|
| 1 | 871.11 | 541.67 | 329.44 | 99,670.56 |
| 2 | 871.11 | 539.88 | 331.23 | 99,339.33 |
| 3 | 871.11 | 538.09 | 333.02 | 99,006.31 |
| 4 | 871.11 | 536.28 | 334.83 | 98,671.48 |
| 5 | 871.11 | 534.47 | 336.64 | 98,334.84 |
| 6 | 871.11 | 532.65 | 338.46 | 97,996.38 |
| 7 | 871.11 | 530.81 | 340.3 | 97,656.08 |
| 8 | 871.11 | 528.97 | 342.14 | 97,313.94 |
| 9 | 871.11 | 527.12 | 343.99 | 96,969.95 |
| 10 | 871.11 | 525.25 | 345.86 | 96,624.09 |
| 11 | 871.11 | 523.38 | 347.73 | 96,276.36 |
| 12 | 871.11 | 521.5 | 349.61 | 95,926.75 |
| 13 | 871.11 | 519.6 | 351.51 | 95,575.24 |
| 14 | 871.11 | 517.7 | 353.41 | 95,221.83 |
| 15 | 871.11 | 515.78 | 355.33 | 94,866.5 |
| 16 | 871.11 | 513.86 | 357.25 | 94,509.25 |
| 17 | 871.11 | 511.93 | 359.18 | 94,150.07 |
| 18 | 871.11 | 509.98 | 361.13 | 93,788.94 |
| 19 | 871.11 | 508.02 | 363.09 | 93,425.85 |
| 20 | 871.11 | 506.06 | 365.05 | 93,060.8 |
| 21 | 871.11 | 504.08 | 367.03 | 92,693.77 |
| 22 | 871.11 | 502.09 | 369.02 | 92,324.75 |
| 23 | 871.11 | 500.09 | 371.02 | 91,953.73 |
| 24 | 871.11 | 498.08 | 373.03 | 91,580.7 |
| 25 | 871.11 | 496.06 | 375.05 | 91,205.65 |
| 26 | 871.11 | 494.03 | 377.08 | 90,828.57 |
| 27 | 871.11 | 491.99 | 379.12 | 90,449.45 |
| 28 | 871.11 | 489.93 | 381.18 | 90,068.27 |
| 29 | 871.11 | 487.87 | 383.24 | 89,685.03 |
| 30 | 871.11 | 485.79 | 385.32 | 89,299.71 |
| 31 | 871.11 | 483.71 | 387.4 | 88,912.31 |
| 32 | 871.11 | 481.61 | 389.5 | 88,522.81 |
| 33 | 871.11 | 479.5 | 391.61 | 88,131.2 |
| 34 | 871.11 | 477.38 | 393.73 | 87,737.47 |
| 35 | 871.11 | 475.24 | 395.87 | 87,341.6 |
| 36 | 871.11 | 473.1 | 398.01 | 86,943.59 |
| 37 | 871.11 | 470.94 | 400.17 | 86,543.42 |
| 38 | 871.11 | 468.78 | 402.33 | 86,141.09 |
| 39 | 871.11 | 466.6 | 404.51 | 85,736.58 |
| 40 | 871.11 | 464.41 | 406.7 | 85,329.88 |
| 41 | 871.11 | 462.2 | 408.91 | 84,920.97 |
| 42 | 871.11 | 459.99 | 411.12 | 84,509.85 |
| 43 | 871.11 | 457.76 | 413.35 | 84,096.5 |
| 44 | 871.11 | 455.52 | 415.59 | 83,680.91 |
| 45 | 871.11 | 453.27 | 417.84 | 83,263.07 |
| 46 | 871.11 | 451.01 | 420.1 | 82,842.97 |
| 47 | 871.11 | 448.73 | 422.38 | 82,420.59 |
| 48 | 871.11 | 446.44 | 424.67 | 81,995.92 |
| 49 | 871.11 | 444.14 | 426.97 | 81,568.95 |
| 50 | 871.11 | 441.83 | 429.28 | 81,139.67 |
| 51 | 871.11 | 439.51 | 431.6 | 80,708.07 |
| 52 | 871.11 | 437.17 | 433.94 | 80,274.13 |
| 53 | 871.11 | 434.82 | 436.29 | 79,837.84 |
| 54 | 871.11 | 432.45 | 438.66 | 79,399.18 |
| 55 | 871.11 | 430.08 | 441.03 | 78,958.15 |
| 56 | 871.11 | 427.69 | 443.42 | 78,514.73 |
| 57 | 871.11 | 425.29 | 445.82 | 78,068.91 |
| 58 | 871.11 | 422.87 | 448.24 | 77,620.67 |
| 59 | 871.11 | 420.45 | 450.66 | 77,170.01 |
| 60 | 871.11 | 418 | 453.11 | 76,716.9 |
| 61 | 871.11 | 415.55 | 455.56 | 76,261.34 |
| 62 | 871.11 | 413.08 | 458.03 | 75,803.31 |
| 63 | 871.11 | 410.6 | 460.51 | 75,342.8 |
| 64 | 871.11 | 408.11 | 463 | 74,879.8 |
| 65 | 871.11 | 405.6 | 465.51 | 74,414.29 |
| 66 | 871.11 | 403.08 | 468.03 | 73,946.26 |
| 67 | 871.11 | 400.54 | 470.57 | 73,475.69 |
| 68 | 871.11 | 397.99 | 473.12 | 73,002.57 |
| 69 | 871.11 | 395.43 | 475.68 | 72,526.89 |
| 70 | 871.11 | 392.85 | 478.26 | 72,048.63 |
| 71 | 871.11 | 390.26 | 480.85 | 71,567.78 |
| 72 | 871.11 | 387.66 | 483.45 | 71,084.33 |
| 73 | 871.11 | 385.04 | 486.07 | 70,598.26 |
| 74 | 871.11 | 382.41 | 488.7 | 70,109.56 |
| 75 | 871.11 | 379.76 | 491.35 | 69,618.21 |
| 76 | 871.11 | 377.1 | 494.01 | 69,124.2 |
| 77 | 871.11 | 374.42 | 496.69 | 68,627.51 |
| 78 | 871.11 | 371.73 | 499.38 | 68,128.13 |
| 79 | 871.11 | 369.03 | 502.08 | 67,626.05 |
| 80 | 871.11 | 366.31 | 504.8 | 67,121.25 |
| 81 | 871.11 | 363.57 | 507.54 | 66,613.71 |
| 82 | 871.11 | 360.82 | 510.29 | 66,103.42 |
| 83 | 871.11 | 358.06 | 513.05 | 65,590.37 |
| 84 | 871.11 | 355.28 | 515.83 | 65,074.54 |
| 85 | 871.11 | 352.49 | 518.62 | 64,555.92 |
| 86 | 871.11 | 349.68 | 521.43 | 64,034.49 |
| 87 | 871.11 | 346.85 | 524.26 | 63,510.23 |
| 88 | 871.11 | 344.01 | 527.1 | 62,983.13 |
| 89 | 871.11 | 341.16 | 529.95 | 62,453.18 |
| 90 | 871.11 | 338.29 | 532.82 | 61,920.36 |
| 91 | 871.11 | 335.4 | 535.71 | 61,384.65 |
| 92 | 871.11 | 332.5 | 538.61 | 60,846.04 |
| 93 | 871.11 | 329.58 | 541.53 | 60,304.51 |
| 94 | 871.11 | 326.65 | 544.46 | 59,760.05 |
| 95 | 871.11 | 323.7 | 547.41 | 59,212.64 |
| 96 | 871.11 | 320.74 | 550.37 | 58,662.27 |
| 97 | 871.11 | 317.75 | 553.36 | 58,108.91 |
| 98 | 871.11 | 314.76 | 556.35 | 57,552.56 |
| 99 | 871.11 | 311.74 | 559.37 | 56,993.19 |
| 100 | 871.11 | 308.71 | 562.4 | 56,430.79 |
| 101 | 871.11 | 305.67 | 565.44 | 55,865.35 |
| 102 | 871.11 | 302.6 | 568.51 | 55,296.84 |
| 103 | 871.11 | 299.52 | 571.59 | 54,725.25 |
| 104 | 871.11 | 296.43 | 574.68 | 54,150.57 |
| 105 | 871.11 | 293.32 | 577.79 | 53,572.78 |
| 106 | 871.11 | 290.19 | 580.92 | 52,991.86 |
| 107 | 871.11 | 287.04 | 584.07 | 52,407.79 |
| 108 | 871.11 | 283.88 | 587.23 | 51,820.56 |
| 109 | 871.11 | 280.69 | 590.42 | 51,230.14 |
| 110 | 871.11 | 277.5 | 593.61 | 50,636.53 |
| 111 | 871.11 | 274.28 | 596.83 | 50,039.7 |
| 112 | 871.11 | 271.05 | 600.06 | 49,439.64 |
| 113 | 871.11 | 267.8 | 603.31 | 48,836.33 |
| 114 | 871.11 | 264.53 | 606.58 | 48,229.75 |
| 115 | 871.11 | 261.24 | 609.87 | 47,619.88 |
| 116 | 871.11 | 257.94 | 613.17 | 47,006.71 |
| 117 | 871.11 | 254.62 | 616.49 | 46,390.22 |
| 118 | 871.11 | 251.28 | 619.83 | 45,770.39 |
| 119 | 871.11 | 247.92 | 623.19 | 45,147.2 |
| 120 | 871.11 | 244.55 | 626.56 | 44,520.64 |
First 120 of 180 rows.
Yearly summarytable
| year | interest | principal | endingBalance |
|---|---|---|---|
| 1 | 6,380.07 | 4,073.25 | 95,926.75 |
| 2 | 6,107.27 | 4,346.05 | 91,580.7 |
| 3 | 5,816.21 | 4,637.11 | 86,943.59 |
| 4 | 5,505.65 | 4,947.67 | 81,995.92 |
| 5 | 5,174.3 | 5,279.02 | 76,716.9 |
| 6 | 4,820.75 | 5,632.57 | 71,084.33 |
| 7 | 4,443.53 | 6,009.79 | 65,074.54 |
| 8 | 4,041.05 | 6,412.27 | 58,662.27 |
| 9 | 3,611.61 | 6,841.71 | 51,820.56 |
| 10 | 3,153.4 | 7,299.92 | 44,520.64 |
| 11 | 2,664.52 | 7,788.8 | 36,731.84 |
| 12 | 2,142.87 | 8,310.45 | 28,421.39 |
| 13 | 1,586.3 | 8,867.02 | 19,554.37 |
| 14 | 992.49 | 9,460.83 | 10,093.54 |
| 15 | 358.87 | 10,093.54 | 0 |
Results are general information, not financial, tax, legal, medical or engineering advice.