Loading...
07. 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 $ 231,933 37 2887 Rural Development Revolving Loan $ 98,000 38 2888 Rural Development Revolving Loan $ 60,250 39 2930 Preserve America Grant $ 8,625 40 2945 CDBG - ED $ 101,770 41 2955 EPA Brownfields Revolving Loan $ 987,523 $ 1,940,471 COMMUNITY DEVELOPMENT -REVOLVING FUND FUND: 2880480-470210 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 Cash, Operating 10162 Cash, Reserve for investment (S&C) REVENUES PPD ADJ - CDBG 2881 373020 Loan Proceeds/Principal 373010 Loan Proceeds/ -Interest 371010 Interest Earnings (me 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 estimated proposed ACTUAL BUDGET ACTUAL BUDGET FY12/13 FY13/14 FY13/14 FY14/15 $372,151 $394,269 $394,269 $365,187 $35,329 $27,649 $27,649 $11,531 $407,480 $421,918 $421,918 $376,718 ($78,418) $40,702 $38,258 $53,000 $35,220 $27,093 $6,798 $11,800 $8,143 $4,753 $2,650 $2,300 $1,500 $72,548 $47,706 ($11,318) $44,863 $480,028 $469,624 $410,600 $421,581 $0 $2,370 $2,370 $1,370 $58,110 $439,605 $31,512 $350,000 $58,110 $441,975 $33,882 $351,370 $394,269 $0 $333,603 $58,680 $27,649 $27,649 $43,115 $11,531 $421,918 $27,649 $376,718 $70,211 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. 33 COMMUNITY DEVELOPMENT -REVOLVING FUND #2 FUND: 2881480-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 353 Auditing 711 Redevelopment Total Expenditures ENDING CASH 10100 Cash, Operating Total Cash estimated proposed ACTUAL BUDGET ACTUAL BUDGET FY12/13 FY13/14 FY13/14 FY14/15 $0 $0 $0 $105,468 $0 $0 $0 $105,468 $78,418 $0 $13,500 $13,500 $14,710 $0 $13,000 $13,000 $12,790 $0 $350 $550 $250 $0 $26,850 $105,468 $27,750 $0 $26,850 $105,468 $133,218 $0 $0 $0 $1,000 $0 $26,850 $0 $100,000 $0 $26,850 $0 $101,000 $0 $0 $105,468 $32,218 $0 $0 $105,468 $32,218 34 Community Development - Miscellaneous FUND: 2886-480-470210 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 CASH: operating REVENUES 331018 CDBG Growth Policy Update (amended) 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 Grant Total Revenue Total Available Personal Services M&O Redevelopment/Grants Total Expenditures ENDING CASH 10100 CASH estimated proposed ACTUAL BUDGET ACTUAL BUDGET FY12/13 FY13/14 FY13/14 FY14/15 $297,441 $248,208 $248,208 $260,093 $0 $0 $0 $0 $14,062 $0 $0 $0 $666 $0 $0 $0 $1,893 $1,200 $1,200 $800 $6,405 $7,352 $7,352 $7,601 $3,415 $2,468 $2,468 $2,219 $0 $0 $865 $0 $26,441 $11,020 $11,885 $10,620 $323,882 $259,228 $260,093 $270,713 $56,000 $0 $0 $0 $19,674 $25,865 $0 $31,933 $0 $0 $0 $200,000 $75,674 $25,865 $0 $231,933 $248,208 $233,363 $260,093 $38,780 35 Community Development - Miscellaneous FUND: 2886-480-470210 Personal Services: 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 Prospect Development 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 Grants: 790 Redevelopment Activity Total Grants & Housing GRAND TOTALS EXPENDITURE DETAIL proposed ACTUAL ACTUAL BUDGET BUDGET FY11/12 FY12/13 FY13/14 FY14/15 FTE's 1.00 1.00 0.00 0.00 $51,101 $46,250 $0 $0 $6,386 $6,706 $0 $0 $3,346 $3,044 $0 $0 $60,833 $56,000 $0 $0 $1,314 $444 $0 $900 $35 $470 $0 $0 $1,656 $586 $0 $0 $0 $500 $0 $0 $473 $492 $0 $0 $1,200 $1,500 $0 $0 $859 $216 $0 $0 $0 $0 $0 $0 $2,712 $2,367 $0 $0 $475 $304 $0 $0 $17,156 $1,084 $865 $0 $3,220 $0 $25,000 $25,000 $2,896 $2,354 $0 $0 $5,651 $3,961 $0 $2,000 $6,680 $3,046 $0 $2,858 $4,703 $2,350 $0 $1,175 $49,028 $19,674 $25,865 $31,933 $0 $50,000 $0 $200,000 $0 $50,000 $0 $200,000 $109,861 $125,674 $25,865 $231,933 36 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 345010 Application/Origination Fees 373010 Loan Interest 371010 Other Interest 373030 Principal Total Revenue Amount Available EXPENDITURES Personal Services Redevelopment Activity Principal Interest Total Expenditure ENDING CASH 10100 CASH: operating 10140 CASH: loan loss reserve (6% o/s loans principal) estimated proposed ACTUAL BUDGET ACTUAL BUDGET FY12/13 FY13/14 FY13/14 FY14/15 $61,667 $41,285 $41,285 $73,203 $14,670 $24,243 $24,243 $22,800 $76,337 $65,528 $65,528 $96,003 $594 $500 $0 $500 $20,990 $20,968 $20,968 $19,361 $661 $500 $750 $400 $23,941 $30,824 $30,824 $32,756 $46,186 $52,792 $52,542 $53,017 $122,523 $118,320 $118,070 $149,020 $143 $0 $0 $0 $34,778 $71,418 $0 $75,000 $17,559 $18,000 $17,377 $18,000 $4,515 $4,600 $4,690 $5,000 $56,995 $94,018 $22,067 $98,000 $41,285 $0 $73,203 $25,720 $24,243 $24,302 $22,800 $25,300 $65,528 $24,302 $96,003 $51,020 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, TIE, 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. 37 RURAL DEVELOPMENT LOAN REVOLVING #61-03 FUND: 2888-480-470210 PROJECTED REVENUE AND FUND SUMMARY estimated proposed ACTUAL BUDGET ACTUAL BUDGET FY12/13 FY13/14 FY13/14 FY14/15 BEGINNING CASH 10100 CASH: operating $132,228 $160,412 $160,412 $86,970 10140 CASH: loan loss reserve $8,667 $6,994 $6,994 $16,259 Total Cash $140,895 $167,406 $167,406 $103,229 REVENUES 345010 Application/Origination Fees $650 $500 $100 $0 373010 Loan Interest $7,914 $7,757 $11,000 $10,919 371010 Other Interest $880 $300 $1,200 $250 373030 Principal $27,891 $34,277 $30,290 $21,838 Total Revenue $37,335 $42,834 $42,590 $33,007 Amount Available $178,230 $210,240 $209,996 $136,236 EXPENDITURES 354 Contract Services $677 610 Principal & Interest Repayment to IRP $10,025 $10,250 $10,032 $10,250 750 Redevelopment Activity $122 $142,896 $100,000 $50,000 Total Expenditures $10,824 $153,146 $110,032 $60,250 ENDING CASH 10100 CASH: operating $160,412 $50,100 $86,970 $58,486 10140 CASH: loan loss reserve (6% of o/s prin of loans) $6,994 $6,994 $16,259 $17,500 $167,406 $57,094 $103,229 $75,986 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. 38 Preserve America Grant FUND: 2930480470240 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 estimated proposed ACTUAL BUDGET ACTUAL BUDGET FY12/13 FY13/14 FY13/14 FY14/15 $0 $0 $0 $0 $9,696 $9,696 $19,819 $19,819 $11,194 $11,194 $8,625 $8,625 $9,696 $19,819 $11,194 $8,625 $9,696 $19,819 $11,194 $8,625 $0 $0 $0 $0 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 signage in the downtown Kalispell. 39 2945 CDBG - ED FUND: 2945-480-470242 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH CASH: operating REVENUES 331011 CDBG ED GRANf Total Available 820 Administration -transfer to General Fund 790 Machinery/Equipment Expenditures ENDING CASH CASH: operating estimated proposed ACTUAL BUDGET ACTUAL BUDGET FY12/13 FY13/14 FY13/14 FY14/15 $0 $0 $0 $0 $66,119 $359,500 $257,730 $101,770 $66,119 $359,500 $257,730 $101,770 $5,392 $60,727 $10,000 $349,500 $917 $256,813 $9,083 $92,687 $66,119 $359,500 $257,730 $101,770 $0 $0 $0 $0 Pass through grant for the college to purchase equipment used in training programs. 40 EPA BROWNFIELDS REVOLVING LOAN FUND FUND: 295 5-480-470210 PROJECTED REVENUE AND FUND SUMMARY BEGINNING CASH 10100 Cash REVENUE 331090 EPA Funding Total Revenue Total Available EXPENDITURES 470210 PETROLEUM 229 Supplies 352 Personnel 353 Fringes 354 Contracted Services 373 Travel 720 Loans 470215 HAZARDOUS SUBSTANCES 229 Supplies 352 Personnel 353 Fringes 354 Contracted Services 373 Travel 720 Loans estimated proposed ACTUAL BUDGET ACTUAL BUDGET FY12/13 FY13/14 FY13/14 FY14/15 $0 ($0) ($0) $0 $3,167 $996,151 $8,628 $987,523 $3,167 $996,151 $8,628 $987,523 $3,167 $996,151 $8,628 $987,523 $42 $908 $456 $16,486 $211 $4,839 $0 $234,790 $1,066 $834 $0 $40,000 $0 $0 $42 $2,458 $465 $47,315 $210 $14,097 $0 $572,600 $676 $1,824 $0 $60,000 $0 $908 $783 $15,703 $345 $4,494 $4,901 $229,889 $999 ($165) $0 $40,000 $0 $0 $0 $2,458 $712 $46,603 $315 $13,782 $0 $572,600 $573 $1,251 $0 $60,000 $3,167 $996,151 $8,628 $987,523 ENDING CASH Cash ($0) ($0) ($0) $0 PROGRAM DESCRIPTION The City has been awarded $1,000,000 for a Brownfields Revolving Loan Program accepted 6/20/11. 41