FY 2017 - 2018 Audit

Schedule 4

CITY OF SPENCER COMBINING SCHEDULE OF RECEIPTS, DISBURSEMENTS, AND CHANGES IN CASH BALANCES NONMAJOR PROPRIETARY FUNDS AS OF AND FOR THE YEAR ENDED JUNE 30, 2018

EnterQrise Funds

Total Nonmajor Proprietar:y Funds

Airport

Golf Course

OPERATING RECEIPTS: Charges for services ................................................................. $ Miscellaneous ...........................................................................

$

$

170,250

352,525

522,775

942

8,883

9,825

171,192

361,408

TOTAL OPERATING RECEIPTS

532,600

OPERATING DISBURSEMENTS: Salaries .................................................................................... Payroll taxes and employee benefits ....................................... Repairs and maintenance ........................................................ Utilities ..................................................................................... Contract services ..................................................................... Insurance premiums ................................................................ Gas and oil .............................................................................. Supplies .................................................................................. Miscellaneous ......................................................................... Sales tax paid .......................................................................... TOTAL OPERATING DISBURSEMENTS

181,780 22,630 22,622 21,337

17,289

199,069 25,149 46,456 54,256 40,915 7,182 64,625 14,560 12,682 473,804 8,910

2,519

23,834 32,919 34,146

6,769

7,182

180

8,730

1,558 4,444

63,067 10,116 12,682 349,733

124,071

EXCESS OF OPERATING RECEIPTS OVER OPERATING DISBURSEMENTS

47,121

11,675

58,796

NON-OPERATING RECEIPTS (DISBURSEMENTS): Interest on investments ............................................................ Capital outlay ........................................................................... TOTAL NON-OPERATING RECEIPTS (DISBURSEMENTS)

6,176

791

6,967

{4,256} {3,465}

{4,256}

6,176

2,711

53,297

8,210

61,507

EXCESS OF RECEIPTS OVER DISBURSEMENTS

OTHER FINANCING SOURCES (USES): Operating transfers in ............................................................... Operating transfers out .............................................................

6,043

16,320

22,363 (59,259} (36,896}

{26,419} (20,376}

(32,840} (16,520}

TOTAL OTHER FINANCING SOURCES (USES)

NET CHANGE IN CASH BALANCES

(8,310)

24,611

32,921

105,982

683,582

577,600

CASH BALANCES - BEGINNING OF YEAR

$

610,521

708,193

97,672

CASH BALANCES - END OF YEAR

~

~

CASH BASIS FUND BALANCES: Unrestricted ........................................................................... ~

$

610,521

97,672

708,193

~

See Accompanying Independent Auditors' Report 46