Working Capital Calculator: Cash Left After Short Bills

Is $50,000.00 the right working capital for $150,000 and $100,000?

On the defaults — $150,000.00 of current assets and $100,000.00 of current liabilities, with a $75,000.00 target — working capital is $50,000.00, the working capital ratio is 1.50, the current assets needed for the target are $175,000.00, and the most current liabilities the target allows are $75,000.00. Working capital is current assets minus current liabilities, both measured at the same date. It is the cash cushion a business has to pay its short-term bills and fund day-to-day operations. Positive working capital means the business can cover its near-term obligations; negative working capital means short-term bills exceed short-term assets — the business is leaning on future sales or borrowing to stay afloat. The working capital ratio says the same thing as a multiple: 1.50 means $1.50 of short-term assets for every $1.00 of short-term bills. Lenders and suppliers watch working capital alongside the current and quick ratios before extending credit. Too much working capital can mean idle cash sitting on the balance sheet; too little means fragility at the first slow month.

Four things about the model are worth stating plainly. First, the working capital is the current assets minus the current liabilities — $150,000.00 − $100,000.00 = $50,000.00. Second, the working capital ratio is the current assets divided by the current liabilities — $150,000.00 ÷ $100,000.00 = 1.50. Third, the current assets needed at the target are the target plus the current liabilities — $75,000.00 + $100,000.00 = $175,000.00. And fourth, the most current liabilities allowed at the target are the current assets minus the target — $150,000.00 − $75,000.00 = $75,000.00; all listed in Accuracy & limitations.

The worked example, line by line

Setup: $150,000.00 of current assets, $100,000.00 of current liabilities, target working capital $75,000.00.

Line 1 — the working capital. The working capital is $150,000.00 − $100,000.00 = $50,000.00.

Line 2 — the working capital ratio. The ratio is $150,000.00 ÷ $100,000.00 = 1.50 — $1.50 of short-term assets for every $1.00 of short-term bills.

Line 3 — the shortfall. The shortfall to the $75,000.00 target is $75,000.00 − $50,000.00 = $25,000.00.

Line 4 — the current assets needed. The current assets needed at the target are $75,000.00 + $100,000.00 = $175,000.00.

Line 5 — the most current liabilities allowed. The most current liabilities the target allows are $150,000.00 − $75,000.00 = $75,000.00.

Line 6 — the check. $50,000.00 + $100,000.00 = $150,000.00, the current assets; and $175,000.00 − $100,000.00 = $75,000.00, the target.

Every branch, checked

Current liabilities $50,000: Working capital $100,000.00; ratio 3.00; current assets needed at the $75,000.00 target $125,000.00; most current liabilities allowed at the $75,000.00 target $75,000.00; $25,000.00 above the $75,000.00 target — Halving the current liabilities to $50,000.00 doubles the working capital to $100,000.00 and the ratio to 3.00 — the business holds $3.00 of short-term assets for every $1.00 of short-term bills, and may be sitting on idle cash.

Current assets $200,000: Working capital $100,000.00; ratio 2.00; current assets needed at the $75,000.00 target $175,000.00; most current liabilities allowed at the $75,000.00 target $125,000.00; $25,000.00 above the $75,000.00 target — With $200,000.00 of current assets the working capital rises to $100,000.00 and the ratio to 2.00 — comfortably above the $75,000.00 target, $25,000.00 to spare.

Current assets $120,000: Working capital $20,000.00; ratio 1.20; current assets needed at the $75,000.00 target $175,000.00; most current liabilities allowed at the $75,000.00 target $45,000.00; $55,000.00 short of the $75,000.00 target — With $120,000.00 of current assets the working capital falls to $20,000.00 and the ratio to 1.20 — the business is $55,000.00 short of the $75,000.00 target.

Current liabilities $150,000: Working capital $0.00; ratio 1.00; current assets needed at the $75,000.00 target $225,000.00; most current liabilities allowed at the $75,000.00 target $75,000.00; $75,000.00 short of the $75,000.00 target — With current liabilities of $150,000.00 the working capital is exactly $0.00 and the ratio is exactly 1.00 — exactly zero working capital, so the business holds exactly $1.00 of short-term assets for every $1.00 of short-term bills, with nothing left over.

Current assets $175,000: Working capital $75,000.00; ratio 1.75; current assets needed at the $75,000.00 target $175,000.00; most current liabilities allowed at the $75,000.00 target $100,000.00; exactly at the $75,000.00 target — With $175,000.00 of current assets the working capital is exactly $75,000.00 and the ratio is 1.75 — exactly at the target, not a dollar over or under.

Current liabilities $125,000: Working capital $25,000.00; ratio 1.20; current assets needed at the $75,000.00 target $200,000.00; most current liabilities allowed at the $75,000.00 target $75,000.00; $50,000.00 short of the $75,000.00 target — With current liabilities of $125,000.00 the working capital falls to $25,000.00 and the ratio to 1.20 — $50,000.00 short of the $75,000.00 target.

Current assets $90,000: Working capital $−10,000.00; ratio 0.90; current assets needed at the $75,000.00 target $175,000.00; most current liabilities allowed at the $75,000.00 target $15,000.00; $85,000.00 short of the $75,000.00 target — With $90,000.00 of current assets the working capital is negative — $−10,000.00, ratio 0.90 — so the short-term bills exceed the short-term assets and the business is leaning on future sales or borrowing to stay afloat.

The reverses, worked backwards

Smallest whole-dollar current assets for the working capital to reach $75,000: At the displayed $175,000 the figures are Working capital $75,000.00; ratio 1.75; current assets needed at the $75,000.00 target $175,000.00; most current liabilities allowed at the $75,000.00 target $100,000.00; exactly at the $75,000.00 target. At the displayed $175,000 the working capital is $75,000.00. At $174,999 the working capital is $74,999.00 — $1 short — so $175,000 is the smallest whole-dollar current assets that reaches the $75,000 target.

Smallest whole-dollar current assets for the working capital to reach $100,000: At the displayed $200,000 the figures are Working capital $100,000.00; ratio 2.00; current assets needed at the $100,000.00 target $200,000.00; most current liabilities allowed at the $100,000.00 target $100,000.00; exactly at the $100,000.00 target. At the displayed $200,000 the working capital is $100,000.00. At $199,999 the working capital is $99,999.00, so $200,000 is the smallest whole-dollar current assets that reaches the $100,000 target.

Largest whole-dollar current liabilities for the working capital to STAY at or above $75,000: At the displayed $75,000 the figures are Working capital $75,000.00; ratio 2.00; current assets needed at the $75,000.00 target $150,000.00; most current liabilities allowed at the $75,000.00 target $75,000.00; exactly at the $75,000.00 target. At the displayed $75,000 the working capital is $75,000.00. At $75,001 the working capital is $74,999.00, so $75,000 is the largest whole-dollar current liabilities for the working capital to stay at or above the $75,000 target.

Largest whole-dollar current liabilities for the working capital to STAY at or above $50,000: At the displayed $100,000 the figures are Working capital $50,000.00; ratio 1.50; current assets needed at the $50,000.00 target $150,000.00; most current liabilities allowed at the $50,000.00 target $100,000.00; exactly at the $50,000.00 target. At the displayed $100,000 the working capital is $50,000.00. At $100,001 the working capital is $49,999.00, so $100,000 is the largest whole-dollar current liabilities for the working capital to stay at or above the $50,000 target.

Smallest whole-dollar current assets for the working capital to reach $25,000: At the displayed $125,000 the figures are Working capital $25,000.00; ratio 1.25; current assets needed at the $25,000.00 target $125,000.00; most current liabilities allowed at the $25,000.00 target $100,000.00; exactly at the $25,000.00 target. At the displayed $125,000 the working capital is $25,000.00. At $124,999 the working capital is $24,999.00, so $125,000 is the smallest whole-dollar current assets that reaches the $25,000 target.

Largest whole-dollar current liabilities for the working capital to STAY at or above $100,000: At the displayed $100,000 the figures are Working capital $100,000.00; ratio 2.00; current assets needed at the $100,000.00 target $200,000.00; most current liabilities allowed at the $100,000.00 target $100,000.00; exactly at the $100,000.00 target. At the displayed $100,000 the working capital is $100,000.00. At $100,001 the working capital is $99,999.00, so $100,000 is the largest whole-dollar current liabilities for the working capital to stay at or above the $100,000 target.

What the defaults assume

The defaults are $150,000.00 of current assets, $100,000.00 of current liabilities and a $75,000.00 target — Working capital $50,000.00; ratio 1.50; current assets needed at the $75,000.00 target $175,000.00; most current liabilities allowed at the $75,000.00 target $75,000.00; $25,000.00 short of the $75,000.00 target. With Current liabilities $50,000, Working capital $100,000.00; ratio 3.00; current assets needed at the $75,000.00 target $125,000.00; most current liabilities allowed at the $75,000.00 target $75,000.00; $25,000.00 above the $75,000.00 target. With Current assets $200,000, Working capital $100,000.00; ratio 2.00; current assets needed at the $75,000.00 target $175,000.00; most current liabilities allowed at the $75,000.00 target $125,000.00; $25,000.00 above the $75,000.00 target. With Current assets $120,000, Working capital $20,000.00; ratio 1.20; current assets needed at the $75,000.00 target $175,000.00; most current liabilities allowed at the $75,000.00 target $45,000.00; $55,000.00 short of the $75,000.00 target. With Current liabilities $150,000, Working capital $0.00; ratio 1.00; current assets needed at the $75,000.00 target $225,000.00; most current liabilities allowed at the $75,000.00 target $75,000.00; $75,000.00 short of the $75,000.00 target. With Current assets $175,000, Working capital $75,000.00; ratio 1.75; current assets needed at the $75,000.00 target $175,000.00; most current liabilities allowed at the $75,000.00 target $100,000.00; exactly at the $75,000.00 target. With Current liabilities $125,000, Working capital $25,000.00; ratio 1.20; current assets needed at the $75,000.00 target $200,000.00; most current liabilities allowed at the $75,000.00 target $75,000.00; $50,000.00 short of the $75,000.00 target. With Current assets $90,000, Working capital $−10,000.00; ratio 0.90; current assets needed at the $75,000.00 target $175,000.00; most current liabilities allowed at the $75,000.00 target $15,000.00; $85,000.00 short of the $75,000.00 target. With Current assets $100,000, current liabilities $100,000, Working capital $0.00; ratio 1.00; current assets needed at the $75,000.00 target $175,000.00; most current liabilities allowed at the $75,000.00 target $25,000.00; $75,000.00 short of the $75,000.00 target. With Current liabilities $0, Working capital $150,000.00; ratio — (undefined: no short-term bills to divide by); current assets needed at the $75,000.00 target $75,000.00; most current liabilities allowed at the $75,000.00 target $75,000.00; $75,000.00 above the $75,000.00 target — the ratio cannot be computed, never Infinity or NaN. With Current assets $250,000, Working capital $150,000.00; ratio 2.50; current assets needed at the $75,000.00 target $175,000.00; most current liabilities allowed at the $75,000.00 target $175,000.00; $75,000.00 above the $75,000.00 target. With Current assets $62,500, current liabilities $12,500, Working capital $50,000.00; ratio 5.00; current assets needed at the $75,000.00 target $87,500.00; most current liabilities allowed at the $75,000.00 target $−12,500.00; $25,000.00 short of the $75,000.00 target. With Current assets $123,456, current liabilities $98,765, Working capital $24,691.00; ratio 1.25; current assets needed at the $75,000.00 target $173,765.00; most current liabilities allowed at the $75,000.00 target $48,456.00; $50,309.00 short of the $75,000.00 target — the unrounded ratio is 1.249997, shown as 1.25 after HALF_UP rounding. With Current assets $0, Working capital $−100,000.00; ratio 0.00; current assets needed at the $75,000.00 target $175,000.00; most current liabilities allowed at the $75,000.00 target $−75,000.00; $175,000.00 short of the $75,000.00 target. With Target bars — current assets $150,000, current liabilities $100,000, Current assets needed at the $50,000 target $150,000.00; at the $100,000 target $200,000.00; most current liabilities allowed at the $50,000 target $100,000.00; at the $100,000 target $50,000.00.

Output · formula · meaning

Who uses this

• The small-business owner checking the year-end balance sheet: they learn $150,000.00 of current assets minus $100,000.00 of current liabilities is $50,000.00 of working capital, a ratio of 1.50 — and they check the $175,000 reverse to see the smallest assets that reach the $75,000 target.
• The supplier deciding whether to extend 30-day terms: they learn a ratio of 1.50 means $1.50 of short-term assets for every $1.00 of short-term bills — and they check the $75,000 reverse to see the largest liabilities that keep the cushion at or above the target.
• The owner whose working capital turned negative: they learn the short-term bills exceed the short-term assets — and they check the $125,000 reverse to see the assets that would bring the cushion back to $25,000.
• The founder with $100,000.00 of working capital: they learn the business is $25,000.00 above the $75,000.00 target — and they check the target bars to see the assets and liabilities the $100,000 target allows.

Accuracy & limitations

The math is first-principles: working capital is current assets minus current liabilities, rounded to cents half-up; the working capital ratio is current assets divided by current liabilities, rounded to two decimals half-up; the current assets needed at the target are the target plus the current liabilities; the most current liabilities allowed at the target are the current assets minus the target; the shortfall is the target minus the working capital. The reverses are exact closed forms on whole dollars: the smallest whole-dollar current assets that reach a target are the target plus the current liabilities, and the largest whole-dollar current liabilities that stay at or above a target are the current assets minus the target — the neighbour one dollar away is printed in full so you can see the crossing. What the model cannot do is judge the business: working capital counts the receivables at face value, but bills that never get paid are not cash; the $75,000.00 target is an example, not a rule, and some industries run happily with less; and the cushion says nothing about the long-term debt, the cash flow, or whether the business is profitable. Too much working capital can mean idle cash sitting on the balance sheet; too little means fragility at the first slow month. Use it to see the cash left after the short-term bills — then read the rest of the balance sheet.

Frequently asked questions