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