Open calculator ↗

Operating expense ratio from a rent roll · Calculation guide

Calculate expenses as a share of effective income.

Calculation guide

Enter annual rent-roll totals. Operating expenses exclude interest, depreciation and capital improvements.

ratio = 100*opex/(scheduled-loss+other); income = scheduled-loss+other; noi = income-opex

Inputs

Scheduled annual rent

Example entry 120000 (in the selected currency).

Vacancy and collection losses

Example entry 6000 (in the selected currency).

Other operating income

Example entry 6000 (in the selected currency).

Annual operating expenses

Example entry 48000 (in the selected currency).

Worked example

InputValue
Scheduled annual rent120,000
Vacancy and collection losses6,000
Other operating income6,000
Annual operating expenses48,000
ResultValue
Expenses as a share of effective income40%
Effective gross income120,000
Net operating income72,000

Calculation steps

Expenses as a share of effective income = ((100 × Annual operating expenses) ÷ ((Scheduled annual rent − Vacancy and collection losses) + Other operating income))

((100 × 48,000) ÷ ((120,000 − 6,000) + 6,000)) = 40%

Effective gross income = ((Scheduled annual rent − Vacancy and collection losses) + Other operating income)

((120,000 − 6,000) + 6,000) = 120,000

Net operating income = (Effective gross income − Annual operating expenses)

(120,000 − 48,000) = 72,000

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Scheduled annual rent120,000132,000Expenses as a share of effective income40%36.363636%
Vacancy and collection losses6,0006,600Expenses as a share of effective income40%40.201005%
Other operating income6,0006,600Expenses as a share of effective income40%39.800995%
Annual operating expenses48,00052,800Expenses as a share of effective income40%44%
Operating expense ratio from a rent roll →

Sources