Audit Work SessionFROM DELOITTE & TOUCHE LLP MINNEAPOLIS RPD 09.00.1994 14:02
P. 2
ALAJ, viork
CITY OF CHANHASSEN
Deloitte & Toucne
City Council presentation
August., 1994
Presented by;
Cliff W. Hoffman, Partner
_-.i
FROM DELOITTE & TOUCHE LLP MINNEAPOLIS RPD 09.08.1994 14:01
CITY OF CHANHASSEN
Selected Ratios
December 31, 1993
Population
Number of Households
Number of Employees - Full Time
Population per Employee
Households per Employee
Water and Sewer Funds - Loss
Before Addback of Depreciation
1893
13,388
4,$46
42
319
115
1992
12,866
4,579
42
306
109
P. 3
1981
12,702
4,350
42
302
103
a
FROM DELOITTE & TOUCHE LLP MINNEAPOLIS RPD 09.08.1994 14:02
CITY OF CHANHASSEN
Selected Performance Indicators
December 31, 1993
Chanhassen
DE�
Net Debt per Capita:
G.O. Bonds
Improvement Bonds
Total
Ratio of Net Debt to Estimated Full Value
ENERPRIS
Operating Ratio:
Water and Sewer
$ 139
P. 4
1
1
National
Averags(l )
1. x„79
2.4% 1.
82.7% 63.4%
(1) Per 1994 Moody's Selected Indicators of Municipal Performance.
FROM DELOITTE & TOUCHE LLP MINNEAPOLIS RPD 09.08.1994 14:02
CITY OF CHANHASSEN
Performance Definitions
December 31, 1993
Debt
P. 5
G.0, Bonds and Debt Service
Net Debt per Capita - Improvement Bond_ - Fjjnds nd
Population
Ratio of Net Debt to G.O. Bonds and Debt Service
Estimated Full Value lmprQve '. t B cis Funds on Hand
Estimated Market Value
Operating Ratio = _ _ Operating EZpenses (without degr iatfo
Operating Revenues
FROM DELOITTE & TOUCHE LLP MINNEAPOLIS RPD 09.08.1994 14:03
CITY OF CHANHASSEN
Operating Fund Status
December 31, 1993 vs. December 31, 1992
General
Fund
Fund Balance at
December 31,
1993
Less Property
Liquid Fund
Balance at
December 31,
1993
Fund Balance at
December 31,
1992
Less Property
Liquid Fund
Balance at
Decemer 31,
1992
Net Increase
Special
Revenue
Funds
Internal
Enterprise Service
Funds Fund
P. 6
1
Total '
$ 1,271,978 $ 512,192 $ 11,861,186 $ 1,873,785 $ 15,519,141 ,
�._ (9.5 21.0191 –(1,083 (1 0,604.7 „
-- 1.271.978 512.192 2.340.167 790.033 4.914.370 '
1,226,684 423,339 11,730,440 1, 535,914 14,916,377
-J1.Q .a61443) f99. _ 8,5411 (11,060,034 ,
423,339 — . 68.9 -I 537.M 3,85.6.343
45,291 S– AIM S 6716 A 2.�Q
FROM DELOITTE « TOUCHE LLP MINNEAPOLIS RPU 09.68.1994 14:03
CITY OF CHANHASSEN
General Fund Balance
Compared to Annual Expenditures
Five Year History
P. 7
(1) 1994 budgeted expenditures
Next
Year
Year
A
Ending
Fund
Budgeted
Annual
Percent
of Budgeted
December 31
Balance
Expenditures
Expenditures
1989
$ 1
$ 2,924,700
34.4%
1990
1,01, 5,892
3,004,095
33.8
1991
1
3,249,550
37.4
1.992
1
3
36.1
1993
1,271,978
3,793,133(1)
33.5
(1) 1994 budgeted expenditures
CITY OF CHANHASSEN
Enfie pwise Funds
Operating Revenues & Expenses
F.
mw K A rIt
$2,000,OOa
$1,9DO,OOb
$1,000.000
$5W,00a
E7
Operating Expenses ❑ Depreciation ® operating Revenue
1993 1992 1 991
CITY OF CHANHASSEN m
r
Debt Service Schedule
(Principal and Interest m
{Rounded to Nearest Thousand DoRars)
$12 =
$10
a �
j
HIM
U4
$0
O g�g6Z� 9,616,000 9,374,E -
8.5w.000 S„39a,000
D 7,755.000
6.905.000 -
M - aA42,000
36MO o
525 voa 320.Oaa
M : • i.
1 1995 19% 1997 19% 1999 2000 2001 2002 2003 2004 2005
m
r
r
3
m
D
O
r
-o
CITY OF CHANHASSEN
General Fund Revenues
24.3
7.4
• T •
$.3%
24.E .
4.9
44.1%
1994 Budget
intewveMFmntal
6.7%
50.Wo
/��
M Property Tax
5.90
25.Wo
32-4%
32%
i
CITY OF CHANHASSEN
Gerwal Fund ExpenTitures
K�
7.9%
21.5%
33.3%
3.6%
R7r"il -
31.8%
32TO
9270
20-5%
1994 Budget
"flk -
7-2%
19.9%
■ Public SafeW Public Works ■ Community Development
■ General Government ■ Relics & Recreation
20
18
16
14
c
ED 12
m
a.
10
8
6
4
CITY OF CHANHASSEN
Investm Yields and angst
For the Past Five Years
$2,100
$1,900
$1,700
$1,19M
0
a
$1,100
sm
�WG
7 1990 1991 1992 1993
Yield Eamings
interest eamings are net of $400,662 and $172,817 interfund earnings of
$323,292 and $596,432 for 1993, 1992, 1991, and 1 994 respecWety
MINE Eft
WHERE YOUR STATE TAX DOLLARS GO ...
Minnesota General Fund Spending
tsui (1992)
Post- Secondary
Education
13.4% (1
State Oper<
Local Aids, Credits
and Grants; and All
Other
33.0% (28.5 %)
-12 Education
!8.7% (32.7'
Human Services
(Healtficare, State
Instihftm and
Family Support)
24.9 ( 23.7%'0)
WHERE YOUR FEDERAL TAX DOLLARS GO ...
U.S. Federal General Funding Spending
1992
33.0%
Social Security, Medicare, and
t" fv--r RptirPmPnt
24.0%
National Defense,
Veterans, and Foreign
Affairs
14.0 0 /4
Net Interest on the
Debt
2.0 0 /a
Law Enforcement and
General Government
10.0 %
Physical, Human, and
Community Devekq ment