Question

In: Accounting

Following is the post-closing trial balance of the General Fund of Leisure City as at December...

Following is the post-closing trial balance of the General Fund of Leisure City as at December 31, 2012:

Cash $300,000

Property taxes receivable—delinquent 50,000

Due from state government 80,000

Supplies and materials 30,000

Salaries payable $ 25,000

Deferred revenues—property taxes 20,000

Nonspendable fund balance 30,000

Assigned fund balance 15,000

Unassigned fund balance 370,000

The following additional information is provided regarding the city’s accounting policies and other matters: 1. Only items charged to the appropriation “Supplies and materials—other programs” are encumbered. Encumbrances lapse if they are outstanding at the close of a fiscal year. They are, however, included in the following year’s appropriation. Outstanding encumbrances at the end of 2012 ($15,000) are reported as Assigned fund balance. 2. The appropriation “Other program costs” covers vacation pay, pension, and retiree health care benefits, and all other program expenditures. 3. The city uses the purchase method to record the acquisition of supplies. The year-end supplies inventory is considered to be material and is reported in the city’s financial statements. 4. The city’s accounting policy regarding income taxes is to recognize income taxes as revenue of the tax year provided they are expected to be received by April 15 of the following year, the due date for filing tax returns. 5. The city maintains tight controls over licensing fees and fines from its inspection program and considers them susceptible to accrual.

The following transactions and events occurred in 2013:

1. The city council of Leisure City approves the following budget for fiscal 2013: Estimated Revenues Property taxes $3,200,000 Income taxes 2,400,000 Intergovernmental grants 300,000 Licensing fees and fines 100,000 Appropriations Food inspection program $ 600,000 Salaries—other programs $4,000,000 Supplies and materials—other programs 300,000 Other program costs 600,000 Transfer to Debt Service Fund 400,000 Budgeted Increase in Fund Balance $ 100,000

2. Open encumbrances at the end of 2012 are restored.

3. All delinquent property taxes outstanding at the end of 2012 are collected between January and May of 2013, together with late payment penalties of $2,000.

4. The state pays the $80,000 it owes the city.

5. The city levies property taxes in the amount of $3,300,000 in anticipation of realizing net cash of $3,200,000. It establishes a $100,000 allowance for uncollectible taxes and discounts.

6. The city reduces tax bills by $60,000 based on taxpayer appeals of property value assessments, and taxpayers deduct $30,000 in discounts for early payment of bills. As a result, the city’s net collection of property taxes in 2013 against the 2013 tax levy is $3,150,000.

7. All remaining unpaid taxes are declared delinquent. The city comptroller concludes that no allowance for uncollectible taxes is needed. He believes that $45,000 of the delinquent taxes will be collected in the first 60 days of 2014.

8. During 2013, the city collects $2,300,000 in personal income taxes as a result of withholdings by employers and payments made by taxpayers based on estimates for calendar year 2013.

9. At year-end, the comptroller estimates that, based on past experience, it is likely that taxpayers who file timely (that is, by April 15, 2014) will request refunds of $120,000 and will make payments of $50,000 with their returns. The comptroller also estimates that about $25,000 of additional taxes probably will be received later in 2014 from late filers of tax returns.

10. At the beginning of the year, the city receives an advance of $200,000 from the state on a grant for inspecting food establishments. The grant is for a maximum amount of $300,000, subject to the following requirements: (a) the state will reimburse the city for 50 percent of all expenditures paid by the city on the food inspection program, up to the maximum amount of the grant; and (b) the city must file a claim for the balance due to the city by no later than December 31, 2013.

11. The city pays $580,000 to operate the inspection program referenced in the previous transaction. It also files a claim on December 31 for the balance due from the state for the program.

12. The city bills a total of $95,000 in licensing fees and inspection fines (through violation notices). It collects $85,000 cash during the year and expects to collect the rest during the first 60 days of 2014.

13. In addition to the item recorded in transaction 2, purchase orders for supplies and materials are placed in the amount of $280,000 and charged to the appropriation “Supplies and materials— other programs.”

14. The following transactions occur regarding the total amount encumbered: a. Invoices of $260,000 are received, vouchered for payment, and paid against encumbrances totaling $265,000. b. Encumbrances totaling $10,000 are canceled. c. Encumbrances of $20,000 remain open at year-end. The appropriation lapses, but the purchase orders will be honored against the following year’s appropriation.

15. Salaries of $3,925,000 are paid during the year. Of this amount, $3,900,000 is charged to the appropriation for salaries—other programs, and $25,000 is charged to salaries payable at the beginning of the year.

16. At year-end, salaries owed to employees for the last week in December total $80,000. They will be paid with the first payroll in 2014.

17. Long-term general obligation debt is sold early in 2013, causing an increase in debt service requirements for the year. As a result, the General Fund budget is amended; the appropriation for “Transfer to Debt Service Fund” is increased by $40,000.

18. A cash transfer of $440,000 is made to the Debt Service Fund.

19. The following transactions and events occur regarding the appropriation for “Other program costs”: a. Analysis of vacation leave records shows that the total liability to employees for unused vacation days increases by $25,000 as a result of the year’s activity. The total liability includes $10,000 due to employees who retire December 31; they will receive that amount in January 2014. b. The retirement system actuary advises the city that the increase in liability for retiree health care benefits as a result of employees who have worked in 2013 is $75,000. The city’s policy, however, is to finance only the health care benefits of its retirees. For the year, those expenditures are $50,000, of which $45,000 is paid during the year, and the rest will be paid in January 2014. c. During the year, other payments of $500,000 are charged to the appropriation.

20. The year-end inventory of supplies and materials totals $35,000.

21. To avoid an increase in property tax rates, Leisure City’s budget for 2014 includes a formal appropriation of $50,000 to finance the difference between estimated revenues and appropriations.

Use the preceding information to do the following: a. Prepare journal entries to record the foregoing transactions and events. b. Prepare a trial balance for 2013 after recording the journal entries. c. Prepare a balance sheet and a statement of revenues, expenditures, and changes in fund balance. d. Prepare a budgetary comparison schedule for 2013.

Solutions

Expert Solution

Answer :

1.         Estimated revenues – property taxes   3,200,000

     Estimated revenues – income taxes    2,400,000

   Estimated revenues – intergovernmental grants                                300,000

   Estimated revenues – fines and penalties     100,000

            Appropriations – food inspection program       600,000

            Appropriations – salaries (other programs)   4,000,000

  Appropriations – supplies and materials (other programs    300,000

            Appropriations – other program costs              600,000

            Appropriations – Transfer to Debt Service Fund     400,000

            Budgetary fund balance     100,000

     To record adopted budget for 2013.

2.         Encumbrances                                                                    15,000

  Budgetary fund balance reserved for encumbrances    15,000

             To restore open encumbrances at end of 2012.

    Assigned fund balance    15,000

            Unassigned fund balance      15,000

             To reverse assignment of fund balance.

3.         Cash      52,000

  Property taxes receivable – delinquent    50,000

            Revenues – fines and penalties       2,000

            To record collection of delinquent receivables.

       Deferred revenues - property taxes       20,000

            Revenues – property taxes     20,000

            To recognize revenues deferred from 2012.

4.         Cash                                                                                            80,000

            Due from state government              80,000

            To record collection of receivable from state.

5.    Property taxes receivable     3,300,000

  Allowance for uncollectible taxes and discounts     100,000

            Revenues – property taxes                                                                              3,200,000

     To record property tax levy.

6.         Cash 3,150,000

            Allowance for uncollectible taxes and discounts     90,000

            Property taxes receivable                                                                                3,240,000

     To record collection of property taxes, less deductions

      resulting from assessment appeals and discounts.

7.    Property taxes receivable – delinquent    60,000

            Property taxes receivable                                                                                   60,000

     To record delinquent property taxes.

   Allowance for uncollectible taxes and discounts                               10,000

            Revenues – property taxes                                                                                 10,000

     To reverse balance in allowance account.

   Revenues – property taxes                                                        15,000

  Deferred revenues – property taxes    15,000

     To defer property taxes not expected to be collected in

      The first 60 days of 2014.

8.         Cash 2,300,000

  Revenues – income taxes 2,300,000

            To record collections of income taxes.

9.         Income taxes receivable              50,000

   Revenues – income taxes                                                                 70,000

            Income tax refunds payable                                                                            120,000

     To record estimated collections from and refunds due

      to timely filers of final income tax returns.

   Income taxes receivable                                                                   25,000

  Deferred revenues – income taxes      25,000

     To record estimated collections from late filers of

      2013 income tax returns due April 15, 2014.

10.       Cash                                                                                          200,000

  Advance received on grant    200,000

            To record advance from state on grant.

11.       Expenditures – food inspection program       580,000

            Cash                                                                                                        580,000

            To record program expenditures.

            Due from state government                                                       90,000

            Advance received on grant                                                       200,000

  Revenues – intergovernmental grants         290,000

             To recognize revenues on grant (50% of $580,000) and

             to record balance due from state on grant.

12.       Cash                                                                                   85,000

            Fees and fines receivable                                                                    10,000

  Revenues – licensing fees and fines    95,000

            To recognize revenues from licensing fees and fines.

13.       Encumbrances                                                                   280,000

  Budgetary fund balance reserved for encumbrances    280,000

     To record purchase orders for supplies and materials.

14a.     Budgetary fund balance reserved for encumbrances     265,000

  Encumbrances         265,000

            To record receipt of items ordered.

            Expenditures – supplies and materials (other programs)    260,000

  Vouchers payable    260,000

      To record vouchers for supplies accepted.

    Vouchers payable                                                                            260,000

            Cash                                                                                                                260,000

      To record payment of vouchers.

  b.     Budgetary fund balance reserved for encumbrances   10,000

            Encumbrances                                                                                                 10,000

      To record cancellation of encumbrances.

  c.     Budgetary fund balance reserved for encumbrances 20,000

            Encumbrances                                                                                                 20,000

      To record lapsing of open encumbrances at year-end.

      Unassigned fund balance   20,000

  Assigned fund balance    20,000

      To record assigned fund balance for open encumbrances.

15.       Salaries payable                                                                                   25,000

            Expenditures – salaries (other programs)                                  3,900,000

  Cash     3,925,000

             To record salaries paid during year.

16.     Expenditures – salaries (other programs) 80,000

  Salaries payable     80,000

            To accrue salaries payable at year-end.

17.     Budgetary fund balance     40,000

  Appropriations – Transfer to Debt Service Fund     40,000

            To record budget amendment.

18.     Transfer out to Debt Service Fund    440,000

  Cash         440,000

      To record transfer to Debt Service Fund.

19a.     Expenditures – other program costs    10,000

  Accrued expenditures       10,000

            To accrue vacation pay due and payable.

  b.     Expenditures – other program costs    50,000

            Cash                                                                                                                45,000

  Accrued expenditures 5,000

            To record payment and accrual of pension expenditures.

  c.     Expenditures – other program costs    500,000

  Cash         500,000

             To record payment of expenditures.

20.       Supplies and materials   5,000

  Nonspendable fund balance          5,000

            To record increase in year-end supplies inventory.

21.       Unassigned fund balance 50,000

  Assigned fund balance     50,000

      To record assigned fund balance for 2014 appropriation.

Leisure City

General Fund

Trial Balance

December 31, 2013

Debits Credits

Estimated revenues – property taxes 3,200,000

Estimated revenues – income taxes   2,400,000

Estimated revenues – intergovernmental grants 300,000

Estimated revenues – fines and penalties 100,000

Appropriations – food inspection program 600,000

Appropriations – salaries (other programs) 4,000,000

Appropriations – supplies and materials (other programs 300,000

Appropriations – other program costs 600,000

Appropriations – Transfer to Debt Service Fund 440,000

Budgetary fund balance 60,000

Cash 417,000

Property taxes receivable – delinquent 60,000

Income taxes receivable 75,000

License fees and fines receivable 10,000

Due from state government 90,000

Supplies and materials 35,000

Salaries payable 80,000

Accrued expenditures 15,000

Income tax refunds payable 120,000

Deferred revenues – property taxes 15,000

Deferred revenues – income taxes 25,000

Nonspendable fund balance 35,000

Assigned fund balance 70,000

Unassigned fund balance 315,000

Revenues – property taxes 3,215,000

Revenues – income taxes 2,230,000

Revenues – intergovernmental grants 290,000

Revenues – licensing fees and fines 97,000

Expenditures – food inspection program 580,000

Expenditures – salaries (other programs) 3,980,000

Expenditures – supplies and materials (other programs) 260,000

Expenditures – Other program costs 560,000

Transfer to Debt Service Fund    440,000 _________

12,507,000   12,507,000


Related Solutions

The City of Castleton’s General Fund had the following post-closing trial balance at June 30, 2019,...
The City of Castleton’s General Fund had the following post-closing trial balance at June 30, 2019, the end of its fiscal year: Debits Credits Cash $ 418,000 Taxes Receivable—Delinquent 590,000 Allowance for Uncollectible Delinquent Taxes $ 196,000 Interest and Penalties Receivable 26,980 Allowance for Uncollectible Interest and Penalties 11,860 Inventory of Supplies 16,800 Vouchers Payable 155,500 Due to Federal Government 66,490 Deferred Inflows of Resources—Unavailable Revenues 402,000 Fund Balance—Nonspendable—Inventory of Supplies 16,800 Fund Balance—Unassigned 203,130 $ 1,051,780 $ 1,051,780 Record...
Given the following pre-closing trial balance, prepare the Balance Sheet CITY OF LASALLE General Fund Trial...
Given the following pre-closing trial balance, prepare the Balance Sheet CITY OF LASALLE General Fund Trial Balance December 31, 2017 Debit Credit Estimated Revenues and Grants      2,300,000 Estimated Other Financing Sources         400,000 Appopriations      2,150,000 Estimated Other Financing Uses         500,000 Budgetary Fund Balance           50,000 Cash         500,000 Taxes Receivable         600,000 Allowance for uncollectible taxes           50,000 Due from Federal Government         200,000 Supplies           50,000 Tax Refunds Payable         800,000 Vouchers Payable         100,000 Due...
The trial balance for the General Fund of the City of Topeka as of December 31,...
The trial balance for the General Fund of the City of Topeka as of December 31, 2017 is presented below:      CITY OF TOPEKA The General Fund Adjusted Trial Balance - December 31, 2017 Debit Credit Cash 216,000 Property Tax Receivable 31,000 Estimated Uncollectible Taxes 8,000 Due from Trust Fund 41,000 Vouchers Payable 55,000 Reserve for Encumbrances 20,000 Unassigned Fund Balance 205,000 288,000 288,000 Transactions for the year ended December 31, 2018 are summarized as follows: 1. The City Council adopted...
Following is a pre-closing trial balance of a village's General Fund at December 31, 2019. The...
Following is a pre-closing trial balance of a village's General Fund at December 31, 2019. The amount shown as Fund balance (unassigned) has not changed since the year started. The amount shown as appropriations includes the amounts appropriated for transfers. Property tax invoices are mailed out on January 10 and are due to be paid on February 10. Property owners that have not paid their taxes are classified as delinquent on March 10. Debits Credits Cash $4,000 Property taxes receivable,...
PROBLEM 6: Following is a pre-closing trial balance of a village's General Fund at December 31,...
PROBLEM 6: Following is a pre-closing trial balance of a village's General Fund at December 31, 2019. The amount shown as Fund balance (unassigned) has not changed since the year started. The amount shown as appropriations includes the amounts appropriated for transfers. Property tax invoices are mailed out on January 10 and are due to be paid on February 10. Property owners that have not paid their taxes are classified as delinquent on March 10. Debits Credits Cash $4,000 Property...
Post-Closing Trial Balance An accountant prepared the following post-closing trial balance: Security Services Co. Post-Closing Trial...
Post-Closing Trial Balance An accountant prepared the following post-closing trial balance: Security Services Co. Post-Closing Trial Balance July 31, 2018 Debit Balances Credit Balances Cash 41,100 Accounts Receivable 317,400 Supplies 5,000 Equipment 162,750 Accumulated Depreciation - Equipment 73,300 Accounts Payable 82,500 Salaries Payable 5,500 Unearned Rent 12,000 Common Stock 65,000 Retained Earnings 287,950 879,250 173,250 Prepare a corrected post-closing trial balance. Assume that all accounts have normal balances and that the amounts shown are correct. If an amount box does...
The following is a December 31, 2021, post-closing trial balance for Culver City Lighting, Inc. Account...
The following is a December 31, 2021, post-closing trial balance for Culver City Lighting, Inc. Account Title Debits Credits Cash $ 65,000 Accounts receivable 49,000 Inventory 55,000 Prepaid insurance 25,000 Equipment 130,000 Accumulated depreciation $ 44,000 Patent (net) 50,000 Accounts payable 17,000 Interest payable 7,000 Notes payable (due in 10 years) 160,000 Common stock 80,000 Retained earnings 66,000 Totals $ 374,000 $ 374,000 a. Calculate the current ratio. b. Calculate the acid-test ratio. c. Calculate the debt to equity ratio....
The following is a December 31, 2018, post-closing trial balance for Culver City Lighting, Inc. Account...
The following is a December 31, 2018, post-closing trial balance for Culver City Lighting, Inc. Account Title Debits Credits Cash 55,000 Accounts receivable 39,000 Inventories 45,000 Prepaid insurance 15,000 Equipment 100,000 Accumulated depreciation—equipment 34,000 Patent, net 40,000 Accounts payable 12,000 Interest payable 2,000 Note payable (due in 10, equal annual installments) 100,000 Common stock 70,000 Retained earnings 76,000 Totals 294,000 294,000 Prepare a classified balance sheet for Culver City Lighting, Inc. (Amounts to be deducted should be indicated by a...
The following is a December 31, 2021, post-closing trial balance for Culver City Lighting, Inc. Account...
The following is a December 31, 2021, post-closing trial balance for Culver City Lighting, Inc. Account Title Debits Credits Cash $ 75,000 Accounts receivable 59,000 Inventory 65,000 Prepaid insurance 35,000 Equipment 160,000 Accumulated depreciation $ 54,000 Patent (net) 60,000 Accounts payable 22,000 Interest payable 12,000 Notes payable (due in 10 years) 210,000 Common stock 90,000 Retained earnings 66,000 Totals $ 454,000 $ 454,000 Prepare a classified balance sheet for Culver City Lighting, Inc. (Amounts to be deducted should be indicated...
The following is a December 31, 2018, post-closing trial balance for Culver City Lighting, Inc. Account...
The following is a December 31, 2018, post-closing trial balance for Culver City Lighting, Inc. Account Title Debits Credits Cash $ 68,000 Accounts receivable 52,000 Inventories 58,000 Prepaid insurance 28,000 Equipment 120,000 Accumulated depreciation—equipment $ 47,000 Patent, net 53,000 Accounts payable 18,500 Interest payable 8,500 Note payable (due in 10, equal annual installments) 140,000 Common stock 83,000 Retained earnings 82,000 Totals $ 379,000 $ 379,000 a. Calculate the current ratio. b. Calculate the acid-test ratio. c. Calculate the debt to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT