The URL can be used to link to this page

07. Special Revenue Funds - Community DevelopmentSPECIAL REVENUE FUNDS Page Fund Dept COMMUNITY DEVELOPMENT 35 2880 CD Revolving Loan $ 1021)7 1 0 36 2881 CD Revolving Loan #2 $ 1511)000 37-38 2886 CD Miscellaneous $ 420,795 39 2887 Rural Development Revolving Loan $ 172,075 40 2888 Rural Development Revolving Loan $ 120,250 41 2955 EPA Brownf elds Revolving Loan $ 8105713 $ 1,777,543 COMMUNITY DEVELOPMENT -REVOLVING FUND FUND: 2880-480-470210 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 Cash, Operating 10162 Cash, Reserve for investment (S&C) REVENUES PPD ADJ - 2881 FYI4/2887-2888 FYI 345010 Application/Origination Fee 373020 Loan Proceeds/Principal 373010 Loan Proceeds/ -Interest 371010 Interest Earnings (inc S&C interest) Total Revenue Total Available EXPENDITURES 353 Auditing 354 Contract: Services 711 Redevelopment Total Expenditures ENDING CASH 10100 Cash, Operating 10162 Cash, Reserve for investment Total Cash ACTUAL BUDGET ACTUAL BUDGET FY13/14 FY14/15 FY14/15 FY15/16 $347,434 $286,075 $286,075 $138,485 $271)649 $36,922 $36,922 $371242 $375,083 $322,997 $322,997 $175,727 ($85,380) $0 ($151,706) $0 $0 $0 $200 $0 $527633 $35,220 $231>790 $2011126 $11,555 $8,143 $55519 $5,224 $2,937 $1,500 $3,398 $1,500 ($18,255) $44,863 ($118,799) $26,850 $356,828 $367,860 $204,198 $202,577 $24)370 $1,370 $1,370 $1,370 $0 $0 $0 $1,340 $317461 $350,000 $27,101 $10000 $335831 $351,370 $28471 $102,710 $286,075 ($20,432) $1381>485 $625625 $3611922 $36,922 $37,242 $371-242 $322,997 $16,490 $175,727 $99,867 PROGRAM DESCRIPTION This is a fund established in 2005 that consolidates "all" of the various loan types the Department has in existence or will be starting. Each type of loan activity has its own line item number and can be easily identified for the audit or monitoring. $175,727 $99,867 35 COMMUNITY DEVELOPMENT -REVOLVING FUND #2 FUND: 2881-480-470210 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 Cash, Operating REVENUES PPD ADJ - CD LOAN REV 2880 373020 Loan Proceeds/Principal 373010 Loan Proceeds/ -Interest 371010 Interest Earnings Total Revenue Total Available EXPENDITURES 353 Auditing 711 Redevelopment Total Expenditures ENDING CASH 10100 Cash, Operating Total Cash ACTUAL BUDGET ACTUAL BUDGET FY13/14 FY14/15 FY14/15 FYI 5/16 $0 $111417 $111,417 $138,794 $0 $111,417 $1111417 $138,794 $851)380 $13,020 $12,480 $537 $0 $14,710 $12,790 $250 $0 $14,956 $12,544 $877 $0 $15,527 $11,973 $500 $111,417 $27,750 $28,377 $281)000 $111 !417 $13915167 $139,794 $166,794 $0 $0 $1,000 $100,000 $1,000 $0 $1,000 $150,000 $0 $101,000 $ I,000 $151,000 $1111417 $38,167 $138,794 $15,794 $111,417 $3 8,167 $138,794 $15,794 36 Community Development - Miscellaneous FUND: 2886-480-470210 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 CASH: operating REVENUES 331018 CDBG Program -Senior Center CFDA# 14.228 371010 Interest/Misc. 373070 Principal payments (Big Sky Manor) 373010 Interest from Loans (Big Sky Manor) 331170 Historic Preservation Grant Reimburse from Old School TIFs Loan from General Fund (Old School Station) Total Revenue Total Available EXPENDITURES M&G Redevelopment/Grants Total Expenditures 10100 CASH amended ACTUAL BUDGET ACTUAL BUDGET FY 13114 FY 14I15 I FY 1. 4115 FY 15/16 $248,208 $2601-828 $2605828 $6261,236 $0 $30,000 $29,613 $30,000 $1,935 $800 $2,071 $1,300 $7,383 $7,601 $75761 $8,024 $2,437 $2,219 $200 $1,798 $865 $0 $0 $0 $0 $0 $327,649 $70,000 $0 $1,30000 $0001:000 $0 $12,620 $1,340,620 $11669,154 $111,122 $2607828 $1,601,448 $13929,982 $737,358 $0 $611933 $45,281 $70,795 $0 $1,500,000 $14)2585465 $350,000 $0 $1,561,933 $003,746 $4201795 $2605828 $39,515 $626,236 $316,563 37 Community Development - Miscellaneous FUND: 2886-480-470210 Materials and Services: 210 Office Supplies 211 Grant Administration Expenses/project exp 353 Auditing 355 CDBG Senior Center 373 Dues & Training 379 Meetings 396 Studies/Surveys & marketing 522 Administrative Transfers 528 Information Tech. Transfers 532 Office Rent new bidg Total Materials & Services Redevelopment: 790 Redevelopment Activity 795 Old School Lot Purchase FY 151Assessment Payments FYI 6 Total Grants & Housing GRAND TOTALS amended ACTUAL BUDGET ACTUAL BUDGET FY13114 J FY14/15 I FY14/15 FY15116 $0 $900 $0 $0 $0 $0 $0 $2,000 $0 $0 $0 $1,500 $0 $30,000 $29,613 $30,000 $0 $0 $0 $200 $0 $0 $0 $11)000 $0 $251000 $9,635 $25,000 $0 $2,000 $2,000 $4,000 $0 $2,858 $2,858 $4,120 $0 $1,175 $1,175 $1,175 $0 $61,933 $451>281 $70,795 $0 $200,000 $0 $ 50,000 $1,300,000 $1,258,465 $2001000 $0 $11500,000 $11258,465 $350,000 $0 $1,561,933 $1,303,746 $420,795 40 RURAL DEVELOPMENT LOAN REVOLVING #61-01 FUND: 2887-480-470210 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 CASH: operating 10140 CASH. loan loss reserve Total Cash REVENUES PPA w fm 2880 matching loans 345010 Application/Origination Fees 373010 Loan Interest 371010 Other Interest 373030 Principal Total Revenue Amount Available EXPENDITURES Redevelopment Activity Principal Interest Total Expenditure ENDING CASH 10100 CASH: operating 10140 CASH: loan loss reserve (6% ols loans principal) ACTUAL BUDGET ACTUAL BUDGET FY13/14 FY14/15 FY14/15 FY15/16 $41,285 $73,907 $73,907 $193,657 $24,243 $22,009 $22,009 $22,981 $65,528 $95,916 $95,916 $216,638 $0 $0 $79,161 $0 $7 $500 $0 $500 $19,701 $19,361 $22,192 $20,366 $993 $400 $451 $400 $31,761 $321)756 $41,002 $41,662 $52,462 $53,017 $142,806 $62,928 $1171)990 $148,933 $2381;1722 $2791)566 $0 $75,000 $10 $150,000 $17,384 $18,000 $17,911) $18,092 $4,690 $5,000 $4,162 $3,983 $221)074 $987000 $22,084 $1721Y075 $731907 $25,633 $193,657 $82,191 $221;1009 $25,300 $22,981 $25,300 $95,916 $501)933 $216,638 $107,491 PROGRAM DESCRIPTION The purpose of the Revolving Loan Fund (RLF) is to provide gap financing or business retention, expansion or start-up with the focus on job creation. Funding Sources for the RLF come from possible CDBG Economic Development Grants, TIF, Rural Development Intermediary relending Program (IRP) funds and the Community Development Revolving Loan Fund. The department was successful in writing a Rural Development (RD) grant application for $520,000 from the RD Intermediary Relending Program (IRP) on 10/12/04. $216,638 $107,491 39 RURAL DEVELOPMENT LOAN REVOLVING #61-03 FUND: 2888-480-470210 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 CASH: operating 10140 CASH: loan loss reserve Total Cash REVENUES PPA - fm 2880 matching loans 345010 Application/Origination Fees 373010 Loan Interest 371010 Other Interest 373030 Principal Total Revenue Amount Available EXPENDITURES 354 Contract Services 610 Principal & Interest Repayment to IRP 750 Redevelopment Activity Total Expenditures ENDING CASH 10100 CASH: operating 10140 CASH: loan loss reserve (6% of ols grin of loans) ACTUAL BUDGET ACTUAL BUDGET FY13/14 FY14/15 FY14/15 FY15/16 $1601)412 $94,214 $94,214 $179,998 $6,994 $10,845 $10,845 $10,137 $167,406 $105,059 $105,059 $190,135 $0 $0 $72,546 $0 $36 $0 $0 $0 $10,921 $10,919 $10,418 $10,041 $1,124 $250 $329 $250 $35,604 $21,838 $11,808 KIM $47,685 $33,007 $95,101 $20,004 $215,091 $13 8,066 $200,160 $2101)139 $10,025 $10,250 $10,025 $10,250 $100,007 $501)000 $0 $110,000 $110,032 $60,250 $10,025 $120,250 $94,214 $60,316 $179,998 $79,889 $10,845 $17,500 $10,137 $10,000 $105,059 $77,816 $190,135 $89,889 PROGRAM DESCRIPTION The purpose of the Revolving Loan Fund (RLF) is to provide gap financing or business retention, expansion or start-up with the focus on job creation. Funding sources for the RLF come from possible CDBG Economic Development Grants, TIF, Rural Development Intermediary relending Program (IRP) funds and the Community Development Revolving Loan Fund. The department was successful in writing a Rural Development (RD) grant application on 11/27/06 from the RD Intermediary Relending Program (IRP) of which $257,500 was used. 40 EPA BROWNFIELDS REVOLVING LOAN FUND FUND: 2955-480-470210 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 Cash REVENUE 331090 EPA Funding Loan Principal and Interest Total Revenue Total Available EXPENDITURES 470210 PETROLEUM 229 Supplies 352 Personnel 353 Fringes 354 Contracted Services 373 Travel 720 Loans 721 Subgrants 725 Revolved Funds 470215 HAZARDOUS SUBSTANCES 229 Supplies 352 Personnel 353 Fringes 354 Contracted Services 373 Travel 720 Loans 721 Subgrants (FC Jail Project) ENDING CASH Cash ACTUAL BUDGET ACTUAL BUDGET FY13/14 FY14/15 FY14/15 FY15/16 $0 $0 $o $100,500 $127,561 $868,590 $1581)376 $100,500 $7101)213 $1271>561 $8681P590 $2587876 $710,213 $127,561 $868,590 $258,876 $8101713 $0 $908 $0 $908 $783 $15,703 $0 $3,505 $345 $4,494 $0 $493 $20,779 $53,011 $31)612 $1,605 $999 $835 $0 $35 $100,000 $100,000 $3,436 $62,354 $0 $0 $0 $100,000 $0 $0 $o $100,500 $0 $2,458 $0 $2,458 $713 $46,602 $0 $o $315 $13,782 $0 $0 $3,054 $569,546 $60,335 $91921 $573 $1,251 $290 $5,961 $0 $601000 $0 $314,600 $0 $0 $90,703 $208,373 $127,561 $8683590 $158,376 $810,713 $0 $o $100,500 $0 PROGRAM DESCRIPTION The City has been awarded $1,000,000 for a Brownfields Revolving Loan Program accepted 6/20/11. 41