2021 Annual Comprehensive Financial Report

CITY OF SHAKOPEE NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2021

NOTE 4 – DEPOSITS AND INVESTMENTS (CONTINUED)

A. Deposits (Continued)

As of December 31, 2021, the City had the following deposits:

City Deposits Component Unit Deposits

$

10,443,261 6,906,420

Total Deposits

17,349,681 $

B. Investments As of December 31, 2021, the City held the following investments:

Years to Maturity

Moody's Rating

Less than One Year

Concentration

1-5 Years

10-15 Years

Value

5-10 Years

Pooled Investments:

4.70% 15.89% 1.52% 0.76% 0.45% 6.88% 14.89% 38.94% 1.50% 11.21% 3.26%

Money Market Fund Certificate of Deposit

$

2,114,889 7,263,643

$

242,486

$

2,501,568 2,114,889

$

4,519,589

$

- - - - - -

NR NR

-

-

Agencies

AAA AAA AAA AAA AAA AAA AAA

FNMA FHLB FFCB

493,770

- - - -

493,770

- - - -

3,046,478 986,210 10,294,147 290,862 4,459,597 9,651,992 968,845 25,231,360

3,046,478 986,210 10,294,147

TVA

Agencies- Mortgage Backed

FHLMC FNMA

421

44,494

290,862 1,148,675 2,598,185 552,664 499,283

371,266 3,310,922

- -

- -

SBA

- - -

Municipal Bond US Treasury Notes

4,966,659 18,017,879

6,714,198 2,087,148

AAA-AA3

AAA

$

64,801,793

$

13,418,224

5,332,155 $

$

42,369,226

$

3,682,188

Total Investments

As of December 31, 2021, the City held the following restricted cash for unspent bond proceeds:

Years to Maturity

One Year Less than

Rating Moody's

Value

1-5 Years

5-10 Years

10-15 Years

Concentration

Non-Pooled Investments: Money Market Fund

$

1,719,381

$

1,719,381

$

-

$

-

$

-

100.00%

NR

Total Investments

$

1,719,381

$

1,719,381

$

-

$

-

$

-

As of December 31, 2021, the component units had the following investments:

Years to Maturity

One Year Less than

Rating Moody's

Value

1-5 Years

5-10 Years

10-15 Years

Concentration

Pooled Investments:

4M Fund

$

359,878

$

359,878

$

- - - -

$

- - - - - -

$

- - - - - -

5.61% 57.65% 20.09% 3.69% 12.40% 0.56%

NR

4M Plus Fund

3,620,565 37,223,204 12,973,818 2,385,557 8,008,785

783,660 3,924,656 12,973,818 2,385,557 8,008,785

AAA N/A N/A NR NR

Commercial Paper Money Market Fund

US Agencies US Treasuries

2,836,905 33,298,548

Total Investments

$

64,571,807

$

28,436,354

$

36,135,453

$

-

$

-

61