Presented below is the trial balance for the Town of Youngersville at December 31, 2019. Based on this information, complete the following for the year ending December 31, 2019. This is to be done on the Input tab:

1. Prepare the closing (Journal) entry.
2. Prepare post-closing Trial Balance.
3. Prepare a statement of revenues, expenditures, and changes in fund balance.
4. Prepare the Balance Sheet.

Town of Youngersville Adjusted Trial Balance December 31, 2019 $ 20,000 30,000 $ 10,000 $ 15,000 $ 25,000 $ 325,000 35,000 $ $ Cash Property taxes receivable Due from other funds Vouchers payable Unassigned fund balance, January 1, 2019 Revenues property taxes Revenues other Expenditures salaries Expenditures materials Transfer out to Debt Service Fund Encumbrances materials Budgetary fund balance reserved for encumbrances Estimated revenues--property taxes Estimated revenues other Appropriations salaries Appropriations materials Appropriations transfer out to Debt Service Fund Budgetary fund balance Totals $ 280,000 20,000 40,000 4,000 $ 4,000 $325,000 $ 40,000 $ 290,000 25,000 40,000 $ 10,000 $ 769,000 $ $ $ 769,000 Home X Garamond 12 ' ' ako Wrap Text Custom Paste 20. W Insert Delete Format B I U A Merge & Center - $ - %, .00 20 Conditional Format as Cell Formatting Table - Styles Styles Clipboard Font Alignment Number Cells G9 X fic . A B C D H I J K L M E F Excel 4 - General Fund Closing Entries and Financials 1 2 a. Closing entries* Debits Credits 3 4 5 6 To close encumbrances 7 8 9 10 11 12 13 14 15 To close budgetary accounts 16 17 10 Info Input + . Formatting Table Styles Styles Clipboard Font Alignment Number G9 fr A B C D E F. G H I J K L 15 16 17 18 19 20 21 22 To close nominal accounts 23 24 25 26 To establish assigned fund balance for encumbrances 27 28 * Make sure to indent for Credits 29 30 31 b. Post-closing Trial Balance: 32 Debits Credits Info Input Paste Bm Insert Delete FC B I U 19. Merge & Center - 60.00 .00 Conditional Format as Cell Formatting Table Styles Clipboard Font Alignment Number Styles Cells G9 --- E F H I J K L A B C D 30 31 b. Post-closing Trial Balance: 32 33 34 Debits Credits 35 36 37 38 39 40 41 42 43 44 45 46 47 c. Statement of revenues, expenditures, and changes in fund balance Town of Youngersville General Fund Statement of Revenues, Expenditures and Changes in Fund Balance Year ending December 31, 2019 Revenues Info Input + B I U ! + + Merge & Center $ - % .00 20 Formatting Table Styles Clipboard Font Alignment Number Styles G9 ** fi E F H I J K L A B C D Revenues 47 48 49 50 51 52 53 54 55 Expenditures Other Financing Sources (Uses) 56 57 58 59 Excess of revenues and other sources over expenditures and other financing uses Fund balance, beginning of year Fund balance, end of year 60 61 62 63 d. Blance Sheet 64 Town of Youngersville General Fund Balance Sheet 65 Clipboard Font Alignment Number Styles Cells G9 fic A B C D G H I J K L E F Town of Youngersville General Fund Balance Sheet Year ending December 31, 2019 Assets 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 Liabilities and Fund Balance Liabilities Fund Balance Info Input Ready