Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This accounting scenario assumes the City of Leesburg government is using fund accounting for its internal record-keeping and then at year-end makes necessary adjustments to

image text in transcribed

This accounting scenario assumes the City of Leesburg government is using fund accounting for its internal record-keeping and then at year-end makes necessary adjustments to prepare the government-wide statements. This scenario affects the General Fund and their fiscal year 2015. Use control accounts for the budgetary accounts, revenues, expenditures and encumbrances ? see Excel file for templates and prepare the requested financial statements.

The Balance Sheets of the General Fund as of December 31, 2014, follow. These (beginning) balances have been entered in the proper general ledger accounts, as of 1/1/2015.

CITY OF LEESBURG

General Fund Balance Sheet

As of December 31, 2014

Assets

Cash

$502,000

Taxes receivable

$210,000

Less: Estimated uncollectible taxes

(42,000)

net

168,000

Interest and penalties receivable on taxes

5,200

Less: Estimated uncollectible interest and penalties

(950)

net

4,250

Due from state government

210,000

Total assets

$884,250

Liabilities, Deferred Inflows, and Fund Equity

Liabilities:

Accounts payable

$ 99,000

Due to other funds

27,000

Total liabilities

126,000

Deferred inflows ? Property taxes

21,000

Fund equity:

Fund balance?assigned

(for outstanding encumbrances)

$17,000

Fund balance?unassigned

720,250

Total fund balance

737,250

Total liabilities, deferred inflows and fund equity

$884,250

Required:

1.

As of January 1, 2015, the City Council approved and the mayor signed a budget calling for $11,250,000 in property tax and other revenue, $9,300,000 in appropriations for expenditures, and $1,700,000 to be transferred to two debt service funds for the payment of principal and interest. Record the budget using budgetary accounts for the General Fund and post to the ledger.

2.

  1. Record journal entries for the following transactions for FY 2015. Make any computations to the nearest dollar. Journal entry explanations are not required. Use control accounts for revenues, expenditures and budgetary accounts. It is not necessary to reflect subsidiary ledger entries.

(1) Encumbrances of $ 17,000 for purchase orders outstanding at the end of 2014 were re-established.

(2) The January 1, 2015, balance in Deferred Inflows ? Property Taxes relates to the amount of the 2014 levy that was expected to be collected more than 60 days after December 31. This amount should be recognized as 2015 revenues.

(3) A general tax levy in the amount of $6,800,000 was made. It is estimated that 2 percent of the tax will be uncollectible.

(4) Goods and supplies related to all encumbrances outstanding as of December 31, 2014 were received (see item 1 above), along with invoices amounting to $16,600; the invoices were approved for payment.

(5) All existing accounts payable balances and the amount due to other funds were paid.

(6) The General Fund collected the following ($ 10,811,500) in cash:

prior year taxes, $158,000;

interest and penalties receivable on prior year taxes, $3,500;

current taxes, $6,400,000;

$210,000 previously recorded as due from the state government;

licenses and permits, $800,000;

sales taxes, $2,890,000; and

miscellaneous revenues, $350,000.

(8) Purchase orders and contracts were issued in the amount of $3,465,000.

(9) Payroll for town employees within the General Fund totaled $5,070,000. The encumbrance system is not used for payrolls, and this amount was paid.

(10) Invoices for most of the supplies and services ordered in transaction 8 were received in the amount of $3,000,000 and the invoices in that amount were approved for payment. The remaining $465,000 remains encumbered.

b. Post the entries to the general ledger and track balances in T-accounts.

c. Prepare and post the closing entries for the General Fund. Outstanding encumbrances at year end are classified as Assigned Fund Balance and all remaining net resources are classified as Unassigned Fund Balance.

d. Prepare a Statement of Revenues, Expenditures, and Changes in Fund Balance for the year ended December 31, 2015.

e. Prepare in good form a Balance Sheet for the General Fund as of the end of fiscal year, December 31, 2015.

This accounting scenario assumes the City of Leesburg government is using fund accounting for its internal record-keeping and then at year-end makes necessary adjustments to prepare the government-wide statements. This scenario affects the General Fund and their fiscal year 2015. Use control accounts for the budgetary accounts, revenues, expenditures and encumbrances ? see Excel file for templates and prepare the requested financial statements.

The Balance Sheets of the General Fund as of December 31, 2014, follow. These (beginning) balances have been entered in the proper general ledger accounts, as of 1/1/2015.

CITY OF LEESBURG

General Fund Balance Sheet

As of December 31, 2014

Assets

Cash

$502,000

Taxes receivable

$210,000

Less: Estimated uncollectible taxes

(42,000)

net

168,000

Interest and penalties receivable on taxes

5,200

Less: Estimated uncollectible interest and penalties

(950)

net

4,250

Due from state government

210,000

Total assets

$884,250

Liabilities, Deferred Inflows, and Fund Equity

Liabilities:

Accounts payable

$ 99,000

Due to other funds

27,000

Total liabilities

126,000

Deferred inflows ? Property taxes

21,000

Fund equity:

Fund balance?assigned

(for outstanding encumbrances)

$17,000

Fund balance?unassigned

720,250

Total fund balance

737,250

Total liabilities, deferred inflows and fund equity

$884,250

Required:

1.

As of January 1, 2015, the City Council approved and the mayor signed a budget calling for $11,250,000 in property tax and other revenue, $9,300,000 in appropriations for expenditures, and $1,700,000 to be transferred to two debt service funds for the payment of principal and interest. Record the budget using budgetary accounts for the General Fund and post to the ledger.

2.

  1. Record journal entries for the following transactions for FY 2015. Make any computations to the nearest dollar. Journal entry explanations are not required. Use control accounts for revenues, expenditures and budgetary accounts. It is not necessary to reflect subsidiary ledger entries.

(1) Encumbrances of $ 17,000 for purchase orders outstanding at the end of 2014 were re-established.

(2) The January 1, 2015, balance in Deferred Inflows ? Property Taxes relates to the amount of the 2014 levy that was expected to be collected more than 60 days after December 31. This amount should be recognized as 2015 revenues.

(3) A general tax levy in the amount of $6,800,000 was made. It is estimated that 2 percent of the tax will be uncollectible.

(4) Goods and supplies related to all encumbrances outstanding as of December 31, 2014 were received (see item 1 above), along with invoices amounting to $16,600; the invoices were approved for payment.

(5) All existing accounts payable balances and the amount due to other funds were paid.

(6) The General Fund collected the following ($ 10,811,500) in cash:

prior year taxes, $158,000;

interest and penalties receivable on prior year taxes, $3,500;

current taxes, $6,400,000;

$210,000 previously recorded as due from the state government;

licenses and permits, $800,000;

sales taxes, $2,890,000; and

miscellaneous revenues, $350,000.

(8) Purchase orders and contracts were issued in the amount of $3,465,000.

(9) Payroll for town employees within the General Fund totaled $5,070,000. The encumbrance system is not used for payrolls, and this amount was paid.

(10) Invoices for most of the supplies and services ordered in transaction 8 were received in the amount of $3,000,000 and the invoices in that amount were approved for payment. The remaining $465,000 remains encumbered.

b. Post the entries to the general ledger and track balances in T-accounts.

c. Prepare and post the closing entries for the General Fund. Outstanding encumbrances at year end are classified as Assigned Fund Balance and all remaining net resources are classified as Unassigned Fund Balance.

d. Prepare a Statement of Revenues, Expenditures, and Changes in Fund Balance for the year ended December 31, 2015.

e. Prepare in good form a Balance Sheet for the General Fund as of the end of fiscal year, December 31, 2015.

image text in transcribed ACCT 219 - Assignment No. 1 This accounting scenario assumes the City of Leesburg government is using fund accounting for its internal record-keeping and then at year-end makes necessary adjustments to prepare the government-wide statements. This scenario affects the General Fund and their fiscal year 2015. Use control accounts for the budgetary accounts, revenues, expenditures and encumbrances - see Excel file for templates and prepare the requested financial statements. The Balance Sheets of the General Fund as of December 31, 2014, follow. These (beginning) balances have been entered in the proper general ledger accounts, as of 1/1/2015. CITY OF LEESBURG General Fund Balance Sheet As of December 31, 2014 Assets Cash $502,000 Taxes receivable $210,000 Less: Estimated uncollectible taxes (42,000) net 168,000 Interest and penalties receivable on taxes 5,200 Less: Estimated uncollectible interest and penalties (950) net 4,250 Due from state government 210,000 Total assets $884,250 Liabilities, Deferred Inflows, and Fund Equity Liabilities: Accounts payable $ 99,000 Due to other funds 27,000 Total liabilities 126,000 Deferred inflows - Property taxes Fund equity: Fund balanceassigned (for outstanding encumbrances) Fund balanceunassigned Total fund balance Total liabilities, deferred inflows and fund equity 1 21,000 $17,000 720,250 737,250 $884,250 Required: 1. a. As of January 1, 2015, the City Council approved and the mayor signed a budget calling for $11,250,000 in property tax and other revenue, $9,300,000 in appropriations for expenditures, and $1,700,000 to be transferred to two debt service funds for the payment of principal and interest. Record the budget using budgetary accounts for the General Fund and post to the ledger. 2. a. Record journal entries for the following transactions for FY 2015. Make any computations to the nearest dollar. Journal entry explanations are not required. Use control accounts for revenues, expenditures and budgetary accounts. It is not necessary to reflect subsidiary ledger entries. (1) Encumbrances of $ 17,000 for purchase orders outstanding at the end of 2014 were re-established. (2) The January 1, 2015, balance in Deferred Inflows - Property Taxes relates to the amount of the 2014 levy that was expected to be collected more than 60 days after December 31. This amount should be recognized as 2015 revenues. (3) A general tax levy in the amount of $6,800,000 was made. It is estimated that 2 percent of the tax will be uncollectible. (4) Goods and supplies related to all encumbrances outstanding as of December 31, 2014 were received (see item 1 above), along with invoices amounting to $16,600; the invoices were approved for payment. (5) All existing accounts payable balances and the amount due to other funds were paid. (6) The General Fund collected the following ($ 10,811,500) in cash: o o o o o o o prior year taxes, $158,000; interest and penalties receivable on prior year taxes, $3,500; current taxes, $6,400,000; $210,000 previously recorded as due from the state government; licenses and permits, $800,000; sales taxes, $2,890,000; and miscellaneous revenues, $350,000. (8) Purchase orders and contracts were issued in the amount of $3,465,000. (9) Payroll for town employees within the General Fund totaled $5,070,000. The encumbrance system is not used for payrolls, and this amount was paid. (10) Invoices for most of the supplies and services ordered in transaction 8 were received in the amount of $3,000,000 and the invoices in that amount were approved for payment. The remaining $465,000 remains encumbered. 2 b. Post the entries to the general ledger and track balances in T-accounts. c. Prepare and post the closing entries for the General Fund. Outstanding encumbrances at year end are classified as Assigned Fund Balance and all remaining net resources are classified as Unassigned Fund Balance. d. Prepare a Statement of Revenues, Expenditures, and Changes in Fund Balance for the year ended December 31, 2015. e. Prepare in good form a Balance Sheet for the General Fund as of the end of fiscal year, December 31, 2015. 3

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Theory Conceptual Issues in a Political and Economic Environment

Authors: Harry I. Wolk, James L. Dodd, John J. Rozycki

9th edition

9781483375014, 1483375013, 9781506300108, 1506300103, 978-1483375021

More Books

Students also viewed these Accounting questions

Question

Prove that for all integers n, if n mod 5 = 3 then n^2 mod 5 = 4

Answered: 1 week ago

Question

Do I own something similar already?

Answered: 1 week ago

Question

2. In what way can we say that method affects the result we get?

Answered: 1 week ago