Articles

How much income does a bank statement loan qualify, and what DTI does it leave?

A bank statement loan qualifies deposits, not tax returns. The expense factor alone decides whether the same file shows a 25.21% DTI or a 50.42% one.

Twelve months of eligible deposits of $486,000, less a 50 per cent expense factor, qualify $20,250 a month. Against a PITI of $4,776.59 and other debts of $1,350, the debt-to-income ratio is 30.25%. Every 10 points of expense factor moves qualifying income by $4,050 a month: at 60 per cent the DTI is 37.82%, at 70 per cent 50.42%. Against a 43 per cent limit the file works only while the factor stays at or below 64.82%, so the factor is the most important number in the file.

The book sets a bank statement loan beside four other loan types and qualifies it on deposits, not on tax returns. This article asks the question that follows from that file: how sensitive is the answer to the expense factor the lender applies? Every figure comes from the bank statement file in the book’s Inputs sheet and is recalculated below from the formulas.

The assumptions

ItemValue
Eligible deposits, 12 months$486,000
Expense factor (share of deposits treated as business costs)50%
Contract price$650,000
Loan$520,000 (loan-to-value 80.00%)
Note rate, 30-year fixed, 360 months8.25%
Property tax a month$640
Homeowners insurance a month$230
Other debts a month$1,350
DTI limit used for the tests (case assumption)43%
Qualifying income = eligible deposits × (1 − expense factor) ÷ 12. The lender, not the borrower, sets the factor; the 43 per cent limit is an assumption of this article, not a rule.

Step 1: qualifying income

The lender treats a share of each deposit as the cost of earning it and qualifies the rest:

Qualifying income a month = deposits × (1 − expense factor) ÷ 12. In Excel: =B2*(1-B3)/12, with deposits in B2 and the expense factor in B3.

486,000 × (1 − 0.50) = 243,000 a year, and 243,000 ÷ 12 = $20,250 a month. Gross deposits of $40,500 a month shrink to $20,250, which is the only income the ratios below can use.

Step 2: the payment and the ratio

The loan is $520,000 at 8.25 per cent over 360 months. The monthly rate is 0.0825 ÷ 12 = 0.6875 per cent:

Principal and interest = L × r ÷ (1 − (1 + r)−360). In Excel: =PMT(B5/12,360,-B4), with the rate in B5 and the loan in B4.

That gives $3,906.59. Add tax of $640 and insurance of $230 for a PITI of $4,776.59, and the other debts of $1,350 for total obligations of $6,126.59 a month. The DTI is 6,126.59 ÷ 20,250 = 30.25%; the housing ratio, PITI alone over income, is 23.59%. In Excel: =(PITI+debts)/income.

Step 3: the expense factor moves everything

The loan, the payment and the debts do not change when the factor does. Only the denominator moves, and it moves by $4,050 a month for every 10 points:

Expense factorQualifying income a monthHousing ratioDTI
30%$28,35016.85%21.61%
40%$24,30019.66%25.21%
50%$20,25023.59%30.25%
60%$16,20029.49%37.82%
70%$12,15039.31%50.42%
Deposits $486,000, total obligations $6,126.59 a month. At 60 per cent the file is still under 43 per cent; at 70 it is over 50.

The ratio is not linear in the factor: income is deposits × (1 − factor), so DTI is total obligations ÷ that. Going from 50 to 60 per cent adds 7.57 points of DTI; going from 60 to 70 adds 12.60. The same 10 points hurt more as the factor rises, because the income they remove is a larger share of what is left.

Step 4: the deposits a DTI limit needs

Turn the question round. For a DTI limit, qualifying income must be at least obligations ÷ limit, and deposits must be that income × 12 ÷ (1 − factor):

Deposits needed = (obligations ÷ limit) × 12 ÷ (1 − factor). The highest factor the file survives is 1 − (obligations ÷ limit) × 12 ÷ deposits. In Excel: =B6/B7*12/(1-B3) and =1-B6/B7*12/B2, with total obligations in B6 and the DTI limit in B7.

DTI limitIncome needed a monthDeposits needed at a 50% factorHighest factor the file survives
43%$14,248$341,94964.82%
45%$13,615$326,75166.38%
50%$12,253$294,07669.75%
Obligations $6,126.59 a month. The file has $486,000 of deposits, so it clears every limit at a 50 per cent factor with $144,051 to spare against 43 per cent.

At a 43 per cent limit the borrower needs $341,949 of eligible deposits, 70.4% of what the account shows. The cushion is $144,051 of deposits a year, or $12,004 a month.

What if the loan were bigger or the rate higher?

The common mistakes

Takeaway

A bank statement file is a sensitivity to one number. At a 50 per cent expense factor, $486,000 of deposits qualify $20,250 a month and a 30.25% DTI; at 70 per cent the same account gives 50.42%. Before quoting a bank statement loan, divide total obligations by the DTI limit, convert the answer to deposits at the lender’s factor, and see how far the account is above it. Here the answer is $144,051. For the other income method in the book, see the two-year average of self-employed income in the Calloway file of The Mortgage Underwriter.

Reproducing it in the workbook

The case inputs are in Mortgage_Underwriter_Model.xlsx: the Inputs sheet holds the bank statement deposits, expense factor, price, loan, rate, taxes, insurance and debts, and the Contrast Files sheet lists the bank statement qualifying income, loan-to-value, PITI and DTI lines. Change the expense factor on the Inputs sheet and those lines follow. The factor table and the deposits-needed table above are not in the workbook: they are two small tables to build on the same inputs with the formulas shown.

Questions readers ask

How do you calculate qualifying income on a bank statement loan?

Eligible deposits times one minus the expense factor, divided by 12. Deposits of $486,000 at a 50 per cent factor give $20,250 a month, and a 30.25% DTI on a $520,000 loan at 8.25 per cent.

What expense factor makes a bank statement loan fail a 43 per cent DTI?

Above 64.82% for this file. At 60 per cent the DTI is 37.82%; at 70 per cent it is 50.42%.

Why does a higher expense factor hurt more each time?

Because DTI is obligations divided by income, and income is deposits times one minus the factor. Going from 50 to 60 per cent adds 7.57 points of DTI; going from 60 to 70 adds 12.60.

The workbooks behind this article

Every figure above is built from the inputs in the free companion files for The Mortgage Underwriter, which also hold the Calloway conventional file, FHA, VA, jumbo and DSCR contrast files, a quality-control sample and a repurchase calculation. Each worked workbook ends with a checks sheet setting the printed figure beside the computed one. No account and no email address.

Open the companion files →

Not on Amazon: 11 paperbacks by Julian R. Sterling on banking, credit and payments, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: real estate investing, finance and fund management → · All 1908 articles →