HomeMy WebLinkAboutAgenda Report - December 19, 2007 K-02AGENDA ITEM ftvo#l%
` CITY OF LODI
COUNCIL COMMUNICATION
TM
AGENDA TITLE: Presentation of June 30, 2007 Financial Conditionfor All City of Lodi Funds
MEETING DATE: December 19.2007 City Council Meeting
PREPARED BY: James R. Krueger, Deputy City Manager
RECOMMENDEDACTION: Receive presentation of June 30, 2007 financial condition for all City
of Lodi funds.
BACKGROUND INFORMATION: The annual audit of the City's fiscal year 2007108 financial records
has been completed by the audit firm of Macias Gini & O'Connell.
Typically, the auditors present their audit report and the
Comprehensive Annual Financial Report (CAFR) shortly afler the completion of their field work. However,
the audit report and the CAFR are not ready to be presented until the first City Council meeting in
January, 2008. Although the audit report and the CAFR are not yet available, the basic financial
information has been audited and is available for review at this time.
Attached are the primary financial statements, which will be included in the CAFR, to be presented in
January. The following highlightsare based on these primary financial statements:
• As of June 30, 2007 the City's financial condition continues to improve.
o Total unrestricted cash and investments stand at $31.1 million and have increased by $3.5
million since June 30, 2006
o Net Assets (term used in government accounting to measure financial condition) stands at
approximately $234 million. This is an increase of $27.3 million from June 30, 2006.
o Net investment in fixed assets (Buildings, majorfacilities and other infrastructure) stands
at approximately $205 million, an increase of about $16.8 million from June 30, 2006
The unreserved General Fund Balance is approximately $5.2 million* as of June 30, 2007. Revenues
were higher than budget estimates by approximately $1.7 million. All departments were undertheir
final budget amounts and had savings in comparison with budgets as follows:
o General Government (City Clerk, City Manager and Internal Services) saved $574,693
o Police and Fire saved $891,710
o Public Works saved $127,206
o Library saved $69,847
o Parks and Recreation saved $258,064
*Staff will recommend upon mid -year budget adjustment, a transfer of $1 million to the Vehicle
Replacement Fund.
APPROVED:
Blair K i m Manager
• The Enterprise Funds (funds that are accounted for and operated like a business) had unreserved
Fund Balances (Cash and other related amounts) as of June 30, 2007 as follows:
o Electric Utility approximately $5.5 million
o Wastewater Utility approximately $4.9 million
o Water Utility had a deficit of approximately $ (5) million
o Transit Fund approximately $.2 million
Special Revenue Funds (those funds which have revenues that are designated for special purposes)
had unreserved fund balances as of June 30,2007 as follows:
o Public Safety special revenue fund $188,675
o Community Development Block Grantfund $0
o Transportation fund $89,867
o Community Development Fund had a deficit of $(173,458)
o Streets fund approximately $6.5 million
Capital Projects Funds (funds established for major capital facilities or equipmentthat are related to
general government operations) had unreservedfund balances as of June 30, 2007 as follows:
o Vehicle and equipment approximately $1.3 million*
o Library $12,677
o Subdivision capital projects $300,339
o Hutchins Square $2,181
o General Capital Outlay Fund (primarily funds paid to the City of Lodi by developers for
mitigation of impacts and to be used to build major capital facilities) approximately $4.5
million.
o Lodi Lake $46,287
• Internal Service Funds ( funds which are used to accountfor self insurance and maintaining vehicles
owned by the city ) had unreserved cash deficits as of June 30, 2007 as follows:
o Fleet services $(104,701)
o Claims and Benefits (workers compensation and liability self insurance costs accounted
for in separate funds) deficit of $(,8) million
Otherfunds (those not accounted for in the categories already enumerated) had balances as of
June 30, 2007 as follows:
o Special assessments (amounts collected and held for use in lighting and landscape
districts throughout the city $674,686
o Library Special Purpose Trust $846,765
o Hutchins Square Bequest $1,386
A more thorough review of the results of operations will be made during the City Council meeting as part
of a power point presentation to be made at that time.
'See General Fund
FISCAL IMPACT: Not Applicable.
es R. Krueger, Depufy C y anager
June 30,, 2007 Financial Report
■ Overall Financial Condition continues to
show improvement.
■ Unrestricted cash and investments increased by $3.5
million to a balance of .1 million as of June 30,
2007
■ Net Assets increased by .3 million, Total
Revenues + $10.7 million, Total expenses +$2.5
million
• Capital assets +$16.8 million
* Restricted assets +$.8 million
❑ Unrestricted assets +$9.7 million
A-1
June 30,, 2007 Financial Report
. General Fund
• Unreserved Fund Balance $5,175,522, net
increase of $i.9 million
• Revenues of $40,456,199
■ Taxes exceeded budget estimates by about $1 million
. Intergovernmental revenues exceeded budget estimates
by about $.9 million
A-2
June 3042007 F4inanci'al Report
(General Fund continued)
■ Actual Expenditures $40,041,238, budget of
$41,962,758
■ General Government saved $574,693
■ Public Safety saved $891,710
■ Public Works saved $127,206
■ Library saved $69,847
. Parks and Recreation saved $258,064
■ Net transfers to the General Fund of $1,535,500,
same as budgeted
A-3
June 30, 2007 Financial Report
■ Electric Utility Unreserved Fund Balance
$5,514,496*
■ Revenues $65.8 million
■ Expenditures $63.6 million
■ Net Interest income &, (expense)
$ (1.9) million
■ Cost of services transfer $2.6 million
* Cash balance of $5,162,284 +Advances Receivable $3.7 million, -
July � 2007 debt repayment of $4.0 million + $.7 million from
unspent debt proceeds received on July 3 2007.
A-4
June 30, 2007 Financial Report
■ Wastewater Utility Unreserved Fund Balance
$ 4,956,069*
■ Revenues $8.5 million
■ Expenses $7.3 million
■ Net interest expense $.7 million
. Net transfer in $1.3 million and capital contributed of
$11.5 million
*Cash $3,000,445 plus July 3� 2007 reimbursement
from debt proceeds $1,955,624
A-5
June 30, 2007 Financial Report
a Water Utility Unreserved Fund Balance
$(475,262)*
■ Revenues $10.0 million
■ Expenses $9.8 million
■ Other income $6.8 million
■ Capital contributions $7.3 million
■ Transfer to Wastewater $2.3 million, Cost of services
* transfer of 1.0 million
Due to other funds of $475,262 is reflected as a
negative amount of fund balance
A-6
June 30,, 2007 Fnancial Report
■ Transit Unreserved Fund Balance
$213,212*
■ Revenues $400,826
■ Expensed $3,576,807
■ Operating Grants $2,621,063
■ Other revenue 113,971
■ Capital Contributions $1,142,763
* Cash balance of $213,212
A-7
June 30, 2007 Financial Report
■ Special Revenue Funds-Unreserved Fund
Balances
■ Public Safety Special Revenue $188,675
■ CDBG $0 balance
■ Transportation $89,867
o Community Development Fund $(173,458)
■ Net deficit for 06/07 of $245,716
. Streets Fund $6,546,231
o Net increase $1.3 million
A-8
June 30,, 2007 Financial Report
■ Capital Projects Unreserved Fund Balances
■ Vehicle and Equipment Replacement $1,291,194
■ Library project $12,677
■ Subdivision capital project fund $300,339
■ Hutchins Square $2,181
■ Capital Outlay reserve funds $4y547,189
. Primarily Impact Mitigation funds
■ Lodi Lake $46,287
A-9
June 30, 2007 Financial Report
■ Internal Service Funds-Unreserved Fund
Balances
■ Fleet services $(104,701)
. Claims and Benefits Funds $(813,142)
■ Primarily this fund reflects workers compensation
and general liability self insurance activities and
shows an improvement of $2.2 million from the
prior year
A-10
June 30, 2007 Financial Report
■ Other Funds -Balances
■ Special Assessments assets and obligations =
$674,686 at June 30, 2007
■ Library Special Purpose Trust Fund $846,765
■ Hutchins Square Bequest $1,386
A-11
City of Lodi's Net Assets
Governmental
Business -type
119,527,995
123,232,209
Activities
Activities.
4,793,639
Total
2002 2006
2007 2M6
2007
2QQ6
Assets:
46,582,385
127,410,987
132,060,366
Current and other assets $ 32,649,468 26,306,575
82,844,456 85,587,439 $
115,493,524
111,894,014
Capital assets 135,878,115 137,535,891
157,655,799 136,816,229
293,533,914
274,352,120
Total assets 168,527,183 163,842,466
240,500,255 222,403,668
409,027,438
386,246,134
Liabilities:
Long-term liabilities
outstanding
Other liabilities
Total liabilities
Net assets:
Invested in capital assets,
net of related debt
Restricted
Unrestricted
Total net assets
41,842,787
42.911,609
119,527,995
123,232,209
161,370,782
166,143,818
4,793,639
3,670,776
7,882,992
8,828,157
12,676,631
12,498,933
46,636,426
46,582,385
127,410,987
132,060,366
174,047,413
178642,751
110,775,646
111,572,441
95,078,319
77,493,888
205,853,965
189,066,329
15,044,403
14,525,637
11,292,585
10,969,285
26,336,988
25,494,922
(3,9291292)
(8,837,997)
6,718,364
1,880,129
2,789,072
(6,957,868)
$ 121,890,757 117,260,081 113,089,268 90,343,302 $ 234,980,025 207,603,383
B-1
ASSETS
Cash and investments
Restricted assets
Accounts receivable.net
Propertytax receivable
Interest receivable
Internal balances
Due from other governmental agencies
Loan receivable
Advance receivable
Inventory
Other assets
Deferred charges
Capital assets, net:
Nondepreciable
Depreciable, net
TOTALASSETS
LIABILITIES
Accounts payable and accrued liabilities
Accrued salaries and wages
Accrued interest
Unearned revenue
Long-term liabilities:
Duewithin one year
Due in more than one year
TOTAL LIABILITIES
NETASSETS
Invested in capital assets, net of related debt
Restricted for:
Capital projects
DebtseMce
Other purposes
Unrestricted (deficit)
TOTAL NET ASSETS
CITY OF LODI
STATEMENTOFNETASSETS
June 30 2007
Governmental
Bu siness-type
9.988.341
Activities
Activities
Total
5 22,744,481
8,375,941 5
31,120,422
1,750,204
29,871,849
31,622,053
3,606,321
13,842,494
17,448,815
1,901,316
13,011,928
1,901,316
201,303
65,597
266.900
(749,911)
749,911
(3,968,367)
1,911,215
970,061
2,881,276
1,084,000
234,980,025
1,084,000
4,790,663
4,790,663
137,931
1,701,197
1,839,128
62,924
5,627
68,551
22,471.116
22,471,116
26.823, 990
31,616,087
58, 440, 077
109,054,125
126,039,712
235,093,837
166,527,899
240,500,255
409,028,154
3,146,437
1,364,788
283,130
4,295,437
2,348,162
1,239,393
7,441,874
1,364,788
2,631,292
1,239,393
5,854,889
4,133;452
9.988.341
35,987,898
115, 394, 543
151, 382,441
46,637,142
127,410,987
174,048,129
110,814,721
97, 960,684
208,775,405
13.011.928
13,011,928
7,749,214
1,749,214
283.261
8,710,994
8,994,255
(3,968,367)
6,417,590
2,449,223
5 121,890,757
113,089,268 5
234,980,025
B-2
Revenues
Program revenues:
Charges for services
Operatinggrants and contributions
Capital grants and contributions
General revenues:
Propertytaxes
Othertaxes
Grants and contributions not restricted to
specific pmgrams
Litigation- environmental lawsuits proceeds
Other
Total revenues
Expanses
General government
Public protection
Public works
Community development
Library
Parks and recreation
Interest on long-term debt
Electric
Wastewater
Water
Transit
Total expenses
Changes in net assets before transfers
Transfers
Changes in net assets
Net assets at beginning of year
Net assets at end of year
City of Lodi's Changes in Net Assets
Governmental
Business -type
Activities
Activities
Total
2042
2006
ZQQ7
2006
2002
2M
$ 4,392,227
4,717,215
84,772,926
76,768,433 5
89,165,153
81,485,648
2,588392
2,586,677
2,621,063
3,376,995
5,209,655
5,963,672
6,934,023
14,630,848
19,983,760
11,145,804
26,917,783
25,776,652
9,523,684
8,030,641
9,523,684
8,030,641
11,070,609
10,065,090
11,070,609
10,063,D90
14,771,545
14,214,678
14,771,645
14,214,678
6,222,568
6,700,399
6,222,568
6,700,399
1,292,149
1,340,239
4,128,972
4,063,465
5,421,121
5,403,704
50,572,829
55,583,388
117,729,289
102,055,096
168,302,118
157,638,484
7,609,063
9,748,613
7,609,063
9,746,613
23,327,792
22,104,641
23,327.792
22,104,641
10,599,292
13,228,998
10,599,292
13,228,998
2,130,349
2,290,412
2,130,349
2,290,412
1,630,145
1,484,793
1,630,145
1,484,79$
4,171,750
4,113,772
4,171,750
4,113,772
1,201,086
1,233, 982
1,201,086
1,233,982
67,533,822
63,779,870
67,533,822
63,779,870
9,270,867
8,574,212
9,270,667
8,574,212
9,874,703
8,256,175
9,874,703
8,256,175
3,576,807
3,643,035
3,576,807
3,643,035
50,869,477
54,203.211
90,255,999
84,253,292
140,925,476
1M,456,503
(96,648)
1,380,177
27,473,290
17,801,804
27376,642
19,181,981
4,727,324
4,922,835
(4,727,324)
(4,922,835)
4,630,676
6,303,012
22,745,966
12,878,969
27,376,642
19,181,981
117,260,081
110,957,069
90,343,302
77,464,333
207,603,383
188,421,402
$ 121,890,757
117,260,081
113,089,268
90,343,302 $
234,980,025
207,603,383
B-3
ASSETS
Cash and investments
Restricted assets
Receivables:
Accounts, net
Property taxes
interest
Due from other funds
Due from other governmental agencies
Loan receivable
inventory
Advances to other funds
Otherassets
Total assets
LIABILITIESAND FUND BALANCES
Llabil'Eties:
Accounts payable and other liabilities
Accrued salaries and wages
Due to other funds
Advancesfrom otherfunds
Deferred revenue
Total liabilities
Fund balances:
Reserved
Unreserved reported in:
General Fund
Special revenue funds
Capital projects funds
Total fund balances
Total liabilities and fund balances
CITY CF LOD]
BALANCE SHEET
GOVERNMENTAL FUNDS
June 30,2007
General
Fund
Other
Governmental
Funds
Total
Governmental
Funds
$ 3,981,991
13,316,450 $
17,298,441
1,750,204
1,750,204
3,355,991
46,695
3,402,686
1,901,316
1,443,950
1,901,316
47,401
108,660
156,061
149.588
978.064
1,127,632
5,300
1,905,915
1,911,215
5,175,522
11084,000
1,084,000
29,407
6,651,315
29.407
272.800
646,770
919,570
59,695
508
60,203
$ 9,803,469
19,837,266 5
29,640,735
$ 2,119,279
871,580 $
2,990,859
1,384,788
1,364,788
652,370
652,370
2,144,743
2,144,743
1,443,950
1,443,950
31464,067
5,112,643
8,596,710
1,143,880
1,873,449
3,017,321
5,175,522
5,175,522
6,651,315
6,651,315
6.199,867
6,199,867
6,399,402 14,724,623 21,044,025
$ 9,803,469 19,837,266 $ 29,640,735
B-4
CITY OF LODI
STATEMENT OF REVENUES, EXPENDITURESAND CHANGES IN FUND BALANCES
GOVERNMENTAL FUNDS
Year ended June 30,2007
Net change In fund balances
Fund balances. beginning of year
Fund balances. end of year
B-5
1,950,461 1,652,936 3,603,397
4,368,941 13,071,687 17,440,628
5 6,319,402 14,724,623 5 21,044,025
Other
Total
General
Governmental
Governmental
Fund
Funds
Funds
Revenues:
Taxes
5 20,594,293
5
20,594,293
Licenses and permits
83,964
632,820
716,784
Intergovernmental revenues
16,091,446
3,800,342
19,891,788
Charges for services
1,854,575
2,641,633
4,696,208
Fines, forfeits and penalties
1,241,051
4,225
1,245,276
Investmentand rental income
380,375
617,703
998,078
Miscellaneous revenue
210,495
93,576
304,071
Total revenues
40,456,199
7,990,299
48,446,498
Expenditures:
Current:
General government
8,893,677
8,893,617
Public protection
21,775,531
435,792
22,211,323
Publicworks
3,871,311
1,715,482
5,586,793
Community development
2,061,706
2,061,706
Library
1,587,714
1, 587,714
Parks and recreetion
3,597,718
3,597,718
Capital outlay
3,526,339
3,526,339
Debt service:
Interest and fiscal charges
41,464
1,163,635
1,205,099
Principal payments
273,823
626,233
900,056
Total expenditures
40,041,238
9,529,167
49,510,425
Excess (deficiency) of expenditu res over (under) revenues
414,961
(1,338,888)
(1,123,927)
Other financing sources (uses):
Transfers in
4,937,314
3,926,356
8,863,670
Transfers out
(3,401,814)
(734,532)
(4,136,346)
Total otherfinancing sources (uses)
1,535,500
3,191,824
4,721,324
Net change In fund balances
Fund balances. beginning of year
Fund balances. end of year
B-5
1,950,461 1,652,936 3,603,397
4,368,941 13,071,687 17,440,628
5 6,319,402 14,724,623 5 21,044,025
EXPENDITURES
07Y OFLCDI
14 240 741
13 439 760
B00 981
SCHEDULEOF REVENUES, EXPEN D(TURES AND CHANGES IN FUND BALANCE- BUDGET AND ACTUAL
8422 t64
GENERALFUND
8 335 771
9C 723
City Council
107.719
Year ended June 30,2007
83,248
24.471
City Manager
835.842
835,842
788,492
47,350
Variance with
499,846
Original
Final
Actual
FinalBudget
REVENUES
514,372
495.071
19.301
Human Resources
Taxes
$ 19,641,605
19,641,608
20,594,293 S
952.685
Licenses and pem b
80,717
80,717
83,964
3,247
Intergovernmental revenues
15,205,635
15,205,635
16,091,446
865,811
Charges for services
1,933,921
1,814,886
1,854,575
39.689
Firm, forfakeand penal8es
1,386,909
1,380,909
1,241,051
(139,858)
investment and rental income
379.853
379.663
380.375
512
Miscellaneous revenue
254.395
254.395
210.495
43,sOD)
Total revenues
38,877,048
38,756,013
40,456,199�`Z56,iS�
Transfers in
EXPENDITURES
14,240 003
14 240 741
13 439 760
B00 981
Currant;
Gertaral government
8422 t64
8426 500
8 335 771
9C 723
City Council
107.719
107.719
83,248
24.471
City Manager
835.842
835,842
788,492
47,350
City Cferk
499,846
499,846
361.870
117,978
City Afton"
465.572
514,372
495.071
19.301
Human Resources
587.333
570.636
438,185
132.451
irdormatim Systems
1,078,143
1,092,482
1,072,088
20.394
Co"W"UnityCenter
1,433,543
1 487678
1467415
263
Finance
1,998,517
2,062,708
1,877,548
185,222
Non Daperhnanhd
2,327,951
2,297,027
2,269,762
27,L85
Total ganaralgovemment
9,334,566
9,468,370
8,893,877
574893
Public prahettion:
police
14,240 003
14 240 741
13 439 760
B00 981
Fire
8422 t64
8426 500
8 335 771
9C 723
Total public protection
22 662 1E 7
22 K 7 241
21 775 531
7' 0
Public Works
1,999,710
3,998,517
3,871,311
127,206
Library
1,646,336
1,657,561
1,581,714
69.847
Parke end recreation
3,963,717
3,855,782
3,597,718
258,0534
Debt sery w
intorestand flscalchargea
41,464
41.464
41,454
PM1dpal payments
273.823
273,623
273,623
Total debt service
315.287
315,287
315.287
Total expenditures
39,921,783
41,962,758
40,041,238
1,921,520
EXCESS (DEFICIENCY)OFREVENUES OVER
(UNDER) EXPENDITURES
(1,0447)
(3,204,745)
414,961
3,619,706
OTHER FINANCING SOURCES(USE S)
Transfers in
4,937,314
4,937,314
4,937,314
Transfers out
13,401,814)
(3,401,614)
(3,401,814)
Total otherfinan" sources (uses)
1,535,500
1,535,500
1,535,500
NETCHANGE IN FUNDBALANCE
490.765
(1,669,245)
1,950,461
3,619,706
FUND BALANCE,teglnning ofyear
2,802,660
4,368,941
4,366,941
FUND BALANCE. and ofyear
3,293,425
5,319,402
B-6
ASSETS
Current assets:
Cash and Investments
Restricted cash and Inveshnents
Resbicled weals MAOI fiscal agents
ReoWables:
Amounts, rat
Interest
Due from other governmental agendes
Advance receivable
Inve"
Odler assets
Total current assets
FlorlcrYfaM assets:
Adveroes to other talds
Da(artW chairges and other assets
Capkei aasels,net:
Nondspreciabie
Depreciable, net
Tom apim assets
Toth noncurferd assets
TOTAL ASSETS
LIA81L17ES
Curved Iiabl"es:
Accounts payable and other liabintles
Accrued Interest
Due lo Mier funds
Unearned revenue
Self-insurance liability
Accrued compensated absences
Certificates ofparticrpallon payable
Waterndfe payable
Total current IiaMlities
Noncurrent liabilities:
Sell -insurance RmbiNty
Accrued Compensated absences
Certifcates of park4mbon payable
Water note payable
Tota! norlaannt liabilltles
TOTAL LIABILITIES
NETASSETS (DEFICIT)
iryested in capital assets, not of relaled debt
RsshiCed:
Debt service
Other purposes
Unrestrcled (deficit)
TOTAL NETASSETS (DEFICIT)
CITY OF LODI
STATEMENT OF NETASSETS
PROPRIETARY FUNDS
June 30, 2007
Govsmmenlal
Sualness-type ACBvOles-Enterprise Funds Internal
Nonmajor Fund Service
Electric Wastewater Water 7rarsit 70161 Funds
$ 5,452,284 3,000,445
10,131,013 11,029,071
4,335,315
2,520,025
37,748
5,251
34 000 583
85,182
4.790.663
76 229'28
1,501,423
13,022
82
4.188
25,958,525
16,757,194
21,730,962
740,154
4,043,584
24,145,041
34 000 583
52.083087
36 044 15'
76 229'28
5Y 7'5 ' 19
7E e69 262
85 '33 647
537284'0
696,877 1,776967
1,731,278 600,465
71.17,6
1,225,173 1,225,173
22,471,118
1,904,656
28 135192
213.212 $
8,375,941 $
5,446,040
5,410,994
12 741 666
8,410,994
39 075
300.771
12 741 BW
21,450,555
39 075
6,275,419
511.735
13,842,494
203,635
20,773
1.815
65,597
45.242
16 389
884,879
970,061
475,262
4,OA6,336
4.790863
266,243
188.752
2,488,254
1,701,197
105,524
1,357
5.527
2.721
15,196,066
1,711,641
59,623,429
5,800162
1,225,173 1,225,173
22,471,118
1,904,656
28 135192
1,521,625
11,219 840
31,616,087
126 039 712
39 075
3c 54C 649
12 741 666
'57 555 799
39 075
31 888,021
12 741 BW
' e'. 352 189
39 075
47 X2 387
14.453.307
24) 975 ' 1'
584^ 23'
1 556 326
26:x,267
4,295,437
155,573
16 389
2,348,162
475,262
4,OA6,336
435,282
266,243
".?66,218
2,488,254
1,239.393
B-7
2.265,383
280,616
231,799
6,399
976
519,790
67,293
2,083948
1 365 904
3,449,852
163.4#D
63,1330
4,792,719
4,OA6,336
3,386,414
266,243
12,491,706
2,488,254
4,130,617
773402
765.357
2'3108
1,561,867
105,134
74.672,566
37,405.504
112,078,070
1.7_+4,506
1,754,606
76,445,966
38,170,861
l.ii7.714
115,381 543_4,235,751
80.238.687
42.217,191
5,164,128
286.243
127,886,249
6,72.4,005
6,009,024
48,486,791
28 723,213
12,741,666
97.9&, y84
39,075
ft.2.1.0 994
8,710,994
[2,514,0841
3,622.,49.1
4,483,7{32
1,445,398
5,417,5909{
17,843)
5 5,494,960
51,509,285
41,897,959
14,187,064 $
113,089,268 $
1878,7681
B-7
OPERATING REVENUES
Charges for services
OPERATING EXPENSES
Personnel seMvee
Supplies, materialsand a@Mm
.11ilittes
Depredation and emotftelli h
Claims
TOTAL OPERATING EXPENSES
OPERATING INCOME (LOSS)
NONOPERATING REVENUES (EXPENSES)
Investment Income
Interest expense
Rent
Operating grants
Litigation -environmental lawsuits proceeds
Other revarrAw
TOTAL NONOPERATING REVENUES (EXPENSES)
INCOME (LOSS) BEFORE CAPITAL C ONTRI BUTT ONS AND TRANSFERS
Capita[ O=Mbuttons
Transfers in
Transfers ox
Net capital contributions and transfers
Change fn net aasais
NET ASSETS (DEFICIT). BEGINNINGOF M A R
NETASSETS (DEFICIT) - END OF YEAR
CITY CF LODI
STATEMENT OF REVENUES, EXPENSES AND
CHANGES IN NET ASSETS
PROPRIETARY FUNDS
Year ended June 30, 2007
Gavemmantal
AGWIll
Sualr ess-type Ac#Ales - Enterprise Funds Intemal
Nonmajor Fund Service
Electric Wastewater Water Transit Total Furter
5 65,806,664 8,523,530 10,1739,706 400,826 I 84,772,926 $ 10,100,165
4,591,337
2,289,035
1,077,002
115,746
8,079,120
1,255,538
8,804,788
2,314,233
6,924,896
2,810,889
20,954,767
8,003,510
43,429,227
1
698,083
47,369
44,658,328
14,587
6,625,207
1,967,035
1,108,809
802,803
10,30104
1,447
6,222,568
6.222,56a
1,578,383
83,558,540
7,253972
9,806,570
3,576,807
w 84,193,889
r. 8,853,465
2252,324 1269_558 233.135 (3,175,981) 579,037 1248700_
1,206,412
922.153
235,742
15,428
2,379,735
203,234
(3,977,282)
(2,016,697)
(68,132)
(5,052,1111
116,202
12.049
4,000
192,251
2,621,063
2,621,063
6,222,568
6.222,56a
849,797
259,818
353.028
94,543
1,556,986
685,412
(1,921,0731
(658.724)
8,755,255
2,735,034
6,910,492
888,646
331,251
610,834
8,988,391
(440,947)
7,489,529
2,135,346
69,0010
11,475,030
7,296,968
1,142,783
19.983.761
40,522
2,377,724
2,377,724
,2 702 736,
1 C52 5331
3 339 719
(7,105,048)
2 1
12 X49221
3657,189
1 142783
15,256,437
40,522
(2,302,485)
13,401,0$5
10.9451580
701,816
22.745,966
2,175,888
7,797,445
X108,230
330,02,379
13,485,248
90,3433,302
(31064,636)
$ &4�E496D
41.8897,959
14,187,064 $
113 $
78,76111)
B-8
ASSETS
Cash and Investments
Receivables:
Accounts. net
Interest
Duefrom otherfunds
Due from other governmental agencies
Other assets
Loan receivable
TOTALASSETS
LIABILITIESAND FUND BALANCES
LIABILITIES
Accounts payable and other IiabHlties
Due to olher Funds
Advances from otherfunds
Deferred revenue
TOTAL LIABILITIES
FUND BALANCES (DEFICIT)
Fund balances:
Reservedfor encumbrances
Unreserved -designated forspecit7c projects and programs
TOTAL FUND BALANCES (DEFICIT)
TOTAL LIABILITIES AND FUND BALANCES (DEFICIT)
CITY OFLODI
COMBINING BALANCESHEET
NONMAJOR GOVERNMENTAL FUNDS. SPECIAL REVENUE FUNDS
June 30,2007
$ 6.486 37,417 734,202 1,000 $ 779,105
149,568 471.844 621.412
646,770 646,770
1,084,000 1,084,000
6,486 186,985 1,380,972 1,000 1,555, 44 3,131,287
1.869
188,675
6.434
(173,458)
850.042
6,546,231
2.850
89.867
HOME Program &
190,544
(167.024)
7,396,273
92,717
7,512,510
Community
19.961
Public
Community
1,555,844 5 10,643,797
Development
Safety
Development
Streets
Transportation
Block Grants
Total
$ 125.584
7,357,087
92.939
$
7,575,610
19,961
26,734
46,695
1,433
63,892
778
66,103
471.844
471,844
70.013
857,180
471.844
1,399,037
508
508
1,084,000
1,084,000
$ 197,030
19,961
8,777,245
93.717
1,555,844 $
10,843,797
$ 6.486 37,417 734,202 1,000 $ 779,105
149,568 471.844 621.412
646,770 646,770
1,084,000 1,084,000
6,486 186,985 1,380,972 1,000 1,555, 44 3,131,287
1.869
188,675
6.434
(173,458)
850.042
6,546,231
2.850
89.867
861,195
6,651,315
190,544
(167.024)
7,396,273
92,717
7,512,510
$ 197,030
19.961
8,777,245
93,717
1,555,844 5 10,643,797
B-9
CITY OF LODI
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES
NONMAJOR GOVERNMENTAL FUNDS
Year ended June 30.2007
Revenues:
Licensesand permits
I ntergovern mental revenues
Chargesfor services
Fines, forfeits and penalties
Investmentand rental income
Miscellaneous revenue
Totts revenues
Expenditures:
Current:
Public protection
P&io works
Community development
Parks and recreation
Capital outlay
Debt service:
Interest and fiscal charges
Principal payments
Total expenditures
Excess (deficiency) of revenues over (under) expenditures
Other financing sources (uses):
Transfers in
Transfers out
Total other financing sources (uses)
Net change in fund balances
Fund balances, beginning of year
Fund balances, end of year
Special
Revenue
$ 632,820
3,565,416
2,180,863
4,225
301,225
83,576
6,768,125
435,792
1,715,482
2,061,706
2,280,375
Debt
Service
Capital
Projects
Total
$
632,820
234,926
3,800,342
660,770
2,841,633
6,493,355
4,225
316.478
617,703
10,000
83,576
1,222,174
7,990,299
435,792
1,715,482
2,061,706
1,245,964 3,526,339
B-10
1,152,715
10,920
1,163,635
626,233
626,233
6,493,355
1,778,948
1,256,884
9,529,157
274,770
(1,778,948)
(34,710)
(1,538,888)
733,912
1,778,948
1;413;496
3,926,356
(101,542)
(632,990)
(734.532)
632,370
1,778,948
780,506
3,191,824
907,140
745,796
1,652, 936
6,605,370
8,466,317
13,071,687
7,512,510
7,212,113 5
14,724,623
B-10
CITY OF LODI
COMBINING STATEMENT OF REVENUES, EXPENDITURESAND CHANGESIN FUNDBALANCES
NONMAJOR GOVERNMENTAL FUNDS
Year ended June 30,2007
Revenues:
Licensesand permits
Intergovernmental revenues
Charges for services
Fines, forfeits and penalties
Investmentand rental income
Miscellaneous revenue
Total revenues
Expenditures:
Current
Public protection
Publicworks
Community development
Parks and recreation
Capital outlay
Debt service:
Interest and fiscal charges
Principal payments
Total expenditures
Excess (deficiency) of revenues over (under) expenditures
Other financing sources (uses):
Transfers in
Transfers out
Total otherfinancing sources (uses)
Net change in fund balances
Fund balances, beginning of year
Fund balances, end of year
Special Debt
Capital
1,245,964
Revenue Service
Projects
Total
$ 632,820
5
632.820
3,565,416
234,926
3,800,342
2,180, 863
680,770
2,841,633
4,225
4,225
301.225
316,478
617,703
83,576
10,000
93,576
6,768,125
1,222,174
7,990,299
435,792
1,715,482
2,061,706
435,792
1,715,482
2,081,706
2,280,375
1,245,964
3,526,339
1,152,715
10,920
1,163,635
626,233
626,233
6,493,35
1,778,948
1,256,884
9,529,187
214,770
(1,778,948)
(34.710)
(1,538,888)
733,912
1,778,948
1,413,496
3,926,356
(101.542)
(632,990)
(734,532)
632,370
1,778,948
780,506
3,191,824
907,140
745,796
1,652,936
6,605,370
6,466,317
13,071,687
$ 7,,512,510
7.,2126113 $
14,724,623
CITY OFLODI
COMBINING STATEMENTOF REVENUES, EXPENDITURESAND CHANGES IN FUND BALANCES
NONMAJOR GOVERNMENTAL FUNDS -SPECIAL REVENUE FUNDS
Year ended June 30,2007
B-12
HOME Program&
Community
Public
Community
Development
Safety
Development
Streets
Transportation
Block Grants
Total
REVENUES
Licenses and permits
632.820
5 632,820
Intergovernmental revenues
221,757
23,905
3,181,427
50,350
87,977
3,565,416
Charges for services
540,525
1,640,338
2,180,863
Fines, forfeits and penalties
3,100
1,125
4,225
Investment and rentalincome
9.759
288.368
3.098
301,225
Miscellaneous revenue
23,051
60,525
B3,576
Total revenues
234,616
1,221,426
5,170,658
53,448
87,977
6,768,125
EXPENDITURES
Current
Public protection
435,792
435,792
Publicmcfls
1,627,505
07,977
1,715,482
Community development
2,061,706
2,061,706
Capitaloutlay
2,213,916
66,459
2,280,375
Total expenditures
435,792
2,061,706
3,841,421
66,459
87,977
6,493,355
EXCESS (DEFICIENCY)OF REVENUES OVER
(UNDER) EXPENDITURES
(201,176)
(840,290)
1,329,237
(13,011)
274,770
OTHER FINANCING SOURCES (USES)
Transfers in
8.680
600,000
125,232
733,912
Transfers out
(5,436)
(96,106)("0542)
Total other Rnancing sources (uses)
8.680
594,564
29,126
632,370
NET CHANGE IN FUND BALANCES
(192,496)
(245,716)
1,358,363
(13,011)
907,140
FUND BALANCES, beginning of year
383.040
78.692
6,037,910
105,728
6,605,370
FUND BALANCES (DEFICIT), end of year
$ 190,544
(167,024)
7,396,273
92,717
$ 7,512,510
B-12
CITY OF LODI
SCHEDULE OF REVENUE, EXPENDITURESAND CHANGES IN FUND BALANCE
BUDGETAND ACTUAL
NONMAJOR GOVERNMENTAL FUNDS- SPECIAL REVENUE FUNDS
Year ended June 30,2007
REVENUES
Intergovernmental revenues
Fines, forfeits and penalties
Investment and rental income
Total Revenue
EXPENDITURES
Current
Public protection
DEFICIENCY OF REVENUES
UNDER EXPENDITURES
OTHER FINANCING SOURCES
Transfers in
NET CHANGE IN FUND BALANCE
FUNDBALANCE, BEGINNINGOFYEAR
FUND BALANCE, END OF YEAR
B-13
PUBLIC SAFETY
FINAL
BUDGET ACTUAL VARIANCE
221,757 221,757
3.100 3,10-0
9,759 9,759
221,757 234,616 12,859
435,792 435,792
(214,035) (201,176) 12,859
8.680 8,680
(205.355) (192.496) 12,859
383,040 383,040
$ 177.685 190,544 12,859
CITY OF LODI
SCHEDULE OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCE
BUDGETAND ACTUAL
NONMAJOR GOVERNMENTAL FUNDS• SPECIAL REVENUE FUNDS
Year ended June 30,2007
EXPENDITURES
Current
Community development
DEFICIENCY OF REVENUES UNDER
EXPENDITURES
OTHER FINANCING SOURCES (USES)
Transfers in
Transfers out
Total other financing sources (uses)
NET CHANGE IN FUND BALANCE
FUND BALANCE, BEGINNING OF YEAR
FUND BALANCE (DEFICIT), ENDOFYEAR
B-14
2,175,623 2,061,706 113,917
(480.937) (840,280) (359,343)
600,000 600,000
(5,436) (5,436)
594,564 594,564
113,627 (245,716) (359,343)
78.692 78,692
192,319 (167,024) (359,343)
COMMUNITY DEVELOPMENT
FINAL
BUDGET
ACTUAL
VARIANCE
REVENUES
Licenses and permits
$ 939,470
632.820
(306,650)
Intergovernmentalrevenues
23,905
23,905
Charges for services
735.881
540,525
(195,356)
Fines, forfeits and penalties
8,875
1.125
(7,750)
Investmentand rental income
9,452
(9,452)
Miscellaneous revenue
1,008
23,051
22,043
Total Revenue
1,694,686
1,221,426
(473,260)
EXPENDITURES
Current
Community development
DEFICIENCY OF REVENUES UNDER
EXPENDITURES
OTHER FINANCING SOURCES (USES)
Transfers in
Transfers out
Total other financing sources (uses)
NET CHANGE IN FUND BALANCE
FUND BALANCE, BEGINNING OF YEAR
FUND BALANCE (DEFICIT), ENDOFYEAR
B-14
2,175,623 2,061,706 113,917
(480.937) (840,280) (359,343)
600,000 600,000
(5,436) (5,436)
594,564 594,564
113,627 (245,716) (359,343)
78.692 78,692
192,319 (167,024) (359,343)
CITY OF LODI
SCHEDULE OF REVENUE, EXPENDITURESAND CHANGES IN FUND BALANCE
BUDGETAND ACTUAL
STREETS FUND
Year ended June 30,2007
REVENUES
Intergovernmental revenues
Charges for services
Investment and rental income
Miscellaneous revenue
Total Revenue
EXPENDITURES
Current
Publicworks
Capital outlay
Total Expenditures
EXCESS (DEFICIENCY) OF REVENUES OVER
(UNDER) EXPENDITURES
OTHER FINANCING SOURCES (USES)
Transfers in
Transfers out
Total other financing sources (uses)
NET CHANGE IN FUND BALANCE
FUND BALANCE, BEGINNING OF YEAR
FUND BALANCE, END OF YEAR
B-15
STREETS
FINAL
125,232
(1,014,082)
BUDGET
ACTUAL
VARIANCE
a 7,736,000
3,181,427
(4,554,573)
1,520,000
1,640,338
120,338
3,800
288.368
284.568
60,525
60,525
9,259,800
5,170,658
(4,089,142)
3,227. 874
1.627, 545
1,600,369
6,571,795
2,213,916
4,357,879
9,799,669
3,841,421
5,958,246
(539,869) 1,329,237 1,869,106
1,139,314
125,232
(1,014,082)
(136,984)
(96,106)
40,878
1,002,330
29,126
(973,204)
462,461
1,358,363
895,902
6,037,910 6,037,910
$ 6,500,371 7,396,273 895,902
SCHEDULE OF REVENUE, EXPENDITURESAND CHANGES IN FUND BALANCE
BUDGETAND ACTUAL
NONMAJOR GOVERNMENTAL FUNDS -SPECIAL REVENUE FUNDS
Year ended June 30,2007
REVENUES
Intergovernmental revenues
Investmentand rental income
Total Revenue
EXPENDITURES
Capital outlay
NET CHANGE IN FUND BALANCE
FUND BALANCE, BEGINNINGOF YEAR
FUND BALANCE. END OF YEAR
B-16
TRANSPORTATION
FINAL
BUDGET ACTUAL VARIANCE
$ 174,249 50,350 (123,899)
3.000 3.098 98
177,249 53,448 (123.801)
282.977 66,459 216,518
(105,728) (13.011) 92,717
105,728 105,728
$ 92,717 92,717
CITY OF LODI
SCHEDULE OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCE
BUDGETANDACTUAL
NONMAJOR GOVERNMENTAL FUNDS- SPECIAL REVENUE FUNDS
REVENUES
I ntergovem mental revenues
EXPENDITURES
Current
Publicworks
NET CHANGE IN FUND BALANCE
FUND BALANCE, BEGINNING OF YEAR
FUND BALANCE, END OF YEAR
Year ended June 30,2007
B-17
HOME PROGRAM and COMMUNITY DEVELOPMENT
BLOCK GRANTS
FINAL
BUDGET ACTUAL
3,347,644
87,977
VARIANCE
(3,259,667)
3,347,644 87,977 3,259,667
ASSETS
Cash and investments
Restricted assets
Receivables:
Interest
Due ftm other funds
DuetmTr other governmental agencies
Advances to other funds
TOTALASSETS
LIABILITIES
Accounts payable and other liabilities
Due toother funds
Advances from Olherfunds
Deferred revenue
TOTAL LIABILITIES
FUND BALANCES
Fund balances:
Reserved for encumbrances
Reserved for advancesto other funds
Unreserved -designated for specificprojects and programs
TOTAL FUND BALANCES
TOTAL LIABILITIES AND FUND BALANCES
OLTX QF LODI
COMBINING BALANCE SHEET
NONMAJOR GOVERNMENTAL FUNDS • CAPITAL PROJECT FUNDS
June 30.2007
Capital
Vehicle and Hutchins Outlay Lodi
Equipment Library Subdivision Street Square Reserve Lake
$ 1,307,968 12,677 300,339 2,181 4,117,675
1,750,204
$ 1,307,968 12,677 300,339 2,181
16,774
16,774
42,557
506,220
359,950 146.928
646,770
7,423,376 146,§-28-
62,577 13,124
30,958
1,497,973
359,950
1,920,500 44782
Total
5,740,840
1,750,204
42,557
506.220
506,878
646.770
$ g. +x,193469
$ 92,475
30,958
1,497,973
359,950
1,981,356
308.917 56,559 365,476
646,770 645,72 i
1,291,194 12,677 300,339 2.181 4,547,189 46,287 6,199,867
1,291,194 12,677 300,339 2,181 5,502,876 102,846 7,212,113
529969�� X00,339 2 181 7,423,376 146 928 5 9,193,469
B-18
CITY OF LW
COMBINING STATEMENTOF REVENUES, EXPENDITURESANDCHANGESIN FUNDBALANCES
NONMAJOR GOVERNMENTAL FUNDS. CAPITALPROjECT FUNDS
Year ended June 80 2007
B-19
Hutchins
Capital
Vehicle and
Street
Outlay
Lndi
Equipment Library Subdivision
Squama
Reserve
Lake
Total
REVENUES
Intanpovemmental revenues
5
234,928
$ 284,928
Charges for services
660,770
680,770
Investment and rental income
316.478
316,478
Misgellaneous revenue
10,000
10.000
Total revenues
987,248
234,926
1,222,174
EXPENDITURES
Capital outlay
342.238
685,874
237.852
1,245,964
Debt service:
Interest and flecal charges
10,920
10,920
Total expenditures
342,238
678.794
237,852
1,258,884
EXCESS (DEFICIENCY) OF REVENUEOVER (UNDER) EXPENDITURES
(342,238)
310,454
(2,926)
(34,710)
OTHER FINANCING SOURCES (USES)
Tranork a in
1,342,707
70.789
1,413,495
Transfam Ort
(632,990)
(632,990)
Total other Onancing sources (uses)
1,342,707
(632,990)
70,789
780,506
NET CHANGE I N FU ND BALANCES
1,000,489
(322,536)
67,863
745,796
FUND BALANCES, BEGINNING OF YEAR
290,725 12,677 300,339
2,161
5.825,412
34,983
6,408,317
FUND BALANCES, END OF M A R
b1,291,194 12677 300,339
2,181
5,502,876
102,848
$ 7,212.113
B-19
ASSETS
Current assets:
Cash and investments
Receivables:
Accounts, net
Interest
Inventory
Other assets
Noncurrent assets:
Capital assets (net)
Total current assets
LIABILITIES
Current liabilities:
Accounts payable and other liabilities
Self-insurance liability
Accrued compensated absences
Noncurrent liabilities:
Accrued compensated absences
Self-insurance liability
Total liabilities
NET ASSETS (DEFICIT)
Invested in capital assets, net of related debt
Unrestricted (deficit)
Total net assets (deficit)
CITY CIF LODI
COMBINING STATEMENT OF NET ASSETS
INTERNALSERVICE FUNDS
June 30,2007
B-20
Fleet
Services Fund
Claims and
Benefits Funds
Total
$
5,446,040 $
5,446,040
203,635
203,635
45,242
45,242
108,524
108,524
1.886
835
2.721
39,075 39,075
149,485 5,695,752 5,845,237
42,684 112,894 155,578
2,265,383 2,265,383
67,293 67,293
105,134 105.134
4,130,617 4,1301617
215,111 6,508,894 6,724,005
39,075 39,075
(104,701) (813,142) (917,843)
$ (65,626) (813,142) $ (878,768)
CITY OF LODI
COMBINING STATEMENT OF REVENUES, EXPENSES AND
CHANGES IN FUND NETASSETS
INTERNAL SERVICE FUNDS
Year ended June 30,2007
OPERATING REVENUES
Charges for services
OPERATING EXPENSES
Personnel services
Supplies, materials and services
Utilities
Depreciation and amortization
Claims
TOTAL OPERATING EXPENSES
OPERATING INCOME (LOSS)
NONOPERATING REVENUES
Investment income
Other revenues
TOTAL NONOPERATING REVENUES
LOSS (INCOME) BEFORE CAPITAL CONTRIBUTION
Capital contribution
Change in net assets
NET ASSETS (DEFICIT)- BEGINNING OF YEAR
NET ASSETS (DEFICIT) - END OF YEAR
B-21
Fleet
Claims and
Services Fund
Benefits Funds
Total
$ 1,567,016
8,533,149 $
10,100,165
929,589
325,949
1,255,538
727,541
5,275,969
6,003,510
14,587
14,587
1,447
1.447
1,578,383
1578,383
1,673,164
7,180,301
8,853,465
(106,148)
1,352,848
1,246,700
203,234
203,234
685,412
685,412
888,646
888,646
(106,148)
2,241,494
2,135,346
40,522
40,522
(65,626)
2,241,494
2,175,868
(3,054,636)
(3,054,636)
$ (65,626)
(813,142)
(878,768)
CITY OF LODI
COMBINING STATEMENT OF FIDUCIARY NET ASSETS
PRIVATE-PURPOSETRUST FUNDS
June 30,2006
B-22
Private -Purpose
Trust Funds
Hutchins Street
Library
Square Bequest
Total
ASSETS
Cash and Investments
$ 846,765
1,386 $
848,151
TOTAL ASSETS
846,765
1,386
848,151
NET ASSETS
$ 846,765
1.386 $
848,151
B-22
CITY OF LODI
COMBINING STATEMENT OF CHANGES IN FIDUCIARY NET ASSETS
FIDUCIARY FUNDS
Year ended June 30,2007
ADDITIONS
Investment income and donations
Total additions
DEDUCTIONS
Current
Library
Total deductions
CHANGE IN NETASSETS
NET ASSETS, BEGINNING OF YEAR
NET ASSETS, END OF YEAR
Private -Purpose Trust Funds
Hutchins Street
Library Square Bequest
$ 100,575
100,575
11,866
11,866
758,056
Total
52 $ 100,627
52 100,627
11,866
11,866
52 88,761
1,334 759,390
$ 846,765 1,386S 848,151
B-23
CITY OF LODI
STATEMENT OF CHANGES IN ASSETS AND LIABILITIES
AGENCY FUND
Year ended June 30,2007
TOTAL ASSETS $ 527,418 824,873 677,605 $ 674,686
LIABILITIES
Agency obligations $ 527,418 147,268 $ 674,686
TOTAL LIABILITIES $ 527,418 147,268 $ 674,686
B-24
Special Assessments
balance
Balance
7/1/06
Additions Deductions
6130107
ASSETS
Cash and investments
$ 453,628
739,870 603,815 $
589,683
Special assessment receivable
71,594
79,508 71,594
79,508
Interest receivable
2,196
5,495 2,196
5,495
TOTAL ASSETS $ 527,418 824,873 677,605 $ 674,686
LIABILITIES
Agency obligations $ 527,418 147,268 $ 674,686
TOTAL LIABILITIES $ 527,418 147,268 $ 674,686
B-24