Business Line of Credit Calculator & Cash Flow Planner

Build a scheduled working-capital borrowing plan and see how two revolving offers fund it. Enter fixed limits, interest rates, unused-line fees and an opening fee for each offer. Then schedule principal draws and repayments on the dates they will occur. See the credit limit needed to fund all requests, follow daily outstanding principal, and review calendar-period cash charges before inspecting the payoff amount.

Working capital

Compare two revolving credit offers

See which offers fund each draw, what fees you pay while the line is open, and how much cash it takes to close.

Choose a borrowing plan

The examples are illustrative. Enter your dates and offer terms. Start with zero principal and add any opening draw to the event list.

The comparison ends before accrual on this date.

Funding, cost and cash to close

Offer A costs $3,436.65 with $0.00 unfilled. Offer B costs $3,719.02 with $0.00 unfilled.

Offer A

Total borrowing cost

$3,436.65

$3,077.85 interest · $58.80 unused fees · $300.00 opening fee

Draws funded
$105,000.00
Unfilled draws
$0.00
Peak principal
$85,000.00
Cash to close
$25,000.00

$25,000.00 principal and $0.00 charges due at payoff.

Offer B

Total borrowing cost

$3,719.02

$2,837.70 interest · $231.32 unused fees · $650.00 opening fee

Draws funded
$105,000.00
Unfilled draws
$0.00
Peak principal
$85,000.00
Cash to close
$25,000.00

$25,000.00 principal and $0.00 charges due at payoff.

Offer A costs $282.37 less on the same funded principal path.

The minimum limit that funds every planned draw is $85,000.00. It uses the largest principal reached if every draw is available and each payment applies up to the current balance.

Edit offer terms

Offer A terms
Offer B terms

Use the fixed rates in your scenario. Interest accrues on outstanding principal and the optional unused fee accrues on the difference between that principal and the limit.

Schedule draws and principal payments

Both offers use these requests. The model sorts by date and follows row order for requests on the same date.

Edit 6 scheduled events
Event 1
Event 2
Event 3
Event 4
Event 5
Event 6

Outstanding principal by date

The chart shows principal after each day’s events and before cash charges. The final point is before the modeled payoff.

Offer A · solidOffer B · dashed

Shared vertical scale from $0 to $125,000.00. Faint guides mark each offer’s limit.

Step chart of outstanding principal for both offersDaily balance before payoff. Selected period closes at $65,000.00 for Offer A and $65,000.00 for Offer B. The period ledger gives the exact balances.
2026-01-01 opening2026-07-01 payoff

Offer A · 2026-01-31

$65,000.00 principal · $35,000.00 available

$416.88 interest + $12.47 unused fee = $429.35 cash charges

$65,000.00 drawn · $0.00 principal repaid

Offer B · 2026-01-31

$65,000.00 principal · $60,000.00 available

$384.35 interest + $45.77 unused fee = $430.12 cash charges

$65,000.00 drawn · $0.00 principal repaid

Review the cash and principal ledger

Calendar cash charges and closing principal
Charge dateDays accruedA cash chargesB cash chargesA principalB principal
2026-01-3131$429.35$430.12$65,000.00$65,000.00
2026-02-2828$500.69$488.46$45,000.00$45,000.00
2026-03-3131$732.47$698.52$85,000.00$85,000.00
2026-04-3030$806.77$762.71$50,000.00$50,000.00
2026-05-3131$412.16$414.90$25,000.00$25,000.00
2026-06-3030$255.21$274.31$25,000.00$25,000.00
Event funding and payments
Requested and applied amounts
Date and actionRequestedA appliedA unappliedB appliedB unapplied
2026-01-05 · draw$35,000.00$35,000.00$0.00$35,000.00$0.00
2026-01-20 · draw$30,000.00$30,000.00$0.00$30,000.00$0.00
2026-02-15 · principal payment$20,000.00$20,000.00$0.00$20,000.00$0.00
2026-03-10 · draw$40,000.00$40,000.00$0.00$40,000.00$0.00
2026-04-30 · principal payment$35,000.00$35,000.00$0.00$35,000.00$0.00
2026-05-20 · principal payment$25,000.00$25,000.00$0.00$25,000.00$0.00

Opening charges are paid separately. Principal payments above the available balance are left unapplied. No charges are added to principal.

Export the comparison

Save both sets of terms, daily requests as applied, and monthly interest, unused-line fees, and outstanding principal.

Download business line CSV
Selectable business line CSV copy

How to use this calculator

  1. Select Working capital draw cycle or Seasonal funding shortfall, then replace the opening date and payoff date with your intended comparison window.
  2. Open both offer panels. Enter the credit limit, fixed interest rate, unused fee rate, opening cash fee and day-count basis for each plan.
  3. Open the event schedule. Add dated draw and principal payment amounts. If two requests share a date, arrange them in the order they should apply.
  4. Review funded draws, unfilled amounts, estimated borrowing cost and cash to close. Inspect a calendar accrual period on the chart to see its principal and charges.
  5. Review the charge and event ledger. Download the CSV to keep the terms, event-level decisions, and charges together.

The Formula

The mathematical logic powering this calculation is:

Start with zero debt on the opening date. Each date up to and including the day before payoff accrues under the modeled offer. Dates use an actual Gregorian calendar with no banking-day adjustments. Requests sort by date and stay in entered order if dates match. A draw applies the lesser of the requested amount and remaining credit limit. A principal payment applies up to the outstanding principal. Enter an opening draw explicitly if needed.
First apply every event for the day. Daily interest = that day’s post-event principal × entered annual interest rate ÷ selected denominator. Daily unused-limit fee = (credit limit − that day’s principal) × entered annual unused fee rate ÷ the same denominator. Actual/360 uses 360 and Actual/365 uses 365 in every year. Both count real days, including Feb 29 when applicable. Rates and limits remain fixed for the modeled period.
Sum each category across its calendar accrual period. Interest and unused fees round separately to the nearest cent with half cents rounded upward. Calendar month-end charges are cash payments on the last day of the month. A final partial period settles at payoff. A separately entered opening charge is cash paid at opening. Charges do not compound or reduce borrowing capacity.
Borrowing cost = opening fee + all settled or payable interest + all settled or payable unused fees. The balance due at payoff = remaining principal + final partial-period charges after the last completed month. No events or charges accrue on the selected payoff day. A payoff on the first of a month leaves the prior month’s charges already paid in this model.
Minimum limit for the draw plan equals the maximum principal after any request when every draw is assumed funded and every principal payment is capped at the balance. This includes same-day events before later payments. The chart shows the balance after all events on each day. A cost winner is reported only when every funded draw and applied payment matches by event. If funding differs, inspect the date, size and consequences of each unfilled draw.
Enter 0 to 60 dated events. Dollar inputs allow two decimal places. Limits and each draw or principal payment allow $0.01 to $10,000,000. An opening fee allows $0 to $10,000,000. Annual interest and unused-fee rates allow 0% to 100% with up to two decimals. Enter valid dates from 2000 through 2099 and a payoff date 1 to 730 days after opening. Keep each request within the modeled date window.
The FDIC’s small-business financing materials explain borrowing, repayment and renewed availability under a revolving credit limit. The SBA 7(a) overview describes its Working Capital Pilot for monitored lines of credit. This planner uses entered terms. Contractual minimum payments, late fees, rates that reset, draw conditions, covenants, taxes and credit eligibility require separate evaluation.

Worked Example

If you input:

  • Opening and payoff dates: January 1 and July 1, 2026
  • Offer A terms: $100,000 limit, 11.50% interest, 0.25% unused fee, $300 opening, Actual/360
  • Offer B terms: $125,000 limit, 10.75% interest, 0.65% unused fee, $650 opening, Actual/365
  • Draw requests: January 5 $35,000, January 20 $30,000, March 10 $40,000
  • Principal payments: February 15 $20,000, April 30 $35,000, May 20 $25,000

Result:

Both offers fund $105,000 across three draws and apply $80,000 of principal payments. Peak principal is $85,000, the minimum credit limit that funds the plan. Both require $25,000 for payoff after the June charges have been paid. Offer A pays $3,077.85 of interest, $58.80 of unused fees and $300 opening, for $3,436.65 total cost. Offer B pays $2,837.70 interest, $231.32 unused fees and $650 opening, for $3,719.02 total. Offer A costs $282.37 less on the same funded principal path.

Frequently Asked Questions

Why can the line with the lower interest rate cost more?

The interest rate applies only to utilized principal. The day-count basis, opening cash fee and fee on unused capacity can change which modeled offer costs less.

Do principal payments restore credit availability?

The modeled principal payment reduces the current balance. The maximum new draw increases by the same amount until the line reaches its full entered limit.

How do I schedule a payment and draw on one date?

Place them in the desired order in the event editor. A principal payment placed before the draw can free credit that the same-day draw can use. Interest and unused fees use the balance after all events that day.

When are unused-line fees charged?

The worksheet applies the entered annual unused percentage to each day’s difference between the line limit and outstanding principal. The resulting charge settles monthly and at the end of any final partial period.

Why is there no lowest-cost offer when funding differs?

A smaller balance can cost less because it funded less of the plan. The event ledger identifies which draws were limited and by how much. Compare the costs on the same funded path after deciding how to cover any shortfall.

What counts toward the payoff amount?

The model retains unpaid principal and charges that accrue after the most recent calendar month end. The cash opening fee and past monthly charges were already paid. Enter the planned closure or contractual maturity date for the scenario you want to examine.

Similar Calculators