continuous problem part 5 and 6
aka2016
Copyofch_5_Other_Governmental_Funds_student_template1.xlsxCapital Projects Fund
| CITY JAIL CAPITAL PROJECTS FUND | CONTRACTS PAYABLE | |||||||||||||||||
| reference | Account Titles | Debits | Credits | CASH | ACCOUNTS PAYABLE | RETAINED PERCENTAGE | ||||||||||||
| 5-C-1 | 1 | type debit accounts in this column | ||||||||||||||||
| type credit accounts in this column | ||||||||||||||||||
| - | - | |||||||||||||||||
| - | ||||||||||||||||||
| BUDGETARY FUND BALANCE | ||||||||||||||||||
| DUE FROM STATE | ENCUMBRANCES | RESERVE FOR ENCUMBRANCES | RESERVE FOR ENCUMBRANCES | |||||||||||||||
| GOVERNMENT | ||||||||||||||||||
| - | ||||||||||||||||||
| - | - | |||||||||||||||||
| CAPITAL | OTHER FIN. USES | |||||||||||||||||
| EXPENDITURES | TRANSFERS OUT | |||||||||||||||||
| - | - | |||||||||||||||||
| REVENUES | OTHER FIN. SOURCES | OTHER FIN. SOURCES | ||||||||||||||||
| INTERGOVERNMENTAL | BOND PROCEEDS | BOND PREMIUM | ||||||||||||||||
| - | - | - | ||||||||||||||||
| Total Debits | - | |||||||||||||||||
| Total Credits | - | |||||||||||||||||
&"Arial,Bold"&14City of Monroe - City Jail Construction Fund
Debt Service Funds
| CASH | FUND BALANCE ASSIGNED | ||||||||||||||||||
| reference | Account Titles | Debits | Credits | CASH | WITH FISCAL AGENT | FOR DEBT SERVICE | |||||||||||||
| CITY HALL DEBT SERVICE FUND | bb | bb | 580,000 | 580,000 | bb | ||||||||||||||
| 5-C-2 | 1 | type debit accounts in this column | |||||||||||||||||
| type credit accounts in this column | |||||||||||||||||||
| - | 580,000 | 580,000 | |||||||||||||||||
| EXPENDITURES - | EXPENDITURES - | OTHER FIN. SOURCES | |||||||||||||||||
| BOND INTEREST | BOND PRINCIPAL | TRANSFERS IN | |||||||||||||||||
| - | - | - | |||||||||||||||||
| Total Debits | 580,000 | ||||||||||||||||||
| Total Credits | 580,000 | ||||||||||||||||||
| CASH | |||||||||||||||||||
| reference | Account Titles | Debits | Credits | CASH | WITH FISCAL AGENT | INVESTMENTS | |||||||||||||
| CITY JAIL DEBT SERVICE FUND | |||||||||||||||||||
| 5-C-3 | type debit accounts in this column | ||||||||||||||||||
| type credit accounts in this column | |||||||||||||||||||
| - | - | - | |||||||||||||||||
| EXPENDITURES - | EXPENDITURES - | OTHER FIN. SOURCES | |||||||||||||||||
| BOND INTEREST | BOND PRINCIPAL | TRANSFERS IN | |||||||||||||||||
| - | - | - | |||||||||||||||||
| Total Debits | - | ||||||||||||||||||
| Total Credits | - | ||||||||||||||||||
&16City of Monroe Debt Service Funds &16
Closing Entries
| CAPITAL PROJECTS FUND | CAPITAL PROJECTS | ||||||
| Account Title | Debits | Credits | FUND BALANCE | ||||
| 0 | Preclosing | ||||||
| closing entry | |||||||
| 0 | ending balance | ||||||
| CITY HALL DEBT SERVICE FUND | CITY HALL DSF | ||||||
| Account Title | Debits | Credits | FUND BALANCE | ||||
| 580,000 | Preclosing | ||||||
| closing entry | |||||||
| 580,000 | ending balance | ||||||
| CITY JAIL DEBT SERVICE FUND | CITY JAIL DSF | ||||||
| Account Title | Debits | Credits | FUND BALANCE | ||||
| 0 | Preclosing | ||||||
| closing entry | |||||||
| 0 | ending balance | ||||||
&14City of Monroe &14 CAPITAL PROJECT AND DEBT SERVICE FUND - Closing Entries
Stmt of revenues & expenditures
| Amounts shaded in blue came from Chapter 4 assignment | ||||||||||||
| General | Street and Highway | City Hall Debt Service | City Jail Debt Service | City Jail Construction | Total Governmental Funds | |||||||
| Revenues | ||||||||||||
| Property Taxes | $ 6,657,500 | $ 6,657,500 | ||||||||||
| Sales Taxes | 2,942,000 | 2,942,000 | ||||||||||
| Interest & penalties | 16,100 | 5,120 | 21,220 | |||||||||
| Licenses and Permits | 800,000 | 800,000 | ||||||||||
| Intergovernmental Revenues | 332,000 | 1,065,000 | 1,397,000 | |||||||||
| Miscellaneous Revenues | 350,000 | 350,000 | ||||||||||
| Total Revenues | 11,097,600 | 1,070,120 | - | - | - | 12,167,720 | ||||||
| Expenditures | ||||||||||||
| Current: | ||||||||||||
| General Government | 1,646,900 | 1,646,900 | ||||||||||
| Public Safety | 3,026,900 | 3,026,900 | ||||||||||
| Highways and Streets | 1,441,400 | 1,040,500 | 2,481,900 | |||||||||
| Sanitation | 591,400 | 591,400 | ||||||||||
| Health | 724,100 | 724,100 | ||||||||||
| Welfare | 374,300 | 374,300 | ||||||||||
| Culture and Recreation | 917,300 | 917,300 | ||||||||||
| Capital Outlay | 492,800 | 492,800 | ||||||||||
| Debt Service | - | |||||||||||
| Principal | - | |||||||||||
| Interest | - | |||||||||||
| Total Expenditures | 9,215,100 | 1,040,500 | - | - | - | 10,255,600 | ||||||
| Excess (Deficiency) of Revenues Over Expenditures | 1,882,500 | 29,620 | - | - | - | 1,912,120 | ||||||
| Other Financing Sources (Uses) | - | |||||||||||
| Proceeds of Bonds | - | |||||||||||
| Premium on Bonds Sold | - | |||||||||||
| Transfers In | - | |||||||||||
| Transfers Out | (1,662,000) | (1,662,000) | ||||||||||
| Total Other Financing Sources (Uses) | (1,662,000) | - | - | - | - | (1,662,000) | ||||||
| Net Change in Fund Balance | 220,500 | 29,620 | - | - | - | 250,120 | ||||||
| Fund Balance, January 1 | 737,250 | 180,000 | - | - | 917,250 | |||||||
| Fund Balance, December 31 | $ 957,750 | $ 209,620 | $ - | $ - | $ - | $ 1,167,370 | ||||||
&"Times New Roman,Regular"&14City of Monroe Statement of Revenues, Expenditures and Changes in Fund Balance Governmental-type Funds For the year ended December 31, 2017
Balance Sheet
| Amounts shaded in blue came from Chapter 4 assignment | ||||||||||
| General | Street and Highway | City Hall Debt Service | City Jail Debt Service | Total Governmental Funds | ||||||
| Assets | ||||||||||
| Cash | $ 545,900 | $ 102,120 | $ 648,020 | |||||||
| Cash with Fiscal Agent | - | |||||||||
| Investments | 59,000 | 59,000 | ||||||||
| Taxes Reveivable - (net) | 262,000 | 262,000 | ||||||||
| Interest & Penalties Receivable - (net) | 16,850 | 16,850 | ||||||||
| Due from State Government | 384,000 | 175,000 | 559,000 | |||||||
| Total Assets | $ 1,208,750 | $ 336,120 | $ - | $ - | $ 1,544,870 | |||||
| Liabilities, Deferred Inflows and Fund Balance | ||||||||||
| Liabilities | ||||||||||
| Accounts Payable | $ 200,300 | $ 126,500 | $ 326,800 | |||||||
| Due to Other funds | 40,200 | 40,200 | ||||||||
| Total Liabilities | 240,500 | 126,500 | - | - | 367,000 | |||||
| Deferred Inflows | ||||||||||
| Property Taxes | 10,500 | 10,500 | ||||||||
| Fund Balances | ||||||||||
| Restricted for Street & Highway Maintenance | 209,620 | 209,620 | ||||||||
| Assigned for: | - | |||||||||
| Debt Service | - | |||||||||
| Other Purposes | 58,000 | 58,000 | ||||||||
| Unassigned | 899,750 | 899,750 | ||||||||
| Total Fund Equity | 957,750 | 209,620 | - | - | 1,167,370 | |||||
| Total Liabilities, Deferred Inflows and Fund Balance | $ 1,208,750 | $ 336,120 | $ - | $ - | $ 1,544,870 | |||||
&"Times New Roman,Regular"&14City of Monroe Balance Sheet Governmental-type Funds As of December 31, 2017
