Skip to content
Alternative Finance

Lending software · Lenders, brokers and borrowers

Loan payment schedule generator

This loan payment schedule generator produces a dated schedule for an amortizing loan or a fixed-payback advance at monthly, weekly or business-day frequency, with payment, interest, principal and remaining balance for every row, and a CSV you can attach to the contract or load into a servicing system. It is for lenders and brokers preparing documents and for borrowers checking what they signed. The thing to watch is the day-count convention: a business-day schedule skips weekends but not bank holidays, so the servicing calendar must be adjusted.

Payment
$2,400.64
Total of payments
$57,615
First payment
2026-11-02
Last payment
2028-10-02
Payments
24

Daily schedules skip weekends but not bank holidays; adjust holiday dates in the servicing system. For advances, the remaining column is the unpaid purchased amount.

Payment schedule
#DatePaymentInterestPrincipalRemaining
12026-11-02$2,400.64$583.33$1,817.31$48,182.69
22026-12-02$2,400.64$562.13$1,838.51$46,344.18
32027-01-02$2,400.64$540.68$1,859.96$44,484.21
42027-02-02$2,400.64$518.98$1,881.66$42,602.55
52027-03-02$2,400.64$497.03$1,903.61$40,698.94
62027-04-02$2,400.64$474.82$1,925.82$38,773.12
72027-05-02$2,400.64$452.35$1,948.29$36,824.82
82027-06-02$2,400.64$429.62$1,971.02$34,853.80
92027-07-02$2,400.64$406.63$1,994.02$32,859.79
102027-08-02$2,400.64$383.36$2,017.28$30,842.51
112027-09-02$2,400.64$359.83$2,040.81$28,801.69
122027-10-02$2,400.64$336.02$2,064.62$26,737.07
132027-11-02$2,400.64$311.93$2,088.71$24,648.36
142027-12-02$2,400.64$287.56$2,113.08$22,535.28
152028-01-02$2,400.64$262.91$2,137.73$20,397.54
162028-02-02$2,400.64$237.97$2,162.67$18,234.87
172028-03-02$2,400.64$212.74$2,187.90$16,046.97
182028-04-02$2,400.64$187.21$2,213.43$13,833.54
192028-05-02$2,400.64$161.39$2,239.25$11,594.28
202028-06-02$2,400.64$135.27$2,265.38$9,328.91
212028-07-02$2,400.64$108.84$2,291.81$7,037.10
222028-08-02$2,400.64$82.10$2,318.54$4,718.55
232028-09-02$2,400.64$55.05$2,345.59$2,372.96
242028-10-02$2,400.64$27.68$2,372.96$0.00

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.

What the schedule shows and how each column is computed

A payment schedule is the contract's arithmetic written out row by row. For an amortizing loan, each row splits a level payment into the interest accrued on the balance since the previous payment and the principal that reduces the balance; because the balance falls, the interest portion falls and the principal portion rises until the balance reaches zero on the last payment. For a fixed-payback advance (a merchant cash advance or a fixed-fee loan), the total payback is set at the start as the amount times the factor rate, every payment is the same share of it, and the schedule tracks only how much of the purchased amount remains undelivered.

The frequency sets the periodic rate. The loan payment schedule generator divides the annual rate by 12 for monthly, 52 for weekly and 252 for business-day schedules. Those divisors are conventions, not laws of nature: a contract that says interest accrues daily on a 365-day year with payments on business days produces slightly different rows, and a contract that uses a 360-day year produces different rows again. The convention in the contract governs; the schedule in the servicing system must match it or the final payment will not clear the balance. The business loan amortization calculator covers the monthly case in more depth, including how the total interest changes with term.

Columns in the generated schedule
ColumnAmortizing loanFixed-payback advance
PaymentLevel amount from the amortization formulaAmount × factor ÷ number of payments
InterestBalance × periodic rateDash (no stated interest)
PrincipalPayment − interestEqual to the payment
RemainingBalance after the principal is appliedPurchased amount not yet delivered
DateFirst payment date advanced by the frequencySame; business days skip weekends only

Date conventions: what the generator does and what it leaves to you

Monthly rows advance one calendar month; a schedule starting on the 31st rolls to the last day of shorter months in the generator's date arithmetic, so check the dates for a first payment after the 28th. Weekly rows advance exactly seven days, so the weekday is fixed. Daily rows advance one business day, Monday to Friday, and the first row is on the first payment date you enter even if that date is a weekend, so pick a weekday. The generator does not know about bank holidays. The Federal Reserve and the ACH network observe the federal holidays published by the Office of Personnel Management; a daily schedule that lands on one must be moved to the next business day in the servicing system, which pushes every later row by one day unless the contract says the missed day is collected together with the next one.

  • Month-end first payments: a first payment on 2026-01-31 produces a second on 2026-02-28 (or 29) and a third on 2026-03-31 in most date libraries, but some servicing systems pin the day to 28. Decide and document.
  • First payment date versus funding date: for a monthly loan, the first payment typically falls one month after funding; interest for the days between funding and the first due date is either included in the first payment or collected at closing as prepaid interest. The generator starts at the first payment and does not compute that stub.
  • Weekly on a Monday: a Monday debit catches the previous Friday's deposits; a Friday debit catches the week's receipts. The choice affects return rates more than the arithmetic.
  • Business days and holidays: 252 business days a year is the convention for daily products; actual years have 250 to 253 weekdays before holidays.

Using the CSV in contracts and servicing systems

The download strips currency symbols and thousands separators so the file imports cleanly. The columns are Number, Date, Payment, Interest, Principal, Remaining. In a loan agreement the schedule is normally an exhibit referenced by the repayment clause; the loan agreement generator produces a repayment clause that states the instalment, the count and the first due date, and this schedule is the exhibit behind it. For a merchant cash advance the schedule is an estimate, not a promise: the merchant delivers a specified percentage of receipts and the daily figure is the estimated remittance, which the MCA agreement template generator makes explicit. Attaching a fixed schedule to an advance without that language is one of the drafting errors that makes an advance look like a loan.

  1. 1

    Match the convention to the contract

    Confirm the periodic rate divisor (12, 52, 252 or a daily accrual) and the day-count in the note. If the note accrues daily on 365 days, do not use this schedule as the ledger.

  2. 2

    Set the first payment date

    One period after funding for monthly and weekly loans; the first business day after funding, or a few days later, for daily advances.

  3. 3

    Generate and review the last row

    The remaining balance on the last row should be $0.00 for a loan. A small residual means a rounding convention differs between this tool and the servicing system; the last payment is usually adjusted by the cents.

  4. 4

    Adjust holidays

    For daily schedules, find rows on federal holidays and move them in the servicing system.

  5. 5

    Import and reconcile

    Load the CSV, then compare the system's total of payments to the generator's. They should match to the cent after the last-payment adjustment.

How lenders, brokers and borrowers use the schedule

Lenders use the schedule to set up ACH debits, to compute interest income by period for accounting, and to produce payoff figures: the remaining balance on any date is the principal owed, to which accrued interest since the last payment is added. Brokers use it to show a client what a term and frequency mean in dollars per week; a borrower who sees $420.93 every Friday understands the commitment better than one who hears 18 percent. Borrowers use it to check a contract and to plan cash: the business cash flow calculator places the payments against receipts and shows whether the schedule fits.

Business-purpose loans are exempt from the federal Truth in Lending Act's disclosure requirements, but several states (California, New York, Utah, Virginia, Georgia, Florida, Connecticut and Kansas) require commercial financing disclosures that include the payment amount, frequency and total of payments, and in some cases an estimated annual percentage rate. New York's rules are administered by the Department of Financial Services; the schedule generated here provides the payment figures those disclosures use. For an SBA-guaranteed loan the terms must also fit the program's maturity and amortization rules, described on the SBA's 7(a) program page. Interest on business loans is generally deductible as a business expense; the IRS small business pages cover the rules, and the interest column of the schedule is the figure the deduction is based on for a cash-basis borrower.

Reading the numbers: checks and common mistakes

  • Total of payments minus amount is the total cost of a loan. For the default it is $57,615 − $50,000 = $7,615. For an advance it is amount × (factor − 1), $15,000 in Example 2.
  • Interest in row 1 equals amount × periodic rate. If it does not, the rate or frequency is entered wrongly; a common error is entering a monthly rate in the annual field.
  • The remaining balance on the last row must be zero for a loan. A large residual means the count or rate does not match the payment; a few cents is rounding.
  • Daily schedules with the first date on a weekend start on that weekend date and then skip to Monday. Enter a weekday.
  • A 24-payment monthly schedule spans 23 months between first and last payment, not 24; the term from funding is 24 months if the first payment is one month after funding.
  • Factor rate of 1.30 on 60 daily payments is not 30 percent a year. The factor rate to APR converter and the factor rate vs APR guide explain the difference.

For background on amortization and its conventions, the amortization schedule entry on Wikipedia is a reasonable reference. For the mechanics of daily advances from the borrower's side, see how merchant cash advances work.

Questions people ask

How is the payment calculated for a weekly loan?

The annual rate is divided by 52 to get the weekly rate, and the standard amortization formula is applied over the number of weekly payments: Amount × r ÷ (1 − (1 + r)^−n). Interest each week is the remaining balance times the weekly rate. A 52-payment loan at 18 percent on $20,000 has a weekly payment of $420.93.

Why does the advance schedule have no interest column?

A merchant cash advance is a purchase of future receivables for a fixed purchased amount, not a loan with a stated rate, so the schedule has nothing to split. Each payment delivers an equal share of the purchased amount, and the remaining column shows what has not yet been delivered. The daily figure is an estimate that reconciliation can change.

Does the loan payment schedule generator account for bank holidays?

No. Business-day schedules skip Saturdays and Sundays only. Federal Reserve holidays, on which the ACH network does not settle, must be adjusted in your servicing system. Expect about ten such days a year; each one shifts the schedule by a day or doubles the next debit, depending on the contract.

Can I use this schedule as the official exhibit to a loan agreement?

Use it as the basis for one, after confirming that the rate convention (annual rate divided by 12, 52 or 252) matches the note and that the last row clears the balance. If the note accrues interest daily on an actual-day basis the official schedule should come from the servicing system that will apply that accrual.

What does the remaining balance tell me if I want to pay off early?

For a loan, the remaining balance after the most recent payment is the principal owed; add interest accrued since that payment for the payoff. For an advance, the remaining column is the undelivered purchased amount, which is what the funder is owed unless the contract offers an early-delivery discount; the MCA early payoff discount calculator covers that case.

Sources and further reading

Related tools and guides

More lending software

Updated October 12, 2026 · By Alternative Finance editorial team

Next step

Turn the estimate into real offers

One request, several funding partners, side-by-side payback. Nothing is binding until you accept an offer.

  • Soft inquiry to request offers; a hard pull only if you proceed with a funder.
  • Decisions in as little as 24 hours for many products; funding often within days.
  • Use our calculators to check the true cost before you accept anything.

See what you may qualify for

Takes about a minute. Requesting offers does not affect your credit score. Free, no obligation.

We are not a lender or broker. Requests are forwarded to funding partners free of charge. How the site is paid.