Debits Credits
Cash $ 746,018
Restricted Cash-Customer Deposits 70,098
Customer Accounts Receivable 253,274
Accumulated Provision for Uncollectible Accounts $ 5,820
Inventory of Supplies 141,299
Due from Other Funds 50,000
Utility Plant in Service 22,163,213
Accumulated Depreciation-Utility Plant 5,186,691
Construction Work in Progress 1,043,527
City of Bingham
Water Utility Fund
Post-closing Trial Balance
For year 2020
Requirement 7d.
Requirement 7d.
Assets
Current assets:
Cash 746,018$
Customer accounts receivable 253,274$
Less: Accumulated provision for uncollectible accounts 5,820 247,454
Due from other funds 50,000
Inventory of supplies 141,299
Vouchers payable 175,441
Accrued interest payable 477,510
Total Current Liabilities 652,951
Liabilities payable from restricted assets:
Customer deposits 70,098
City of Bingham
Statement of Net Position
As of December 31, 2020
Water Utility Fund
Debits Credits
Cash $ 746,018
Restricted Cash-Customer Deposits 70,098
Customer Accounts Receivable 253,274
Accumulated Provision for Uncollectible Accounts $ 5,820
Inventory of Supplies 141,299
Due from Other Funds 50,000
Utility Plant in Service 22,163,213
Accumulated Depreciation-Utility Plant 5,186,691
Construction Work in Progress 1,043,527
City of Bingham
Water Utility Fund
Pre-closing Trial Balance
For year 2020
Requirement 7e.
Operating Revenue
Sales of water (net of $4,954 provision
for uncollectible accounts) 3,169,546$
Operating Expenses
Operation 922,904$
Maintenance 299,400
Depreciation expense 420,849
Non-operating Expenses
City of Bingham
Water Utlity Fund
Statement of Revenue, Expenses, and Changes in Net Position
For the Year Ended December 31, 2020
Requirement 7f.
Cash flows from operating activities:
Cash received from customers 3,070,854$
Cash paid to employees for services (815,150)
Cash paid to vendors for supplies (352,600)
Net cash provided by operating activities 1,903,104
Cash flows from capital and related financing activities:
Construction of utility plant (761,500)
Interest paid on long-term bonds (920,020)
Net cash used in capital and related financing activities: (1,681,520)
Net increase in cash and cash equivalents 221,584
City of Bingham
Statement of Cash Flows
Proprietary Funds
For the Year Ended December 31, 2020
Reconciliation of Operating Income to Net Cash Provided
Requirement 8c.
Debt Service Fund Bingham CSD Total
Equity at Creation of Fund 220,000$ 625,100$ 845,100$
City of Bingham
Calculation of Equities
Investment Pool
As of December 31, 2021 (before withdrawal)
Requirement 8d.
Debt Service Fund Bingham CSD Total
Equity at Creation of Fund 220,000$ 625,100$ 845,100$
Percentage Interest 26% 74% 100%
Distribution of investment earnings 6,019 17,131 23,150
City of Bingham
Calculation of Equities
Investment Pool
As of December 31, 2021 (after withdrawal)
Debits Credits
Cash $ 36,950
Investments-Bonds 626,000
City of Bingham
Investment Trust Fund
Post-closing Trial Balance
For year 2021
Requirement 8e.
Requirement 8e.
Assets
Cash $24,387 0.66224
City of Bingham
Investment Pool
Statement of Fiduciary Net Position
As of December 31, 2021
Debits Credits
Cash $ 36,950
Investments-Bonds 626,000
Interest Receivable on Investments 9,300
Due to Debt Service Fund $ 227,059
Additions-Deposits in Pooled Investments 625,100
City of Bingham
Investment Trust Fund
Pre-closing Trial Balance
For year 2021
Requirement 8f.
Requirement 8f.
Additions
Deposits in pooled investments 625,100$ 0.662171
Investment earnings 17,131
Change in fair value of investments 2,960
Total Additions 645,191
Deductions
City of Bingham
Investment Pool
Statement of Changes in Fiduciary Net Position
As of December 31, 2021
Debits Credits
Cash $ 1,714,522
Taxes Receivable-Delinquent 712,750
Allowance for Uncollectible Delinquent Taxes $ 355,795
Interest and Penalties Receivable on Taxes 67,679
Allowance for Uncollectible Interest and Penalties 11,714
Accumulated Depreciation-Equipment 6,036,400
Vouchers Payable 611,396
Accrued Interest Payable on Long-Term Debt 160,000
Internal Payables to Business-Type Activities 50,000
Current Portion of Long-Term Debt 1,125,000
City of Bingham
Governmental Activities, Governmental-Wide level
Post-closing Trial Balance
For year 2020
Requirement 9d.
Debits Credits
Cash $ 1,714,522
Taxes Receivable-Delinquent 712,750
Buildings 17,628,000
Accumulated Depreciation-Buildings 3,602,000
Equipment 8,910,500
Accumulated Depreciation-Equipment 6,036,400
Vouchers Payable 611,396
City of Bingham
Governmental Activities, Governmental-Wide level
Pre-closing Trial Balance
For year 2020
Requirement 9d.
Program Revenues-General Government-Operating Grants and
515,000
Program Revenues-Public Safety-Charges for Services 319,000
Program Revenues-Culture and Recreation-Operating Grants an
30,000