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