Project # 0
FEDERAL HOME LOAN BANK OF DALLAS
AFFORDABLE HOUSING PROGRAM
RENTAL PROJECTS WORKSHEET
HUD AREA MEDIAN INCOMES (AMI)
1. Please enter the annual Median Family Income (MFI) for the project area: $0
2. In the spaces below, please enter the MFI adjusted for family size, based on guidelines published by the Federal Housing Finance Board. The use
of median incomes other than those pulished by the Finance Board must be submitted with the application package and must be approved by the Bank.
Family size Family size
1 $0 5 $0
2 $0 6 $0
3 $0 7 $0
4 $0 8 $0
Percent MFI Adjusted Tenant Rent Total Rent Proposed Rent as %
Number of Bedrooms Persons MFI Target for Family Size Rent Subsidy (Includes Subsidy) of Targeted Income
Units Per Unit Per Unit (1) (2) (3) (4) (5)
0 0 0 0% $0 $0.00 $0.00 $0.00 #DIV/0!
0 0 0 0% $0 $0.00 $0.00 $0.00 #DIV/0!
0 0 0 0% $0 $0.00 $0.00 $0.00 #DIV/0!
0 0 0 0% $0 $0.00 $0.00 $0.00 #DIV/0!
0 0 0 0% $0 $0.00 $0.00 $0.00 #DIV/0!
0 0 0 0% $0 $0.00 $0.00 $0.00 #DIV/0!
0 0 0 0% $0 $0.00 $0.00 $0.00 #DIV/0!
0 0 0 0% $0 $0.00 $0.00 $0.00 #DIV/0!
0 0 0 0% $0 $0.00 $0.00 $0.00 #DIV/0!
0 0 0 0% $0 $0.00 $0.00 $0.00 #DIV/0!
0 0 0 0% $0 $0.00 $0.00 $0.00 #DIV/0!
0 0 0 0% $0 $0.00 $0.00 $0.00 #DIV/0!
0
(1) Targeting should agree with that provided in application (50, 60, 80, 100)
(2) Portion the Tenant Pays - Rents should not include utilities.
(3) Any subsidy paid in combination with tenant portion to equal total rent paid
(4) Total Rent (Tenant plus Subsidy)
(5) Housing ratio will be calculated based on the tenant portion only. (Not to exceed 30%)
Rental Work Sheet
CONFIDENTIAL D:\Docstoc\Working\pdf\99bc1842-b162-42fa-b3c0-31154c3bd2c0.xls Page 1 of 3
Federal Home Loan Bank of Dallas
Affordable Housing Program 15 year Pro forma
Project name: Project # Date 08/18/09
Pro Forma Income/Expense Statement
Yr. 1 Yr. 2 Yr. 3 Yr. 4 Yr. 5
Assumptions: No. Units Rent Gross Annual
0 $0 $0
Vacancy Rates 0.00% 0 $0 $0
Rent Increase Rates 0.00% 0 $0 $0
Expense Growth Rates 0.00% 0 $0 $0
Total Number of Units 0 0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
0 $0 $0
Income: 0 $0 $0
Rental Income $0 $0 $0 $0 $0
Vacancy $0 $0 $0 $0 $0
Other Income (Secondary Income) $0 $0 $0 $0 $0
Total Income: $0 $0 $0 $0 $0
Expenses % of EGI $ per Unit
Insurance #DIV/0! $0 #DIV/0! $0 $0 $0 $0
1.) Property Taxes #DIV/0! $0 #DIV/0! $0 $0 $0 $0
2.) Utilities #DIV/0! $0 #DIV/0! $0 $0 $0 $0
Trash #DIV/0! $0 #DIV/0! $0 $0 $0 $0
Maintenance #DIV/0! $0 #DIV/0! $0 $0 $0 $0
Management Fee #DIV/0! $0 #DIV/0! $0 $0 $0 $0
Groundskeeping #DIV/0! $0 #DIV/0! $0 $0 $0 $0
Administrative #DIV/0! $0 #DIV/0! $0 $0 $0 $0
Professional #DIV/0! $0 #DIV/0! $0 $0 $0 $0
Tenant Expense #DIV/0! $0 #DIV/0! $0 $0 $0 $0
Other #DIV/0! $0 #DIV/0! $0 $0 $0 $0
Operating Expenses #DIV/0! $0 #DIV/0! $0 $0 $0 $0
2.) Utilities: Do not include tenant paid utilities
Reserves
Replacement $0 #DIV/0! $0 $0 $0 $0
Total Reserves $0 #DIV/0! $0 $0 $0 $0
Total Expenses $0 #DIV/0! $0 $0 $0 $0
Net Operating Income $0 #DIV/0! $0 $0 $0 $0
Debt Service
1st Mortgage (Principal) $0
Rate 0.00%
Term (Years) 0
Monthly Payment #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Annual Payment #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
2nd Mortgage $0
Rate 0.00%
Term (Years) 0
Monthly Payment #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Annual Payment #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Deferred Developer Fee
Total Debt Service #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Cash Flow #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
3.) DSR = [Net Operating Income / Total Debt Service]
3.) Debt Service Ratio #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
15 Year Feasibility
CONFIDENTIAL D:\Docstoc\Working\pdf\99bc1842-b162-42fa-b3c0-31154c3bd2c0.xls Page 2 of 3
Project name: 0 Project # 0
Pro Forma Income/Expense Statement
Years 6 through 15
Yr. 6 Yr. 7 Yr. 8 Yr. 9 Yr. 10 Yr. 11 Yr. 12 Yr. 13 Yr. 14 Yr. 15
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
15 Year Feasibility
CONFIDENTIAL D:\Docstoc\Working\pdf\99bc1842-b162-42fa-b3c0-31154c3bd2c0.xls Page 3 of 3