Single-family rental underwriting
Higher mortgage debt delays the recovery of rental reserves
Mortgage debt reduces the equity required to acquire a rental property. It also reduces the income available to replenish reserves after a vacancy, extending the owner's financial exposure beyond the interruption in rent.
Acquisition equity and the owner's subsequent cash commitment
An illustrative $180,000 rental earning $1,900 a month requires $21,400 for closing costs, initial rehabilitation and a cash reserve, in addition to the down payment. An owner comparing mortgage offers must also allow for bills due during a vacancy. The loan payment continues when collections stop, and repairs may require payment before a replacement tenant begins paying rent. A larger mortgage reduces the owner's initial investment while increasing the cash required for debt service. The owner's assessment must include the cash retained outside the property and the availability of that money if rental income becomes insufficient to meet expenses.
Purchase price and operating assumptions remain unchanged across the loan-to-value comparisons, so differences in the reserve balance result from financing. An annual rent sensitivity and a separate monthly vacancy-and-repair scenario measure the potential owner funding requirement and the time needed to restore reserves, without estimating the likelihood of the vacancy or reporting a client investment result.
Higher debt service reduces the cash return at the base rent
At $1,900 monthly rent, financing 75% of the purchase price produces an annual cash-on-cash yield of 2.65%. Increasing the loan-to-value ratio to 85% reduces the yield to 0.52%, as annual cash after debt service declines from approximately $1,760 to $250. The yield calculation divides cash after debt service by the owner's initial investment, including the funded reserve. Appreciation and principal amortization are excluded from the return numerator.
The additional borrowing reduces acquisition equity by $18,000 and increases annual debt service by approximately $1,510. With only $250 of annual cash remaining at 85% loan-to-value, a small expense above the forecast can require an owner contribution. The cash retained at acquisition is available for that purpose only to the extent the owner preserves it for the rental property.
At $2,300 a month, the cash yield is 8.46% without debt and 8.69% at 85% loan-to-value, compared with 6.50% and 0.52%, respectively, at the base rent. The improvement follows from the additional income available after fixed debt payments. An acquisition decision that assumes $2,300 rent therefore requires evidence that the property can command that amount. The mortgage payment remains due if collections are lower.
Cash yield by monthly rent and mortgage financing
Annual cash after debt service divided by the initial owner investment, including the funded reserve. Appreciation and principal amortization are excluded.
View chart data · %
| Monthly rent | 0% loan-to-value | 60% loan-to-value | 75% loan-to-value | 85% loan-to-value |
|---|---|---|---|---|
| 1,500 | 4.53 | 0.08 | -3.31 | -7.66 |
| 1,540 | 4.73 | 0.5 | -2.71 | -6.84 |
| 1,580 | 4.93 | 0.92 | -2.11 | -6.02 |
| 1,620 | 5.12 | 1.35 | -1.52 | -5.2 |
| 1,660 | 5.32 | 1.77 | -0.92 | -4.39 |
| 1,700 | 5.52 | 2.19 | -0.33 | -3.57 |
| 1,740 | 5.71 | 2.62 | 0.27 | -2.75 |
| 1,780 | 5.91 | 3.04 | 0.86 | -1.94 |
| 1,820 | 6.11 | 3.46 | 1.46 | -1.12 |
| 1,860 | 6.3 | 3.89 | 2.05 | -0.3 |
| 1,900 | 6.5 | 4.31 | 2.65 | 0.52 |
| 1,940 | 6.69 | 4.73 | 3.25 | 1.33 |
| 1,980 | 6.89 | 5.16 | 3.84 | 2.15 |
| 2,020 | 7.09 | 5.58 | 4.44 | 2.97 |
| 2,060 | 7.28 | 6 | 5.03 | 3.78 |
| 2,100 | 7.48 | 6.43 | 5.63 | 4.6 |
| 2,140 | 7.68 | 6.85 | 6.22 | 5.42 |
| 2,180 | 7.87 | 7.27 | 6.82 | 6.24 |
| 2,220 | 8.07 | 7.7 | 7.42 | 7.05 |
| 2,260 | 8.27 | 8.12 | 8.01 | 7.87 |
| 2,300 | 8.46 | 8.54 | 8.61 | 8.69 |
Vacancy and repairs can create a combined funding requirement
A tenant's departure can both reduce collections and require repairs before the property is ready to rent again. Assessing vacancy and repair costs together tests the owner's ability to pay for work during the period of reduced income.
At $1,805 monthly rent, 5% below the base assumption, the 75% loan-to-value case produces approximately $1,020 of annual cash after debt service with 4% vacancy and $1,500 of repairs. Increasing vacancy to 10% produces a deficit of approximately $176. At 4% vacancy, increasing repairs to $4,500 instead produces a deficit of approximately $1,980. Combining 10% vacancy and $4,500 of repairs increases the annual deficit to approximately $3,176.
The $3,000 increase in repairs exceeds the initial scenario's entire annual surplus. Even a positive annual forecast therefore allows limited expenditure above the assumed repair budget. The owner must provide cash for the combined deficit under the more adverse assumptions, with the timing of that contribution determined by rent collections and payment dates.
The reserve requirement depends on the timing of payments
The monthly scenario begins with a $6,000 reserve for every financing structure. It assumes no rent in months four and five and an additional $4,500 repair payment in month four. Rent is collected in full during all other months, while allowances for routine repairs and capital reserves continue each month. These assumptions define a separate monthly calculation from the annual vacancy sensitivity.
The lowest balances occur at the end of month five. The 60% loan-to-value case retains approximately $118, while the 75% and 85% cases have cumulative funding shortfalls of approximately $826 and $1,455. The forecast excludes owner contributions, so negative balances measure cash the owner would need to provide to meet the modeled obligations.
A $118 balance permits almost no further expenditure before the next collection. For the 60% financing case, retaining a larger minimum reserve would require additional cash even though the forecast remains positive. The owner must select that minimum balance when sizing the initial reserve. An assumption that cash can fall to zero establishes only the amount required to pay the modeled bills.
Reserve balance and funding shortfall during vacancy and recovery
Rent is absent in months four and five, with an additional $4,500 repair in month four. Owner contributions are excluded, while monthly allowances for routine repairs and capital reserves continue.
View chart data · $
| Month | 60% loan-to-value | 75% loan-to-value | 85% loan-to-value |
|---|---|---|---|
| 0 | 6,000 | 6,000 | 6,000 |
| 1 | 6,422.85 | 6,234.06 | 6,108.2 |
| 2 | 6,845.7 | 6,468.12 | 6,216.4 |
| 3 | 7,268.54 | 6,702.18 | 6,324.61 |
| 4 | 1,443.39 | 688.24 | 184.81 |
| 5 | 118.24 | -825.7 | -1,454.99 |
| 6 | 541.09 | -591.64 | -1,346.79 |
| 7 | 963.94 | -357.58 | -1,238.59 |
| 8 | 1,386.79 | -123.52 | -1,130.39 |
| 9 | 1,809.63 | 110.54 | -1,022.18 |
| 10 | 2,232.48 | 344.6 | -913.98 |
| 11 | 2,655.33 | 578.66 | -805.78 |
| 12 | 3,078.18 | 812.72 | -697.58 |
| 13 | 3,501.03 | 1,046.79 | -589.38 |
| 14 | 3,923.88 | 1,280.85 | -481.17 |
| 15 | 4,346.72 | 1,514.91 | -372.97 |
| 16 | 4,769.57 | 1,748.97 | -264.77 |
| 17 | 5,192.42 | 1,983.03 | -156.57 |
| 18 | 5,615.27 | 2,217.09 | -48.37 |
| 19 | 6,038.12 | 2,451.15 | 59.83 |
| 20 | 6,460.97 | 2,685.21 | 168.04 |
| 21 | 6,883.81 | 2,919.27 | 276.24 |
| 22 | 7,306.66 | 3,153.33 | 384.44 |
| 23 | 7,729.51 | 3,387.39 | 492.64 |
| 24 | 8,152.36 | 3,621.45 | 600.84 |
Debt service determines the pace of reserve recovery
After collections resume, the 75% financing case returns to a positive forecast balance in month nine. The 85% case reaches that point in month nineteen. The forecasts contain four and fourteen negative month-end balances, respectively. Those periods measure the time required for subsequent cash generation to offset the cumulative funding shortfall before any owner contribution. An owner paying the bills would supply the missing cash when required and decide whether subsequent rental surpluses should reimburse that contribution or remain in reserve.
By month nineteen, the 60% loan-to-value case has restored the original $6,000 reserve. The 85% case records a balance of approximately $60. Monthly cash after expenses and debt service is approximately $423 at 60% financing and $108 at 85%, despite identical rent collections. Higher debt service limits the amount available to replace cash spent during the vacancy.
At month twenty-four, the modeled reserve is approximately $3,621 at 75% loan-to-value and $601 at 85%. Both remain below their starting balance, with owner contributions still excluded. Distributing rental surpluses before reserves recover would extend the period in which a second vacancy could require additional owner funding. A reserve policy for this acquisition therefore needs to specify the balance to be restored before distributions resume.
Purchase terms should reflect the owner's reserve policy
Adding approximately $826 to the opening reserve would eliminate the modeled shortfall at 75% loan-to-value, leaving the owner with approximately zero cash at the lowest point. Retaining cash for another expense would require a larger contribution. Increasing the reserve addresses the immediate payment requirement, while reducing debt also increases the monthly income available to replenish it.
For this acquisition, the owner can assess the purchase price and mortgage together against a chosen minimum reserve and an acceptable recovery period. A lower purchase price reduces the loan amount at a given loan-to-value ratio. A smaller mortgage increases acquisition equity and reduces subsequent debt service. The financing decision should record the additional cash the owner is prepared to contribute and the conditions for resuming distributions, alongside the annual return estimate.
The assumptions and exclusions below define the worked scenario.
Model notes and assumptions
- $180,000 purchase price, $5,400 closing costs, $10,000 initial rehabilitation and $6,000 funded reserve.
- Illustrative 7.5% fixed note, 30-year monthly amortization, loan amount based only on purchase price.
- $1,900 base monthly rent; 5% vacancy; management 8% of collected rent; $4,200 annual taxes and insurance; $1,500 routine repairs; capital reserve 5% of scheduled rent.
- Cash yield = annual cash after debt / down payment plus closing costs, rehabilitation and initial reserve; principal amortization and appreciation excluded from the numerator.
- Monthly liquidity case: no rent in months 4 and 5, extra $4,500 repair in month 4; all other months fully collected; no rent growth.
Rates, rents, costs and leverage are scenario inputs, not current lender quotes or HUD payment standards.
No taxes on investor income, sale proceeds, refinancing, utilities or security deposits modeled.
Monthly shock case is separate from steady-state vacancy sensitivity and does not imply a probability.