Please show all work on an excel or word document.
Sheet3 Sheet2 Sheet1 3) A/R Customers 9/30/15 Collected Amounts 9/30/15 Water Sewer Revenues Billed 9/30/15 A/R Beginning 9/30/14 5) Total P-P-E 9/30/15 Land 9/30/14 Buliding 9/30/14 Water Plant9/30/14 Sewer Plant 9/30/14 Water Line 9/30/14 Sewer Line 9/30/14 Machinery and Equipment 9/30/14 6) Total P-P-E 9/30/15 Acummulated Depreciation 9/30/14 Actual Depreciation Expense 9/30/15 Net Book Value P-P-E 9/30/15 12) 17) Capitol Assets 9/30/15 Fund Balance For Gov Funds 9/30/15 Net Position For Gov Activities 9/30/15 Accounts payable 9/30/15 Bonds Payable 9/30/15 Taxes Recievable 9/30/15 Billings 10/1/15 Billings 10/15/15 Billings 11/1/15 (176,550/33) *20 days Billings 11/15/15 (143,000/33) * 6 days Investment Income for 9/30/15 Johnny James ACG 3501 Section 2 Beginning (9/30/14) Revenues( 9/30/15) #3 #5 #6 450000.00 6000000.00 -5800000.00 650000.00 500000.00 1500000.00 5000000.00 8000000.00 15000000.00 20000000.00 700000.00 52700000.00 52700000.00 -15000000.00 -1700000.00 36000000.00 6000000.00 -400000.00 155200.00 140500.00 107000.00 26000.00 6028700.00 2000000.00 250000.00 100000.00 90000.00 -4750000.00 -25000.00 -2335000.00 Sheet3 Sheet2 Sheet1 3) A/R Customers 9/30/15 Collected Amounts 9/30/15 Water Sewer Revenues Billed 9/30/15 A/R Beginning 9/30/14 5) Total P-P-E 9/30/15 Land 9/30/14 Buliding 9/30/14 Water Plant9/30/14 Sewer Plant 9/30/14 Water Line 9/30/14 Sewer Line 9/30/14 Machinery and Equipment 9/30/14 6) Total P-P-E 9/30/15 Acummulated Depreciation 9/30/14 Actual Depreciation Expense 9/30/15 Net Book Value P-P-E 9/30/15 12) 17) Capitol Assets 9/30/15 Fund Balance For Gov Funds 9/30/15 Net Position For Gov Activities 9/30/15 Accounts payable 9/30/15 Bonds Payable 9/30/15 Taxes Recievable 9/30/15 Billings 10/1/15 Billings 10/15/15 Billings 11/1/15 (176,550/33) *20 days Billings 11/15/15 (143,000/33) * 6 days Investment Income for 9/30/15 Johnny…
Attachments: