Question

In: Accounting

P17-6 Balance Sheet, Statement of Revenues, Expenditures, and Changes in Fund Balance Hunnington Township’s adjusted trial...

P17-6 Balance Sheet, Statement of Revenues, Expenditures, and Changes in Fund Balance
Hunnington Township’s adjusted trial balance for the General Fund at the close of its fiscal year ended June 30,
2016, is presented here:
Hunnington Township
General Fund Trial Balance
30-Jun-16
Cash $11,000
Property Tax Receivable—current (Note 1) 82,000
Estimated Uncollectible Taxes—current $1,500
Property Tax Receivable—delinquent 25,000
Estimated Uncollectible Taxes—delinquent 16,500
Accounts Receivable (Note 1) 40,000
Allowance for Uncollectible Accounts 4,000
Due from Internal Service Fund (Note 5) 50,000
Expenditures (Note 2) 755,000
Encumbrances 37,000
Revenue (Note 3) 60,000
Due to Enterprise Fund (Note 5) 10,000
Vouchers Payable 20,000
Surplus Receipts (Note 4) 7,000
Appropriations 720,000
Fund Balance—Asssigned (Note 6) 81,000
Fund Balance—Unasssigned 80,000
$1,000,000 $1,000,000
Note 1: The current tax roll and accounts receivable, recorded on the accrual basis as sources of revenue,
amounted to $500,000 and $200,000, respectively.
Note 2: Includes $42,500 paid during the fiscal year in settlement of all purchase orders outstanding at the
beginning of the fiscal year
Note 3: Represents the difference between the budgeted (estimated) revenue of $700,000 and the actual
revenue realized during the fiscal year.
Note 4: Represents the proceeds from the sale of equipment damaged by fire. The equipment originally
cost $40,000 and had been held for 80% of its useful life prior to the fire.
Note 5: The interfund payable and receivable resulted from cash advances (loans) to and from the respective
funds.
Note 6: Includes $44,000 of encumbrances from prior year.
Required:
A. Prepare a statement of revenues, expenditures, and changes in fund balance.
B. Prepare a balance sheet for the General Fund at June 30, 2016. (AICPA adapted)

Solutions

Expert Solution

Part A

HUNNINGTON TOWNSHIP

Statement of Revenues, Expenditures and

Changes in Fund Balance

For the Year Ended June 30, 2016

Revenue

Expenditures:

Current Year’s Appropriation

Prior Year’s Appropriation

Total

Excess of Revenues over Expenditures

Sale of Equipment

Increase (Decrease) in Fund Balance

Fund Balance July 1, 2015

Fund Balance June 30, 2016

a $700,000 + $60,000 = $767,000

b $755,000 - $42,500 = $712,500

c Unreserved fund balance per trial balance

Add appropriations

Deduct estimated revenue (note 3)

Unreserved fund balance - July 1, 2015

Reserve for encumbrances - July 1, 2015

Fund Balance - July 1, 2015

d Unreserved fund balance per trial balance

Add revenue in excess of estimated revenue ($767,000 - $700,000)

Deduct expenditures and encumbrances in excess of appropriations

[($755,000 + $37,000) - $764,000]

Unreserved fund balance - June 30, 2016

Reserve for encumbrances

Fund Balance - June 30, 2016

$760,000a

712,500b

    42,500

755,000

5,000

    7,000

12,000

144,000c

$156,000d

$80,000

720,000

(700,000)

100,000

    44,000

$144,000

$80,000

67,000

    (28,000)

119,000

     37,000

$156,000




Part B

HUNNINGTON TOWNSHIP

The General Fund

Balance Sheet

June 30, 2016

Assets

Cash

Property Tax Receivable

Less Estimated Uncollectible Taxes

Accounts Receivable

Less Allowance for Uncollectible Accounts

Due from Internal Service Fund

Total

Liabilities and Fund Balance

Vouchers Payable

Due to Enterprise Fund

Fund Balance:

Unreserved

Reserve for Encumbrances

Total

$107,000

     18,000

40,000

       4,000

$119,000

     37,000

$11,000

89,000

36,000

     50,000

$186,000

$20,000

10,000

   156,000

$186,000


Related Solutions

Prepare a Statement of Revenues, Expenditures, and Changes in Fund Balance for the San Jacinto County...
Prepare a Statement of Revenues, Expenditures, and Changes in Fund Balance for the San Jacinto County Courthouse Capital Projects Fund for the year ended June 30, 20X9, given the following information: 1. In June 20X8, a $10,000,000 bond referendum is voted for and approved by the citizens of San Jacinto County for the construction of a new courthouse. 2. On July 1, 20X8, a Capital Projects Fund is established for this project with a transfer of $500,000 from the General...
1. A governmental fund Statement of Revenues, Expenditures, and Changes in Fund Balances reported of $30...
1. A governmental fund Statement of Revenues, Expenditures, and Changes in Fund Balances reported of $30 million, including capital outlay expenditures of $9 million. Capital assets for that government cost $90 million, including land of $10 million. Depreciable assets are amortized over 20 years, on average. The reconciliation from governmental changes in fund balances to governmental activities changes in would reflect a(an): A) Decrease of $1 million. B) Increase of $l million. C) Increase of $5 million. D) Decrease of...
In preparing Chase City's reconciliation of the Statement of Revenues, Expenditures, and Changes in fund balances...
In preparing Chase City's reconciliation of the Statement of Revenues, Expenditures, and Changes in fund balances to the Government-Wide Statement of Activities, which of the following items should be subtracted from the changes in fund balances? A. Capital Assets Purchases. B. Payment of long-term debt principal. C. Internal Service Fund increase in Net Position. D. Book value of capital assets sold during the year. I know the answer is D. Book value of capital assets sold during the year, because...
CITY OF SALEM Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual:...
CITY OF SALEM Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual: General Fund For The Year Ended December 31, 2017 Budgeted Amounts REVENUES Original Final Actual Amounts Budgetary Basis Variance with Final Budget    Property Taxes          14,666,000          14,666,000          15,361,830               695,830    Other Local Taxes          11,562,500          11,562,500          11,761,522               199,022    Charges for Services            1,613,011            1,613,011            1,601,435                (11,576)    Intergovernmental              7,892,080            8,047,907           ...
A governmental fund Statement of Revenues, Expenditures, and Changes in Fund Balances reported expenditures of $30 million, including capital outlay expenditures of $5 million.
A governmental fund Statement of Revenues, Expenditures, and Changes in Fund Balances reported expenditures of $30 million, including capital outlay expenditures of $5 million. Capital assets for that government cost $90 million, including land of $10 million. Depreciable assets are amortized over 20 years, on average. The reconciliation from governmental changes in fund balances to governmental activities changes in net assets would reflect a(an):            A) Decrease of $1 million.            B)   Increase of $l million.            C)   Increase of $5 million.           D) Decrease...
E-45 (Statement of revenues, expenditures, and changes in fund balances) prepare, in good form, the 20x1...
E-45 (Statement of revenues, expenditures, and changes in fund balances) prepare, in good form, the 20x1 statement of revenues, expenditures, and changes in fund balances for the general fund of Crabtree township, based on the following information: Property tax revenues $13,000,000 Licenses and permits $800,000 Intergovernmental grants $2,500,000 Short-term note proceeds $775,000 General capital asset sale proceeds (Equal to book value less 10%) $523,000 Receipt of residual assets of terminated Debt Service Fund $90,000 Amount paid to Debt service fund...
E-45 (Statement of revenues, expenditures, and changes in fund balances) prepare, in good form, the 20x1...
E-45 (Statement of revenues, expenditures, and changes in fund balances) prepare, in good form, the 20x1 statement of revenues, expenditures, and changes in fund balances for the general fund of Crabtree township, based on the following information: Property tax revenues $13,000,000 Licenses and permits $800,000 Intergovernmental grants $2,500,000 Short-term note proceeds $775,000 General capital asset sale proceeds (Equal to book value less 10%) $523,000 Receipt of residual assets of terminated Debt Service Fund $90,000 Amount paid to Debt service fund...
Balance Sheet from Adjusted Trial Balance The following is the alphabetical adjusted trial balance of the...
Balance Sheet from Adjusted Trial Balance The following is the alphabetical adjusted trial balance of the Meadows Company on December 31, 2016: Debits Credits Accounts Payable $ 9,800 Accounts Receivable $ 19,000 Accrued Payables 7,100 Accumulated Depreciation 44,000 Additional Paid-in Capital 50,600 Cash 7,900 Common Stock, $5 par 29,600 Cost of Goods Sold 179,500 Current Portion of Long-Term Debt 6,200 Deferred Taxes Payable 12,500 Dividends Distributed 7,000 General Expenses 27,560 Income Tax Expense 12,340 Income Taxes Payable 7,500 Interest Expense...
Use the following Adjusted Trial Balance, make a classified balance sheet. Carters Used Cars ADJUSTED TRIAL...
Use the following Adjusted Trial Balance, make a classified balance sheet. Carters Used Cars ADJUSTED TRIAL BALANCE April 31, 2016 Account                                                                                                   Debit                    Credit Cash                                                                                                      $ 20,000                               $ Accounts Receivables                                                                        50,000 Allowance for Bad Debts                                                                                                                    2,000 Inventory                                                                                               30,000 Supplies                                                                                                    1,000 Building                                                                                                250,000 Accumulated Depr.-Building                                                                                                           80,000 Equipment                                                                                             70,000 Accumulated Depr.- Equipment                                                                                                  60,000 Patents                                                                                                   70,000 Accounts Payable                                                                                                                                30,000 Notes Payable (due in 6 months)                                                                                                    5,000 Mortgage Payable (10 years, next yr...
Please prepare a full trial balance – Trial Balance, Adjustments,Adjusted Trial Balance, Income Statement, Balance...
Please prepare a full trial balance – Trial Balance, Adjustments, Adjusted Trial Balance, Income Statement, Balance Sheet, and Statement of Owner’s Equity, as well the individual Balance Sheet, Income Statement, and Statement of Owners Equity. Include any journal entries necessary for this assignment. Use T accounts if you find them helpful. Attached are the files for your use. Check your formulas. 1. You are reporting for your client for the One Month period September 30, 2020 2. The started the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT