For Simon Village prepare a government-wide statement of net position and statement of activities, and a governmental funds balance sheet and statement of revenues, expenditures, and changes in fund balances. Any ending balance in the Debt Service Fund is legally restricted to debt service payments on the firetruck. Also prepare reconciliations for the differences between the governmental and government-wide financial statements.

General Fund - Modified Accrual Transactions Analysis Worksheet Liabilities and Fund Balance Fund Balance and Changes in Fund Balance Assets Liabilities Deferred Inflow of Resources Real Estate Taxes Receivable State Grants Receivable Due to Debt Service Fund Salaries Deferred Inflow of Resources Accounts Payable Fund Cash Payable Balance Beginning Balance S300,000 $20,000 $10,000 SO $16,000 $90,000 SO Transaction #1 (480000 (80000) $224,000 (200000) General Government Expenditures (140000) Education Expenditures (60000) Public Works, Safety & Sanitation Expenditures (2000) General Government Expenditures (6000) Education Expenditures (2000) Public Works, Safety & Sanitation Expenditures 292000 Real Estate Tax Revenues Transaction #2 10000 Transaction # 3a 300000 8000 Transaction # 3b 280000 (280000) Transaction # 4a 100000 1000001 State Grant Revenues Transaction # 4b 20000 (20000) Transaction # 5 (70000 (10000) (60000)Transfer to Debt Service Fund Transaction # 6a Transaction # 6b Transaction # 7 Ending Balance S50.000 S40,000 $90.000 S10,000 S6.000 S10.000 S8.000 S146.000 Debt Service Fund Liabilities and Fund Balance Fund Balance and Changes in Fund Balance Liabilities Assets Due from General Cash Fund 4,000 16,000 Fund Balance 0 20,000 Beginning Balance Transaction # 1 Transaction #2 Transaction # 3 Transaction #4 Transaction #5 Transaction #6 Transaction #7 70,000 (10,000) 60,000 Transfer from General fund (38,000) (8,000 Interest Expenditure (30,000 Debt Service Principal Expenditure $42.000 Ending Balance $36.000 $6.000 SO Capital Projects Fund Capital Projects Fund Liabilities and Fund Balance Fund Balance and Changes in Fund Balance Assets Liabilities Due from General Fund Balance Cash Fund 0 0 0 Beginning Balance Transaction #1 Transaction # 2 Transaction # 3 Transaction #4 Transaction # 5 Transaction # 6a 200,000 (200,000) 200,000 Other Sources of Financing-Note Payable (200,000) Capital Outlay Expenditure Transaction # 6b Transaction # 7 Ending Balance 0 General Fund - Modified Accrual Transactions Analysis Worksheet Liabilities and Fund Balance Fund Balance and Changes in Fund Balance Assets Liabilities Deferred Inflow of Resources Real Estate Taxes Receivable State Grants Receivable Due to Debt Service Fund Salaries Deferred Inflow of Resources Accounts Payable Fund Cash Payable Balance Beginning Balance S300,000 $20,000 $10,000 SO $16,000 $90,000 SO Transaction #1 (480000 (80000) $224,000 (200000) General Government Expenditures (140000) Education Expenditures (60000) Public Works, Safety & Sanitation Expenditures (2000) General Government Expenditures (6000) Education Expenditures (2000) Public Works, Safety & Sanitation Expenditures 292000 Real Estate Tax Revenues Transaction #2 10000 Transaction # 3a 300000 8000 Transaction # 3b 280000 (280000) Transaction # 4a 100000 1000001 State Grant Revenues Transaction # 4b 20000 (20000) Transaction # 5 (70000 (10000) (60000)Transfer to Debt Service Fund Transaction # 6a Transaction # 6b Transaction # 7 Ending Balance S50.000 S40,000 $90.000 S10,000 S6.000 S10.000 S8.000 S146.000 Debt Service Fund Liabilities and Fund Balance Fund Balance and Changes in Fund Balance Liabilities Assets Due from General Cash Fund 4,000 16,000 Fund Balance 0 20,000 Beginning Balance Transaction # 1 Transaction #2 Transaction # 3 Transaction #4 Transaction #5 Transaction #6 Transaction #7 70,000 (10,000) 60,000 Transfer from General fund (38,000) (8,000 Interest Expenditure (30,000 Debt Service Principal Expenditure $42.000 Ending Balance $36.000 $6.000 SO Capital Projects Fund Capital Projects Fund Liabilities and Fund Balance Fund Balance and Changes in Fund Balance Assets Liabilities Due from General Fund Balance Cash Fund 0 0 0 Beginning Balance Transaction #1 Transaction # 2 Transaction # 3 Transaction #4 Transaction # 5 Transaction # 6a 200,000 (200,000) 200,000 Other Sources of Financing-Note Payable (200,000) Capital Outlay Expenditure Transaction # 6b Transaction # 7 Ending Balance 0