ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Down Payment Assistance (DPA)
PROGRAMS SPREADSHEET
2
Project Name:
Spreadsheet instructions are in blue.
3
Applicant:
Enter your agency's information in the yellow cells.
4
Date:Spreadsheet Version:1
Do not enter information in gray cells, they will autocalculate.
5
6
STAFF ALLOCATION CHART
7
8
Enter Staff Positions and each staff person's Total Salary & Fringe in Columns A&B. Enter the percent of time spent on CDOH Housing Rehab (DPA) by each staff person in Colmun D. Column E will auto-calculate amount of salary allocated to CDOH DPA.Fill in the names of the various programs your agency runs in Row 10, Columns F-I. Add or delete columns as needed. For each staff person, show what percent of their time is spent on each program. Total in Column J should add up to 100% for each person.
9
Staff PositionTotal Salary
& Fringe		% of Time
CDOH Housing Rehab (DPA)		Total Salary & Fringe DPA% of Time
(Non-DPA Program
Name 1)		% of Time
(Non-DPA Program
Name 2)		% of Time
(Non-DPA Program
Name 3)		% of Time
(Non-DPA Program
Name 4)		Total % of Time
10
Staff Position 1 $ - 0%
11
Staff Position 2 $ - 0%
12
Staff Position 3 $ - 0%
13
Staff Position 4 $ - 0%
14
Totals $ - $ -
15
16
Enter your agency overall operating costs and the percent spent on CDOH Housing Rehab (DPA). Column E will auto-calculate amount of overhead allocated to CDOH DPA.If your agency would like to be paid loan servicing expenses from Program Income, enter expenses below. If you prefer to be paid loan servicing expenses in project delivery, include in DPA Budget tab as a project delivery expense.
17
Agency Operating ExensesTotal Agency Annual Costs% of Overall Operations spent on CDOH DPA Total Overhead Allocated to DPAAnnual Loan Servicing Expense
*if applicable
18
Executive Director $ - Loan Servicing Specialist
19
Accountant $ - Loan Servicing Expense 1
20
Other Staff $ - Loan Servicing Expense 2
21
Other Staff $ - Loan Servicing Expense 3
22
Operating Expenses (i.e. rent, utilities) $ - Loan Servicing Expense 4
23
Equipment, materials and supplies $ - Loan Servicing Expense 5
24
Taxes and Insurance $ - Total Loan Servicing Expenses $ -
25
Communication Cost $ -
26
Audit Cost $ - # of Non-Deferred Loans
27
Legal Cost $ - # of Payments per Year
28
 $ - Loan Servicing Costs per payment#DIV/0!
29
 $ -
30
Total Operating Expenses $ - $ -
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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100