Business Property Loans 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
6,752.07
Loan Payment Calculator
Total interest
585,362.23
Total of payments
1,585,362.23
Number of payments
120
Payoff time
10 years
Rate per period
0.541667 %
Interest per unit borrowed
0.5854
Interest saved by extra payments
0
Payments saved
0
Loan amount
1,000,000.00
Annual interest rate
6.5 %
Months to repay
120
Balloon payment due
775,113.83
Fees deducted at closing
0.00
Net amount advanced
1,000,000.00
APR
6.5 %
Worked out from Standard annuity-immediate payment formula, PMT = P i / (1 - (1+i)^-n) and 4 other sources.
The payment amortises the loan over 25 years, but the loan is called after 10: 775113.83 falls due as a balloon payment with payment 120.

How this is worked out

3 steps
  1. Rate per period = 6.5% / 12 = 0.541667%
  2. Payment = P i / (1 - (1+i)^-n) = 6752.07
  3. Over 120 payments the total paid is 1585362.23, of which 585362.23 is interest.
Amortisation scheduletable
periodpaymentinterestprincipalbalance
16,752.075,416.671,335.4998,664.6
26,752.075,409.431,342.64997,321.96
36,752.075,402.161,349.91995,972.05
46,752.075,394.851,357.22994,614.83
56,752.075,387.51,364.57993,250.26
66,752.075,380.111,371.96991,878.3
76,752.075,372.671,379.4990,498.9
86,752.075,365.21,386.87989,112.03
96,752.075,357.691,394.38987,717.65
106,752.075,350.141,401.93986,315.72
116,752.075,342.541,409.53984,906.19
126,752.075,334.911,417.16983,489.03
136,752.075,327.231,424.84982,064.19
146,752.075,319.511,432.56980,631.63
156,752.075,311.751,440.32979,191.31
166,752.075,303.951,448.12977,743.19
176,752.075,296.111,455.96976,287.23
186,752.075,288.221,463.85974,823.38
196,752.075,280.291,471.78973,351.6
206,752.075,272.321,479.75971,871.85
216,752.075,264.311,487.76970,384.09
226,752.075,256.251,495.82968,888.27
236,752.075,248.141,503.93967,384.34
246,752.075,2401,512.07965,872.27
256,752.075,231.811,520.26964,352.01
266,752.075,223.571,528.5962,823.51
276,752.075,215.291,536.78961,286.73
286,752.075,206.971,545.1959,741.63
296,752.075,198.61,553.47958,188.16
306,752.075,190.191,561.88956,626.28
316,752.075,181.731,570.34955,055.94
326,752.075,173.221,578.85953,477.09
336,752.075,164.671,587.4951,889.69
346,752.075,156.071,596950,293.69
356,752.075,147.421,604.65948,689.04
366,752.075,138.731,613.34947,075.7
376,752.075,129.991,622.08945,453.62
386,752.075,121.211,630.86943,822.76
396,752.075,112.371,639.7942,183.06
406,752.075,103.491,648.58940,534.48
416,752.075,094.561,657.51938,876.97
426,752.075,085.581,666.49937,210.48
436,752.075,076.561,675.51935,534.97
446,752.075,067.481,684.59933,850.38
456,752.075,058.361,693.71932,156.67
466,752.075,049.181,702.89930,453.78
476,752.075,039.961,712.11928,741.67
486,752.075,030.681,721.39927,020.28
496,752.075,021.361,730.71925,289.57
506,752.075,011.991,740.08923,549.49
516,752.075,002.561,749.51921,799.98
526,752.074,993.081,758.99920,040.99
536,752.074,983.561,768.51918,272.48
546,752.074,973.981,778.09916,494.39
556,752.074,964.341,787.73914,706.66
566,752.074,954.661,797.41912,909.25
576,752.074,944.931,807.14911,102.11
586,752.074,935.141,816.93909,285.18
596,752.074,925.291,826.78907,458.4
606,752.074,915.41,836.67905,621.73
616,752.074,905.451,846.62903,775.11
626,752.074,895.451,856.62901,918.49
636,752.074,885.391,866.68900,051.81
646,752.074,875.281,876.79898,175.02
656,752.074,865.111,886.96896,288.06
666,752.074,854.891,897.18894,390.88
676,752.074,844.621,907.45892,483.43
686,752.074,834.291,917.78890,565.65
696,752.074,823.91,928.17888,637.48
706,752.074,813.451,938.62886,698.86
716,752.074,802.951,949.12884,749.74
726,752.074,792.391,959.68882,790.06
736,752.074,781.781,970.29880,819.77
746,752.074,771.111,980.96878,838.81
756,752.074,760.381,991.69876,847.12
766,752.074,749.592,002.48874,844.64
776,752.074,738.742,013.33872,831.31
786,752.074,727.842,024.23870,807.08
796,752.074,716.872,035.2868,771.88
806,752.074,705.852,046.22866,725.66
816,752.074,694.762,057.31864,668.35
826,752.074,683.622,068.45862,599.9
836,752.074,672.422,079.65860,520.25
846,752.074,661.152,090.92858,429.33
856,752.074,649.832,102.24856,327.09
866,752.074,638.442,113.63854,213.46
876,752.074,626.992,125.08852,088.38
886,752.074,615.482,136.59849,951.79
896,752.074,603.912,148.16847,803.63
906,752.074,592.272,159.8845,643.83
916,752.074,580.572,171.5843,472.33
926,752.074,568.812,183.26841,289.07
936,752.074,556.982,195.09839,093.98
946,752.074,545.092,206.98836,887
956,752.074,533.142,218.93834,668.07
966,752.074,521.122,230.95832,437.12
976,752.074,509.032,243.04830,194.08
986,752.074,496.882,255.19827,938.89
996,752.074,484.672,267.4825,671.49
1006,752.074,472.392,279.68823,391.81
1016,752.074,460.042,292.03821,099.78
1026,752.074,447.622,304.45818,795.33
1036,752.074,435.142,316.93816,478.4
1046,752.074,422.592,329.48814,148.92
1056,752.074,409.972,342.1811,806.82
1066,752.074,397.292,354.78809,452.04
1076,752.074,384.532,367.54807,084.5
1086,752.074,371.712,380.36804,704.14
1096,752.074,358.812,393.26802,310.88
1106,752.074,345.852,406.22799,904.66
1116,752.074,332.822,419.25797,485.41
1126,752.074,319.712,432.36795,053.05
1136,752.074,306.542,445.53792,607.52
1146,752.074,293.292,458.78790,148.74
1156,752.074,279.972,472.1787,676.64
1166,752.074,266.582,485.49785,191.15
1176,752.074,253.122,498.95782,692.2
1186,752.074,239.582,512.49780,179.71
1196,752.074,225.972,526.1777,653.61
1206,752.074,212.292,539.78775,113.83
Yearly summarytable
yearinterestprincipalendingBalance
164,513.8716,510.97983,489.03
263,408.0817,616.76965,872.27
362,228.2718,796.57947,075.7
460,969.4220,055.42927,020.28
559,626.2921,398.55905,621.73
658,193.1722,831.67882,790.06
756,664.1124,360.73858,429.33
855,032.6325,992.21832,437.12
953,291.8627,732.98804,704.14
1051,434.5329,590.31775,113.83

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