Formula
Amortizing loan payment = Amount × r ÷ (1 − (1 + r)^−Count), where r = Annual rate ÷ periods per year (12 monthly, 52 weekly, 252 daily). Each row: Interest = Remaining balance × r; Principal = Payment − Interest; Remaining = previous Remaining − Principal.
Fixed-payback advance payment = Amount × Factor rate ÷ Number of payments. There is no interest column; Remaining = Amount × Factor rate − payments made so far.
Dates: monthly rows advance one calendar month from the First payment date; weekly rows advance seven days; daily rows advance one business day (Monday to Friday) with no holiday adjustment. Total of payments = Payment × Count.
Worked examples
Example 1: the default loan ($50,000 at 14 percent, 24 monthly payments)
Periodic rate: 0.14 ÷ 12 = 0.011667. Payment: $50,000 × 0.011667 ÷ (1 − 1.011667^−24). The discount factor 1.011667^−24 = 0.7570, so the denominator is 0.2430 and the payment is $583.33 ÷ 0.2430 = $2,400.64. Row 1, dated 2026-11-02: interest $50,000 × 0.011667 = $583.33; principal $2,400.64 − $583.33 = $1,817.31; remaining $48,182.69. Row 2, dated 2026-12-02: interest $48,182.69 × 0.011667 = $562.13; principal $1,838.51; remaining $46,344.18. Row 3, 2027-01-02: interest $540.68; principal $1,859.96; remaining $44,484.21. Interest falls and principal rises by about $21 each month. The last row is dated 2028-10-02, twenty-three months after the first, and the remaining balance reaches $0.00. Total of payments: $2,400.64 × 24 = $57,615, so total interest is $7,615 on $50,000.
Example 2: a fixed-payback advance collected on business days
Set Product to Fixed-payback advance, Amount $50,000, Factor rate 1.30, Number of payments 60, Frequency Daily, First payment date 2026-11-02. Payback: $50,000 × 1.30 = $65,000. Payment: $65,000 ÷ 60 = $1,083.33. The interest column shows a dash because an advance has no stated interest; the principal column equals the payment and the remaining column is the undelivered purchased amount: after row 1 it is $65,000 − $1,083.33 = $63,916.67, after row 2 $62,833.33, and so on. Dates: row 1 on Monday 2026-11-02, row 2 on 2026-11-03, row 5 on Friday 2026-11-06, row 6 skips the weekend to Monday 2026-11-09. Sixty business days end on Friday 2027-01-22, a little under twelve calendar weeks later; a 60-payment daily schedule is roughly a three-month advance. Total of payments: $65,000. Note that the schedule includes rows on federal holidays in this window (Veterans Day, Thanksgiving, Christmas, New Year's Day and Martin Luther King Jr. Day), which the ACH network does not process; your servicing system should push those items to the next business day.
Example 3: a weekly amortizing loan ($20,000 at 18 percent, 52 weeks)
Periodic rate: 0.18 ÷ 52 = 0.003462. Payment: $20,000 × 0.003462 ÷ (1 − 1.003462^−52). The discount factor is 0.8355, the denominator 0.1645, and the payment $69.23 ÷ 0.1645 = $420.93. Row 1 interest: $20,000 × 0.003462 = $69.23; principal $351.70; remaining $19,648.30. Row 2 interest: $68.01; principal $352.92; remaining $19,295.38. Total of payments: $420.93 × 52 = $21,888, so interest is $1,888 over the year, about 9.4 percent of the amount even though the annual rate is 18 percent, because the average balance over a year of weekly amortization is a little over half the original. Dates advance seven days from the first payment date, so the weekday is constant; if the first payment is a Friday every payment is a Friday, which matters for businesses whose deposits land on particular days.