978-0078025815 Exercise 4 Excel

subject Type Homework Help
subject Pages 9
subject Words 806
subject Authors Paul Copley

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
page-pf1
State Government - Special Revenue Fund CASH LICENSE FEES RECEIVABLE SUPPLIES
Fish and Game Fund Journal Entries bb 200,000 bb 125,000 bb 9,000
December 31, 2015 31,150,000 303,000 7125,000 3 6 287,500
4272,000 305,000 9 3 128,000 283,650 12
Item # Account Title Debits Credits 8300,000 977,000 10
1 Estimated Revenues 1,400,000
Estm' Other financing sources 300,000 128,000 12,850
Appropriations 1,670,000
Budgetary fund balance 30,000 337,000
2 Encumbrances 26,000 ACCOUNTS PAYABLE WAGES PAYABLE FUND BALANCE
Budgetary Fund Balance - Reserve for encumbrances 26,000 66,000 bb 3,000 bb 265,000 bb
287,500 6 10 3,000
3 Cash 1,150,000 7303,000 3,600 11
Hunting and Fishing License Revenue 1,025,000
Licenses fees receivable 125,000 50,500 3,600 265,000
License fees receivable 128,000 HUNTING AND FISHING OTHER FINANCING
Hunting and Fishing License Revenue 128,000 LICENSE REVENUE FINES REVENUE SOURCES -- TRANSFERS IN
4 Cash 272,000 1,025,000 3272,000 4300,000 8
Fines revenue 272,000 128,000 3
5 Encumbrances 277,000 1,153,000 272,000 300,000
Budgetary Fund Balance - Reserve for Encumbrances 277,000
CURRENT EXPENDITURES CAPITAL
6 Supplies 287,500 WILDLIFE MANAGEMENT EXPENDITURES
Accounts payable 287,500
10 974,000 9305,000
Budgetary Fund Balance - Reserve for Encumbrances 289,000 11 3,600
Encumbrances 289,000 12 283,650
7 Accounts payable 303,000 305,000
Cash 303,000 1,261,250
8 Cash 300,000 BUDGETARY FUND BALANCE -
Other financing sources - transfers in 300,000 RESERVE FOR ENCUMBRANCES ENCUMBRANCES ESTIMATED REVENUES
26,000 2
9 Encumbrances 305,000 226,000 1 1,400,000
Budgetary Fund Balance - Reserve for Encumbrances 305,000 277,000 5 5 277,000
6289,000 289,000 6
Capital Expenditures 305,000 305,000 9 9 305,000
Cash 305,000 9305,000 305,000 91,400,000
Budgetary Fund Balance - Reserve for Encumbrances 305,000 14,000 14,000
Encumbrances 305,000
ESTIMATED OTHER BUDGETARY
10 Current Expenditures - Wildlife Management 974,000 FINANCING SOURCES APPROPRIATIONS FUND BALANCE
Wages Payable 3,000
Cash 977,000 1 300,000 1,670,000 130,000 1
11 Current Expenditures - Wildlife Management 3,600 300,000 1,670,000 30,000
Wages Payable 3,600 bb - denotes Beginning Balance
12 Current Expenditures - Wildlife Management 283,650
Supplies 283,650 Check that these equal after posting each journal entry
Total Debit Balances 3,758,100
Total Credit Balances 3,758,100
page-pf2
STATE GOVERNMENT - Special Revenue Fund
Fish and Game Fund - Closing Entries
December 31, 2015
BUDGETARY BUDGETARY FUND BALANCE
Account Title Debits Credits FUND BALANCE RESERVE FOR ENCUMBRANCES
30,000 Preclosing 14,000 Preclosing
Appropriations 1,670,000 30,000 closing entry 14,000 closing entry
Budgetary fund balance 30,000
Estimated other financing sources 300,000
Estimated Revenues 1,400,000
- -
Budgetary fund balance - reserve for
encumbrances
14,000
Encumbrances 14,000
Fines Revenue 272,000
License fees revenue 1,153,000
Other financing sources - transfer in 300,000 FUND BALANCE
Current expenditures - Wildlife Management 1,261,250 265,000 Preclosing
Capital expenditures 305,000 158,750 closing entry
Fund balance 158,750
423,750
Complete the following table
Non-
spendable
Restricted
Committ
ed
Assigned Unassigned Total
Fund Balance 12,850 410,900 423,750
page-pf3
Fish and
Game Fund
Revenues
Hunting and fishing license fees revenue 1,153,000$
Fines revenue 272,000
Total Revenues 1,425,000
Expenditures
Current:
Wildlife Management 1,261,250
Capital Outlay 305,000
Total Expenditures 1,566,250
Excess (Deficiency) of Revenues Over Expenditures
(141,250)
Other financing sources
Transfers In 300,000
Net Change in Fund Balance 158,750
Fund Balance, January 1 265,000
Fund Balance, December 31 423,750$
page-pf4
STATE GOVERNMENT Special Revenue Fund
Balance Sheet
as of 12/31/2015
Fish and
Game Fund
Assets
Cash 337,000$
License Fees Receivable 128,000
Supplies Inventory 12,850
Total Assets 477,850$
Liabilities and Fund Balances
Liabilities
Accounts Payable 50,500$
Wages Payable 3,600
Total Liabilities 54,100
Fund Balances
Nonspendable 12,850
Restricted for fish and game management 410,900
Total Fund Balances 423,750
Total Liabilities and Fund Balances 477,850$
page-pf5
ALLOWANCE FOR
CASH TAXES RECEIVABLE UNCOLLECTIBLE TAXES SUPPLIES
Jefferson County bb 132,348 bb 47,220 1,570 bb bb 660
General Fund Journal Entries 4265,000 1,325 4 7 39,800
December 31, 2015 5258,000 258,000 540,110 13
37,800 71,020 5 5 1,020
Item # Account Title Debits Credits 39,900 8
1 Estimated Revenues 250,000 133,900 953,200 1,875 350
Appropriations 200,000 7,600 10
Estimated other financing uses 40,000 43,000 11
Budgetary fund balance 10,000 128,148
DEFERRED INFLOWS -
2 Encumbrances 4,800 ACCOUNTS PAYABLE PROPERTY TAXES
WAGES PAYABLE
FUND BALANCE
Budgetary Fund Balance - Reserve for encumbrances 4,800 - bb 21,000 bb 900 bb 156,758 bb
39,800 7 3 21,000 9900
3 Deferred inflows - property taxes 21,000 737,800 850 12
Property tax revenue 21,000 22,600 14
4 Taxes receivable 265,000 2,000 22,600 850 156,758
Allowance for uncollectible taxes 1,325
Property tax revenue 263,675 GENERAL GOVERNMENT CAPITAL OTHER FINANCING USES
EXPENDITURES EXPENDITURES PROPERTY TAX REVENUE TRANSFERS OUT
5 Cash 258,000
Taxes receivable 258,000 9133,000 21,000 3
10
7,600 263,675 4
Allowance for uncollectible taxes 1,020 12 850 839,900 14 22,600 11 43,000
Taxes receivable 1,020 13 40,110
6 Encumbrances 36,000 181,560 39,900 262,075 43,000
Budgetary Fund Balance - Reserve for encumbrances 36,000
7 Supplies 39,800 ESTIMATED OTHER BUDGETARY
Accounts payable 39,800 FINANCING USES APPROPRIATIONS FUND BALANCE ESTIMATED REVENUES
40,000 1200,000 110,000 1 1 250,000
page-pf6
13 General government expenditures 40,110
Supplies 40,110
14 Property tax revenue 22,600
Deferred property taxes 22,600
1,321,180 1,321,180
page-pf7
Jefferson County
General Fund Closing Entries
December 31, 2015
BUDGETARY BUDGETARY FUND BALANCE
Account Title Debits Credits FUND BALANCE RESERVE FOR ENCUMBRANCES
10,000 Preclosing 800 Preclosing
Appropriations 200,000 10,000 closing entry 800 closing entry
Estimated other financing uses 40,000
Budgetary fund balance 10,000
Estimated Revenues 250,000
- -
Budgetary Fund Balance -- Reserve for
Encumbrances
800
Encumbrances 800
Property tax revenue 262,075 FUND BALANCE
Fund balance 2,385 156,758 Preclosing
General government expenditures 181,560
Capital expenditures 39,900 2,385 closing entry
Transfers out 43,000 1
154,373 ending balance
Complete the following table
Non-
spendable
Restricted Committed Assigned Unassigned Total
Fund Balance 350 800 153,223 154,373
page-pf8
Jefferson County - General Fund
Statement of Revenues, Expenditures and Changes in Fund Balance
For the year ended 12-31-2015
General
Fund
Revenues
Property Taxes 262,075$
Total Revenues 262,075
Expenditures
Current:
General Government Operations 181,560
Capital Outlay 39,900
Total Expenditures 221,460
Excess (Deficiency) of Revenues Over Expenditures
40,615
Other financing sources (uses)
Transfers out (43,000)
Total other financing sources (uses) (43,000)
Net Change in Fund Balance (2,385)
Fund Balance, January 1 156,758
Fund Balance, December 31 154,373$
page-pf9
Jefferson County - General Fund
Balance Sheet

Trusted by Thousands of
Students

Here are what students say about us.

Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.