Loading...
08. Special Revenue Funds - Community DevelopmentSPECIAL REVENUE FUNDS Page Fund Dept COMMUNITY DEVELOPMENT 33 2880 CD Revolving Loan $ 351,370 34 2881 CD Revolving Loan #2 $ 101,000 35-36 2886 CD Miscellaneous $ 261,933 37 2887 Rural Development Revolving Loan $ 98,000 38 2888 Rural Development Revolving Loan $ 60,250 39 2930 Preserve America Grant $ 7,251 40 2945 CDBG - ED $ 101,345 41 2955 EPA Brownfields Revolving Loan $ 868,590 $ 1,849,739 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 AD] - CDBG 2881 373020 loan Proceeds/Principal 373010 loan Proceeds/ -Interest 371010 interest Earnings (inc S&C interest) Total Revenue Total Available 353 Auditing 711 Redevelopment Total Expenditures ENDING CASH 10100 Cash, Operating 10162 Cash, Reserve for investment Total Cash ACTUAL BUDGET ACTUAL BUDGET FY12/13 FY13/14 FY13114 FY14115 $372,151 $347,434 $347,434 $311,466 $35,329 $27,649 $27,649 $11,531 $407,480 $375,083 $375,083 $322,997 ($85,380) $42,500 $38,258 $52,633 $35,220 $27,709 $6,798 $11,555 $8,143 $4,753 $2,650 $2,937 $1,500 $74,962 $47,706 ($18,255) $44,863 $482,442 $422,799 $356,828 $367,860 $0 $107,359 $2,370 $439.605 S>2,370 $31,461 $1,370 $350,000 $107,359 $441,975 $33,831 $351,370 $347,434 $27,649 ($46,835) $27,649 $279,892 $43,115 $4,959 $11531 $375,093 ($19,186) $322,997 $16,490 PROGRAM DESCRIPTION This is a fund established in 2005 that consolidates "all" of the various loan types the Department has in existence or wi11 he starting. Each type of loan activity has its own line item number and can be easily identified for the audit or monitoring. 33 COMMUNITY DEVELOPMENT -REVOLVING FUND #2 FtND: 2881-480-470210 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 Cash, Operating REVENUES PPD ADD - CD LOAN REV 2880 373020 Loan Proceeds/Principal 373010 Loan Proceeds/4riterest 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 FY12/13 FY13/14 FY13/14 FY14/15 $0 $0 $0 $111,417 $0 $0 $0 $111,417 $85,380 $0 $13,500 $13,020 $14,710 $0 $13,000 $12,480 $12,790 $0 $350 $537 $250 $0 $26,850 $111,417 $27,750 $0 $26,850 $111,417 $139,167 $0 $0 $0 $26,850 $0 $0 $1,000 $I00,000 $0 $26,850 $0 $101,000 $0 $0 $111,4I7 $38,167 $0 $0 $111,417 $38,167 I Community Development - Miscellaneous FUND: 2886480470210 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 CASH: operating REVENUES 331018 CDBG Program -Senior Center CFDA# 14.228 341021 Grant Administration 365000 Misc. /Donations 371010 Interest(Misc, 373070 Principal payments (Big Sky Manor) 373010 Interest from Loans (Big Sky Manor) 331170 Historic Preservation Chant Total Revenue Total Available Personal Services M&O Redevelopment/Grants Total Expenditures ENDING CASH 10100 CASH ACTUAL BUDGET ACTUAL BUDGET FY12113 FY13114 FY13114 FY14115 $297,441 $248,209 $248,208 $260,828 $0 $0 $0 $30,000 $14,062 $0 $0 $0 S666 $0 $0 $0 $1,893 $1,200 $1,935 $800 $6,405 $7,352 $7,383 $7,601 $3,415 $2,468 $2,437 $2,219 $0 $0 $865 $0 $26,441 $11,020 $12,620 $40,620 $323.882 $259.228 $260,828 $301,448 $56,000 $0 $0 $0 $19,674 $25,865 $0 $61,933 $0 $0 $0 $200,000 $75,674 $25,865 $0 $261,933 $248,208 $233,363 $260,828 $39,515 35 Community Development - Miscellaneous FUND: 28 86-480-4702 10 EXPENDITURE DETAIL Personal Services: 110 Sataries & 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 hldg Total Materials & Services Grants: 790 Redevelopment Activity Total Grants & Housing GRAND TOTALS ACTUAL BUDGET ACTUAL, BUDGET FY12113 FY13114 FY13114 FY14115 FTE's 1.00 0.00 0.00 0.00 $46,250 $0 $0 $0 $6,092 $0 $0 $0 $3,044 $0 $0 $0 $55,394 $0 $0 $0 SW $0 $o $900 $470 $0 $0 $0 $586 $0 $0 $o $500 $0 $0 $0 S492 $0 $0 $0 $1,500 $0 $0 $0 $216 $0 $0 $0 $0 $0 $0 $30,000 $2,367 $0 $0 so $304 $0 $0 $o $1,084 $865 $o $0 $0 $25,000 $0 $25,000 S.2,354 $0 $0 $0 $3,96I $o $0 $2,000 $3,046 $0 $0 $2,858 $2,350' $0 $0 $1,175 $19,674 $25,865 $0 $61,933 $0 $0 $o $200,000 $0 $0 $0 $200,000 $75,058 $25,865 $o $261,933 36 RURAL DEVELOPMENT LOAN REVOLVING #61-01 FUND: 28 8 7-480-470210 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH. 10100 CASH: operating 10140 CASH: loan loss reserve Total Cash REVENUES 345010 AppiicationlDrigination Fees 373010 Loan interest 371010 Other Interest 373030 Principal Total Revenue Amount Available Personal Services Redevelopment Activity Principal Interest Total Expenditure ENDING CASH 10100 CASH: operating 10140 CASH: loan loss reserve (6%ols loans principal) ACTUAL BUDGET ACTUAL BUDGET FY12/13 FY13/14 FY13/14 FY14I15 $61,667 $14,670 $41,285 $24,243 $41,285 $24,243 $73,116 $22,800 $76,337 $65,528 $65,528 $95,916 $594 $500 $7 S500 $20,990 $20,968 $19,701 $19,361 $661 $500 $993 $400 $23,941 $30,824 $31,761 $32,756 $46,186 $52,792 $52,462 $53,017 $122,523 $118,320 $117,990 $148,933 $143 $0 $0 $0 $34,778 $71,418 $o $75,000 $17,559 $18,000 $17,384 $18,000 $4,515 $4,600 $4,690 $5,000 $56,995 $94,018 $22,074 $98,000 $41,285 $0 $73,116 $25,633 $24,243 $24,302 $22,800 $25,300 $65,528 $24,302 $95,916 $50,933 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, Dural Development Intermediary relending Program (1RP) 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, 37 RURAL DEVELOPMENT LOAN REVOLVING #61-03 FUND: 28 8 8-480-470210 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 CASH: operating 10140 CASH: loan loss reserve Total Cash REVENUES 345010 Application/Origination Fees 373010 Loan Interest 371010 Other Interest 373030 Principal Total Revenue Amount Available 354 Contract Services 610 Principal 8c Interest Repayment to IR.P 750 Redevelopment Activity Total Expenditures ENDING CASH 10I00 CASH: operating 10140 CASH: loan loss reserve (6% of ols prin of loans) ACTUAL BUDGET ACTUAL BUDGET FY12113 VY13114 FY13114 FY14115 $132,229 $160,412 $160,412 $88,800 $8,667 $6,994 $6,994 $16,259 $140,895 $167,406 $167,406 S105,059 $650 $500 136 $0 $7,914 $7,757 $10,921 $10,919 $890 $300 $1,124 $250 $27.991 $34,277 935.604 $21,838 $37,335 542,834 $47,685 $33,007 $179,230 $210,240 $215,091 $138,066 $677 $10,025 $10,250 $10,025 $10,250 $122 $142,896 $100,007 $50,000 $10,824 $153,I46 $110,032 S60,250 5160,412 S50,10D $88,800 S60,316 $6,994 $6,994 $16,259 $17,500 $167,406 $57,094 $105,059 $77,816 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 W) funds and the Community Development Revolving Loan Fund. The department was successful in writing a Rural Development (RD) grant application on l 1/27/06 from the RD intermediary Relending Program (IRP) of which $257,500 was used. 38 Preserve America Grant FUND; 2930-480-470240 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 Cash REVENUE 331030 Preserve America Grant ($75,000) Total Revenue Total Available EXPENDITURES 354 Grant Contract Services ENDING CASH Cash ACTUAL BUDGET ACTUAL BUDGET FY12/13 FY13114 FY13114 FY14115 $0 $o $0 $0 $9,696 $19,819 $12,568 $7,251 $9,696 $19,819 $12,568 $7,251 $9,696 $19,819 $12,568 $7,251 $9,696 $19,819 $12,568 $7,251 $o $o $0 $o PROGRAM DESCRIPTION The preserve america grant is for the development of a website and social media marketing campaign for downtown Kalispell working with Hockaday Museum's youth program; 2) development of a marketing campagin with youth and local business input to promotre cultural resources in the historic downtown destination; and 3) provide way -finding, historic register building and interpretive sign age in the downtown Kalispell. 39 2945 CDBG - ED FUND: 2945480-470242 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH CASH: operating REVENUES 331011 CDBG ED GRANT Total Available 820 Administration -transfer to Gcncral Fund 790 Machinery/Equipment Expenditures ENDING CASH CASH: operating ACTUAL BUDGET ACTUAL BUDGET FY12113 FY13114 FY13114 FY14115 $0 $0 $0 $0 $66,119 $359,500 $258,155 $101,345 $66,119 $359,500 $259,155 $101,345 $5,392 $10,000 $1,342 $9,658 $60,727 $349,500 $256,813 $92,687 $66,119 $359,500 $258,155 $101,345 SO $0 $0 $(1 Pass through grant for the college to purchase equipment used in training programs. 40 EPA BROWNFIELDS REVOLVING LOAN FUND FUND: 2955-480470210 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 Cash RE VENUE 331090 EPA Funding Total Revenue Total Available 470210 PETROLEUM 229 Supplies 352 Personnel 353 Fringes 354 Contracted Services 373 Travel 720 Loans/Subgrants 470215 HAZARDOUS SU13ST'ANCES 229 Supplies 352 Personnel 353 Fringes 354 Contracted Services 373 Travel 720 Loans/Subgrants ENDING CASH Cash ACTUAL BUDGET ACTUAL BUDGET FY12113 FY13114 FY13114 FYi4115 $0 {$0} [$0} $0 $3,167 $996,I51 $127,561 $868,590 $3,167 $996,151 $127,561 $868,590 $3,167 $996,151 $127,561 $868,590 $42 $908 $0 $908 S456 $16,496 $783 $15,703 $211 $4,839 $345 $4,494 $0 $234,790 $20,779 $53,011 $1,066 $834 $999 $835 $0 $40,000 $100,000 $100,000 $42 $2,458 $0 $2,458 $465 $47,315 $713 $46,602 S210 $14,097 $315 $13,782 $0 $572,600 $3,054 $569,546 $676 $1,824 $573 $1,251 $0 $60,000 $0 $60,000 $3,167 $996,151 $127,561 $868.590 ($0} ($0) ($0) $0 PROGRAM DESCRIPTION The City has been awarded $1,000,000 for a Brownfields Revolving Loan Program accepted 6120/11. 41