Loading...
08. Special Revenue Funds, Community DevelopmentSPECIAL REVENUE FUNDS Page Fund Dept COMMUNITY DEVELOPMENT 34 2880 CD Revolving Loan $ 102,710 35 2881 CD Revolving Loan #2 $ 1515000 36-37 2886 CD Miscellaneous $ 4205795 38 2887 Rural Development Revolving Loan $ 172!X 5 39 2888 Rural Development Revolving Loan $ 120,250 40 2945 CDBG - ED $ 1011258 41 2955 EPA Browniields Revolving Loan $ 8061,309 $ 118749397 COMMUNITY DEVELOPMENT -REVOLVING FUND FUND: 2880-080-170210 PROTECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 Cash, Operating 10162 Cash, Reserve for investment (S&C) REVENUES PPD ADJ - 2881 F Y 14/2887-2888 FYI 5 373020 Loan Proceeds/Principal 373010 Loan Proceeds/ -Interest 371010 Interest Earnings (ine S &.0 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 estimated proposed ACTUAL BUDGET ACTUAL BUDGET FY 13/14 FY 14/15 FY 14/15 FY 15/16 $347$434 $2863075 $2865075 $1411104 $27,649 $36,922 $36,922 $36,767 $375,083 $322,997 $322,997 $177,871 ($85,3 80) $0 ($151,706) $0 $521)633 $35,220 $25,000 $202126 $11555 $8,143 $7,000 $5,224 $2,937 $1,500 $32000 $1,500 ($1 R,255j $44,863 ($116,706) $26,850 $3565828 $367,860 $206,291 $2042721 $2,370 $11;1370 $1,370 $1,370 $0 $0 $0 $1,340 $31 a461 $350,000 $27,050 $100,000 $331,831 $351,370 $287420 $1027710 $286,075 ($20,432) $141,104 $65,1 4 $361>922 $361,922 $36,767 $36,767 $322,997 $165490 $177,871 $102,011 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. 34 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 Eamings Total Revenue Total Available EXPENDITURES 353 Auditing 711 Redevelopment Total Expenditures 10100 Cash, Operating Total Cash estimated proposed ACTUAL BUDGET ACTUAL BUDGET FY 13/14 FY 14/15 I FY 14/15 FY 15/16 $0 $111,417 $111,417 $138,517 $0 $1111417 $1115417 $138,517 $85,380 $131020 $121480 $537 $143710 $12,790 $250 $143710 $12,790 $600 $151527 $1115973 $500 $111,417 $27,750 $2810100 $285000 $111,417 $1395167 $139,517 $1661)517 $0 $0 $100 $1007,000 $100 $0 $1,000 $15000 $0 $101,000 $1,000 $151,000 $1111417 $385167 $138,517 $15,517 $1115417 $382167 $138,517 $15,517 35 Community Development - Miscellaneous FUND: 2886-480-470210 PROTECTED REVENUE AND FUND SUMMARY BEGINNMG CASH 10100 CASH: operating RE VENUE S 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&O Redevelopment/Grants Total Expenditures ENDING CASH 10100 CASH amended estimated proposed ACTUAL BUDGET ACTUAL BUDGET FY 13114 FY 14115 FY 14115 FY 15I1 6 $248,208 $260,828 $260,828 $6111850 $0 $30,000 $0 $30,000 $1,935 $800 $1,500 $1,300 $710383 $7,601 $7,601 $8,024 $2,437 $22219 $2,219 $11)798 $865 $0 $0 $0 $0 $0 $327,649 $70,000 $0 $1,300,000 $11)300,000 $0 $12,620 $133407620 $1,63 8,969 $111,122 $260P828 $1,601,448 $1,89%797 $722,972 $0 $61,933 $17,947 $70,795 $0 $1,5001000 $1,270,000 $350,000 $0 $1,561,933 $15287,947 $420,795 $260,828 $39,515 $611,850 $302,177 36 Community Development - Miscellaneous FUND: 2886-480-470210 EXPENDITURE DETAIL Personal Services: FTEts 110 Salaries & Wages 153 Health Insurance 155 Retirement Total Personal Services Materials and Services: 210 Office Supplies 211 Grant Administration Expenses/project exp 312 Postage & Printing 334 Montana West Membership 345 Telephone, Communications 353 Auditing 354 Contract Services 355 CDBG Senior Center 373 Dues & Training 379 Meetings 395 CDBG Growth Policy Update 396 Studies/Surveys & marketing 510 Property & Liability Ins. 522 Administrative Transfers 528 Information Tech. Transfers 532 Office Rent new Bldg Total Materials & Services Redevelopment: 790 Redevelopment Activity 795 Old School Lot Purchase FY 15/Assessment Payments FY 16 Total Grants & Housing GRAND TOTALS amended proposed ACTUAL ACTUAL BUDGET BUDGET FY12113 FY 13/14 FY 14115 FY 15/16 1.00 0.00 0.00 0.00 $465250 $o $0 $0 $6,092 $0 $0 $0 $31044 $0 $0 $0 $55,384 $0 $0 $0 $444 $o $900 $0 $470 $0 $0 $2,000 $586 $0 $0 $0 $500 $0 $0 $0 $492 $0 $0 $0 $1,500 $0 $0 $15500 $216 $0 $0 $0 $0 $o $30,000 $301000 $2,367 $0 $0 $2,000 $304 $0 $0 $1,000 $104 $0 $0 $0 $o $0 $255-000 $2.51,000 $27354 $0 $0 $0 $3,961 $0 $2,000 $41)000 $35046 $0 $2,858 $4,120 $2,350 $0 $11,175 $1,175 $19,674 $0 $617933 $70,795 $0 $0 $200,000 $1501000 $1,300,000 $20000 $0 $0 $1,500,000 $350,000 $75,058 $0 $1,5611933 $420,795 37 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 - 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°gyp ols loans principal) estimated proposed ACTUAL BUDGET ACTUAL BUDGET FY13114 FY14115 FY14/15 FY15116 $41,285 $731907 $73,907 $1 90,091. $24,243 $22,009 $221X9 $251300 $65,528 $95,916 $95,916 $215,391 $o $o $79,160 $0 $7 $500 $0 $500 $19,701 $19,361 $22,000 $205-366 $993 $400 $400 $400 $31,761 $321756 $40,000 $41,662 S52,462 $53,017 $ l 41,560 $62.928 $1173k990 $1487933 $2371476 $278,319 $0 $75,000 $10 $150,000 $17,384 $18,000 $17,913 $18,092 $47690 $5,000 $4,162 $3,983 $22,074 $981,000 $22,085 $172,075 $73,907 $2511633 $1901)091 $801,944 $22,009 $25,300 $25,300 $25,300 $95,916 $50,933 $215,391 $106,244 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 10112/04. 38 RURAL DEVELOPMENT LOAN REVOLVING #61-03 FUND: 2888-480-470210 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 CASH: operating 10140 CASH: loan toss reserve Total Cash REVENUES PPA - fin 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) estimated proposed ACTUAL BUDGET ACTUAL BUDGET FY13114 FY14/15 FY14/15 FY15116 $160,412 $94,214 $94,214 S 179,300 $6,994 $10,845 $10,845 $10,280 $167,406 $105,059 $105,059 $18%5 80 $0 $0 $721-546 $0 $36 $0 $0 $0 $10,921 $105919 $10,000 $10,041 $1,124 $250 $300 $250 $35,604 $21,838 $11,700 $92713 $47>685 $33,007 $94,546 $20,004 $215,091 $13 8,066 $1995605 $2091.%5 84 $101.1025 $10,250 $10,025 $10,250 $1001)007 $50,000 $0 $110,000 $1101032 $60,250 $10,025 $120250 $94,214 $60,316 $179,300 $69,334 $10,845 $171500 $101280 $10,000 $105,059 $77,816 $189,580 $79,334 PROGRAM DESCRIPTION a aAv k'-' F vuv V }_ 'w 4 R44a i VML4 + {*AAtia `' -- .1 wu YV e t V • &-- tl-k' a--""4b ` V "-4-A `ko WJ i 4 V W - /LF4 hAA� A V W V u I y V 44 yy�44 VlA. Funding sources for the RLF come from possible CDBG Economic Development Grants, TIF, Rural Development Intermediary relending Program 39 2945 CDBG - ED FUND: 2945-480-470242 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH CASH: operating REVENUES 331011 CDBG ED GRANT (FVCC EQUIPMENT GRT) Total Available EXPENDITURES 820 Administration -transfer to General Fund 790 Machinery/Equipment Expenditures ENDING CASH CASH: operating ACTUAL FY13I14 BUDGET FY14/15 estimated ACTUAL FY14/15 proposed BUDGET FY15/16 $0 $0 $0 $0 $25 8,155 $101,345 $87 $1011>258 $258,155 $101,345 $87 $1011258 $1,342 $2565813 $8,558 $92,687 $87 $0 $8,571 $921,687 $2581155 $1011)345 $87 $101,258 $0 $0 $0 $0 Pass through grant for the college to purchase equipment used in training programs. EPA BROWNFIELDS REVOLVING LOAN FUND FUND: 2955480-470210 PROJECTED REVENUE AND FUND SUMMARY estimated proposed ACTUAL BUDGET ACTUAL BUDGET FY13/14 FY14/15 FY14/15 FY15/15 BEG INNING CASH 10100 Cash $0 $0 $0 $100,500 REVENUE 331090 EPA Funding $127,561 $8682590 $227,815 $806,309 Total Revenue $127,561 $868,590 $227,815 $806,309 Total Available $127,561 $868,590 $227,815 $90609 EXPENDITURES 470210 PETROLEUM 229 Supplies $0 $908 $0 $908 352 Personnel $783 $157703 $0 $3,505 353 Fringes $345 $4,494 $0 $493 354 Contracted Services $20,779 $53,011 $3,612 $1,605 373 Travel $999 $835 $0 $35 720 Loans $100,000 $100,000 $31)436 $62,354 721 S ubgrants $100,000 470215 HAZARDOUS SUBSTANCES 229 Supplies $0 $2,458 $0 $21;1458 352 Personnel $713 $46,602 $0 $41,602 353 Fringes $315 $13,782 $0 $131>781 354 Contracted Services $3,054 $5697546 $31808 $112066 373 Travel $573 $13251 $0 $61,251 720 Loans $0 $60,000 $661459 $414,600 721 Subgrants (FC Jail Project) $0 $0 $501000 $147,651 $127561 $868590 $127,315 $806,309 ENDING CASH Cash $0 $0 $100,500 $100,500 PROGRAM DESCRIPTION The City has been awarded $1,000,000 for a Brown -fields Revolving Loan Program accepted 6/20/11. 41