Maple Components has a fictional C$500,000 line and C$800,000 of unpaid invoices. Its owner needs C$90,000 for a payment. The worksheet below produces only C$64,000 of quantitative headroom. A second check finds that even this smaller amount would arrive too late under one stipulated timetable.
Every company, amount, date, document and person in this example is invented. It is a teaching exercise for a Canadian-dollar request, not a lender’s offer or an assessment of anyone’s eligibility.
The OCC’s U.S. supervisory handbook describes agreement-defined eligibility, advance rates and reporting. Its availability framework compares the borrowing base with the commitment, then accounts for facility use and blocks. It is a general reference here, not Canadian lending rules. Reserve order and funding conditions must come from the applicable terms.
Open Maple’s November file
Controller Jo prepares certificate BBC-01 using a November 19, 2026, 5 p.m. Toronto snapshot. Treasury lead Eli records a C$90,000 request for November 20 at 9 a.m. The payment needs usable funds by 10 a.m.
Maple’s invented agreement uses receivables alone. No inventory or property enters the calculation. Its rate is 80% of the final eligible invoice pool. A single C$40,000 reserve comes off that advanced amount before comparison with the C$500,000 ceiling. Existing use consists of C$300,000 in loans and a separate C$20,000 letter-of-credit amount. These two items do not overlap.
Those are stipulated terms, including the treatment of the letter of credit. There are no other usage items, fees, accrued interest, currencies or movements in the base example. The contemplated C$90,000 request has not been drawn and is not part of existing use.
Put each invoice in one row
Jo’s fictional invoice export has five mutually exclusive pools:
Customer A: current, undisputed, domestic. Gross amount C$220,000. Excluded before customer cap C$0. Amount left C$220,000.
Other customers: current, undisputed, domestic. Gross amount C$380,000. Excluded before customer cap C$0. Amount left C$380,000.
Other customers: overdue. Gross amount C$100,000. Excluded before customer cap C$100,000. Amount left C$0.
Other customers: disputed. Gross amount C$40,000. Excluded before customer cap C$40,000. Amount left C$0.
Other customers: foreign. Gross amount C$60,000. Excluded before customer cap C$60,000. Amount left C$0.
Total. Gross amount C$800,000. Excluded before customer cap C$200,000. Amount left C$600,000.
The fictional terms exclude the last three pools entirely. This does not establish that those descriptions always make an invoice ineligible. No invoice appears in two excluded pools, and no amount has yet been removed for customer concentration.
Maple’s invented concentration rule admits at most C$150,000 of Customer A’s otherwise eligible invoices. It is a fixed dollar cap, applied once after the exclusions. There is no percentage denominator to recalculate. Other customers are stipulated to be below their applicable caps.
Customer A’s excess is C$220,000 − C$150,000 = C$70,000. Removing that excess leaves C$600,000 − C$70,000 = C$530,000. The check by customer gives the same answer: C$150,000 from A plus C$380,000 from the other customers.
Follow the C$90,000 request
With Maple’s stipulated sequence, the bridge is:
Advance the eligible pool: C$530,000 × 80% = C$424,000.
Deduct the one reserve: C$424,000 − C$40,000 = C$384,000.
Compare C$384,000 with the C$500,000 facility ceiling. The smaller amount is C$384,000.
Subtract existing use: C$384,000 − C$300,000 − C$20,000 = C$64,000.
Compare the request: C$90,000 − C$64,000 = C$26,000 short.
Subtracting use from the headline limit alone would give C$180,000. That answer skips Maple’s lower collateral calculation. Deducting the C$40,000 reserve again would make the opposite mistake: it is already included in the C$384,000 subtotal.
Jo records a C$26,000 amount gap against this particular request. She does not enter C$64,000 as money in Maple’s bank account. This worksheet contains no other cash or borrowing sources, so it cannot establish Maple’s total liquidity.
Change one assumption at a time
More eligible invoices: the ceiling takes over
In the first independent countercase, replace the final eligible pool with C$900,000. Keep the rate, reserve, facility ceiling and C$320,000 existing use unchanged.
C$900,000 × 80% − C$40,000 = C$680,000. The smaller of C$680,000 and C$500,000 is now C$500,000. After C$320,000 of use, headroom is C$180,000.
If a C$90,000 draw were confirmed and made under these fictional conditions, it would leave C$90,000 of headroom. That conditional calculation does not confirm a transfer or its arrival time.
A larger reserve: preserve the negative result
Return to the original C$530,000 eligible pool. Change only the reserve to C$110,000.
C$424,000 − C$110,000 = C$314,000. Subtract C$320,000 of existing use and the signed result is negative C$6,000. Positive headroom is zero, with a separate C$6,000 deficit.
Eli keeps both entries. Replacing the signed result with a lone zero would hide the difference he needs to discuss. Nothing in this invented calculation establishes default, a repayment demand or a cure obligation. Those questions remain outside the example.
A late certificate: the clock defeats the request
Return again to the original C$64,000 headroom. Add this fictional processing condition: the certificate must be accepted by 8:30 a.m. for funds to arrive by 10 a.m.
Maple submits its request at 9 a.m. Certificate acceptance occurs at 9:15 a.m., and the next stipulated funding time is 2 p.m. All times are Toronto time on November 20. No funds from this request arrive by 10 a.m.
Reducing the request to C$64,000 does not fix that clock. The C$26,000 amount gap and the missed funding deadline are separate results. A 2 p.m. credit cannot be used for this stipulated 10 a.m. payment. This is not an actual lender’s timetable or a claim about Maple’s other cash.
Pending advances consume availability only when the applicable terms, confirmed with the lender, treat them as use. Check whether the amount is already included before subtracting it.
Give the open questions an owner
In Maple’s November 19 review, Jo attaches invoice export AR-01, certificate BBC-01 and fictional agreement schedule FAC-01. She records C$800,000 gross, C$200,000 of exclusions and C$70,000 above the Customer A cap. Her next check is whether every row matches the stated snapshot and whether any invoice was removed twice.
Eli attaches usage record USE-01. It identifies the C$300,000 loans and the nonduplicative C$20,000 letter-of-credit usage. His questions are specific: does this record match the certificate time, and has another applicable use or reserve changed? The unchanged-input assumption is visibly marked as such.
Owner Amira’s decision record says: “C$90,000 needed by November 20, 10 a.m. Base calculation: C$64,000; amount gap: C$26,000. Funding timing unconfirmed.” Jo owns the calculation questions. Eli owns confirmation of acceptance and the funding timetable. Their next checkpoint is before any commitment that relies on this draw.
If the timing countercase is confirmed, Eli updates the record to “no credit from this request by 10 a.m.” He retains the earlier version and the confirming message. The record does not prescribe another borrowing product or tell Amira which business payment to make. It identifies the missing amount and time evidence.
Before their checkpoint, Eli finds a separate C$15,000 request, ADV-02, awaiting posting. He records its identifier, amount, status and last update beside USE-01. The original C$90,000 request is still merely contemplated and remains outside the base example’s C$320,000 existing use.
For ADV-02, Eli records two questions: what treatment do the applicable terms and lender confirmation establish, and does USE-01 already include it? If the confirmed answer is additional applicable use, Maple’s C$64,000 result falls to C$49,000. If it is already included in C$320,000, subtracting it again would understate the result by C$15,000. If the treatment is unresolved, Eli marks the request bridge unconfirmed. He does not convert a missing answer into either an extra deduction or an assumed zero.
Jo retains BBC-01; Eli attaches the pending-request record and confirming response when available. Their revised bridge carries a new version and the time of the check, so the hypothetical C$49,000 result cannot be mistaken for the unchanged base case.
When the file has only two numbers
Suppose Amira brings only the C$500,000 limit and C$800,000 invoice total. The answer remains unknown. Maple’s example cannot be completed without the stipulated exclusions, cap, rate, reserve and usage. Jo leaves those lines blank rather than copying the favourable assumptions from this teaching worksheet.
Her request for information lists the missing line, the document expected to resolve it, the responsible person and the next check. “Terms unconfirmed” is a useful answer when it prevents an unsupported amount from entering the payment plan.
Copyable worksheet
Identity: Entity ______. Currency ______. Facility and version ______. Prepared by ______. Review date/time ______.
Snapshot: Invoice export/reference ______. Cutoff ______. Certificate/version ______. Submitted ______. Accepted or pending ______. Evidence ______.
Pool — repeat each row: Invoice/customer IDs ______. Gross amount ______. Stated exclusion and document ______. Amount removed ______. Duplicate-removal check ______. Amount remaining ______.
Customer cap: Customer ______. Exact fictional or actual rule ______. Fixed amount or specified denominator ______. Calculation order ______. Excess removed ______. Evidence ______.
Bridge: Final pool ______ × stated rate ______ = advanced amount ______. Each reserve and its specified placement ______. Result ______. Ceiling comparison ______. Each separate use/reference ______. Signed result ______. Positive amount ______. Negative difference retained ______.
Pending item — repeat each: Request/reference ______. Amount ______. Status and update time ______. Confirmed availability treatment ______. Applicable terms and lender evidence ______. Already included in usage? ______. Single adjustment or unresolved ______. Owner/next check ______.
Request and clock: Requested amount ______. Request time ______. Needed cleared-credit time ______. Acceptance/processing evidence ______. Earliest confirmed funding time ______. Amount gap ______. Timing gap ______.
Decision: Assumptions still open ______. Record owner ______. Evidence needed ______. Next checkpoint ______. Confirmed change/version ______. Amount that can be supported for this request and date, or unresolved status ______.
For the separate step after funding, use our guide to reconciling financing proceeds to usable cash to match the bank credit and identify cash available for a payment.
For general information and education, not legal, tax, investment or valuation advice. Examples are illustrative and do not predict your business’s value, financing terms or sale outcome. Consult qualified advisers about your situation.
Subscribe to Deal Flow Canada for practical owner guides and Canadian deal updates.


