e SANCTUARY 9% Financial Projections 7.1.24.pdf

PDF 814 KB Posted

Attached to
RFP20240906 Debt and Equity Sanctuary on Potomac
Solicitation number
RFP20240906
Issued by
Alamosa County, Colorado

About this file

The document is a comprehensive financial projection for the Sanctuary on Potomac Permanent Supportive Housing (PSH) project by the Aurora Housing Authority (AHA), detailing a 43-unit affordable housing development utilizing 9% Low Income Housing Tax Credits (LIHTC). The project is scheduled for closing on May 1, 2025, with construction starting on the same date and expected completion by September 1, 2026. All 43 units will receive Section 8 Project-Based Voucher rental assistance, and the project aims to achieve full qualified occupancy by March 1, 2027.

The total project budget is $22,770,264, with financing sources including a $3.5 million first mortgage at 6.40% interest, $1 million from the City of Aurora ARPA funds, $1.2 million from Arapahoe County ARPA funds, $600,000 from Arapahoe County HOME funds, and $12,110,004 in federal LIHTC equity and $2,940,000 in Colorado state tax credit equity. The development will target 30% and 50% Area Median Income (AMI) residents, with 33 units at 30% AMI and 10 units at 50% AMI. The project includes a deferred developer fee of $1,200,000 and anticipates a debt coverage ratio above 1.15, indicating strong financial feasibility and sustainability.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

SANCTUARY UPDATE: 1-Jul-24 # of Units: 43

PROJECT BUDGET SOURCE & USE Contractor GMP: 14,058,961$ 50% DDs

Per CHFA Initial Determination

FINANCING MODEL USED: 9% Competitive LIHTC

Uses of Funds Sources of Funds key rates

Site Purchase 1,000,000 First Mortgage 6.40% 3,500,000

Site Work (on & off site) 1,094,909 City of Aurora ARPA 1,000,000 aka Sponsor loan #1

New Construction 13,264,052 Arapahoe County ARPA 1,200,000 aka Sponsor loan #1

Owner contingency 705,356 Arapahoe County HOME 600,000 aka Sponsor loan #2

Professional Fees 1,250,307 Colorado Tax Credit Equity 0.70$ 2,940,000

Construction Interim Costs 811,400 LIHTC Federal Equity (4%) 0.86$ 12,110,004

Permanent Financing Costs 116,000 Operating cash B4 perm conversion -

Development fees & soft costs 1,300,989 Deferred Developer Fee 45.5% 1,200,000

LIHTC Syndication Costs 223,000 Seller carry back loan -

Developer Fees 2,635,000 Other Owner Funds (GAP) 220,260 add to Sponsor Loan #1

Project Reserves 369,251

TOTAL COSTS 22,770,264 TOTAL SOURCES 22,770,264

Total Costs Per Unit 529,541 Total Sources Per Unit 529,541

SANCTUARY update: 1-Jul-24

ADDITIONAL NOTES TO THE PROJECTIONS

NOTE: The dollar amounts used in these projections match the approved CHFA application dated June 7, 2024. The developer expects there will by further cost updates prior to Closing.

1 Low Income Housing Tax Credits

AHA has received an initial credit reservation determination of 1,408,140$ competitive 9% LIHTC Federal tax credits in a competitive preliminary application to CHFA.

AHA has received an initial credit reservation determination of 700,000$ competitive Colorado State tax credits in a competitive preliminary application to CHFA.

AHA is seeking LIHTC pricing shown in these projections, at no less than 0.860$ per federal credit, and State credit pricing no less than 0.70$

Minimum Federal tax credit equity Investment is estimated to be 12,110,004$ Minimum State tax credit equity investment is estimated to be 2,940,000$

2 Construction Loan

The estimated minimum need for construction loan financing is 12,000,000$ underwritten at an average interest rate of 6.15%

The projected construction loan has a TAX-EXEMPT portion of -$ and a TAXABLE portion of 12,000,000$ at an interest rate of 6.15% 6.15%

Projected interest reserve amount $614,400 is calculated using the interest rate during construction.

It is expected that some construction interest payments will be includable in Eligible Basis. This includable amount is estimated at approximately $307,200

3 Permanent Loan

The estimated need for permanent first mortgage financing is 3,500,000$ Fixed interest rate is 6.40%

The expected term is 18 years, including 2 years for construction, with level amortization over 35 years.

There will be subordinate financing as follows: 2,200,000$ called Sponsor loan #1 at AFR rates; and 600,000$ called Sponsor loan #2 also at AFR rates. Both loans are cash flow dependant.

There may be additional Owner Funds required to (ie. GAP), which will be added to the Sponsor Loan #1 balance. The additional Owner funds need currerntly is 220,260$

4 Section 8 Rental Assistance

All 43 units will receive Section 8 rental assistance under the Project-Based Voucher Progam. On behalf of the project, AHA has applied to it's own PBV program under established procedure.

The plan has been reviewed by an unrelated hird party on behalf of HUD (Foothills Regional Housing) and received approval. The 43 vouchers will come from AHA's own allotment.

5 Schedule

Closing is expected to occur by 1-May-25 with construction start by 1-May-25 and construction completion by 01-Sep-26

LIHTC Placed in Service date by 01-Sep-26 achieving Full Qualified Occupancy by 1-Mar-27

Conversion to permanent financing will occur after a period of stabilization by 1-Jul-27

SANCTUARY UPDATE: 1-Jul-24

PROJECT BUDGET SOURCE & USE TBD Jun-24

PROJECT CONSTRUCTION BUDGET (GC) TAX CREDITS Fed APR FEDERAL CREDIT STATE CREDIT COMBINED

NOT RIGHT YET APPLICATION Eligible Estimate in CHFA app June 2024 (50% DDs) Total Credit to LP 9.00% 14,081,400 4,200,000 adjust later to 99.99% to LP

USES OF FUNDS TOTAL Basis Total Investment 12,110,004 2,940,000 15,050,004

1 GC On Site Work 794,909 794,909 GC On Site Costs Per Credit $0.860 $0.700

2 GC Basic Construction 10,831,647 10,831,647 Existing Conditions 34,500 PROJECTED INVESTOR PAY-IN SCHEDULE COMBINED

3 GC General Conditions 1,151,449 1,151,449 Exterior Improvements, earthwork 586,809 At Closing 20.0% 2,422,001 588,000 3,010,001

4 GC Contractor Profit & Overhead 527,594 527,594 Utilities 173,600 At 50% construction 0.0% - - -

5 GC Preconstruction fee 35,000 35,000 xx - At 100% construction 20.0% 2,422,001 588,000 3,010,001

6 GC Construction Contingency - in GC contract 396,853 396,853 TOTAL SITE DEVELOPMENT 794,909 At 100% PIS 0.0% - - -

7 GC Performance Bond 101,505 101,505 At Perm Conversion 58.0% 7,023,802 1,705,200 8,729,002

8 GC General Hazard & Liability Insurance 80,539 80,539 GC Basic Construction At final closeout 2.0% 242,200 58,800 301,000

9 GC Builder's Risk Insurance 139,465 139,465 Site Work (SEE ABOVE) - Total Installments 100.0% 12,110,004 2,940,000 15,050,004

10 Land acquisition 1,000,000 Concrete 441,473

11 Off-Site work (allowance to Aurora Mental Health) 300,000 Masonry 271,633 PRIVATE ACTIVITY BOND ASSUMPTIONS not applicable

12 Utility Tap Fees 817,000 817,000 Metals 249,674 Aggregate Basis -

13 Building Permit fees (owner paid) 5,000 5,000 Wood & composites 2,078,816 50% Threshold 50.0% -

14 Power/Telecom Provider fees 50,000 50,000 Thermal 731,490 Selected Bond Amount #DIV/0! -

15 Civil Engineering 50,000 50,000 Doors & Windows (openings) 415,602 TBD

16 Furniture, Fixtures & Equipment 281,989 281,989 Finishes 1,121,442 CONSTRUCTION LOAN ASSUMPTIONS Calculation of combined interest rate:

17 Owner-held contingency 705,356 705,356 Specialties 92,690 Tax Exempt Amount - - 0% 0.00%

18 Architect Design Services 634,342 634,342 Equipment 103,238 Taxable Amount up to: 12,000,000 6.15% 12,000,000 100% 6.15%

19 Architect Supervision Services 140,965 140,965 Furnishings 268,257 Total Amount needed up to: 12,000,000 12,000,000 6.15%

20 Attorney, Owner real estate 25,000 25,000 Special construction - Additional cushion amount -$

21 Consultant fees: financial 85,000 85,000 Elevator (conveying equipment) 280,000 Total Construction Loan commitment 12,000,000$

22 Survey Services 50,000 50,000 Fire protection 287,705 Underwriting rate 6.15% blended rate

23 Materials Testing Fees 50,000 50,000 Mechanical, Plumbing, Radon 1,340,000 Term (months) 24

24 Construction Management, Owner 250,000 250,000 HVAC 1,376,000 Total Construction Interest budget (from S&U) 614,400

25 Market Studies 10,000 10,000 Electrical & Communications 1,522,392 TBD

26 Environmental Studies, PCNA, Geotech 5,000 5,000 Safety & Security Systems - PRIMARY MORTGAGE ASSUMPTIONS

27 Tax Credit fees to CHFA 111,500 - 123,570 TOTAL BASIC CONSTRUCTION 10,580,412 Amount 3,500,000

28 Tax Credit compliance fees to CHFA 21,500 - 21,500 Interest Rate (fixed-Tx) 6.40%

29 Appraisal 10,000 10,000 GC Other Costs Amortization (yr) 35 420

30 Cost Certification 12,000 12,000 General Conditions 1,151,449 Annual Payment 250,866

31 Partnership legal & organization 90,000 - Precon fee & Proj. software (in GCs) 35,000 Term (yr) - including 2 yr construct 18

32 Soft Cost contingency 75,000 75,000 Profit & Overhead 527,594

33 Construction loan origination fees 87,000 87,000 Hazard & Liability Insurance 80,539 LIHTC ASSUMPTIONS Bldg (100%) CHFA App math check

34 Construction loan interest 614,400 307,200 998,050 Builders Risk insurance 139,465 Building Eligible Basis (adj -$ 20,454,813 20,454,813 100.0%

35 Construction lender inspection fees 20,000 20,000 Performance Bond 101,505 Building Qualified Basis @ 130% 20,454,813 20,454,813 100.0%

36 Construction lender legal, due diligence 50,000 50,000 GC Contingency 376,853 Acquisition Qualified Basis @ 100% - #DIV/0!

37 Construction loan, title & recording fees 40,000 40,000 Permits 20,000 Total Qualified Basis 20,454,813 20,454,813 100.0%

38 Permanent loan origination & Rate lock 66,000 - TOTAL OTHER GC COSTS 2,432,405 Applicable LIHTC Percentage (Federal) 9.00%

39 Permanent loan prepaid MIP, CHFA app fee - - Calculated Annual LIHTC Credit (Federal) 1,840,933

40 Bond Cost of Issuance - - Additional allowances (see below) 251,235 CHFA Approved LIHTC Credit (Federal) 1,408,140 as per CHFA Special GAP calculation

41 Permanent loan, legal, title & recording fees 50,000 - Total LIHTC Credit (Federal) 10 Year 14,081,400

42 Relocation: Temp & Perm & site hospitality - - TOTAL GC CONTRACT 14,058,961 Applicable Percentage (State) 30%

43 Rent-up Reserves, marketing/leasing 32,250 - Comparison with CHFA app 14,058,961 Calculated Colo Max Credit (State) 6 Year 6,136,444

44 Operating Reserves (6 mo. OPEX & DS) 337,001 360,970 100.0% - Approved Colo Credit (State) 6 Year 4,200,000 as per CHFA Special GAP calculation

45 Developer Fee: deferred 1,200,000 1,200,000 TOTAL DEVELOPER FEE 2,635,000 Annual Approved Colo Credit (State) 700,000 as per CHFA Special GAP calculation

46 Developer Fee: paid 1,435,000 1,435,000 Deferred 45.5% 1,200,000 TAX CREDIT FEES Federal State Total CHFA App In Budget

Paid 54.5% 1,435,000 Reservation Amount 1,408,140 700,000

TOTAL Uses of Funds 22,770,264 20,454,813 Application 10,000 1,000 11,000 11,000 111,500

Additional allowances Initial Determination 63,326 - 63,326 63,326

SOURCES OF FUNDS (Permanent) Mold remediation, etc - Final application 49,244 - 49,244 49,244

1 First Mortgage 3,500,000 Inflation expectation 251,235 Compliance monitoring 21,500 21,500 21,500 21,500

2 City of Aurora funds: ARPA 1,000,000 xxx - none Milestone Fee - - - -

3 County of Arapahoe funds: ARPA 1,200,000 xxx - none 145,070 133,000

4 Arapahoe County: HOME 600,000 Total Additions 251,235 CDOH DEFERRED LOAN NOT APPLICABLE

5 Seller carry back loan - Amount -

6 LIHTC Investor proceeds (federal credit) 12,110,004 Interest Rate (fixed; accrual) TBD

7 Colo Tax credit investor proceeds (state credit) 2,940,000 Annual Payment: % of cash flow after DDF paid off TBD

8 Operating Cash before Perm loan conversion - Payment begins: after DDF fully paid. Est in Year TBD

9 AHA Deferred Developer Fee 1,200,000 Maturity in Year TBD

10 Other Owner Funds (remaining GAP) 220,260

TOTAL Sources of Funds 22,770,264 CHFA LIHTC AWARD CALC Basis max/unit

- 1 BR Units 43 367,588 15,806,284

CHFA Original App math check 22,770,264 20,454,813 2 BR Units 0 352,438 -

Change from original CHFA app - - 3 BR Units 0 442,373 -

100.0% 100.0% ELIGIBLE BASIS LIMIT MAXIMUM 15,806,284

Adjustments (QTC, DDA) 1.00

PROPERTY SALE TO PARTNERSHIP ASSUMPTIONS NOT APPLICABLE QUALIFIED BASIS LIMIT 15,806,284

Total Appraised Value-Restricted - from appraisal Qualified Basis Award Limit 9.00% 1,422,566 using Basis Limit Test

Land Value - excluded from Sale - from appraisal Current Calculated Award 1,840,933 using actual Qualified Basis

Building Value - included in Sale - from appraisal -$ per unit CHFA Initial Determination 1,408,140 as per initial determination letter

Adjusted building value - Actual Sale price Credit Award used for this project 1,408,140 using CHFA GAP determination

Outstanding debt to pay off, expenses - estimate

Net to AHA -

Cash proceeds to AHA -

Takeback Note to AHA -

SANCTUARY

FIRST YEAR OPERATIONS (Stabilized)

Stabilized Monthly

INCOME Annual Average INITIAL RENT SCHEDULE ASSUMPTIONS INITIAL OPERATING EXPENSE

Gross Rental Income 793,608 66,134 Administration 43 units

Other Income - laundry 6,192 516 UNITS - SQ FT # AMI NET RENT ANNUAL Accounting 4,085

Less Vacancy @ 5.0% (39,990) (3,333) 1 Br 1 Ba - 492 33 30 - Sec8 1,538$ 609,048 Advertising 3,225

NET RENTAL INCOME 759,810 63,318 1 Br 1 Ba - 492 0 40 - Sec8 1,538$ - Legal, background checks 5,160

1 Br 1 Ba - 492 10 50 - Sec8 1,538$ 184,560 Management Fees 23,650

EXPENSES 1 Br 1 Ba - 492 0 60 - Sec8 1,538$ - Management Salaries & OT 65,000

Administration 108,000 9,000 Office Supplies 4,300

Operations 88,202 7,350 Employee 0 - - Telephone 2,580

Maintenance 204,700 17,058 Non-LIHTC 0 - - Community Builder -

Fixed Expenses 57,260 4,772 TOTALS 43 793,608 108,000

TOTAL EXPENSES: 458,162 38,180 Operations

Other Income 43 Laundry 12 6,192 Electricity & Gas 62,402

NET OPERATING INCOME 301,648 25,137 Water & Sewer 19,780

Replacement Reserve Deposit 12,900 1,075 AFFORDABILITY DISTRIBUTION - LIHTC classification Other -

30% AMI 33 76.7% Trash 6,020

ADJUSTED NET OPERATING INCOME 288,748 24,062 40% AMI 0 0.0% 88,202

50% AMI 10 23.3% Maintenance

Primary Mortgage Debt Service 250,866 20,906 60% AMI 0 0.0% Elevator 4,730

1sy year Debt Coverage Ratio 1.151 1.151 TOTALS 43 100.0% Extermination 3,010

Grounds, snow 7,310

Additional Must-Pay Debt Service 0 0 AFFORDABILITY DISTRIBUTION - SECTION 8 SUBSIDIZED Repairs -

Debt Coverage Ratio--All Must-Pay 1.151 1.151 1BR Units 43 100.0% Maintenance salary & OT 66,000

Maintenance supplies 11,825

YEAR ONE CASH FLOW 37,882 3,157 TOTAL SEC 8 43 Maintenance contracts 7,525

NON- SEC 8 0 0.0% Decorating 4,300

CASH FLOW PAYMENTS (expected Year 1) TOTALS 43 100.0% Snow removal -

Investor Asset Mgmt Fee 6,000 Security 80,000

Deferred Developer Fee 30,000 Inspection costs -

Total Distributions (expected Year 1) 36,000 UTILITY ALLOWANCES USED (May/2023) Campus maintenance HOA fee 20,000

1BR Units 0 204,700

PRIMARY MORTGAGE ASSUMPTIONS Fixed Expenses

Amount 3,500,000 Real Estate Taxes - EXEMPT -

Interest Rate (fixed) 6.40% Insurance 20,210

Amortization (yr) 35 420 Payroll tax 32,750

Annual Payment 250,866 Workman's Comp 4,300

Term (yr) 18 57,260

CHFA App

OPERATING RESERVE ASSUMPTIONS 1 month 6 TOTAL EXPENSES 458,162 458,162 -

Operating Expens budget 39,255 235,531 Per Unit Per Annum 10,655

Debt Service (1st mortgage only) 20,906 125,433 Replacement Reserve Deposit 12,900 12,900 -

Total Initial Deposit est. 360,970 Per Unit Per Annum 300

TOTAL PROJECT EXPENSES 471,062 471,062 -

Total OpEx Per Unit Per Month 913

SANCTUARY 13,919,496 Total GC Contract Construction Loan Closing: 1-May-25 Construction Initiation (NTP): 1-May-25

CONSTRUCTION PERIOD Construction Loan Takeout: 1-Jul-27 Construction Duration: months 16

Construction Loan Duration: months 27 Construction Completion (SC/TCO): 1-Sep-26 Substantial 100% Close 8609

Completion Qualified Permanent Final

Loan Closing TCO Occupancy

NTP Balances (must reseries) PIS

BUDGET Draw # : 1 Remaining 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 TOTAL check

USES OF FUNDS TOTAL 1-May-25 After Closing 1-Jun-25 1-Jul-25 1-Aug-25 1-Sep-25 1-Oct-25 1-Nov-25 1-Dec-25 1-Jan-26 1-Feb-26 1-Mar-26 1-Apr-26 1-May-26 1-Jun-26 1-Jul-26 1-Aug-26 1-Sep-26 1-Oct-26 1-Nov-26 1-Dec-26 1-Jan-27 1-Feb-27 1-Mar-27 1-Apr-27 1-May-27 1-Jun-27 1-Jul-27 1-Aug-27 1-Sep-27 sum

1 GC On Site Work 794,909 - 794,909 46,759 46,759 46,759 46,759 46,759 46,759 46,759 46,759 46,759 46,759 46,759 46,759 46,759 46,759 46,759 46,759 46,759 - - - - - - - - - - - 794,909 -

2 GC Basic Construction 10,831,647 - 10,831,647 637,156 637,156 637,156 637,156 637,156 637,156 637,156 637,156 637,156 637,156 637,156 637,156 637,156 637,156 637,156 637,156 637,156 - - - - - - - - - - - 10,831,647 -

3 GC General Conditions 1,151,449 - 1,151,449 67,732 67,732 67,732 67,732 67,732 67,732 67,732 67,732 67,732 67,732 67,732 67,732 67,732 67,732 67,732 67,732 67,732 - - - - - - - - - - - 1,151,449 -

4 GC Contractor Profit & Overhead 527,594 - 527,594 31,035 31,035 31,035 31,035 31,035 31,035 31,035 31,035 31,035 31,035 31,035 31,035 31,035 31,035 31,035 31,035 31,035 - - - - - - - - - - - 527,594 -

5 GC Preconstruction fee 35,000 35,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 35,000 -

6 GC Construction Contingency - in GC contract 396,853 - 396,853 23,344 23,344 23,344 23,344 23,344 23,344 23,344 23,344 23,344 23,344 23,344 23,344 23,344 23,344 23,344 23,344 23,344 - - - - - - - - - - - 396,853 -

7 GC Performance Bond 101,505 101,505 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 101,505 -

8 GC General Hazard & Liability Insurance 80,539 80,539 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 80,539 -

9 GC Builder's Risk Insurance (paid by Owner) 139,465 139,465 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 139,465 -

10 Land acquisition 1,000,000 1,000,000 - - - 1,000,000 -

11 Building acquisition 300,000 300,000 - 300,000 -

12 Utility Tap Fees 817,000 817,000 - 817,000 -

13 Building Permit fees 5,000 5,000 - 5,000 -

14 Power/Telecom Provider fees 50,000 50,000 - 50,000 -

15 Civil Engineering 50,000 50,000 - 50,000 -

16 Furniture, Fixtures & Equipment 281,989 - 281,989 140,995 140,995 281,989 -

17 Owner-held contingency 705,356 - 705,356 41,492 41,492 41,492 41,492 41,492 41,492 41,492 41,492 41,492 41,492 41,492 41,492 41,492 41,492 41,492 41,492 41,492 - - - - - - - - - - - 705,356 -

18 Architect Design Services 634,342 634,342 - 634,342 -

19 Architect Supervision Services 140,965 - 140,965 8,292 8,292 8,292 8,292 8,292 8,292 8,292 8,292 8,292 8,292 8,292 8,292 8,292 8,292 8,292 8,292 8,292 - - - - - - - - - - - 140,965 -

20 Attorney, Owner real estate 25,000 25,000 - 25,000 -

21 Development/Financial Consultant 85,000 85,000 - - - - - - - - - - - - - 85,000 -

22 Survey Services 50,000 50,000 - 50,000 -

23 Materials Testing Fees 50,000 - 50,000 2,941 2,941 2,941 2,941 2,941 2,941 2,941 2,941 2,941 2,941 2,941 2,941 2,941 2,941 2,941 2,941 2,941 - - - - - - - - - - - 50,000 -

24 Construction Management, Owner 250,000 40,000 210,000 12,353 12,353 12,353 12,353 12,353 12,353 12,353 12,353 12,353 12,353 12,353 12,353 12,353 12,353 12,353 12,353 12,353 - - - - - - - - - - - 250,000 -

25 Market Studies 10,000 10,000 - 10,000 -

26 Environmental Studies, PCNA, Geotech 5,000 5,000 - - 5,000 -

27 Tax Credit fees to CHFA 111,500 111,500 - - 111,500 -

28 Tax Credit compliance fees to CHFA 21,500 - 21,500 21,500 21,500 -

29 Appraisal 10,000 10,000 - 10,000 -

30 Cost Certification 12,000 - 12,000 12,000 12,000 -

31 Partnership legal & organization 90,000 45,000 45,000 45,000 90,000 -

32 Soft Cost contingency 75,000 37,500 37,500 7,500 7,500 7,500 7,500 7,500 75,000 -

33 Construction loan origination fees 87,000 87,000 - 87,000 -

34 Construction loan interest (carried) 614,400 - 614,400 344 1,388 2,310 3,750 8,272 12,817 17,347 21,901 26,477 31,077 35,701 40,348 45,742 51,164 55,890 60,641 65,416 56,327 56,616 56,906 57,198 57,491 57,786 58,082 58,379 58,679 - - 998,050 (383,650)

35 Construction lender inspection fees 20,000 20,000 - 20,000 -

36 Construction lender legal, due diligence 50,000 50,000 - 50,000 -

37 Construction loan, title & recording fees 40,000 40,000 - 40,000 -

38 Permanent Loan Origination 66,000 66,000 - 66,000 -

39 Permanent loan MIP, app fee - - - - -

40 Bond Issuance legal fees - - - - -

41 Permanent loan, legal, title & recording fees 50,000 50,000 - - 50,000 -

42 Tenant Services Reserve - - - - - -

43 Rent-up Reserves 32,250 32,250 - 32,250 -

44 Operating Reserves 337,001 - 337,001 337,001 337,001 -

45 Developer Fee: deferred 1,200,000 - 1,200,000 1,200,000 1,200,000 -

46 Developer Fee: paid 1,435,000 100,000 1,335,000 300,000 307,891 727,109 1,435,000 -

TOTAL Uses of Funds 22,770,264 - 4,077,101 18,693,163 923,948 879,992 880,915 882,354 886,876 883,922 888,452 893,005 897,582 902,182 906,805 1,052,447 1,057,841 922,268 926,995 931,745 1,236,521 56,327 56,616 56,906 57,198 57,491 57,786 58,082 58,379 1,937,071 - 727,109 23,153,914 (383,650)

SOURCES OF FUNDS

1 Construction Loan 67,100 203,688 179,992 280,915 882,354 886,876 883,922 888,452 893,005 897,582 902,182 906,805 1,052,447 1,057,841 922,268 926,995 931,745 (1,773,480) 56,327 56,616 56,906 57,198 57,491 57,786 58,082 58,379 (11,449,473) - - (0)

2 Project Operating Income (interest credit) - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

3 First Mortgage 3,500,000 - 3,500,000 - - - - - - - - - - - - - - - - - - - - - - - - - 3,500,000 - - 3,500,000 -

4 City of Aurora funds: ARPA (Sponsor loan #1) 1,000,000 1,000,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 1,000,000 -

5 County of Arapahoe funds: ARPA (Sponsor loan #1) 1,200,000 - 1,200,000 500,000 700,000 - - - - - - - - - - - - - - - - - - - - - - - - - - 1,200,000 -

6 Arapahoe County: HOME (Sponsor loan #2) 600,000 - 600,000 - - 600,000 - - - - - - - - - - - - - - - - - - - - - - - - - 600,000 -

7 Remaining GAP funds (Sponsor loan #1) 220,260 - 220,260 220,260 - - - - - - - - - - - - - - - - - - - - - - - - - - - 220,260 -

8 LIHTC Investor proceeds (Fed & State credit) 15,050,004 3,010,001 12,040,003 - - - - - - - - - - - - - - - - 3,010,001 - - - - - - - - 8,729,002 - 301,000 15,050,004 -

9 AHA Deferred Developer Fee 1,200,000 - 1,200,000 1,200,000 1,200,000 -

10 Other - - - - - -

TOTAL Sources of Funds 22,770,264 - 4,077,101 18,693,163 923,948 879,992 880,915 882,354 886,876 883,922 888,452 893,005 897,582 902,182 906,805 1,052,447 1,057,841 922,268 926,995 931,745 1,236,521 56,327 56,616 56,906 57,198 57,491 57,786 58,082 58,379 1,979,529 - 301,000 22,770,264 -funds in excess of current month expense - - - - - - - - - - - - - - - - - - - - - - - - - - 42,459 - (426,109) (383,650) 383,650

FUNDS DISBURSEMENT SCHEDULES 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 -

Construction Loan Disbursement (Source line 1) 67,100 203,688 179,992 280,915 882,354 886,876 883,922 888,452 893,005 897,582 902,182 906,805 1,052,447 1,057,841 922,268 926,995 931,745 (1,773,480) 56,327 56,616 56,906 57,198 57,491 57,786 58,082 58,379 (11,449,473) - - -

Construction Loan Payoffs - - - - - - - - - - - - - - - - - -

Construction Loan Balance 67,100 270,788 450,780 731,695 1,614,049 2,500,926 3,384,847 4,273,299 5,166,304 6,063,885 6,966,067 7,872,872 8,925,320 9,983,161 10,905,429 11,832,423 12,764,169 10,990,689 11,047,016 11,103,632 11,160,538 11,217,736 11,275,227 11,333,012 11,391,094 11,449,473 - - - -

Construction Interest Charge 614,400 6.15% 344 1,388 2,310 3,750 8,272 12,817 17,347 21,901 26,477 31,077 35,701 40,348 45,742 51,164 55,890 60,641 65,416 56,327 56,616 56,906 57,198 57,491 57,786 58,082 58,379 58,679 - - -

Construction Interest Credit from Ops (Source line 2) - -

Construction Interest Carried on Loan 344 1,388 2,310 3,750 8,272 12,817 17,347 21,901 26,477 31,077 35,701 40,348 45,742 51,164 55,890 60,641 65,416 56,327 56,616 56,906 57,198 57,491 57,786 58,082 58,379 58,679 - - -

593,530

LIHTC Investor Installment # Investor #2 Investor #3 Investor #4 LIHTC Investor disbursements (Source line 8) 15,050,004 3,010,001 12,040,003 3,010,001 - - 8,729,002 301,000 15,050,004 -

Project Operating Income (from lease-up page) 84,000 - 84,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - 84,000

First Mortgage Disbursement (Source line 3) 3,500,000 3,500,000 3,500,000 3,500,000 -

City of Aurora Disbursements (Source line 4) 1,000,000 1,000,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - 1,000,000 -

Arapahoe ARPA Disbursements (Source line 5) 1,200,000 - 1,200,000 500,000 700,000 - - - - - - - - - - - - - - - - - - - - - - 1,200,000 -

Arapahoe HOME Disbursements (Source line 6) 600,000 - 600,000 - - 600,000 - - - - - - - - - - - - - - - - - - - - - - - 600,000 -

AHA GAP Loan disbursements (Source line 7) 220,260 - 220,260 220,260

Payout of soft debt (Source lines 4,5,6,7) 3,020,260 1,000,000 720,260 700,000 600,000 - - - - - - - - - - - - - - - - - - - - - - - - - 3,020,260 -

Cumulative Paid out 1,000,000 1,720,260 2,420,260 3,020,260 3,020,260 3,020,260 3,020,260 3,020,260 3,020,260 3,020,260 3,020,260 3,020,260 3,020,260 3,020,260 3,020,260 3,020,260 3,020,260 3,020,260 3,020,260 3,020,260 3,020,260 3,020,260 3,020,260 3,020,260 3,020,260 3,020,260 3,020,260

Remaining balance of AHA Equity 2,020,260 1,300,000 600,000 - - - - - - - - - - - - - - - - - - - - - - - -

Cumulative Paid out 100% 33% 57% 80% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100%

Close-out PeriodStabilization PeriodLease-up Period

SANCTUARY EOM 4 12

LEASE-UP PERIOD Fully TCO/PIS 100% Qualified Stabilization months months

Stabilized Received (must reseries) Occupancy Perm Conversion Sep - Dec Jan - Dec

Monthly Sep-26 Oct-26 Nov-26 Dec-26 Jan-27 Feb-27 Mar-27 Apr-27 May-27 Jun-27 Jul-27 Aug-27 Sep-27 Oct-27 Nov-27 Dec-27 2026 2027

Levels

Units Leased and Occuppied (BoM) 43 0 8 18 28 38 43 43 43 43 43 43 43 43 43 43 43 54 511

INCOME 0% 0% 19% 42% 65% 88% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% variable variable

Gross Rental Income 66,134 - - 12,304 27,684 43,064 58,444 66,134 66,134 66,134 66,134 66,134 66,134 66,134 66,134 66,134 66,134 39,988 762,848

Other Income 516 - - 96 216 336 456 516 516 516 516 516 516 516 516 516 516 312 5,952

Less Vacancy (Sec 8) (3,333) - - (620) (1,395) (2,170) (2,945) (3,333) (3,333) (3,333) (3,333) (3,333) (3,333) (3,333) (3,333) (3,333) (3,333) (2,015) (38,440)

NET RENTAL INCOME 63,318 - - 11,780 26,505 41,230 55,955 63,318 63,318 63,318 63,318 63,318 63,318 63,318 63,318 63,318 63,318 38,285 730,360

EXPENSES - 15% 25% 50% 75% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% variable 100%

Administration 9,000 1,350 2,250 4,500 6,750 9,000 9,000 9,000 9,000 9,000 9,000 9,000 9,000 9,000 9,000 9,000 9,000 14,850 108,000

Operations 7,350 1,103 1,838 3,675 5,513 7,350 7,350 7,350 7,350 7,350 7,350 7,350 7,350 7,350 7,350 7,350 7,350 12,128 88,202

Maintenance 17,058 2,559 4,265 8,529 12,794 17,058 17,058 17,058 17,058 17,058 17,058 17,058 17,058 17,058 17,058 17,058 17,058 28,146 204,700

Fixed Expenses 4,772 716 1,193 2,386 3,579 4,772 4,772 4,772 4,772 4,772 4,772 4,772 4,772 4,772 4,772 4,772 4,772 7,873 57,260

TOTAL EXPENSES: 38,180 5,727 9,545 19,090 28,635 38,180 38,180 38,180 38,180 38,180 38,180 38,180 38,180 38,180 38,180 38,180 38,180 62,997 458,162

NET OPERATING INCOME 25,137 (5,727) (9,545) (7,310) (2,130) 3,050 17,775 25,137 25,137 25,137 25,137 25,137 25,137 25,137 25,137 25,137 25,137 (24,712) 272,198

Replacement Reserve Deposit 1,075 - - - - - - 1,075 1,075 1,075 1,075 1,075 1,075 1,075 1,075 1,075 1,075 - 10,750

ADJUSTED NET OPERATING INCOME 24,062 (5,727) (9,545) (7,310) (2,130) 3,050 17,775 24,062 24,062 24,062 24,062 24,062 24,062 24,062 24,062 24,062 24,062 (24,712) 261,448

Construction loan interest payments - - - - - - 21,000 21,000 21,000 21,000 - - - - - - - 84,000

1st Mortgage Debt Service 20,906 - - - - - - - - - - 20,906 20,906 20,906 20,906 20,906 20,906 - 125,433

Other required debt service - - - - - - - - - - - - - - - - - - -

CASH FLOW AFTER REQ. DEBT SERVICE 3,157 (5,727) (9,545) (7,310) (2,130) 3,050 17,775 3,062 3,062 3,062 3,062 3,157 3,157 3,157 3,157 3,157 3,157 (24,712) 52,015

Note: Ability to cover mortgage payments after achieving 100% quialified occupancy but before perm loan conversion shown as applied to construction interest

NOI Deficit funded by Rent-up Reserve 24,712 5,727 9,545 7,310 2,130 - - 24,712 -

LIHTC DATES

Construction Completion (TCO recvd) 1-Sep-26 adjusted to first day of month

Placed in Service date 1-Sep-26 adjusted to first day of month

100% Qualified Occupancy achieved 1-Mar-27

UNIT DELIVERY SCHEDULE (Qualified Occupancy) LIHTC Occupancy %

New Units Cumulative 2025 2026

Unit Delivery Schedule by Oct 1, 2026 8 8 19% 0% by November 1, 2026 10 18 42% 0% by December 1, 2026 10 28 65% 0% by January 1, 2027 10 38 88% by February 1, 2027 5 43 100% by March 1, 2027 0 43 100%

Total LIHTC Occupancy 43 43 100%

2025 2026

State Credit Earned for Year 100% 100%

Federal Credit Earned for Year (proportional) 10.47% 99.03%

Eligible Unit Months 54 511

Potential Eligible Unit Months for year 516 516

17 YEAR CASH FLOW

Lease-Up 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

Inflator 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043

INCOME

Gross Rental Income 2.0% 39,988 762,848 809,480 825,670 842,183 859,027 876,207 893,732 911,606 929,838 948,435 967,404 986,752 1,006,487 1,026,617 1,047,149 1,068,092 1,089,454

Other Income 2.0% 312 6,192 6,316 6,442 6,571 6,702 6,836 6,973 7,113 7,255 7,400 7,548 7,699 7,853 8,010 8,170 8,334 8,500

Less Vacancy 5.0% (2,015) (39,990) (41,990) (41,606) (42,438) (43,286) (44,152) (45,035) (45,936) (46,855) (47,792) (48,748) (49,723) (50,717) (51,731) (52,766) (53,821) (54,898)

NET RENTAL INCOME 38,285 729,050 773,807 790,506 806,316 822,443 838,892 855,669 872,783 890,239 908,043 926,204 944,728 963,623 982,895 1,002,553 1,022,604 1,043,056

EXPENSES

Administration 3.0% 14,850 108,000 111,240 114,577 118,015 121,555 125,202 128,958 132,826 136,811 140,916 145,143 149,497 153,982 158,602 163,360 168,260 173,308

Operations 3.0% 12,128 88,202 90,848 93,574 96,381 99,272 102,250 105,318 108,477 111,732 115,084 118,536 122,092 125,755 129,528 133,413 137,416 141,538

Maintenance 3.0% 28,146 204,700 210,841 217,166 223,681 230,392 237,303 244,423 251,755 259,308 267,087 275,100 283,353 291,853 300,609 309,627 318,916 328,483

Fixed Expenses 3.0% 7,873 57,260 58,978 60,747 62,570 64,447 66,380 68,371 70,423 72,535 74,711 76,953 79,261 81,639 84,088 86,611 89,209 91,885

TOTAL EXPENSES: 62,997 458,162 471,907 486,064 500,646 515,665 531,135 547,069 563,481 580,386 597,797 615,731 634,203 653,229 672,826 693,011 713,801 735,216

NET OPERATING INCOME (24,712) 270,888 301,900 304,442 305,670 306,777 307,756 308,600 309,301 309,853 310,246 310,473 310,525 310,393 310,069 309,542 308,803 307,841

Replacement Reserve Deposit 3.0% - 10,750 13,287 13,686 14,096 14,519 14,955 15,403 15,865 16,341 16,832 17,337 17,857 18,392 18,944 19,512 20,098 20,701

ADJUSTED NET OPERATING INCOME (24,712) 260,138 288,613 290,757 291,574 292,258 292,802 293,197 293,436 293,511 293,414 293,136 292,668 292,001 291,125 290,030 288,705 287,140

Construction loan interest payments - 84,000

1st Mortgage Debt Service - 125,433 250,866 250,866 250,866 250,866 250,866 250,866 250,866 250,866 250,866 250,866 250,866 250,866 250,866 250,866 250,866 250,866

Other required debt service - - - - - - - - - - - - - - - - - -

CASH FLOW AFTER REQ. DEBT SERVICE (24,712) 50,705 37,746 39,890 40,708 41,392 41,935 42,331 42,570 42,645 42,548 42,270 41,802 41,135 40,259 39,163 37,839 36,274

CASH FLOW DEBT SERVICE & FEES inflation

Land Lease payments (not applicable) - - - - - - - - - - - - - - - - -

Operating Reserve Draw Down - - - - - - - - - - - - - - - - - -

Investor Asset Mgmt Fee 3% - 6,000 6,180 6,365 6,556 6,753 6,956 7,164 7,379 7,601 7,829 8,063 8,305 8,555 8,811 9,076 9,348 9,628

Deferred Developer Fee 44,705 31,566 33,525 34,152 34,639 34,980 35,166 35,190 35,044 34,719 34,206 33,497 32,580 31,447 30,088 (684,495) - GP Capital Contribution required

General Partner Asset Mgmt Fee 3% - - - - - - - - - - - - - - - - 25,000 25,750

Subordinate Loan #1 (Sponsor/COA$) 4% - - - - - - - - - - - - - - - - 1,745 448

Subordinate Loan #2 (CDOH) 1% - - - - - - - - - - - - - - - - 1,745 448

TOTAL CASH FLOW PAYMENTS - 50,705 37,746 39,890 40,708 41,392 41,935 42,331 42,570 42,645 42,548 42,270 41,802 41,135 40,259 39,163 (646,656) 36,274

REMAINING CASH FLOW (24,712) - - - - - - - - - - - - - - - - -

Distributed to LP

Distributed to GP

Deferred Developer Fee (DDF) Payments as shown - 44,705 31,566 33,525 34,152 34,639 34,980 35,166 35,190 35,044 34,719 34,206 33,497 32,580 31,447 30,088

Outstanding balance of DDF 1,200,000 1,200,000 1,155,295 1,123,729 1,090,204 1,056,052 1,021,413 986,433 951,267 916,077 881,032 846,313 812,107 778,610 746,030 714,583 684,495 GP Capital Contribution required

DCR on first mortgage debt service not applicable 2.07 1.15 1.16 1.16 1.16 1.17 1.17 1.17 1.17 1.17 1.17 1.17 1.16 1.16 1.16

EXITCOMPLIANCE PERIODTAX CREDIT PERIOD

15 YEAR TAX PROJECTIONS

Lease-Up 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

01-Sep-26 First Bldg P.I.S. Date Rates 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043

NET OPERATING INCOME (24,712) 260,138 288,613 290,757 291,574 292,258 292,802 293,197 293,436 293,511 293,414 293,136 292,668 292,001 291,125 290,030

Interest Expense (paid & accrued)

Construction loan - - - - - - - - - - - - - - - -

First Mortgage loan 6.40% - 168,000 226,724 225,179 223,535 221,786 219,925 217,945 215,838 213,596 211,211 208,673 205,972 203,099 200,042 196,789

Sponsor Loan #1 3.00% - 72,608 74,786 77,030 79,341 81,721 84,172 86,698 89,298 91,977 94,737 97,579 100,506 103,521 103,521 103,521

Sponsor Loan #2 3.00% - 18,000 18,540 20,851 23,231 25,683 28,208 30,809 33,488 36,247 39,089 42,017 45,032 48,137 51,243 54,349

Other loans 0.00% - - - - - - - - - - - - - - - -

Other Expense

Investor Asset Mgmt Fee 3.00% 6,000 6,180 6,365 6,556 6,753 6,956 7,164 7,379 7,601 7,829 8,063 8,305 8,555 8,811 9,076

Ground Lease 0.00% - - - - - - - - - - - - - - - -

Other 0.00% - - - - - - - - - - - - - - - -

GP Asset Mgmt Fee 3.00% - - - - - - - - - - - - - - - -

Depreciation & Amortization (see table) * - 1,780,972 678,863 678,863 678,863 678,863 678,863 678,863 678,863 678,863 678,863 678,863 678,863 678,863 678,863 678,863

TAXABLE INCOME (LOSS) (24,712) (1,785,442) (716,481) (717,532) (719,952) (722,548) (725,323) (728,282) (731,431) (734,773) (738,314) (742,059) (746,011) (750,175) (751,356) (752,568)

Allocation of income/ losses SUMMARY

To General Partner 0.01% (2) (179) (72) (72) (72) (72) (73) (73) (73) (73) (74) (74) (75) (75) (75) (75)

To Investor Limited Partner 99.99% (24,710) (1,785,264) (716,409) (717,460) (719,880) (722,475) (725,250) (728,209) (731,357) (734,700) (738,240) (741,984) (745,936) (750,100) (751,281) (752,493) (12,085,750)

LP BENEFIT ANALYSIS

from Tax Losses 21% 5,189 374,905 150,446 150,667 151,175 151,720 152,303 152,924 153,585 154,287 155,030 155,817 156,647 157,521 157,769 158,024 1,752,231 from Tax Credits, based on annual alloc = 1,408,140 1,394,495 1,408,140 1,408,140 1,408,140 1,408,140 1,408,140 1,408,140 1,408,140 1,408,140 1,408,140 13,645 - - - - - 14,081,400 from State Tax Credits, annual alloc = 700,000 700,000 700,000 700,000 700,000 700,000 700,000 - 4,200,000

MINIMUM GAIN ANALYSIS

Total Non-Recourse debt - 7,808,730 7,904,837 8,001,995 8,101,574 8,203,747 8,308,696 8,416,604 8,527,661 8,642,060 8,760,001 8,881,686 9,007,322 9,030,496 9,051,746 9,071,102

Total Net Assets ######### 22,335,013 20,554,041 19,875,177 19,196,314 18,517,450 17,838,587 17,159,723 16,480,860 15,801,996 15,123,133 14,444,269 13,765,406 13,086,542 12,407,679 11,728,815 11,049,952

Net 22,335,013 12,745,311 11,970,340 11,194,318 10,415,876 9,634,839 8,851,027 8,064,255 7,274,335 6,481,073 5,684,269 4,883,720 4,079,220 3,377,183 2,677,070 1,978,850

* Depreciation Note: New 2018 depreciation rules used here. See Depreciation sheet for detail.

TAX CREDIT PERIOD COMPLIANCE PERIOD EXIT

AMORTIZING LOANS

Lease-Up 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043

Rate

First Mortgage: TBD

Begin UPB 3,500,000 3,542,567 3,518,425 3,492,738 3,465,407 3,436,326 3,405,385 3,372,463 3,337,435 3,300,164 3,260,509 3,218,315 3,173,421 3,125,653 3,074,829 3,020,752 2,963,213

Payment PAY 125,433 250,866 250,866 250,866 250,866 250,866 250,866 250,866 250,866 250,866 250,866 250,866 250,866 250,866 250,866 250,866 250,866 to Interest 6.400% - 168,000 226,724 225,179 223,535 221,786 219,925 217,945 215,838 213,596 211,211 208,673 205,972 203,099 200,042 196,789 193,328 189,646 to Principal - (42,567) 24,142 25,687 27,331 29,080 30,941 32,922 35,029 37,270 39,656 42,194 44,894 47,767 50,824 54,077 57,538 61,221

End UPB - 3,542,567 3,518,425 3,492,738 3,465,407 3,436,326 3,405,385 3,372,463 3,337,435 3,300,164 3,260,509 3,218,315 3,173,421 3,125,653 3,074,829 3,020,752 2,963,213 2,901,993

Deferred Developer Fee (cash flow)

Begin UPB - 1,200,000 1,155,295 1,123,729 1,090,204 1,056,052 1,021,413 986,433 951,267 916,077 881,032 846,313 812,107 778,610 746,030 714,583 684,495 684,495

CF Payment PAY - 44,705 31,566 33,525 34,152 34,639 34,980 35,166 35,190 35,044 34,719 34,206 33,497 32,580 31,447 30,088 - -to Interest 0.000% - - - - - - - - - - - - - - - - - -to Principal - 44,705 31,566 33,525 34,152 34,639 34,980 35,166 35,190 35,044 34,719 34,206 33,497 32,580 31,447 30,088 - -

End UPB - 1,155,295 1,123,729 1,090,204 1,056,052 1,021,413 986,433 951,267 916,077 881,032 846,313 812,107 778,610 746,030 714,583 684,495 684,495 684,495

Ground Lease (not applicable)

Begin UPB - - - - - - - - - - - - - - - - - -

New charge - - - - - - - - - - - - - - - - -

CF Payment TBD - - - - - - - - - - - - - - - - - -to Interest 0.000% - - - - - - - - - - - - - - - - -to Principal - - - - - - - - - - - - - - - - - -

End UPB - - - - - - - - - - - - - - - - - -

Sponsor Loan #1 - ARPA $ & GAP (cash flow)

Begin UPB - 2,420,260 2,492,868 2,567,654 2,644,683 2,724,024 2,805,745 2,889,917 2,976,615 3,065,913 3,157,890 3,252,627 3,350,206 3,450,712 3,450,712 3,450,712 3,450,712 3,452,457

Interest Charge 3.000% - 72,608 74,786 77,030 79,341 81,721 84,172 86,698 89,298 91,977 94,737 97,579 100,506 103,521 103,521 103,521 103,521 103,574

CF Payment - - - - - - - - - - - - - - - - 1,745 448 to Interest - - - - - - - - - - - - - - - - 1,745 448 to Principal - - - - - - - - - - - - - - - - - -

End UPB - 2,492,868 2,567,654 2,644,683 2,724,024 2,805,745 2,889,917 2,976,615 3,065,913 3,157,890 3,252,627 3,350,206 3,450,712 3,450,712 3,450,712 3,450,712 3,452,457 3,452,905

Sponsor Loan #2 - HOME $ (cash flow)

Begin UPB - 600,000 618,000 695,030 774,370 856,091 940,263 1,026,961 1,116,259 1,208,237 1,302,973 1,400,552 1,501,058 1,604,580 1,708,101 1,811,622 1,915,144 2,016,972

Interest Charge 3.000% - 18,000 18,540 20,851 23,231 25,683 28,208 30,809 33,488 36,247 39,089 42,017 45,032 48,137 51,243 54,349 57,454 60,509

CF Payment - - - - - - - - - - - - - - - - 1,745 448 to Interest - - - - - - - - - - - - - - - - 1,745 448 to Principal - - - - - - - - - - - - - - - - - -

End UPB 618,000 695,030 774,370 856,091 940,263 1,026,961 1,116,259 1,208,237 1,302,973 1,400,552 1,501,058 1,604,580 1,708,101 1,811,622 1,915,144 2,016,972 2,016,524

TOTAL NON-RECOURSE DEBT EOY - 7,808,730 7,904,837 8,001,995 8,101,574 8,203,747 8,308,696 8,416,604 8,527,661 8,642,060 8,760,001 8,881,686 9,007,322 9,030,496 9,051,746 9,071,102 9,117,138 9,055,917

DEPRECIATION & AMORTIZATION SCHEDULES TOTALS

Total Lease-Up 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 FOR

Amount 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 15 YEARS

0% 100%

Depreciation

Property - First Year 1,102,109 - 1,102,109 1,102,109

Property - 15 year - MACRS - - - - - - - - - - - - - - - - - -

Property - 30 year 20,049,904 - 668,330 668,330 668,330 668,330 668,330 668,330 668,330 668,330 668,330 668,330 668,330 668,330 668,330 668,330 668,330 10,024,952

Amortization

Tax Credit fees - 15 year 133,000 - 8,867 8,867 8,867 8,867 8,867 8,867 8,867 8,867 8,867 8,867 8,867 8,867 8,867 8,867 8,867 133,000

Permanent loan fees - 30 year 50,000 - 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 1,667 25,000

TOTALS BY YEAR - 1,780,972 678,863 678,863 678,863 678,863 678,863 678,863 678,863 678,863 678,863 678,863 678,863 678,863 678,863 678,863 11,285,061

CURRENT LIHTC First Year 15 Year 30 Year 15 Year 30 Year

PROJECTIONS Eligible Depreciation Depreciation Depreciation Amortization Amortization

USES OF FUNDS TOTAL Basis * Property Property Property Fees Fees

1 GC On Site Work 794,909 794,909 794,909 Assume: First Year depreciation eligible

2 GC Basic Construction 10,831,647 10,831,647 10,831,647 change *** from 30 yr dep to 30 yr am

3 GC General Conditions 1,151,449 1,151,449 1,151,449

4 GC Contractor Profit & Overhead 527,594 527,594 527,594

5 GC Preconstruction fee 35,000 35,000 35,000

6 GC Construction Contingency - in GC contract 396,853 396,853 396,853

7 GC Performance Bond 101,505 101,505 101,505

8 GC General Hazard & Liability Insurance 80,539 80,539 80,539

9 GC Builder's Risk Insurance (paid by Owner) 139,465 139,465 139,465

10 Land acquisition (leased, not purchased) 1,000,000 -

11 Building acquisition 300,000 - 300,000

12 Utility Tap Fees 817,000 817,000 817,000

13 Building Permit fees 5,000 5,000 5,000

14 Power/Telecom Provider fees 50,000 50,000 50,000

15 Civil Engineering (included in Architecture) 50,000 50,000 50,000

16 Furniture, Fixtures & Equipment 281,989 281,989 281,989 change from 1st yr dep to 30 year dep

17 Owner-held contingency 705,356 705,356 705,356

18 Architect Design Services 634,342 634,342 634,342

19 Architect Supervision Services 140,965 140,965 140,965

20 Attorney, Owner real estate 25,000 25,000 25,000

21 Development/Financial Consultant 85,000 85,000 85,000

22 Survey Services 50,000 50,000 50,000

23 Materials Testing Fees 50,000 50,000 50,000

24 Construction Management, Owner 250,000 250,000 250,000

25 Market Studies 10,000 10,000 10,000

26 Environmental Studies, PCNA, Geotech 5,000 5,000 5,000

27 Tax Credit fees to CHFA 111,500 - 111,500

28 Tax Credit compliance fees to CHFA 21,500 - 21,500

29 Appraisal 10,000 10,000 10,000

30 Cost Certification 12,000 12,000 12,000

31 Partnership legal & organization 90,000 - 90,000

32 Soft Cost contingency 75,000 75,000 75,000

33 Construction loan origination fees (proportional) 87,000 87,000 87,000

34 Construction loan interest 614,400 307,200 307,200 307,200 change *** from 30yr dep to 1st year expense

35 Construction lender inspection fees 20,000 20,000 20,000

36 Construction lender legal, due diligence 50,000 50,000 50,000

37 Construction loan, title & recording fees 40,000 40,000 40,000

38 Permanent loan MIP, app fee - - - ?? 30 yr am vs 18 yr am ??

39 Bond Issuer legal fees - - - ?? 30 yr am vs 18 yr am ??

40 Permanent loan, legal, title & recording fees 50,000 - 50,000 ?? 30 yr am vs 18 yr am ??

41 Tenant Services Reserve - - - Assume: First Year depreciation eligible

42 Rent-up Reserves 32,250 -

43 Operating Reserves 337,001 -

44 Developer Fee: deferred 1,200,000 1,200,000 1,200,000

45 Developer Fee: paid 1,435,000 1,435,000 1,435,000

TOTAL Uses of Funds 22,704,264 20,454,813 1,102,109 - 20,049,904 133,000 50,000

Depreciable & Amortized Assets 21,335,013 1,102,109 - 20,049,904 133,000 50,000

SANCTUARY update: 1-Jul-24

WATERFALL PRIORITIES & RULES

Total Year 1 Annual Pymt Interest

PAYMENTS FROM NET OPERATING INCOME Obligation Payment Increase on UPB

(stabilized)

Required Debt Service & Payments

1 First Mortgage Debt Service 3,500,000 125,433 none n/a

2 Reserve for Replacements deposit annual 10,750 3.00% n/a

Cash Flow Dependant Payments

3 LP Investor Services Fee annual 6,000 3.00% 0.00%

4 Deferred Developer Fee payment 1,200,000 variable 0.00% 0.00%

5 Ground Lease (not applicable) - - n/a n/a

6 GP Partnership Management Fee annual 25,000 3.00% 0.00% payments begin after DDF fully paid

7 Sponsor Loan #1 - variable none 3.00% @ AFR 50% of available CF after DDF paid off

8 Sponsor Loan #2 - variable none 3.00% @ AFR 50% of available CF after DDF paid off

Remaining Cash Distribution

9 LP 99.99% annual variable none none

10 GP 00.01% annual variable none none

PUBLISHED REFERENCES

CHFA RENT & INCOME LIMITS

Effective: 2023 County: ADAMS County Median Income: HUD Release Date: May 15,2023

AMI

0 BR 1 BR 2BR 3BR 4BR 1 Person 2 Person 3 Person 4 Person 5 Person 6 Person 7 Person 8 Person

120% 2,607 2,793 3,351 3,873 4,320 104,280 119,160 134,040 148,920 160,920 172,800 184,680 196,680

100% 2,172 2,327 2,792 3,227 3,600 86,900 99,300 111,700 124,100 134,100 144,000 153,900 163,900

80% 1,738 1,862 2,234 2,582 2,880 69,520 79,440 89,360 99,280 107,280 115,200 123,120 131,120

70% 1,520 1,629 1,954 2,259 2,520 60,830 69,510 78,190 86,870 93,870 100,800 107,730 114,730

60% 1,303 1,396 1,675 1,936 2,160 52,140 59,580 67,020 74,460 80,460 86,400 92,340 98,340

55% 1,194 1,280 1,535 1,775 1,843 47,795 54,615 61,435 68,255 73,755 79,200 84,645 90,145

50% 1,086 1,163 1,396 1,613 1,800 43,450 49,650 55,850 62,050 67,050 72,000 76,950 81,950

45% 977 1,047 1,256 1,452 1,620 39,105 44,685 50,265 55,845 60,345 64,800 69,255 73,755

40% 869 931 1,117 1,291 1,440 34,760 39,720 44,680 49,640 53,640 57,600 61,560 65,560

30% 651 698 837 968 1,080 26,070 29,790 33,510 37,230 40,230 43,200 46,170 49,170

20% 434 465 558 645 720 17,380 19,860 22,340 24,820 26,820 28,800 30,780 32,780

AMI CHFA ELIGIBLE BASIS LIMITS CHFA SCORING ITEMS

0 BR 1 BR 2BR 3BR 4BR Effective: 2023 QAP Effective: 2023 QAP

# Persons 1.0 1.5 3.0 4.5 6.0 Zone: 1 Non-Elevator City/Cnty: AURORA

120% 104,280 111,720 134,040 154,920 172,800 Elevator Non-Elev Table Score

100% 86,900 93,100 111,700 129,100 144,000 0 BR 320,641 256,874 C-1 12

80% 69,520 74,480 89,360 103,280 115,200 1 BR 367,588 291,576 C-2 4

70% 60,830 65,170 78,190 90,370 100,800 2 BR 446,958 352,438

60% 52,140 55,860 67,020 77,460 86,400 3 BR 578,210 442,373

50% 43,450 46,550 55,850 64,550 72,000

45% 39,105 41,895 50,265 58,095 64,800

40% 34,760 37,240 44,680 51,640 57,600 CHFA LIHTC APPLICABLE PERCENTAGES

30% 26,070 27,930 33,510 38,730 43,200 Month: Jun-24 FIXED 9%/FIXED 4%

70% Present Value Credit 9.00%

30% Present Value Credit 4.00%

HUD FAIR MARKET RENT LIMITS: 2022 AHA PAYMENT STANDARDS

AREA: DENVER MSA HUD Publication: 2-Feb-23 LIHTC INVESTOR quoted rate: CHFA recommended

FMR Update: Jun-24

0 BR 1 BR 2BR 3BR 4BR 9% Credit Equity Rate 0.860$

1390 1538 1856 2449 2750 4% Credit Equity Rate -$

Colorado State Credit Rate 0.700$

UTILITY ALLOWANCES

PHA Source: AHA effective: 2023 PHA Published: MARKET RENT ESTIMATE

Eligible In Rent or Pd by Ten Type 0 BR 1 BR 2BR 3BR 4BR Source:

Heat Paid by Tenant Elec 0 0 0 0 0 Market:

Hot Water Paid by Tenant Elec 0 0 0 0 0 Ref Date:

Range Paid by Tenant Elec 0 0 0 0 0 Avg Rent

Other, A/C Paid by Tenant Elec 0 0 0 0 0 0 BR -

Water Paid by OWNER Water 0 0 0 0 0 1BR -

Other Paid by TENANT ALL 0 0 0 0 0 2BR-1BA -

0 0 0 0 0 2BR-2BA -

Utility Chargeback by Owner (if applicable) 0 0 0 0 0 3 BR -

0 0 0 0 0 ALL -

RENT SCHEDULE FOR PROJECT: SANCTUARY

Unit AMI MAX* UA MAX NET ACTUAL SQ FT #

1 Br 1 Ba 30 - Sec8 698 0 698 1,538$ 492 33 LENDER quoted loan rate: CHFA Risk Share

1 Br 1 Ba 40 - Sec8 931 0 931 1,538$ 492 0 Update: TaxEx Taxable

1 Br 1 Ba 50 - Sec8 1,163 0 1,163 1,538$ 492 10 Construction Financing 6.150% 6.150%

1 Br 1 Ba 60 - Sec8 1,396 0 1,396 1,538$ 492 0 Permanent Financing 6.400% 6.400%

Subordinate Debt Rate 3.00%

INTEREST RATE ENVIRONMENT

Update:

SOFR 2 Year 10 Year AFR n/a 4.93% 4.49% 4.83%

* MAX is * MAX NET Sec 8 43 APPLICABLE FEDERAL RATE - LT

LIHTC is LIHTC Overide Update: November 1, 2023 table limit less UA rents Current Rate: 4.83% long term rate today

Sponsor Loan Rate: 4.00%

CDOH Limitations for Funding (NEW CONSTRUCTION)

TDC less exclusions (land, DF/C, reserves) 18,800,264

Allowable Percentage 12%

Maximum Developer fee 2,256,032 not OK 2,635,000

Minimum DDF at 20% 46% OK 1,200,000

Maximum operating PUPA of 6,000 not OK 10,655

November 8, 2023

June 1, 2024

MAXIMUM RENTS MAXIMUM INCOME LIMITS

PROJECTED MAXIMUM INCOME BY UNIT SIZE

MAXIMUM RENTS

TOTAL ALLOWANCE FOR UNIT SIZE:

UTILITY ALLOWANCE PLUS CHARGEBACK:

File details come from the government source that posted it. Updated .