DealMemo icon DealMemo

Monthly Rental CapEx Reserve from Component Cost and Remaining Life

Cash flow is overstated when a roof, HVAC system, water heater, or floor is left out of the reserve. Monthly CapEx reserve adds, for each component, replacement cost divided by remaining useful life in years, then divided by 12. Costs, remaining years, and the workbench price, rent, tax, and insurance on this page are example inputs you can replace. This page does not present lifespans as published chart figures or contractor quotes.

Monthly CapEx Reserve
Monthly reserve = Sum of (Replacement cost / Remaining useful life in years) / 12.

Monthly Reserve from Example Inputs

Every cost and every remaining year is an example input. Edit the cells. For each component, monthly reserve equals replacement cost divided by remaining useful life in years, then divided by 12. The total is the sum of those monthly amounts, each rounded to the cent. This page does not cite a published lifespan chart.

The workbench on this guide loads with CapEx percent at 0. Leave it there when you use the itemized reserve, so the same dollars are not counted a second time. Long-term rental and BRRRR both take this monthly total as a cash-flow line.

Component, example inputReplacement cost, example inputRemaining years, example inputMonthly reserve
$50.00
$40.00
$10.00
$40.00

Worked result

Monthly CapEx reserve $140.00.

  1. Roof: ($12,000.00 / 20) / 12 = $600.00 / 12 = $50.00 per month
  2. HVAC: ($7,200.00 / 15) / 12 = $480.00 / 12 = $40.00 per month
  3. Water heater: ($1,440.00 / 12) / 12 = $120.00 / 12 = $10.00 per month
  4. Flooring: ($4,800.00 / 10) / 12 = $480.00 / 12 = $40.00 per month
  5. Monthly CapEx reserve: $50.00 + $40.00 + $10.00 + $40.00 = $140.00

Each monthly reserve is rounded to the cent. The total adds those rounded amounts.

Educational mathematical modeling worksheet only; not financial, tax, lending, or legal advice.

The shared workbench below is loaded with CapEx percent at 0. Subtract the monthly reserve from the sheet before treating its cash-flow figure as spendable.

Calibration Deals:
DSCR Coverage
1.17x
Below 1.25x
Monthly Cash Flow
+$221
+$2,651/yr
Cap Rate
7.49%
NOI $17,980/yr
70% Flip MAO
$166,500
$73,500 over
Cash-on-Cash
3.95%
Cash In $67,200
1% Rule / GRM
0.92%
GRM 9.1x

Deal Assumptions

$
$
$
$

7x7 Interest Rate vs Vacancy Stress Matrix

12/49 cells pass DSCR >= 1.25x

Click any scenario cell to inspect exact monthly cash flow and lender coverage. Emerald cells clear both positive cash flow and your DSCR bar.

Rate \ Vac0%3%5%8%10%15%20%
5.50%
6.00%
6.50%
7.00%
7.50%
8.00%
8.50%

Annual Operating Statement & Debt Service

Gross Scheduled Income
$26,400
Effective Gross Income
$25,080
Operating Expenses
-$7,100
Net Operating Income
$17,980
Monthly Debt (P&I)
$1,277.38
Total Cash Required
$67,200

Educational mathematical modeling worksheet only; not financial, tax, lending, or legal advice.

Reference Scenario Benchmarks

Scenario Inputs Result Underwriting Note
Example costs, longer remaining life Roof $12,000 / 20 yr; HVAC $7,200 / 15 yr; water heater $1,440 / 12 yr; flooring $4,800 / 10 yr $140.00 per month Illustrative user inputs. Roof (12000 / 20) / 12 = $50.00. HVAC (7200 / 15) / 12 = $40.00. Water heater (1440 / 12) / 12 = $10.00. Flooring (4800 / 10) / 12 = $40.00. Sum = $140.00.
Same costs, shorter remaining life Roof $12,000 / 10 yr; HVAC $7,200 / 5 yr; water heater $1,440 / 4 yr; flooring $4,800 / 5 yr $330.00 per month Illustrative user inputs. Roof (12000 / 10) / 12 = $100.00. HVAC (7200 / 5) / 12 = $120.00. Water heater (1440 / 4) / 12 = $30.00. Flooring (4800 / 5) / 12 = $80.00. Sum = $330.00.
Higher example replacement costs Roof $18,000 / 20 yr; HVAC $9,000 / 15 yr; water heater $1,800 / 12 yr; flooring $7,200 / 10 yr $197.50 per month Illustrative user inputs. Roof (18000 / 20) / 12 = $75.00. HVAC (9000 / 15) / 12 = $50.00. Water heater (1800 / 12) / 12 = $12.50. Flooring (7200 / 10) / 12 = $60.00. Sum = $197.50.

Field Verification Checklist

  • 1 Type the replacement cost you would pay and the years of life you believe remain. Both start as example inputs. This page does not cite a lifespan table.
  • 2 This guide loads the workbench with CapEx percent at 0. Leave that percent at 0 when you use the itemized reserve, so the same dollars are counted once.
  • 3 Put the monthly total on the long-term rental cash-flow line and on the BRRRR cash-flow line before you treat either result as spendable cash.

Related Underwriting Guides