Question: Please answer it only if you know how to solve it. THANK YOU! Accounting Cycle Project - Chapter 9 Following is the trial balance of

Please answer it only if you know how to solve it. THANK YOU!Please answer it only if you know how to solve it. THANK

Accounting Cycle Project - Chapter 9 Following is the trial balance of City of Kendall Green's General Fund at December 31, 2019. Using MS-Excel, prepare well-formatted worksheets as follows: (a) closing entries (b) a post-closing trial balance. (c) a statement of revenues, expenditures, and changes in fund balance for the year ended December 31, 2019 (d) a balance sheet at December 31, 2019. Debits Credits Cash $ 20,000 Property taxes receivable 30,000 Due from other funds 10,000 Vouchers payable $ 15,000 Unassigned fund balance, January 1, 2019 25,000 Revenuesproperty taxes 325,000 Revenuesother 35,000 Expendituressalaries 280,000 Expenditures-materials 20,000 Transfer out to Debt Service Fund 40,000 Encumbrancesmaterials 4,000 Budgetary fund balance reserved for encumbrances 4,000 Estimated revenues--property taxes 325,000 Estimated revenuesother 40,000 Appropriationssalaries 290,000 Appropriationsmaterials 25,000 Appropriationstransfer out to Debt Service Fund 40,000 Budgetary fund balance 10,000 Totals $769,000 $769,000 Accounting Cycle Project - Chapter 9 Following is the trial balance of City of Kendall Green's General Fund at December 31, 2019. Using MS-Excel, prepare well-formatted worksheets as follows: (a) closing entries (b) a post-closing trial balance. (c) a statement of revenues, expenditures, and changes in fund balance for the year ended December 31, 2019 (d) a balance sheet at December 31, 2019. Debits Credits Cash $ 20,000 Property taxes receivable 30,000 Due from other funds 10,000 Vouchers payable $ 15,000 Unassigned fund balance, January 1, 2019 25,000 Revenuesproperty taxes 325,000 Revenuesother 35,000 Expendituressalaries 280,000 Expenditures-materials 20,000 Transfer out to Debt Service Fund 40,000 Encumbrancesmaterials 4,000 Budgetary fund balance reserved for encumbrances 4,000 Estimated revenues--property taxes 325,000 Estimated revenuesother 40,000 Appropriationssalaries 290,000 Appropriationsmaterials 25,000 Appropriationstransfer out to Debt Service Fund 40,000 Budgetary fund balance 10,000 Totals $769,000 $769,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!