Skip to main content

    Clarity before commitment

    Working capital planner

    Model an opportunity, test slower sales and spot potential cash shortages.

    Free to use · No signup required · Educational estimates

    Model your opportunity

    Amount available after any deductions.

    All incremental costs to complete one order or sales cycle.

    For example, buy inventory in month 1 and sell at the end of month 2.

    Opportunity & cash flow

    Projected profit before tax
    $45,000.00
    Additional cash required
    $0.00
    Ending project cash
    $45,000.00
    Uncollected sales at end
    $0.00
    Completed business cycles
    6
    Financing cost
    $15,000.00

    No cash shortage appears under these assumptions. Keep a separate allowance for overhead, taxes and unexpected costs.

    What if customers pay later?

    Stress scenario: sales fall 10% and collection takes one extra month. Costs and repayments stay the same.

    Profit before tax
    $27,000.00
    Additional cash required
    $16,166.70
    Ending project cash
    $0.00

    Month-by-month project cash

    Base scenario cash flow. Negative balances require additional cash.
    MonthCycle costsCash collectedRepaymentEnding cash
    1$20,000.00$0.00$5,416.67$24,583.33
    2$0.00$30,000.00$5,416.67$49,166.66
    3$20,000.00$0.00$5,416.67$23,749.99
    4$0.00$30,000.00$5,416.67$48,333.32
    5$20,000.00$0.00$5,416.67$22,916.65
    6$0.00$30,000.00$5,416.67$47,499.98
    7$20,000.00$0.00$5,416.67$22,083.31
    8$0.00$30,000.00$5,416.67$46,666.64
    9$20,000.00$0.00$5,416.67$21,249.97
    10$0.00$30,000.00$5,416.67$45,833.30
    11$20,000.00$0.00$5,416.67$20,416.63
    12$0.00$30,000.00$5,416.63$45,000.00

    The cash requirement also includes shortages immediately after paying cycle costs, which can be larger than a month-end shortage.

    Profit and cash answer different questions

    In the hypothetical example, each two-month cycle costs $20,000 and produces $30,000 in sales. Six cycles produce a $60,000 operating margin. After $15,000 in financing costs, projected profit is $45,000 before tax. If collections slip, that profit may still be tied up in unpaid customer invoices when repayments are due.

    What does this planner assume?

    This models only the incremental opportunity, with no opening cash beyond the net funding entered. A new cycle starts as soon as the previous cycle finishes, even if its customer has not paid. Costs are paid at the start of the cycle; sales are collected at the end plus any delay. Only cycles that finish within the repayment period are started.

    Repayments are equal monthly amounts rounded to cents, with a final adjustment. Within each month, the model pays cycle costs, collects sales, then makes the repayment. Actual daily or weekly debits can require more cash. Taxes, existing business cash flows and overhead outside the entered costs are excluded. This is a scenario, not a forecast or funding recommendation.

    Prepare for your next step

    Ready to explore your options?

    Bring your questions and your numbers. A Bizlendia advisor can walk through available funding options with you.

    Start an application