ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Change Log
Spreadsheet Version 4.7
4
5
Version 4.7 Updates
Effective: 5/29/2026
6
• Removed header/footer and page numbers
7
• Added alt text to all the DOH logos
8
• Match Calclator: Added description to the eligible matching source table.
9
• Assessment: Updated scoring table to score PSH Projects
10
• CHFA Rent & Income limits updated to 2026
11
12
Version 4.6 Updates
Effective: 1/21/2026
13
• Dev Budget: Moved the Construction Insurance and P&P Bonds to Construction
14
• Assessment Tab: Added calculation for minimum DDF on acquisition deals
15
16
Version 4.5 Updates
Effective:11/6/2025
17
• DOH Financing tab: Gap(Surplus) fixed to (Gap)Surplus
18
• DOH Financing tab: Fixed bug in subsidy per unit formula
19
• Added DOLA County Designation to Dev Budget
20
• Assessment tab: Added automated underwriting scoring
21
• Added Pending/Confirmed drop-down to sources & uses tab
22
• Assessment tab: Added drop-down for Subsidy Limit with bonus subsidy
23
• Assisted Units tab: removed auto unit rounding
24
• Assessment tab: Added Cash Flow Loan Analysis
25
26
Version 4.4 Updates
Effective:10/1/2025
27
• DOH Ranges updated to FY25-26 Limits
28
29
Version 4.3 Updates
Effective:7/1/2025
30
• Fixed bug in the CHFA rent limit formula
31
• Update the Garfield County CHFA rent & income limit error
32
• Updated PSH Replacement Reserve / unit to $350
33
• Proforma updated to drop negative numbers to the "Available Cash" line
34
• Removed the 60% AMI box on the DOH Financing tab
35
• Annual Debt Service formula updated to be amorized monthly
36
37
Version 4.2 Updates
Effective:4/17/2025
38
• DOH Proforma tab: Row 31 had two minus functions, removed one.
39
• Sources & Uses tab: Change notes column text to black font instead of grey
40
• Assessment tab: Updated layout to show variances & calculate if outside range
41
• CHFA rent & Income limits updated to 2025
42
• Sources & Uses tab: Fix formula in sources table to only populate if there is a source
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