How to Calculate DSCR from Bank Statements

Short answer: Divide net operating income by total debt service for the same period. From bank statements, net operating income is total deposits from operations minus operating expenses that cleared the account, with loan payments, owner draws and one off items excluded. Total debt service is every principal and interest payment due in that period, including the loan you are applying for. A DSCR of 1.25 means the business generates $1.25 of cash for every $1.00 of debt payments, which is the minimum most commercial lenders want to see.

The formula, and why bank statements are the source

DSCR is net operating income divided by total debt service. On a tax return that income comes off the P&L. Underwriters increasingly build it from bank statements instead, for two reasons. Statements are hard to dress up, since a deposit either landed or it did not. And they are current, where a tax return can be eighteen months stale by the time it reaches a credit file.

That is why so many business lenders now ask for twelve or twenty four months of statements as the primary income document. If you are preparing a file, preparing bank statements for a loan application covers the packaging side. This article is about the arithmetic.

Step 1: build net operating income from deposits

Start with total deposits for the period, then take out anything that is not revenue from operations. Underwriters will do this whether or not you do, so it pays to do it first and show your work.

Then subtract the operating costs that actually cleared the account: payroll, rent, materials, insurance, software, utilities, marketing. Leave out anything that is debt service, because that belongs in the denominator, and leave out owner draws and distributions, which are a use of profit rather than a cost of operating.

Doing this by hand across twelve statements is where people lose an afternoon. Converting the statements first and then categorizing the transactions lets you total each bucket with a pivot table and, more usefully, hand the lender a schedule that shows exactly what you excluded and why.

Step 2: total the debt service

Total debt service is every principal and interest payment due during the period. Include term loans, equipment finance, vehicle notes, SBA loans, the amortizing portion of any merchant advance, and the payments on the loan you are asking for. That last one trips people up. The ratio a lender cares about is the one after the new debt exists, not before.

Two details matter. Use the full payment, principal and interest, not the interest expense your accountant books. And use scheduled payments for a full twelve months, so a loan you took out in September counts twelve times rather than four.

Step 3: divide, and read the result

A worked example. A contracting business shows $840,000 of operating deposits over twelve months. Transfers between its own accounts and a $60,000 line of credit draw are stripped out, leaving $780,000. Operating expenses that cleared the account come to $612,000, so net operating income is $168,000. Existing debt service is $84,000 a year and the new equipment loan would add $36,000, for total debt service of $120,000.

$168,000 divided by $120,000 gives a DSCR of 1.40. That clears the usual 1.25 threshold with room, and it is the kind of file that gets approved without a fight.

What DSCR do lenders require?

It varies by product and by how much collateral is behind the loan.

A DSCR of exactly 1.00 means the cash coming in covers the payments and nothing else. No lender likes it, because a single slow quarter turns it into a missed payment. Below 1.00 the business is funding debt from reserves or new borrowing, and most credit committees stop there.

How is DSCR calculated on a rental property?

Differently, and more simply. For a DSCR rental loan the ratio is the property's gross rental income divided by PITIA: principal, interest, taxes, insurance and any HOA dues. Nothing about the borrower's personal income enters the calculation, which is the entire appeal of the product for investors who show low taxable income after depreciation.

A property renting at $2,600 a month against a PITIA of $2,200 gives a DSCR of 1.18. Whether that funds depends on the program. Lenders will use the lower of the actual lease and the market rent from the appraiser's rent schedule, so an above market lease to a friendly tenant will not lift the ratio.

Why your DSCR looks worse than it is

Three things distort the number when it is built from raw statements, and all three are fixable before a lender sees the file.

Transfers counted as income and then as expense. If you move money between two business accounts, an untreated statement shows a deposit in one and a withdrawal in the other. It inflates both sides and muddies the picture. Strip matched transfers out on both accounts.

Owner draws read as operating costs. Draws are not an expense of running the business. Left in, they cut net operating income directly and can drag a healthy 1.35 down under the threshold.

One time costs treated as recurring. A legal settlement or an equipment purchase paid from the operating account is a real outflow, but it does not repeat. Underwriters call these add backs. Identify them, document them, and present them separately rather than hoping they get noticed.

Working from converted statements makes each of these a filter rather than an argument. Every line is visible, every exclusion is footnoted, and the schedule you produce is the same one the analyst would have built. If the lender also wants formal statements alongside the workings, turning the categorized data into a presentable set of financials is the last step.

Run the numbers before the lender does

Calculating your own DSCR takes an hour once the statements are in a spreadsheet, and it tells you whether to apply now or wait a quarter. If the ratio comes in under the threshold you have three levers: raise operating income, cut costs that cleared the account, or reduce the debt service by asking for a smaller loan or a longer term. Extending an amortization from five years to seven lowers the annual payment and lifts the ratio without changing anything about the business.

Lenders build this from the same documents you have. The bank statement converter for lenders shows what the analyst on the other side is doing with your file, and what underwriters look for in bank statements covers the red flags that sit alongside the ratio: overdrafts, unsourced large deposits, and the volatility of the deposit pattern month to month.