Compare Fixed Draw Fees With Interest on a Business Line

Two small draws may incur fees large enough to materially change the modeled financing cost. The worksheet for this decision tracks combined draw interest and fees and keeps the other amounts visible so you can reconcile the estimate with your own paperwork. The worked example uses fictional figures in U.S. dollars. Replace them with confirmed values for your own business cash flow and financing decision before relying on the comparison.

Start with the documents you can reconcile

Use the date each draw cleared and the date you expect to repay it. Count the days each amount stays outstanding separately, even if the draws overlap. Use the credit agreement’s actual day basis for a statement reconciliation. For a business, use cash receipts instead of invoice dates when deciding whether a payment can be covered. Mark whether cash is unrestricted, whether a draw has actually funded and whether a supplier requires payment before delivery. Ask whoever maintains your ledger to reconcile the amounts to bank activity. Keep a separate operating reserve if payroll or taxes must be protected.

Keep an estimate column and a confirmed column while you gather the inputs. A blank line should mean you are still waiting for a number, while a zero should mean you confirmed no amount applies. If the number is unsettled, run a range or a separate downside case instead of entering zero in a way that makes the decision appear cheaper. Record the date of each figure so it is clear when to refresh the worksheet.

Worked example with two scenarios

The reference case uses the calculator’s starting values. This guide tests what happens when you change first draw from $16,000.00 to $5,500.00 and second draw from $9,000.00 to $4,100.00 and total cash-paid fees from $150.00 to $220.00. All unchanged inputs are kept at their reference values, so the difference below reflects the specified changes. The table shows the inputs to compare before you interpret any of the totals.

In the reference case, combined draw interest and fees is $438.41, with interest on first draw of $231.45 and interest on second draw of $56.96. In the scenario for this guide it falls to $325.51. Interest on first draw is $79.56, and Interest on second draw is $25.95. The difference in the first row is $112.90 compared with the reference case. Use the secondary rows to see where that difference comes from. They represent components or additional checks, so adding every result together would combine amounts that can describe the same money from different angles.

Ask whether the charge is per draw, per statement or one-time. Match the fee treatment to the expected draw schedule before comparing alternatives.

Assign each balance its own holding period

Adding the two draw amounts and applying the longest holding period to both can overstate carrying interest. Compute interest on the first draw over its own days and then do the same for the second draw. Add any fees separately so you can tell whether timing or transaction charges are driving the total. If a single draw is repaid in installments, divide it into constant-balance segments instead of treating the original amount as outstanding until the last day. Confirm the agreement’s basis and method before using the estimate to challenge a billed amount.

Check which inputs move the result

If total cash-paid fees ($) changes from $220.00 to $242.00, combined draw interest and fees rises to $347.51. In the same run, the other displayed estimates stay the same. This comparison holds every other entry constant, so it isolates that input. If your offer changes more than one amount at once, put all the revised amounts into a separate scenario and compare the complete set of results.

If days first draw is outstanding changes from 48 to 53, combined draw interest and fees rises to $333.80. In the same run, interest on first draw becomes $87.85. This comparison holds every other entry constant, so it isolates that input. If your offer changes more than one amount at once, put all the revised amounts into a separate scenario and compare the complete set of results.

If first draw ($) changes from $5,500.00 to $6,050.00, combined draw interest and fees rises to $333.47. In the same run, interest on first draw becomes $87.52. This comparison holds every other entry constant, so it isolates that input. If your offer changes more than one amount at once, put all the revised amounts into a separate scenario and compare the complete set of results.

A small change that produces no movement in the headline result can still be worth noting. Some worksheets apply a cap or floor, and the first row may stay flat until an input crosses it. Look at the secondary amounts and test the actual limit rather than extrapolating from one small change. Save the reference settings first so that a later comparison starts from the same assumptions.

What this worksheet assumes

Adds simple interest for two draw amounts under the same rate and a 365-day basis, plus entered fees. It does not model rate changes, repayments during each interval or daily compounded interest.

The output uses the values you supply and rounds displayed amounts for readability. A lender, school, vendor or other party may use different dates, fees, credit treatment or rounding. If a statement and the estimate disagree, first check that the figures refer to the same dates and the same underlying balance. Then separate formula differences from missing cash items. This makes it easier to ask a targeted question about a particular line rather than trying to reconcile a single total.

Before you act on the estimate

Ask about fees that apply to each draw or only to the whole line. If the balance changes partway through, model the intervals separately. The lender statement remains the source for billed amounts.

Take the scenario closest to your actual situation and put the opening cash, dated receipts and dated obligations in order. Flag any entry you cannot confirm and identify the first payment that depends on it. If a supplier, lender or other party changes that figure, update that entry first and rerun the comparison. Save both versions with the dates they were prepared so another person can see what changed and which documents support the revision.

If two alternatives are close, check what would make their order switch. For example, one alternative may depend on an unconfirmed fee or receipt, while the other depends on a date or rate you already have in writing. The sensitivity runs above help distinguish a difference that survives a small revision from one that disappears when the input moves. In your final notes, state what you verified and which assumptions still need a quote or statement.

What should I do if I only have a rough figure?

Use the rough amount as a labeled starting point and run a second version using a plausible less favorable amount. Keep the exact written quote when it arrives and replace the estimate. If the updated figure changes the headline result but leaves the earliest payment unchanged, still check that the cash is available by the relevant date. If both the amount and the date change, update the payment calendar as well as the worksheet.

When should I run the numbers again?

Recalculate when a fee, installment, credit, cost or payment date changes, and once more when you have the paperwork that will govern the decision. Use the same units and time window in both versions. If the only change is timing, keep the amount the same in your first comparison so you can see that effect separately. Compare the new result with the written figures rather than carrying forward an older estimate.

Open the Business Line Two Draw Interest Calculator to substitute your own inputs. Estimate Interest When a Second Credit Line Draw Is Held for Fewer Days covers another scenario for the same worksheet. See also the SBA small-business loan programs for background on business cash flow and financing.