Loading...
HomeMy WebLinkAbout#Funds 148-149 RFP to HFB - Revised2023 Affordable Housing 148 & Homeless Housing 149 January - Current BEGINNING FUND BALANCE REVENUES County Sales Tax (1406) - Support Housing-Sales Use Tax City Sales Tax (1406) - City Contribution Sales Use Tax Sales Tax (1590) Investment Interest Shelter Program Grant Recording Fees Misc Revenue TOTAL REVENUES EXPENSES Community Build - Caswell Brown Dove House - Emergency Shelter Dove House - Housing Support Habitat for Humanity Habitat for Humanity - Landes Family Homes Fairgrounds Housing Bayside PTAC Heaters Bayside Shelter - Woodley Place Bayside Housing - Tiny OlyCAP 7th Haven Project OlyCAP Caswell Brown OlyCap Adult Shelter - Emergency Shelter OlyCap Haines Street Cottages Olycap 1590 funds - Mill Rd completion Pfeiffer House/Owl 360 Treasurer Financial Service Fees RFP Budget - 1590 TOTAL EXPENSES Change in Fund Balance ENDING FUND BALANCE Estimated 2024 Revenues Total Available (including prior year RFP not allocated) Calculated RFP Amount Recommended RFP Amount 2023 Budget 148 223017 62000 585000 350 40000 0 687350 20000 12000 95000 60000 100000 100000 40000 39920 34000 148920 649840 37510 260527 647000 1056447 991747 992000 149 276832 1500 10000 234000 0 245500 85000 0 10000 144500 0 180000 0 0 419500 -174000 102832 274000 376832 349432 350000 TOTAL 499849 62000 0 585000 1850 10000 274000 0 932850 20000 97000 95000 60000 0 0 0 110000 144500 0 100000 180000 40000 34000 0 148920 1009420 -76570 423279 2023 Actual 148 223017 29904 14695 538054 13761 19370 0 615784 20000 3107 44819 42323 63864 9421 26418 16085 226037 389747 612764 149 276832 8479 34609 153737 11.95 196836.95 40142 41 49180 104606 193969 2867.95000000001 279699.95 9/13/2023 TOTAL 499849 29904 14695 538054 22240 34609 173107 11.95 812620.95 20000 43249 44819 42323 0 0 0 63905 49180 0 9421 104606 26418 16085 0 0 400006 412614.95 912463.95 Available Amount 32096 -14695 46946 -20390 -24609 100893 -11.95 120229.05 0 53751 50181 17677 0 0 0 46095 95320 0 90579 75394 13582 17915 0 148920 609414 Budget % 0.482322580645161 Over 0.919750427350427 Over Over 0.631777372262774 Over 1 0.445865979381443 0.471778947368421 0.705383333333333 0.580954545454546 0.340346020761246 0.09421 0.581144444444444 0.66045 0.473088235294118 0 0 0.396273107328961 Sales Tax: Recording: Mo Avg 67256.75 21638.375 RFP still remaining for additional awards in 2023. Est thru Dec 2023 336283.75 86553.5 Total 874337.75 240290.5 0.330922175097667 -0.123 2023 Affordable Housing 148 & Homeless Housing 149 9/13/2023 BEGINNING FUND BALANCE REVENUES County Sales Tax (1406) - Support Housing-Sales Use Tax City Sales Tax (1406) - City Contribution Sales Use Tax Sales Tax (1590) Investment Interest Shelter Program Grant Recording Fees Misc Revenue TOTAL REVENUES EXPENSES Community Build - Caswell Brown Dove House Dove House - Emergency Shelter Dove House - Housing Support Habitat for Humanity Habitat for Humanity - Landes Family Homes Fairgrounds Housing Bayside PTAC Heaters Bayside Shelter Grant Bayside Housing - Tiny OlyCAP 7th Haven Project OlyCAP Caswell Brown OlyCap Adult Shelter OlyCap Haines Street Cottages Pfeiffer House/Owl 360 Treasurer Financial Service Fees RFP Budget - 1590 TOTAL EXPENSES Change in Fund Balance ENDING FUND BALANCE - Current Estimated 2024 Revenues Total Available Possible RFP Amount 148 Budget 62000 585000 350 40000 0 687350 20000 50000 12000 60000 100000 55000 30000 25000 335000 687000 350 647000 870367 805667 Actual 223017 29904 14695 538054 13761 19370 0 615784 20000 3107 42323 63864 9421 16085 154800 460984 0 740760 Remaining 32096 -14695 46946 -13411 0 20630 0 71566 0 0 46893 12000 0 17677 0 0 0 36136 0 0 45579 0 30000 8915 0 335000 532200 0 460634 2024 50000 15000 617760 18000 40000 740760 149 Budget 1500 10000 234000 0 245500 85000 45000 10000 144500 45000 180000 10000 9000 528500 -283000 274000 267832 240432 Actual 276832 8479 34609 153737 11.95 196836.95 40142 44819 41 49180 104606 26418 265206 -68369.05 208462.95 210000 Remaining 0 0 0 0 -6979 -24609 80263 -11.95 48663.05 44858 0 181 0 0 0 0 9959 95320 0 45000 75394 -16418 9000 0 0 263294 214630.95 2024 10000 0 200000 210000 June Award-148 40000 2022 Affordable Housing 148 & Homeless Housing 149 January - July 2022 (Updated 8-17-2022) BEGINNING FUND BALANCE REVENUES County Sales Tax (1406) - Support Housing-Sales Use Tax City Sales Tax (1406) - City Contribution Sales Use Tax Sales Tax (1590) - Orig Budget $600,000 Investment Interest Shelter Program Grant Recording Fees TOTAL REVENUES EXPENSES Dove House Habitat for Humanity Habitat for Humanity - Landes Family Homes Fairgrounds Housing Bayside PTAC Heaters Bayside Shelter Grant Bayside Housing - Tiny OlyCAP 7th Haven Project OlyCap Adult Shelter OlyCap Haines Street Cottages Pfeiffer House/Owl 360 Treasurer Financial Service Fees TOTAL EXPENSES Change in Fund Balance ENDING FUND BALANCE Current Year Model BEGINNING FUND BALANCE Budgeted Revenues Budgeted Expenditures Projected Ending Fund Balance Projected Current Year Model and Recommendation 2022 Beginning Fund Balance Projected Revenues Projected Expenditures 2022 Projected Ending Fund Balance Recommended Reserve (approx 25%) 2022 Fund Balance for RFP 1590 Revenue Other Affordable Housing Revenue Ending Homelessness 2023 Projected Revenues for RFP 2023 Recommended RFP SHB 1590 Revenue and Expenditure Budget 2021 2022 through 12/31/2022 2023 Anticipated Total 2022 Budget 148 521071.85 62000 600000 350 42753 705103 50000 27000 6000 35000 600000 90000 70500 878500 -173397 347674.85 148 521071.85 705103 878500 347674.85 148 521071.85 900000 1318500 102571.85 102575 0 940000 102000 1042000 1042000 Revenue 438556 720000 720000 1878556 149 301674.33 250 45000 500000 545250 87588 45000 28000 128100 40000 133505 462193 83057 384731.33 149 301674.33 545250 462193 384731.33 149 301674.33 545250 462193 384731.33 100000 284500 234000 234000 518500 Expense 0 600000 940000 1540000 TOTAL 822746.18 62000 600 45000 542753 1250353 87588 50000 27000 6000 35000 45000 28000 600000 218100 40000 204005 1340693 -90340 732406.18 Total 822746.18 1250353 1340693 732406.18 Total 822746.18 1445250 1340693 927303.18 202575 284500 940000 102000 234000 1276000 1560500 BALANCE 438556 558556 338556 2022 Actual 148 521071.85 25352 13705 426881 1006 29114 496058 6582 27000 6000 21400 600000 23710 50 684742 -188684 332387.85 Total $620,500 Other Housing Revenue 149 301676 1102 35076 184196 220374 37113 43395 16780 68465 32994 13296 55 1 220373 522049 8/18/2022 TOTAL 822747.85 25352 13705 426881 2108 35076 213310 716432 37113 6582 27000 6000 21400 43395 16780 600000 68465 32994 37006 105 896840 -180408 642339.85 FUND 148 & FUND 149 - 2021 Updated 1-27-2022 BEGINNING FUND BALANCE REVENUES County Sales Tax (1406) City Sales Tax (1406) Sales Tax (1590) Investment Interest Shelter Program Grant Recording Fees TOTAL REVENUES EXPENSES Bayside - rental subsidies Bayside - tiny homes Dove House Habitat for Humanity 2020** Habitat for Humanity 20 homes Jefferson Interfaith Action Coalition 2020 Bayside (Shelter grant) OlyCap - Fairgrounds OlyCAP Adult Shelter 2020 OlyCAP Housing Assistance OlyCAP Haines Street Cottages OlyCAP/Parcher Pfeiffer House renovation OlyCAP/Parcher Pfeiffer House repairs OlyCAP SHB 1590 (7th and Hendricks project) Affordable Housing SHB 2060 (7th and Hendricks project) Transfer to Construction and Renovation Fund Treasurer Fees Facilitator Contract Administrative Costs TOTAL EXPENSES Change in Fund Balance ENDING FUND BALANCE 148 226277 120048 400000 2830 42752 565630 75000 27000 40000 27000 6000 20000 400000 75000 27500 2137.6 699637.6 -134007.6 92269.4 2021 Budget 149 377426.87 1400 145000 270239 416639 16000 73691 145000 200000 20000 182660 15000 16214.34 668565.34 -251926.34 125500.53 TOTAL 603703.87 0 120048 4230 145000 312991 982269 91000 73691 40000 0 145000 200000 0 40000 182660 15000 0 18351.94 805702.94 176566.06 780269.93 148 226277 67703 13705 438556 240.85 65290 585494.85 0.0351 75000 27000 44533 0 20000 21660 75000 27500 7 0 290700 -0.5845 294794.85 521071.85 2021 Actual 149 377427 319 93940 414422 508681 14719 73691 80611 200000 20000 169355 15000 7.67 11050 0 584433.67 -75752.67 301674.33 TOTAL 603704 67703 559.85 93940 479712 1094175.85 89719 27000 73691 44533 0 0 80611 0 200000 0 40000 169355 15000 75000 11050 0 825959 268216.85 871920.85 FUND 148 & FUND 149 - 2020 Updated 1-25-2021 BEGINNING FUND BALANCE REVENUES Sales Tax (1406) Investment Interest Transfer 148-149 Shelter Program Grant Recording Fees TOTAL REVENUES EXPENSES Interim Homeless Shelter Services Jan 1- April 30 2020 Bayside 2020 Dove House 2020 Habitat for Humanity 2020 Jefferson Interfaith Action Coalition 2020 Bayside (Shelter grant) OlyCAP Adult Shelter 2020 OlyCAP Housing Assistance OlyCAP Haines Street Cottages 2020 1st Task Force Facilitator Contract Olycap housing support request Transfer 148-149 Est'd Administrative Costs & New Facilitation Contract as of 2020 TOTAL EXPENSES Change in Fund Balance ENDING FUND BALANCE 2020 RFP ALLOCATIONS Actual Expenditures Difference - RFP Allocation Unspent 148 410852 3080 47283 50363 1900 272281 0 274181 -223818 2019 FINAL 149 0 5702 272281 299044 577027 251843 21013 272856 304171 TOTAL 410852 346327 627390 251843 22913 0 547037 80353 148 187034 52155 1402 59754 113311 13770 60298 0 0 0 0 0 74068 39243 226277 108780 74068 34712 2020 Actual 149 304171 0 2320 0 379365 381685 118682 18210 20397 94555.58 15000 31666.55 9918 16284.95 308429.13 73255.87 377426.87 159477 159432.13 44.87 TOTAL 491205 52155 3722 0 439119 494996 118682 31980 60298 0 0 20397 94555.58 15000 31666.55 9918 0 16284.95 398782.08 96213.92 603703.87 268257 233500.13 34756.87 148 1% increase 60351.54 60351.54 12621.002 12621.002 2021 Est'd 149 1% increase 383158.65 383158.65 0 19617.998 19617.998 TOTAL 443510.19 443510.19 0 0 32239 32239