|
Using data drawn from the Operating Pro-Forma tab, this portion of the Summary tab summarizes income and expenses for Years 1, 2, 5, 10, 15, and 30 of operations. This section is of special interest to potential lenders and investors trying to determine the property's ability to meet expenses and pay debt service.
While useful, this snapshot of the projects first two years is not intended to replace the full operating pro-forma, which should more fully demonstrate the long term sustainability of your project.
Below are definitions of the fields found in this section of the Summary tab and some include links to additional information.
-
HOME Rents is the total rental income from HOME units. This figure already takes utility expenses for HOME units into account. As with the other rental income projections, the amount increases each year at the rate you specified.
- Market Rents is the total rental income from market rate units. This figure does not include utility expenses for these units.
- Other Affordable Rents is the total rental income from other types of affordable units, besides HOME-assisted units (e.g., Low-Income Housing Tax Credit or Community Development Block Grant units). This figure already takes utility expenses into account.
- Gross Potential Rent (GPR) is the projected revenue of a property assuming all units are occupied at all times. The Template calculates GPR by adding the total rental income to the other income.
- Vacancy Loss is calculated, based on data you provided in the Development Pro-Forma tab, as a percentage of GPR.
- Other Revenue is calculated based on data that you entered under the Rents and Income tab. Many properties supplement their income from rents with income from other services they provide residents, such as access to laundry machines. The amount of other income increases each year at the rate you specified.
- Effective Gross Income (EGI) is calculated as the GPR less the vacancy loss, plus the other revenue.
- Total Expenses incurred by a project are calculated by summing the residential expense, replacement reserve amount, operating reserve amount, and property taxes.
- Net Operating Income (NOI) represents a project's income after expenses. The Template subtracts total expenses from EGI to supply the projected NOI.
- Cash Flow (After Debt Service) is the amount of income remaining after all debt service has been paid.
|