Formula
Instalment = Principal amount × r ÷ (1 − (1 + r)^−Instalments), where r = Annual interest rate ÷ 12 for monthly and ÷ 52 for weekly payments; Instalments = Term (months) for monthly and round(Term ÷ 12 × 52) for weekly.
Origination fee = Principal amount × Origination fee percent. Net proceeds = Principal amount − Origination fee. Total of payments = Instalment × Instalments.
Late charge = Late fee percent × the overdue instalment, applied when payment is not received within the Grace period (days). The template inserts these figures into Sections 2, 3, 4 and 6 and fills Sections 5, 7, 9 and 12 from the prepayment, collateral, guarantor and state inputs.
Worked examples
Example 1: the default loan ($100,000 at 12 percent, 36 monthly instalments, 2 percent fee)
Monthly rate: 0.12 ÷ 12 = 0.01. Instalment: $100,000 × 0.01 ÷ (1 − 1.01^−36). The discount factor 1.01^−36 = 0.6989, the denominator 0.3011, and the instalment $1,000 ÷ 0.3011 = $3,321.43. Total of payments: $3,321.43 × 36 = $119,571.52, shown as $119,572, so total interest is $19,572. Origination fee: $100,000 × 0.02 = $2,000; net proceeds $98,000. The generated text states in Section 1 a loan of $100,000; in Section 2 a fixed rate of 12.00 percent on a 12-month year; in Section 3 a fee of 2.00 percent ($2,000) deducted at closing with net proceeds of $98,000; in Section 4 thirty-six monthly instalments of $3,321.43, total $119,572; in Section 5 prepayment without penalty (the box is checked by default); in Section 6 a late charge of 5.0 percent on any instalment more than 10 days late; and in Section 10 default after 10 days. With no names entered, the parties appear as bracketed placeholders, Section 7 says unsecured or describe collateral, Section 9 says no guarantor, and Section 12 says [STATE]. Note that the borrower receives $98,000 but repays $119,572; the effective cost is higher than 12 percent because the fee is paid on the gross principal.
Example 2: a secured weekly loan with a guarantor ($60,000 at 16 percent, 24 months weekly, 3 percent fee)
Weekly instalment count: round(24 ÷ 12 × 52) = 104. Weekly rate: 0.16 ÷ 52 = 0.003077. Instalment: $60,000 × 0.003077 ÷ (1 − 1.003077^−104). The discount factor is 0.7265, the denominator 0.2735, and the instalment $184.62 ÷ 0.2735 = $675.03. Total of payments: $675.03 × 104 = $70,203. Fee: $60,000 × 0.03 = $1,800; net proceeds $58,200. With the lender entered as Lender LLC, the borrower as Borrower Inc., a Delaware corporation, the guarantor as a named individual, collateral as all business assets (blanket lien) and governing law New York, the text names the parties in the preamble, says interest is computed on a 52-week year in Section 2, states 104 weekly instalments of $675.03 due on the same weekday in Section 4, grants a security interest in all business assets with UCC-1 authority in Section 7, inserts the guarantor's unconditional guaranty in Section 9, and names New York in Section 12 with the bracketed warning about confessions of judgment. Interest over the term is $10,203 on $60,000, less than 16 percent a year on the original amount because weekly amortization keeps the average balance low.
Example 3: the effect of the grace period and late fee on one missed instalment
Take the default loan. An instalment of $3,321.43 is due on the first of the month and is not received. Section 6 says a late charge applies if payment is not received within 10 days, at 5.0 percent of the overdue amount: $3,321.43 × 0.05 = $166.07. If the borrower pays on day 9, no late charge; on day 11, $166.07 plus the instalment. Section 10 makes a payment more than 10 days late an Event of Default, which under Section 11 allows the lender to accelerate the whole balance; after the twelfth payment the remaining principal is $70,558.44, and the lender may also charge default interest at a bracketed rate for counsel to set. In practice a lender rarely accelerates on a single late payment, but the clause gives it the right. If a late fee of 5 percent on a weekly instalment seems small, remember that on a 104-instalment loan the same 5 percent applied repeatedly can exceed what state law permits as a reasonable estimate of the lender's cost; counsel sets the cap.