How to underwrite a property in an interview
A property underwrite is your estimate of what a building will earn and what it is worth, built from the rent roll up. In an interview it is usually done on paper with a handful of figures. The aim is a clear, ordered answer with stated assumptions, not exact arithmetic. This guide gives an order of work, a computed example and the usual mistakes.
What order should I work in?
Say your conventions first (annual figures, no tax, no financing unless asked), then go in the same order every time.
- Rent roll to gross income. Multiply units or space by rent. Check that you are using in-place rent, not asking rent, and note leases ending soon.
- Vacancy and credit loss. Deduct for empty space and unpaid rent. Use the building's actual vacancy if known, or a market-based allowance, and say which.
- Other income. Parking, laundry, service charge recoveries, kept separate and modest.
- Operating expenses. Property tax, insurance, management, repairs, utilities and on-site staff. Only the costs the landlord bears. Check the expense ratio is sensible for the type of property.
- NOI. Income less expenses. No capex, financing or tax.
- Capex reserve. A per-unit or per-area allowance for replacing roofs, lifts and fittings. Many people deduct it below NOI, others within it, so state which.
- Value and yield. Price divided into NOI for the going-in yield, or NOI ÷ a cap rate for value.
- Exit and sensitivity. Assume a sale, choose an exit cap rate, and show how the answer moves.
Worked example: Marlstone Court
Marlstone Court is an invented block of 40 apartments, offered at 7.0m. All figures were computed in advance. Conventions: annual figures, in-place rents, no tax or financing, rent and costs both grow 3% a year, five-year hold, sale at year-5 NOI ÷ the exit cap rate, no sale costs.
Gross income. 40 units at an average of 1,500 a month is 40 x 1,500 x 12 = 720,000.
Vacancy. At 6%, the loss is 43,200, leaving 676,800. Other income (parking and laundry) is 40 a unit a month, 19,200, so total income is 696,000.
Expenses.
| Item | Annual cost |
|---|---|
| Property tax | 110,000 |
| Insurance | 36,000 |
| Management (3% of income) | 20,880 |
| Repairs and maintenance | 26,000 |
| Utilities | 16,000 |
| On-site payroll | 95,000 |
| Total | 303,880 |
That is 43.7% of income, which you should compare with what you would expect for this kind of building.
NOI. 696,000 less 303,880 is 392,120. Going-in yield on 7.0m is 5.6%.
Capex reserve. At 300 a unit a year, the reserve is 12,000. NOI after reserve is 380,120, a yield of 5.4%. Quote both and say which one you use.
Exit. Year-5 NOI after reserve is 380,120 x 1.03 to the power 5, about 440,700. With an exit cap rate of 6.0%, about 60 basis points above the going-in yield because the building is older, value is about 7.34m, a gain of 5% on the price. Add the five years of income and the unlevered IRR is about 6.8%.
Sensitivity on the exit cap rate.
| Exit cap rate | Exit value | Unlevered IRR |
|---|---|---|
| 5.5% | 8.01m | 8.4% |
| 6.0% | 7.34m | 6.8% |
| 6.5% | 6.78m | 5.4% |
Sensitivity on income (first-year NOI after reserve).
| Case | NOI | Yield on 7.0m |
|---|---|---|
| Base | 380,120 | 5.4% |
| Vacancy 10% | 352,184 | 5.0% |
| Rents 5% lower | 347,295 | 5.0% |
| Expenses 10% higher | 349,732 | 5.0% |
Each of these is a drop of about 7% to 9% in NOI, and because value is NOI over the cap rate, value falls by about the same proportion. A buyer paying 7.0m for 5.4% needs growth to earn much more than that, and that is the honest summary: the deal depends on rent growth and the exit yield.
How do I choose the exit cap rate?
Start from the going-in yield and be cautious. A common approach is to assume the same or slightly higher exit yield, because the building is older at sale. Using a lower exit yield than the entry yield means you are assuming the market improves, and an interviewer will ask why. Whatever you pick, show the neighbouring cases. Practitioners differ on how much of a spread to add, and it depends on the market, so explain your reasoning instead of quoting a rule.
What should I check on the rent roll?
Lease expiries and break dates; rent reviews; tenants who pay late or occupy a large share of income; rent-free periods or incentives that make passing rent higher than cash rent; and whether recoveries cover costs. These checks often matter more than the arithmetic.
What are the common mistakes?
- Using asking or headline rent instead of in-place rent.
- Applying vacancy to the wrong base, or twice.
- Forgetting management fees, insurance or the landlord's share of costs.
- Putting capex inside NOI without saying so, or leaving it out.
- Assuming a lower exit cap rate than entry without a reason.
- Showing one answer and no sensitivity.
- Over-precision: "5.4%" is fine, "5.4317%" is not.
- Presenting NOI growth that comes only from rent growth, with costs held flat.
How do I present it in two minutes?
State conventions, give income, vacancy, expenses and NOI in that order, quote the yield on price, mention the reserve, give your exit assumption and the one sensitivity that matters most, then end with a view: "At 5.4% I would want evidence of rent growth before paying this."
About this guide: it is original to Charta Learning, uses an invented property and has not yet been reviewed by an experienced practitioner. Expense levels, reserve conventions and the treatment of recoveries differ by market and property type, so state your convention.