Get documents about "Excel Sheet Proforma - Excel
W
Description
Excel Sheet Proforma document sample
Document Sample
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 C:\Docstoc\Working\pdf\defe3f28-e387-4082-9b5e-d65672c551fc.xls Page 1 of 4
A B C D E F G H I J
1 Fed eral Ho m e L o an B an k o f Dallas
2 Affo rd ab le Ho u sin g Pro g ram 15 year Pro fo rm a
3
4 Project name: Project # Date 02/03/11
5 Pro Forma Income/Expense Statement
6
7
8 Yr. 1 Yr. 2 Yr. 3 Yr. 4 Yr. 5
9 Assumptions: No. Units Rent Gross Annual
10 0 $0 $0
11 Vacancy Rates 0.00% 0 $0 $0
12 Rent Increase Rates 0.00% 0 $0 $0
13 Expense Growth Rates 0.00% 0 $0 $0
14 Total Number of Units 0 0 $0 $0
15 0 $0 $0
16 0 $0 $0
17 0 $0 $0
18 0 $0 $0
19 0 $0 $0
20 0 $0 $0
21 Income: 0 $0 $0
22 Rental Income $0 $0 $0 $0 $0
23 Vacancy $0 $0 $0 $0 $0
24 Other Income (Secondary Income) $0 $0 $0 $0 $0
25 Total Income: $0 $0 $0 $0 $0
26
27 Expenses % of EGI $ per Unit
28 Property Insurance #DIV/0! $0 #DIV/0! $0 $0 $0 $0
29 1.) Property Taxes #DIV/0! $0 #DIV/0! $0 $0 $0 $0
30 2.) Utilities (elec/gas/wtr/sewer/trash) #DIV/0! $0 #DIV/0! $0 $0 $0 $0
31 Advertising & Marketing #DIV/0! $0 #DIV/0! $0 $0 $0 $0
32 Repairs & Maintenance #DIV/0! $0 #DIV/0! $0 $0 $0 $0
33 Management Fee #DIV/0! $0 #DIV/0! $0 $0 $0 $0
34 Groundskeeping #DIV/0! $0 #DIV/0! $0 $0 $0 $0
35 Administrative #DIV/0! $0 #DIV/0! $0 $0 $0 $0
36 Professional #DIV/0! $0 #DIV/0! $0 $0 $0 $0
37 Tenant Expense #DIV/0! $0 #DIV/0! $0 $0 $0 $0
38 Other #DIV/0! $0 #DIV/0! $0 $0 $0 $0
39 Operating Expenses #DIV/0! $0 #DIV/0! $0 $0 $0 $0
40 2.) Utilities: Do not include tenant paid utilities
41 Reserves
42 Replacement $0 #DIV/0! $0 $0 $0 $0
43 Total Reserves $0 #DIV/0! $0 $0 $0 $0
44
45 Total Expenses $0 #DIV/0! $0 $0 $0 $0
46
47 Net Operating Income $0 #DIV/0! $0 $0 $0 $0
48
49 Debt Service
50 1st Mortgage (Principal) $0
51 Rate 0.00%
52 Term (Years) 0
53 Monthly Payment #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
54 Annual Payment #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
55 2nd Mortgage $0
56 Rate 0.00%
57 Term (Years) 0
58 Monthly Payment #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
59 Annual Payment #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
60 Deferred Developer Fee
61 Total Debt Service #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
62
63 Cash Flow #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
64 3.) DSR = [Net Operating Income / Total Debt Service]
65 3.) Debt Service Ratio #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
15 Year Feasibility
CONFIDENTIAL C:\Docstoc\Working\pdf\defe3f28-e387-4082-9b5e-d65672c551fc.xls Page 2 of 4
K L M N O P Q R S T
1
2
3
4 Project name: 0 Project # 0
5
6
7
8 Pro Forma Income/Expense Statement
9 Years 6 through 15
10
11
12
13
14
15
16
17
18
19
20 Yr. 6 Yr. 7 Yr. 8 Yr. 9 Yr. 10 Yr. 11 Yr. 12 Yr. 13 Yr. 14 Yr. 15
21
22 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
23 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
24 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
25 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
26
27
28 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
29 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
30 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
31 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
32 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
33 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
34 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
35 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
36 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
37 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
38 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
39 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
40
41
42 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
43 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
44
45 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
46
47 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
48
49
50
51
52
53 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
54 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
55
56
57
58 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
59 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
60
61 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
62
63 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
64
65 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
15 Year Feasibility
CONFIDENTIAL C:\Docstoc\Working\pdf\defe3f28-e387-4082-9b5e-d65672c551fc.xls Page 3 of 4
U V W X Y Z AA AB AC AD AE AF
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
15 Year Feasibility
CONFIDENTIAL C:\Docstoc\Working\pdf\defe3f28-e387-4082-9b5e-d65672c551fc.xls Page 4 of 4
Related docs
