Business Loan Repayment Calculator and Cash-Gap Worksheet for Charleston, IL Restaurants and Shops

This page is a business loan repayment calculator for Charleston, IL restaurants and shops, with a cash-gap worksheet beside it. List what comes due before deposits arrive, find the gap, then enter that amount, an annual rate and a term in months to see a level monthly payment.

A man at a work table with a closed folder in a small florist.

Put in the numbers from an offer or check how a bigger amount changes the payment. Nothing you type is sent anywhere.

Calculated payments as entered

Estimated monthly payment
—
Total interest
—
Total repaid
—

Illustrative arithmetic only. Not an offer, quote or estimate of terms available to you. Lending partners set actual rates and terms. Fees and other costs are not included.

In short

Three entries drive the calculator on this page (amount, annual rate, months), and it returns a level payment along with total interest and total repaid. The page shows how to enter an equipment quote, why the term goes in as months, how to run two offers, and how a worksheet finds the amount to enter.

Entering an equipment quote as an equipment repayment calculator for a Charleston, IL clothing store

The calculator on this page has no down payment box, so an equipment quote goes in as the amount the store would finance. A Charleston, IL clothing store pricing a garment steamer and fitting-room mirrors would subtract any cash it puts down from the quote and enter the rest.

The equipment financing page has its own calculator with a down payment input and works equipment loans and leases through invented cases. A lease quote cannot be checked on this page: the loan calculator spreads an amount at an annual rate, and a lease payment is simply whatever the leasing company quotes.

Term loan repayment calculator entries for a Coles County, IL home builder, and the months box

The term box takes months. In an invented case, a Coles County, IL home builder checks $23,800 at a 10.15% annual rate over three years and enters 36: in this invented example the payment is $769.64, and 36 payments total $27,707.04.

Entering 3 by mistake treats the term as three months, and in the same invented example the payment jumps to $8,067.92, far too high. A result that looks many times larger than expected is the first sign the term went in as years.

Two offers through one repayment calculator: what a Charleston, IL bar can compare

Running two offers through the calculator shows what each trades. In an invented case, a Charleston, IL bar has two offers on $18,500: one at an 11.8% annual rate for 24 months and one at a 13.1% annual rate for 18 months.

Two invented offers on the same amount (illustration only, totals from the rounded payment)
OfferMonthly paymentTotal of paymentsInterest
11.8%, 24 months$869.13$20,859.12$2,359.12
13.1%, 18 months$1,137.64$20,477.52$1,977.52

In this invented example the shorter offer has the higher rate yet totals $381.60 less, while its payment is $268.51 higher each month. Fees on either offer would change the comparison and are not part of the calculator. The calculator works from the unrounded payment, so its totals can differ by a few cents from the table, which multiplies the rounded payment by the number of months.

A working capital needs worksheet for a Charleston, IL sit-down restaurant, then the payment it implies

Before the calculator, the worksheet finds the amount. List what is due in the next 30 days, subtract the deposits expected in the same days, and the difference is the gap. The table is an invented case for a Charleston, IL sit-down restaurant with biweekly payroll on day 6 and day 20 of the window.

Invented 30-day working capital worksheet (illustration only)
LineInvented figure
Payroll, day 6$6,150
Payroll, day 20$6,150
Food distributor bill$4,380
Fryer repair bill$1,240
Deposits expected$13,900
Gap to fund$4,020

Typed into the calculator with a 12.45% annual rate and 9 months, this invented $4,020 gap turns into a $470.16 monthly payment and $4,231.44 over the nine months. Those payments then belong on next month's worksheet too. Deposits that land later than planned widen the gap, so a worksheet built on cautious deposit dates gives an amount that holds up when a customer pays late.

County Business Patterns put the 2023 annual payroll of the 38 full-service restaurants in Coles County, IL at $14,228,000 combined (NAICS 722511), a total for all of them rather than a figure for any one restaurant.

By Windmead Financial ยท Updated

Calculator answers for Charleston, IL owners

Short answers; the call covers the rest.

Call now (217) 335-6680
Why does a longer term show a higher total on the calculator?

A longer term spreads the amount over more payments, so each payment is smaller, but interest runs for more months, so the total of all payments rises. The calculator on this page shows both the monthly payment and the totals for the term entered.

What goes in the amount box for a working capital gap?

The gap from the worksheet: bills due in the window minus deposits expected in it. Entering the full bills instead of the gap would size the payment for money the business may not need.

Worked out a gap for a Charleston, IL business? Call Windmead about it

Call (217) 335-6680 about the gap and the timing, or read the working capital page.

Call now (217) 335-6680Request