Articles

How do you calculate replacement reserves for a commercial property?

A replacement reserve built from the building's components, and why the capex it hides usually lands on the next owner.

List the building's major components, divide each replacement cost by its useful life, and add the results: that is the steady-state replacement reserve. On a fictional 150,000 sq ft office with 5,450,000 of components to replace, the reserve is 295,667 a year, 1.97 per square foot, nearly eight times a flat 0.25 allowance. Capitalised at a 6.50 per cent cap rate, the difference is 3,971,795 of value.

Worked in full in Real Estate Fund Management by Julian R. Sterling, with every figure reproduced in a free workbook.See the book on Amazon →

Replacement reserves are the line between NOI and the cash flow an owner can actually keep. They are often typed into a model as a round number per square foot or per unit, borrowed from the last deal, and left there. The component method replaces the round number with a schedule the property manager and the building surveyor can argue about, which is the point: a reserve with a source can be challenged, and one without a source cannot.

The assumptions

Fictional suburban office, 150,000 sq ft. Costs and lives are illustrative, not survey data.
ComponentReplacement costUseful lifeAgeRemaining
Roof membrane1,200,00020146
HVAC plant2,400,00020128
Lifts modernisation600,00025187
Car park resurfacing450,0001596
Facade sealant and glazing gaskets300,00015105
Common area refurbishment500,0001266
Total5,450,000

The costs are today's prices for a like-for-like replacement, including professional fees and contingency. Tenant improvements and leasing commissions are not here: they are leasing costs, tied to lease events, and belong in their own line. Items the leases let the landlord recover through the service charge should also come out, because a reserve is for cost the owner bears.

The calculation step by step

Steady-state reserve = Σ (replacement cost ÷ useful life)

Catch-up funding = Σ (replacement cost ÷ remaining life)

Value effect = reserve ÷ cap rate

In Excel, with costs in B, lives in C and ages in D: =SUMPRODUCT(B2:B7/C2:C7) for the steady state and =SUMPRODUCT(B2:B7/(C2:C7-D2:D7)) for the catch-up.

Annual reserve by component.
ComponentSteady statePer sq ftCatch-upPer sq ft
Roof membrane60,0000.40200,0001.33
HVAC plant120,0000.80300,0002.00
Lifts modernisation24,0000.1685,7140.57
Car park resurfacing30,0000.2075,0000.50
Facade sealant and gaskets20,0000.1360,0000.40
Common area refurbishment41,6670.2883,3330.56
Total295,6671.97804,0485.36

The result: two numbers, two uses

The steady-state figure, 295,667 a year or 1.97 per square foot, is what the building costs to keep as it is, averaged over a full replacement cycle. It is the reserve to deduct from NOI in the exit year and in any valuation that capitalises income in perpetuity. On an NOI of 3,000,000 it is 9.9 per cent of NOI, and it moves value at a 6.50 per cent cap from 46,153,846 to 41,605,128.

The catch-up figure, 804,048 a year or 5.36 per square foot, is 2.7 times larger because the building is past the middle of most component lives and nobody has been saving for them. A buyer should not book that as a reserve. It should put the specific replacements into the cash flow in the years they fall due, as capex, and price them into the bid.

Check the dates against the hold. Only the facade work, 300,000, falls due within a five-year hold. Five components costing 5,150,000 fall due in years 6 to 8. The seller's reserve will look harmless for the whole hold, and the buyer at exit will deduct almost the entire component list from the price. A five-year model that never shows that capex still pays for it, through the exit value.

What if: lives and costs

Steady-state reserve under different assumptions.
CaseAnnual reservePer sq ftValue at 6.50%
Lives 20% shorter369,5832.465,685,897
Base case295,6671.974,548,718
Lives 20% longer246,3891.643,790,598
Costs 10% lower266,1001.77
Costs 25% higher369,5832.46

Lives matter as much as prices: a survey that shortens every life by a fifth adds 1,137,179 of capitalised cost. If the reserve is funded as a sinking fund instead, with replacement costs inflating at 3.00 per cent and the balance earning 4.00 per cent, the annual deposit to meet each component on its due date is 874,628, or 5.83 per square foot. Inflation on an ageing building outweighs the interest earned.

The common mistake

The common mistake is the flat allowance. At 0.25 per square foot the model deducts 37,500 a year, 258,167 less than the components require. Capitalised at 6.50 per cent that overstates value by 3,971,795, 8.6 per cent of the unreserved value, and it does so silently, because NOI looks better every year the reserve is too low. The second mistake runs the other way: deducting a full reserve from NOI and also modelling the replacements as capex, which counts the same roof twice.

Reserves also decide what the market cap rate means. If comparable sales were analysed on NOI after reserves, apply the cap rate to NOI after reserves; mixing conventions moves value by the full 4,548,718. The same discipline runs through taking a T-12 to underwritten NOI and through deciding what cap rate a building deserves once capex is counted.

Takeaway

Build the reserve from the components, not from a rule of thumb: 1.97 per square foot here, against a 0.25 allowance that would have overstated value by almost 4 million. Then read the remaining lives against the hold, because the capex a reserve hides usually lands on the next owner and comes back as a lower exit price. The free workbooks for this book take a trailing-twelve statement to an underwritten NOI, which is where this line belongs.

Questions readers ask

Are replacement reserves deducted before or after NOI?

Conventions differ, so match the evidence. Many lenders and valuers deduct reserves below NOI to reach net cash flow; some appraisals deduct them inside NOI. What matters is applying the cap rate to the same measure the comparables used. In the worked case, a 295,667 reserve at a 6.50 per cent cap is worth 4,548,718, so mixing conventions moves value by that amount.

What is the difference between a reserve and capex in a model?

A reserve is a level annual deduction for the long-run cost of keeping the building as it is. Capex is a specific spend in a specific year. For a hold model, put known replacements falling due inside the hold in as capex, and use the steady-state reserve in the exit year. Here the steady state is 1.97 per sq ft, while funding aged components over their remaining lives would need 5.36.

Does inflation change the replacement reserve?

Yes, if the reserve is funded as a sinking fund for a dated replacement. With replacement costs rising 3.00 per cent a year and the fund earning 4.00 per cent, the deposits needed to meet each component on its due date total 874,628 a year in the worked case, against 804,048 at today's prices. On an ageing building, cost inflation outweighs the interest earned on the balance.

Read the whole case

This article is one calculation from Real Estate Fund Management. The book takes the same case from first principles to the decision, chapter by chapter, and every figure it prints is a live formula in the free companion workbooks.

Get the book on Amazon →Free companion files

Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada

Also on this site

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

If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.