Land Loan Calculator

Formatting only. This does not change the calculation.
The nominal annual rate (APR before fees), not the monthly rate.
Added to the term in years, for terms such as 5 years and 6 months. To state a tenure purely in months, set the years to 0 and enter the whole tenure here.
Additional principal paid on top of the scheduled payment.
Commercial, land and construction loans are commonly written on a long amortisation but fall due earlier, with the remaining balance repaid in one balloon payment. Leave at 0 for a fully amortising loan.
A percentage of the loan withheld at closing. Enter the figure your lender quotes - fee schedules differ by lender and by programme.
Guaranty, packaging, survey or documentation fees withheld from the advance rather than paid separately.
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
  1. Rate per period = 6.5% / 12 = 0.541667%
  2. Payment = P i / (1 - (1+i)^-n) = 871.11
  3. Over 180 payments the total paid is 156798.89, of which 56798.89 is interest.
Amortisation scheduletable
periodpaymentinterestprincipalbalance
1871.11541.67329.4499,670.56
2871.11539.88331.2399,339.33
3871.11538.09333.0299,006.31
4871.11536.28334.8398,671.48
5871.11534.47336.6498,334.84
6871.11532.65338.4697,996.38
7871.11530.81340.397,656.08
8871.11528.97342.1497,313.94
9871.11527.12343.9996,969.95
10871.11525.25345.8696,624.09
11871.11523.38347.7396,276.36
12871.11521.5349.6195,926.75
13871.11519.6351.5195,575.24
14871.11517.7353.4195,221.83
15871.11515.78355.3394,866.5
16871.11513.86357.2594,509.25
17871.11511.93359.1894,150.07
18871.11509.98361.1393,788.94
19871.11508.02363.0993,425.85
20871.11506.06365.0593,060.8
21871.11504.08367.0392,693.77
22871.11502.09369.0292,324.75
23871.11500.09371.0291,953.73
24871.11498.08373.0391,580.7
25871.11496.06375.0591,205.65
26871.11494.03377.0890,828.57
27871.11491.99379.1290,449.45
28871.11489.93381.1890,068.27
29871.11487.87383.2489,685.03
30871.11485.79385.3289,299.71
31871.11483.71387.488,912.31
32871.11481.61389.588,522.81
33871.11479.5391.6188,131.2
34871.11477.38393.7387,737.47
35871.11475.24395.8787,341.6
36871.11473.1398.0186,943.59
37871.11470.94400.1786,543.42
38871.11468.78402.3386,141.09
39871.11466.6404.5185,736.58
40871.11464.41406.785,329.88
41871.11462.2408.9184,920.97
42871.11459.99411.1284,509.85
43871.11457.76413.3584,096.5
44871.11455.52415.5983,680.91
45871.11453.27417.8483,263.07
46871.11451.01420.182,842.97
47871.11448.73422.3882,420.59
48871.11446.44424.6781,995.92
49871.11444.14426.9781,568.95
50871.11441.83429.2881,139.67
51871.11439.51431.680,708.07
52871.11437.17433.9480,274.13
53871.11434.82436.2979,837.84
54871.11432.45438.6679,399.18
55871.11430.08441.0378,958.15
56871.11427.69443.4278,514.73
57871.11425.29445.8278,068.91
58871.11422.87448.2477,620.67
59871.11420.45450.6677,170.01
60871.11418453.1176,716.9
61871.11415.55455.5676,261.34
62871.11413.08458.0375,803.31
63871.11410.6460.5175,342.8
64871.11408.1146374,879.8
65871.11405.6465.5174,414.29
66871.11403.08468.0373,946.26
67871.11400.54470.5773,475.69
68871.11397.99473.1273,002.57
69871.11395.43475.6872,526.89
70871.11392.85478.2672,048.63
71871.11390.26480.8571,567.78
72871.11387.66483.4571,084.33
73871.11385.04486.0770,598.26
74871.11382.41488.770,109.56
75871.11379.76491.3569,618.21
76871.11377.1494.0169,124.2
77871.11374.42496.6968,627.51
78871.11371.73499.3868,128.13
79871.11369.03502.0867,626.05
80871.11366.31504.867,121.25
81871.11363.57507.5466,613.71
82871.11360.82510.2966,103.42
83871.11358.06513.0565,590.37
84871.11355.28515.8365,074.54
85871.11352.49518.6264,555.92
86871.11349.68521.4364,034.49
87871.11346.85524.2663,510.23
88871.11344.01527.162,983.13
89871.11341.16529.9562,453.18
90871.11338.29532.8261,920.36
91871.11335.4535.7161,384.65
92871.11332.5538.6160,846.04
93871.11329.58541.5360,304.51
94871.11326.65544.4659,760.05
95871.11323.7547.4159,212.64
96871.11320.74550.3758,662.27
97871.11317.75553.3658,108.91
98871.11314.76556.3557,552.56
99871.11311.74559.3756,993.19
100871.11308.71562.456,430.79
101871.11305.67565.4455,865.35
102871.11302.6568.5155,296.84
103871.11299.52571.5954,725.25
104871.11296.43574.6854,150.57
105871.11293.32577.7953,572.78
106871.11290.19580.9252,991.86
107871.11287.04584.0752,407.79
108871.11283.88587.2351,820.56
109871.11280.69590.4251,230.14
110871.11277.5593.6150,636.53
111871.11274.28596.8350,039.7
112871.11271.05600.0649,439.64
113871.11267.8603.3148,836.33
114871.11264.53606.5848,229.75
115871.11261.24609.8747,619.88
116871.11257.94613.1747,006.71
117871.11254.62616.4946,390.22
118871.11251.28619.8345,770.39
119871.11247.92623.1945,147.2
120871.11244.55626.5644,520.64

First 120 of 180 rows.

Yearly summarytable
yearinterestprincipalendingBalance
16,380.074,073.2595,926.75
26,107.274,346.0591,580.7
35,816.214,637.1186,943.59
45,505.654,947.6781,995.92
55,174.35,279.0276,716.9
64,820.755,632.5771,084.33
74,443.536,009.7965,074.54
84,041.056,412.2758,662.27
93,611.616,841.7151,820.56
103,153.47,299.9244,520.64
112,664.527,788.836,731.84
122,142.878,310.4528,421.39
131,586.38,867.0219,554.37
14992.499,460.8310,093.54
15358.8710,093.540

Results are general information, not financial, tax, legal, medical or engineering advice.