How the repayments are calculated
A structured business loan has up to three parts: an interest-only phase, a principal-and-interest phase and a balloon. Each has its own formula, and all of them use the rate per repayment period.
r = yearly rate ÷ repayments per year
During the interest-only phase nothing is paid off the debt, so each repayment is simply one period’s interest on the full amount.
Interest-only repayment = P × r
When that phase ends, the whole amount is still owing and has to be repaid over the time that is left.
Repayment = (P − B × (1 + r)−m) × r ÷ (1 − (1 + r)−m)
P is the amount borrowed. B is the balloon, the part of the loan left to pay in one sum at the end (zero if there is none). m is the number of repayments remaining after the interest-only phase: the total number n less the k interest-only repayments. r is the rate per period as a decimal.
Total interest = P × r × k + repayment × m + B − P
Upfront fees do not change the repayments, but they do change what the money costs, because you have the use of P less the fees while repaying as if you had all of P. The fee-inclusive rate is the rate at which the value today of every payment (interest-only, regular and balloon) equals P less the fees. It is found by trial and error, as there is no formula for it.
Worked example: $100,000 at 9.5% over 5 years
Repayments are monthly, the first 6 months are interest only, there is no balloon and the upfront fees are $1,500.
- Rate and counts. r = 0.095 ÷ 12 = 0.0079167. n = 5 × 12 = 60 repayments, of which k = 6 are interest only, leaving m = 54.
- Interest-only repayment. $100,000 × 0.095 ÷ 12 = $791.67 a month. Six of them come to $4,750.
- The bracket. (1 + 0.095 ÷ 12)−54 = 0.653236, and 1 − 0.653236 = 0.346764.
- Repayment for the other 54 months. $791.67 ÷ 0.346764 = $2,283.01 a month, $123,282.72 in all.
- Total interest. $4,750 + $123,282.72 − $100,000 = $28,032.72.
- Interest and fees. $28,032.72 + $1,500 = $29,532.72.
- Rate with fees. You have the use of $98,500. The payments above are worth exactly that today at 10.10% a year, against the 9.5% on the contract. As an effective annual rate it is 10.59%.
What the interest-only period costs
Without the interest-only period the same loan is $2,100.19 a month for all 60 months, with $26,011.17 of interest. Six months of interest only therefore adds $2,021.55 of interest and, once it ends, a repayment $182.83 higher than the plain loan, because the full $100,000 now has to be cleared in 54 months instead of 60. A 12-month period pushes the later repayment to $2,512.31 and the interest to $30,091.06.
The step up is the figure to plan around. The early months are $791.67; the month after the interest-only period ends is $2,283.01, nearly three times as much.
One result can look odd: the interest-only version has the lower fee-inclusive rate, 10.10% against 10.15% for the plain loan. A rate measures cost per dollar borrowed per year. The interest-only loan keeps more money borrowed for longer, so the same $1,500 of fees is spread more thinly, even though more dollars are paid in total. Use the rate to compare the price of credit and the total to see what leaves the business.
Adding a balloon
With a 20% balloon on top of the six interest-only months, the regular repayment falls to $1,984.74, but $20,000 is due with the last repayment and the interest rises to $31,926.18. The balloon has to come from somewhere: retained cash, the sale of the asset the loan paid for, or a new loan at whatever rate then applies.
Repayment frequency
Paying more often lowers the interest a little, because each repayment reduces the balance sooner. On the example, weekly repayments are $182.69 during the interest-only phase and $525.57 afterwards, with $27,733.29 of interest, $299.43 less than monthly. Quarterly repayments of $6,892.14 after the interest-only phase cost $28,808.56 in interest. The interest-only period is converted to whole repayments, so six months is 26 weekly, 13 fortnightly, 6 monthly or 2 quarterly payments.
Limits of the calculation
Some lenders charge interest daily, round repayments, or collect the first repayment in advance, so a quote may differ by small amounts. Variable rates, line fees on undrawn funds, seasonal repayment schedules and security or guarantee costs are not modelled. Tax treatment of interest and fees differs between countries and business structures and is left out entirely.