2020 Comprehensive Annual Financial Report

CITY OF SHAKOPEE

NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 2020

NOTE 4 – DEPOSITS AND INVESTMENTS (CONTINUED)

A. Deposits (Continued)

$ As of December 31, 2020, the City had the following deposits:

City Deposits Component Unit Deposits

7,361,716 8,854,061

Total Deposits

$

16,215,777

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

Years to Maturity

Less than One Year

Moody's Rating

Value

1-5 Years

5-10 Years

10-15 Years

Concentration

Pooled Investments:

Money Market Fund Certificate of Deposit

$

5,272,792 7,790,401

$

3,252,525 5,272,792

$

4,537,876

$

- -

$

- -

12.69% 8.59%

NR NR

-

Agencies

FFCB FHLB

1,504,200

1,004,300

499,900

- - - - -

- - - - -

2.45% 0.54% 1.63% 6.96% 1.65% 11.26% 0.49% 2.90% 1.06% 12.81% 36.97%

AAA AAA AAA AAA AAA

329,293 999,805

329,293

-

FHLMC FNMA

- - -

999,805

4,272,367 1,012,810

4,272,367 1,012,810

TVA

Agencies- Mortgage Backed

FHLMC FNMA

1,782,294 6,912,783

458

71,112

804,251

906,473

NR NR NR

- -

- -

1,712,283

5,200,500

SBA

298,347

298,347

-

Agency Discount Notes

FHLB

649,981

649,981 2,228,508 6,503,695

- 4,317,325 15,100,632

-

- - -

NR

US Treasury Notes Municipal Bond

7,860,219 22,693,574

1,314,386 1,089,247

AAA-AA3

AAA

Total Investments

$

61,378,866

$

19,241,552

$

30,811,827

5,218,514 $

$

6,106,973

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

Years to Maturity

Less than One Year

Moody's

Value

1-5 Years

5-10 Years

10-15 Years

Concentration

Rating

Money Market Fund Agency Discount Notes FHLB Non-Pooled Investments:

3,769,321

3,769,321

-

-

-

79.03%

NR

999,970

$

999,970

$

-

$

-

$

-

20.97%

NR

Total Investments

$

4,769,291

$

4,769,291

$

-

$

-

$

-

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

Years to Maturity

One Year Less than

Moody's

Value

1-5 Years

5-10 Years

10-15 Years

Concentration

Rating

Pooled Investments:

4M Fund

$

5,000,000 12,005,111 24,831,941 1,486,200 11,638,822 7,811,128 459,899

$

5,000,000 12,005,111 24,831,941 1,486,200 4,347,928 3,275,407 459,899

$

- - - - -

$

- - - - - - -

$

- - - - - - -

7.91% 18.99% 0.73% 2.35% 18.41% 39.26% 12.35%

NR NR NR NR

4M Term Series 4M Plus Fund

Money Market Fund

Brokered CDs US Treasuries US Agencies

N/A N/A

4,535,721 7,290,894

AAA

Total Investments

$

63,233,101

$

51,406,486

$

11,826,615

$

-

$

-

62