Spreadsheet Version 1.9

Version 1.9 Updates

• Removed header/footer and page numbers

• Added alt text to all the DOH logos

• Match Calclator: Added description to the eligible matching source table.

• CHFA Rent & Income limits updated to 2026

• Assited tab: Removed HOME metodology, now using DOH share ratio

Version 1.8 Updates

• MH Inc & Exp tab: Lot avg and (Ann. Exp. w/out RR) calculations were reversed

• Dev Budget: Moved the Construction Insurance and P&P Bonds to Construction

Version 1.7 Updates

• DOH Financing tab: Gap(Surplus) fixed to (Gap)Surplus

• DOH Financing tab: Fixed bug in subsidy per unit formula

• Assessment tab: Added automated underwriting scoring

• Added DOLA County Designation to Dev Budget

• Assessment tab: Added drop-down for Subsidy Limit with bonus subsidy

Version 1.6 Updates

• DOH Ranges updated to FY25-26 Limits

• DOH Proforma tab: Cashflow percentage formula updated to include all cash flow loans

• Assessment tab: Operating reserve formula corrected

Version 1.5 Updates

Effective: 7/1/2025

• Fixed bug in the CHFA rent limit formula

• Proforma updated to drop negative numbers to the "Available Cash" line

• Annual Debt Service formula updated to be amorized monthly

• Update the Garfield County CHFA rent & income limit error

• Proforma updated to drop negative numbers to the "Available Cash" line

Version 1.4 Updates

Effective: 4/17/2025

• DOH Proforma tab: Row 31 had two minus functions, removed one.

• Sources & Uses tab: Change notes column text to black font instead of grey

• Assessment tab: Updated layout to show variances & calculate if outside range

• CHFA rent & Income limits updated to 2025

• Added scoring template for underwriter

Version 1.3 Updates

• Changed the word Unit to Lot throughout the spreadsheet

• MH Inc & Exp tab: Fixed the data validation conditional formatting in column I

• MH Inc & Exp tab: Updated PUPA formula to calculate using total lots instead of total affordable lots

• Dev Budget: Changed from rentable sq. ft. to livable sq. ft. in cell G8

• Re-linked header - Applicant & submitted date

• DOH Financing Tab: G23 term in years was reformatted

• Changed type of lot from single/double/triple to owner/vacant/rental

• Expanded chart at top to count owner, rental & vacant lots

• Added eligible lots box to the chart that counts owner occ lots at <100% AMI

• Assisted lots tab reworked using the proportional test

• Assessment Tab: added conditional formatting if amounts exceed ranges