HomeMy WebLinkAbout7. 2008 Audit Presentation
I.
CITY OF SHAKOPEE
Memorandum
TO: Mayor and Council
Mark McNeill, City Administrator
FROM: Gregg Voxland, Finance Director
SUBJ: Comprehensive Annual Financial Report/ Auditor's Report
DATE: June 11, 2009
Introduction & Background
Enclosed are the 2008 Comprehensive Annual Financial Report and the
auditor's reports. Steve Wischmann, Partner, in the firm of Kern,
DeWenter, Viere, LTD. , will be presenting the results.
GrivOXland
Finance Director
H:\Finance\cafr\cafr08
I
I
I
I
I CITY OF SHAKO PEE
Scott County, Minnesota
I Management Letter
For the Fiscal Year Ended December 31,2008
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I CITY OF SHAKOPEE
Scott County, Minnesota
I T ABLE OF CONTENTS
I REPORT ON MATTERS IDENTIFIED AS A RESULT OF
THE AUDIT OF THE FINANCIAL STATEMENTS......................................................... 1
I MATERIAL WEAKNESS............................. ........................................................................... 3
SI GNIFICANT DEFI CIEN CIES............................................................................................. 4
I CONTROL DEFI CIEN CY....................................................................................................... 5
I REQ UIRED COMMUNICA TI ON.......................................................................................... 6
FINAN CIAL ANALySIS......................................................................................................... 9
I
I
I
I
I
I
I
I
I
I
I
I
I ~DV
I
I Expert advice. When you need it. SM
I REPORT ON MATTERS IDENTIFIED AS A RESULT OF
THE AUDIT OF THE FINANCIAL STATEMENTS
I June 2, 2009
I
Honorable Mayor and Members
I of the City Council
City of Shakopee
Shakopee, Minnesota
I In planning and performing our audit of the financial statements of the City of Shakopee,
I Minnesota, as of and for the year ended December 31, 2008, in accordance with U.S. generally
accepted auditing standards and Government Auditing Standards, we considered the City's
internal control over financial reporting (internal control) as a basis for designing our auditing
I procedures for the purpose of expressing our opinion on the financial statements, but not for the
purpose of expressing an opinion on the effectiveness of the City's internal control.
Accordingly, we do not express an opinion on the effectiveness of the City's internal control.
I Our consideration of internal control was for the limited purpose described in the preceding
paragraph and would not necessarily identify all deficiencies in internal control that might be
significant deficiencies or material weaknesses. The deficiencies in internal control we
I identified, if any, are stated within this letter.
A control deficiency exists when the design or operation of a control does not allow management
I or employees, in the normal course of performing their assigned functions, to prevent or detect
misstatements on a timely basis. A significant deficiency is a control deficiency, or combination
of control deficiencies, that adversely affects the City's ability to initiate, authorize, record,
I process or report financial data reliably in accordance with U.S. generally accepted accounting
principles such that there is more than a remote likelihood that a misstatement of the City's
financial statements that is more than inconsequential will not be prevented or detected by the
City's internal control.
I A material weakness is a significant deficiency, or combination of significant deficiencies, that
results in more than a remote likelihood that a material misstatement of the financial statements
I will not be prevented or detected by the City's internal control.
I
I
I 1
I ~DV
I
I
The accompanying memorandum includes financial analysis and recommendations for
I improvement of accounting procedures and internal control measures that came to our attention
as a result of our audit of the financial statements of the City for the year ended December 31,
2008. The matters discussed herein were considered by us during our audit and they do not
I modify the opinion expressed in our Independent Auditor's Report dated June 2, 2009, on such
statements.
I This communication is intended solely for the information and use of management, the City
Council, others within the City and state oversight agencies and is not intended to be and should
not be used by anyone other than these specified parties.
I ~ ( 7J~Lu4A~, V~, lfJ),
I KERN, DEWENTER, VIERE, LTD.
Minneapolis, Minnesota
I
I
I
I
I
I
I
I
I
I
I 2
I
I CITY OF SHAKO PEE
Scott County, Minnesota
I MATERIAL WEAKNESS
December 31, 2008
I MATERIAL AUDIT ADJUSTMENT
I We proposed an audit adjustment that we considered to be quantitatively material to the financial
statements. The audit adjustment we proposed was material to the financial statements related to
I capital assets.
I
I
I
I
I
I
I
I
I
I
I
I
I 3
I
CITY OF SHAKO PEE I
Scott County, Minnesota
SIGNIFICANT DEFICIENCIES I
December 31, 2008
LACK OF SEGREGATION OF ACCOUNTING DUTIES I
Adequate segregation of accounting duties is in place when the four areas of a transaction have I
been separated: authorization, custody, recording and reconciliation.
As part of this year's audit, we reviewed the City's documentation of its internal control over I
significant areas including: cash receipts, cash disbursements and payroll. Areas in which we
noticed a lack of segregation of accounting duties are included below.
Payroll I
The Payroll Clerk processes payroll, posts payroll to the general ledger, issues direct I
deposits, prepares the payroll taxes, initiates the transfer for payment of payroll, prepares all
W-2s, maintains all data files and the payroll program.
Cash Receipts I
Deposits at the City Hall - The front desk personnel receive money, code the revenue and I
prepare bank deposits. The Accountant reconciles cash and posts all deposits into the general
ledger.
Deposits received at the Recreation Center - One employee is able to receipt money, prepare I
the bank deposits and take the deposits to the bank.
Cash Disbursements I
The Accounting Clerk enters invoices, matches purchase orders to invoices and prepares
checks of payment. I
Management is aware of this condition and has taken certain steps to compensate for the lack of
segregation but due to the small staff needed to handle all of the accounting duties, the costs of
obtaining desirable segregation of accounting duties often exceeds benefits which could be I
derived. However, management must remain aware of this situation and should continually
monitor the accounting system, including changes that occur.
SIGNIFICANT AUDIT ADJUSTMENT I
We proposed an audit adjustment that we considered to be quantitatively significant to the I
financial statements. The audit adjustment we proposed related to investments and interest
revenue.
I
I
4 I
I
I CITY OF SHAKOPEE
I Scott County, Minnesota
CONTROL DEFICIENCY
December 31,2008
I
IMPROVE ICE ARENA RECEIPTING INTERNAL CONTROL
I During our audit, we reviewed the receipts collection system of the ice arena and found the
process to be decentralized from the City's regular receipting process. Currently, the City
I employs an ice arena manager who collects funds and also maintains copies of signed ice rental
contracts and a list of payers. Although copies of the ice arena contracts are received at City
Hall, there appears to be a lack of verification or reconciliation of these contracts to the ice arena
receipts and actual deposits.
I To improve internal control over the ice arena receipting process and to prevent omissions and
errors, we recommend the performance of periodic reconciliation of ice arena receipts to actual
I deposits.
I
I
I
I
I
I
I
I
I
I
I 5
I
CITY OF SHAKOPEE I
Scott County, Minnesota
REQUIRED COMMUNICATION I
December 31, 2008
We have audited the basic financial statements of the City for the year ended December 31, I-
2008, and have issued our report dated June 2, 2009. Professional standards require that we I
provide you with the following information related to our audit.
OUR RESPONSIBILITY UNDER U.S. GENERALLY ACCEPTED AUDITING
STANDARDS AND GOVERNMENT AUDITING STANDARDS I
As stated in our engagement letter, our responsibility, as described by professional standards, is
to express an opinion about whether the financial statements prepared by management with your I
oversight are fairly presented, in all material respects, in conformity with U.S. generally accepted
accounting principles. Our audit of the financial statements does not relieve you or management
of your responsibilities. Our responsibility is to plan and perform our audit to obtain reasonable, I
but not absolute, assurance that the financial statements are free of material misstatement. As
part of our audit, we considered the internal control of the City. Such considerations were solely
for the purpose of determining our audit procedures and not to provide any assurance concerning I
such internal control. We are responsible for communicating significant matters related to the
audit that are, in our professional judgment, relevant to your responsibilities in overseeing the
financial reporting process. However, we are not required to design procedures specifically to
identify such matters. I
As part of obtaining reasonable assurance about whether the City's financial statements are free
of material misstatement, we performed tests of its compliance with certain provisions of laws, I
regulations, contracts and grant agreements, noncompliance with which could have a direct and
material effect on the determination of financial statement amounts. However, providing an
opinion on compliance with those provisions was not an objective of our audit. I
PLANNED SCOPE AND TIMING OF THE AUDIT
We performed the audit according to the planned scope and timing previously communicated to I
you.
QUALITATIVE ASPECTS OF ACCOUNTING PRACTICES I
Management is responsible for the selection and use of appropriate accounting policies. In
accordance with the terms of our engagement letter, we will advise management about the I
appropriateness of accounting policies and their application. The significant accounting policies
used by the City are described in Note 1 to the financial statements. The City implemented the
provisions of Governmental Accounting Standards Board (GASB) Statement No. 45 in 2008. I
The City also adopted a Payroll Policy and amended its Investment Policy during 2008. We
noted no transactions entered into during the year for which there is a lack of authoritative
guidance or consensus. There were no significant transactions that have been recognized in the I
financial statements in a different period than when the transaction occurred.
I
6 I
I
I CITY OF SHAKOPEE
Scott County, Minnesota
I REQUIRED COMMUNICATION
December 31, 2008
I QUALITATIVE ASPECTS OF ACCOUNTING PRACTICES
I Accounting estimates are an integral part of the financial statements prepared by management
and are based on management's knowledge and experience about past and current events and
I assumptions about future events. Certain accounting estimates are particularly sensitive because
of their significance to the financial statements and because of the possibility that future events
affecting them may differ significantly from those expected. The most sensitive estimates
affecting the financial statements were:
I Depreciation - The City is currently depreciating its capital assets over their estimated
useful lives, as determined by management, using the straight-line method.
I Expense/Expenditure Allocation - The City is currently allocating certain costs among the
programs and supporting services benefited. The costs are allocated based on
I management's estimates.
We evaluated the key factors and assumptions used to develop the above estimates in
I determining they are reasonable in relation to the financial statements taken as a whole.
The disclosures in the financial statements are neutral, consistent and clear.
I DIFFICULTIES ENCOUNTERED IN PERFORMING THE AUDIT
We encountered no difficulties in dealing with management in performing and completing our
I audit.
CORRECTED AND UNCORRECTED MISSTATEMENTS
I Professional standards require us to accumulate all known and likely misstatements identified
during the audit, other than those that are trivial, and communicate them to the appropriate level
of management. There were uncorrected misstatements related to bond issuance costs.
I Management has determined the effects are immaterial, both individually and in the aggregate, to
the financial statements taken as a whole. A material misstatement related to capital assets was
detected as a result of audit procedures and was corrected by management.
I DISAGREEMENTS WITH MANAGEMENT
I For purposes of this letter, professional standards define a disagreement with management as a
financial accounting, reporting or auditing matter, whether or not resolved to our satisfaction that
could be significant to the financial statements or the auditor's report. Weare pleased to report
Ii that no such disagreements arose during the course of our audit.
MANAGEMENT REPRESENT A TIONS
I We requested certain representations from management which were provided to us in the
management representation letter.
I 7
I
CITY OF SHAKO PEE I
Scott County, Minnesota
REQUIRED COMMUNICATION I
December 31,2008
MANAGEMENT CONSULTATIONS WITH OTHER INDEPENDENT ACCOUNT ANTS I
In some cases, management may decide to consult with other accountants about auditing and I
accounting matters, similar to obtaining a "second opinion" on certain situations. If a
consultation involves application of an accounting principle to the City's financial statements or I
a determination of the type of auditor's opinion that may be expressed on those statements, our
professional standards require the consulting accountant to check with us to determine that the
consultant has all the relevant facts. We are not aware of any consultations by the City's
management with other accountants during the course of our audit. I
OTHER ISSUES
We generally discuss a variety of matters, including the application of accounting principles and I
auditing standards, with management each year prior to retention as the City's auditors.
However, these discussions occurred in the normal course of our professional relationship and I
our responses were not a condition to our retention.
OTHER INFORMATION IN DOCUMENTS CONTAINING AUDITED FINANCIAL
STATEMENTS I
We have not reviewed, and it is our understanding, that no other published documents exist that
contain audited financial statement information, for which we are currently auditing. As stated I
in our engagement letter, if you publish or reproduce the financial statements or make reference
to our Firm name in relation to such documents, you agree to provide us with a copy of the final
reproduced material for our approval before it is distributed. I
I
I
I
I
!I
I
8 I
-~-- .-- -~~ ~-------
I
I CITY OF SI-L-\KOPEE
I Scott County, Minnesota
I
I FINANCIAL ANAL YSIS
I December 31,2008
I
[
The following pages provide graphic representation of select data pertaining to the financial
I I position and operations of the City for the past five years. Our analysis of each graph is
I presented to provide a basis for discussion of past performance and how implementing certain
I changes may enhance future performance. We suggest you view each graph and document if our
I analysis is consistent with yours. A subsequent discussion of this information should be useful
for planning purposes.
GENERAL FUND
I fn 2008, expenditures exceeded revenues for the third time in five years. However, fund balance
did increase by S 152,069 as a result of net transfers in ofS 563,044. Of the tota1200S fund
I balance, $ 8,733,528 was unreserved. It is the City's policy to maintain an unreserved fund
balance between 40% and 45% of the subsequent year's expenditures and transfers out. The
unreserved fund balance at December :3 I, 2008 represents 47% 0 f the 2009 budgeted
I expenditures and transfers out. The bar chart below highlights the General Fund total revenues,
expenditures and fund balance for the last five years.
I \
iGeneral Fund
$18,000.000 !
I $ \ 6,000,000 I
I
$14.000.000 ~
I I
I
------,
$12,000,000 I
I
I ------,
SIO,OOO.OOO
I I I
:56,000.000 - I
I
S4,OOO,OOO - I
I
S2,OOO,000 I,
I S- I
2004 2005 2006 2007
1111 Revenues S 12,887,186 [ SI4.495,115 i S 13,750.652 S \5.266.076 S \5,878,047 \
o Expenditures I 11,199,607 I 12,259,973 I 13.862,250 16,129,807 16,289,022 I
I
I 18 Fund Balance! 7246,854 I 9.679.142 I 9.844.634 9.707.533 9,859,602 I
I
I \
I
I
I
I I
9
I
I
ClTY Of SHAKOPEE I
Scott County, i'vlinnesota I
FlNANClAL ANAL YSlS
December 31, 2008
I
GENERAL FUND
The City has experienced increased revenues in four of the last fi ve years. In 2008, revenues I
increased S 611,971, or 4%, from S 15,266,076 in 2007 to $ 15,878,047 in 2008. This increase
was primarily a result of an 11 % increase in tax revenue as a result of a levy increase. Offsetting I
the increase in property tax revenue was a decrease in license and permit revenue of$ 282,243,
or 29%, as a result of a general decline in the economy. In addition, intergovernmental revenue
decreased $ 229,026, or 39%, due to a federal Homeland Security Grant received in the prior I
year. The following graphs illustrate the allocation of the revenues for 2008 and 2007.
I
12008 General Fund Revenues I
Charges for Services
Fines and Forfeitures 7% I
\ '",
'0' J ,0
J ,0 \
\
Licenses and Pennits \
-l%
[ntergovcrnm~ntal_~' I
2%
I
Taxes
81% I
(2007 General Fund Rcvenucsl I
Charges for Services \liscelJanlZ'ous I
401
7"' /0
m
Fines and Forfeitures - \
3"' \ I
Licenses and Pennirs
6"
m
I
Taxes I
76%
I
I 10 I
,
,----.----- -------- -~--- ---~---
I
I CITY OF SHAKOPEE
I Scott County, Minnesota
FINANCIAL ANAL YSIS
December 31, 2008
I I
GENERAL FUND
I I
[General Fund Revenues
I I Budget and Actual
$11,000,000 I
I I
S 12.000,000 -
I 510.000,000
I I 58.000.000 -
I
56,000.000 -
I
54,000,000 -
I
I ~1,l4," l,-;" LII-~-~-~.-
Sp<":CI.1.l Ass<..:ssm<..:nts i Int<..:rgo\-"cmmcntal I liccnses J.Jld P..:nmts Fincs JJ1d Forf..:its i Charges for S..:rvic..:s .\1isccllancotls
E!ActuJJ $12.371.292 $9.950 S36l.-H2 I S691AI5 $366.618 $1.043.250 I $~&.l.lIG
. Budg..:t 11.979AIO 2.000 344.000 820.000 ,ljO,OOO 644.650 i 410.000
I As show'n in the above graph, actual revenues were fairly close to budgeted amounts for 2008.
I Actual revenues exceeded budgeted revenues by $ 242,987. The largest variance betvveen
budgeted and actual amounts was in charges for services where budgeted amounts exceeded
actual amounts by $ 442,488. This variance was primarily a result of an increase in police
contracted services, more specifically for the Republican National Convention. This was
I somewhat offset by a licenses and permit revenue falling below budget by $ l28,585 as a result
of a downturn in the housing market caused by the general decline in the economy.
I
I
I
I 11 I
I
CITY OF SHAKO PEE I
Scott County, Minnesota I
FINANCIAL ANALYSIS
December 31, 2008
I
GENERAL FUND
(n 2008, total General Fund expenditures increased.5 159,215, or 1%, ti'om.5 16,129,807 in 2007 I
to S 16,289,022 in 2008. Expenditures have increased steadily over the past live years because
of growth in the City. The following is an illustrated expenditure breakdown for 2008 and 2007. I
The largest expenditure increase during 2008 was in recreation with an increase of S 244,326.
This increase was primarily a result of a more accurate allocation of salaries to recreation in 2008
than in the prior year. Cn addition, general government expenditures increased S 161,761 due to I
increases in salaries and benefits. These increases were somewhat offset by a S 263,554
decrease in public safety as a result of the City purchasing radios in the prior year.
2008 General Fund Expenditures I
\liscdlaneous I
r 1% G~ncral Govcmm~nt
I 20%
I
:.' " I
Public Works
16% -------~
I
I
Public Safety
52%
(2007 General Fund Expenditures I
Recreation I
IO~~ Gcnerai Gon:mment
I
Public Works
16%
I
I
Public Safety I
5..t~"O
l2 I
r---
I
I CITY OF SHAKOPEE
I Scott County, Minncsota
FINANCIAL ANAL YSIS
Dccember 31, 2008
I I
GENERAL FUND
I I General Fund Expenditures
I Budget and Actual
I
I
I 57,000,000 -
56,000,000 -
I $5 .000.000 -I
I 54,000,000
I 53,000,000
I
I I 58,452,941 52,581.368 51.863,597
3,539,850 8,678,020 2,859,150 2,0 I 0200
I I Actual expenditures were under budgeted amounts in the General Fund by $ 957,950. As shown
I above, actual expenditures came in below budgeted amounts in every function. The largest
ditTerences bet\veen actual and budgeted amounts were in public works and public safety, where
actual expenditures were under budgeted expenditures by S 277,782 and $ 225,079, respectively.
Public works expenditures were under budget as a result of the City budgeting personnel costs
I here that were allocated to other programs based on actual hours worked. Public safety
expenditures were under budget due to the City leaving two police officer positions open during I
the year. In addition to the programs shown above, the City annually budgets an amount for I
I unexpected expenses which may occur. For 2008, the City budged $ 157,240 and only expended
I $67,661.
I
I I
I
I 13
I
I I
I
I
] CITY OF SI-IAKOPEE
Scott County, i\tfinncsota I
FINANCIAL ANAL YSIS
December 31, 2008
I
DEBT SERVICE
The following charts illustrate debt service requirements through 2030 and bonded debt for the I
last five years.
I Debt Service Schedule I
!<Including Principal and [nter"est)
57.000.000 'j"! I I
56.000.000 - ! I
55.000.000 I i
54.000.000 . -I ! I
I
i
- I
53.000.000 - -
52.000.000 - - - - - I
I
I
- -
- - - - - - - I
I . G.O. Bonds o Revenue Bonds I I
I Bonded G.O. Debtl I
530.000.000
525.000.000 I
520.000.000 I
515.000.000
5 I 0.000.000 I
55,000.000 I
I
$- I
2004 2005 2006 2007 2008
o Gross Bonded Debt cr 0'et Bonded Debt . Debt S~:r\iice Fund Balance
14 I
I
I CITY OF SHAKOPEE
I Scott County, Minnesota
FINANCIAL ANAL YSIS
December 31,2008
I
ENTERPRISE FUNDS
I The City has four enterprise funds. The following charts compare the segment information and
retained earnings ot' all the enterprise funds for the last five years.
I i Electric Fund
I i
i
I I
I
I
S5.000.000
I $-
200~ 2005 2006 2007 2008
II Operating R~vcnucs iii Operating Expenses
I . Operating Income o Income before Contributions and Transfers
. Change in ~et Assets
I [\Vater Fundi
S..500.000 1/1 I
I
I
s~.ooo.ooo -rr-- i
I i
S3.500.000 - I !
I i
S3.000.000 I
I S2.500,000 i
I
S2.000.000 I
I
,
S 1.500.000 I
I I
S 1.000,000
S500,000 -
I S(500.000) .
200~ 2005 2006 1007 2008
I III Operating Revenues iI Operating Expenses
a Operating Income (Loss) o rnearne before Contributions and Transfers
. Cham!c in :\'et Assets
I I 15
,
I
ClTY OF SHAKO PEE I
Scott County, iVlinncsota I
FlNANClAL ANALYSlS
December 31, 1008
I
ENTERPRISE FUNDS
[Sewer Fundi I
..1 I I
55.000.000 - ' i
;
I
54,000.000 I
5:3,000,000 - I
-
52,000,000 - I
: , I
- -
$- - I
I
$( \ ,000,000) , /
2004 2005 2006 2007 2008 I
I
I . Operating Revenues lil Operating Expenses I!!l Operating [neorne (Loss) o Change in Net Assets
During 2008, the Sewer Fund had an operating loss of $ 762,195. This is the third consecutive I
year this Fund has had an operating loss. This "vas primarily a result of increases in operating I
expenses, including depreciation. Operating expenses increased $ 323,954, or 14%, from
$ 2,938,955 in 2007 to $ 3,304,759 in 2008. Although the Fund had an operating loss for the
year, the Fund net assets increased by S 611.206. primarily as a result of capital contributions
Cram the City in the amount of $ 603,716 and investment income of $ 777,190. I
I
I
I I
I I
16 I
I
I CITY OF SHAKOPEE
I Scott County, Minnesota
FINANCIAL ANALYSIS
December 31,2008
I I
ENTERPRISE FUNDS
I I [Storm Drainage FundI
I :55,000,000 /1 -------~
I
!
I i i
i
I i
I 54,000,000 - !
I I
I
i
I I
:53,000,000 - I
I
!
I :52,000,000 - I
!
I :5 \'000,000 - I
I
-1
:5. - I
I I
:5( I ,000,000) I
I 2004 2005 2006 2007 2008
. Service Charges Ii)! Operating Expenses [J Operating Income (Loss) o Change in Net Assets
I I
The Storm Drainage fund realized a $ 170,002 operating loss for the year. This is the third
I consecutive year this Fund has had an operating loss, This was primarily a result of increases in
operating expenses, including depreciation. Operating expenses increased $ 83,298, or 6%, from
$ 1,352,078 in 2007 to $ 1,435,376 in 2008. Although the Fund had an operating loss again this
year, the Fund net assets increased by $ 706,206, primarily as a result of investment income of
I $ 820,294.
I
I
I
I 17
I
CITY OF SHAKOPEE I
Scott County, Minnesota I
FINANCIAL ANALYSIS
December' 31, 2008
I
INTERNAL SERVICE FUNDS
The Equipment Fund was starred in [995 to fund City equipment purchases. The Fund has I
shown increasing growth and income each year as illustrated in the following chart. This
increase is primarily because of new equipment additions and user charge adjustments to the I
various departments,
r
!Equipmcnt Fund I
51.200,000 l ~ , I
I
I I
Sloooooor I
I
i
I
I I
$800.000 n I
i
I I
I
i
$600,000 . /: l
I I
!
$400.000
$200,000 I
$- , I
2004 2005 2006 2007 2008
I
I . Rental Charges Iii Operating Ex penses/Depreciation [] Operating Income o Change in Net Assets I
,
I
I
I
I
18 I
-- -------- ._----.--
I
I CITY OF SHAKO PEE
I Scott County, Minnesota
FINANCIAL ANAL YSIS
December 31, 200S
I
INTERNAL SERVICE FUNDS
I The Building Fund was established in 1999 to fund City building improvements. The following
I chart illustrates fund activity for 2004 through 2008. The Fund saw a large increase in net assets
I in 2005 mainly because of the completion of the City's public works building. The decrease in
I net assets for 2008 is a result of the City opening a new internal service fund for park assets and
transferring park buildings from the Building Fund to the Park Assets Fund.
I [Building Fundi
I I ~ i
$3.500.000 i
! .' I
~
I I
~ 1 I
I $3.000,000 - ,
I ( I
I I
i
P I
$2.500,000 . k I
I !
52.000,000 - I
I
I I
I >8
I $ 1.500,000 /, i i
i i I
i I
$ 1.000,000 - :~
I $500,000 -
! "0;
I
I I ! ~~.} ~t;t^" -
$- - , i I
J. .
/
I 5(500,000) ',/
2004 2005 2006 2007 2003
I . Rental Charges
l - II Operating ExpenseslDepreciation i:J Operating rncome o Change in Net Assets
I
During 2008, the City opened the Park Assets Fund to fund the replacement of park assets. This
I Fund realized an operating loss of$ 2l0,057 in 2008; however, the Fund received $ 8,408,176 in
, contributed assets from the City during the year, of which $ 140,615 was contributed from the
Building Fund.
I
I
I 19
I
CITY OF SHAKOPEE I
Scott County, Minnesota I
FINANCIAL ANALYSIS
December 31, 2008
I
INTER.\'AL SERVICE FUNDS
The Employee Benefits Fund was established in 2004 to account for funds accumulated for City I
employee compensated absences. The Fund is fully funded with $ 1,774,259 in assets and
S 1,667,919 in liabilities. I
ADDITIONAL INFORMATION
As seen in the chart below, the City's taxable tax capacity has been consistently increasing since I
tax reforms were implemented in 2002. Taxable tax capacity increased 12% from 2007 to 2008,
which enabled the City to increase the certified levy amount by 12%. As a result of these
changes, the City's tax capacity rate decreased slightly from 31.940 for property taxes payable in I
2007 to 31.930 in 2008.
[Taxable Tax Capacity and Certified Levy I
/i I
':15,000,000 ~ j
/1 !
"10,000,000 tJ
'" . I
535,000,000 - i ~ III ,
,
I
"0,000,000 t:1 - I
r;~' I
'25.000,000 t:Jr:;,. i
," III -
I I
' ,
520,000,000 i '" III I I
I
5 15,000,000 -
510,OOIJ.IJIJO I
S5JJOO.OOO
5- I
I
i [I Taxable Ta.x Capacity $25,626,029 530,211,233 '531,6[8,556 I '536,078,921 5..0,291,1..9
I I
,
. Certified Levy 8,625,695 9,703.206 10,951,917 i 12,745.....9 1..,222,007 I I
I
I
20 I
1
I
I I CITY OF SHAKOPEE .
Scott County, Minnesota I
I I FINANCIAL ANALYSIS
I
December 31, 2008 I
I I
ADDITIONAL INFORMATlON I
I [Tax Capacity Ratel I
I >>OOT- I
'0000 I '
I 45.000 '
I .joooo i
I
I 35000 i
132ml 1319401 1319301
I '0000, ~::.j I
25.000 ' ,
2004 2005 200G 2007 2008
I General Fund Rcvcnues/Expcnditurcs
I PCI' Capita
I
I '
I
I
I
I
2004 2007 2008
I I B! Revenues III Expenditures I
2004 2005 2006 2007 2008
Population 28,913 31,000 32,800 33,460 33,660
I Number of Full-Time Employees 117 124 127 126 125
Population Per Employee 247 250 258 266 269
I 21
I
i CITY OF SE-IAKOPEE I
I Scott County, i\linncsota
I
FINANCIAL ANALYSIS
December 31, 1008
I
ADDITIONAL INFORMATION
INational Bond Ratings I
! ~
~ ,---; I
18%~ ;~I~
I
16%
I~%
12% I
10% I
8"1
,n
6% I I I
I
I I I
~% I
2% I
0%
Aaa Aal Aa2 t\a3 * Al A2 A3 Baal Baa2 Baa3 Below I
* - Denotes City's Rating
The City's bond rating was raised to 1\a3 in April 2004. I
I
! I
I
I
I
I 22 I
-~ --~ 1
I
, I
I I I
CITY OF SHAKO PEE
I Scott COllllty, Minnesota I
I
FINANCIAL ANAL YSIS I
December 31, 2008
I I
ADDITIONAL INFORMATION I
I
The following information shows 2008 per capita data for the City in comparison to three other I
cities similar in size and/or operations (Cities of Savage, Crystal and Apple Valley). This
I inlormation is based on the population estimates listed below. When analyzing this intormation, I
keep in mind that each City is unique in its operations.
Po ulation Em 10 ees
I 33,660 l25
25,532 liS
I 22,138 87
I 50.074 274
I The graph below shows the total General Fund revenues and expenditures per capita, as well as
General runcl tax revenues per capita for the various Cities.
I I 2008 General Fund
I
Revenues and Expenditures Per Capita
I 600.00
500.00
I I
400.00
I I
300.00 I
I 200.00 I
I
I 100.00 I
I I , I I \
Total Expenditures I Total Revenues Tax Revenues
I I
!E] Shakopee I 483.93 I 47L72 382.39 I
I
I
:. Savage I: 432.78 I 445.77 359.41 I
!
I !OCrystal I 478 04 I 5i673 322.71
!I ! 441. 84 I 475.18 i 373.62 I
10 Apple Valley i I
I * Revenues and expenditures obtained from audited tinancial data I
** Population for the City of Apple Valley is 2007 intormation as 2008 data is unavailable I
I 23 I
. .I
: I
I CITY OF SHAKOPEE I
Scott County, Minncsota
FfNANCIAL ANALYSIS I
December 31,2008
I
I ADDITIONAL INFORMATION
I The following graphs show the General Fund expenditures by function per capita for the various I
I Cities. The first graph includes all expenditures and the second graph excludes the expenditures
I tor [nternal Service Fund rents Whicl: are charged to the various functions. I
! :2008 General Fund
I
I Expenditures Per Capita I
200.00 1 I
\80.00 I
160.00 I
140.00
\20.00
100.00 I
80.00
60.00
40.00 l I
20.00 I
I General Government! I
! C_~l.~.n; nO!.1 ! 1--'.;"7 ) ,,':;J "'f-.r:;a ""1; I
1 III JII'lh.UPl.;1; ").' ~ I .7_...' i "'.... ,S /'J.,-'/ ~J.-, 7 ,
I. Savage 79.57 I \49.0\ =1 39.14 87.86 50.67 I
10 Crystal i 91.6\ I 173.53 I 35.27 43.34 37.75 I
!O Apple Valley I 96.29 I \45.33 I 34.30 6737 35.27 I I
i 2008 Gencral Fund Expenditures
I Pcr Capita (Excluding Internal Service Fund Rents) I
200.00 1 I
180.00
160.00 I
I \40.00 I
120.0n
100.00 I
80.00
60.00 .
= I
20.00
ill Shakopee I 96.46 I \63.92 66.97 47.3\ I
. Savage ! 79.57 I 149.0\ 87.36 50.67
[Q.0sta\ I 91.6\ I \73.53 48.34 37.75
:0 App\e Valley I 96.29 I 145.88 34.30 67.87 I 35.27 I
* Expenditures obtained from auclitecllinancial data 24 I
---
I
I CITY OF SHAKOPEE
I Scott County, Minnesota
I
FINANCIAL ANAL YSIS
December 31,2008
I I
ADDITIONAL I~FORMA TION
I
The graph below shows the total revenues, expenditures, capital outlay and outstanding debt per I
capita for the various Cities. [nformation is based on totals for all governmental funds.
I 2008 Per Capita Information I
Governmental Funds
I I 3.000.00 I
I 2,500.00 I
2.000.00 I
I
I
1,500.00
I I
LOOOOO I
I
I 500.00 I
I I
I 70 l.57 740.44 428.93 109.42 I
llliJ Shakopee
I I. Savage I 2,621.42 950.46 641.65 26904
I !O Crystal
I 418.16 868.72 426.12 354.10 i I
[0 Apple Valley I 929.72 653.89 438.50 232 98
I * Revenues, expenditures and outstanding debt obtained from audited tinancial data I
I
I I
I
I
I ,
I
I I
I 25 I
I
I
I
I CITY OF SHA'KOPEE, MINNESOTA
I Sc~tt County
I COMPREHENSIVE ANNUAL FINANCIAL REPORT
For the Fiscal Year Ended
I December 31, 2008
I DEPARTMENT OF FINANCE
I GREGG M. VOXLAND, Director of Finance
I
I
I MEMBER OF GOVERNMENT FINANCE OFFICERS ASSOCIATION
OF THE UNITED STATES AND CANADA
I 129 HOLMES STREET SOUTH
SHAKOPEE, MN 55379
I
I
I
I
I
I
I
I CITY OF SHAKOPEE
I Scott County, Minnesota
TABLE OF CONTENTS
I SECTION I
Page
INTRODUCTORY SECTION:
I Elected Officials and Administration... .................. ......... ..... ............. ........ ....................... 1
Organization Chart........................................................................................................... 2
Letter of Transmittal........ ................... ...................... ..... .................. ................................ 3
I Certificate of Achievement for Excellence in Financial Reporting................................. 7
SECTION II
I FINANCIAL SECTION:
Independent Auditor's Report......................................... ................................................. 9
I Management's Discussion and Analysis (Unaudited) ..................................................... 11
Basic Financial Statements:
Government-Wide Financial Statements:
I Statement of Net Assets ........... ....................... ............................... ...................... 24
Statement of Activities...................... .......................................... ......................... 25
Fund Financial Statements:
Balance Sheet - Governmental Funds................................................................. 26
I Reconciliation of the Balance Sheet to the Statement of Net Assets-
Governmental Funds... ......... .................... ........... ............... ............................... 27
Statement of Revenues, Expenditures and Changes in Fund Ba1ances-
I Governmental Funds........................................................... .............................. 28
Reconciliation of the Statement of Revenues, Expenditures and Changes
in Fund Balances to the Statement of Activities - Governmental Funds ......... 29
I Statement of Revenues, Expenditures and Changes in Fund Balances -
Budget and Actual - General Fund................................................................... 30
Statement of Net Assets - Proprietary Funds ...................................................... 32
I Statement of Revenues, Expenses and Changes in Fund Net Assets-
Proprietary Funds...... ..... ..... ......................... ................... ........ ..... ..................... 33
Statement of Cash Flows - Proprietary Funds..................................................... 34
I Statement of Fiduciary Net Assets. ............... ....................................................... 36
Notes to the Financial Statements .......................... ............................. ....................... 37
Required Supplementary Information:
Schedule of Funding Progress - Post Employment Benefits Plan............................. 72
I Supplementary Information:
Combining and Individual Fund Financial Statements and Schedules:
Combining Balance Sheet - Nonmajor Governmental Funds ............................. 74
I Combining Statement of Revenues, Expenditures and Changes in Fund
Balances - Nonmajor Governmental Funds ....... .................... .......................... 80
Schedule of Revenues, Expenditures and Changes in Fund Balances-
I Budget and Actual:
Transit Fund............................................... .............................. ....... ............. 87
Telecommunication Fund................. ............................ ................ ................ 88
I Economic Development Authority Fund...................................................... 89
Recreation Fund............................................................................................ 90
I
I
I CITY OF SHAKOPEE
I Scott County, Minnesota
TABLE OF CONTENTS
I SECTION II
Table Page
FINANCIAL SECTION:
I Supplementary Information: (Continued)
Combining and Individual Fund Financial Statements and Schedules (Continued):
Combining Statement of Fund Net Assets - Internal Service Funds .................. 91
I Combining Statement of Revenues, Expenses and Changes in Fund Net
Assets - Internal Service Funds...................................................... .... ............... 92
Statement of Cash Flows - Internal Service Funds ............................................. 93
I Statement of Changes in Assets and Liabilities - Escrow Agency Fund ............ 94
SECTION III
I STATISTICAL SECTION:
Net Assets by Component..................................................... .......................................... 1 96
Changes in Net Assets..................................................................................................... 2 97
I Fund Balances - Governmental Funds.......................... .................................................. 3 99
Changes in Fund Balances - Governmental Funds ......................................................... 4 100
Tax Capacity and Estimated Actual Value of Taxable Property ..................................... 5 101
I Direct and Overlapping Property Tax Rates.................................................................... 6 102
Principal Taxpayers......................................................................................................... 7 103
Property Tax Levies and Collections............ ................................................................... 8 104
I Ratio of Outstanding Debt by Type ............................................... .................................. 9 105
Ratio of General Bonded Outstanding........ ...... ............................................................... 10 106
Direct and Overlapping Governmental Activities Debt .................................................. 11 107
I Legal Debt Margin Information.... ..... ................ ............................................ ........ .......... 12 108
Pledged Revenue Coverage ......................... ............................. .......................... ............. 13 109
Demographic and Economic Statistics............................................................................ 14 110
Principal Employers......................................................................................................... 15 III
I Full- Time Equivalent City Government Employees by Function/Program.................... 16 112
Operating Indicators by Function/Program..................................................................... 17 113
Capital Asset Statistics by Function/Program ................................................................. 18 114
I
I
I
I
I
I
I
I CITY OF SHAKOPEE
I Scott County, Minnesota
ELECTED OFFICIALS AND ADMINISTRATION
December 31, 2008
I
Elected Officials Position Term Expires
I John Schmitt Mayor December 31, 2009
I Matthew Lehman Council Member December 31, 2011
Patrick Heitzman Council Member December 3 1, 2011
I Steven Clay Council Member December 31, 2009
I Terry Joos Council Member December 31, 2009
Administration
I Mark H. McNeill City Administrator Appointed
I Gregg M. V oxland Finance Director Appointed
I
I
I
I
I
I
I
I
I I
I
I
,
I
I
~
....
<IJ
0 I
.c-
O
I
I
I
I
E-- I
= ~
~~ <00
~ ~ :== I
~ ~ u=
0= N
= Z ~
~.... -
<~ OM
:= ~ -..
.c E-- ~ I
rJ'J. <..c
~ S N 5
o 0 _ ~
U Z(j
~- <~ I
E--- I-'~
_ 0 ~
U~ 0
I
I
I
I
I
2
I
I
I
I SHAKOPEE
I
June 2,2009
I
To the Honorable Mayor, Members of the City Council, and Citizens of the City of Shakopee:
I State law requires that all general-purpose local governments publish within six months of the
close of the fiscal year, a complete set of financial statements presented in conformity with
I generally accepted accounting principles (GAAP) and audited in accordance with generally
accepted auditing standards by a firm of licensed certified public accountants. Pursuant to that
requirement, we hereby issue the Comprehensive Annual Financial Report of the City of
I Shakopee for the fiscal year ended December 31, 2008.
The report consists of the City's management team representations concerning the finances of
I the City of Shakopee (City). Consequently, management assumes full responsibility for the
completeness and reliability of all of the information presented in this report. To provide a
reasonable basis for making these representations, management of the City has established a
comprehensive internal control framework that is designed both to protect the government's
I assets from loss, theft, or misuse and to compile sufficient reliable information for the preparation
of the City's financial statements in conformity with GAAP. Because the cost of internal controls
should not outweigh their benefits, the City's comprehensive framework of internal controls has
I been designed to provide reasonable rather than absolute assurance that the financial statements
will be free from material misstatements. As management, we assert that, to the best of our
knowledge and belief, this financial report is complete and reliable in all material respects.
I The City of Shakopee's financial statements have been audited by Kern, DeWenter, Viere, Ltd., a
firm of licensed certified public accountants. The goal of the independent audit was to provide
I reasonable assurance that the financial statements of the City for the fiscal year ended December
31, 2008, are free of material misstatements, and to comply with state law requiring such an audit.
The independent audit involved examining, on a test basis, evidence supporting the amounts and
I disclosures in the financial statements; assessing the accounting principles used and significant
estimates made by management; and evaluating the overall financial statement presentation.
The independent auditor concluded, based on the audit, that there was a reasonable basis for
rendering an unqualified opinion that the City's financial statements for the fiscal year ended
I December 31, 2008, are fairly presented in conformity with GAAP. The independent auditor's
report is presented as the first component of the financial section of this report.
I Management is providing a narrative introduction, overview, and analysis to accompany the basic
financial statements in the form of 'Management's Discussion and Analysis' (MD&A). This letter
of transmittal is designed to complement the MD&A and should be read in conjunction with the
I MD&A.
I
COMMUNITY PRIDE SINCE 1857
I \29 Holmes Street South' Shakopee, Minnesota' 55379-\35\ . 952-233-9300 . FAX 952-233-3801 . www.ci.shakopee.mn,us 3
I
Profile of the Government I
The City of Shakopee was incorporated for the second time in 1870 and is located about 25 miles I
southwest of Minneapolis. Bounded by the Minnesota River on the north, Shakopee is in the
northern part of Scott County and is the county seat. The City is one of the most rapidly growing
communities of the state. The 2000 population of the City was 20,568 and the land area covered I
is approximately 30 square miles. For 2008, the estimated population is about 34,000. The City
is empowered to levy a property tax on both real and personal property located within its
boundaries. It is also empowered by state statute to extend its corporate limits by annexation, I
which occurs periodically.
Shakopee is organized in Minnesota under Plan A, which includes a City Administrator, but the I
City Council retains most decision making authority such as policy setting, adopting ordinances,
budget adoption and staffing. The City Council has four members who serve staggered terms of
four years plus the Mayor who serves a two-year term. All cou,!cilpositions are non-partisan, I
part-time and members are elected at large.
The City provides the normal municipal services such as police and fire protection, street and I
infrastructure construction and maintenance, parks and recreation, planning and zoning. Also
provided are electrical distribution, water, sewer and storm drainage utilities, organized refuse
collection and recycling, and some transit services. Electric and water utilities are operated by
Shakopee Public Utilities Commission which is appointed by the City Council and is included as I
an integral part of the City's report. Housing, economic development and redevelopment are
controlled by the Shakopee Economic Development Authority. The Authority is comprised of City
Council members and is included as an integral part of the City's report. I
The annual budget is the basis for the City's financial planning and control. Budget requests from
divisions are submitted in July and are prepared by fund and division. The City Administrator I
reviews the submittals and presents City Council with a proposed budget in August of each year.
City Council is required to adopt a maximum tax levy by September 15. The final tax levy and
budget are adopted in December after a public hearing. Budgeting control is provided by an I
annual budget resolution passed by City Council (or EDA as appropriate). Formal control is at the
division level and Council action is necessary to change budgeted amounts between divisions
and/or funds. The Finance Director or City Administrator may make changes within divisions.
Along with the operating budget, a five-year capital improvement plan and a ten-year major I
equipment list is also prepared annually. Budget-to-actual comparisons are provided in this report
for each individual governmental fund for which an appropriated annual budget has been formally
adopted. I
Factors Affecting Financial Condition
The information presented in the financial statements is perhaps best understood when it is I
considered from the broader perspective of the specific environment within which the City of
Shakopee operates. I
Compared to the majority of national markets, the City has had a relatively
Local Economy.
stable economic environment and local indicators point to some rebound in the housing market. I
While still down significantly from the peak development years, the number of building permits
that have been issued by the City are up slightly in 2009 over 2008. Housing had grown rapidly
I
4 I
I
I following the opening on the new Highway 169 bridge over the Minnesota River in 1995. Overall,
the slowdown in the housing industry over the past two years has impacted the City.
I However, the local commercial industrial sector seems to have been spared major contraction.
The City has traditionally had a strong industrial base with commercial/industrial property currently
I comprising 19% of market value and 34% of tax capacity. The largest commercial/industrial
taxpayer comprises 1.3% of total tax capacity, which indicates the diversity of the local tax base.
Companies in the City manufacture chemicals, malt, roofing products, glass, cardboard and
I electronics with electronics being the rapidly growing industry in recent years.
The tax base decreased 5% for taxes payable in 2009, after having increased 11 % for taxes
I payable in 2008. Tax capacity decrease for taxes payable in 2010 appears will be around 5%.
Long-term financial planning.
I About every year, the City issues bonds to fund infrastructure expansion and additions for the
growing population. Much of this debt is funded by special assessments against benefited
properties. The City has built a new library (2003), police station (2003) and public works building
I (2005). One replacement and one additional satellite fire station are anticipated to be built over
the next five to ten years. The Shakopee Public Utilities Commission constructed a new service
center in 2004.
I The City of Shakopee annually prepares an updated five-year capital improvement plan and ten
year capital equipment list.
I Cash management policies and practices. Cash temporarily idle during the year was invested
in commercial paper or securities backed by the U.S. Government such as treasuries and
agencies or pools that invest in such securities. Of the city's total investments, 28% will mature in
I less than one year and 40% will mature in one to five years. The majority of the portfolio is
managed by an independent investment manager. The manager is required to follow the City's
Investment Policy.
I Risk management. The City has third party insurance coverage for all significant risks. The City
has the exposure for deductibles under the various policies. Deductibles are $5,000 or less.
I Pension and other post employment benefits. All full-time and certain part-time employees of
the City of Shakopee are covered by defined benefit plans administered by the Public
Employees Retirement Association of Minnesota (PERA). PERA administers the Public
I Employees Retirement Fund (PERF) and the Public Employees Police and Fire Fund (PEPFF).
These are cost sharing, multiple-employer retirement plans. These plans are established and
administered in accordance with Minnesota Statutes, Chapters 353 and 356. The City has no
I obligation in connection with employee benefits offered through this plan beyond its annual
required contributions.
I PERA issues a publicly available financial report that includes financial statements and required
supplementary information for PERF and PEPFF. That report may be obtained by writing to
PERA, 514 St. Peter Street #200, St. Paul, Minnesota, 55102 or by calling 651-296-7460 or 1-
I 800-652-9026.
The Shakopee Fire Department Relief Association is the administrator of a single employer
I defined benefit pension plan established to provide benefits for paid on call members of the
I 5
I
Shakopee Fire Department. The Relief Association provides retirement benefits to members I
and benefits to survivors upon the death of eligible members. Benefit provisions are also
subject to enabling state statutes; therefore, any amendments to benefit provisions are I
reviewed by the Office of the State Auditor. Benefits are lump sum payments and the annual
City contribution to the Association is determined by State of Minnesota directed calculations.
Deficits are amortized over ten years as part of the city contribution. Annual actuarial studies I
are not done because the calculations to determine liability and city contributions are done by
following Minnesota State law.
The Relief Association issues a publicly available financial report that includes financial I
statements and required supplementary information for the Relief Association. The
Association's report may be obtained by writing to Shakopee Fire Department Relief I
Association, 129 Holmes St. S., Shakopee, MN 55379.
City employees are eligible to participate in COBRA provisions after severing employment or I
MN Chapter 488 after retirement, which allows employees to continue coverage on the City's
health insurance plan under certain provisions. Currently, the City has 6 former
employees/dependents participating under the MN Chapter 488 provision and 4 disabled at the
end of 2008. The participants pay for the premium under the above provisions. I
Awards and Acknowledgements
The Government Finance Officers Association of the United States and Canada (GFOA) I
awarded a Certificate of Achievement for Excellence in Financial Reporting to the City of
Shakopee for its Comprehensive Annual Financial Report (CAFR) for the fiscal year ended I
December 31, 2007. This was the twenty fourth consecutive year that the City has received
this award. In order to be awarded a Certificate of Achievement, a government must publish an
easily readable and efficiently organized CAFR. This report satisfied both GMP and I
Applicable legal requirements.
A Certificate of Achievement is valid for a period of one year only. We believe our current I
CAFR continues to meet the Certificate of Achievement Program's requirements and we are
submitting it to the GFOA to determine its eligibility for another certificate.
The preparation of this report would not have been possible without the efficient and dedicated I
services of the Finance Department and the entire city staff. We would like to express our
appreciation to all staff members who assisted and contributed to the preparation of this report.
Credit also must be given to the Mayor and Councilors for their unfailing support for maintaining I
the highest standards of professionalism in the management of the City of Shakopee's
finances.
I
Respectfully submitted,
~J]Jt~~ I
Mark McNeill I
City Administrator
I
6 I
I
I
I Certificate of
I Achievement
for Excellence
I in Financial
I Reporting
Presented to
I City of Shal(opee
I Minnesota
I For its Comprehensive Annual
Financial Report
I for the Fiscal Year Ended
December 31, 2007
I A Certificate of Achievement for Excellence in Financial
Reporting is presented by the Government Finance Officers
Association of the United States and Canada to
I government units and public employee retirement
systems whose comprehensive annual fmancial
reports (CAFRs) achieve the highest
I standards in government accounting
and financial reporting.
I ~ ./.-. H
I President
I ~,r?~
Executive Director
I
I
I 7
I
I
I
I
I
I
I
I
I
(THIS PAGE LEFT BLANK INTENTIONALLY) I
I
I
I
I
I
I
I
I
8 I
SECTION II
I KDV
I
I Expert advice. When you need it. SM
I INDEPENDENT AUDITOR'S REPORT
I
June 2, 2009
I
I Honorable Mayor and Members
of the City Council
City of Shakopee
I Shakopee, Minnesota
I We have audited the accompanying financial statements of the governmental activities, the
business-type activities, each major fund and the aggregate remaining fund information of the
City of Shakopee, Minnesota, as of and for the year ended December 31, 2008, which
collectively comprise the City's basic financial statements as listed in the Table of Contents.
I These financial statements are the responsibility of the City's management. Our responsibility is
to express opinions on these financial statements based on our audit. We did not audit the
Electric Fund and Water Fund financial statements of the Shakopee Public Utilities Commission,
I which represent 53% and 92%, respectively, of the assets and operating revenues of the
enterprise funds. Those financial statements were audited by other auditors whose report thereon
has been furnished to us, and our opinion expressed herein, insofar as it relates to the amounts
I included for the Shakopee Public Utilities Commission, is based solely upon the report of the
other auditors.
I We conducted our audit in accordance with U.S. generally accepted auditing standards and the
standards applicable to financial audits contained in Government Auditing Standards, issued by
the Comptroller General of the United States. Those standards require that we p1a,n and perform
the audit to obtain reasonable assurance about whether the financial statements are free of
I material misstatement. An audit includes examining, on a test basis, evidence supporting the
amounts and disclosures in the financial statements. An audit also includes assessing the
I accounting principles used and significant estimates made by management, as well as evaluating
the overall financial statement presentation. We believe our audit provides a reasonable basis for
our opmlOns.
I In our opinion, based on our audit and the report of other auditors, the financial statements
referred to above present fairly, in all material respects, the respective financial position of the
governmental activities, the business-type activities, each major fund and the aggregate
I remaining fund information of the City of Shakopee, Minnesota, as of December 31, 2008, and
the respective changes in financial position and cash flows, where applicable, thereof, and the
respective budgetary comparison for the General Fund for the year then ended in conformity with
I U.S. generally accepted accounting principles.
I 9
~DY I
I
I
In accordance with Government Auditing Standards, we have also issued our report dated
June 2, 2009, on our consideration ofthe City's internal control over financial reporting and on I
our tests of its compliance with certain provisions of laws, regulations, contracts and grant
agreements and other matters. The purpose of that report is to describe the scope of our testing
of internal control over financial reporting and the results of that testing and not to provide an I
opinion on the internal control over financial reporting or on compliance. That report is an
integral part of an audit performed in accordance with Government Auditing Standards and
important for assessing the results of our audit. I
As discussed in Note 14 to the financial statements, the City has implemented Governmental
Accounting Standards Board (GASB) Statement No. 45, Accounting and Financial Reporting by I
Employers for Post Employment Benefits Other than Pensions.
The Management's Discussion and Analysis and Schedule of Funding Progress, as listed in the
Table of Contents, are not a required part of the basic financial statements but are supplementary I
information required by U.S. generally accepted accounting principles. We have applied certain
limited procedures, which consisted principally of inquiries of management regarding the
methods of measurement and presentation of the required supplementary information. However, I
we did not audit the information and express no opinion on it.
Our audit was performed for the purpose of forming opinions on the financial statements that I
collectively comprise the City's basic financial statements. The information identified in the
Table of Contents as Combining and Individual Fund Financial Statements and Schedules are
presented for purposes of additional analysis and are not a required part of the basic financial I
statements. This information has been subjected to the auditing procedures applied in the audit
of the basic financial statements and, in our opinion, is fairly stated in all material respects in
relation to the basic financial statements taken as a whole.
The information identified in the Table of Contents as the Introductory and Statistical Sections I
are presented for purposes of additional analysis and are not a required part of the basic financial
statements of the City. This information has not been subjected to the audit procedures applied I
in the audit ofthe basic financial statements and, accordingly, we express no opinion on it.
J~l ])e().J-UA~, V~, W, I
KERN, DEWENTER, VIERE, LTD. I
Minneapolis, Minnesota
I
I
I
10 I
I
I CITY OF SHAKOPEE
Scott County, Minnesota
I MANAGEMENT'S DISCUSSION AND ANALYSIS
December 31, 2008
I As management of the City of Shako pee (the City), we offer readers of the City's financial
I' statements this narrative overview and analysis of the financial activities of the City for the fiscal
year ended December 31, 2008. We encourage readers to consider the information presented
here in conjunction with additional information that we have furnished in our Letter of
I Transmittal, which can be found on pages 3 to 6 of this report. All amounts, unless otherwise
indicated, are expressed in thousands of dollars.
I Financial Highlights
. The assets of the City exceeded its liabilities at the close of the most recent fiscal year by
$ 323 million (net assets). Of this amount, $ 71 million (unrestricted net assets) may be
I used to meet the City's ongoing obligations to citizens and creditors.
. The City's total net assets increased by $ 6 million.
. As of the close of the current fiscal year, the City's governmental funds reported
I combined ending fund balances of $ 28 million, an increase of $ 1.5 million in
comparison with the prior year. Approximately 69% of this total amount, $ 19 million is
available for spending at the City's discretion (unreserved fund balance).
I . At the end of the current fiscal year, unreserved fund balance for the General Fund was
$ 8.7 million or 54% of total General Fund expenditures.
. The City's total debt decreased by $ 1.8 million (3%) during the current fiscal year.
I Overview of the Financial Statements
This discussion and analysis are intended to serve as an introduction to the City's basic financial
I statements. The City's basic financial statements comprise three components: 1) government-
wide financial statements, 2) fund financial statements and 3) Notes to the Financial Statements.
This report also contains other supplementary information in addition to the basic financial
I statements themselves.
Government-Wide Financial Statements
I The government-wide financial statements are designed to provide readers with a broad
overview of the City's finances, in a manner similar to private-sector business.
I The Statement of Net Assets presents information on all of the City's assets and liabilities, with
the difference between the two reported as net assets. Over time, increases or decreases in net
assets may serve as a useful indicator of whether the financial position of the City is improving
I or deteriorating.
The Statement of Activities presents information showing how the City's net assets changed
I during the most recent fiscal year. All changes in net assets are reported as soon as the
underlying event giving rise to the change occurs, regardless of the timing of related cash flows.
Thus, revenues and expenses are reported in this statement for some items that will only result in
I cash flows in future fiscal periods (e.g., uncollected taxes and earned but unused employee
leaves).
I 11
I
CITY OF SHAKO PEE I
Scott County, Minnesota I
MANAGEMENT'S DISCUSSION AND ANALYSIS
December 31, 2008
I
Both of the government-wide financial statements distinguish functions of the City that are
principally supported by taxes and intergovernmental revenues (governmental activities) from I
other functions that are intended to recover all or a significant portion of their costs through user
fees and charges (business-type activities). The governmental activities of the City include
general government, public safety, highways and streets, economic development and recreation. I
The business-type activities of the City include an electrical distribution operation, water, sewer
and storm drainage utilities.
The government-wide financial statements include not only the City itself (known as the primary I
government), but also the Economic Development Authority (ED A) which functions like a
department of the City although it is a legally separate entity. The City Council is the EDA
Board. The Shakopee Public Utilities Commission (Electric and Water Funds) is mostly legally I
separate but functions as a department of the City. City Council appoints Commission Members
and therefore it has been included as an integral part of the primary government.
The government-wide financial statements can be found on pages 24 and 25 of this report. I
Fund Financial Statements
A fund is a grouping of related accounts that is used to maintain control over resources that have I
been segregated for specific activities or objectives. The City, like other state and local
governments, uses fund accounting to ensure and demonstrate compliance with finance-related I
legal requirements. All of the funds of the City can be divided into three categories:
governmental funds, proprietary funds and fiduciary funds.
Government Funds I
Government funds are used to account for essentially the same functions reported as
governmental activities in the government-wide financial statements. However, unlike the I
government-wide financial statements, governmental fund financial statements focus on near-
term inflows and outflows of spendable resources, as well as on balances of spendable resources
available at the end ofthe fiscal year. Such information may be useful in evaluating a City's I
near-term financing's requirements.
Because the focus of governmental funds is narrower than that of the government-wide financial
statements, it is useful to compare the information presented for governmental funds with similar I
information presented for governmental activities in the government-wide financial statements.
By doing so, readers may better understand the long-term impact of the City's near-term
financing decisions. Both the Governmental Funds Balance Sheet and the Governmental Funds I
Statement of Revenues, Expenditures and Changes in Fund Balances provide a reconciliation to
facilitate this comparison between governmental funds and governmental activities.
The City maintains 36 individual governmental funds. Information is presented separately in the I
Governmental Funds Balance Sheet and in the Governmental Funds Statement of Revenues,
Expenditures and Changes in Fund Balances for the General Fund. It is considered to be a major I
fund. Data from the other governmental funds are combined into a single, aggregated
presentation. Individual fund data for each of these non-major governmental funds is provided
in the form of combining statements elsewhere in this report.
12 I
I
I CITY OF SHAKO PEE
Scott County, Minnesota
I MANAGEMENT'S DISCUSSION AND ANALYSIS
December 31, 2008
I The City adopts an annual appropriated budget for its General Fund and four of its special
I revenue funds. A budgetary comparison statement has been prepared for those funds to
demonstrate compliance with the budget.
I The basic governmental funds financial statements can be found on pages 26 to 31 of this report.
Proprietary Funds
I The City maintains two different types of proprietary funds. Enterprise funds are used to report
the same functions presented as business-type activities in the government-wide financial
statements. The City uses enterprise funds to account for its electric, water, sewer and storm
I drainage operations. Internal service funds are an accounting device used to accumulate and
allocate costs internally among the City's various functions. The City uses internal service funds
to account for its fleet of vehicles and mobile equipment, its major buildings, the replacement of
I park assets, and for employee compensated absences and other post employment benefits. All of
these services predominantly benefit governmental rather than business-type functions.
'I Proprietary funds provide the same type of information as the government-wide financial
statements. The proprietary fund financial statements provide separate information for the
electric, water, sewer and storm drainage operations, all of which are considered to be major
funds of the City. Conversely, all internal service funds are combined into a single, aggregated
I presentation in the proprietary fund financial statements. Individual fund data for the internal
service funds is provided in the form of combining statements elsewhere in this report.
I The basic proprietary fund financial statements can be found on pages 32 to 35 of this report.
Fiduciary Funds
I Fiduciary funds are used to account for resources held for the benefit of parties outside the
government. Fiduciary funds are not reflected in the government-wide financial statement
I because the resources of those funds are not available to support the City's own programs.
The basic fiduciary fund financial statements can be found on page 36 of this report.
I Notes to the Financial Statements
The notes provide additional information that is essential to a full understanding of the data
I provided in the government-wide and fund financial statements. The Notes to the Financial
Statements can be found on pages 37 to 69 of this report.
I Other Information
In addition to the basic financial statements and accompanying notes, this report also presents
I certain required supplementary information concerning the City's progress in funding its
obligation to provide pension benefits to its employees.
I 13
I
CITY OF SHAKOPEE I
Scott County, Minnesota
MANAGEMENT'S DISCUSSION AND ANALYSIS I
December 31, 2008
The combining statements referred to earlier in connection with nonmajor governmental funds I
and internal service funds are presented immediately following the required supplementary I
information on pensions. Combining and individual fund statements and schedules can be found
on pages 74 to 94 of this report.
GOVERNMENT-WIDE FINANCIAL ANALYSIS I
As noted earlier, net assets may serve over time as a useful indicator of a City's financial
position. For the City, assets exceeded liabilities by $ 323 million at the close of the most recent I
fiscal year.
By far the largest portion of the City's net assets (71 %) reflects its investment in capital assets I
(e.g., land, buildings and equipment); less any related debt used to acquire those assets that is
still outstanding. The City used these capital assets to provide services to citizens; consequently,
these assets are not available for future spending. Although the City's investment in its capital I
assets is reported net of related debt, it should be noted that the resources needed to repay this
debt must be provided from other sources, since the capital assets themselves cannot be used to
liquidate these liabilities.
Net Assets I
Governmental Acvtivities Business-Type Activities Total I
2008 2007 2008 2007 2008 2007
Current and Other Assets $ 47,489 $ 45,624 $ 68,876 $ 65,631 $ 116,365 $ 111,255
Capital Assets 136,525 138,259 135,220 135,143 271,745 273,402 I
Total Assets $ 184,014 $ 183,883 $ 204,096 $ 200,774 $ 388,110 $ 384,657
Long-Term Liabilities I
Outstanding $ 21,912 $ 22,005 $ 31,622 $ 32,282 $ 53,534 $ 54,287
Other Liabilities 5,189 6,945 6,227 6,750 11,416 13,695
Total Liabilities $ 27,101 $ 28,950 $ 37,849 $ 39,032 $ 64,950 $ 67,982 I
NET ASSETS:
Invested in Capital Assets,
Net of Related Debt $ 112,910 $ 113,534 $ 115,124 $ 114,546 $ 228,034 $ 228,080 I
Restricted 21,916 13,081 1,756 1,026 23,672 14,107
Unrestricted 22,087 28,317 49,367 46,170 71,454 74,487
Total Net Assets $ 156,913 $ 154,932 $ 166,247 $ 161,742 $ 323,160 $ 316,674 I
An additional portion of the City's net assets (7%) represents resources that are subject to
external restrictions on how they may be used. The remaining balance of unrestricted net assets I
($ 71 million) may be used to meet the City's ongoing obligations to citizens and creditors.
At the end of the current fiscal year, the City was able to report positive balances in all three
categories of net assets, both for the government as a whole, as well as for its separate I
governmental and business-type activities. The same situation held true for the prior fiscal year.
14 I
I
I CITY OF SHAKOPEE
I Scott County; Minnesota
MANAGEMENT'S DISCUSSION AND ANALYSIS
December 31, 2008
,I
During the current fiscal year, the City's net assets increased by $ 6 million. 69% of this
I increase is due to enterprise fund activities reflecting the growth in the City.
Changes in Net Assets
I Governmental Acvtivities Business-Type Activities Total
2008 2007 2008 2007 2008 2007
REVENUES:
I Program Revenues:
Charges for Services $ 5,763 $ 5,936 $ 46,059 $ 45,244 $ 51,822 $ 51,180
Operating Grants and
I Contributions 1,660 1,944 - - 1,660 1,944
Capital Grants and
Contributions 1,825 2,463 1,007 4,139 2,832 6,602
General Revenues:
I Property Taxes 14,201 12,768 - - 14,201 12,768
Other Taxes 389 369 - - 389 369
Other 1,998 2,255 3,129 3,186 5,127 5,441
I Total Revenues 25,836 25,735 50,195 52,569 76,031 78,304
EXPENSES:
Gemeral Government 3,515 3,908 - - 3,515 3,908
I Public Safety 8,346 8,301 - - 8,346 8,301
Public Works 8,099 15,265 - - 8,099 15,265
Economic Development 522 - - - 522 -
Culture and Recreation 3,638 5,323 - - 3,638 5,323
I Interest on Long-Term Debt 1,034 1,042 - - 1,034 1,042
Electric - - 36,187 34,711 36,187 34,711
Water - - 3,461 3,332 3,461 3,332
I Sewer - - 3,309 2,939 3,309 2,939
Storm - - 1,435 1,352 1,435 1,352
Total Liabilities 25,154 33,839 44,392 42,334 69,546 76,173
I Increase (Decrease in Net
Assets before Transfers 682 (8,104) 5,803 10,235 6,485 2,131
I Transfers 1,298 1,111 (1,298) (1,111) - -
Change in Net Assets 1,980 (6,993) 4,505 9,124 6,485 2,131
"' NET ASSETS:
January 1 154,932 161,925 161,742 152,618 316,674 314,543
I December 31 $ 156,912 $ 154,932 $ 166,247 $ 161,742 $ 323,159 $ 316,674
I
I 15
r____
I
CITY OF SHAKOPEE I
Scott <;:ounty, Minnesota I
MANAGEMENT'S DISCUSSION AND ANALYSIS
December 3 L, 2008
I
Governmental Activities
Governmental activities increased the City's net assets by $ 2 million. I
Expenses and Program Revenues - Governmental Activities I
9.000.000 --- --l
8.000.000 I
7.000.000 i
i
6.000.000 I I
5.000.000 I CI PrOI~~r,)m Fe'''enues
4.000.000 I .E..pense-:. I
3.000.000 I
:2.000.000 I
'\ .000.000 I I
I
-
>. Vl ~ r- C r-
C V ..;r: c 0 o E
- v u v
ro r- - 0 .- r- 'Z ~v~ I
~ c ro 3 ~ ::: ro Vlf-..!::
v c (f) (5 Q... ~ !l> Ol v
c OJ U r- 0 iVco
u o"iV u
v > ..!:: V ~ 0
l') 0 ..0 :::; U > a:: c-.J I
l') :::; 0... W <V
CL 0 I
Rcvcnues by Source - Governmental Activities I
(ipHatin~1 I
':tiar'J>?S iN '~'th8r Ro:?\'8nue'~ Grant<;. and
::.:"l~r\""11:8':. ,= ontnbutll)ns
12q{\ 6% I
( apttall:'rant.; I
l)tllH T 8X 2S and
:2t~lo ee, ntri tluti (,n':.
71}o
,
Property Tax 25 I
:,:,'Vo
For the most part, increases in expenses closely paralleled inflation and growth in the demand for I
serVIces.
16 I
I
I
CITY OF SHAKOPEE
I Scott County, Minnesota
MANAGEMENT'S DlSCUSSlON AND ANAL YSrS
I December 31, 2008
I Business- Type Activities
I
Business-type activities increased the City's net assets by $ 4.5 million, accounting for 69% of
the total growth in the City's net assets. Key elements of this increase are as follows:
I I . Capital grants and contribution by developers - $ 1,007.
. Charges for utility service - $ 46,059.
I Expenses and Program Revcnucs - Business-Type Activities
I $45.000.000 -
$40.000.000
I $35.000.000
$30.000.000
I $25.000.000
520.000.000
$15.000.000
I $10.000.000
55.000.000
I $-
Electric Water Se'Ner Storm
I Revenues by Source - Business-Type Activities
I
I r:::.:1pital ':rants
and
'=:(tntnbutl(,ns
I 2~/o
':::l'I:~ rl~l-? '3 f,)r
:~I8'r\ll('es
In';8'3trnent 9 .2'~/o
I Earnlrl9s
fO'-
J /lj
I
I ]7
I
CITY OF SHAKOPEE ,I
Scott County, Minnesota I:
MANAGEMENT'S DISCUSSION AND ANALYSIS
December 31,2008
I
FINANCIAL ANALYSIS OF THE CITY'S FUNDS
As noted earlier, the City uses fund accounting to ensure and demonstrate compliance with I
finance-related legal requirements.
Governmental Funds I
The focus of the City's governmental funds is to provide information on near-term inflows,
outflows and balances of spendable resources. Such information is useful in assessing the City's I
financing requirements. In particular, unreserved fund balance may serve as a useful measure of
a City's net resources available for spending at the end of the fiscal year.
As of the end of the current fiscal year, the City's governmental funds reported combined ending I
fund balances of $ 28,256, an increase of $ 1,600 in comparison with the prior year.
Approximately 69% ($ 19,517) of the total amount of $ 28,256 constitutes unreserved fund I
balance, which is available for spending at the City's discretion. The remainder of fund balance
($ 8,739) is reserved to indicate that it is not available for new spending because it has already
been committed to restricted purposes. The Park Reserve Fund showed an increase of $ 174 but
has a negative fund balance of $ 1,609. 'I
The General Fund is the chief operating fund of the City. At the end of the current fiscal year,
fund balance of the General Fund was $ 9,860. As a measure ofthe General Fund's liquidity, it I
may be useful to compare fund balance (unreserved) to total fund expenditures. Fund balance
represents 54% of total General Fund expenditures.
Fund balance of the City's General Fund increased by $ 152 during the current fiscal year. This I
was in part due to conservative budgeting. Key factors in this change are as follows:
. Revenues exceeded the budget by $ 243. I
. Under-spending the budget by $ 955 or 6%.
Proprietary funds ,I
The City's proprietary funds provide the same type of information found in the government-wide
financial statements, but in more detail.
Unrestricted net assets ofthe enterprise funds: I
Electric Water Sewer Storm
Beginning of Year $ 15,617 $ 1,386 $ 14,926 $ 14,240 I
Change During Year 745 695 485 1,272
I
End of Year $ 16,362 $ 2,081 $ 15,411 $ 15,512
I
18 I
I
I CITY OF SHAKOPEE
I Scott County, Minnesota
MANAGEMENT'S DISCUSSION AND ANALYSIS
December 31,2008
I
GENERAL FUND BUDGETARY HIGHLIGHTS
I The difference between the original General Fund budget and the final amended budget for
expenditures was not significant for the current year. The original legally adopted budget for
I expenditures was $ 17,049 and transfers out were $ 1,171. Final budget was $ 17,244 and
transfers out were $ 1,424. Original adopted budget for revenues was $ 15,588 and the final
amended was $ 15,635.
I: CAPITAL ASSET AND DEBT ADMINISTRATION
Capital Assets
I The City's investment in capital assets for its governmental and business type activities as of
December 31, 2008, amounts to $ 228,034 (net of accumulated depreciation and related debt).
I This investment in capital assets includes land, buildings and systems, improvement, machinery
and equipment, park facilities, roads, highways and bridges. The City's capital assets for the
current fiscal year were virtually unchanged from the previous year.
I Major capital assets events during the current fiscal year included the following:
. A variety of street construction projects were completed with a value of $ 1,899.
I . Buildings added $ 885.
. Equipment added $ 1,788.
. Change in net utility assets for electric $ 1,484, water $ (968), sewer $ 125 and storm
I $ (566).
Capital Assets
I (Net of Depreciation)
_,.J
Governmental Activities Business-Type Activities Total
I 2008 2007 2008 2007 2008 2007
Land $ 19,272 $ 19,272 $ 9,128 $ 6,088 $ 28,400 $ 25,360
I Construction in Progress - 188 1 1,207 1 1,395
Buildings and System:
Improvements Other than Buildings 26,668 26,674 124,611 126,885 151,279 153,559
I Infrastructure 82,432 84,683 - - 82,432 84,683
Machinery and Equipment 8,153 7,443 1,480 963 9,633 8,406
Total $ 136,525 $ 138,260 $ 135,220 $ 135,143 $ 271,745 $ 273,403
,I Additional information on the City's capital assets can be found in Note 5 on pages 54 to 56 of
I this report.
I 19
I
CITY OF SHAKO PEE I
Scott County, Minnesota
MANAGEMENT'S DISCUSSION AND ANALYSIS I
December 31, 2008
Long-Term Debt 'I
At the end of the current fiscal year, the City had total bonded debt outstanding of $ 56,840. Of I
this amount, $ 7,165 comprises debt backed by the full faith and credit of the government and
$ 16,450 is special assessment debt for which the government is liable in the event of default by
the property owners subject to the assessment. The remainder of the City's debt represented I
bonds secured solely of specified revenue sources (i.e., revenue bonds).
Outstanding Debt I
G.O. and Revenue Bonds
Governmental Activities Business-Type Activities Total I
2008 2007 2008 2007 2008 2007
G.O, Bonds $ 7,165 $ 7,560 $ - $ - $ 7,165 $ 7,560 I
Special Assessment Debt
with Governmental Commitment 16,450 17,165 - - 16,450 17,165
Revenue Bonds - - 33,225 33,895 33,225 33,895 'I
Total $ 23,615 $ 24,725 $ 33,225 $ 33,895 $ 56,840 $ 58,620
The City's total bonded debt decreased by $ 1,780 during the current fiscal year. I
Minnesota Statutes limit the amount of general obligation debt a government entity may issue to I
a net figure of 3 % of the taxable market value. The current debt limitation for the City is $ 114
million, which is significantly in excess of the City's outstanding general obligation debt.
Additional information on the City's long-term debt can be found in Note 6 on pages 56 to 59 of I
this report.
ECONOMIC FACTORS AND NEXTYEAR'S BUDGETS AND RATES 'I
The unemployment rate for the City was 6.7% at year-end. This is an increase from a rate of r
4.6% a year ago. The state's average unemployment rate was 6.8% and the national average rate
was 7.1 %.
Inflationary trends in the region compare favorably to national indices. ,
I
I
20 I
I
I CITY OF SHAKOPEE
Scott County, Minnesota
I MANAGEMENT'S DISCUSSION AND ANALYSIS
December 31, 2008
I During the current fiscal year, unreserved fund balance in the General Fund increased from
I $ 7,897 to $ 8,734. The City has appropriated $ 107 of this amount for spending in the 2009
fiscal year. General Fund revenues from development activities such as permits, engineering
fees and platting were $ 932, which is 5.8% of total revenues. For 2007, the amounts were
$ 1,449, or 9%.
I Building permits have been a significant source of revenue in recent years. The downturn in that
sector ofthe economy and a reduction in the fees charged for permits had a significant impact on
I the General Fund for 2008 and 2007. The City has reserved part of the fund balance for building
inspection related activities. The slower housing market is expected to continue through 2009
and into 2011.
I The tax levy for 2008/09 increased from $ 14,222 to $ 14,984, an increase of 5.4%. The tax rate
increased from 31.925 to 32.630, a 2.2% increase. The General Fund budget for 2009
I expenditures as originally adopted was $ 17,355 compared to $ 17,049 for 2008 and $ 16,545 for
2007.
In 2008, there were zero lots/units in 2 final plats made available for building. The respective
I numbers for the prior year were 16 and 3.
Utility rates for the enterprise funds were slightly increased from 2008.
I REQUESTS FOR INFORMATION
I This financial report is designed to provide a general view of the City's finances for all those
with an interest in the City's finances. Questions concerning any of the information provided in
this report or requests for additional information should be addressed to the Finance Director,
I 129 Holmes St. S., Shakopee, MN, 55379.
I
I
I
I
I
I 21
I
I
I
I
I
I
I
I
I
(THIS PAGE LEFT BLANK INTENTIONALLY.) I
I
I
I
I
I
I
I
I
22 I
I
I
I
I
I
I
I
I
I
I BASIC FINANCIAL STATEMENTS
I
I
I
I
I
I
I
I
I 23
I
CITY OF SHAKOPEE I
Scott County, Minnesota
STATEMENT OF NET ASSETS
December 31, 2008 I
Governmental Business-Type
Activities Activities Total I
ASSETS:
Cash and Investments $ 38,587,702 $ 46,098,069 $ 84,685,771
Restricted Accounts - 13,691,747 13,691,747
Receivables: I
Property Tax Receivable 483,317 - 483,317
Accounts Receivable (Net of Allowance for
Uncollectible Accounts) 647,584 3,847,595 4,495,179
Interest Receivable 274,126 554,772 828,898 I
Notes Receivable 774,825 - 774,825
Special Assessments Receivable 8,276,269 241,985 8,518,254
Due from Other Funds (Internal Balances) (18,783) 18,783 -
Advances to Other Funds (Internal Balances) (1,650,000) 1,650,000 - I
Inventories - 760,642 760,642
Prepaid Expenses 114,478 84,697 199,175
Unamortized Debt Issue Costs - 929,589 929,589
Electric Plant Acquisition (Net of Accumulated Amortization) - 998,073 998,073 I
Capital Assets not being Depreciated:
Land 19,271,560 9,127,782 28,399,342
Construction in Progress - 741 741
Capital Assets being Depreciated: I
Infrastructure 126,443,387 - 126,443,387
Plant in Service - 159,819,230 159,819,230
Buildings 33,501,391 - 33,501,391
Machinery and Equipment 13,154,586 2,309,699 15,464,285 I
Less Accumulated Depreciation (55,846,131 ) (36,037,626) (91,883,757)
Total Assets $ 184,014,311 $ 204,095,778 $ 388, II 0,089
LIABILITIES AND NET ASSETS: I
Liabilities:
Accounts Payable $ 803,552 $ 3,907,134 $ 4,710,686
Contracts Payable 71,954 - 71,954
Due to Other Governments 165,593 - 165,593 I
Salaries and Benefits Payable 402,671 - 402,671 .
Deposits Payable - 947,133 947,133
Interest Payable 375,113 620,283 995,396 I
Unearned Revenue - 12,237 12,237
Bond Principal Payable:
Payable Within One Year 2,660,000 710,000 3,370,000
Payable After One Year 20,955,000 31,593,863 52,548,863
Compensated Absences Payable: I
Payable Within One Year 710,577 29,423 740,000
Payable After One Year 724,189 21,117 745,306
Net OPEB Obligation:
Payable After One Year 233,153 7,400 240,553 I
Total Liabilities 27,101,802 37,848,590 64,950,392
Net Assets:
Invested in Capital Assets, Net of Related Debt 112,909,793 115,124,238 228,034,031 I
Restricted for:
Economic Development 748,343 748,343
Transit 1,875,058 - 1,875,058
Forfeiture 117,650 117,650 I
Debt Service 14,846,737 1,756,369 16,603,106
Capital Projects 4,328,157 - 4,328,157
Unrestricted 22,086,771 49,366,581 71,453,352
Total Net Assets 156,912,509 166,247,188 323,159,697 I
Total Liabilities and Net Assets $ 184,014,311 $ 204,095,778 $ 388,110,089
The Notes to the Financial Statements are an integral part of this statement. 24 I
I
,,-...,.-.....-......-...-....-...-.... ,-...,-... .-...
\0 0 t- -.:t C"l 0'\ 0'\ ("f) 0 - I/) t- C"l C"l I/) \0 C"l ' t- I/) C"l t-
t--.:tt-C"lC"l0'\1/) C"l0'\~1/)t- ~ C"lC"lt-1/) O'\-~ 0'\
I C"l-.:t 0'\ \00'\0'\ C"l t-C"l~1/)1/) t- ~O'\O-.:t C"ll/)- \0
~ ~~~o~m~ ~~~~~ 0 o~o~ ~~~ ~
~ 0t--.:t0'\1/)C"l0 C"lC"lC"lI/)t- C"l O~t-I/) -~t- I/)
o O'\-.:t-.:t-.:tl/)OO'\ \O~t-~\O C"l C"l("f)0 t--.:t\O-
E-< N~m~~~~ N ~ N m ~ ~ ~~~ m
~~~ ~~~ ~ ~ ~ ~ N
I '" 10'7"""- ~ ("f) ~
"'Q)
o en
::l '"
5 ~ ^' ,-.. ,-.. ,-..
>~ i:t IIIIIII MOl""""'llr)1" t"-- 11J-"lIOO("f')OOO 00
00 ~ C"l0'\~1/)t- t- -.:t OOI/)("f)1/) ~
I ~z E-<~ ~~~~~ ~ ~ ~~~~ ~
,~ OO-O'\I/)-.:t -.:t 00 t-Ol/)- t-
~ .5 ~ .;; C"l C"l C"l I/) t- t- C"l 0'\ C"l 0 -.:t -.:t
~ Vl <l) .',;:1 \0" 00 t:., '-' \O~ \0", ~ N 00 1I1 l'-" C'i.
(\) ~ .5 0 C"l C"l C"l C"l - - -.:t - \0
~~ :g~ ~ ~ ~
I ~e ~ 10'7 10'7
0'0
Z ~ ,-....,-...",-...,-..,..-...-.....-.. ..-..
~ \Oot--.:tC"lO'\O'\ " I " 0'\ ("f)1/)1/)C"loo-.:tl/)-.:t 0'\
~ t--.:tt-("f)("f)0'\1/) I/) C"l("f)("f)I/)~-.:tooC"l 0
5~ ~~~~~~~ ~ ~~~~~~~~ ~
I c~ -.:t~1/)0-C"l1/) I/) O~-\Ot-I/)OC"l C"l
!3';; 0 t- -.:t 0'\ I/) C"l 0 0 0 00 -.:t I/) 0'\ ~ ~ ("f) -
~~ ~~~~~q~ ~ ~C"l~ ~~~~ ~
00 C"l\o("f) __I/) I/) ~ - _t-_~ \0
6< ~~~ ~~c c ~ ~ ~ ~
010'710'7
I .l!l ~ 'OC"l'C"l'-.:t ~C"lO'\'O'\ C"l
~.9 ~ ~ &l ~ $ ;:!i!;;:;:; ~
I O'O~ ~~ ~ ~ NNN ~ N
_I::~ -.:t \0 C"l 000C"l 0 ("f)
~ .is.'c 0 t- 00 0'\ 0 00
~ .- 1:: ,...; _ - C"ln
<:I) 0.. 0
~~ · U 10'7 10'7
....,.... U
. ~rI')
I ~ 'i:: ........ en
J;;1il - Q,l (\)
t:l-.~ 2:.c ::l '" ~~O'\OO'_ "'" -
0= ~e 50J)"Os C"l00C"l-.:t0 0'\ 0'\
...... = U Q,l > I:: 1::._ O'\n -.:t, ~ -.:tn On -n -n
~- <0 o~.~ C"lC"l0-- 0 0
<~ ~ ~ ~.l!l.E 1()1/)C"lC"l \0 \0 ~
I = ~ roo.... Fl 0 I:: .;::: ("f) ~ \On \0, ~
rn.e- 0 '0. @ 0.. ~ 1:: - - - '"
roo. = ~~ 50000 ~
06 z= 0 U 10'7 10'7 ~
>oU ~J;;1il ~ ~ "0
I Eo-< t:: ~; .5 1a
U 8 E!~ ... 0'\0\0' C"l 't- -0'\0'\-0 t- Fl ~
rn ~r 0 I()~t- t- 00 00 0'\C"l ("f) - a ~
<Q,l ~~ C"l\OC"l t- 0'\ t-C"l C"l 00_ - ~ a ~
~.l:l '" 0 ~~-.:tn ~ C"ln C"lnO~~~ C"ln ~ 0 I::
rn ... 0.- 0 0 I() 0'\ \0 ("f) 0'\ I/) t- I/) C"l I:: > (\)
~ e!l;:: \OI/)("f) C"l t- t-C"l I/) ("f)0 00 ~Q) B S
I roo. ~ r~ ,...; N _n I/)n ~ C"ln N ,...; \On,...; .t::J '" ..... ~
..... ", .C"l -.:t I/) en '" ..... OJ) .is
u 10'7 10'7 o~ E!",I:: '"
'" en i:: '+-< 0 Q) '8 OJ) en
en 0 1:: .=l 0 I:: '" I:: I:: .-
o ~ (\)"0 0 r~ "'.- .- ;S
::lE-<ao~ \"I~~ -g '+-<
I C"l~~~t-O'\- \O-O'\\OC"l C"l I:: otl<:l) ~~~ ~ 0
'" t- 0 00 t- C"l 0'\ \0 t- \0 I/) t- t- C"l ~ i>:> b 'C I:: ~o Zo, , t::
o 1/)-C"lOI/)O'\\O \OC"lt-C"lO t- Ot::I::~O en en t'l
~ ~n \0' ~ C"ln ~ C"ln C"\ ..0 _n ~ ~ N ~ ~ g,...... ~ I:: '" E-< .5 Q) Q) p.
(\) - -.:t 0'\ C"l C"l ("f) I() 00 \0 0 C"l 0'\ -.:t _ 0 X ... .- ... -
0.. ~ ~ On I/) \On On - --:. -.:t, "l -.:t, ~ Vi, ~... <11 ~ r~ ~ ~Il ~ ~ ~
X C"l~00 C"l-I/) \OC"lC"l-~ 0'\ (\)~E-<"",v;g i::~ ~ ~Il
I ~ C"l ("f) -.:t \0 I:: ..~ ~ ~
o ...,.r.:o (\) i::
10'7 10'7 0 E-< U Z Z .-
i::
t'l
(\)
...
I ~
Vl ~ ~
~ .~ o.;:j Q.)
._ ~ "0 ._ S
.~ 0> a.;:: ~
._ 0;: _ '0 ,fS
I ",:ctl ~ .iS~ (/)
a (\)~ I::(\) ~
<11 ~ Cl - 0 S 0.. .-
50 I::l::g.iS ~ sC g
o 00. I:: .. r .
... .. ~ S .- 0 '" E-< 0 J, I::
e: ~ 5 p. t<i ~ S.~ J, > '" .-
I ",.- co(\) c- c ~ '" 0 0 IJ;..
i::.t:: ~ - b ~ 1:<';; g 0 .5 0
o > (\) 0._ 0 ._ '"
~~5 en~~S~ tl ~:g]::l ;S
g ~ ~ ~ ~ Cl '0 .... 0 ~ .5 P=l 0 co .9
::l_r~~Ool::l::..... (\) t'l_ E-< '"
~ cd v t'l :> .... ~ 0 III 0. ... . (\)
I 1::~<:I)~So-o CO 00 b
~ 0 0 0 ~ ~ ~.- ~ ~
~(\)~~i::::l~E-< ,.':l(\)O~E-< Z
~I::.o~o';::(\) "'o~;:::t:: (\)
S~::l::lo::l1:: ~~~0.9 ~
ov~~~U...... I::~~(/)<:I) E-<
> .~
o ::l
I 0 P=l 25
I
CITY OF SHAKOPEE I
Scott County, Minnesota
BALANCE SHEET-GOVERNMENTAL FUNDS I
December 31, 2008
Other Total I
Governmental Governmental
General Fund Funds Funds I
ASSETS:
Cash and Investments $ 10,098,475 $ 20,064,559 $ 30,163,034
Taxes Receivable - Delinquent 473,314 10,003 483,317 I
Special Assessments Receivable:
Delinquent 6,792 15,149 21,941
Deferred 28,495 8,225,833 8,254,328 I
Accounts Receivable 406,203 241,381 647,584
Interest Receivable 55,231 152,314 207,545
Due from Other Funds 71,293 - 71,293 I
Notes Receivable - 214,825 214,825
Prepaid Items 114,478 - 114,478
Total Assets $ 11,254,281 $ 28,924,064 $ 40,178,345 I
LIABILITIES AND FUND BALANCES: I
Liabilities:
Accounts Payable $ 428,331 $ 354,630 $ 782,961
Contracts Payable - 71,954 71,954 I
Due to Other Funds 55,076 35,000 90,076
Advances from Other Funds - 1,650,000 1,650,000
Due to Other Governments - 165,593 165,593 I
Salaries and Benefits Payable 402,671 - 402,671
Deferred Revenue 508,601 8,250,985 8,759,586
Total Liabilities 1,394,679 10,528,162 11,922,841 I
Fund Balances:
Reserved for: I
Special Revenue - 2,738,909 2,738,909
Capital Projects - 4,873,440 4,873,440
Prepaid Items 114,478 - 114,478 I
Building Permits and Activities 1,011,596 - 1,011,596
Unreserved, Reported in: I
General Fund - Undesignated 8,733,528 - 8,733,528
Special Revenue - Undesignated - 1,130,452 1,130,452
Debt Service - Undesignated - 7,658,289 7,658,289
Capital Projects - Undesignated - 1,994,812 1,994,812 I
Total Fund Balances 9,859,602 18,395,902 28,255,504
Total Liabilities and Fund Balances $ 11,254,281 $ 28,924,064 $ 40,178,345 I
The Notes to the Financial Statements are an integral part of this statement. 26
I
I
I CITY OF SHAKOPEE
Scott County, Minnesota
I RECONCILIATION OF THE BALANCE SHEET TO
THE STATEMENT OF NET ASSETS - GOVERNMENTAL FUNDS
I December 31, 2008
I Total Fund Balances - Governmental Funds $ 28,255,504
Amounts reported for governmental activities in the Statement of Net Assets
I are different because:
Capital assets used in governmental activities are not current financial
I resources and, therefore, are not repqrted as assets in governmental funds.
Cost of Capital Assets 144,763,415
Less Accumulated Depreciation (44,676,933)
I Long-term liabilities, including bonds payable, are not due and payable in
the current period and, therefore, are not reported as liabilities in the funds.
I Long-term liabilities at year-end consist of:
Bond Principal Payable (23,615,000)
I . Delinquent property taxes and assessments receivable will be collected this
year, but are not available soon enough to pay for the current period's
I expenditures and, therefore, are deferred in the funds.
Property Taxes 483,317
Special Assessments 21,941
I Deferred special assessments receivable are not available to pay for current
expenditures and, therefore, are deferred in the funds.
I Deferred Special Assessments 8,254,328
Governmental funds do not report a liability for accrued interest
I due and payable. (375,113)
Internal service funds are used by management to charge the costs of
I equipment, buildings, park assets and employee benefits to individual funds.
A portion of the assets and liabilities of those funds are included in
governmental activities in the Statement of Net Assets. 43,801,050
I Total Net Assets - Governmental Activities $ 156,912,509
I
I
I The Notes to the Financial Statements are an integral part of this statement. 27
I
CITY OF SHAKOPEE I
Scott County, Minnesota
STATEMENT OF REVENUES, EXPENDITURES AND I
CHANGES IN FUND BALANCES - GOVERNMENTAL FUNDS
For the Year Ended December 31,2008
Other Total I
Governmental Governmental I
General Fund Funds Funds
REVENUES:
Property Taxes $ 12,871,292 $ 1,177,539 $ 14,048,831 I
Tax Increments - 388,935 388,935
Special Assessments 9,950 1,870,024 1,879,974
Licenses and Permits 691,415 530,524 1,221,939
Intergovernmental 361,412 2,341,581 2,702,993 I
Charges for Services 1,093,250 1,116,019 2,209,269
Fines and Forfeitures 366,618 76,008 442,626
Miscellaneous 484,110 1,544,419 2,028,529 I
Total Revenues 15,878,047 9,045,049 24,923,096
EXPENDITURES: I
Current:
General Government 3,298,455 219,502 3,517,957
Public Safety 8,413,890 48,398 8,462,288 I
Public Works 2,573,687 1,055,267 3,628,954
Culture and Recreation 1,811,976 2,289,199 4,101,175
Economic Development 67,661 454,413 522,074 I
Debt Service:
Principal - 3,280,000 3,280,000
Interest and Other Charges - 1,077,711 1,077,711 I
Capital Outlay 123,353 3,177,589 3,300,942
Total Expenditures 16,289,022 11,602,079 27,891,101
Excess of Revenues I
Under Expenditures (410,975) (2,557,030) (2,968,005)
OTHER FINANCING SOURCES (USES): I
Bonds Issued - 2,170,000 2,170,000
Premium on Bonds Issued - 16,741 16,741 I
Transfers In 1,990,522 2,615,171 4,605,693
Transfers Out (1,427,478) (797,214) (2,224,692)
Total Other Financing Sources (Uses) 563,044 4,004,698 4,567,742 I
Net Change in Fund Balances 152,069 1,447,668 1,599,737
FUND BALANCES: I
Beginning of Year 9,707,533 16,948,234 26,655,767
End of Year $ 9,859,602 $ 18,395,902 $ 28,255,504 I
The Notes to the Financial Statements are an integral part of this statement. 28
I
I
I CITY OF SHAKO PEE
Scott County, Minnesota
I RECONCILIATION OF THE STATEMENT OF REVENUES,
EXPENDITURES AND CHANGES IN FUND BALANCES TO
THE STATEMENT OF ACTIVITIES - GOVERNMENTAL FUNDS
I For the Year Ended December 31, 2008
I Net Change in Fund Balances - Governmental Funds $ 1,599,737
Amounts reported for governmental activities in the Statement of Activities are
I different because:
Capital outlays are reported in governmental funds as expenditures. However,
I in the Statement of Activities, the cost of those assets is allocated over
the estimated useful lives as depreciation expense.
Capital Outlays 1,818,728
I Depreciation Expense (4,224,836)
Loss on Disposal of Fixed Assets (11,158)
Transfer of Assets to Internal Service Funds (7,106,042)
I Principal payments on long-term debt are recognized as expenditures in the
governmental funds but as an increase in the net assets in the Statement of Activities. 3,280,000
I
Interest on long-term debt in the Statement of Activities differs from the amount
I reported in the governmental funds because interest is recognized as an expenditure
in the funds when it is due and thus requires use of current financial resources.
In the Statement of Activities, however, interest expense is recognized as
I the interest accrues, regardless of when it is due. 43,712
Proceeds from long-term debt are recognized as an other financing source in the
I governmental funds but as a decrease in net assets in the Statement of Activities.
Bonds Payable (2,170,000)
I Certain revenues in the Statement of Activities that do not provide current financial
resources are not reported as revenues in the funds.
Special Assessments (69,592)
I Delinquent and deferred receivables will be collected this year, but are not
available soon enough to pay for the current period's expenditures and,
I therefore, are not revenues in the funds. 152,002
Internal service funds are used by management to charge the costs of certain
I activities such as buildings, equipment, park assets and employee benefits
to individual funds. This amount represents the change in net assets of the internal
service funds, which all is reported with governmental activities. 8,667,634
I Change in Net Assets - Governmental Activities $ 1,980,185
I The Notes to the Financial Statements are an integral part of this statement. 29
I
CITY OF SHAKOPEE I
Scott County, Minnesota
STATEMENT OF REVENUES~ EXPENDITURES AND I
CHANGES IN FUND BALANCES -
BUDGET AND ACTUAL-GENERALFUND
For the Year Ended December 31, 2008
I
Variance with
Budgeted Amounts Actual Final Budget - I
Original Final Amounts Over (Under)
REVENUES:
Property Taxes:
General Property Taxes $ 11,624,210 $ 11,624,210 $ 11,552,626 $ (71,584) I
Fiscal Disparities 1,137,200 1,137,200 1,119,749 (17,451)
Lodging Tax 210,000 210,000 193,797 (16,203)
Aggregate Tax 8,000 8,000 5,120 (2,880) I
Total Property Taxes 12,979,410 12,979,410 12,871,292 (108,118)
Special Assessments 2,000 2,000 9,950 7,950
I
Licenses and Permits 820,000 820,000 691,415 (128,585)
Intergovernmental Revenues: I
Federal Grants 5,000 5,000 21,014 16,014
PERA Aid 19,000 19,000 (541) (19,541)
Police Aid 228,000 228,000 308,226 80,226
Other Grants and Aids 92,000 92,000 32,713 (59,287) I
Total Intergovernmental Revenues 344,000 344,000 361,412 17,412
Charges for Services: I
General Government 99,250 99,250 104,663 5,413
Public Safety 280,000 322,000 530,444 208,444
Public Works 228,400 228,400 458,143 229,743 I
Total Charges for Services 607,650 649,650 1,093,250 443,600
Fines and Forfeitures 430,000 430,000 366,618 (63,382)
Miscellaneous Revenues: I
Investment Income 350,000 350,000 434,413 84,413
Rents - 5,000 - (5,000) I
Other 55,000 55,000 49,697 (5,303)
Total Miscellaneous Revenues 405,000 410,000 484,110 74,110
Total Revenues 15,588,060 15,635,060 15,878,047 242,987
EXPENDITURES: I
General Government:
Mayor and Council 177,190 177,390 124,869 (52,521) I
Administration 516,670 519,120 497,429 (21,691)
City Clerk 364,540 366,440 317,846 (48,594)
Finance 770,090 772,100 744,004 (28,096)
Legal 533,500 533,500 557,547 24,047 I
Planning 546,670 549,150 517,772 (31,378)
Government Buildings 296,470 309,030 269,188 (39,842)
Information Technology 312,020 313,120 294,800 (18,320) I
Total General Government 3,517,150 3,539,850 3,323,455 (216,395)
The Notes to the Financial Statements are an integral part of this statement. 30 I
I
I CITY OF SHAKOPEE
Scott County, Minnesota
I STATEMENT OF REVENUES, EXPENDITURES AND
CHANGES IN FUND BALANCES -
BUDGET AND ACTUAL - GENERAL FUND
For the Year Ended December 31, 2008
I Variance with
I Budgeted Amounts Actual Final Budget-
Original Final Amounts Over (Under)
EXPENDITURES:
Public Safety:
I Police $ 5,851,840 $ 5,920,620 $ 5,808,744 $ (111,876)
Fire 1,925,730 1,933,710 1,857,482 (76,228)
Building Inspection 820,540 823,690 786,715 (36,975)
I Total Public Safety 8,598,110 8,678,020 8,452,941 (225,079)
Public Works:
Streets and Highways:
I Engineering 786,220 790,090 645,788 (144,302)
Streets 1,890,310 1,973,070 1,793,946 (179,124)
Shop 94,380 95,990 141,634 45,644
I Total Public Works 2,770,910 2,859,150 2,581,368 (277,782)
Park and Recreation:
Park Maintenance 1,557,550 1,579,820 1,479,316 (100,504)
I Natural Resources 127,660 128,030 100,501 (27,529)
Library/Congregate Dining 297,080 302,350 283,780 (18,570)
Total Park and Recreation 1,982,290 2,010,200 1,863,597 (146,603)
I Miscellaneous 181,000 157,240 67,661 (89,579)
Total Expenditures 17,049,460 17,244,460 16,289,022 (955,438)
I Excess of Revenues Over
(Under) Expenditures (1,461,400) (1,609,400) (410,975) 1,198,425
I OTHER FINANCING SOURCES (USES):
Transfers In 1,740,000 1,817,230 1,990,522 173,292
Transfers Out (1,171,010) (1,424,125) (1,427,478) (3,353)
I Total Other Financing Sources (Uses) 568,990 393,105 563,044 169,939
Net Change in Fund Balances $ (892,410) $ (1,216,295) 152,069 $ 1,368,364
I FUND BALANCES:
Beginning of Year 9,707,533
I End of Year $ 9,859,602
I
I
The Notes to the Financial Statements are an integral part ofthis statement. 31
I
I
CITY OF SHAKOPEE I
Scott County, Minnesota
STATEMENT OF NET ASSETS - PROPRIETARY FUNDS
December 31,2008 I
Business-Type Activities - Enterprise Funds
Governmental
Activities - I
Storm Internal Service
Electric Water Sewer Drainage Total Funds
ASSETS:
Current Assets: I
Cash and Cash Equivalents $ 8,429,308 $ 1,261,202 $ 1,462,629 $ 1,701,2[5 $ 12,854,354 $ 1,761,233
Investments 5,989,566 2,135,790 [ 1,612,089 13,506,270 33,243,715 6,663,435
Restricted Accounts 11,176,003 82,466 - - 11,258,469 -
Accounts Receivable 2,991,513 258,305 440,122 227,030 3,916,970 -
Allowance for Uncollectible Accounts (61,852) (7,523) - - (69,375) - I
Interest Receivable 285,475 31,254 103,484 121,908 542,121 66,581
Special Assessment Receivable, Current - - 30,593 - 30,593 -
Notes Receivable, Current - - - - - 115,000
Due from Other Funds 1,053,726 63,236 - - 1,116,962 - I
Advances to Other Funds, Current - - 375,000 - 375,000 -
Inventories 729,441 31,201 - - 760,642 -
Prepaid Expenses 63,523 21,174 - - 84,697 -
Total Current Assets 30,656,703 3,877,105 14,023,917 15,556,423 64,114,148 8,606,249
Noncurrent Assets: I
Restricted Accounts 947,133 1,386,145 - - 2,333,278 -
Other Accounts 100,000 - - - 100,000 -
Interest Receivable - 12,651 - - 12,651 -
Special Assessment Receivable, Noncurrent - - 211,392 - 211,392 - I
Notes Receivable, Noncurrent - - - - - 445,000
Advances to Other Funds, Noncurrent - - 1,275,000 - 1,275,000 -
Unamortized Debt Issue Costs 874,309 55,280 - - 929,589 -
Electric Plant Acquisition (Net of Amortization) 998,073 - - - 998,073 - I
Capital Assets:
Land and Land Improvements 4,811,952 892,333 4,500 3,4 18,997 9,127,782 -
Plant in Service 40,866,626 44,170,751 37,794,582 36,987,271 159,819,230 33,302,544
Machinery and Equipment - - 1,827,065 482,634 2,309,699 14,304,965
Construction in Progress 556 185 - - 741 - I
Total Cost 45,679,134 45,063,269 39,626,147 40,888,902 171,257,452 47,607,509
Less Accumulated Depreciation (10,299,131) (9,841,821) (7,756,363) (8,140,3 I I) (36,037,626) (11,169,198)
Net Capital Assets 35,380,003 35,221,448 31,869,784 32,748,591 135,219,826 36,438,31 I
Total Noncurrent Assets 38,299,518 36,675,524 33,356, I 76 32,748,591 141,079,809 36,883,311 I
Total Assets $68,956,221 $40,552,629 $47,380,093 $48,305,014 $205, I 93,957 $ 45,489,560
LIABILITIES AND NET ASSETS:
Current Liabilities: I
Accounts Payable $ 3,177,302 $ 677,304 $ 29,601 $ 22,927 $ 3,907,134 $ 20,591
Due to Other Funds 36,293 1,029,246 24,480 8,160 1,098, I 79 -
. Current Compensated Absences - - 20,000 9,423 29,423 710,577
Liabilities Payable from Restricted Accounts: I
Current Portion of Revenue Bonds 608,000 102,000 - - 710,000 -
Accrued Interest Payable 589;317 30,966 - - 620,283 -
Customer Deposits 947,133 - - - 947,133 -
Total Current Liabilities 5,358,045 1,839,516 74,081 40,510 7,312,152 731,168
Noncurrent Liabilities: I
Deferred Revenue 4,970 7,267 - - 12,237 -
Compensated Absences - - 21,117 - 21,117 724, I 89
Revenue Bonds (NetofUnamortized Bond Premium I
and Unamortized Loss on Advance Refunding) 30,030,290 1,563,573 - - 31,593,863 -
Net OPEB Obligation - - 3,700 3,700 7,400 233, I 53
Total Noncurrent Liabilities 30,035,260 1,570,840 24,817 3,700 31,634,617 957,342
Total Liabilities 35,393,305 3,410,356 98,898 44,210 38,946,769 1,688,5 I 0
Net Assets: I
Invested in Capital Assets, Net of Related Debt 16,894,708 33,611,155 3 I ,869,784 32,748,591 115,124,238 36,438,31 I
Restricted 306,073 1,450,296 - - 1,756,369 -
Unrestricted 16,362,135 2,080,822 15,411,411 15,512,213 49,366,58[ 7,362,739 I
Total Net Assets 33,562,916 37,142,273 47,281,195 48,260,804 166,247,188 43,80 I ,050
Total Liabilities and Net Assets $68,956,22 I $40,552,629 $47,380,093 $48,305,014 $205, I 93,957 $ 45,489,560
The Notes to the Financial Statements are an integral part of this statement. 32 I
I
I CITY OF SHAKOPEE
Scott County, Minnesota
STATEMENT OF REVENUES, EXPENSES AND CHANGES
I IN FUND NET ASSETS - PROPRIETARY FUNDS
For the Year Ended December 31, 2008
I Business-Type Activities - Enterprise Funds
Governmental
Activities -
Storm Internal Service
I Electric Water Sewer Drainage Total Funds
OPERATING REVENUES:
Charges for Services $ 38,437,626 $ 3,254,227 $ 2,542,564 $ 1,265,374 $ 45,499,791 $ -
Rental and Other Charges - - - - - 2,952,918
I Total Operating Revenues 38,437,626 3,254,227 2,542,564 1,265,374 45,499,791 2,952,9 I 8
OPERATING EXPENSES:
Operations and Maintenance 33,191,532 2,112,716 2,597,364 787,739 38,689,351 -
I Depreciation 1,392,372 1,260,880 707,395 647,637 4,008,284 1,612,669
Amortization 63,003 - - 63,003 -
Employee Benefits - - - - - 1,030,109
Total Operating Expenses 34,646,907 3,373,596 3,304,759 1,435,376 42,760,638 2,642,778
I Operating Income (Loss) 3,790,719 (I 19:,369) (762, 195) (170,002) 2,739,153 310,140
NONOPERATING REVENUES (EXPENSES):
I Investment Income 1,283,755 247,502 777,190 820,294 3,128,741 491,477
Special Assessments - - 22,579 - 22,579 -
Interest Expense (I,445,786) (77,412) - - (1,523,198) -
Gain (Loss) on Sale of Asset - - (4,000) - (4,000) 56,453
I Amortization of Debt Issue Costs and
Loss on Refunding (93,983) (10,253) - - (104,236) -
Other Income 295,075 136,082 13,735 114,447 559,339 -
Total Nonoperating Revenues (Expenses) 39,061 295,919 809,504 934,741 2,079,225 547,930
I Income before Capital
Contributions and Transfers 3,829,780 176,550 47,309 764,739 4,818,378 858,070
I Capital Contributions 82,698 902,242 603,716 13,800 1,602,456 8,275,061
Transfers In - - - - - 140,615
Transfers Out (1,151,428) (651,924) (39,819) (72,333) (1,915,504) (606, 112)
I Change in Net Assets 2,761,050 426,868 611,206 706,206 4,505,330 8,667,634
NET ASSETS:
Beginning of Year 30,801,866 36,715,405 46,669,989 47,554,598 161,741,858 35,133,416
I End of Year $ 33,562,916 $37,142,273 $ 47,281,195 $ 48,260,804 $166,247,188 $ 43,801,050
I
I
I
I
I The Notes to the Financial Statements are an integral part of this statement. 33
I
CITY OF SHAKOPEE I
Scott County, Minnesota
STATEMENT OF CASH FLOWS - PROPRIETARY FUNDS
For the Year Ended December 31,2008 I
Business-Type Activities - Enterprise Funds
Governmental I
Activities -
Storm Internal
Electric Water Sewer Drainage Total Service Funds
CASH FLOWS - OPERATING ACTIVITIES: I
Receipts from Customers and Users $38,969,167 $3,224,800 $ 2,593,153 $ 1,272,675 $46,059,795 $ 2,952,918
Payments to Suppliers (31,422,196) (1,313,221) (2,428,934) (602,461) (35,766,812) -
Payments to Employees (1,623,907) (828,449) (229,799) (302,312) (2,984,467) (652,588) I
Payments for Interfund Services - - (23,085) (10,886) (33,971) (49,538)
Net Cash Flows - Operating Activities 5,923,064 1,083,130 (88,665) 357,016 7,274,545 2,250,792
CASH FLOWS - NONCAPITAL
FINANCING ACTIVITIES: I
Cash hnplicitly Financed to (from) Other Funds 727,279 (727,279) - - - -
Advances to Other Funds - - 42,450 7,088 49,538 -
Transfer to Other Funds (1,151,428) (651,924) (39,819) (72,333) (1,915,504) (465,497)
Net Cash Flows - Noncapital I
Financing Activities (424,149) (1,379,203) 2,631 (65,245) (1,865,966) (465,497)
CASH FLOWS - CAPITAL AND RELATED
FINANCING ACTIVITIES: I
Principal Paid on Debt (573,600) (96,400) - - (670,000) -
Interest Paid on Debt (1,433,093) (78,716) - - (1,511,809) -
Capital Contributions 82,698 846,804 - - 929,502 -
Trunk Charges - - 13,735 114,447 128,182 - I
Capital Related Special Assessments - - 55,931 - 55,931 -
Interfund Loan for Capital Acquisition - - 350,000 - 350,000 -
Proceeds from Disposal of Capital Assets - - - - - 134,769
Acquisition of Capital Assets (2,960,038) (493,185) (233,529) (67,695) (3,754,447) (1,194,284) I
Net Cash Flows - Capital and Related
Financing Activities (4,884,033) 178,503 186,137 46,752 (4,472,641) (1,059,515)
CASH FLOWS - INVESTING ACTIVITIES: I
Proceeds (Purchases) of Investments 620,550 285,014 (1,970,777) (2,387,020) (3,452,233) (942,861)
Interest and Dividends Received 1,102,703 250,512 781,397 806,618 2,94 I ,230 477,827
Net Cash Flows - Investing Activities 1,723,253 535,526 (1,189,380) (1,580,402) (511,003) (465,034) I
Net Change in Cash and Cash Equivalents 2,338,135 417,956 (1,089,277) (1,241,879) 424,935 260,746
CASH AND CASH EQUIVALENTS: I
Beginning of Year 6,091,173 843,246 2,551,906 2,943,094 12,429,419 1,500,487
End of Year $ 8,429,308 $1 ,261.202 $ 1 ,462,629 $ 1.701.215 $12,854,354 $ 1.761.233
RECONCILIATION OF CASH AND CASH I
EQUIVALENTS TO THE STATEMENT OF
NET ASSETS:
Restricted Accounts $12,123,136 $1,468,611 $ - $ - $13,591,747 $ - I
Other Accounts 100,000 - - - 100,000 -
Cash and Investments 14,418,874 3,396,992 13,074,718 15,207,485 46,098,069 8,424,668
Subtotal 26,642,010 4,865,603 13,074,718 15,207,485 59,789,816 8,424,668
Less Long-Term Investments 18,212,702 3,604,401 11,612,089 13,506,270 46,935,462 6,663,435 I
Cash and Cash Equivalents $ 8,429.308 $1.261 ,202 $ 1 ,462,629 $ 1.701,215 $12,854,354 $ l,761.233
I
The Notes to the Financial Statements are an integral part of this statement. 34 I
I
I CITY OF SHAKOPEE
Scott County, Minnesota
STATEMENT OF CASH FLOWS - PROPRIETARY FUNDS
I For the Year Ended December 31,2008
I Business-Type Activities - Enterprise Funds
Governmental
Activities -
Storm Internal
I Electric Water Sewer Drainage Total Service Funds
RECONCILIATION OF OPERATING
(INCOME) LOSS TO NET CASH FLOWS -
OPERATING ACTIVITIES:
I Operating Income (Loss) $ 3,790,719 $ (119,369) $ (762,195) $ (170,002) $ 2,739,153 $ 310,140
Adjustments to Reconcile Operating Income
(Loss) to Net Cash Flows - Operating Activities:
Miscellaneous Revenue 295,075 136,082 - - 431,157 -
I Depreciation and Amortization Expense 1,455,375 1,260,880 707,395 647,637 4,071,287 1,612,669
Change in Assets and Liabilities:
Accounts Receivable 200,831 (37,305) 50,589 7,301 221,416 -
Due from Other Funds (1,395) (52,350) - - (53,745) -
I Prepaid Items 3,065 1,022 - - 4,087 -
Inventory 162,404 1,617 - - 164,021 -
Accounts Payable (12,849) (34,777) (41,186) (130,382) (219,194) -
Contracts Payable - - (47,030) (847) (47,877) -
I Customer Deposits 49,717 - - - 49,717 -
Deferred Revenue (12,687) (75,854) - - (88,541) -
Due to Other Funds (74,738) - 1,395 (2,726) (76,069) (49,538)
Compensated Absences Payable - - (1,333) 2,335 1,002 144,368
I Net OPEB Obligation - - 3,700 3,700 7,400 233,153
Other Liabilities 67,547 3,184 - - 70,731 -
Total Adjustments 2,132,345 1,202,499 673,530 527,018 4,535,392 1,940,652
Net Cash Flows -
I Operating Activities $ 5,923,064 $1,083,130 $ (88,665) $ 357,016 $ 7.274,545 $ 2,250,792
NONCASH INVESTING, CAPITAL AND
FINANCING ACTIVITIES:
I Contributions of Capital Assets from the
Municipality and Developers $ - $ 55,438 $ 603,716 $ 13,800 $ 672,954 $ 8,275,061
Purchases of Capital Assets on Account - - - - - 20,591
Capital Asset Trade-Ins - - - 29,845 29,845 191,747
I
I
I
I
I
I
I The Notes to the Financial Statements are an integral part of this statement. 35
I
CITY OF SHAKOPEE I
Scott County, Minnesota
STATEMENT OF FIDUCIARY NET ASSETS I
December 31,2008
Escrow I
Agency Fund I
ASSETS:
Cash and Investments $ . 1,293,136
LIABILITIES: I
Accounts Payable $ 5,071
Deposits Payable 1,288,065 I
Total Liabilities $ 1,293,136
I
I
I
I
I
I
I
I
I
I
I
The Notes to the Financial Statements are an integral part ofthis statement. 36 I
I
I CITY OF SHAKO PEE
I Scott County, Minnesota
NOTES TO THE FINANCIAL STATEMENTS
I December 31,2008
NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
I A. Reporting Entity
I The City of Shakopee is a statutory city governed by an elected mayor and four council members.
The accompanying financial statements present the government entities for which the
government is considered to be financially accountable.
I The financial statements present the City and its component units. The City includes all funds,
organizations, institutions, agencies, departments and offices that are not legally separate from
I such. Component units are legally separate organizations for which the elected.officials of the
City are financially accountable and are included within the financial statements of the City
because ofthe significance of their operational or financial relationships with the City.
I The City is considered financially accountable for a component unit if it appoints a voting
majority of the organization's governing body and it is able to impose its will on the organization
by significantly influencing the programs, projects, activities or level of services performed or
I provided by the organization or there is a potential for the organization to provide specific
financial benefits to or impose specific financial burdens. on, the City.
I As a result of applying the component unit definition criteria above, certain organizations have
been defined and are presented in this report as follows:
I Blended Component Unit - Reported as if they were part of the City.
Joint Ventures and Jointly Governed Organizations - The relationship of the City with the
I entity is disclosed.
For each of the categories above, the specific entities are identified as follows:
I 1. Blended Component Unit
The Shakopee Economic Development Authority (EDA) was organized to promote
I development, improve housing and reduce blighted areas in the City. It is included by reason
ofthe City Council having final approval for Shakopee EDA actions and the Shakopee EDA
Board being comprised entirely of City Council Members. City staff handles Shakopee EDA
I activity including Shakopee EDA funds and the City approves Shakopee EDA tax levies and
bonding activity. Therefore, the City has financial oversight for Shakopee EDA activities.
I The activity of the Shakopee EDA is shown in the Shakopee EDA Special Revenue Fund in
the City's financial statements. No separate financial statements for the Shakopee EDA are
issued. For any information desired beyond what is presented in this report, contact the
I Finance Director for the City of Shakopee at 129 Holmes Street South, Shakopee, Minnesota
55379-1351.
I 37
I
CITY OF SHAKOPEE I
Scott County, Minnesota
NOTES TO THE FINANCIAL STATEMENTS I
December 31,2008
NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES I
A. Reporting Entity (Continued) I
2. Joint Ventures and Jointly Governed Organizations I
Local Government Information Systems
Local Government Information Systems (LOGIS) is a joint venture of approximately 44 I
governmental entities that provides computerized data processing and support services to its
members. Legally separate, the City does not appoint a voting majority of the Board and
LOGIS is fiscally independent of the City. During 2008, the City paid $ 200,588 to LOGIS I
for services provided which is included in expenditures of the General Fund. Financial
statements are available by contacting LOGIS, 5750 Duluth Street, Golden Valley, Minnesota
55422-4036. I
Scott Joint Prosecution Association
Scott Joint Prosecution Association (the "SJP A") is a joint venture of approximately seven I
cities that provides legal prosecution and support services to its members. Legally separate,
the City does not appoint a voting majority of the Board of Directors and the SJPA is fiscally I
independent of the City. During 2008, the City paid $ 346,454 to the SJPA for services
provided which is included in expenditures of the General Fund. Financial statements are
available by contacting the SJPA, 200 Fourth Avenue West, Shakopee, Minnesota 55379. I
3. Other Organizations
Shakopee Volunteer Fire Department Relief Association I
The Shakopee Volunteer Fire Department Relief Association (the "Association") is organized as
a nonprofit organization, legally separate from the City, by its members to provide pensions and I
other benefits to such members in accordance with Minnesota Statutes. It is not a component
unit of the City because the Board of Directors is appointed by the membership of the
Association and not by the City Council. The financial oversight ofthe City is limited to I
approval authority for amending the Association bylaws when the change results in an increase
in the pension benefit level requiring an increased City contribution. The Association has the
authority to levy its own taxes for pensions and deficits and would continue to exist for its I
members if the City was dissolved. Because the Association is fiscally independent of the City,
the financial statements of the Association have not been included within the City's reporting
entity. I
I
38 I
I
I CITY OFSHAKOPEE
I Scott County, Minnesota
NOTES TO THE FINANCIAL STATEMENTS
I December 31,2008
NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
I B. Government-Wide and Fund Financial Statements
I The government-wide financial statements (i.e., the Statement of Net Assets and the Statement
of Activities) report information on all of the nonfiduciary activities of the City. The fiduciary
funds are only reported in the Statement of Fiduciary Net Assets at the fund financial statement
I level. Governmental activities, which normally are supported by taxes and intergovernmental
revenues, are reported separately from business-type activities, which rely to a significant extent
on fees and charges for support.
I The Statement of Activities demonstrates the degree to which the direct expenses of a given
function or segment are offset by program revenues. Direct expenses are those that are clearly
I identifiable with a specific function or segment. Interest on general long-term debt is considered
an indirect expense and is reported separately in the Statement of Activities. Program revenues
include I) charges to customers or applicants who purchase, use or directly benefit from goods,
services or privileges provided by a given function or segment and 2) grants and contributions
I that are restricted to meeting the operational or capital requirements of a particular function or
segment. Taxes and other items not properly included among program revenues are reported
instead as general revenues. Internally dedicated revenues are reported as general revenues
I rather than program revenues.
Separate financial statements are provided for governmental funds and proprietary funds. Major
I individual governmental funds and major individual enterprise funds are reported as separate
columns in the fund financial statements.
I The Escrow Agency Fund is presented in the fiduciary fund financial statements. Since, by
definition, these assets are being held for the benefit of a third party (other local governments,
private parties, etc.) and cannot be used to address activities or obligations of the City, this fund
I is not incorporated into the government-wide statements.
C. Measurement Focus, Basis of Accounting and Financial Statement Presentation
I The government-wide financial statements are reported using the economic resources
measurement focus and the accrual basis of accounting, as are the proprietary fund financial
statements. Revenues are recorded when earned and expenses are recorded when a liability is
I incurred, regardless of the timing of related cash flows. Property taxes are recognized as revenues
in the year for which they are levied. Grants and similar items are recognized as revenue as soon
as all eligibility requirements imposed by the provider have been met.
I The agency fund reports only assets and liabilities and has no measurement focus, but does use the
accrual basis of accounting to recognize receivables and payables.
I
I 39
I
CITY OF SHAKOPEE I
Scott County, Minnesota I
NOTES TO THE FINANCIAL STATEMENTS
December 31, 2008
I
NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
c. Measurement Focus, Basis of Accounting and Financial Statement Presentation I
(Continued)
Governmental fund financial statements are reported using the current financial resources I
measurement focus and the modified accrual basis of accounting. Revenues are recognized as
soon as they are both measurable and available. Revenues are considered to be available when I
they are collectible within the current period or soon enough thereafter to pay liabilities ofthe
current period. For this purpose, the City considers revenues to be available if they are collected
within 60 days of the end of the current fiscal period. Expenditures generally are recorded when I
a liability is incurred, as under accrual accounting. However, debt service expenditures, as well
as expenditures related to compensated absences and claims and judgments, are recorded only
when payment is due. I
Property taxes, franchise taxes, licenses and interest associated with the current fiscal period are
all considered to be susceptible to accrual and so have been recognized as revenues ofthe
current fiscal period. Only the portion of special assessments receivable due within the current I
fiscal period is considered to be susceptible to accrual as revenue of the current period. All
other revenue items are considered to be measurable and available only when cash is received
by the City. I
Description of Funds:
Major Governmental Fund: I
General Fund - This Fund is the City's primary operating fund. It accounts for all financial I
resources of the general City, except those required to be accounted for in another fund.
Proprietary Funds: I
Electric Fund - This Fund accounts for the operations of the City's electric utility.
Water Fund - This Fund accounts for the operations of the City's water utility. I
Sewer Fund - This Fund accounts for operations of the City's sewer utility.
Storm Drainage Fund - This Fund accounts for the activities ofthe City's storm drainage I
utility.
I
I
40 I
I
I CITY OF SHAKOPEE
I Scott County, Minnesota
NOTES TO THE FINANCIAL STATEMENTS
December 31, 2008
I
NOTE 1- SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
I c. Measurement Focus, Basis of Accounting and Financial Statement Presentation
(Continued)
I Description of Funds: (Continued)
I Internal Service Funds:
Equipment Fund - This Fund accounts for the City's acquisition of larger pieces of
I equipment.
Building Fund - This Fund accounts for the City's funds accumulated for construction,
improvement or majorrepairs of major public buildings.
I Park Assets Fund - This Fund accounts for the City's funds accumulated for the replacement
of park assets.
I Employee Benefits Fund- This Fund accounts for the City's funds accumulated for
compensated absences and other post employment benefits.
I Fiduciary Fund:
I Escrow Agency Fund - This Fund accounts for the monies held for specific purposes for
individuals, private organizations, other government units and other funds. Escrows may be
held on behalf of builders and developers, for security deposits and police evidence deposits.
I Private-sector standards of accounting and financial reporting issued prior to December 1, 1989,
generally are followed in both the government-wide and proprietary fund financial statements to
the extent that those standards do not conflict with or contradict guidance of the Governmental
I Accounting Standards Board (GASB). Governments also have the option of following
subsequent private-sector guidance for their business-type activities and enterprise funds, subject
to this same limitation. The City has elected not to follow subsequent private-sector guidance.
I As a general rule, the effect of interfund activity has been eliminated from the government-wide
financial statements. Exceptions to this general rule are payments, where the amounts are
I reasonably equivalent in value to the interfund services provided and other charges between the
City's utility function and various other functions of the City. Elimination of these charges
would distort the direct costs and program revenues reported for the various functions concerned.
I
I
I 41
I
CITY OF SHAKOPEE I
Scott County, Minnesota I
NOTES TO THE FINANCIAL STATEMENTS
December 31, 2008
I
NOTE 1- SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
C. Measurement Focus, Basis of Accounting and Financial Statement Presentation I
(Continued)
Proprietary funds distinguish operating revenues and expenses from nonoperating items. I
Operating revenues and expenses generally result from providing services and producing and
delivering goods in connection with a proprietary fund's principal ongoing operations. The I
principal operating revenues of the enterprise funds are charges to customers for sales and
services. Operating expenses for enterprise funds include the cost of sales and services,
administrative expenses and depreciation on capital assets. All revenues and expenses not
meeting this definition are reported as nonoperating revenues and expenses. I
When both restricted and unrestricted resources are available for use, itis the City's policy to use
restricted resources first, then unrestricted resources as they are needed. I
D. Assets, Liabilities and Net Assets or Equity
1. Deposits and Investments I
The City's cash and cash equivalents are considered to be cash on hand, demand deposits and I
highly liquid debt instruments purchased with original maturities of three months or less from
the date of acquisition. Investments are stated at fair value.
Minnesota Statutes authorizes the City to invest in obligations of the U.S. Treasury, agencies I
and instrumentalities, shares of investment companies whose only investments are in the
aforementioned securities, obligations of the State of Minnesota or its municipalities,
bankers' acceptances, future contracts, repurchase and reverse repurchase agreements and I
commercial paper of the highest quality with a maturity of no longer than 270 days and in the
Minnesota Municipal Money Market Fund.
The Minnesota Municipal Money Market Fund is an external investment pool not registered I
with the Securities Exchange Commission (SEC) that follows the same regulatory rules of
the SEC under Rule 2.a. 7. The fair value of the position in the pool is the same as the value I
of the pool shares.
The City's investment policy for all funds except the Electric and Water Enterprise Funds I
(Shakopee Public Utilities Commission) addresses custodial credit risk for deposits. The
policy also addresses credit risk, interest rate risk, concentration of credit risk and custodial
credit risk for investments. The City's Electric and Water Enterprise Funds (Shakopee Public I
Utilities Commission) also have a formal policy to address all of these risks except custodial
credit risk for investments.
I
42 I
I
I CITY OF SHAKO PEE
I Scott County, Minnesota
NOTES TO THE FINANCIAL STATEMENTS
December 31, 2008
I
NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
I, D. Assets, Liabilities and Net Assets or Equity (Continued)
I 1. Deposits and Investments (Continued)
Custodial Credit Risk - Deposits: This is the risk that in the event of a bank failure, the
I City's deposits may not be returned to it. Minnesota Statutes require all deposits be protected
by federal deposit insurance, corporate surety bonds or collateral. The market value of
collateral pledged must equal 11 0% of deposits not covered by Federal Deposit Insurance
I Corporation (FDIC) insurance or corporate surety bonds. The City's investment policy and
the investment policy for the City's Electric and Water Enterprise Funds (Shakopee Public
Utilities Commission) state deposits must be collateralized in order to comply with
Minnesota Statutes.
I Credit Risk: This is the risk that an issuer or other counterparty to an investment will not
fulfill its obligation to the holder of the investment. Minnesota Statutes 118A.04 and
'I 188A.OS limit investments that are in the top two ratings issued by nationally recognized
statistical rating organizations. The City's investment policy references Minnesota Statutes
and further limits the types of investments that the City is allowed to invest in. The
I investment policy for the City's Electric and Water Enterprise Funds (Shakopee Public
Utilities Commission) also defines suitable and authorized investments and related minimum
ratings.
I Interest Rate Risk: This is the risk that changes in market interest rates will adversely affect
the fair value of an investment. The City's policy states the investment portfolio shall be
I designed with the objective of attaining a market rate of return throughout budgetary and
economic cycles, taking into account the investment risk constraints and liquidity needs. To
the extent possible, the City shall attempt to match its investments in short-term operating
funds with anticipated cash flow requirements. Unless matched to a specific cash flow, the
I City will not directly invest in securities maturing more than ten years from the date of
purchase. Long-term funds shall not be invested in securities exceeding 10 years in modified
duration, at tim1 of purchase. The investment policy for the City's Electric and Water
I Enterprise Funds (Shakopee Public Utilities Commission) addresses this risk by requiring
holding of securities to maturity (subject to certain exceptions) and limiting maturity
constraints to a relatively short duration.
I
I
I \
I 43
I
CITY OF SHAKOPEE I
Scott County, Minnesota I
NOTES TO THE FINANCIAL STATEMENTS
December 31,2008
I
NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
D. Assets, Liabilities and Net Assets or Equity (Continued) I
1. Deposits and Investments (Continued) I
Concentration of Credit Risk: This is the risk of loss attributed to the magnitude of an
investment in a single issuer. According to the City's investment policy, the aggregate I
investment portfolio shall be diversified by:
. Limiting investments to avoid over concentration in securities from a specific issuer
or business sector. I
. Limiting investments in securities that have higher credit risks.
. Investing in securities with varying maturities.
. Continuously investing a portion of the portfolio in readily available funds, such as I
Local Government Investment Pools (LGIP), money market funds or repurchase
agreements to ensure appropriate liquidity is maintained in order to meet ongoing I
obligations.
. Having all investments, other than those in direct obligations or agencies of the
United States, secured by collateral or repurchase agreements, shall not exceed 50%
ofthe aggregate investment portfolio. Mortgage backed securities shall not exceed I
35% of the aggregate investment portfolio, at the time of investment (i.e., commercial
paper or bankers' acceptance).
. Limiting investments in anyone corporation to 5% of the aggregate investment I
portfolio.
The investment policy for the City's Electric and Water Enterprise Funds (Shakopee Public I
Utilities Commission) defines suitable and authorized investments and related minimum
ratings as well as application of prudent person standards in construction of portfolio
management and diversification. I
Custodial Credit Risk - Investments: For an investment, this is the risk that in the event of
the failure of the counterparty, the City will not be able to recover the value of its investments I
or collateral securities that are in the possession of an outside party. The City's investment
policy states all securities purchased, including appropriate collateral, shall be placed with an
independent third party for custodial safekeeping. I
I
I
44 I
I
I CITY OF SHAKOPEE
Scott County, Minnesota
,I NOTES TO THE FINANCIAL STATEMENTS
December 31, 2008
I
NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
I D. Assets, Liabilities and Net Assets or Equity (Continued)
I 2. Receivables and Payables
Activity between funds that are representative of lendinglborrowing arrangements
I outstanding at the end of the fiscal year are referred to as "advances to/from other funds". All
other outstanding balances between funds are reported as "due to/from other funds". Any
residual balances outstanding between the governmental activities and business-type
activities are reported in the government-wide financial statements as "interfund balances".
I All trade and property tax receivables are shown at a gross amount since both are assessable
to the property taxes and are collectible upon the sale of the property.
I The City levies its property tax for the subsequent year during the month of December.
December 28 is the last day the City can certify a tax levy to the County Auditor for
I collection the following year. Such taxes become a lien on January 1 and are recorded as
receivables by the City at that date. The property tax is recorded as revenue when it becomes
measurable and available. Scott County is the collecting agency for the levy and remits the
I collections to the City three times a year. The tax levy notice is mailed in March with the
first half of the payment due on May 15 and the second half due on October 15. Taxes not
collected as of December 31 each year are shown as delinquent taxes receivable.
I The County Auditor prepares the tax list for all taxable property in the City, applying the
applicable tax rate to the tax capacity of individual properties, to arrive at the actual tax for
each property. The County Auditor also collects all special assessments, except for certain
I prepayments paid directly to the City.
The County Auditor submits the list of taxes and special assessments to be collected on each
I parcel of property to the County Treasurer in January of each year.
3. Inventory, Prepaid Items and Other Assets
I Certain payments to vendors reflect costs applicable to future accounting periods and are
recorded as prepaid items in both government-wide and fund financial statements. Other
I' assets include unamortized debt issuance costs for the Electric and Water Enterprise Funds.
Also included is the unamortized cost of buying capacity in a sewer inceptor owned by
Metropolitan Council - Environmental Services.
I Inventories of enterprise funds are valued at average cost using the first in, first out (FIFO)
method. Inventories of governmental funds are not recorded at year-end on the Balance
Sheets because they accumulate insignificant inventories.
I
I 45
I
CITY OF SHAKOPEE I
Scott County, Minnesota
NOTES TO THE FINANCIAL STATEMENTS I,
December 31, 2008
NOTE 1- SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES I
D. Assets, Liabilities and Net Assets or Equity (Continued) I
4. Restricted Assets
Certain cash and investments in the enterprise funds are classified as restricted. The Electric I
Fund has monies restricted for customer deposits and debt service. The Water Fund has
monies restricted for water production and trunk distribution facility acquisition, based on I
trunk and connection fees collected from users, construction projects and debt service.
5. Capital Assets I
Capital assets, which include property, plant, equipment and infrastructure assets (e.g., roads,
sidewalks and similar items), are reported in the applicable governmental or business-type I
activities columns in the government-wide financial statements. Capital assets are defined by
the City, excluding the Electric and Water Enterprise Funds (Shakopee Public Utilities
Commission), as assets with an initial, individual cost of more than $ 5,000 and an estimated I
useful life in excess of one year. Capital assets for the Electric and Water Enterprise Funds
(Shakopee Public Utilities Commission) are defined as assets with an initial, individual cost
of more than $ 1,000 and an estimated useful life in excess of one year. Such assets are
recorded at historical cost or estimated historical cost if purchased or constructed. Donated I
capital assets are recorded at estimated fair market value at the date of donation.
The costs of normal maintenance and repairs that do not add to the value of the asset or I
materially extend assets lives are not capitalized.
Property, plant and equipment of the City are depreciated using the straight-line method over I
the following estimated useful lives.
Assets Years I
Buildings 30-50
Park Buildings 30 I
Building Improvements 25
Light Vehicles 4-10
Machinery and Equipment 4-20 I
Utility Distribution System 10-75
Infrastructure 30-50
Fire Trucks 20-25 I
I
46 I
I
I CITY OF SHAKOPEE
I Scott County, Minnesota
NOTES TO THE FINANCIAL STATEMENTS
December 31, 2008
I
NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
I D. Assets, Liabilities and Net Assets or Equity (Continued)
I 6. Compensated Absences
Vacation and sick leave benefits are recorded as expenditures in the Employee Benefits
I Internal Service Fund and governmental funds when the obligations have matured and are
expected to be liquidated with expendable financial resources. City employees earn vacation
time based on years of City service. Employees who have 0 to 15 years of employment may
I accumulate no more than 240 hours. Employees who have 16 or more years of service may
accumulate no more than 360 hours of vacation leave. Upon termination, employees will
receive compensation for all unused vacation. Employees earn sick leave at a rate of3.69
hours per pay period and may accumulate it to a maximum of 960 hours. The City
I compensates employees who leave municipal service at the rate of 45% up to 15 years of
service. After 15 years of service, employees who leave are compensated at the rate of 55%
plus 2% for each year of service beyond 15 years up to 75% of unused sick leave.
I 7. Long-Term Obligations
I In the government-wide financial statements and proprietary fund types in the fund financial
statements, long-term debt and other long-term obligations are reported as liabilities in the
applicable governmental activities, business-type activities or proprietary fund type Statement
I of Net Assets. Enterprise fund bond premiums and discounts, as well as issuance costs, are
deferred and amortized over the life of the bonds using the effective interest method. Bonds
payable are reported net of the applicable bond premium or discount. Bond issuance costs
I are reported as deferred charges and amortized over the term of the related debt.
In the fund financial statements, governmental fund types recognize bond premiums and
discounts, as well as bond issuance costs, during the current period. The face amount of debt
I, issued is reported as other financing sources. Premiums received on debt issuances are
reported as other financing sources while discounts on debt issuances are reported as other
financing uses. Issuance costs, whether or not withheld from the actual debt proceeds
I received, are reported as debt service expenditures.
8. Fund Equity
I In the fund financial statements, governmental funds report reservations of fund balance for
amounts that are not available for appropriation or are legally restricted by outside parties for
I use for a specific purpose. Designations of fund balance represent tentative management
plans that are subject to change.
I
I 47
I
CITY OF SHAKOPEE I
Scott County, Minnesota
NOTES TO THE FINANCIAL STATEMENTS 'I
December 31, 2008
NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES I
D. Assets, Liabilities and Net Assets or Equity (Continued) I
9. Net Assets I
Net assets represent the difference between assets and liabilities in the government-wide
financial statements. Net assets invested in capital assets, net of related debt consists of
capital assets, net of accumulated depreciation, reduced by the outstanding balance of any I
long-term debt used to build or acquire the capital assets. Net assets are reported as restricted
in the government-wide financial statement when there are limitations on their use through
external restrictions imposed by creditors, grantors or laws or regulations of other I
governments.
10. Use of Estimates I
The preparation of financial statements in conformity with U.S. generally accepted
accounting principles requires management to make estimates and assumptions that affect the I
reported amounts of assets and liabilities and disclosure of contingent assets and liabilities at
the date of the financial statements. Estimates also affect the reported amounts of revenue
and expenditures/expense during the reporting period. Actual results could differ from those
estimates. I
NOTE 2 - STEWARDSHIP, COMPLIANCE AND ACCOUNTABILITY
A. Budgetary Information I
Budgets are adopted on a basis consistent with U.S. generally accepted accounting principles. I
Annually appropriated budgets are adopted for the General Fund and the Shakopee EDA, Transit,
Telecommunications and Recreation Special Revenue Funds. The Forfeiture Fund is not required
to have a budget adopted. All activity in this Fund is at the discretion of the Chief of Police. I
Budgeted amounts present the originally adopted budget and final amended budget approved by
the City Council. The City does not use encumbrances. Budgeted expenditure appropriations I
lapse at year end.
1. In August of each year, City staff submits to the City Council, a proposed operating
budget for the fiscal year commencing the following January 1. The operating budget I
includes proposed expenditures and the means of financing them for the upcoming year.
2. Public hearings are conducted to obtain taxpayer comments. I
3. The budget is legally enacted through passage of a resolution after obtaining taxpayer
comments. I
48 I
I
I CITY OF SHAKO PEE
I Scott County, Minnesota
NOTES TO THE FINANCIAL STATEMENTS
December 31, 2008
I
NOTE 2 - STEWARDSHIP, COMPLIANCE AND ACCOUNTABILITY
I A. Budgetary Information (Continued)
I 4. Expenditures may not legally exceed budgeted appropriations at the division level. No
fund's budget can be increased without City Council approval. The City Council may
authorize transfer of budgeted amounts between divisions within any fund. Management
I may amend budgets within a division level, so long as the total division budget is not
changed.
I 5. Annual budgets are adopted for the General and applicable Special Revenue Funds.
Annual appropriated budgets are not adopted for Debt Service Funds because effective
budgetary control is alternatively achieved through bond indenture provisions. Budgetary
I control for Capital Projects Funds is accomplished through the use ofproject controls and
formal budgets are not adopted.
6. Budgeted amounts are as originally adopted or as amended by the City Council.
I Individual amendments were not material in relation to the original amounts budgeted,
except for transfers in the General Fund.
I B. Expenditures in Excess of Appropriations
Expenditures exceeded appropriations in the following Fund for the year ended December 31,
I 2008:
Appropriations Expenditures Excess
I ,Nonmajor Special Revenue Fund:
Recreation $ 2,250,660 $ 2,303,679 $ 53,019
I C. Deficit Fund Balances
The following Funds had deficit balances at December 31, 2008:
I Nonmajor Governmental Funds:
Capital Projects:
I Park Reserve $ 1,609,409
2009 Projects 34,725
I The deficit fund balances in the Capital Projects Funds are a result of ongoing construction which
is periodically reimbursed by transfers from other funds and bond proceeds.
I
I 49
I
CITY OF SHAKOPEE I
Scott County, Minnesota I
NOTES TO THE FINANCIAL STATEMENTS
December 31, 2008
I
NOTE 3 - DEPOSITS AND INVESTMENTS
A. Deposits I
In accordance with applicable Minnesota Statutes, the City maintains deposits at depository I
banks authorized by the City Council.
Custodial Credit Risk: As of December 31, 2008, the City's bank balances, including the I
Electric and Water Enterprise Funds (Shakopee Public Utilities Commission), were not exposed
to custodial credit risk because they were insured through FDIC and properly collateralized with
securities held by the pledging financial institutions' trust departments or agents in the City's I
name.
As of December 31, 2008, the City had the following deposits:
Deposits (All Funds but the Electric and $ 201,402 I
Water Enterprise Funds
Deposits (Electric and Water Enterprise Funds) 10,900,950 I
Total Deposits $ 11,102,352
B. Short-Term Investments I
As of December 31, 2008, the City had the following short-term investments for all funds, I
excluding the Electric and Water Enterprise Funds (Shakopee Public Utilities Commission).
Investment Maturities I
Fair Less than 1-5 6 -10
Investment Type Value One Year Years Years I
Agency Bonds $ 6,121,260 $ $ 4,116,260 $ 2,005,000
-
Agency Step-Up Bonds 1,001,980 - 1,001,980 - I
Commercial Paper 1,999,365 1,999,365 - -
Certificates of Deposit 2,853,674 2,853,674 - -
Money Market Funds 4,925,781 4,925,781 - - I
Total mvestments $ 16,902,060 $ 9,778,820 $ 5,118,240 $ 2,005,000
I
I
50 I
I
I CITY OF SHAKOPEE
I Scott County, Minnesota
NOTES TO THE FINANCIAL STATEMENTS
December 31, 2008
I
NOTE 3 - DEPOSITS AND INVESTMENTS
I C. Long-Term Investments
I As of December 31, 2008, the City had the following long-term investments for all funds,
excluding the Electric and Water Enterprise Funds (Shakopee Public Utilities Commission).
I Modified
Fair Duration Moody's
Value (Years ) Rating
I U.S. Treasury Notes $ 1,698,617 3.78 Aaa
U.S. Treasury Bills 498,645 0.82 Aaa
I Agency Bonds:
FFCB 4,748,362 1.60 Aaa
FHLB 7,320,443 1.81 Aaa
I FHLMC 3,866,515 1.09 Aaa
FNMA 7,265,858 0.76 Aaa
I Agency Step-Up Bonds:
FHLMC 515,190 0.51 Aaa
FNMA 365,642 0.46 Aaa
I Mortgage Bonds:
CMO 4,602,252 1.09 Aaa
FHLMC 5,422,792 2.43 Aaa
I FNMA 4,552,783 2.59 Aaa
GNMA 325,136 1.68 Aaa
Municipal Bonds 9,876,144 1.74 (Aa1-A3)
I Total Long-Term Investments 51,058,379 1.54
I Total Investments $ 67 ,960,439
I
I
I
I 51
I
CITY OF SHAKOPEE I
Scott County, Minnesota
NOTES TO THE FINANCIAL STATEMENTS I
December 31, 2008
NOTE 3 - DEPOSITS AND INVESTMENTS I
C. Long-Term Investments (Continued) I
As of December 31,2008, the City's Electric and Water Enterprise Funds (Shakopee Public I
Utilities Commission) had the following investments.
Investment Maturities
Fair Less than 1 - 5 6 - 10 More than I
Investment Type Value One Year Years Years 10 Years
U.S. Treasuries $ 2,029,304 $ 785,563 $ 1,243,741 $ - $ - I
U.S. Agencies 13,507,044 6,681,590 6,825,454 - -
External Investment Pools 5,070,315 5,070,315 - - -
Total Investments $ 20,606,663 $ 12,537,468 $ 8,069,195 $ - $ - I
Custodial Credit Risk- Investments: As of December 31, 2008, all investments of the City and I
the Electric and Water Enterprise Funds (Shakopee Public Utilities Commission) were insured,
registered and held by the City or its agent and in the City's name.
Credit Risk: In accordance with the City's investment policy, the City is invested in securities I
with high ratings. Investments in government bonds are rated Aa1, Aa2, Aa3, AI, A2 and A3.
Investments in agency bonds and agency step-up bonds are rated Aaa. Investments in
commercial paper have a credit rating ofP-1 and the money market funds and certificates of I
deposit do not have credit ratings. The City's Electric and Water Enterprise Funds (Shakopee
Public Utilities Commission) investments in U.S. Agencies have ratings by Moody's Investors
Service ranging from unrated to Aaa. The City's Electric and Water Enterprise Funds (Shakopee I
Public Utilities Commission) investments in external investment pools are not rated.
Concentration of Credit Risk: As of December 31, 2008, the City's investments exceeding 5% I
of the City's total investments for all funds excluding the Electric and Water Enterprise Funds
(Shakopee Public Utilities Commission) were as follows.
Investment Percentage of I
Issuer Type Portfolio
Federal Home Loan Bank (FHLB) U.S. Agencies 10.8% I
Federal Home Loan Mortgage Corporation (FHLMC) U.S. Agencies 20.3%
Federal National Mortgage Association (FNMA) U.S. Agencies 29.2% I
Federal Farm Credit Bank (FFCB) U.S. Agencies 7.0%
The City's Electric and Water Enterprise Funds (Shakopee Public Utilities Commission) I
investments in FHLB, FNMA and FHLMC also exceeded 5% of the total investments of those
funds at December 31, 2008.
52 I
I
I CITY OF SHAKOPEE
Scott County, Minnesota
I NOTES TO THE FINANCIAL STATEMENTS
December 31, 2008
I
NOTE 3 - DEPOSITS AND INVESTMENTS
I C. Long-Term Investments (Continued)
I The following is a summary of total deposits and investments as of December 31,2008:
Deposit (Note 3.A.) $ 11,102,352
I Investments (All Funds but the Electric and
Water Enterprise Funds) 67,960,439
Investments (Electric and Water Enterpirse Funds) 20,606,663
I Petty Cash 1,200
Total Deposits and Investments $ 99,670,654
I Deposits and investments are presented in the December 31, 2008 basic financial statements as
follows:
I Statement of Net Assets:
Cash and Investments $ 84,685,771
I Restricted and Other Accounts 13,691,747
Statement of Fiduciary Net Assets 1,293,136
I Total Cash and Investments $ 99,670,654
I NOTE 4 - RECEIVABLES
Governmental funds report deferred revenue in connection with receivables for revenues that are
I not considered to be available to liquidate liabilities of the current period. Governmental funds
also defer revenue recognition in connection with resources that have been received, but not yet
earned. At the end of the current fiscal year, the various components of deferred revenue
I reported in the governmental funds were as follows:
Delinquent Delinquent Deferred
I Property Special Special
Taxes Assessments Assessments Total
I General Fund $ 473,314 $ 6,792 $ 28,495 $ 508,601
Nonmajor Funds 10,003 15,149 8,225,833 8,250,985
Total $ 483,317 $ 21,941 $ 8,254,328 $ 8,759,586
I
I 53
I
CITY OF SHAKOPEE I
Scott County, Minnesota
NOTES TO THE FINANCIAL STATEMENTS I
December 31, 2008
NOTE 5 - CAPITAL ASSETS I
Capital asset activity for the year ended December 31,2008 was as follows: I
Beginning Ending I
Balance Increases Decreases Balance
Governmental Activities:
Capital Assets not being
Depreciated: I
Land $ 19,271,560 $ - $ - $ 19,271,560
Construction in Progress 187,868 - 187,868 -
Total Capital Assets I
not being Depreciated 19,459,428 - 187,868 19,271,560
Capital Assets being
Depreciated: I
Buildings 32,812,022 885,403 196,034 33,501,391
Infrastructure 124,544,337 1,899,050 - 126,443,387
Machinery and Equipment 12,012,076 1,787,518 645,008 13,154,586 I
Total Capital Assets
being Depreciated 169,368,435 4,571,971 841,042 173,099,364
Less Accumulated I
Depreciation for:
Buildings 6,137,880 857,897 162,504 6,833,273
Infrastructure 39,861,321 4,149,903 - 44,011,224 I
Machinery and Equipment 4,569,246 829,705 397,317 5,001,634
Total Accumulated
Depreciation 50,568,447 5,837,505 559,821 55,846,131 I
Total Capital Assets being
Depreciated, Net 118,799,988 (1,265,534) 281,221 117,253,233
I
Governmental Activities Capital
Assets, Net $ 138,259,416 $ (1,265,534) $ 469,089 $136,524,793
I
I
I
I
54 I
I
I CITY OF SHAKOPEE
I Scott County, Minnesota
NOTES TO THE FINANCIAL STATEMENTS
December 31, 2008
I
NOTE 5 - CAPITAL ASSETS
I Beginning Ending
Balance Increases Decreases Balance
I Business-Type Activities:
Capital Assets not being
Depreciated:
Land $ 6,088,241 $ 3,039,541 $ - $ 9,127,782
I Construction in Progress 1,206,959 3,016,505 4,222,723 741
Total Capital Assets
not being Depreciated 7,295,200 6,056,046 4,222,723 9,128,523
I Capital Assets being Depreciated:
Plant in Service 158,339,152 5,252,795 3,772,717 159,819,230
I Machinery and Equipment 1,682,349 770,432 143,082 2,309,699
Total Capital Assets
being Depreciated 160,021,501 6,023,227 3,915,799 162,128,929
I Less Accumulated
Depreciation for:
Plant in Service 31,454,195 3,788,805 34,752 35,208,248
I Machinery and Equipment 719,136 219,479 109,237 829,378
Total Accumulated
Depreciation 32,173,331 4,008,284 143,989 36,037,626
I Total Capital Assets being
Depreciated, Net 127,848,170 2,014,943 3,771,810 126,091,303
I Business-Type Activities Capital
Assets, Net $ 135,143,370 $ 8,070,989 $ 7,994,533 $ 135,219,826
I The $ 3,039,541 increase in land is a reclassification of storm ponds from plant in service since
the City has chosen not to depreciate these assets due to their nature.
I
I
I
I
I 55
I
CITY OF SHAKOPEE I
Scott County, Minnesota I
NOTES TO THE FINANCIAL STATEMENTS
December 31,2008 I
NOTE 5 - CAPITAL ASSETS
Depreciation expense was charged to functions/programs of the City as follows: I
Governmental Activities: I
General Government $ 260,010
Public Safety 490,511
Public Works 4,455,271 I
Park and Recreation 631,713
Total Depreciation Expense - Governmental Activities $ 5,837,505 I
Business-Type Activities:
Electric $ 1,392,372 I
Water 1,260,880
Sanitary Sewer 707,395
Storm Drainage 647,637 I
Total Depreciation Expense - Business-Type Activities $ 4,008,284
NOTE 6 - LONG-TERM DEBT I
A. General Obligation Bonds I
The City issues General Obligation (G.O.) Bonds to provide for financing tax increment projects
and street improvements. Debt service is covered respectively by tax increments and special I
assessments against benefited properties with any shortfalls being paid from general taxes.
G.O. Bonds are direct obligations and pledge the full faith and credit of the City. These Bonds I
generally are issued as serial bonds with equal debt service payments each year. G.O. Bonds
currently outstanding are shown on the following page.
B. Revenue Bonds I
The City issues Revenue Bonds for electric and water activity. I
Debt service is covered through the revenue producing activities ofthese funds.
I
I
56 I
I
I CITY OF SHAKOPEE
I Scott County, Minnesota
NOTES TO THE FINANCIAL STATEMENTS
December 31,2008
I
NOTE 6 - LONG-TERM DEBT
I C. Components of Long-Term Liabilities
I Issue Interest Original Final Principal Due Within
Date Rates Issue Maturity Outstanding One Year
Governmental Activities:
G.O. Bonds:
I G.O. Improvement Bonds:
19978 11/05/97 4.40%-4.75% $ 1,805,000 02/01/09 $ 70,000 $ 70,000
1998B 12/01/98 4.0%-4.4% 2,375,000 02/01/10 390,000 195,000
2000A 09/19/00 4.45%-4.95% 2,560,000 02/01111 705,000 240,000
I 2002A 02/01/02 3.0%-4.3% 1,185,000 02/01/12 540,000 130,000
2002B 07/01/02 2.0%-4.1 % 3,750,000 02/01/13 1,010,000 210,000
2003A 07/01/03 2.0%-3.0% 2,215,000 02/01/14 925,000 130,000
2004A 05/01/04 2.25%-4.10% 4,225,000 02/01/25 3,035,000 480,000
I G.O. Building Refunding
Bonds 2004B 05/01/04 2.25%-4.00% 2,275,000 02/01/17 1,780,000 175,000
G.O. Improvement Bonds
2004C JI/O 1/04 3.0%-4.0% 2,570,000 02/01/15 1,770,000 250,000
I G.O. Capital Improvement
Bonds 2004D I 1/01/04 2.5%-4.2% 6,000,000 02/01/25 5,385,000 235,000
G.O. Improvement Bonds
2006A 07/01/06 4.00% 3,440,000 02/01/17 3,130,000 315,000
I G.O. Improvement Bonds
2007 A 02/01/07 4.00% 1,370,000 02/01/17 1,260,000 110,000
G.O. Improvement Bonds
2007B 09/01/07 4.00% 1,445,000 02/01/18 1,445,000 120,000
G.O. Improvement Bonds
I 2008A 09/01/08 3.5%-4.0% 2,170,000 02/01/19 2,170,000 -
Total G.O. Bonds 23,615,000 2,660,000
Compensated Absences 1,434,766 710,577
I Net OPEB Obligation 233,153 -
Total Governmental
Activities $ 25.282.919 $ 3,370,577
I Issue Interest Original Final Principal Due Within
Date Rates Issue Maturitv Outstanding One Year
Business-Type Activities:
I Revenue Bonds:
Utility Revenue Bonds 1999 12/06/99 5.00% $ 9,850,000 02/01/28 $ 145,000 $ 145,000
Utility Revenue Bonds 2001 06/01/01 4.25%-5.12% 12,000,000 02/01/30 10,555,000 275,000
Utility Refunding Revenue
Bonds 2003A 05/01/03 2.25%-4.45% 3,385,000 08/01/18 2,450,000 210,000
I Utility Refunding Revenue
Bonds 2004A 1 % 1/04 3.5%-4.5% 9,830,000 02/01/28 9,505,000 80,000
Utility Refunding Revenue
Bonds 2006A 1lI0 1/06 4.125%-4.375% 10,570,000 02/01/30 10,570,000
I Total Revenue Bonds 33,225,000 710,000
Compensated Absences 50,540 29,423
Net OPEB Obligation 7,400 -
I Total Business-Type
Activities $ 33.232.400 $ 710,000
I 57
I
CITY OF SHAKOPEE I
Scott County, Minnesota
NOTES TO THE FINANCIAL STATEMENTS I
December 31,2008
I
NOTE 6 - LONG-TERM DEBT
C. Components of Long-Term Liabilities (Continued) I
Long-term bonded indebtedness listed on the previous page were issued to finance acquisition I
and construction of capital facilities or to refinance (refund) previous bond issues.
On November 1, 2006, the Shakopee Public Utilities Commission issued $ 10,570,000 Public I
Utilities Crossover Refunding Revenue Bonds, Series 2006A, to crossover refund $ 10,280,000
of the $ 10,555,000 currently outstanding of the $ 12,000,000 Shakopee Public Utilities Revenue
Bonds, Series 2001 on February 1,2009.
D. Changes in Long-Term Liabilities I
Long-term liability information for the year ended December 31, 2008 was as follows. I
Beginning Ending
Balance Additions Reductions Balance I
Governmental Activities:
Bonds Payable:
G.O. Bonds $ 24,725,000 $ 2,170,000 $ 3,280,000 $ 23,615,000
Compensated Absences 1,290,398 877,016 732,648 1,434,766 I
Net OPEB Obligation - 233,153 - 233,153
Total Governmental Activities $ 26,015,398 $ 3,280,169 $ 4,012,648 $ 25,282,919 I
Business-Type Activities:
Revenue Bonds $ 33,895,000 $ - $ 670,000 $ 33,225,000
Bond Premium 49,112 - 4,715 44,397 I
Deferred Refunding Costs (I,O 19,672) - (54,138) (965,534)
Compensated Absences 49,538 6,088 5,086 50,540
Compensated Absences - 7,400 - 7,400
I
Total Business-Type Activities $ 32,973,978 $ 13,488 $ 625,663 $ 32,361 ,803
The General Fund, Recreation Special Revenue Fund, Employee Benefits Internal Service Fund I
and Sewer and Storm Drainage Enterprise Funds typically liquidate the liability related to
compensated absences.
I
I
I
58 I
I
I CITY OF SHAKOPEE
I Scott County, Minnesota
NOTES TO THE FINANCIAL STATEMENTS
December 31, 2008
I
NOTE 6 - LONG-TERM DEBT
I E. Governmental Activity General Obligation Bonds
I Debt service to maturity for outstanding G.O. Bonds is as follows:
Year Ending
I December 31, Principal Interest Total
2009 $ 2,660,000 $ 859,610 $ 3,519,610
I 2010 2,930,000 766,109 3,696,109
2011 2,375,000 669,092 3,044,092
2012 2,265,000 583,384 2,848,384
I 2013 2,245,000 521,603 2,766,603 .
2014-2018 7,635,000 1,432,010 9,067,010
2019-2023 2,485,000 500,230 2,985,230
I 2024-2028 1,020,000 47,460 1,067,460
Total $23,615,000 $5,379.498 $28,994,498
I F. Business-Type Activity Revenue Bonds
I Debt service to maturity for outstanding revenue bonds is as follows:
Year Ending
December 31, Principal Interest Total
I 2009 $ 710,000 $ 1,251,898 $ 1,961,898
I 2010 1,055,000 1,443,241 2,498,241
2011 1,080,000 1,401,393 2,481,393
2012 1,145,000 1,357,015 2,502,015
I 2013 1,155,000 1,310,225 2,465,225
2014-2018 6,620,000 5,726,187 12,346,187
2019-2023 8,270,000 4,049,445 12,319,445
I 2024-2028 10,165,000 1,921,579 12,086,579
2029-2030 3,025,000 145,884 3,170,884
I Total $ 33,225,000 $18,606,867 $ 51,831,867
I
I 59
I
CITY OF SHAKOPEE I
Scott County, Minnesota I
NOTES TO THE FINANCIAL STATEMENTS
December 31,2008
I
NOTE 7 - CONDUIT DEBT OBLIGATIONS
Conduit debt obligations are certain limited obligation revenue bonds or similar debt instruments I
issued for the express purpose of providing capital financing for a specific third party. The City
has issued various revenue bonds to provide funding to private-sector entities for projects I
deemed to be in the public interest. Although these bonds bear the name of the City, the City has
no obligation for such debt beyond the resources provided by related leases or loans.
Accordingly, the bonds are not reported as liabilities in the financial statements of the City. I
As of December 31,2008, the following conduit debt was outstanding:
Date of Original Amount Balance I
Project Issue of Issue Retired Outstanding
St. Francis RMC 10/06/04 $ 52,520,000 $ 2,340,000 $ 50,180,000 I
St. Francis RMC 12/23/87 8,000,000 3,210,000 4,790,000
Total $ 54,970,000 I
NOTE 8 - PLEDGING AGREEMENTS 'I
The City has pledged its taxing authority to back certain revenue bonds issued by the Scott
County Community Development Agency (CDA), formally known as the Scott County Housing I
and Redevelopment Authority (HRA), for the Blocks 3 and 4 redevelopment project in
downtown Shakopee. Refunding bonds were issued during 2006 to advance refund the 1997 A,
1997D and 1997E Series Bonds on their call dates. The 1997D Series Bonds were called on I
September 1, 2006 and the 1997A and 1997E Series Bonds were called on February 1, 2008.
The outstanding issues at December 31, 2008 were:
. Scott County CDA Housing Development Refunding Revenue Bonds, Series 2006A, the I
amount is $ 3,260,000 and payments are scheduled from February 1,2007 to 2027, with
interest ranging from 4.25% to 4.5%. I
. Scott County CDA Housing Development Refunding Revenue Bonds, Series 2006D, the
amount is $ 925,000 and payments are scheduled from February 1, 2007 to 2016, with
interest ranging from 5.7% to 6.25%. I
. Scott County CDA Housing Development Refunding Revenue Bonds, Series 2006E, the
amount is $ 1,245,000 and payments are scheduled from February 1, 2018 to 2023, with I
interest ranging from 4.5% to 4.7%.
I
60 I
I
I CITY OF SHAKOPEE
I Scott County, Minnesota
NOTES TO THE FINANCIAL STATEMENTS
December 31, 2008
I
NOTE 8 - PLEDGING AGREEMENTS
I . Scott County CDA Housing Development Revenue Bonds, Series 1997 A, the original
amount was $ 3,220,000 and payments were scheduled from February 1,2002 to the call
I date of February 1,2008, with interest ranging from 4.10% to 5.38%.
Scott County CDA Taxable Tax Increment Development Revenue Bonds, Series 1997D,
.
I the original amount was $ 945,000 and payments were scheduled to the call date of
February 1, 2008, with interest ranging from 7.10% to 7.45.%.
. Scott County CDA Taxable Tax Increment Development Revenue Bonds, Series 1997E,
I the original amount is $ 1,170,000 and payment was scheduled for the call date of
February 1,2008, with interest at 5.38%.
I The City has pledged its taxing authority to back a series of revenue bonds issued by the Scott
County CDA for the North Ridge Court Redevelopment Project in downtown Shakopee. The
issue is:
I . Scott County CDA Housing Development Revenue Bonds, Series 2003, the amount is
$ 6,690,000 and payments are scheduled from February 1, 2006 to 2034, with interest
I ranging from 2.00% to 5.00%.
The City and the Shakopee EDA had a development agreement for costs related to a Seagate
I facility moving to Shakopee. The Shakopee EDA issued a Taxable Tax Increment Revenue Note
in the amount of$ 4,572,725 in support of development costs for the Seagate Project. Seagate
was the holder of the note, which expired in December of2008. The Shakopee EDA was liable
I only to the extent of the tax increment received from the Seagate property. The interest on the
note was 7.5%.
I The City and the Shakopee EDA have a development agreement for costs related to an Imagine!
Print Solutions, formally known as Challenge Printing, facility moving to Shakopee. The
Shakopee EDA issued a Taxable Tax Increment Revenue Note in the amount of$ 513,900 in
I support of development costs for the Imagine! Print Solutions project. Imagine! Print Solutions
is the holder of the note. The Shakopee EDA is liable only to the extent of the tax increment
received from the Imagine! Print Solutions property. The interest on the note is 6.0%. Payments
are scheduled semiannually from August 1,2006 to February 1,2015.
I The City and the Shakopee EDA have a development agreement for costs related to Open
Systems facility located in Shakopee. The Shakopee EDA issued a Taxable Tax Increment
I Revenue Note in the amount of $ 125,000 in support of development costs for the Open Systems
Project. Open Systems is the holder of the note. The Shakopee EDA is liable only to the extent
of the tax increment received from the Open Systems property. The interest on the note is 6.0%.
I Payments are scheduled semiannually from August 1,2007 to February 1,2014.
I 61
I
CITY OF SHAKOPEE I
Scott County, Minnesota I
NOTES TO THE FINANCIAL STATEMENTS
December 31, 2008
I
NOTE 9 - INTERFUND ASSETS/LIABILITIES
The composition of inter fund balances as of December 31,2008 is as follows: I
Receivable Fund Payable Fund Amount I
General Fund Nonmajor Governmental Funds $ 35,000
General Fund Electric Fund 36,293 I
Electric Fund Sewer Fund 24,480
Electric Fund Water Fund 1,029,246
Water Fund General FUnd 55,076 I
Water Fund Storm Drainage Fund 8,160
Sewer Fund Nonmajor Governmental Funds 1,650,000
Total $ 2,838,255 I
The due from/due to other funds balances generally represent borrowing to resolve deficit cash I
balances and billing expenses. The $1,650,000 balance represents an advance from the Sewer
Fund to the Park Reserve Fund which will be repaid in annual payments ranging from $ 350,000
to $ 450,000 through 2012. I
NOTE 10 - INTERFUND TRANSFERS
Transfer In I
Nonmajor futernal
General Governmental Service
Fund Funds Funds Total I
Transfer Out:
General Fund $ - $ 1,427,478 $ ~ $ 1,427,478
Nonmajor Governmental Funds 114,130 683,084 - 797,214 I
Electric Fund 1,151,428 - - 1,151,428
Water Fund 651,924 - - 651,924
Sewer Fund 25,000 14,819 - 39,819
Storm Drainage Fund 48,040 24,293 - 72,333 I
Internal Service Funds - 465,497 140,615 606,112
Total $ 1,990,522 $ 2,615,171 $ 140,615 $ 4,746,308 I
General Fund transfers in the amount of$ 1,145,010 were made to the Recreation Fund for
operating purposes, $ 29,200 to the Shakopee EDA Fund for tax abatements and $ 93,945 and I
$ 159,323 to the 2007B and 2008A Improvement Bonds Debt Service Funds, respectively, for
debt service levy.
I
62 I
I
I CITY OF SHAKO PEE
Scott County, Minnesota
I NOTES TO THE FINANCIAL STATEMENTS
December 31, 2008
I
NOTE 10 - INTERFUND TRANSFERS
I A transfer in the amount of $ 3,328 was made from the I 996A Improvement Bonds Debt Service
Fund to the 1997B Improvement Bonds Debt Service Fund to close out the I 996A Improvement
I Bonds Debt Service Fund. Transfers in the amount of$ 213,188 and $ 228,887 were made from
the 2005 and 2006 Capital Projects Funds, respectively, to the 2006A Improvement Bonds Debt
Service Fund to close the 2005 and 2006 Capital Projects Funds. Transfers in the amount of
I $ 19,203 were made from the 2007 Capital Projects Fund to the 2007B Improvement Bonds Debt
Service Fund to close the 2007 Capital Projects Fund. Other transfers between nonmajor
governmental funds were made for operating purposes.
I A transfer in the amount of $ 465,497 was made from the Buildings Internal Service Fund to the
2004D Improvement Bonds Debt Service Fund to cover the debt service payment on this debt. A
transfer of equipment in the amount of $ 140,615 was made from the Buildings Internal Service
I Fund to the Park Assets Internal Service Fund to transfer park related assets to the new Park
Assets Internal Service Fund.
I Transfers from the business-type funds were made to assist with financing of various activities in
the recipient funds.
I NOTE 11 - FUND EQUITY /NET ASSETS
Fund equity or net assets are the residual or net assets of a given fund. Fund equity is what is left
I over when the total liabilities of a fund are deducted from its total assets. Governmental funds
refer to a fund's net assets as fund balance. The government-wide Statement of Net Assets and
the City's proprietary fund financial statements refer to a fund's residual assets as net assets.
I Governmental fund balance is divided into three major categories: reserved, designated and
unreserved. Reservations of governmental fund balance are used to quantify the amount of a
fund's net assets that are not available to meet the current financial needs of the City.
I Designations are used to indicate a future use has been identified for net assets that are available
for current financial needs. Finally, unreserved fund balance is a measure of a governmental
fund's net resources available for current financial needs.
I The government-wide Statement of Net Assets and the proprietary fund financial statements
divide net assets into the following components: net assets invested in capital assets, net of
I related debt, restricted net assets and unrestricted net assets. Restricted net assets are required to
be reported when external parties mandate their restriction.
I
I
I 63
I
CITY OF SHAKOPEE I
Scott County, Minnesota I
NOTES TO THE FINANCIAL STATEMENTS
December 31, 2008
I
NOTE 12 - RISK MANAGEMENT
The City purchases commercial insurance coverage through the League of Minnesota Cities I
Insurance Trust (LMCIT) with other cities in the state which is a public entity risk pool currently
operating as a common risk management and insurance program. The City pays an annual I
premium to the LMCIT for its insurance coverage. The LMCIT. is self-sustaining through
commercial companies for excess claims. The City is covered through the pool for any claims
incurred but unreported, but retains risk for the deductible portion of its insurance policies. The I
amount ofthese deductibles ranges from $ 2,500 to $ 5,000 and is considered immaterial to the
financial statements.
There were no significant reductions in insurance from the previous year or settlements in excess I
of insurance coverage for any of the past three fiscal years.
Through the pool, the City is subject to reassessment but due to reserves and reinsurance I
contracts, the likelihood is very low. The policy limits through the pool included $ 1,200,000
aggregate for liability, $ 1,200,000 for automobile coverage, $ 100,000 faithful performance
employee bonding and $ 1,000,000 for universal umbrella coverage. Property coverage is at I
approximately $ 89,000,000.
NOTE 13 - DEFINED BENEFIT PENSION PLANS - STATEWIDE I
Public Employees' Retirement Association
A. Plan Description I
All full-time and certain part-time employees ofthe City are covered by defined benefit pension I
plans administered by the Public Employees' Retirement Association of Minnesota (PERA).
PERA administers the Public Employees' Retirement Furtd (PERF) and the Public Employees'
Police and Fire Fund (PEPFF), which are cost-sharing, multiple-employer retirement plans. I
These Plans are established and administered in accordance with Minnesota Statutes Chapters
353 and 356.
PERF members belong to either the Coordinated or Basic Plan. Coordinated Plan members are I
covered by social security and Basic Plan members are not. All new members must participate in
the Coordinated Plan. All police officers, firefighters and peace officers who qualify for
membership by statute are covered by the PEPFF. I
PERA provides retirement benefits as well as disability benefits to members, and benefits to
survivors upon death of eligible members. Benefits are established by state statute, and vest after I
three years of credited service. The defined retirement benefits are based on a member's highest
average salary for any five successive years of allowable service, age and years of credit at
termination of service. I
64 I
I
I CITY OF SHAKOPEE
I Scott County, Minnesota
NOTES TO THE FINANCIAL STATEMENTS
December 31, 2008
I
NOTE 13 - DEFINED BENEFIT PENSION PLANS - STATEWIDE
I Public Employees' Retirement Association (Continued)
I A. Plan Description (Continued)
Two methods are used to compute benefits for PERA' s Coordinated and Basic Plan members.
I The retiring member receives the higher of a step-rate benefit accrual formula (Method 1) or a
level accrual formula (Method 2). Under Method 1, the annuity accrual rate for a Basic Plan
member is 2.2% of average salary for each of the first 10 years of service and 2.7% for each
I remaining year. The annuity accrual rate for a Coordinated Plan member is 1.2% of average
salary for each of the first 10 years and 1.7% for each remaining year. Under Method 2, the
annuity accrual rate is 2.7% of average salary for Basic Plan members and 1.7% for Coordinated
Plan membersfor each year of service. For PEPFF members, the annuity accrual rate is 3.0% for
I each year of service. For all PERF and PEPFF members hired prior to July 1, 1989, whose
annuity is calculated using Method 1, a fun annuity is available when age plus years of service
equal 90. Normal retirement age is 55 for PEPFF members and 65 for Basic and Coordinated
I Plan members hired prior to July 1, 1989. Normal retirement age is the age for unreduced social
security benefits capped at 66 for Coordinated Plan members hired on or after July 1, 1989. A
reduced retirement annuity is also available to eligible members seeking early retirement.
I There are different types of annuities available to members upon retirement. A single-life
annuity is a lifetime annuity that ceases upon the death of the retiree - no survivor annuity is
I payable. There are also various types of joint and survivor annuity options available which will
be payable over joint lives. Members may also leave their contributions in the Fund upon
termination of public service in order to qualify for a deferred annuity at retirement age. Refunds
I of contributions are available at any time to members who leave public service, but before
retirement benefits begin.
I The benefit provisions stated in the previous paragraphs of this section are current provisions and
apply to active Plan participants. Vested, terminated employees who are entitled to benefits but ,^
are not yet receiving them are bound by the provisions in effect at the time they last terminated
their public service.
I PERA issues a publicly available financial report that includes financial statements and required
supplementary information for PERF and PEPFF. That report may be obtained on the Internet at
I www.mnpera.org, by writing to PERA at 60 Empire Drive, Suite 200, St. Paul, Minnesota
55103-2088 or by calling (651) 296-7460 or (800) 652-9026.
I
I
I 65
I
CITY OF SHAKOPEE 'I
Scott County, Minnesota I
NOTES TO THE FINANCIAL STATEMENTS
December 31, 2008
I
NOTE 13 - DEFINED BENEFIT PENSION PLANS - STATEWIDE
Public Employees' Retirement Association (Continued) I
B. Funding Policy I
Minnesota Statutes Chapter 353 sets the rates for employer and employee contributions. These
Statutes are established and amended by the state legislature. The City makes annual I
contributions to the pension plans equal to the amount required by state statutes. PERF Basic
Plan members and Coordinated Plan members were required to contribute 9.10% and 6.0%,
respectively, oftheir annual covered salary in 2008. PEPFF members were required to contribute I
8.6% of their annual covered salary in 2008. That rate will increase to 9.4% in 2009. The City is
required to contribute the following percentages of annual covered payroll: 11.78% for Basic
Plan PERF members, 6.5% for Coordinated Plan PERF members and 12.9% for PEPFF
members. Employer contribution rates for the Coordinated Plan and PEPFF will increase to I
6.75% and 14.1 %, respectively, effective January 1, 2009. The City's contributions to the PERF
for the years ending December 31,2008,2007 and 2006 were $ 483,329, $ 452,967 and
$ 410,849, respectively. The City's contributions to the PEPFF for the years ending I
December 31,2008,2007 and 2006 were $ 415,440, $ 359,836 and $ 278,056, respectively. The
City's contributions were equal to the contractually required contributions for each year as set by
state statute. I
C. Sbakopee Volunteer Fire Relief Association
The City contributes to the Shakopee Volunteer Fire Department Relief Association (the I
"Association") that provides pension benefits to its members under a single employer defined
benefit plan. Since fire department members are volunteers, contributions to the Association are I
not based on payroll, but rather on years of active service. All active firefighters may apply for
membership in the Association and shall become a member immediately upon approval by the
Board of Trustees.
The City's contribution to the Association is determined by multiplying $ 7,500 by the number of I
years of active service completed by members of the Association for the plan year, prorated by
months for members who did not complete a full year of active service. Required and actual I
employer contributions to the plan during 2008 were $ 187,451. Members ofthe Association are
not allowed to make voluntary contributions to the Plan.
I
I
I
66 I
I
I CITY OF SHAKOPEE
I Scott County, Minnesota
NOTES TO THE FINANCIAL STATEMENTS
I December 31,2008
NOTE 14 - POST EMPLOYMENT HEALTH BENEFITS PLAN
I A. Plan Description
I The City provides a single-employer defined benefit health care plan to eligible retirees and their
spouses. The plan offers medical coverage administered by Medica. It is the City's policy to
periodically review its medical coverage and to obtain requests for proposals in order to provide
I the most favorable benefits and premiums for City employees and retirees.
B. Funding Policy
I Retirees and their spouses contribute to the health care plan at the same rate as City employees.
This results in the retirees receiving an implicit rate subsidy. Contribution requirements are
I established by the City, based on the contract terms with Medica. The required contributions are
based on projected pay-as-you-go financing requirements. For fiscal year 2008, the City
contributed $ 0 to the plan. As of January 1, 2008, there were ten retirees receiving health
benefits from the City's health plan.
I C. Annual Other Post Employment Benefit Cost and Net Other Post Employment Benefit
Obligation
I The City's annual other post employment benefit (OPEB) cost (expense) is calculated based on
the annual required contribution (ARC) ofthe City, an amount actuarially determined in
I accordance with the parameters ofGASB Statement No. 45. The ARC represents a level of
funding that, if paid on an ongoing basis, is projected to cover normal cost each year and
amortize any unfunded actuarial liabilities (or funding excess) over a period not to exceed 30
I years. The following table shows the components of the City's annual OPEB cost of the year, the
amount actually contributed to the plan, and changes in the City's net OPEB obligation to the
plan.
I Annual Required Contribution $ 240,553
Interest in Net OPEB Obligation -
I Adjustment to Annual Required Contribution -
Annual OPEB Cost (Expense) 240,553
Contribution Made -
I Increase in Net OPEB Obligation 240,553
Net OPEB Obligation - Beginning of Year -
I Net OPEB Obligation - End of Year $ 240,553
I
I 67
I
CITY OF SHAKO PEE I
Scott County, Minnesota I
NOTES TO THE FINANCIAL STATEMENTS
December 31, 2008 I
NOTE 14 - POST EMPLOYMENT HEALTH BENEFITS PLAN
C. Annual Other Post Employment Benefit Cost and Net Other Post Employment Benefit I
Obligation (Continued)
The City's annual OPEB cost, the percentage of annual OPEB cost contributed to the plan and I
the net OPEB obligation for 2008 was as follows:
Percentage of I
Fiscal Year Annual OPEB Employer Annual OPEB Net OPEB
End Cost Contribution Cost Contributed Obligation I
12/31/08 $ 240,553 $ - 0% $ 240,553
D. Funded Status and Funding Progress I
As of January 1, 2007, the most recent actuarial valuation date, the City had no assets deposited to I
fund the plan. The actuarial accrued liability for benefits was $ 1,887,961 and the actuarial value
of assets was $ 0, resulting in an unfunded actuarial accrued liability (VAAL) of$ 1,887,961. The
covered payroll (annual payroll of active employees covered by the plan) was $ 6,652,669, and the I
ratio of the VAAL to the covered payroll was 28.4%.
Actuarial valuations involve estimates of the value of reported amounts and assumptions about I
the probability of occurrence of events far into the future. Examples include assumptions about
future employment, mortality and the health care cost trend. Amounts determined regarding the
funded status of the plan and the annual required contributions ofthe employer are subject to I
continual revision as actual results are compared with past expectations and new estimates are
made about the future.
The Schedule of Funding Progress, presented as required supplementary information following I
the Notes to the Financial Statements, presents multi-year trend information about whether the
actuarial value of plan assets is increasing or decreasing over time relative to the actuarial I
accrued liabilities for benefits.
E. Actuarial Methods and Assumptions
Projections of benefits for financial reporting purposes are based on the substantive plan (the I
plan as understood by the employer and the plan members) and include the types of benefits
provided at the time of each valuation and the historical pattern of sharing of benefit costs I
between the employer and plan members to that point. The actuarial methods and assumptions
used include techniques that are designed to reduce the effects of short-term volatility in actuarial
accrued liabilities, consistent with the long-term perspective of the calculations. I
68 I
I
I CITY OF SHAKOPEE
I Scott County, Minnesota
NOTES TO THE FINANCIAL STATEMENTS
I December 31, 2008
NOTE 14 - POST EMPLOYMENT HEALTH BENEFITS PLAN
I E. Actuarial Methods and Assumptions (Continued)
I In the January 1, 2007 actuarial valuation, the projected unit credit actuarial cost method was
used. The actuarial assumptions included a 4.0 % discount rate, which is based on the
investment yield expected to finance benefits depending on whether the plan is funded in a
I separate trust (about 7% to 8.5%, long-term, similar to a pension plan) or unfunded (3.5% to 5%,
shorter term, based on City's general assets). The City currently does not plan to prefund for this
benefit. At the actuarial valuation date, the annual health care cost trend rate was calculated to be
I 9% initially, reduced incrementally to an ultimate rate of 5% after 5 years. The VAAL is being
amortized as a level percentage of payroll. The remaining amortization period at January 1, 2007
was 30 years.
I NOTE 15 - CONTINGENT LIABILITIES AND COMMITMENTS
The City is a currently a defendant in litigation with a developer concerning platting issues.
I Although the outcome ofthis lawsuit is not presently determinable, the resolution is not expected
to have a material adverse effect on the financial condition of the City.
I There are various uncompleted construction contracts as of year-end totaling approximately
$ 319,733 for work yet to be done. Completed work is reflected in the financial statements, work
yet to be done is not.
I NOTE 16 - SEGMENT INFORMATION
I The City maintains four enterprise funds that account for the electric, water, sewer and storm
drainage utilities. The City considers each of its enterprise funds to be a segment. Since the
required segment information is already included in the City's proprietary funds' Balance Sheet
I and Statement of Revenues, Expenses and Changes in Net Assets balances, this information has
not been repeated in the Notes to the Financial Statements.
I
I
I
I
I 69
I
I
I
I
I
I
I
I
I
I
(THIS PAGE LEFT BLANK INTENTIONALL Y.)
I
I
I
I
'I
I
I
I
70 I
I
I
I
I
I
I
I
I
I
II
REQUIRED SUPPLEMENTARY INFORMATION
I
I
I
I
I
I
I
I
I 71
I
CITY OF SHAKOPEE I
Scott County, Minnesota
SCHEDULE OF FUNDING PROGRESS ~ POST EMPLOYMENT BENEFITS PLAN I
December 31,2008
Actuarial VAAL as a I
Actuarial Accrued Liability Unfunded Percentage of
Actuarial Value of (AAL) - AAL Funded Covered Covered I
Valuation Assets Entry Age (VAAL) Ratio Payroll Payroll
Date (a) (b) (b-a) (aIb) (c ) ((b-a)/c)
01/01/07* $ - $ 1,887,961 $ 1,887,961 0.0% $ 6,652,669 28.4% I
*This Schedule was implemented in 2008 and, therefore, contains only one year of data. See Note 14 in the Notes I
to the Financial Statements for more details on this Schedule. I
I
I
I
I
I
I
I
I
I
I
72 I
I
I
I
I
I
I
I
I
I
I NONMAJOR FUNDS
I
I
I
I
I
I
I
I
73
I
I
CITY OF SHAKOPEE I
Scott County, Minnesota
COMBINING BALANCE SHEET - I
NONMAJOR GOVERNMENTAL FUNDS
December 31, 2008
(Continued) I
Special Revenue
Revolving I
Forfeiture Transit Telecommunication SCDP Grant Loan
ASSETS: I
Cash and Investments $ 119,930 $ 1,972,110 $ 710,173 $ 68,899 $ 178,230
Taxes Receivable - Delinquent - - - - -
Special Assessments Receivable: I
Delinquent - - - - -
Deferred - - - - -
Accounts Receivable 830 53,761 86,783 - -
Interest Receivable 820 16,101 5,447 558 1,387 I
Notes Receivable - - - - 214,825
Total Assets $ 121,580 $ 2,041,972 $ 802,403 $ 69,457 $ 394,442 I
LIABILITIES AND FUND BALANCES:
Liabilities: I
Accounts Payable $ 3,930 $ 166,914 $ 12,761 $ - $ -
Contracts Payable - - - - -
Due to Other Funds - - - - -
Advances from Other Funds - - - - - I
Due to Other Governments - - - - 165,593
Deferred Revenue - - - - -
Total Liabilities 3,930 166,914 12,761 - 165,593 I
Fund Balances:
Reserved for:
Special Revenue 117,650 1,875,058 - 69,457 228,849 I
Capital Projects - - - - -
Unreserved, Reported in:
Special Revenue - Undesignated - - 789,642 - - I
Debt Service - Undesignated - - - - -
Capital Projects - Undesignated - - - - -
Total Fund Balances 117,650 1,875,058 789,642 69,457 228,849 I
Total Liabilities and
Fund Balances $ 121,580 $ 2,041,972 $ 802,403 $ 69,457 $ 394,442
I
I
I
74
I
I
I
I
I
Special Revenue Debt Service
I Economic 1997B 1998B 2000A 2002A
Development Improvement Improvement Improvement Improvement
Authority Recreation Total Bonds Bonds Bonds Bonds
I $ 444,565 $ 292,060 $ 3,785,967 $ 71,863 $ 273,164 $ 447,984 $ 343,150
2,142 - 2,142 - - - -
I - - - - 645 - 2
- - - - 49,051 185,554 92,585
- 100,007 241,381 - - - -
I 3,330 6,923 34,566 - 1,820 3,049 2,277
- - 214,825 - - - -
I $ 450,037 $ 398,990 $ 4,278,881 $ 71,863 $ 324,680 $ 636,587 $ 438,014
I $ - $ 58,180 $ 241,785 $ - . $ - $ - $ -
- - - - - - -
- - - - - - -
I - - - - - - -
- - 165,593 - - - -
2,142 - 2,142 - 49,696 185,554 92,587
I 2,142 58,180 409,520 - 49,696 185,554 92,587
I 447,895 - 2,738,909 - - - -
- - - - - - -
I - 340,810 1,130,452 - - - -
- - - 71,863 274,984 451,033 345,427
- - - - - - -
I 447,895 340,810 3,869,361 71,863 274,984 451,033 345,427
$ 450,037 $ 398,990 $ 4,278,881 $ 71,863 $ 324,680 $ 636,587 $ 438,014
I
I
I
7S
I
I
CITY OF SHAKOPEE I
Scott County, Minnesota
COMBINING BALANCE SHEET - I
NON MAJOR GOVERNMENTAL FUNDS
December 31, 2008
(Continued)
I
Debt Service
2002B 2003A 2004A 2004B 2004C I
Improvement Improvement Improvement Refunding Improvement
Bonds Bonds Bonds Bonds Bonds
ASSETS: I
Cash and Investments $ 722,745 $ 526,824 $ 1,112,&92 $ 355,257 $ 933,149
Taxes Receivable - Delinquent - - - 7,861 -
Special Assessments Receivable: I
Delinquent - - - - -
Deferred 1,015,201 359,901 2,482,475 - 701,255
Accounts Receivable - - - - -
Interest Receivable 4,730 4,575 8,289 2,065 6,501 I
Notes Receivable - - - - -
Total Assets $ 1,742,676 $ 891,300 $ 3,603,656 $ 365,183 $ 1,640,905 I
LIABILITIES AND FUND BALANCES:
Liabilities:
Accounts Payable $ - $ - $ - $ - $ - I
Contracts Payable - - - - -
Due to Other Funds - - - - -
Advances from Other Funds - - - - - I
Due to Other Governments - - - - -
Deferred Revenue 1,015,201 359,901 2,482,475 7,861 701,255
Total Liabilities 1,015,201 359,901 2,482,475 7,861 701,255 I
Fund Balances:
Reserved for:
Special Revenue - - - - - I
Capital Projects - - - - -
Unreserved, Reported in:
Special Revenue - Undesignated - - - - - I
Debt Service - Undesignated 727,475 531,399 1,121,181 357,322 939,650
Capital Projects - Undesignated - - - - -
Total Fund Balances 727,475 531,399 1,121,181 357,322 939,650 I
Total Liabilities and
Fund Balances $ 1,742,676 $ 891,300 $ 3,603,656 $ 365,183 $ 1,640,905
I
I
I
76
I
I
I
I
I
Debt Service Capital Projects
I 2004D 2006A 2007 A 2007B 200BA
Building Improvement Improvement Improvement Improvement
Bonds Bonds Bonds Bonds Bonds Total State Aid
I $ 480,387 $ 1,145,663 $ 158,216 $ 757,319 $ 278,080 $ 7,606,693 $ 4,299,103
- - - - - 7,861 -
I - 1,184 - 662 - 2,493 -
- 449,647 1,122,231 123,105 972,202 7,553,207 -
- - - - - - -
I 2,038 7,678 594 7,283 697 51,596 29,054
- - - - - - -
I $ 482,425 $ 1,604,172 $ 1,281,041 $ 888,369 $ 1,250,979 $ 15,221,850 $ 4,328,157
I $ - $ - $ - $ - $ - $ - $ -
- - - - - - -
- - - - - - -
I - - - - - - -
- - - - - - -
- 450,831 1,122,231 123,767 972,202 7,563,561 -
I - 450,831 1,122,231 123,767 972,202 7,563,561 -
I - - - - - - -
- - - - - - 4,328,157
I - - - - - - -
482,425 1,153,341 158,810 764,602 278,777 7,658,289 -
- - - - - - -
I 482,425 1,153,341 158,810 764,602 278,777 7,658,289 4,328,157
$ 482,425 $ 1,604,172 $ 1,281,041 $ 888,369 $ 1,250,979 $ 15,221,850 $ 4,328,157
I
I
I
77
I
I
CITY OF SHAKO PEE I
Scott County, Minnesota
COMBINING BALANCE SHEET - I
NONMAJOR GOVERNMENTAL FUNDS
December 31, 2008
(Continued)
I
Capital Projects
Capital East Dean's I
Park Reserve Improvements Lake 2007 Projects 2008 Projects
ASSETS: I
Cash and Investments $ 103,627 $ 3,612,337 $ 367,064 $ 794 $ 288,573
Taxes Receivable - Delinquent - - - - -
Special Assessments Receivable:
Delinquent - 12,656 - - - I
Deferred . 672,626 - - -
Accounts Receivable - - - - -
Interest Receivable 4,438 29,687 2,973 - - I
Notes Receivable - - - - -
Total Assets $ 108,065 $ 4,327,306 $ 370,037 $ 794 $ 288,573 I
LIABILITIES AND FUND BALANCES:
Liabilities:
Accounts Payable $ 67,484 $ 3,068 $ - $ 794 $ 41,373 I
Contracts Payable - - - - 71,954
Due to Other Funds - - . - -
Advances from Other Funds 1,650,000 - . - - I
Due to Other Governments - - - - -
Deferred Revenue - 685,282 - - -
Total Liabilities 1,717,484 688,350 - 794 113,327 I
Fund Balances:
Reserved for:
Special Revenue - - - - - I
Capital Projects - - 370,037 - ] 75,246
Unreserved, Reported in:
Special Revenue - Undesignated - - - - - I
Debt Service - Undesignated - - - - -
Capital Projects - Undesignated (1,609,419) 3,638,956 - - -
Total Fund Balances (1,609,419) 3,638,956 370,037 - 175,246 I
Total Liabilities and
Fund Balances $ 108,065 $ 4,327,306 $ 370,037 $ 794 $ 288,573
I
I
I
78
I
I
I
I
I
Capital Projects
I Total
Governmental
2009 Projects Total Funds
I $ 401 $ 8,671,899 $ 20,064,559
- - 10,003
I - 12,656 15,149
- 672,626 8,225,833
- - 241,381
I - 66,152 152,314
- - 214,825
I $ 401 $ 9,423,333 $ 28,924,064
I $ 126 $ 112,845 $ 354,630
- 71,954 71,954
35,000 35,000 35,000
I - 1,650,000 1,650,000
- - 165,593
- 685,282 8,250,985
I 35,126 2,555,081 10,528,162
I - - 2,738,909
- 4,873,440 4,873,440
I - - 1,130,452
- - 7,658,289
. (34,725) 1,994,812 1,994,812
I (34,725) 6,868,252 18,395,902
$ 401 $ 9,423,333 $ 28,924,064
I
I
I
79
I
I
CITY OF SHAKOPEE I
Scott County, Minnesota
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES -
NONMAJOR GOVERNMENTAL FUNDS I
For the Year Ended December 31, 2008
(Continued)
Special Revenue I
Revolving I
Forfeiture Transit Telecommunication SCDP Grant Loan
REVENUES:
Property Taxes $ - $ 7 $ - $ - $ - I
Tax Increments - - - - -
Special Assessments - - - - -
Licenses and Permits - - 336,918 - -
Intergovernmental: I
State Grants - 1,035,319 - - -
Other Grants and Aids - - - - -
Charges for Services - 31,090 - - - I
Fines and Forfeitures 76,008 - - - -
Miscellaneous:
Investment Income 5,707 107,681 36,952 3,740 13,925
Contributions and Donations - - - - - I
Other 18,567 - 882 - -
Total Revenues 100,282 1,174,097 374,752 3,740 13,925
EXPENDITURES: I
Current:
General Government - - 219,502 - -
Public Safety 48,398 - - - - I
Public Works - 1,055,267 - - -
Culture and Recreation - - - - -
Economic Development - - - - -
Debt Service: I
Principal - - - - -
Interest and Other Charges - - - - 3,835
Capital Outlay - - - - - I
Total Expenditures 48,398 1,055,267 219,502 - 3,835
Excess of Revenues Over
(Under) Expenditures 51,884 118,830 155,250 3,740 10,090 I
OTHER FINANCING SOURCES (USES):
Bonds Issued - - - - - I
Premium on Bonds Issued - - - - -
Transfers In - - - - -
Transfers Out - (11,200) (6,500) - -
Total Other Financing Sources (Uses) - (11,200) (6,500) - - I
Net Change in Fund Balances 51,884 107,630 148,750 3,740 10,090
FUND BALANCES: I
Beginning of Year 65,766 1,767,428 640,892 65,717 218,759
End of Year $ 117,650 $ 1,875,058 $ 789,642 $ 69,457 $ 228,849 I
80
I
I
I
I
I Special Revenue Debt Service
Economic 1996A 1997B 1998B 2000A 2002A
I Development Improvement Improvement Improvement Improvement Improvement
Authority Recreation Total Bonds Bonds Bonds Bonds Bonds
I $ 77,082 $ . $ 77,089 $ 20,000 $ 75,000 $ 62,238 $ 56,167 $ 95,786
- . - - - . - -
- - - - 27,329 50,978 103,929 37,032
- - 336,918 - - - - -
I
. . 1,035,319 - . - - -
31,440 . 31,440 - - - - -
I - 1,084,929 1,116,019 - - - - -
- - 76,008 - - . - -
22,746 48,020 238,771 - - 10,884 18,899 14,641
I - . - - - - - -
- 13,867 33,316 - . - - -
131,268 1,146,816 2,944,880 20,000 102,329 124,100 178,995 147,459
I
- - 219,502 - - - - -
I - - 48,398 - - - - -
- - 1,055,267 - - - - -
- 2,289,199 2,289,199 - - - - -
72,418 - 72,418 - - - - -
I - - - 150,000 105,000 195,000 240,000 130,000
- - 3,835 4,926 6,564 21,691 40,569 25,657
I - 14,480 14,480 - - - - -
72,418 2,303,679 3,703,099 154,926 111,564 216,691 280,569 155,657
I 58,850 (1,156,863) (758,219) (134,926) (9,235) (92,591) (101,574) (8,198)
I - - - - - - - -
- - - - - - - -
36,140 1,145,010 1,181,150 - 32,809 . - -
(19,200) . (36,900) (3,328) - - - -
I 16,940 1,145,010 1,144,250 (3,328) 32,809 - - .
75,790 (11,853) 386,031 (138,254) 23,574 (92,591 ) (101,574) (8,198)
I 372,105 352,663 3,483,330 138,254 48,289 367,575 552,607 353,625
I $ 447,895 $ 340,810 $ 3,869,361 $ - $ 71,863 $ 274,984 $ 451,033 $ 345,427
81
I
I
CITY OF SHAKOPEE I
Scott County, Minnesota
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES-
NONMAJOR GOVERNMENTAL FUNDS I
For the Year Ended December 31, 2008
(Continued)
Debt Service I
2002B 2003A 2004A 2004B 2004C
Improvement Improvement Improvement Refunding Improvement I
Bonds Bonds Bonds Bonds Bonds
REVENUES:
Property Taxes $ - $ - $ - $ 201,195 $ 144,965 I
Tax Increments - - - - -
Special Assessments 317,250 22,211 251,507 - 127,637
Licenses and Permits - - - - -
Intergovernmental: I
State Grants - - - - -
Other Grants and Aids - - - - -
Charges for Services - - - - - I
Fines and Forfeitures - - - - -
Miscellaneous:
Investment Income 26,910 28,645 53,121 13,461 41,280
Contributions and Donations - - - - - I
Other - - - - -
Total Revenues 344,160 50,856 304,628 214,656 313,882
EXPENDITURES; I
Current:
General Government - - - - -
Public Safety - - - - - I
Public Works - - - - -
Culture and Recreation - - - - -
Economic Development - - - - -
Debt Service: I
Principal 715,000 185,000 495,000 165,000 250,000
Interest and Other Charges 52,028 88,024 119,675 67,870 66,399
Capital Outlay - - - - - I
Total Expenditures 767,028 273,024 614,675 232,870 316,399
Excess of Revenues Over
(Under) Expenditures (422,868) (222,168) (310,047) (18,214) (2,517) I
OTHER FINANCING SOURCES (USES):
Bonds Issued - - - - - I
Premium on Bonds Issued - - - - -
Transfers In - - - - -
Transfers Out - - - - -
Total Other Financing Sources (Uses) - - - - - I
Net Change in Fund Balances (422,868) (222,168) (310,047) (18,214) (2,517)
FUND BALANCES: I
Beginning of Year 1,150,343 753,567 1,431,228 375,536 942,167
End of Year $ 727,475 $ 531,399 $ 1,121,181 $ 357,322 $ 939,650 I
82
I
I
I
I
I Debt Service Capital Projects
I 20040 200M 2007 A 2007B 2008A
Building Improvement Improvement Improvement Improvement
Bonds Bonds Bonds Bonds Bonds Total State Aid Park Reserve
I $ - $ 345,274 $ 8,742 $ 91,083 $ - $ 1,100,450 $ " $ -
- - - - - - - -
- 116,166 159,677 44,100 114,445 1,372,261 - -
- - - - - - - 193,606
I
- - - - - - 1,254,822 20,000
- - - - - - - -
I - - - - - - - -
- - - - - - - -
9,978 24,453 3,779 36,927 5,513 288,491 194,788 25,631
I - - - - - - - 493,900
- - - - - - - 1,758
9,978 485,893 172,198 172,110 119,958 2,761,202 1,449,6 I 0 734,895
I
- - - - - - - -
I - - " - - - - -
" - - - - - - -
- - - - - - - -
- - - - - - - -
I 230,000 310,000 1 10,000 - - 3,280,000 - -
214,175 132,032 80,430 53,332 504 973,876 - 100,000
I - - - - - - - 460,575
444,175 442,032 190,430 53,332 504 4,253,876 - 560,575
I (434, I 97) 43,861 (18,232) 118,778 119,454 (1,492,674) 1,449,610 174,320
I " - - - - - - -
- - - - - - - -
465,497 442,075 - 113,148 159,323 1,212,852 - -
- - - - - (3,328) (190,401) -
I 465,497 442,075 - 113,148 159,323 1,209,524 (190,40 I) -
31,300 485,936 (18,232) 231,926 278,777 (283, I 50) 1,259,209 174,320
I 451,125 667,405 177,042 532,676 - 7,941,439 3,068,948 (1,783,739)
I $ 482,425 $ 1,153,341 $ 158,810 $ 764,602 $ 278,777 $ 7,658,289 $ 4,328,157 $ (1,609,419)
83
I
I
CITY OF SHAKOPEE I
Scott County, Minnesota
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES-
NON MAJOR GOVERNMENTAL FUNDS I
For the Year Ended December 31,2008
(Continued)
Capital Projects I
Capital East Dean's I
Improvements TIF No. 10 Lake TIF No. 11 2005 Projects
REVENUES:
Property Taxes $ - $ - $ - $ - $ - I
Tax Increments - 35,512 - 241,299 -
Special Assessments 135,319 - - - -
Licenses and Permits - - - - -
Intergovernmental: I
State Grants - - - - -
Other Grants and Aids - - - - -
Charges for Services - - - - - I
Fines and Forfeitures - - - - -
Miscellaneous:
Investment Income 196,780 - 19,927 - 13,562
Contributions and Donations - - - - - I
Other - - - - -
Total Revenues 332,099 35,512 19,927 241,299 13,562
EXPENDITURES: I
Current:
General Government - - - - -
Public Safety - - - - - I
Public Works - - - - -
Culture and Recreation - - - - -
Economic Development - 35,512 - 241,299 -
Debt Service: I
Principal - - - - -
Interest and Other Charges - - - - -
Capital Outlay 108,407 - - - 1,130 I
Total Expenditures 108,407 35,512 - 241,299 1,130
Excess of Revenues Over
(Under) Expenditures 223,692 - 19,927 - 12,432 I
OTHER FINANCING SOURCES (USES):
Bonds Issued - - - - - I
Premium on Bonds Issued - - - - -
Transfers In - - - - -
Transfers Out (98,367) - - - (213,188)
Total Other Financing Sources (Uses) (98,367) - - - (213,188) I
Net Change in Fund Balances 125,325 19,927 (200,756)
- -
FUND BALANCES: I
Beginning of Year 3,513,631 - 350,110 - 200,756
End of Year $ 3,638,956 $ - $ 370,037 $ - $ - I
84
I
I
I
I
I Capital Projects
Total Other
I Governmental
TIF No. 12 2006 Projects 2007 Projects 2008 Projects TIF No. 13 2009 Projects Total Funds
I $ - $ - $ - $ - $ - $ - $ - $ 1,177,539
87,276 - - - 24,848 - 388,935 388,935
- - - 362,444 - - 497,763 1,870,024
- - - - - - 193,606 530,524
I - - - - - - 1,274,822 2,310,141
- - - - - - - 3 1,440
I - - - - - - - 1,116,019
- - - - - - - 76,008
-
- 12,413 24,583 499 - - 488,183 1,015,445
I - - - - - - 493,900 493,900
- - - - - - 1,758 35,074
87,276 12,413 24,583 362,943 24,848 - 3,338,967 9,045,049
I
- - - - - - - 219,502
I - - - - - - - 48,398
- - - - - - - 1,055,267
- - - - - - - 2,289,199
82,821 - - - 22,363 - 381,995 454,413
I - - - - - - - 3,280,000
- - - - - - 100,000 1,077,711
I - 236 87,445 2,470,591 - 34,725 3,163,109 3,177,589
82,821 236 87,445 2,470,591 22,363 34,725 3,645,104 11,602,079
I 4,455 12,177 (62,862) (2,107,648) 2,485 (34,725) (306,137) (2,557,030)
I - - - 2,170,000 - - 2,170,000 2,170,000
- - - 16,741 - - 16,741 16,741
- - 68,886 152,283 - - 221,169 . 2,615,171
(4,455) (228,887) (19,203) - (2,485) - (756,986) (797,214)
I (4,455) (228,887) 49,683 2,339,024 (2,485) - 1,650,924 4,004,698
(216,710)
- (13,179) 231,376 - (34,725) 1,344,787 1,447,668
I - 216,710 13,179 (56,130) - - 5,523,465 16,948,234
I $ - $ - $ - $ 175,246 $ . $ (34,725) $ 6,868,252 $ 18,395,902
85
I
I
I
I
I
I
I
I
I
I
(THIS PAGE LEFT BLANK INTENTIONALLY.) I
I
I
I
I
I
I
I
I
86 I
I
I CITY OF SHAKOPEE
Scott County, Minnesota
I SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES
IN FUND BALANCES - BUDGET AND ACTUAL -
I TRANSIT FUND
For the Year Ended December 31, 2008
I Variance with
Budgeted Amounts Actual Pinal Budget-
I Original Final Amounts Over (Under)
REVENUES:
Property Taxes $ - $ - $ 7 $ 7
I Intergovernmental Revenue:
State Grants 2,189,380 2,189,380 1,035,319 (1,154,061)
I Charges for Services 197,040 197,040 31,090 (165,950)
Miscellaneous Revenues:
Investment Income 5,000 5,000 107,681 102,681
I Total Revenues 2,391,420 2,391,420 1,174,097 (1,217,323)
EXPENDITURES:
I Public Works:
Current 878,420 880,840 1,055,267 174,427
Capital Outlay 1,200,000 1,200,000 - (1,200,000)
I Total Expenditures 2,078,420 2,080,840 1,055,267 (1,025,573)
Excess of Revenues Over
I (Under) Expenditures 313,000 310,580 118,830 (191,750)
I OTHER FINANCING USES:
Transfers Out (11,200) (11,200) (11,200) -
I Net Change in Fund Balance $ 301,800 $ 299,380 107,630 $ (191,750)
FUND BALANCE:
I Beginning of Year 1,767,428
End of Year $ 1,875,058
I
I
I
I 87
I
CITY OF SHAKOPEE I
Scott County, Minnesota
SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES I
IN FUND BALANCES - BUDGET AND ACTUAL -
TELECOMMUNICATION FUND I
For the Year Ended December 31, 2008
Variance with I
Budgeted Amounts Actual Final Budget -
Original Final Amounts Over (Under) I
REVENUES:
Licenses and Permits $ 309,000 $ 309,000 $ 336,918 $ 27,918
Miscellaneous Revenues: I
Investment Income 15,000 15,000 36,952 21,952
Other - - 882 882
Total Revenues 324,000 324,000 374,752 50,752 I
EXPENDITURES: 'I
General Government:
Current 274,600 296,700 219,502 (77,198)
Capital Outlay 40,000 40,000 - (40,000) I
Total Expenditures 314,600 336,700 219,502 (117,198)
Excess of Revenues Over I
(Under) Expenditures 9,400 (12,700) 155,250 167,950
OTHER FINANCING USES: I
Transfers Out (6,500) (6,500) (6,500) -
Net Change in Fund Balance $ 2,900 $ (19,200) 148,750 $ 167,950 I
FUND BALANCE: I
Beginning of Year 640,892
End of Year $ 789,642 I
I
I
I
88 I
I
I CITY OF SHAKOPEE
Scott County, Minnesota
I SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES
IN FUND BALANCES - BUDGET AND ACTUAL -
ECONOMIC DEVELOPMENT AUTHORITY FUND
I For the Year Ended December 31, 2008
I Variance with
Budgeted Amounts Actual Final Budget-
Original Final Amounts Over (Under)
I REVENUES:
Property Taxes $ 80,000 $ 80,000 $ 77,082 $ (2,918)
Intergovernmental Revenue:
I Other Grants and Aids 26,500 26,500 31,440 4,940
Miscellaneous Revenues:
Investment Income 13,000 13,000 22,746 9,746
I Total Revenues 119,500 119,500 131,268 11,768
EXPENDITURES:
I Economic Development:
Current 123,770 123,770 72,418 . (51,352)
I Excess of Revenues Over
(Under) Expenditures (4,270) (4,270) 58,850 63,120
I OTHER FINANCING SOURCES (USES):
Transfers In 26,000 26,000 36,140 10,140
I Transfers Out (19,200) (19,200) (19,200) -
Total Other Financing Sources (Uses) 6,800 6,800 16,940 10,140
I Net Change in Fund Balance $ 2,530 $ 2,530 75,790 $ 73,260
FUND BALANCE:
I Beginning of Year 372,105
End of Year $ 447,895
I
I
I
I
89
I
I
CITY OF SHAKO PEE I
Scott County, Minnesota
SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES I
IN FUND BALANCES - BUDGET AND ACTUAL -
RECREATION FUND I
For the Year Ended December 31, 2008
Variance with I
Budgeted Amounts . Actual Final Budget -
Original Final Amounts Over (Under) I
REVENUES:
Charges for Services $ 1,036,580 $ 1,036,580 $ 1,084,929 $ 48,349
Miscellaneous Revenues: I
Investment Income . 20,000 20,000 48,020 28,020
Other 16,250 16,250 13,867 (2,383)
Total Revenues 1,072,830 1,072,830 1,146,816 73,986 I
EXPENDITURES: I
Culture and Recreation:
Current 2,217,840 2,250,660 2,289,199 38,539
Capital Outlay - - 14,480 14,480 I
Total Expenditures 2,217,840 2,250,660 2,303,679 53,019
Excess of Revenues Over I
(Under) Expenditures (1,145,010) (1,177,830) (1,156,863) 20,967
OTHER FINANCING SOURCES: I
Transfers In 1,145,010 1,145,010 1,145,010 -
Net Change in Fund Balance $ - $ (32,820) (11,853) $ 20,967 I
FUND BALANCE: I
Beginning of Year 352,663
End of Year $ 340,810 I
I
I
I
90 I
I
I CITY OF SHAKO PEE
Scott County, Minnesota
I COMBINING STATEMENT OF FUND NET ASSETS -
INTERNAL SERVICE FUNDS
December 31, 2008
I Governmental Activities - Internal Service Funds
Employee
I, Equipment Buildings Park Assets Benefits Total
ASSETS:
Current Assets:
Cash and Cash Equivalents $ - $ - $ - $ 1,761,233 $ 1,761,233
I Investments 4,780,811 1,771,027 111,597 - 6,663,435
Interest Receivable 36,283 17,002 270 13,026 66,581
Notes Receivable, Current Portion 115,000 - - - 115,000
I Total Current Assets 4,932,094 1,788,029 111,867 1,774,259 8,606,249
Noncurrent Assets:
Notes Receivable 445,000 - - - 445,000
I Capital Assets:
Buildings and System - 30,160,731 3,141,813 - 33,302,544
Machinery and Equipment 7,836,047 , - 6,468,918 - 14,304,965
I Total Cost 7,836,047 30,160,731 9,610,731 - 47,607,509
Less Accumulated Depreciation (3,451,889) (6,194,695) (1,522,614) - (11,169,198)
Net Capital Assets 4,384,158 23,966,036 8,088,117 - 36,438,311
Total Noncurrent Assets 4,829,158 23,966,036 8,088,117 - 36,883,311
I Total Assets $ 9,761,252 $ 25,754,065 $ 8,199,984 $ 1,774,259 $45,489,560
I LIABILITIES AND NET ASSETS:
Current Liabilities:
Accounts Payable $ 4,409 $ 16,182 $ - $ - $ 20,591
Current Compensated Absences - - - 710,577 710,577
I Total Current Liabilities 4,409 16,182 - 710,577 731,168
Noncurrent Liabilities:
I Compensated Absences - - - 724,189 724,189
Net OPEB Obligation - - - 233,153 233,153
Total Noncurrent Liabilities - - - 957,342 957,342
Total Liabilities 4,409 16,182 - 1,667,919 1,688,510
I Net Assets:
Invested in Capital Assets, Net of Related Debt 4,384,158 23,966,036 8,088,117 - 36,438,311
I Unrestricted 5,372,685 1,771,847 111,867 106,340 7,362,739
Total Net Assets 9,756,843 25,737,883 8,199,984 106,340 43,801,050
Total Liabilities and Net Assets $ 9,761,252 $ 25,754,065 $ 8,199,984 $ 1,774,259 $45,489,560
I
I
I
I 91
I
CITY OF SHAKOPEE I
Scott County, Minnesota
COMBINING STATEMENT OF REVENUES, EXPENSES I
AND CHANGES IN FUND NET ASSETS -
INTERNAL SERVICE FUNDS
For the Year Ended December 31,2008 I
Governmental Activities - Internal Service Funds
Employee I
Equipment Buildings Park Assets Benefits Total
OPERATING REVENUES:
Rental Charges $ 1,048,560 $ 917,340 $ 110,002 $ - $ 2,075,902 I
Other Charges - - - 877,016 877,016
Total Operating Revenues 1,048,560 917,340 110,002 877,016 2,952,918
OPERATING EXPENSES: I
Employee Benefits - - - 1,030,109 1,030,109
Depreciation 537,873 754,737 320,059 - 1,612,669
Total Operating Expenses 537,873 754,737 320,059 1,030,109 2,642,778 I
Operating Income (Loss) 510,687 162,603 (210,057) (153,093) 310,140
NONOPERATING REVENUES: I
Investment Income 285,670 116,118 1,865 87,824 491,477
Gain on Disposal of Assets 56,453 - - - 56,453 I
Total Nonoperating Revenues 342,123 116,118 1,865 87,824 547,930
Income (Loss) before Capital I
Contributions and Transfers 852,810 278,721 (208,192) (65,269) 858,070
Capital Contributions 7,500 - 8,267,561 - 8,275,061
Transfers In - - 140,615 - 140,615 I
Transfers Out - (606,112) - - (606,112)
Change in Net Assets 860,310 (327,391) 8,199,984 (65,269) 8,667,634 I
NET ASSETS:
Beginning of Year 8,896,533 26,065,274 - 171,609 35,133,416 I
End of Year $ 9,756,843 $ 25,737,883 $ 8,199,984 $ 106,340 $43,801,050
I
I
I
I
92
I
I
I CITY OF SHAKOPEE
Scott County, Minnesota
I COMBINING STATEMENT OF CASH FLOWS -
INTERNAL SERVICE FUNDS
For the Year Ended December 31, 2008
I Employee
Equipment Buildings Park Assets Benefits Total
CASH FLOWS - OPERATING ACTIVITIES:
I Receipts from Customers and Users $ 1,048,560 $ 917,340 $ 110,002 $ 877,016 $ 2,952,918
Payments to Employees - - . (652,588) (652,588)
Payments for Interfund Services - - - (49,538) (49,538)
'I Net Cash Flows - Operating Activities 1 ,048,560 917,340 110,002 174,890 2,250,792
CASH FLOWS. NONCAPIT AL
FINANCING ACTIVITIES:
Transfer to Other Funds - (465,497) - - (465,497)
I
CASH FLOWS - CAPITAL AND RELATED
FINANCING ACTIVITIES:
I Proceeds from Disposal of Capital Assets 101,239 33,530 - - 134,769
Acquisition of Capital Assets (380,818) (813 ,466) - - (I,194,284)
Net Cash Flows - Capital and Related
Financing Activities (279,579) (779,936) - - (1,059,515)
I CASH FLOWS. INVESTING ACTIVITIES:
Proceeds (Purchases) ofInvestments (1,045,564) 214,300 (111,597) . (942,861)
Interest Received 276,583 II3,793 1,595 85,856 477,827
I Net Cash Flows - Investing Activities (768,981) 328,093 (I 10,002) 85,856 (465,034)
Net Change in Cash and Cash Equivalents - - - 260,746 260,746
I CASH AND CASH EQUIVALENTS:
Beginning of Year - - - 1,500,487 1,500,487
I End of Year $ - $ - $ - $ 1,761,233 $ 1,761,233
RECONCILIATION OF OPERATING INCOME (LOSS)
TO NET CASH FLOWS - OPERATING ACTIVITIES:
I Operating Income (Loss) $ 510,687 $ 162,603 $ (210,057) $ (153,093) $ 310,140
Adjustments to Reconcile Operating Income (Loss)
to Net Cash Flows. Operating Activities:
Depreciation Expense 537,873 754,737 320,059 - 1,612,669
I Changes in:
Due to Other funds - . - (49,538) (49,538)
Compensated Absences Payable - - - 144,368 , 144,368
Net OPEB Obligation . - - 233,153 233,153
'I Total Adjustments 537,873 754,737 320,059 327,983 1,940,652
Net Cash Flows - Operating Activities $ 1,048,560 $ 917,340 $ 110,002 $ 174,890 $ 2,250,792
J NONCASH INVESTING, CAPITAL AND FINANCING
ACTIVITIES:
Contributions of Capital Assets from the
Municipality and Developers $ 7,500 $ - $ 8,267,561 $ - $ 8,275,061
I Transfer of Capital Assets - (140,615) 140,615 - -
Purchases of Capital Assets on Account 4,409 16, I 82 - - 20,591
Capital Asset Trade-Ins 191,747 - . - 191,747
I
I 93
I
CITY OF SHAKO PEE I
Scott County, Minnesota
STATEMENT OF CHANGES IN ASSETS AND LIABILITIES - I
ESCROW AGENCY FUND
For the Year Ended December 31,2008 I
Balance at Balance at I
December 31, December 31,
2007 Additions Deductions 2008
ASSETS: I
Current:
Cash and Investments $ 1,333,877 $ 465,046 $ 505,787 $ 1,293,136
LIABILITIES: I
Accounts Payable $ - $ 489,678 $ 494,749 $ 5,071 I
Deposits Payable 1,333,877 536,804 582,616 1,288,065
Total Liabilities $ 1,333,877 $ 1,026,482 $ 1,077,365 $ 1,293,136 I
I
I
I
I
I
I
I
I
I
94 I
I
I STATISTICAL SECTION
I This part ofthe City's Comprehensive Annual Financial Report (CAFR) presents detailed
information for placing in context and understanding what the information shown in the financial
I statements, note disclosures and required supplementary information reveals about the City's
overall financial health.
I Contents Page
I Financial Trends 96
These schedules show trend information to help the reader
understand how the City's financial performance and
I well being have changed over time.
Revenue Capacity 101
Portrayed is information to help the reader assess the
I City's most important local revenue source, the property tax.
Debt Capacity 105
I These schedules present information to help the reader assess
the affordability of the City's current levels of outstanding
debt and the City's ability to issue additional debt in the future.
I Demographic and Economic Information 110
Shown are demographic and economic indicators to help the
I reader understand the environment within which the City's
financial activities take place.
Operating Information 112
I These schedules shown service and infrastructure data to
help the reader understand how the information in the City's
financial report relates to the services the City provides
I and the activities it performs.
Source: Unless noted otherwise, the information in these schedules is from the CAFR for the
I relevant year.
I
I
I
I
I 95
I
CITY OF SHAKO PEE I
Scott County, Minnesota
Table 1
NET ASSETS BY COMPONENT
Years 2003 Through 2008 I
2003 2004 2005 2006 2007 2008
Governmental Activities: I
Invested in Capital Assets, Net of
Related Debt $ 94,388,758 $ 90,281,410 $ 111,237,672 $ 119,661,761 $ 113,534,056 $ 112,909,793
Restri cted 15,231,314 29,731,412 21,638,112 12,998,982 13,081,337 21,915,945
Unrestricted 15,241.647 21,214,073 21,845,121 29,264,714 28,316,931 22,086,771 I
Total Governmental Activities Net Assets $ 124,861,719 $ 141,226,895 $ 154,720,905 $ 161,925,457 $ 154.932,324 $ 156,912,509
Business-Type Activities:
Invested in Capita] Assets, Net of I
Related Debt $ 81,725,264 $ 89,415,817 $ 99,140,973 $ 109,337,014 $ 114,546,218 $ 115,124,238
Restricted 978,371 1,867,077 2,232,469 880,069 1,026,351 1,756,369
Unrestricted 38,234,063 37,354,576 41,291,469 42,400,797 46,169,289 49,366,581
Total Business-Type Activities Net Assets $ ]20,937,698 $ 128,637,470 $ 142,664,911 $ 152,617,880 $ 161,741,858 $ 166,247,188 I
Primary Government:
Invested in Capital Assets, Net of
Related Debt $ 176,114,022 $ 179,697,227 $ 210,378,645 $ 228,998,775 $ 228,080,274 $ 228,034,031 I
Restricted 16,209,685 31,598,489 23,870,581 13,879,051 14,107,688 23,672,314
Unrestricted 53,475,710 58,568,649 63,136,590 71,665,511 74,486,220 71,453,352
Total Primary Government Net Assets $ 245,799,417 $ 269,864,365 $ 297,385,816 $ 314.543,337 $ 316.674,182 $ 323,159,697
Note: The City began to report accrual information when it implemented GASB Statement No. 34 in fiscal year 2003. I
I
I
I
I
I
I
I
I
I
96 I
I
I CITY OF SHAKOPEE
Scott County, Minnesota
Table 2
CHANGES IN NET ASSETS
I Years 2003 Through 2008
2003 2004 2005 2006 2007 2008
Expenses
I Governmental activities:
General Government $ 2,761,210 $ 3,135,421 $ 2,563,526 $ 3,161,106 $ 3,543,980 $ 3,514,573
Public Safety 4,995,127 5,461,190 6,190,689 6,856,485 8,30 I ,075 8,346,104
Public Works 3,673,623 6,036,920 8,298,258 6,798,917 15,264,606 8,099,384
I Economic Development 683,035 360,1 67 314,858 333,462 363,805 522,074
Culture and Recreation 894,321 2,150,765 3,664,944 4,653,240 5,323,087 3,637,527
Other 668,531 861,864 924,270 896,110 1,042,133 1,033,999
Total Governmantal Activities Expenses 13,675,847 18,006,327 21,956,545 22,699,320 33,838,686 25,153,661
I Business-Type Activities:
Electric 17,634,004 19,820,900 23,378,764 29,169,297 34,710,974 36,186,676
Water 2,337,860 2,723,003 2,460,977 2,949,990 3,332,132 3,461,261
Sewer 1,835,242 2,009,468 2,349,047 2,786,234 2,938,955 3,308,759
I Storm &00,092 941,842 999,849 1,523,343 1,352,078 1,435,376
Recreation 1,552,524
Total Business-Type Activities Expenses 24,159,722 25,495,213 29,188,637 36,428,864 42,334,139 44,392,072
Total Primary Govenrment Expenses $ 37,835,569 $ 43,50],540 $ 51,145,182 $ 59,128,184 $ 76,172,825 $ 69,545,733
I Program Revenues
Governmental activities:
Charges for Services:
General Government $ 1,706,644 $ 3,591,641 $ 791,504 $ 714.105 $ 583,247 $ 606,259
I Public Safety 2,408,012 3,446,465 3,462,283 2,063,023 1,650,235 1,506,680
Public Works 3,691,149 4,534,285 2,668,728 2,986,495 2,615,402 2,354,276
Culture and Recreation 1,330,062 1,497,853 1,826,847 1,676,630 1,086,750 1,295,772
Operating Grants and Contributions 2,622,953 4,303,581 3,646,605 1,653,238 1,943,805 1,660,191
I Capital Grants and Contributions 11,009 8,666,283 6,116,366 2,463,129 1,825,124
Total Governmental Activities Program Revenues 11,769,829 17,373,825 21,062,250 15,209,857 10,342,568 9,248,302
Business-Type Activities:
Charges for Services:
I Electric 19,733,990 22,161,542 27,425,921 31,906,714 37,407,565 38,732,701
Water 2,569,848 2,349,505 2,627,084 3,127,207 3,525,140 3,390,309
Sewer 2,827,777 3,078,191 2,971,601 3,471,984 2,806,371 2,556,299
Storm 1,947,139 1,806,974 1,937,430 1,859,912 1,505,247 1,379,821
I Recreati on 758,124
Operating Grants and Contributions 2,345
Capital Grants and Contributions 8,800,811 10,844,269 10,9]3,464 6,174,786 4,138,977 1,007,519
Total Business-Type Activities Program Revenues 36,640,034 40,240,481 45,875,500 46,540,603 49,383,300 47,066,649
Total Primary Government Program Revenues $ 48,409,863 $ 57,614,306 $ 66,937,750 $ 61,750,460 $ 59,725,868 $ 56,314,951
I Net (Expense) Revenue
Governmental Activities $ (1,906,018) $ (632,502) $ (894,295) $ (7,489,463) $ (23,496,118) $ (l5,905,359)
I Business-Type Activities 12,480,312 14,745,268 16,686,863 10,11 ],739 7,049,161 2,674,577
Total Primary Government Net Expense $ 10,574,294 $ ]4,] 12,766 $ 15,792,568 $ 2,622,276 $ (16,446,957) $ (l3,230,782)
I
I
I
I
97
I
I
CITY OF SHAKOPEE I
Scott County, Minnesota
Table 2 (Continued)
CHANGES IN NET ASSETS I
Years 2003 Through 2008
General Revenues and Other Changes in Net Assets 2003 2004 2005 2006 2007 2008
Governmental Activities: I
Taxes
Property Taxes $ 7,995,002 $ 7,842,043 $ 9,341,977 $ 10,547,]77 $ 12,767,354 $ 14,200,833
Other Taxes 507,706 364,211 314,858 336,648 369,240 388,935
Unrestricted Investment Earnings 550,705 740,612 951,795 1,661,257 2,232,717 1,941,335 I
Gain on Disposal of Assets 69,623 294,833 746,340 2,700 22,628 56,453
Enterprise Fund Reclassed to Special Revenue 5,539,108 1,658,132
Transfers 443,65] 2,2]5,87l 1,375,203 2,146,233 1,111,046 1,297,988
Total Governmental Activities 9,566,687 16,996,678 14,388,305 14,694,015 16,502,985 17,885,544 I
Business-Type Activities:
Investment Earnings 942,040 709,483 870,714 1,973,715 3,185,863 3,]28,741
Gain on Disposal of Assets 9,260 409,918 13,749
Special Item (5,539,108) (1,658,132) I
Transfers (443,651 ) (2,2] 5,871) (1,375,203) (2,146,233 ) (1,1 11,046) (1,297 ,988)
Total Business-Type Activities 507,649 (7,045,496) (1,752,703) (158,769) 2,074,817 1,830,753
Total Primary Government $ 10,074,336 $ 9,951,182 $ 12,635,602 $ ]4,535,246 $ 18,577,802 $ 19,7]6,297
Change in Net Assets I
Government Activities $ 7,660,669 $ ]6,364,176 $ 13,494,0] 0 $ 7,204,552 $ (6,993,133) $ 1,980,185
Business-Type Activities 12,987,961 7,699,772 14,934,160 9,952,970 9,123,978 4,505,330
Total Primary Government $ 20,648,630 $ 24,063,948 $ 28,428,170 $ 17 ,157 ,522 $ 2,130,845 $ 6,485,515
Note: The City began to report accrual infonnation when it implemented GASS Statement No. 34 in tlscal year 2003. I
I
I
I
I
I
I
I
I
I
98
I
I
I .., ""00'" '" 0 "''''''' N
'" <--"'0 0 ... "'oo~ 0
:0 0"''"'' '" "", """'00 '"
" 00 -.o~~ 00 c<1 600~ '"
~ "'''''''' "" <-- "".,., '" '"
0 - .... 00 t-- 00 ~'""'" ""
I 0 ...:oo~ N .f -=r--:...: 00
'"
.., .., ..,
0,..,,.., .,., 'c<1 '" '" '" ...
.,.,00,.., t-- 0 .,., ,.., -0 c<1
I '"" 00 .,., t-- <-- "'..,.<-- '"
,... o ...ot-~ 0; 0; M" .-: (""')'" 00
~"'O 00 ... "'....... ..,.
0 00 00 .... ... 00 ",,,,,",, '"
0 ....:r--:~ N ....; ~~ -6
'"
.., .., ..,
I ........... ~..,.O\ .~ .,.,
.,.,<--,.., '" -'" c<1
""'":~... '0" ....-t-- t--
"" 0..,."" -.6 0" N ....;
0\"''''' 00 ,., 00 '"
0 o::t...~~ """'0
0 ~r---"'oO 00
'" ~ 00 '"
I .., .., ..,
.,.,t--'" ""00 .~ ....
,""t--..,. ,""N~ .,.,
""""- .,.,0,"" '"
III \0" N a:: -"\IS v) ~
I -~~ -0,..,-
... = "'0\
... ~~ ('of a\ '" 0
M '"
.., .., ..,
I ,",,00"" ~..,.,., ~ '""
00 "" .,., '"" 00 0 t-- 0\
"""'00 0""00 '" ""
... MM~ N'r-:-oO -:i '"
- ,..,... ,.., ,.., 00 '"
0 "'''' "'000
'" 0 r-: r---" Nor:--: 0
~ '" ~ ~ ""
I ;;J .., .., ..,
r.-.
...1 ~
~ ,.,""'" ..,.,.,<-- ....
o~- 00000 ""
\J;l~ ~ ~ 00000 '"" "" 00 '"
\J;l " .., O\..,.;~ ry:) 0-." 00 ""
~ ~ :::! i'l t--""..,. .... "" 00
<= .,.,"" ....""0 '"
I ~ .5 ~:: <= v) v) ....:\CSr;-: :i.
....
~~ r.l i'l ..,
;> .:!l .., ..,
ooC or.-.
r.-. = \,:) = ~
os ~~ 00 t-- 0\ '"" N
;;..U 00 00 """'0 0\
I r.l";; 00 '" "" "" N
~:: ~-.::i I,Q"'~OO 0
- " u " ... ,..,,.., .,.,.,., ~ .,.,
u '" 2;...1 ~ .,., .,., 0:::::1"... \0... 00"
(fJ ~ ~rt1 ~....-o '"
= .., .., ..,
I ~ .,
;;J 00 -0"" N
r.-. "" -0 ..."'.... ...
.,., .,., 0"'''' ""
:t:t ~Nr--:- 0
- ""0'" <--
0 '" '" '" '"
0 "';M" oo-q: :f
....
I .., .., ..,
0""-0 .... '" "" ., '"
o -~ ,., 00\ '"
q-,,--:' ""0'" N
0 0"""" 0-"0\ 00
I 0........ "" '" '" ...
0 "''"'''''' """"'" 'l;
0 ~...~... 0:;-.0
N ~
.., .., ..,
I . "" "" ..."'... .~ '"
"",.., 0.,.,,,, ,..,
,..,,.., ..q-..'<:t..~ N
'" 06 "" "'.... '"
00 t-- 00 0 '"
'" t--t-- ""0- 00
~ ~~ S~ '"
I .., .., ..,
oi!l
<<i
3 ;:;
I ~ .g oi!l .g oi!l~
'5 &:oi!l& &:oi!l&"
"" e g 5 00 ~ 9 ~ 8
& E C~Q ~~t)
~ ~ lj.~ ~ ~.~ '""
""2 ca 8 ~ .~ J: 'E ~ .~ J: .s
"",,'Ell
I ~ dl i:: ~ ~]~~g~~~g~
OJ i': 1;1 c3 ~ ~ u ~.- ~ ~ ~ .- ~ 00
6~~c; ~!&83~~83~]
=~:5~ 99
c3 ~ <: f-o
I
. ~.~~~~~~ ~-N~.~.' O-N- ~ 0 - ~~ N ~ ~ I
~ ~~~~~NN~ ~~~~~~~ O-~O 0 0 ~ ~~ 7 M ~
~ ~~~~~~~~ ~q~~~~q q~q q q ~ ~~ ~ ~ -'
~ ~ ~~-N~MOOM ~OO~~OO-N O~O- 00 0 ~ ~~ ~ ~ I
~ = ~~NOO~N~ --~OONON OO~O~ ~ ~...... ON ~ ~
= ~ooN~NvO~ ~OOOO~~-~ NO~OO ~ ~N ~ ~
N ~~~NN N~ ~~~ ~~ M~~~ N N ~~ ~ ~
N N --
~ ~
,,-.. ..-. --- <::>
l..1"JOOo::::t'\I)COlt)l;' l.()V) \0 \C-O'\ OOOM~ \0 00\0 I -('f') V N 2f( I
~\O~~~N~~ N~~~~~ O~~~ 0 OO~ OOM 0 0 ~
l..1"J~v)V)MN~\O ~~OO-~V) 000000 N O~~ N~ ~ ~ -
~ ~~OOO~~N~ ~N~~~~ O~OO~ 00 ~~~ ~OO ~ N
Q OOO~~OOON ~\OM~~V) -NOO~ ~ -00 ~ ~
~ ~~~~~~~~ ~~~~~~ ~S~6 ~ ~ }~ ~ M
- N ~ - ~-
~ ~ ~: ,0 I
~-V)~~O~M ~OO~~NV)' OooO\~ M eoV') N~ M 0 ~
~~M~~V)-OO -\ON~~~ o-~~ ~ oo~ M~ ~ M ~
~OO~N~OO~\O ~NM~MV) o\O~oo O~N V)M 0 -
~ ~~~~d~~~ ~~~~~~ ~~d~ ~ d~d ~~ ~ d
= -~~~~N~- 7~OON~V) V)~V)N ~ N OOV) ~ N
o OOl:'\OOON~~OO -oo~ooo~ O-\O~ ~ 7 \OM ~ 00
N 0 -" C"..f N N -" M M" -::;r" -:- M ~ r-r)' -" 0"" 00" rr) .,,0 ('"<')" \f".i " I
- N ......M ~ --
~ ~
-0""" V')-Q\ \0 f"<') 7""1"O"=T'<:tO' 0'70000 ~ -o::t I 0-0 CO ~;:: ~
Nl:'~O~~~~ ~M-~~~ ONO- ~ n O~~ ~ ~ ~
~~~~-~~~ ~~~oo~~ o~~~ 0 O~~ ~ ~ I
~ ~~~~~M~~ O~~~~M ~~oo~ N ~ o~~ ~ M
g ~~~~~~~N ~~~~8~ ~S~M ~ ~ ~~~ ~ ~
Moo 0 0 0 0 0 0 o. 0 0 0 0 0 0 0 0 0 0 0
~N~~N -~ M~- ~N --~N ~ NM- ~
N -tv) -- -- -- --
~ ~
~ 0 I
~-<::t'-V'lN...:t- O\NOONO\ I o '-0 lrlt"') N 0("1') I .......00 '-D -.::t ~
~~oooo~-- N~ON...o~ O~~~ ~ 000 ~~ ~ ~ ~
N-OO~~~~~ OM~~~~ O~~~ ~ 0- ~o 00 .......
~ ~~~NMOO~~ ~oo~o~~ ~~NO ~ o~ MN 0 ~
~ ~ o~~~~oo~~ oo~~~...ooo ~o~oo N ~_~ ~- N ~
Q M N" ......" -" -.. ~ N r-" -.::t" '-0" ....." \0 v),.. "<::t" ~... ~ ""'... 0\" e a" N ~" ~ c" ...
~ OOM~~N M M~- NM - ~~ ~ ~~ 00 ~
;S ~ N N - ~-;;;; I
""
~ __ -. 0
< O\O~~NM~~ oo~~o~o ~ OOONO ~ r-- IN_ ~ ~ ~
~ ~...o~~-OO~M ...o~~MC~ ~ O~~M ~ ~~ t-N r- 00 00
Z 5~~~~~~~ ~~~~s~ ~ d~~~ ~ ~~ ~~ d ~ N
~ a ~~~-M~OM ~~~...:tN~ - N-MM 0 ~~ M~ 0 0\
~ Q ~-..~~~N~~ ~~O\~~~ M ~~~. ~ ~ ~~ ~ ~ I
z N ~M~N- 0 M~ N M ~- N-N
~ ~ N N ~
W - ~ foil
~~ ,'- ~ ~
Q. e,,) ,,- ~
02 0;':: ~ ~ 0
~~ ~~ ooN~r-~OOOO~ N~O~M~I~ oo~oo M ~~ ~o M 0 ~
<~ ~~ ~~0~~~~~ 8~~~~g ~ g~~~ ~ ~~ ~~ ~ r- ~ I
~~ ~~ ~ ~~~o~~~~ ~~~~~~ ~ ~~~o 0 ~~ ~o ~ ~
~; ~c ~ ~~~R~~~~ ~q~~~~ s q~~~ ~ ~ ~~ ~ ~
0= <~ ~-M~- - ~M N ~ ~M N ~ -N ~
U,...,J ~ N M'-" "--' t;f;
S~ ~j ~ ~ ~ 0 I
rJ'J. Q o\'-O~o\\Ol.r)......oo NOO-I..OMO ,__ ON\OO'> 0 I lI')O l() I.{) ~
~ -OON~~~~OO ~~~~~~ 00 O~~~ ~ 00 ~~ 1..0 M 0
~ ~"""~OO-OM~ ~~ooo~~ ~ a-MO ~ ~ ~~ 0 lI') ~
~ ~ ~d~~~d~~ d~~~~~ ~ ~d~" ~ ~ ~~ ~ d
~ 2 \OOOll')NO\MOO~ ~N\ON-~ 0 \O~~O lI') ~ ~~ ~ ~
z N q~~~qN~~ ~~~~q\O - ~~~~ ~ ~~ ~ ~
_ \ONM-- -l() N~ N M ~~ ~~ N ~
f2 ~ - - ~ ~~;;; I
"
~ ~ 0
~ ~NOO~r--r-OO N("'f)O'I~N\O I If) ONl-oo 0 Nl- I 0\\0 N N 'cF-
~ M~l--.::to\-O\- ~l-~O\oo 0 00\l()- 0 ~- \OM ~ ~ 00
= ~~~q~q~q ~~~~~~ ~ q~~~ ~ ~~ ~~ ~ ~ ~
U e OOO'l~~NNNr- OOOOOO\~- \0 lI')~~ ~ ON M\O 0 lI')
= ~lI')"""MOO~O\O lI')O\NO\ON 00 ~~OON ...... V)O ~oo ~ N I
e -O'IV)N~-OOO\ ~or-~~\O -00 lI') 0 lI')- NO 00 ~
MOO 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~NNN- -\0 NN""" ~ ~oo ~ N Me ~
~ ~
OOO............Ol.r)MOO 0000 Q(".fO\ t- 'M O~"=T~ ~ 00 I 0\00 -. M "$.
\OOOO\OlI')MMN ~MN~~- 00 OO\~N 0 N \O~ ~ ~ 00 I
-\ON\OOOOOO~ N-N~lI')~ O~M~ 0 \0 00 M ~ N
~ " " ... " " ... "" " " " " "" ... """"" """,,,,,
~ ~_~M~OON~ O\-\O~NOO 0\ o~O\o ~ 00 \O~ 0\ ~
~ ~lI')-O\~~NO\ \Or-r-l.r)MlI') 0 -\0-\0 ~ l- ~~ 0 N
~ ~~~~~-O\~ ~~If)Mq~ - qO\~~ ~ N ~~ q N
lI')NN-- ~ N- N N N~ N~
...... -- ---.
~ ~
I
I
'-
'" 0
e ~ ~
_ n ~ ~ ~ ~ ~ S~ I
S=ij ~ g:Cf1 ~ ~~ rn "3 ~~
tn ~ 1: c:.,g E E 0 ~ = ~ 0 OJ) co ~ .€
~ '-' _ ~ 4).2 <l:i 0.. U u:l 5 0 - ti .5 "0 u "0
~ E t'j._ rJ1 E t) e 0 \-0 u:l Q) - 00 f/:l CI} r..> .- ~ c:
t=~cC:o ,... v o "is ~ e ='~ ~ ~UJ a ;; ~8.
r:;;.o...-iUQ)C;::~Vl t:: p.. B>tr.l "';:I ::s 1;3c: = o"'CI = u.. tnx
~ "'0 E U) Ci ::s ~ foil ~ ~ ~ ~ ~ ::1 0 >..~ > 8.'~ U] tJ:J s::: -- (;- ~ ~ t.U I
OJ <=: E lo... ~ o::s Q,l 0 _ ~ "'0 j.....j 0 ~ "'0 ~ "'Cl Q) = "'0..... . 0 :;) - ...- Q)
~~v~"'Og5 ~o ~o~.~8,~_g~5 ~~ : 8~~~~Ot ~ .~3
foil tI'l f/) Cl:3 > ..... ...... ,>' cd ro Cl.- '- -. ._ r.n CJ') "0 r.n tr.I .- > .-
~ ~~~Q)~~~ ~Cl:3 ~~Q)E=6~~Ox o~ ~-~~EQ)~~~_ ~ ~~
~~.G5~~~~~ ~~'~v~~~g~~'~~i~ ~~ t~~~.a]~~~~ e ~g
;;. ~ ~.S:! B ..c .5 .....5 c.. Q) '0 .!::: e -g "5 8.- ,..0 'C ..... '5. ,s 8 c: ~ ;J c.:.2 S 2 ~ c: .9 Vl ..... .E 0
~~~~Bu~2~ ~o~~~~u~28~Ba~ ~2 5-~~l~~~~2 ~ 82 100 I
I
I CITY OF SHAKOPEE
Scott County, Minnesota
Table 5
TAX CAPACITY AND ESTIMATED ACTUAL VALUE OF TAXABLE PROPERTY
I Last Ten Fiscal Years
Taxable Tax
I Estimated Capacity as a
Commercial Less: Less Net Net Taxable Total Taxable Percentage of
Fiscal Residential Industrial Other Tax Increment Fiscal Tax Direct Market Estimated
Year Property Property Property Property Disparities Capacity Tax Rate Value Market Value
I 1999 $ 7,580,688 $ 9,460,927 $ 551,646 $ 1,231,584 $ 1,452,992 $ 14,908,685 0.23358 $ 897,901,119 1.66%
2000 8,920,457 10,681,728 530,294 1,211 ,989 1,718,112 17,202,378 0.20132 1,087,145,000 1.58%
I 2001 11,560,704 13,820,811 542,037 1,801,828 1,997,080 22,124,644 0.17983 1,369,102,400 1.62%
2002 11,469,272 10,023,762 409,721 975,773 1,543,453 19,383,529 0.33976 \,743,136,300 1.11%
I 2003 13,890,536 10,452,944 589,540 497,860 2,035,749 22,399,411 0.33939 2,062,115,200 1.09%
2004 16,721,302 10,609,240 913,912 497,255 2,121,170 25,626,029 0.32433 2,464,564,300 1.04%
I 2005 20,394,086 I 1,749,438 528,300 327,963 2,132,628 30,211,233 0.31115 2,654,161,900 1.14%
2006 23,162,320 12,710,783 565,215 352,543 1,615,190 34,470,585 0.30974 2,987,657,400 1.06%
I 2007 26,817,616 14,013,644 675,479 378,593 1,963,379 39,164,767 0.31939 3,419,040,600 1.06%
2008 29,942,078 15,426,355 741,679 411,490 1,846,9 I 9 43,851,703 0.31925 3,800,795,500 1.06%
I Source: Scott County Auditor
I'
I
I
I
I
I
I
I
I 101
I
CITY OF SHAKO PEE I
Scott County, Minnesota
Table 6
DIRECT AND OVERLAPPING PROPERTY TAX RATES I
Last Ten Fiscal Years
City Direct Rate General I
Obligation
Shakopee Debt Service I
Fiscal Operating Debt Service Total Direct School Scott Other Market Value
Year Rate Rate Rate District County Jurisdictions Rate
1999 0.21660 0.01698 0.23358 0.58686 0.39282 0.03192 0.02909 I
2000 0.18699 0.01433 0.20132 0.50203 0.36182 0.04324 0.02497 I
2001 0.16959 0.01024 0.17983 0.42982 0.31729 0.03034 0.01980
2002 0.33194 0.00782 0.33976 0.26080 0.39517 0.04976 0.00764 I
2003 0.33172 0.00767 0.33939 0.24168 0.38554 0.05685 0.01393 I
2004 0.31131 0.01302 0.32433 0.21517 0.36635 0.04123 0.01189
2005 0.29855 0.01260 0.31115 0.25215 0.35361 0.04660 0.00969 I
2006 0.28996 0.01978 0.30974 0.27789 0.34974 0.04578 0.00848 I
2007 0.29822 0.02117 0.31939 0.27132 0.33140 0.04434 0.00728
2008 0.29874 0.02051 0.31925 0.26103 0.32646 0.04642 0.00537 I
Sources: Scott County Auditor I
I
I
I
I
I
102 I
I
I CITY OF SHAKOPEE
Scott County, Minnesota
Table 7
PRINCIPAL TAXPAYERS
I Current Year and Nine Years Ago
2008 1998
I Percentage Percentage
2007/08 of Total 1997/98 of Tatal
Tax Cap. Tax Cap. Tax Cap. Tax Cap.
Taxpayer Type of Business Value Rank Value Value Rank Value
I Excel Energy Electrical Generation $ 532,876 I 1.32% $ 775,758 2 4.76%
Shakopee Crossings Retail 436,954 2 1.08%
I Rahr Malting Grain Processing 408,370 3 1.01% 794,205 I 4.87%
Seagate ManufacturinglResearch 399,250 4 0.99%
I Certainteed Manufacturing 397,522 5 0.99% 265,439 7 1.63%
Inland Shakopee Valley Market Retail 388,392 6 0.96% - -
I Valley Fair Amusement Park 358,348 7 0.89% 550,000 4 3.37%
First Industrial LP Property Management 350,574 8 0.87%
I Ryan Companies Property Management 329,094 9 0.82%
Canterbury Park Horse Racing 314,748 10 0.78% 241,488 8 1.48%
I KMart Warehouse WarehouselDistribution Center - 654,740 , 4.02%
J
Tsumara Manufacturing - - 493,682 5 3.03%
I Opus Warehouse - 286,414 6 l.76%
AA Holdings Auto Auction - - 229,234 9 1.41%
I Carlson Real Estate Retail Mall - - 199,386 10 122%
$ 3,916,128 9.72% $ 4,490,346 27.55%
I Source: Scott County Auditor
I
I
I
I
I
I 103
I
CITY OF SHAKOPEE I
Scott County, Minnesota
Table 8
PROPERTY TAX LEVIES AND COLLECTIONS
Last Ten Fiscal Years I
Ratio of
Accumulated I
Percentage Delinquent
Co lIections Percentage Collections of Total Accumulated Taxes to
Year Tax of Current of Levy of Prior Total Collections Delinquent Current
Collected Levy Years Taxes Collected Years Taxes Collections To Tax Levy Taxes Years Taxes I
1999 $ 3,819,736 $ 3,757,750 98% $ 25,186 $ 3,782,936 99% $ 65,389 1.71%
2000 3,853,808 3,738,963 97% 24,342 3,763,305 98% 88,656 2.30% I
2001 4,477,969 4,335,602 97% 62,905 4,398,507 98% 61,661 1.38%
2002 6,645,713 6,484,920 98% 41,342 6,526,262 98% 70,622 1.06% I
2003 7,889,018 7,191,567 91% 47,055 7,238,622 92% 79,710 1.01%
2004 8,625,695 7,878,618 91% (86,619) 7,791,999 90% 175,774 2.04% I
2005 9,703,206 9,025,261 93% 67,187 9,092,448 94% 164,517 1.70%
2006 10,951,9]7 9,945,490 91% 38,986 9,984,476 9]% 279,316 2.55% I
2007 12,745,449 12,418,768 97% 91,200 12,509,968 98% 331,315 2.60%
I
2008 ] 4,222,007 13,661,366 96% 208,470 13,869,836 98% 483,317 3.40%
Source: Scott County Auditor I
1. The above data does not include tax increment districts.
2. The State of Minnesota cancelled $ 561,000 in 2003 to 2006 and $ 243,439 in 2008 of annual
aid payments to the City that were part ofthe tax levy. I
I
I
I
I
I
I
104 I
I
I CITY OF SHAKOPEE
Scott County, Minnesota
Table 9
I RATIO OF OUTSTANDING DEBT BY TYPE
Last Ten Fiscal Years
I Governmental Activities
GO Revenue Business-type
I General Tax Special Activities Total Percentage
Fiscal Obligation Increment Assessment Revenue Primary of Personal Per
Year Bonds Bonds Bonds Bonds Government Income Capita
I 1999 $ 2,880,000 $ 2,020,000 $ 15,090,000 $ 14,480,000 $ 34,470,000 6.5% $ 2,004
2000 2,780,000 1,400,000 14,215,000 14,235,000 32,630,000 4.7% 1,586
I 2001 2,675,000 755,000 11,660,000 26,000,000 41,090,000 5.5% 1,852
I 2002 2,565,000 390,000 14,055,000 25,660,000 42,670,000 5.5% 1,785
2003 2,445,000 - 13,060,000 25,215,000 40,720,000 5.0% 1,631
I 2004 10,595,000 - 18,205,000 25,515,000 54,315,000 5.5% 1,879
I 2005 8,275,000 - 16,360,000 24,750,000 49,385,000 4.7% 1,593
2006 7,950,000 17,070,000 34,535,000 59,555,000 5.5% 1,816
-
I 2007 7,560,000 - 17,165,000 33,895,000 58,620,000 4.8% 1,752
2008 7,165,000 - 16,450,000 33,225,000 56,840,000 N/A 1,689
I
Sources: See Table 14 for income and population data.
Bureau of Economic Analysis
I
I
I
I
I
I
I 105
I
CITY OF SHAKOPEE
Scott County, Minnesota I
Table 10
RATIOS OF GENERAL BONDED OUTSTANDING
Last Ten Fiscal Years I
Percentage of Percentage of I
Actual Taxable Total
fiscal G.O. Value of Per Personal I
Year Bonds Property Capita Income
1999 $ 2,880,000 0.32% $ 167 0.54% I
2000 2,780,000 0.26% 135 0.40%
2001 2,675,000 0.20% 121 0.36% I
2002 2,565,000 0.15% 107 0.33% I
2003 2,445,000 0.12% 98 0.30% I
10,595,000 0.43% 366
2004 1.07%
2005 8,275,000 0.27% 267 0.76% I
2006 7,950,000 0.27% 242 0.65% I
2007 7,560,000 0.21% 226 0.61%
2008 7,165,000 0.19% 213 N/A I
Sources: I
1. Metropolitan Council population estimated except for 2000 which is the
the official census figure. 2005-2008 are the City's estimate. I
2. Scott County Auditor
I
I
I
I
106 I
I
I CITY OF SHAKOPEE
Scott County, Minnesota
I Table 11
DIRECT AND OVERLAPPING GOVERNMENTAL ACTIVITIES DEBT
December 31, 2008
I
Percentage Amount
I Applicable Applicable
G.O. To City of To City of
Debt Shakopee Shakopee
I City of Shakopee $ 23,615,000 100.0% $ 23,615,000
Independent School District No. 720 158,250,000 85.2% 134,829,000
I Independent School District No. 191 77,895,000 2.0% 1,557,900
Scott County 73,550,000 27.1% 19,932,050
I Metropolitan Council 21,645,000 1.2% 259,740
Metropolitan Transit 194,335,000 1.6% 3,109,360
I Total Direct and Overlapping Debt $ 549,290,000 $ 183,303,050
Source: Scott County Auditor
I Dakota County Auditor
State Department of Revenue
I
I
I
I
I
I
I
I
I 107
I
~ 0 l./) OOO'NM
.... 0 \0 .0 0 C'\ r-
..:: lI"'.l 00 .0 -..0 M <o:::t
.Q ... . . .
~ ~ ~ ~ ~ ~ ~ ~ I
t- gt'-" 0.. "e~r-:
__,0 -q-- f' \Or-
\"'1:;; :: ~
...,
~ ~
o N 0 C) V"l l"""- I
o 0 I.(') -.::t \Q .
\0 00 0 000\
o 0 O"~V)"~'"
r----.:::t 00 \OMN'-n
QO M l./)OOr->..O
Q " " ,,___ n
N; ~ ~ ~ ~ I
~ ~
0. 00 O~\QN
o "=t' <0 0'\ 0 "'::t"
~ 0 ~ ~ ~ I
r-" f"")" 0 0 0\ ~
Vi lI') lti ("j
~\C... t-;. O'\.,e...~
Or- 0\ r- I'N
M 00 trl t.r)
a-
N
~ ~ I
~ ~
o 00 0 00 (".I \0 .5 ~ .
o ~ o~V')oo ~ r.n r.9 E '
0\" ~ ~"tri ~ ~ ~ ~ 1 S:fa
~ \0 ~ ~ ~ - ~ ~ ~ ig ~.~
Q . . . .. ... "...... ,,'t:l I
M..q- MOOr-.... V'l ::s .J:: Cl)o. t..c
~ I.(') ~ v g ~ ~~ ~ ~
N .- 0 ~ -5 C.~
~ ~ ~ [~~ ~ ~
~ '(3 g ca ~ ~ ~
o \0 0 N 00 00 ~ = ~~ ~ g ~
g ~ 8 ~ ~ C:; ~ e- ~ Q. ~ Q) .9- I
<<::f " tri' 0:' ~ ~ ..c:: ~.5 u:o.~
\0 0\ 0'\ ('f'j l./) M VJ .......- '- ~ .- ~
~ '" N. ~. '" q ~ ,.= '0 ilo '" U ::l .
'7 e 'o::t 0\ .0 N 00 - a) Q,) ~Q,) ro -5 s
~ MI.O <o::j" ---- .q- ..c:: ..."0 C <v:>..,
o ~ e::: ~ €..c: 0 ~ ~
E: N 0 e 4)$ ] ~ ~ I
< ~ ~ ~ ~ ~,5 ro 0 0
~ '6 I ~a ~ a $
~.:! ~ __ ro iU l:11J v ~ Cl)
~~ 05 g ~ g ~ ~ ~ 0 ~ &~ ~ ~ t
~~ ~~ N M '.0 \0 ("f"') 0'\ ...... .:o::$~ ell I-. C
0= z> ~ N ~ ~ ~ ~ u ~ ~~ I-. ~ V
~.- ..... _ ('t"'j _ ~ -:::t 0\ .q- 0\ l- "'tj ,(1).D ~ -:s ..c:: I
-< ~ 2S ~ ~ " N,. '<:t"!j,,, 0" :.a ~ ~ .5 0 ~ ~
~ i- u ~ N ~ ~ N N ~ "0 ~ ';;; ~ e- 6 ,5
~; ~ = ~ ]= ~ 5 s ~ .~ g.
0= 2~ ~ ~ M~ - Ei .s.~ E
>u _ ro~ E ~~ ~ ~ 8
,... t: ,... '" _ '" 0" 'C "0 '- I
08:~ 0 \0 0 ~ - ~ &.~ ~ a5 ~ ~ 0
~ ~ ~ ~ & A ~ ~ ~.~ .~ ~.~ ~ ~ ~
\.0 f"".I l.(') V 0 Q.} :::1 _.~ >. .;::: q) CI.l
~ N ~ ~ ~ ~ ~ 00 ~E g il~ ~ E ~
~ g ~ ~ 4'1, (:!., <"'1 "l .:::' a> --g Q. ~ OJ) .z 5
~ N ~ ~ N N ~ ~~ ~ ~,~ ~.~ ~
~~, .- '" ... 0 .- - OJ) 5 I
_ Q ._ V rJ'J!::: ..0 C ~
&ll7 €t7 '2 ~ ~ -g 2 s.. - -e
:::J t:: 4) J;;;; K (l)
~ s 8. .S> ~] -g ~ -g
g ~ g 0'1 00 fa g ~ .5 6. ;; . ~ is g
-c:t 0 0 \.0 t"") \0 .... ro lU . ""=' S loo< ,-
N N ~ 0 ~ ~ ~~ ~ ~e ~s~ ~ 0 I
~ 0 ~ ~ ~ ~ g ~~ ~ E] ~~~] ~
= .... ~ .. __ .. n ('. ~ !:: 0'" ,2 ~ ~ .=' e
N 0'1 t""'- N N VI """ _ ::3 ct: eo J: ...... . ("j::i Cl:S
1..0 N N 01:.0-. 0 c:: Q)~ CI:I"O Oil rJ:l
~ -0 E b.s >o~~c "0
- - (l) ~ 1:: en g ;> 0 .- :.!2 =
~ ~ ~~ ~ !.~ Q~~~.E 2
_ ~ :; : 8.€' ,SO 5 ~ u: ~ I
o 0 0 ~ M ~ ~lU 5 ~~ ~E~~~ ~
o 0 0 ~ ~ ~~.~ =~ ~~ ~
q ~ q ~ ~ ~ .g~ ~ ]'S ~~~~~ = i
g ~ ~ i ~ ~ ~ ~~ ~ ~.~ ~~~~j ~
Q ^ r- r-: c ""t ~ Vl..= ~.!!E ~lUE=tf.l~ -g
M ~ N M N ~ .5~ ~ ~u ~~~o'~~ ~
o~ "0 0 t);;... -5 =' ~ [3 ~ ::s 'C _ I
V; EA ~@' ~ s.'Q ~~a~~~ a3 .
.~ ~ ~ ~ ~ ~ ~ E 5 ~ ~ ~
Q\ N 0 ~ V) r--.. E5..s g ~.g ~E8.~~~ ~
_ N 0 00 0 Q) <c; .- ,S:! ~ fJ:: 0 eq .a "'5 0 .5
0" 0" ~ 0.. 0.. '=' .~ '* '~-j.JJ ~ g l:: ~ :.2 Q) ;.< I
~ 00 0 ~ ~ ~ ~~~ ._ ~ Q).-'~~~E S
C\ ~ ~ gg ~ ~ ~ tU ~ -- :g tJ 0 .t:: <1) C ^ ~ -: i
c:J\ ^ ^ ... '"-" ~ " 0 ..J:: ';:R :::3 l:: ~ l:: ..c .- g E ';). _
~ ~ ~ N N ~ ~o~ ~ e~ ~EE~~8 c
~ fA Z '0 0 tn ~ [i "0 0 ~ .; Q) ~ ,~
I: +-> r.n a. 0 b1l 0 tl:: 0 0'" CJ Q) .-
cn U <1) ,:: 8 ~ :; (i e 23 ~ 6 ~ ~ .~ ~ ~
"<:l", -;:: s- >< '" E"'="'o",,<=v ..0 I
Q.) t:..... ~ ~ Q) ~.- ..c a) .- ..c: \0,;., ..c u I: ='
:z 0 i::" :J . '" "... .~ E ~ ~ '" - > OJ '"
_ _ ~ mu = ~~.- c ~~~~Q.)s~~~ ~
~ ~< ~ c~ ~~ M~Z ~~~r.n~~~~c ~
,.0 _ v Q.. .9..0 < E l(') s.-;, Q.) I.() \U 11) en ~ ~ IU "'0 u 0 -
~ ~o Q. (diU ~ t: ~g"'C vi ~!;fJ~-o>-.~~:.=E a\
~ 2 b ~ ~ ~ ~ 1)'~ !;; c3 ~ ~.~ .s ~ ~ g,.;!? .~ .g ~ ~ I
- ~ Q) ~.~ ~..... 0 0 ~ g. cO g ~ /)J) U Q ~ ~ !::: ~ r.-.. s::
g ..2 Q S _ ~ r.n ";j ~ ',j:: - 0 'c.g .5 8. ~ ,9 .S .2 4) ~ .g
_ _ >ro ~ 'i c:s ..c '0 ~ 0 01..> .. CJ C - .. (,) ~ 11) <:IJ J:: ~ -:: - -5 I: CJ
~.- 0 - l- ~ ~ 0...... ..c ,.-." IU 0 - - 4> b:b "d Q) ~ b"h Oh ~ 0:::3 ll) .
> E_ __~~=~ Q) <oo'~g ~oo ._~~~._._._~o 00
u :J~ g~,,>~ 0 ~~'SF ~~ :Z~~~:Z:Z:Z~E ~
~ ~ta 000< ~ ""~~i ~~ 0-0 000 < ~
t<l "::E S 0 OJ) o...g o. ~ ~~~~ ~ . I
::E 0 < - .3 z::E OIl J5 z::E '-' ~ c :'!, ~ ~ ::E 108
I
I CITY OF SHAKOPEE
Scott County, Minnesota
I Table 13
PLEDGED-REVENUE COVERAGE
Last Ten Fiscal Years
I
Utility Bonds
I Utility Less: Net
Fiscal Service Operating Available Debt Service
Year Charges Expense Revenue Principal Interest Coverage
I 1999 $ 15,615,257 $ 11,990,257 $ 3,625,000 $ 205,000 $ 252,687 7.92
I 2000 19,212,094 14,212,682 4,999,412 230,000 620,116 5.88
I 2001 21,667,471 16,153,413 5,514,058 235,000 797,759 5.34
2002 21,148,771 16,343,532 4,805,239 340,000 1,468,242 2.66
I 2003 22,871,121 17,585,831 5,285,290 580,000 1,348,883 2.74
I 2004 25,473,439 19,778,149 5,695,290 640,000 1,307,626 2.92
2005 33,841,730 25,821,489 8,020,241 765,000 1,074,487 4.36
I 2006 38,445,403 31,436,969 7,008,434 785,000 1,174,711 3.58
I 2007 44,692,049 36,644,414 8,047,635 640,000 1,574,925 3.63
I 2008 45,499,791 38,689,351 6,810,440 670,000 1,523,198 3.11
1. Operating expense excludes depreciation.
I
I
I
I
I
I 109
I
CITY OF SHAKOPEE I
Scott County, Minnesota
Table 14 I
DEMOGRAPHIC AND ECONOMIC STATISTICS
Last Ten Calendar Years
Fiscal School Unemployment Total Per Capita Personal I
Year Population (1) Enrollment (2) Rate (3) Employment Income (4) Income (5) I
1999 17,200 3,723 1.8% 12,373 $ 30,894 $ 531,376,800
2000 20,568 3,900 2.6% 12,740 33,709 693,326,712 I
2001 22,192 3,892 4.0% 13,809 33,401 741,234,992 I
2002 23,900 4,487 4.0% 15,024 32,575 778,542,500
2003 24,967 4,790 4.3% 15,887 32,760 817,918,920 I
2004 28,913 5,121 3.9% 16,213 34,284 991,253,292 I
2005 31,000 6,247 3.6% 16,192 35,956 1,114,636,000
2006 32,800 6,643 3.7% 17,787 37,023 1,214,354,400 I
2007 33,460 6,905 4.6% 18,225 39,042 1,306,345,320 I
2008 33,660 7,163 6.7% 18,688 N/A N/A
Source: 1. Metropolitan Council polupation estimates except for 2000 which is the official I
census figure. 2005-2008 are the City's estimate.
2. Shakopee School District, SACS, Bloomington Lutheran I
3. Minnesota Department of Employment and Economic Development
4. Bureau of Economic Analysis
5. Scott County per capita income times population I
I
I
I
I
110 I
I
I CITY OF SHAKOPEE
Scott County, Minnesota
Table 15
I PRINCIPAL EMPLOYERS
Current Year and Nine Years Ago
I 2008 1998
Total Total
City City
Taxpayer Type of Business Employees Rank Employment Employees Rank Employment
I Valley Fair Amusement Park 1,600 I 8.56% 1,537 I 13.27%
I Seagate ManufacturinglResearch 1,200 2 6.42% -
Canterbury Park Horse Racing 1,100 3 5.89% - -
I School District No. 720 Education 947 4 5.07% 437 4 3.77%
St. Francis RMC Health Care 900 5 4.82% 363 7 3.13%
I Scott County Government 713 6 3.82% 500 3 4.32%
North Star Auto Auction Auto Auction 332 7 1.78% 240 12 2.07%
I American Color - SVP Printing 287 8 1.54% 415 6 3.58%
Anchor Glass Glass Container Manufaturing 282 9 1.51% 278 9 2.40%
I City of Shakopee Government 251 10 1.34% - -
ADC Manufacturing - - 650 2 5.61%
I
Kmart Distribution Center - - 424 5 3.66%
I CertainTeed Roofing Manufacturing - - 300 8 2.59%
TORO Manufacturing - - 275 10 2.37%
I 6,012 40.73% 5,419 46.78%
Total employment 18,688 11,584
I Source: Minnesota Department of Employment and Economic Development.
I
I
I
I
III
I
I
'" '<"I'<:l"('O')V)r-M r- \0 Moo\O r-('O')('O') 00 r- M \0 00 r- - oo:t
...
QO oo:t oo:t - r- .-. - oo:t ..- I
~ ..- M
:c <::>
<::>
III N
E-
trl'<:l"('O')'<"I\OM \0 r- -oor- r-MM 000 oo:t \0 00 r- - V) I
r- oo:t '<:l" - - r- - .-. oo:t ,......
<::> - M
<::>
N
\Ooo:tMtrl\OM lI"\ r- I 00 00 O'>M('O') r-O lI"\ 0000\0 M r- I
'" oo:t oo:t ,...... - r- - ..- oo:t -
<::> - M
<::>
N
\Ooo:tMlI"\oo:tM MO'> I 000 O'>M('O') r-O oo:t '<"Ir-\O 00 M I
~ lI'l oo:t '<"I - - r- - ,...... ('0') -
<::> ,...... M
-< <::> I
~ N
0
0
~ \Ooo:tr<'l'<"loo:tM Or- ' 000 0'> - ('0') r- 00 r-
~
-- "'" oo:t '<"I ...- \0
;Z; <::> - I
0 <::>
- N
Eo-
U
;Z;
;;;l \'o~('<)\O-.- "1"r- 'Or- 0'> 0'> M r- 00 V) I
... ~ ('0') V) '<"I
>- <::> -
== <::>
N
00
~
~ I
>- \OM-.::t\O..-- "1"r- 'Or- O'>O'>M r- 00 oo:t
~~ 0 N M lI"\ V)
...:l '1.1 ..-
~ ~ ~ lo. <::>
<::>
~ ~ ~ ~ N
o a ~>- I
i;( .- Eo-'a
-<~ ;z; ~
== ~ ~ .- \o~'o:::;J-t.r)-..- '<"1\0 I r- r- 0'> 0'> M \0 0'> -
ooC ~... - M '<t "1"
... == <::>
o 6 ~~ <::>
N I
>-u ~....
Eo-:t: ;;.. ~
- Q O...:l
U <.I
00 0 "1"'<too:t'<"l- I "1"\0 'r-r- OOO'>M '<"Ir- M
<::> M '<:l" ('0')
~ -
<::> I
<::>
- N
U
Eo-
Z
~ '<:l"'<t'<:l"r-- I M '<"I I '<"I '<"I oor-M V) r- \0
...:l Q\ M '<:l" M I
~ Q\ -
Q\
- -
;;;l
0'
~ I
~
~
-
Eo-
I
...:l
...:l I
;;;l
...
I
'1.1
:>, .::! en I
o ~ :S E
.... u ..... == 0
= ~ 0 6 Q .... E
~
e <<l C ; 8 ;;;l 1::
C.J:: 'n <<l
Ec ~i3 ~ c .!: 0.
0 ~ crl :c 0
~ 0 ._ E- C 0. III b s:: -a "<::l I
;iilo- '.a ~ ..... en .;,: 01) ~~c<il =
Q ~ ..::<: ::;; g ~ "<::l o ~ .s lo. C ~ ] '0 :>,
o ti t ell Ul .~ Q .- ~ '; ,:9 '0 .....
co:l 4.> ECell ~ ~ ~ .9 E- O
_'- _ l1.) =: <l) ~ ~ 1-0. '.p 0 C = ::;; 'i;j .:0 ~ u
~ C U u .- .- E ~ 'C l-o ,-..g Q)
;.... .- c s::;..:::: .:!81::l~ :=::-5::9 .:= .5 t) 0.. III 4.>::l
~ E :>, <<l C .- 0 .;,:~tioo j'g~~r/1 u
== "<::l ..... s:: o;S u "'" - ;.::: ._ ~ <l) = Cl:S '- -01)4.>0 ....
~<Oli:;i;rf.E .g 0 ....l 0 .;: u., c.. ciS ~~.t:.J:: lo. o;S 0 ]5:i:so ::l I
~c.. u., ~p;.)r/1r/1 :.c..~ 0 112
00 r/1
I
~ OONO -~~ ~ ~~~ - ~ M O~~ ~~~ ~~~
~, ~ ~ OO~~ ~ -~~ ~ ~ M --~ N~~ ~~~
~ ~ ~q~ ~ q~ ~ - ~ ~~~ ~~~ ~~~
I ~ Q -~~ -~ - 0 ~ ~ 0--
C': Q..- -0' -00-
~ N -
I ~~OO ~M~ ~ ~~OO 0 ~ 0 ~~~ ~~OO ~~C
~ M ~~O 0 ~~~ ~ ~ M ~~~ M~~ NOO
~ ~~~ ~ ~~- ~..-. ~ ~~q ~~q ~~~
Q N~~ -~ ~ C 0 ~ M ~--
Q....... -0 -0\
N -
I -O~ OOM ~ --M ~ M 0 OOOO~ ~-C ~-~
~-~ ~~~ ~ M~N ~ ~ M N~~ ~~O -M~
~ ....... ~~~ ~ ~~N ~..-. ~ ~~~ ~M~ ~qM
o -~OO -~ 0 ~....... ~ ~ ~--
Q - - 0\_0\
....
I O~- -MM ~ N~N ~ M ~ M~M 00-0 ON-
N N ~~~ M -~~ ~ N N ~-~ ~OO -~~
r.n .-. M '"'t~C""'"t l.r) t.n...-~M ,,- 0\ oq.l.("',"'1. '...q,o::tll). r"ll':r--i
o -M~ -~ M ~ ~ ~ ~ ~--
I ~ - - - I"--~
~~~ OONN ~ OO~~ ~ ~ 0 ~-OO '0 l~~
o M ~O~ ~ MM~ M""'" ~ ~~_ O-~
~ ....... ~ ~~q ~ ~~M ~ - ~ ~~q q ~O
I Q -M~ -~ ~ ~ ~ 0--
10 ..-............ I:'"'-- C--
'"
I ::;: I"--~ I"-o,~ N '<1"'0'<1" 0, ~ - '<I"~'<I" '0 '0,0
, ~ N-OO qN~ ~ ~-OO ~ M ~ ~~- 0 NM
~ M ...... ~ ~~~ ~ ~qM ~...... ~ ~~q ~ ~N
~ Q -M~ -~ ~ 0 ~ ~--
"Q _ - -I"- ~
o N
IX
i:l.
I ~ -O~ oo~o, \0 O'O~ 0 - ~ -000 '0 '"<to
~~ r:CI) N ~-~ ~~,,~ ~ M,,:;;:'N \0" ~ ~ a::"~~,, 8n ~~
~O U~ Q -M~ -- ~ ~ 0 ~......
~~ Z~ Q -............. r- \0
I ~.g ~~ M
<::;: >e
:= . CC '"
CIl.e> CIl/i: No,N <<M 00 o-,~N oo"<t ~ <<< '0' MM
~== ~= O-~ _~- 00 \OC--~ ~ N M ~_~ 0 NO
OQ 0" _ - - :Z:ZN."<t '<l;.~.'<t q - ~ :Z:ZZ '<1".0
"....~ Q '" -- I"- --
>"" <.... Q - - ~
I' !:::~ U~ M
VCJ ~~
Vl Q
~
~ -~o-, <<< ~ "''<1"00 0 ~ N <<< '0 '--
7 0-- __~ ~ ~O~ ~ - - ~~_ 0 ~OO
I ~ c - - ZZZ '<t '<l;.q'<l" ~ - ~ Z:zZ ~ qoo
~ 0 -~ ("f') N -
< Q - ~
c=: ....
WJ
i:l.
o
I ~'O< <<< 0 ~'<I"I"- 0, ~ N <<< '0 'MO
-N~ __~ ~ ~~~ ~ - - ~__ 0 NN
~ - Z ZZZ '" q~'" ~ - ~ Z:z:z q o-,~
~ M ~
~ ~
-
I
I
I ~ ~
~ S ~S ~ ~
.- 0 ~ .- ~ ~
I ~ e ~J g g
~ ~~~ a fiE ~ ~ ~ ~
~~~ ~~~ ~ ~~~ E < <~ ~
~ ___ ~O u ~_
= .- .- "- ~ '+:l S 2 = c:: ...... <:: "8 ",. "8 E 'OJ) '"
~ ~~ ~-uo ~ ~ Q ~ ~~2 ~ ~ ~ ~~ E
~ MI! 8 8~~R= !. i8! '~66 u I~~ Ii! i
I al U ~ ~ .~ .~ R 5 .E B ~ 8 g ~ ~.~ .~ ~ ~ ~ :E 5] ~ E] .@'
~ ~~~ r Vl Vl!"-~; ...I~ IX ~~'~c::"-~'a ~ ~~E ~fs ~
I-< J- 1--0 __ t'I];-. $..0 I"'"'"l on I- 0 .-...- ~ ._ J- Q) ~ (1) .t:
. ~I~~~ ~ 8Ba al.5~~ ~bg 0 ~.~~;~~ ~u~VlC ~!c u
~]~~~ !~gl~",~~~~J !1~1~ !~uet~~ J~]~11]~1 ~
I 5SZ:ZZ io<uu.~UaCQZVl i~<~. ~.<B"-UU J~~~~~~o,,- g
~ "- i:l. "- ~..... i:l. Vl ll.o ~.... VJ (/) 113
I
~ _~~ N ~~ ~~~ ~ ~-o
~ - ~N -~N ~~-
~ ~ _ O~ -t--~ I
....... c ~ 'f"'""'1
,.Q Q
ec N
Eo-<
-~~ N ~~ ~t--N ~ ~OO I
_ ~N -~N ~~-
~ - q -~
Q --
~ I
_~~ N ~~ ~t--oo ~ ~OO
_ ~N -~- ~~-
~ _ 0 _t--
~ ~ - I
-~~ N ~~ ~~~ ~ 0 I
_ NN N~- -
~ - ~
Q
Q
N
~ -..-::; N ::::<:l 8~::;"-::: I
o ~ - t--
~ Q I
~ Q
__ N
Z
o
....
_ ~ -~N N OO~ -N~ ~ I
~~ u - ~N t--~-
~Q Z~ ~ - ~
~~;Jec Q
0;3 ~~ ~
~.- ~-
<~ ~e I
~~ ~~ -~N N -- ~NN ~
= .... _ ~N ~~-
~= ~~ N - ~
00 ~~ g I
~U~..... N
~::: <~
....0 ~~
U~ 00
~ _~_ N ~- OONN ~
~ _ ~N ~~- I
00 ~
00 Q
< ~
~
~ -~O N ~- NN- ~ I
~ _ -N -~-
< Q - ~
U Q
~ I
_~-< N ~- NN- ~
-- -N -~- I
Q'\ z - ~
Q'\
Q'\
....
~ ~ I
::: ~,-.......
o ::: OIl :::
.~ .~ S ~
;>. ~ ~ '-" S I
Cl:l t) ,.,:;.0 1:::
~ ~ ..0 ~.~ c<$
"t:l- ;:l ~mu 0..
00 c<$Cl:l m r;n ~"""'a ~
~2 ~ o~ m"t:l ~ ~~c<$ "t:l
S 'S = ~ .~ "t:l ::: 0 ;;> !-< U .0
00 N ......., Q "-' 00 Q) ;:l ~ "-' "t:l.~ I
::: ~ ~ 0 U .~ 0 ~ 0 ;>. ~ U
0""'''''' ec m ~ m~ (J..o m:I: OIl
~'.;::e8 ~ .....2tE ",e:::::~ 'i:S .2~~ ~
" Cl:l ~ ..... ~ .~ c<$ ~ U _ Cl:l .....;:l ~ .~ !-< 0 U
- ....... c<$ c<$ ~ ~ ,,<:,!-< -...... w ..... (J z ..... "<:' .~..... !-<
~r;n~~ . .,.,:;E-< ;""-<o::l~ ~ ec,.,:;~r;n;:l
~ ~ ~ ~ ~ ~ as 114 I
I
I
I
I
I CITY OF SHAKO PEE
Scott County, Minnesota
I Reports on
Government Auditing Standards
and Legal Compliance
For the Fiscal Year Ended December 31, 2008
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I CITY OF SHAKO PEE
Scott County, Minnesota
I TABLE OF CONTENTS
I REPORT ON INTERNAL CONTROL OVER FINANCIAL REPORTING
AND ON COMPLIANCE AND OTHER MATTERS BASED ON AN
I AUDIT OF FINANCIAL STATEMENTS PERFORMED IN
ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS ............................... I
REPORT ON LEGAL COMPLIANCE ............................ ..... ............. ......... .......... ....... .......... 3
I SCHEDULE OF FINDINGS AND RESPONSES ON LEGAL
COMPLIAN CE AND INTERNAL CONTROL.................................................................. 4
I
I
I
I
I
I
I
I
I
I
I
I
I
I ~DV
I
I Expert advice. When you need it. .1M
I REPORT ON INTERNAL CONTROL OVER FINANCIAL REPORTING
AND ON COMPLIANCE AND OTHER MATTERS BASED ON AN AUDIT OF
FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH
I GOVERNMENT AUDITING STANDARDS
I June 2, 2009
I Honorable Mayor and Members
of the City Council
City of Shakopee
I Shakopee, Minnesota
I We have audited the financial statements of the governmental activities, the business-type
activities, each major fund and the aggregate remaining fund information of the City of
Shakopee, Minnesota, as of and for the year ended December 31, 2008, which collectively
I comprise the City's basic financial statements and have issued our report thereon dated June 2,
2009. We conducted our audit in accordance with U.S. generally accepted auditing standards
and the standards applicable to financial audits contained in Government Auditing Standards,
issued by the Comptroller General of the United States.
I INTERNAL CONTROL OVER FINANCIAL REPORTING
I In planning and performing our audit, we considered the City's internal control over financial
reporting as a basis for designing our auditing procedures for the purpose of expressing our
opinion on the financial statements, but not for the purpose of expressing an opinion on the
I effectiveness of the City's internal control over financial reporting. Accordingly, we do not
express an opinion on the effectiveness of the City's internal control over financial reporting.
I Our consideration of internal control over financial reporting was for the limited purpose
described in the preceding paragraph and would not necessarily identify all deficiencies in
internal control over financial reporting that might be significant deficiencies or material
weaknesses. However, as discussed below, we identified certain deficiencies in internal control
I over financial reporting that we consider to be significant deficiencies.
A control deficiency exists when the design or operation of a control does not allow management
I or employees, in the normal course of performing their assigned functions, to prevent or detect
misstatements on a timely basis. A significant deficiency is a control deficiency, or combination
of control deficiencies, that adversely affects the entity's ability to initiate, authorize, record,
I process or report financial data reliably in accordance with U.S. generally accepted accounting
principles such that there is more than a remote likelihood that a misstatement of the City's
financial statements that is more than inconsequential will not be detected by the City's internal
I control. We consider the deficiencies described in the accompanying Schedule of Findings and
Responses on Legal Compliance and Internal Control as Audit Findings 06-01, 06-02 and 08-01
to be significant deficiencies over financial reporting.
I I
I ~DV
I
I
A material weakness is a significant deficiency, or combination of significant deficiencies, that
I results in more than a remote likelihood that a material misstatement of the financial statements
will not be prevented or detected by the City's internal control.
I Our consideration of the internal control over financial reporting was for the limited purpose
described in the first paragraph of this section and would not necessarily identify all deficiencies
in the internal control that might be significant deficiencies and, accordingly, would not
I necessarily disclose all significant deficiencies that are also considered to be material
weaknesses. However, of the significant deficiencies described on the previous page, we
consider Audit Finding 06-02 to be a material weakness.
I COMPLIANCE AND OTHER MATTERS
As part of obtaining reasonable assurance about whether the City's financial statements are free
I of material misstatement, we performed tests of its compliance with certain provisions of laws,
regulations, contracts and grant agreements, noncompliance with which could have a direct and
material effect on the determination of financial statement amounts. However, providing an
I opinion on compliance with those provisions was not an objective of our audit and, accordingly,
we do not express such an opinion. The results of our tests disclosed no instances of
noncompliance or other matters that are required to be reported under Government Auditing
Standards.
I We also noted certain matters that we reported to management of the City in a separate letter
dated June 2, 2009.
I The City's responses to the findings identified in our audit are described in the accompanying
Schedule of Findings and Responses on Legal Compliance and Internal Control. We did not
I audit the City's responses and, accordingly, we express no opinion on it.
This report is intended solely for the information and use of the City Council, management,
I federal and state oversight awarding agencies and pass-through entities and is not intended to be
and should not be used by anyone other than these specified parties.
I ~ I 7>( W.w>A, U..uu/ 6Izt
KERN, DEWENTER, VIERE, LTD.
I Minneapolis, Minnesota
I
I
I
I 2
I KDY
I
I Expert advice. When you need it. 8M
I REPORT ON LEGAL COMPLIANCE
I June 2, 2009
I
Honorable Mayor and Members
I of the City Council
City of Shakopee
Shakopee, Minnesota
I We have audited the financial statements of the governmental activities, the business-type
I activities, each major fund, the aggregate remaining fund information and fiduciary activities of
the City of Shakopee, Minnesota, as of and for the year ended December 31, 2008, which
collectively comprise the City's basic financial statements and have issued our report thereon
I dated June 2, 2009.
We conducted our audit in accordance with u.s. generally accepted auditing standards and the
provisions of the Minnesota Legal Compliance Audit Guidefor Local Government, promulgated
I by the State Auditor pursuant to Minnesota Statutes Sec. 6.65. Accordingly, the audit included
such tests of the accounting records and such other auditing procedures as we considered
necessary in the circumstances.
I The Minnesota Legal Compliance Audit Guide for Local Government covers seven main
categories of compliance to be tested: contracting and bidding, deposits and investments,
I conflicts of interest, public indebtedness, claims and disbursements, miscellaneous provisions
and tax increment financing. Our study included all of the listed categories.
I The results of our tests indicate that for the items tested, the City complied with the material
terms and conditions of applicable legal provisions.
This report is intended solely for the information and use of management, the City Council and
I state regulatory agencies, and is not intended to be and should not be used by anyone other than
these specified parties.
I ~ I Pe WbA-4, IJ~, U/.
I KERN, DEWENTER, VIERE, LTD.
Minneapolis, Minnesota
I
I 3
I
I CITY OF SHAKO PEE
Scott County, Minnesota
I SCHEDULE OF FINDINGS AND RESPONSES ON
LEGAL COMPLIANCE AND INTERNAL CONTROL
I December 31,2008
I CURRENT AND PRIOR YEAR INTERNAL CONTROL FINDINGS:
Material Weakness
I Audit Finding 06-02 - Material Audit Adjustment
During our audit, we proposed an audit adjustment we considered to be quantitatively
I material to the financial statements. The audit adjustment we proposed that was material to
the financial statements related to capital assets.
I City's Response
Infrastructure assets from an improvement project were under-capitalized. The process and
I coordination between staff members/departments involved has been changed to avoid a
reoccurrence.
I
I
I
I
I
I
I
I
I
I 4
I
I CITY OF SHAKOPEE
I Scott County, Minnesota
SCHEDULE OF FINDINGS AND RESPONSES ON
LEGAL COMPLIANCE AND INTERNAL CONTROL
I December 31, 2008
I CURRENT AND PRIOR YEAR INTERNAL CONTROL FINDINGS:
Significant Deficiency
I Audit Finding 06-01 - Lack of Segregation of Accounting Duties
I Adequate segregation of accounting duties is in place when the four areas of a transaction
have been separated: authorization, custody, recording and reconciliation.
As part of this year's audit, we reviewed the City's documentation of its internal control over
I significant areas including: cash receipts, cash disbursements and payroll. Areas in which
we noticed a lack of segregation are included below.
I Payroll
The Payroll Clerk processes payroll, posts payroll to the general ledger, issues direct
I deposits, prepares the payroll taxes, initiates transfers for payment of payroll, prepares all
W2s and maintains all data files as well as the payroll program.
I Cash Receipts
Deposits at the City Hall- The front desk personnel receives money, codes the revenue
and prepares bank deposits. The Senior Accounting Clerk reconciles cash and posts all
I deposits into the general ledger.
Deposits at the Recreation Center - One employee is able to receipt money and prepare
I the bank deposit.
Cash Disbursements
I The Accounting Clerk enters invoices, matches purchase orders to invoices and prepares
checks for payment.
I City's Response
The small size of the City's accounting staff limits how efficiently the segregation of
I accounting duties can be accomplished. In order to minimize the risk associated with having
a limited accounting staff, the City has the following oversight procedures in place:
I . The Payroll Supervisor reviews a detailed payroll report each pay period.
. The Finance Director takes the deposits for the City Hall and Community Center to the
bank.
I . All invoices are approved by an authorized purchaser.
. The Finance Director reviews each bill for payment and manually signs each check.
I 5
I
I CITY OF SHAKOPEE
Scott County, Minnesota
I SCHEDULE OF FINDINGS AND RESPONSES ON
LEGAL COMPLIANCE AND INTERNAL CONTROL
I December 31,2008
I CURRENT YEAR INTERNAL CONTROL FINDING:
Significant Deficiency
I Audit Finding 08-01 - Significant Audit Adjustment
During our audit, we proposed an audit adjustment we considered to be quantitatively
I significant to the financial statements. The audit adjustment we proposed related to
investments and interest revenue.
I City's Response
The City had received conflicting information on "mark to market" investment values from
I two different sources. The information deemed most reliable was first used at first but
reconsidered to use the more conservative numbers.
I
I
I
I
I
I
I
I
I
I 6
I
I CITY OF SHAKOPEE
Scott County, Minnesota
I SCHEDULE OF FINDINGS AND RESPONSES ON
LEGAL COMPLIANCE AND INTERNAL CONTROL
I December 31, 2008
I PRIOR YEAR LEGAL COMPLIANCE FINDING:
Prompt Payment to Subcontractors
I Minnesota Statutes 471.425, Subd. 4a requires contracts of a municipality to have the prime
contractor pay any subcontractor within 10 days of the prime contractor's receipt of payment.
The contract also must require the prime contractor pay interest of 1.5% per month or any part of
I a month to the subcontractor for any undisputed amount not paid to the subcontractor within the
10 days.
I During our 2007 audit, we noted the City's standard contract for improvement projects does not
contain specific verbiage referencing payment within 10 days or the payment of interest at 1.5%
as required by Minnesota Statutes.
I The City modified the 2008 standard contract to include the specific verbiage as required by
Minnesota Statutes.
I
I
I
I
I
I
I
I
I
I 7