Act on the result
Compare the maximum payment with a dated cash-flow forecast before requesting a 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
Owners setting a prudent borrowing ceiling from cash available for scheduled debt service.
Outputs
Maximum payment each period and maximum principal under the entered coverage, rate and term.
Start here
Use cash available in one payment period and choose a conservative minimum coverage ratio.
Use a different tool when: Do not use this to compare periodic loan repayments and total interest across financing terms; use Business Loan Repayment Planner for that decision. Use this tool to set a borrowing ceiling from available cash flow and downside cover.
Cash & growth
Business Loan Affordability: maximum payment each period and maximum principal under the entered coverage
Maximum payment each period and maximum principal under the entered coverage, rate and term.
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
Cash the business can allocate to scheduled debt payments in one payment period. Use one consistent currency and time basis.
User-selected cash cover required above each scheduled payment.
Nominal annual rate used only for this stress test.
Equal payment periods in one year.
Whole number of scheduled payment periods.
Bounded stress reduction applied to available cash.
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.
- Base maximum principal
- 24,000.00
- Base Maximum Periodic Payment
- 1,000.00
- Downside Maximum Periodic Payment
- 800.00
- Downside Maximum Principal
- 19,200.00
- Principal Ceiling Reduction
- 4,800.00
- Input Coverage Ratio
- 1.2×
The chart and accessible scenario table use the same exact engine evaluations.
Base maximum principal
| Downside cash reduction | Base maximum principal |
|---|---|
| 0.2 (current) | 24,000.00 |
| 0.19 | 24,000.00 |
| 0.21000000000000002 | 24,000.00 |
Scenario comparison
Each row names the assumption axis changed from the baseline.
ScenarioResultDifference
Current scenario24,000.00Baseline
Lower Downside cash reduction24,000.000.00
Higher Downside cash reduction24,000.000.00
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.
Base maximum principal
Base Maximum Principal
present value of base maximum payments24,000.00Result24,000.00
Uses one consistent market-neutral ex-tax basis and planning period. The engine retains full precision; only presentation is rounded.
Business Loan Affordability Planner formulas →Inputs used by these formula steps
- Base Maximum PrincipalCash Available For Debt Service Per Period
- 1,200
- Base Maximum PrincipalMinimum Coverage Ratio
- 1.2
- Base Maximum PrincipalAnnual Interest Rate
- 0
- Base Maximum PrincipalPayments Per Year
- 12
- Base Maximum PrincipalTotal Payments
- 24
- Base Maximum PrincipalDownside Cash Reduction Rate
- 0.2
Base Maximum Periodic Payment
Base Maximum Periodic Payment
base cash available ÷ minimum coverage ratio1,000.00Result1,000.00
Uses one consistent market-neutral ex-tax basis and planning period. The engine retains full precision; only presentation is rounded.
Business Loan Affordability Planner formulas →Inputs used by these formula steps
- Base Maximum Periodic PaymentCash Available For Debt Service Per Period
- 1,200
- Base Maximum Periodic PaymentMinimum Coverage Ratio
- 1.2
- Base Maximum Periodic PaymentAnnual Interest Rate
- 0
- Base Maximum Periodic PaymentPayments Per Year
- 12
- Base Maximum Periodic PaymentTotal Payments
- 24
- Base Maximum Periodic PaymentDownside Cash Reduction Rate
- 0.2
Downside Maximum Periodic Payment
Downside Maximum Periodic Payment
downside cash available ÷ minimum coverage ratio800.00Result800.00
Uses one consistent market-neutral ex-tax basis and planning period. The engine retains full precision; only presentation is rounded.
Business Loan Affordability Planner formulas →Inputs used by these formula steps
- Downside Maximum Periodic PaymentCash Available For Debt Service Per Period
- 1,200
- Downside Maximum Periodic PaymentMinimum Coverage Ratio
- 1.2
- Downside Maximum Periodic PaymentAnnual Interest Rate
- 0
- Downside Maximum Periodic PaymentPayments Per Year
- 12
- Downside Maximum Periodic PaymentTotal Payments
- 24
- Downside Maximum Periodic PaymentDownside Cash Reduction Rate
- 0.2
Downside Maximum Principal
Downside Maximum Principal
present value of downside maximum payments19,200.00Result19,200.00
Uses one consistent market-neutral ex-tax basis and planning period. The engine retains full precision; only presentation is rounded.
Business Loan Affordability Planner formulas →Inputs used by these formula steps
- Downside Maximum PrincipalCash Available For Debt Service Per Period
- 1,200
- Downside Maximum PrincipalMinimum Coverage Ratio
- 1.2
- Downside Maximum PrincipalAnnual Interest Rate
- 0
- Downside Maximum PrincipalPayments Per Year
- 12
- Downside Maximum PrincipalTotal Payments
- 24
- Downside Maximum PrincipalDownside Cash Reduction Rate
- 0.2
Principal Ceiling Reduction
Principal Ceiling Reduction
base maximum principal − downside maximum principal4,800.00Result4,800.00
Uses one consistent market-neutral ex-tax basis and planning period. The engine retains full precision; only presentation is rounded.
Business Loan Affordability Planner formulas →Inputs used by these formula steps
- Principal Ceiling ReductionCash Available For Debt Service Per Period
- 1,200
- Principal Ceiling ReductionMinimum Coverage Ratio
- 1.2
- Principal Ceiling ReductionAnnual Interest Rate
- 0
- Principal Ceiling ReductionPayments Per Year
- 12
- Principal Ceiling ReductionTotal Payments
- 24
- Principal Ceiling ReductionDownside Cash Reduction Rate
- 0.2
Input Coverage Ratio
Input Coverage Ratio
visible user-entered minimum coverage ratio1.2 ratioResult1.2×
Uses one consistent market-neutral ex-tax basis and planning period. The engine retains full precision; only presentation is rounded.
Business Loan Affordability Planner formulas →Inputs used by these formula steps
- Input Coverage RatioCash Available For Debt Service Per Period
- 1,200
- Input Coverage RatioMinimum Coverage Ratio
- 1.2
- Input Coverage RatioAnnual Interest Rate
- 0
- Input Coverage RatioPayments Per Year
- 12
- Input Coverage RatioTotal Payments
- 24
- Input Coverage RatioDownside Cash Reduction Rate
- 0.2
Inputs used
- Cash available for debt service each period
- 1,200
- Minimum coverage ratio
- 1.2
- Annual interest rate
- 0
- Payments per year
- 12
- Total payments
- 24
- Downside cash reduction
- 0.2
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 used only for this stress test. | decimal nominal annual loan interest rate (1 = 100%) | 0 to 1 | Required | 0 |
| cashAvailableForDebtServicePerPeriod | Cash the business can allocate to scheduled debt payments in one payment period. Use one consistent currency and time basis. | currency units/payment period | 0 to 100000000 | Required | 1200 |
| downsideCashReductionRate | Bounded stress reduction applied to available cash. | decimal fraction of cash available per payment period removed in the downside scenario (1 = 100%) | 0 to 1 | Required | 0.2 |
| minimumCoverageRatio | User-selected cash cover required above each scheduled payment. | decimal cash-coverage ratio: cash available / scheduled payment | 1 to 20 | Required | 1.2 |
| paymentsPerYear | Equal payment periods in one year. | whole scheduled payment periods/year | 1 to 365 | Required | 12 |
| totalPayments | Whole number of scheduled payment periods. | whole scheduled payment periods/loan term | 1 to 1200 | Required | 24 |
Business Loan Affordability: maximum payment each period and maximum principal under the entered coverage
The ceiling is a cash-cover stress test, not a lender eligibility or approval result.
Formula summary
- Primary formula
- present value of base maximum payments
Data used here
- The estimate uses your inputs and the general business formula documented in the methodology.
Decision checks
Stress-test the decision
Retest with less available cash, a higher rate and a higher coverage requirement.
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.
- The ceiling is a cash-cover stress test, not a lender eligibility or approval result.
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 set a borrowing ceiling from available cash flow and downside cover?
Compare the maximum payment with a dated cash-flow forecast before requesting a facility.
Which planning assumptions should I stress-test?
Compare a plausible alternative scenario and verify the decision-critical assumption that changes the plan most.