Other Resources
In partnership with this report, OHCS updated the
online dashboard featuring the full dataset, offering more tools for filtering and data analysis. Additional filtering will include by county. New this year are data visualizations and metrics including hard debt service, hard debt balance and deposits to the replacement reserve.
Data Appendix
Financial Metric Calculations and Definitions
-
Net Income: Total Revenue – Total Expenses
-
Net Operating Income (NOI): Total Revenue – Total Operating Expenses
-
Operating Expenses: Administrative, Utilities, Operating/Maintenance, Taxes/Insurance, Elderly Services. See the next section for more details on Operating Expenses
-
Non-Operating Expenses: Depreciation, Financial (debt interest), Other
-
Debt service: Senior hard debts (interest and principal), plus fees and insurance premium. This report does not include Junior Hard debts interest and principal in debt service or DCR calculations
-
Replacement Reserve: A restricted account used to pay for planned future replacements of major building systems and components
-
Debt Coverage Ratio (DCR): (NOI – annual deposit to replacement reserve) / annual senior hard debt service. More conservative measure of a project’s ongoing health by factoring in ongoing capital reserve needs
-
Cash Flow: (NOI – annual deposit to the replacement reserve) / annual senior and junior hard debt service
-
Vacancy Rate (Loss): Vacancy / gross potential revenue Gross potential revenue includes residential, commercial, garage and other rent. Vacancy refers to revenue lost due to vacant, or unoccupied, units.
-
Income to expense ratio: Revenue / (Total operating expenses + annual deposit to replacement reserve). Alternative metric to DCR for properties that do not have hard debts
OHCS Standardized Financials – based on HUD’s Chart of Accounts
Please note: The ProLink standard financial template categorizes operating expenses into five main groups: administrative, utilities, operating/maintenance/ taxes/insurance and elderly services. Instead of listing payroll as a standalone category, the template embeds payroll costs within all categories except Utilities. These costs include Office Salary, Property Manager, Payroll (catchall), Payroll Taxes and Payroll Insurance.
1000 Asset
- 1100 Current Assets (includes cash, accounts receivable, tenant deposits, and other current assets)
- 1200 Prepaid Expense
- 1300 Funded Reserve (replacement reserve, escrow deposit, and other reserves)
- 1400 Fixed Assets
- 1500 Investment Long-term 1900 Other Assets
2000 Liability
- 2100 Current Liability (accounts payable, accruals, prepaid rent, and other current liabilities)
- 2300 Long-term Liability (developer fee, mortgage, and other long-term liabilities)
3000 Equity
5000 Revenue
- 5100 Rent Revenue
- 5200 Vacancy
- 5400 Financial Revenue
- 5900 Other Revenue
6000 Expense
- 6200 Administrative Expense (advertisements, office salaries, office supplies, management fees, property management and superintendent salaries, legal expenses, audit expenses, accounting services, phone services, bad debt, other general administrative costs)
- 6400 Utility Expenses (fuel, electricity, gas, water, sewer)
- 6500 Operating and Maintenance Expense (payroll, maintenance supplies, contracts, garbage, security, vehicle, other O&M expenses)
- 6600 Depreciation and Amortization Expense *non-operating expense
- 6700 Tax and Insurance Expense (property tax, payroll tax, property insurance, payroll insurance, other)
6800 Financial Expense
- Non-operating expenses including senior hard debt interest, junior hard debt interest, mortgage insurance, and other financial expense.
6900 Elderly Expense
- Only for properties financed with OHCS Elderly & Disabled (E&D) bonds. Includes expenses such as dietary, nursing, medical, laundry, housekeeping, and others.
7000 Other Expense
10000 Other Financial
11300 Reserve Deposit
- 11400 Property Valuation
- 15100 Rental Revenue
- 15200 Occupancy Info
- 16800 Mortgage Principal Payment
- 17100 Cash Flow