2023 Annual Comprehensive Financial Report

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

NOTE 4 – DEPOSITS AND INVESTMENTS (CONTINUED) A. Deposits (Continued) As of December 31, 2023, the City had the following deposits:

City Deposits Component Unit Deposits

$

17,200,555 3,299,451

Total Deposits

$ 20,500,006

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

Years to Maturity

Less than One Year

Moody's Rating

5-10 Years

10-15 Years

Concentration

Value

1-5 Years

Pooled Investments:

505,917 -

- - - - - - - -

Certificate of Deposit Money Market Fund

$

247,555 2,634,428 527,243 4,998,093 948,490 14,994,547 3,395,557 7,977,128 1,413,288 17,433,783 2,764,878

5.27% 1.00% 2.92% 18.39% 0.26% 2.78% 0.56% 0.74% 14.73% 8.41% 1.49% 24.06% 3.58% 15.81%

$

5,308,800 3,395,557

$

9,179,830 - 948,490 3,545,155 2,764,878 10,292,102 1,413,288 4,778,118

NR NR

Agencies

1,720,310 - 2,119,216 - 1,452,938 - 515,170 1,582,224 247,555 - 4,204,701 -

FFCB

1,478,700

AAA AAA AAA AAA AAA AAA AAA AAA AAA

FHLMC FNMA FHLB FAMC

-

5,022,465

- - - - - -

TVA

Agencies- Mortgage Backed

- 836,932

FHLMC FNMA

12,073 215,272

-

SBA

-

Agency Discount Notes

FHLB

699,741

127,425 699,741

- - -

- 9,638,972 8,403,951

AAA

US Treasury Notes Municipal Bond

22,810,750 13,971,098

AAA-AA3

14,406,799

NR

Money Market Fund Non-Pooled Investments:

-

-

1,513,983

-

100.00%

1,513,983

NR

$

12,348,031

$

51,192,129

Total Investments

$ 836,932

$

96,330,562

$

31,953,470

As of December 31, 2023, 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

$

5,523,601 36,767,216 962,655 9,208,430 8,546,272 2,480,034

$

1,325,267 16,439,470 151,574 9,208,430 8,546,272 2,480,034

$

- - -

$

- - - - -

$

- - - - - -

8.70% 57.91% 1.52% 14.50% 13.46% 3.91%

AA NR NR NR

4M Plus Fund

US Agencies US Treasuries Municipal Bonds Money Market Fund

811,081

4,007,691 20,327,746

AAA N/A

190,643

Total Investments

$

63,488,208

$

38,151,047

$

25,146,518

$ 190,643

$

-

The City’s investment policy, which covers all funds except the component units, addresses the following risks. The City’s component units also have a formal policy to address the following risks.

67