FY 17 Annual Report

2017

ANNUAL FINANCIAL SUMMARY CITY OF SPENCER, IOWA

SUMMARY OF BANK ACCOUNTS Total Cash Transactions of all funds for the period July 1, 2016 through June 30, 2017, excluding Spencer Municipal Utilities and Spencer Hosptial Accounts.

CITY CLERK'S BOOK BALANCE JULY 1, 2016 PLUS: Receipts for Year Ending June 30, 2017 TOTAL TO ACCOUNT FOR: LESS: Disbursements for Year Ending June 30, 2017 CITY CLERK'S BOOK BALANCE JUNE 30, 2016

$ 25,977,779.45 39,086,531.95 $

65,064,311.40

35,166,818.84

29,897,492.56

144,831.22 (5,300.00) (31,705.33) (13,000,000.00) (24,143.86) -

PLUS: Warrants Outstanding LESS: Petty Cash LESS: Police Forfeiture Acct- Farmers Bank LESS: Investments LESS: Outstanding Deposit/Wire

LESS: Adjustment

$ 16,981,174.59

RECONCILED CASH BALANCE OF ALL FUNDS IN FARMERS BANK CHECKING ACCOUNT: June 30, 2016

STATEMENT OF BANK BALANCES AND SECURITIES As of June 30, 3017 (Excluding Spencer Municipal Utilities and Spencer Hospital)

$ 16,981,174.59 13,000,000.00

Checking IMMIA

INVESTMENTS - CERTIFICATE OF DEPOSITS: Farmers Bank CSI - Escrow/Wells Fargo

- -

-

TOTAL INVESTMENTS

$ 29,981,174.59

TOTAL BANK BALANCES AND SECURITIES

FINANCIAL SUMMARY