The Replacement Reserve Table Explained: EUL, RUL, Effective Age and the Ten-Year Schedule

The reserve table is the reason most lenders order a PCA. The narrative tells them what the building is; the table tells them how much money to escrow and when. It is also the part of the report most likely to be built in a spreadsheet and pasted in, which is why the arithmetic behind it deserves to be written down once.

What the guide says about it

Under E2018-24 the table is a presentation of long-term costs: opinions of cost for replacing building systems and components that reach the end of their useful life within an evaluation period the user chooses. It sits in the appendix on enhanced due diligence, so it is beyond the baseline scope and is listed as a deviation in the executive summary. The guide excludes routine maintenance and tenant-responsibility items, says inflation is typically applied at a constant rate, and says pointedly that the table is not a substitute for a condominium or homeowner-association reserve study, which is a different discipline with its own standards (see PCA vs reserve study).

The five numbers on every line

Expected useful life (EUL). The average number of years a component is expected to function when new and maintained. It comes from a published table. The HUD CNA e-Tool table is public domain, organised by the E2018 system outline, and is the most common source for non-agency work; Fannie Mae's Form 4099.F table is the one agency lenders expect on multifamily. The two disagree for some components, and a report should say which it used.

Remaining useful life (RUL). The guide defines this as a subjective opinion of the years remaining before replacement is warranted, and says it is not a guarantee. It is the field observer's judgment, informed by condition, reported and documented age, and maintenance history. A fifteen-year-old EPDM roof with open seams and ponding has less life left than the table implies; the same roof under a warranty with clean drains may have more.

Effective age. Defined in the guide as EUL minus RUL. It is not the calendar age. A well-maintained 2004 unit with an RUL opinion of eight years against a fifteen-year EUL has an effective age of seven, not twenty-two. Reports that print calendar age in the effective-age column are printing the wrong number.

Year due. The report year plus RUL. If it falls outside the evaluation period the item is listed with no cost, so the reader sees it was considered.

Cost. Quantity times unit cost, from the same sources the guide allows for all opinions of cost, rounded to an order of magnitude. Recurring items (seal coat every five years, exterior sealants every ten) repeat at their interval within the period.

Worked example

A 24,700 square foot adhered EPDM roof installed in 2011, report year 2026, HUD EUL 20 years. Calendar age is 15 and the arithmetic RUL is 5, so the roof is due in 2031. The field observer rated it fair with repairs pending and kept the RUL at 5; effective age is therefore 15. At $11.50 per square foot the line carries $284,100 in 2031. With inflation at 3 percent compounding from the report year, the inflated figure is about $329,000. Over a ten-year period on a 24,300 square foot building, a $626,650 uninflated total works out to $2.58 per square foot per year, which is the figure a lender compares with its underwriting assumption.

Reading the table the way a lender does

• Per square foot per year, uninflated. The headline. Office and retail lenders have a range they expect; a figure far below it prompts the question of what was left out.
• The first three years. Anything due early is effectively an immediate cost with a delay; underwriters often move it into the escrow.
• Items with no cost. A component listed as engineer to provide, or excluded as tenant responsibility, must say why. Silence reads as omission.
• Whether RUL was an opinion or arithmetic. A column or note stating the basis for each RUL is what separates a considered table from a spreadsheet macro.

Common mistakes

• Printing calendar age as effective age.
• Using one EUL source in the table and citing another in the methodology.
• Carrying the same item in Table 1 and Table 2 (a short-term replacement is not also a reserve item unless the component recurs).
• Including tenant improvements or tenant-owned equipment.
• Inflating from the site-visit year when the methodology says report year, or vice versa.
• Omitting the inflation factor row, so the reader cannot check the inflated total.

How Baseline PCR builds Table 2

Every line is computed, not written: EUL from the HUD table with the Fannie 4099.F value carried alongside, RUL from the field observer's stated opinion when there is one and from EUL minus documented age when there is not, effective age as EUL minus RUL, year due as report year plus RUL, cost as quantity times the firm's unit cost, inflation compounding from the report year. A basis sheet prints the arithmetic and the source for each line, and the reviewer can change any RUL, quantity or unit cost in the workspace and watch the totals move. The sample report shows the table on its landscape sheet.