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.
| Item | Value |
|---|---|
| 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 months | 8.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% |
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.
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.
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 factor | Qualifying income a month | Housing ratio | DTI |
|---|---|---|---|
| 30% | $28,350 | 16.85% | 21.61% |
| 40% | $24,300 | 19.66% | 25.21% |
| 50% | $20,250 | 23.59% | 30.25% |
| 60% | $16,200 | 29.49% | 37.82% |
| 70% | $12,150 | 39.31% | 50.42% |
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.
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 limit | Income needed a month | Deposits needed at a 50% factor | Highest factor the file survives |
|---|---|---|---|
| 43% | $14,248 | $341,949 | 64.82% |
| 45% | $13,615 | $326,751 | 66.38% |
| 50% | $12,253 | $294,076 | 69.75% |
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.
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.
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.
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.
Above 64.82% for this file. At 60 per cent the DTI is 37.82%; at 70 per cent it is 50.42%.
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.
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.
Not on Amazon: 11 paperbacks by Julian R. Sterling on banking, credit and payments, printed on demand and shipped worldwide. Browse the bookshop →
Reading guide: real estate investing, finance and fund management → · All 1908 articles →