Continuous Problem Part 7 and 8

aka2016

ch_5_Other_Governmental_Funds_student_template.xlsx

Home >Business & Finance homework help >Accounting homework help >Continuous Problem Part 7 and 8

Capital Projects Fund

		CITY JAIL CAPITAL PROJECTS FUND													CONTRACTS PAYABLE
reference		Account Titles		Debits	Credits		CASH				ACCOUNTS PAYABLE				RETAINED PERCENTAGE
						1	4,200,000	200,000	1	11	1,282,500	1,282,500	8	12	67,500	67,500	8
5-C-1	1	Cash		4,200,000		9	1,340,000	121,000	3	12	3,217,500	3,150,000	12
			Other financing- proceeds from bond		4,000,000			50,000	5	15	474,500	459,300	13
			Other financing sources- premium bond		200,000			150,000	6			200,000	14
								1,282,500	11
		Other financing- Transfer out		200,000				3,217,500	12
			Cash		200,000			474,500	15
								14,700	15
	2	Due from State Gov		1,340,000
			Revenues- Intergovernmental		1,340,000							117,300				-
							29,800
	3	Capital Expenditures		121,000											BUDGETARY FUND BALANCE
			Cash		121,000		DUE FROM STATE				ENCUMBRANCES			RESERVE FOR ENCUMBRANCES	RESERVE FOR ENCUMBRANCES
							GOVERNMENT			4	250,000	50,000	5	5	50,000	250,000	4
	4	Encombrances Control		250,000		2	1,340,000	1,340,000	9	7	4,500,000	150,000	6	6	150,000	4,500,000	7
			Budgetary Fund Bal- Reserve for Encombrances		250,000					10	459,300	1,350,000	8	8	1,350,000	459,300	10
												3,150,000	12	12	3,150,000
	5	Budgetary Fund Bal- Reserve for Encombrances		50,000								459,300	13	13	459,300
			Encombrances Control		50,000							200,000	14	14	200,000
		Capital Expenditure		50,000			-
			Cash		50,000						(150,000)					(150,000)
	6	Budgetary Fund Balance- Reserve for Encombrances		150,000			CAPITAL				OTHER FIN. USES
			Encombrance Control		150,000		EXPENDITURES				TRANSFERS OUT
						3	121,000			1	200,000
		Capital Expenditure		150,000		5	50,000			16	14,700
			Cash		150,000	6	150,000
						8	135,000
	7	Encombrances Control		4,500,000		12	3,150,000
			Budgetary Fund Balance- Reserve for Encombrances		4,500,000	13	459,300
						14	200,000
	8	Budgetary Fund Balance- Reserve for Encombrances		1,350,000
			Encombrances Control		1,350,000
							4,265,300				214,700
		Capital Expenditure		1,350,000
			Accounts Payable		1,282,500
			Contracts Payable- Retained percentage		67,500		REVENUES				OTHER FIN. SOURCES				OTHER FIN. SOURCES
							INTERGOVERNMENTAL				BOND PROCEEDS				BOND PREMIUM
	9	Cash		1,340,000				1,340,000	2			4,000,000	1			200,000	1
			Due from State Government		1,340,000
	10	Encombrances Control		459,500				1,340,000				4,000,000				200,000
			Budgetary Fund Balance- Reserve for Encombrances		459,500
	11	Accounts Payable		1,282,500					Total Debits			4,359,800
			Cash		1,282,500				Total Credits			5,507,300
	12	Budgetary Fund Balance- Reserve for Encombrances		3,150,000
			Encombrances Control		3,150,000
		Capital Expenditure		3,150,000
		Contracts payable- Retained percentage		67,500
			Accounts payable		3,217,500
		Accounts payable		3,217,500
			Cash		3,217,500
	13	Budgetary Fund Balance- Reserve for Encombrances		459,300
			Encombrances control		459,300
	14	Budgetary Fund Balance- Reserve for Encombrances		200,000
			Encombrances Contrl		200,000
		Capital Expenditure		200,000
			Accounts Payable		200,000
	15	Accounts payable		474,500
			Cash		474,500
		Other financing uses- transfer out		14,700
			cash		14,700

&"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	1			580,000	bb
5-C-2	1	Expenditures - Bond interest		180,000		2	574,000	574,000	2	2	574,000	574,000	3
		Expenditures - Bond principal		400,000		4	568,000	568,000	5	5	568,000
			Cash with fiscal agent		580,000
	2	cash		574,000
			other financing sources transfer in		574,000
							-				568,000					580,000
		cash with fiscal agent		574,000
			cash		574,000
	3	Expenditures - Bond interest		174,000			EXPENDITURES -				EXPENDITURES -				OTHER FIN. SOURCES
		Expenditures - Bond principal		400,000			BOND INTEREST				BOND PRINCIPAL				TRANSFERS IN
			Cash with fiscal agent		574,000	1	180,000			1	400,000					574,000	2
						3	174,000			3	400,000					568,000	5
	4	cash		568,000
			other financing sources transfer in		568,000
							354,000				800,000					1,142,000
	5	Cash with fiscal agent		568,000
			cash		568,000
									Total Debits			1,722,000
									Total Credits			1,722,000
											CASH
reference		Account Titles		Debits	Credits		CASH				WITH FISCAL AGENT				INVESTMENTS
		CITY JAIL DEBT SERVICE FUND				1	200,000	160,000	2	2	160,000	160,000	3	6	200,000
5-C-3	1	cash		200,000		2	160,000	360,000	5	5	360,000
			other financing sources transfer in		200,000	4	14,700	200,000	6
						5	360,000
	2	cash		160,000
			other financing sources transfer in		160,000
							14,700				360,000				200,000
		cash with fiscal agent		160,000
			cash		160,000
	3	Expenditures - Bond interest		160,000			EXPENDITURES -				EXPENDITURES -				OTHER FIN. SOURCES
			cash with fiscal agent		160,000		BOND INTEREST				BOND PRINCIPAL				TRANSFERS IN
						3	160,000									200,000	1
	4	cash		14,700												160,000	2
			other financing sources transfer in		14,700											14,700	4
																360,000	5
	5	cash		360,000
			other financing sources transfer in		360,000		160,000				-					734,700
		cash with fiscal agent		360,000					Total Debits			734,700
			cash		360,000				Total Credits			734,700
	6	Investments		200,000
			cash		200,000

&16City of MonroeDebt Service Funds &16

Closing Entries

CAPITAL PROJECTS FUND			CAPITAL PROJECTS
Account Title	Debits	Credits	FUND BALANCE
Revenues-intergovernmental	1,340,000			0	Preclosing
OFS-proceeds of bonds	4,000,000
OFS-premium on bonds	200,000				closing entry
Fund balance
Capital expenditures		5,305,300
OFU - transfer out		214,700		0	ending balance
CITY HALL DEBT SERVICE FUND			CITY HALL DSF
Account Title	Debits	Credits	FUND BALANCE
				580,000	Preclosing
OFU - transfer in	1,142,000
Fund balance	12,000		12,000		closing entry
Expenditures - bond interest		354,000
expenditures - bond principal		800,000		568,000	ending balance
CITY JAIL DEBT SERVICE FUND			CITY JAIL DSF
Account Title	Debits	Credits	FUND BALANCE
				0	Preclosing
OFS - transfers in	734,700
Fund balance		574,700		574,700	closing entry
Expenditures - bond interest		160,000
expenditures - bond principal				574,700	ending balance

&14City of Monroe &14CAPITAL 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,340,000	2,737,000
Miscellaneous Revenues	350,000					350,000
Total Revenues	11,097,600	1,070,120	-	-	1,340,000	13,507,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,042,000				2,483,400
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				5,330,300	5,823,100
Debt Service						-
Principal			800,000			800,000
Interest			354,000	160,000		514,000
Total Expenditures	9,215,100	1,042,000	1,154,000	160,000	5,330,300	16,901,400
Excess (Deficiency) of Revenues Over Expenditures	1,882,500	28,120	(1,154,000)	(160,000)	(3,990,300)	(3,393,680)
Other Financing Sources (Uses)						-
Proceeds of Bonds					4,000,000	4,000,000
Premium on Bonds Sold					200,000	200,000
Transfers In			1,142,000	720,000		1,862,000
Transfers Out	(1,662,000)				(214,700)	(1,876,700)
Total Other Financing Sources (Uses)	(1,662,000)	-	1,142,000	720,000	3,985,300	4,185,300
Net Change in Fund Balance	220,500	28,120	(12,000)	560,000	(5,000)	791,620
Fund Balance, January 1	737,250	180,000	580,000	-	-	1,497,250
Fund Balance, December 31	$ 957,750	$ 208,120	$ 568,000	$ 560,000	$ (5,000)	$ 2,288,870

&"Times New Roman,Regular"&14City of MonroeStatement of Revenues, Expenditures and Changes in Fund BalanceGovernmental-type FundsFor 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	$ 727,500	$ 102,120			$ 829,620
Cash with Fiscal Agent			568,000	360,000	928,000
Investments		59,000		200,000	259,000
Taxes Reveivable - (net)	274,000				274,000
Interest & Penalties Receivable - (net)	16,850				16,850
Due from State Government	384,000	175,000			559,000
Total Assets	$ 1,402,350	$ 336,120	$ 568,000	$ 560,000	$ 2,866,470
Liabilities, Deferred Inflows and Fund Balance
Liabilities
Accounts Payable	$ 376,900	$ 126,500			$ 503,400
Due to Other funds	40,200				40,200
Total Liabilities	417,100	126,500	-	-	543,600
Deferred Inflows
Property Taxes	27,500				27,500
Fund Balances
Restricted for Street & Highway Maintenance		209,620			209,620
Assigned for:					-
Debt Service			568,000	560,000	1,128,000
Other Purposes	58,000				58,000
Unassigned	899,750				899,750
Total Fund Equity	957,750	209,620	568,000	560,000	2,295,370
Total Liabilities, Deferred Inflows and Fund Balance	$ 1,402,350	$ 336,120	$ 568,000	$ 560,000	$ 2,866,470

&"Times New Roman,Regular"&14City of MonroeBalance SheetGovernmental-type FundsAs of December 31, 2017