Need accounting project to be done... Need it back within 6 hrs.

Template_Govt_wide11.xlsx

worksheet

Enter all amounts as positive numbers. The worksheet is formatted to add debits to assets & expenses and add credits to revenues, liabilities & equity
#		Journal Entries	debits	credits (enter as negatives)		Gov'tal Fund Balances	Adjustments & Eliminations				Balances for Gov't-wide Stmts
	type accounts to be debited here							Debits	Credits
		type accounts to be credited here			DEBITS:
					Cash	2,123,249					2,123,249
					Taxes Receivable, net	559,000					559,000
					Inventories	116,000					116,000
					Capital Assets (net)						-
											-
					Expenditures (expenses) Current
					General Govt. Operations	1,490,501					1,490,501
					Public Safety	1,495,000					1,495,000
					Education	1,115,000					1,115,000
					Other Expenditures (expenses)
					- Debt Service Principal	93,750					93,750
					- Interest (expenditure/expense)	187,500					187,500
					- Capital Outlay	1,250,000					1,250,000
					- Depreciation						-
					Other Fin. Uses - Transfers Out	911,250					911,250
					Total Debits	9,341,250					9,341,250
					CREDITS:
					Accounts Payable	35,000					35,000
					Due to Other Funds	115,000					115,000
					Contracts Payable	400,000					400,000
					Accrued Interest Payable						-
					Short Term Notes Payable	300,000					300,000
					Bonds Payable
											-
					Premium on Bonds						-
											-
											-
					Revenues
					Property Taxes	3,589,000					3,589,000
					Sales Taxes	838,000					838,000
					Interest						-
					Fees, Licenses & Permits	312,000					312,000
					Miscellaneous	80,000					80,000
					Intergovernmental Grant for						-
					General Gov't Operations	450,000					450,000
											-
					Other Financing Sources
					Proceeds of Bonds	2,500,000					2,500,000
					Premium on Bonds	80,000					80,000
					Transfers In	611,250					611,250
					Net Position at beginning of year	31,000					31,000
					Total Credits	9,341,250					9,341,250
					column totals for JE's			0	0	0

Worksheet to convert Governmental fund basis information to accrual basis

			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					-		-
Education					-		-
Interest					-		-
Depreciation					-		-
Total Governmental Activities	-	-	-	-	-		-
Business Type Activities
Water and Sewer						-	-
Total Government	$ -	$ -	$ -	$ -	$ -	$ -	-
			General Revenues
			Taxes:
			Property Taxes				-
			Sales Taxes				-
			Fees, Licenses and Permits				-
			Transfers				-	Enter transfers out as negative and transfers in as positive amounts
			Total General Revenues		-	-	-
			Change in Net Position		-	-	-
			Net Position, Beginning			-	-
			Net Position, Ending		$ -	$ -	$ -

PROVINCE OF EUROPA STATEMENT OF ACTIVITIES GOVERNMENT-WIDE BASIS FOR THE YEAR ENDED DECEMBER 31, 2091

	Governmental Activities	Business-Type Activities	Total
Assets
Cash			$ -
Accounts Receivable (Net)			-
Taxes Receivable (Net)			-
Internal Balances Current			-	Enter payables to other funds as negative, receivables as positve amounts
Inventories			-
Capital Assets, Net of Accumulated Depreciation			-
Total Assets	$ -	$ -	$ -
Liabilities
Accounts Payable			-
Contracts Payable			-
Accrued Interest Payable			-
Short Term Notes Payable			-
General Obligation Bonds Payable			-
Premium on Bonds Sold			-
Total Liabilities	-	-	-
Net Position
Net Investment in Capital Assets	-	-	-
Unrestricted	-	-	-
Total Net Position	$ -	$ -	$ -

PROVINCE OF EUROPA STATEMENT OF NET POSITION AS OF DECEMBER 31, 2091