keisoku

Loan Repayment Calculator with Bonus Payments

Enter your loan amount, interest rate and term, plus the share repaid through bonus payments and how often they occur, to instantly compute your monthly payment, each bonus payment, the annual and total repayment, and total interest using the equal-payment method. A year-by-year amortization schedule is included.

Input

$
%
years
$

The portion of the loan repaid in lump sums on bonus months. Must be no larger than the loan amount.

Bonus payments per year

Result

Monthly payment

$67,749.00

On bonus months you also pay an extra $101,799.00

Monthly payment

$67,749.00

Per bonus payment (2/yr)

$101,799.00

Annual repayment

$1,016,586.00

Loan principal

$30,000,000.00

Total interest

$5,580,331.00

Total repayment

$35,580,331.00


Breakdown (monthly portion / bonus portion)

Principal on monthly portion

$24,000,000.00

Principal on bonus portion

$6,000,000.00


Amortization schedule (yearly, monthly + bonus combined)

YearPaymentPrincipalInterestBalance
1$1,016,586.00$719,577.00$297,009.00$29,280,423.00
2$1,016,586.00$726,805.00$289,781.00$28,553,618.00
3$1,016,586.00$734,103.00$282,483.00$27,819,515.00
4$1,016,586.00$741,476.00$275,110.00$27,078,039.00
5$1,016,586.00$748,920.00$267,666.00$26,329,119.00
6$1,016,586.00$756,443.00$260,143.00$25,572,676.00
7$1,016,586.00$764,036.00$252,550.00$24,808,640.00
8$1,016,586.00$771,709.00$244,877.00$24,036,931.00
9$1,016,586.00$779,457.00$237,129.00$23,257,474.00
10$1,016,586.00$787,286.00$229,300.00$22,470,188.00
11$1,016,586.00$795,192.00$221,394.00$21,674,996.00
12$1,016,586.00$803,177.00$213,409.00$20,871,819.00
13$1,016,586.00$811,242.00$205,344.00$20,060,577.00
14$1,016,586.00$819,387.00$197,199.00$19,241,190.00
15$1,016,586.00$827,617.00$188,969.00$18,413,573.00
16$1,016,586.00$835,925.00$180,661.00$17,577,648.00
17$1,016,586.00$844,320.00$172,266.00$16,733,328.00
18$1,016,586.00$852,799.00$163,787.00$15,880,529.00
19$1,016,586.00$861,363.00$155,223.00$15,019,166.00
20$1,016,586.00$870,013.00$146,573.00$14,149,153.00
21$1,016,586.00$878,751.00$137,835.00$13,270,402.00
22$1,016,586.00$887,574.00$129,012.00$12,382,828.00
23$1,016,586.00$896,485.00$120,101.00$11,486,343.00
24$1,016,586.00$905,487.00$111,099.00$10,580,856.00
25$1,016,586.00$914,583.00$102,003.00$9,666,273.00
26$1,016,586.00$923,765.00$92,821.00$8,742,508.00
27$1,016,586.00$933,040.00$83,546.00$7,809,468.00
28$1,016,586.00$942,411.00$74,175.00$6,867,057.00
29$1,016,586.00$951,873.00$64,713.00$5,915,184.00
30$1,016,586.00$961,434.00$55,152.00$4,953,750.00
31$1,016,586.00$971,085.00$45,501.00$3,982,665.00
32$1,016,586.00$980,838.00$35,748.00$3,001,827.00
33$1,016,586.00$990,688.00$25,898.00$2,011,139.00
34$1,016,586.00$1,000,636.00$15,950.00$1,010,503.00
35$1,016,407.00$1,010,503.00$5,904.00$0.00

How it works

  • The loan is split into a monthly portion (loan amount minus the bonus portion) and a bonus portion, each treated as an independent equal-payment (annuity) loan and then combined for display.
  • For the monthly portion, the monthly rate is the annual rate divided by 100 and by 12, and the number of payments is the term in years times 12. The monthly payment is principal x monthly rate x (1 + monthly rate)^n / ((1 + monthly rate)^n - 1), where n is the number of payments (when the rate is 0%, it is simply principal divided by n).
  • For the bonus portion, the per-period rate is the annual rate divided by 100 and by the number of bonus payments per year, and the number of payments is the term in years times that frequency. The same equal-payment formula gives each bonus payment. You can choose twice a year (every 6 months) or once a year.
  • Annual repayment is the monthly payment x 12 plus each bonus payment x the yearly frequency. Total repayment is the sum of all payments, and total interest is the total repayment minus the loan principal.
  • The amortization schedule combines the monthly and bonus portions by year, showing each year's payment, principal, interest, and year-end balance. Payments are rounded to the nearest currency unit, with the rounding adjusted on the final payment of each portion so the balance reaches exactly zero.
  • Note: results are rounded estimates. The rate is treated as fixed for the entire term; variable rates, prepayments, and overlapping bonus months are not supported. Actual payments may differ depending on your lender's calculation and rounding methods.