City of Monroe

government_wide_statements_template.xls

Home >Business & Finance homework help >Accounting homework help >City of Monroe

Worksheet entries


reference		Account Titles	Debits	Credits
8-C	A

&LCITY OF MONORE WORKSHEET ENTRIES FOR PREPARATION OF GOVERNMENT-WIDE STATEMENTS

Conversion worksheet

	Gov'tal Fund Balances			Subtotal Govern-mental Funds - Adjusted	Internal Service Funds		Balances for Gov't-wide Stmts
		Debits	Credits		Debits	Credits
DEBITS:
Cash	444,900			444,900			444,900
Cash with Fiscal Agent	928,000			928,000			928,000
Investments	136,450			136,450			136,450
Taxes Receivable, net	97,522			97,522			97,522
Interest Receivable, net	28,768			28,768			28,768
Inventories				0			-
Due from State Govt.	548,000			548,000			548,000
Due from Other Funds							-
Capital Assets
				0			-
Expenditures (expenses) Current
General Govt.	1,692,300			1,692,300			1,692,300
Public Safety	3,258,700			3,258,700			3,258,700
Highway and Streets	2,337,400			2,337,400			2,337,400
Sanitation	591,400			591,400			591,400
Health	723,600			723,600			723,600
Welfare	373,800			373,800			373,800
Culture and Recreation	916,800			916,800			916,800
Compensated Absences Exp				0			-
Other Expenditures (expenses)
- Debt Service Principal	400,000			400,000			400,000
- Interest (expenditure/expense)	508,000
				508,000			508,000
- Capital Outlay	4,914,150			4,914,150			4,914,150
- Depreciation				0			-
Other Fin. Uses - Transfers Out	1,337,450			1,337,450			1,337,450
Total Debits	19,237,240						19,237,240
CREDITS:
Accounts Payable	(61,600)			(61,600)			(61,600)
Due to Other Funds	(58,200)			(58,200)			(58,200)
Accrued Interest Payable				0			-
Deferred Revenues	(50,000)			(50,000)			(50,000)
Bonds Payalbe
				0			-
Premium on Bonds				0			-
Compensated Absence Payable				0			-
Advance from Water Utility Fund							-
Accumulated Depreciation
				0			-
Revenues
Property Taxes	(6,469,000)			(6,469,000)			(6,469,000)
Sales Taxes	(3,115,000)			(3,115,000)			(3,115,000)
Interest	(32,000)			(32,000)			(32,000)
Licenses & Permits	(800,000)			(800,000)			(800,000)
Miscellaneous	(270,000)			(270,000)			(270,000)
State Grant for Street Expenses	(975,000)			(975,000)			(975,000)
Capital Grant- Gen Gov't	(250,000)			(250,000)			(250,000)
Capital Grant- Public Safety	(250,000)			(250,000)			(250,000)
Grant for Law Enforcement	(288,000)			(288,000)			(288,000)
							-
Other Financing Sources
Proceeds of Bonds	(4,000,000)			(4,000,000)			(4,000,000)
Premium on Bonds	(50,000)			(50,000)			(50,000)
Transfers In	(1,337,450)			(1,337,450)			(1,337,450)
Net Position at beginning of year	(1,230,990)			(1,230,990)			(1,230,990)
Total Credits	(19,237,240)						(19,237,240)
column totals: debits = credits ??		-	-		-	-	-

&CCITY OF MONROE WORKSHEET TO CONVERT GOVERNMENTAL ACTIVITIES TO ACCRUAL BASIS

&LAmounts in parentheses represent credits.&C

Stmt of Activities

			Program Revenues		Net (Expense) Revenue and Change in Net Position
	Expenses	Charges for Services	Operational Grants and Contributions	Capital Grants and Contributions	Governmental Activities	Business-Type Activities	Total
Functions/Programs
Governmental Activities:
General Government					$ -		$ -
Public Safety					-		-
Highways and Streets					-		-
Sanitation					-		-
Health					-		-
Welfare					-		-
Culture and Recreation					-		-
Depreciaiton					-		-
Interest					-		-
Compensated Absneces					-		-
Total Governmental Activities	-	-	-	-	-		-
Business Type Activities
Water and Sewer	952,000	951,440				(560)	(560)
Total Government	$ 952,000	$ 951,440	$ -	$ -	$ -	$ (560)	(560)
			General Revenues
			Taxes:
			Property Taxes				-
			Sales Taxes				-
			Interest				-
			licenses and Permits				-
			Miscellaneous				-
			Total General Revenues		-	-	-
			Change in Net Position		-	(560)	(560)
			Net Position, Beginning			1,624,840	1,624,840
			Net Position, Ending		$ -	$ 1,624,280	$ 1,624,280

&C&14CITY OF MONROE Statement of Activities &11For the year ended December 31, 2014

Stmt of Net Assets

	Governmental Activities	Business-Type Activities	Total
Assets
Cash		$ 83,100	$ 83,100
Cash with Fiscal Agents			-
Investments			-
Accounts Receivable (Net)		142,180	142,180
Taxes Receivable (Net)			-
Interest Receivable			-
Internal Balances Current		37,000	37,000
Due from Other Governments			-
Inventories		127,400	127,400
Internal Balances Long-Term		20,000	20,000
Restricted Assets		150,000	150,000
Capital Assets, Net of Accumulated Depreciation		3,613,000	3,613,000
Total Assets	$ -	$ 4,172,680	$ 4,172,680
Liabilities
Accounts Payable		169,000	169,000
Payroll Taxes Payable		3,300	3,300
Accrued Interest Payable			-
Revenue Bonds Payable		2,300,000	2,300,000
General Obligation Bonds Payable			-
Premium on Bonds Sold			-
Compensated Absences Payable			-
Total Liabilities	-	2,472,300	2,472,300
Net Position
Net investment in capital assets	-	1,313,000	1,313,000
Restricted		150,000	150,000
Unrestricted	-	237,380	237,380
Total Net Position	$ -	$ 1,700,380	$ 1,700,380

&C&14CITY OF MONROE Statement of Net Position &11As of December 31, 2014

Reconciliations

		CITY OF MONORE
Reconciliation of the Balance Sheet of Governmental Funds to the Statement of Net Position
		As of December 31, 2014
	Fund balances reported in governmental funds Balance Sheet		$ 2,013,840
	Amounts reported for governmental activities in the
	Statement of Net Position are different because:
		Capital assets used in governmental activities are not financial resources and therefore not reported in the funds.
		The assets and liabilities of internal service funds are included in governmental funds in the Statement of Net Position.
		Deferred revenue for property taxes reported in the funds but accrued as revenue in the government-wide statements and added to Net Position.
		Accrued interest payable is reported as a liability in the Statement of Activities; interest is not accrued in the governmental funds.
		Bonds payable, not due and payable in the current period are not reported in the funds.
		Compensated absences, not due and payable in the current period are not reported in the funds.
	Net Position of Governmental Activities		$ 2,013,840
		CITY OF MONROE
	Reconciliation of the Statement of Revenues, Expenditures and Changes
		in Fund Balance to the Statement of Activities
		For the year ended December 31, 2014
	Net change in fund balances - Governmental funds		$ 782,850
	Amounts reported for governmental activities in the
	Statement of Activities are different because:
		Governmental funds report capital outlays as expenditures rather than assets
		Governmental funds do not report depreciation expense
		The net revenue of internal service funds is not reported with the governmental funds
		Property taxes due more than 60 days after year end is not accrued in the governmental funds.
		Bond proceeds are reported as other financing sources in the governmental funds but as liabilities in the government-wide statements.
		Repayment of bonds is reported as an expenditure in the governmental funds
		Interest is not accrued at year end in the governmental funds.
		Increases in compensated absences, not due and payable in the current period are not reported in the funds.
	Change in Net Position of Governmental Activities		$ 782,850