This page from Ivyhollow Lending Group in Marshalltown, Iowa shows how to calculate working capital and a cash gap by hand and estimates a loan payment. It is arithmetic on your inputs, not an offer.
Working Capital Calculation for Bank Loan in Marshalltown, IA: Paying for Progress-Billing Gaps
A bank reading a working capital calculation looks first at the balance sheet: current assets minus current liabilities. Illustration only, invented figures: a Marshalltown, IA store with $14,000 in cash, $3,000 owed by customers and $46,000 of stock has $63,000 in current assets. Against invented supplier bills of $21,000, $6,000 of loan payments due within the year and $5,000 of unpaid wages and taxes, $32,000 in all, its invented working capital is $31,000, by our arithmetic.
Illustration only, invented figures: a contractor awaiting a $41,000 progress payment for 5 weeks, with a weekly payroll of $7,600, pays 5 invented payrolls, $38,000, before the draw arrives. The balance sheet can look healthy while that gap still has to be paid in cash.
How to Calculate Working Capital Needed? What It Means for Marshalltown, IA Retailers
Positive working capital does not mean there is cash for this month's bills; much of the store's invented total above is stock. The second calculation is the cash gap: list the bills due over the next few weeks, list the money that will actually arrive by those dates, and subtract.
Illustration only, invented figures: before the holidays the same store has $58,000 of bills due over six weeks and expects $39,000 of cash in over the same weeks, a gap of $19,000, by our arithmetic. Financed at an invented annual rate of 13% over 9 months, a loan for the invented gap would cost about $2,227 a month and about $20,044 in total. Type your own figures into the calculator to test yours.
Inputs the Working Capital Calculator Online Uses for Restaurant Owners
A restaurant's inputs are weekly rather than seasonal. The bills: food and beverage orders, payroll every week or two, rent and utilities. The money in: card settlements that land a day or more after each sale, and cash. A kitchen replacing equipment adds the repair or quote to the bills side.
- Amount: the gap, not the whole month's costs.
- Rate: the annual rate stated in an offer, or a test figure.
- Term: the months over which the gap should be paid back from sales.
Inputs the Working Capital Calculator Online Uses for Repair Shops
A repair shop's gap comes from parts bought on account before customers or insurers pay for the repair. List open parts invoices with their due dates, list repair orders waiting on payment, and the difference is the input. If the gap repeats every month, a line of credit may fit better than a loan; if it is one large purchase, read the term loans page.
What the Payment Arithmetic Leaves Out
- Every payment is treated as equal, at one rate that never changes.
- Fees are left out; add any stated fees to the total yourself.
- Balloon payments, daily or weekly schedules and variable rates are not modeled.
- A merchant cash advance is not a loan and does not fit this formula.
Results are arithmetic on your inputs only, not an offer or an estimate of terms available. The request form starts a real request.
By Ivyhollow Lending Group · Updated
