Act on the result
Compare the periodic payment with a cash-flow forecast for the same dates before accepting the facility.
Educational only: Business decision support, not accounting, tax or legal advice.
Privacy: No account is required. Tool inputs and results stay in this browser. Anonymous categorical usage analytics send only governed page, tool, cluster and action identifiers; tool inputs and results are never sent. Error monitoring is disabled. Optional saved state stays only on this device.
Update policy: Reviewed when formulas or official dependencies change.
Scope: Market-neutral small-business planning using your own assumptions.
What this planner helps you decide
Best for
Businesses comparing the repayment burden of a proposed or existing term loan.
Outputs
Payment per period, total scheduled payments, total interest and final principal balance.
Start here
Confirm principal, nominal annual rate, payment frequency, term and any final balloon with the lender documents.
Use a different tool when: Do not use this to stress-test operating cash coverage of scheduled debt obligations; use Debt Service Coverage Planner for that decision. Use this tool to compare periodic loan repayments and total interest across financing terms.
Cash & growth
Business Loan Repayment: payment per period
Payment per period, total scheduled payments, total interest and final principal balance.
Amounts use the same currency as your inputs. No currency conversion is performed.
Planning assumptions
Use records and assumptions from one consistent period. Values stay in this browser.
Your numbers stay in this browser
Amount borrowed before interest. Use one consistent currency and time basis.
Nominal annual rate entered as a percentage.
Number of equal payment periods each year.
Total number of scheduled payment periods.
Additional principal due with the final scheduled payment. Use one consistent currency and time basis.
Decision result
Each output is bound to its own registered engine formula step.
PDF and CSV exports stay on this device. Clean page links contain no inputs.
- Payment each period
- 5,009.49
- Total Scheduled Payments
- 300,569.23
- Total Interest
- 50,569.23
- Payment Count
- 60
- Final Closing Principal
- 0.00
Scenario comparison
Each row names the assumption axis changed from the baseline.
ScenarioResultDifference
Current scenario5,009.49Baseline
Lower Total payments5,227.05217.57
Higher Total payments4,812.87-196.62
Save these results, change an input, then compare the updated figures with this baseline.
The baseline is temporary in this tab and is not added to shared scenario links or generated reports.
Calculation details
View calculation detailsView the formulas and inputs used for these results.
Payment each period
Periodic Payment
amortised principal × periodic rate ÷ (1 − (1 + periodic rate)^−payments)5,009.49Result5,009.49
Uses one consistent market-neutral ex-tax basis and planning period. The engine retains full precision; only presentation is rounded.
Business Loan Repayment Planner formulas →Inputs used by these formula steps
- Periodic PaymentPrincipal
- 250,000
- Periodic PaymentAnnual Interest Rate
- 0.08
- Periodic PaymentPayments Per Year
- 12
- Periodic PaymentTotal Payments
- 60
- Periodic PaymentBalloon Payment
- 0
Total Scheduled Payments
Total Scheduled Payments
periodic payment × total payments + balloon payment300,569.23Result300,569.23
Uses one consistent market-neutral ex-tax basis and planning period. The engine retains full precision; only presentation is rounded.
Business Loan Repayment Planner formulas →Inputs used by these formula steps
- Total Scheduled PaymentsPrincipal
- 250,000
- Total Scheduled PaymentsAnnual Interest Rate
- 0.08
- Total Scheduled PaymentsPayments Per Year
- 12
- Total Scheduled PaymentsTotal Payments
- 60
- Total Scheduled PaymentsBalloon Payment
- 0
Total Interest
Total Interest
total scheduled payments − principal50,569.23Result50,569.23
Uses one consistent market-neutral ex-tax basis and planning period. The engine retains full precision; only presentation is rounded.
Business Loan Repayment Planner formulas →Inputs used by these formula steps
- Total InterestPrincipal
- 250,000
- Total InterestAnnual Interest Rate
- 0.08
- Total InterestPayments Per Year
- 12
- Total InterestTotal Payments
- 60
- Total InterestBalloon Payment
- 0
Payment Count
Payment Count
number of scheduled payments60 countResult60
Uses one consistent market-neutral ex-tax basis and planning period. The engine retains full precision; only presentation is rounded.
Business Loan Repayment Planner formulas →Inputs used by these formula steps
- Payment CountPrincipal
- 250,000
- Payment CountAnnual Interest Rate
- 0.08
- Payment CountPayments Per Year
- 12
- Payment CountTotal Payments
- 60
- Payment CountBalloon Payment
- 0
Final Closing Principal
Final Closing Principal
closing principal after final payment0.00Result0.00
Uses one consistent market-neutral ex-tax basis and planning period. The engine retains full precision; only presentation is rounded.
Business Loan Repayment Planner formulas →Inputs used by these formula steps
- Final Closing PrincipalPrincipal
- 250,000
- Final Closing PrincipalAnnual Interest Rate
- 0.08
- Final Closing PrincipalPayments Per Year
- 12
- Final Closing PrincipalTotal Payments
- 60
- Final Closing PrincipalBalloon Payment
- 0
Inputs used
- Loan principal
- 250,000
- Annual interest rate
- 0.08
- Payments per year
- 12
- Total payments
- 60
- Final balloon payment
- 0
Loan amortisation table
Exact payment rows from the same repayment engine. Long schedules show the first 12 and final payment.
| Payment | Opening principal | Payment amount | Interest | Principal repaid | Closing principal |
|---|---|---|---|---|---|
| 1 | 250,000.00 | 5,009.49 | 1,562.50 | 3,446.99 | 246,553.01 |
| 2 | 246,553.01 | 5,009.49 | 1,540.96 | 3,468.53 | 243,084.48 |
| 3 | 243,084.48 | 5,009.49 | 1,519.28 | 3,490.21 | 239,594.27 |
| 4 | 239,594.27 | 5,009.49 | 1,497.46 | 3,512.02 | 236,082.25 |
| 5 | 236,082.25 | 5,009.49 | 1,475.51 | 3,533.97 | 232,548.28 |
| 6 | 232,548.28 | 5,009.49 | 1,453.43 | 3,556.06 | 228,992.22 |
| 7 | 228,992.22 | 5,009.49 | 1,431.20 | 3,578.29 | 225,413.93 |
| 8 | 225,413.93 | 5,009.49 | 1,408.84 | 3,600.65 | 221,813.28 |
| 9 | 221,813.28 | 5,009.49 | 1,386.33 | 3,623.15 | 218,190.13 |
| 10 | 218,190.13 | 5,009.49 | 1,363.69 | 3,645.80 | 214,544.33 |
| 11 | 214,544.33 | 5,009.49 | 1,340.90 | 3,668.59 | 210,875.74 |
| 12 | 210,875.74 | 5,009.49 | 1,317.97 | 3,691.51 | 207,184.23 |
| 60 | 4,978.37 | 5,009.49 | 31.11 | 4,978.37 | 0.00 |
Equipment financing module
Translate a purchase price and deposit into the same repayment schedule used above. This is an owner workflow module, not a separate public tool.
- Financed amount
- 100,000.00
- Payment each period
- 1,865.92
- Total interest
- 21,954.92
- Initial cash required
- 20,000.00
- Scheduled finance payments
- 121,954.92
- Total cash outflow
- 141,954.92
Calculation details
View calculation detailsView the formulas and inputs used for these results.
Financed amount
Financed amount
purchase price - deposit100,000.00Result100,000.00
Uses the same amortisation engine as the canonical business-loan owner. Full precision is retained until display.
Equipment financing formula →Inputs used by these formula steps
- Financed amountPurchase Price
- 120,000
- Financed amountDeposit
- 20,000
- Financed amountAnnual Interest Rate Percent
- 7.5
- Financed amountPayments Per Year
- 12
- Financed amountTotal Payments
- 60
- Financed amountResidual Payment
- 10,000
Initial cash required
Initial cash required
deposit20,000.00Result20,000.00
Uses the same amortisation engine as the canonical business-loan owner. Full precision is retained until display.
Equipment financing formula →Inputs used by these formula steps
- Initial cash requiredPurchase Price
- 120,000
- Initial cash requiredDeposit
- 20,000
- Initial cash requiredAnnual Interest Rate Percent
- 7.5
- Initial cash requiredPayments Per Year
- 12
- Initial cash requiredTotal Payments
- 60
- Initial cash requiredResidual Payment
- 10,000
Periodic payment
Periodic payment
canonical amortising loan payment1,865.92Result1,865.92
Uses the same amortisation engine as the canonical business-loan owner. Full precision is retained until display.
Equipment financing formula →Inputs used by these formula steps
- Periodic paymentPurchase Price
- 120,000
- Periodic paymentDeposit
- 20,000
- Periodic paymentAnnual Interest Rate Percent
- 7.5
- Periodic paymentPayments Per Year
- 12
- Periodic paymentTotal Payments
- 60
- Periodic paymentResidual Payment
- 10,000
Scheduled finance payments
Scheduled finance payments
periodic payments + residual121,954.92Result121,954.92
Uses the same amortisation engine as the canonical business-loan owner. Full precision is retained until display.
Equipment financing formula →Inputs used by these formula steps
- Scheduled finance paymentsPurchase Price
- 120,000
- Scheduled finance paymentsDeposit
- 20,000
- Scheduled finance paymentsAnnual Interest Rate Percent
- 7.5
- Scheduled finance paymentsPayments Per Year
- 12
- Scheduled finance paymentsTotal Payments
- 60
- Scheduled finance paymentsResidual Payment
- 10,000
Total interest
Total interest
scheduled finance payments - financed amount21,954.92Result21,954.92
Uses the same amortisation engine as the canonical business-loan owner. Full precision is retained until display.
Equipment financing formula →Inputs used by these formula steps
- Total interestPurchase Price
- 120,000
- Total interestDeposit
- 20,000
- Total interestAnnual Interest Rate Percent
- 7.5
- Total interestPayments Per Year
- 12
- Total interestTotal Payments
- 60
- Total interestResidual Payment
- 10,000
Total cash outflow
Total cash outflow
deposit + scheduled finance payments141,954.92Result141,954.92
Uses the same amortisation engine as the canonical business-loan owner. Full precision is retained until display.
Equipment financing formula →Inputs used by these formula steps
- Total cash outflowPurchase Price
- 120,000
- Total cash outflowDeposit
- 20,000
- Total cash outflowAnnual Interest Rate Percent
- 7.5
- Total cash outflowPayments Per Year
- 12
- Total cash outflowTotal Payments
- 60
- Total cash outflowResidual Payment
- 10,000
Inputs used
- purchasePrice
- 120,000
- deposit
- 20,000
- annualInterestRatePercent
- 7.5
- paymentsPerYear
- 12
- totalPayments
- 60
- residualPayment
- 10,000
Open this calculator with preset values
This calculator supports documented, shareable scenario URLs. Compatible assistants and applications can construct links using the parameters below.
Scenario links contain only allowlisted numeric and closed-choice inputs shown in the URL; Margin101 excludes free text and identifying fields. Anyone you share the URL with can read those numbers, so do not include private or identifying data.
| Parameter | Meaning | Unit | Allowed values | Presence | Default |
|---|---|---|---|---|---|
| annualInterestRate | Nominal annual rate entered as a percentage. | decimal nominal annual loan interest rate (1 = 100%) | 0 to 1 | Required | 0.075 |
| balloonPayment | Additional principal due with the final scheduled payment. Use one consistent currency and time basis. | currency units due with the final scheduled payment | 0 to 100000000 | Required | 0 |
| paymentsPerYear | Number of equal payment periods each year. | whole scheduled payment periods/year | 1 to 365 | Required | 12 |
| principal | Amount borrowed before interest. Use one consistent currency and time basis. | currency units of opening loan principal | 0 to 100000000 | Required | 250000 |
| totalPayments | Total number of scheduled payment periods. | whole scheduled payment periods/loan term | 1 to 1200 | Required | 60 |
Business Loan Repayment: payment per period
Treat the schedule as an estimate that must be reconciled with lender fees, timing conventions and contract terms.
Formula summary
- Primary formula
- amortised principal × periodic rate ÷ (1 − (1 + periodic rate)^−payments)
Data used here
- The estimate uses your inputs and the general business formula documented in the methodology.
Decision checks
Stress-test the decision
Test a higher rate, shorter term and any balloon payment shown in the lender proposal.
When this estimate can be misleading
- This model excludes lender fees, tax effects, covenant wording and lender-specific assessments.
- Results depend on complete, consistently classified inputs.
- Demand, timing, quality and strategic fit remain separate decisions.
- This is educational business decision support, not accounting, tax, legal or financial advice.
- Treat the schedule as an estimate that must be reconciled with lender fees, timing conventions and contract terms.
Educational estimate, not advice. See all assumptions & limitations →
Related reading
Guides to interpret the decision and its assumptions.
- Business Borrowing: Repayment and Cash Coverage
Review repayment, total interest, a declared cash-based affordability ceiling and downside debt-service coverage without treating a ratio as lender approval.
Read guide
Frequently asked questions
How do I compare periodic loan repayments and total interest across financing terms?
Compare the periodic payment with a cash-flow forecast for the same dates before accepting the facility.
Which planning assumptions should I stress-test?
Compare a plausible alternative scenario and verify the decision-critical assumption that changes the plan most.