Ive done all the previous statements.

I need help on how to do the post-closing trial balance for this question. I've already done the previous statements.

Scenario:

Moonlight Bay Inn is incorporated on January 2, 2017, by its three owners, each of whom contributes $20,000 in cash in exchange for shares of stock in the business. In addition to the sale of stock, the following transactions are entered into during the month of January:

Requirement #10: Prepare a post-closing trial balance as of January 31 in the space below.

Assignment 1 Accounting Cycle Project_ACCU 602 (Student Version) (2) QuSearch Sheet Formulas Data Review View Comments AutoSave OFF A sro Home Insert Draw Page Layout Arial 10 B I U E 119 x fix A A = Share E 490 = = Wrap Text A A DO E General - PZD - E Paste Merge & Center $ % 20 Conditional Format Formatting as Table Cell Styles Insert Delete Format Sort & Filter X Find & Select Ideas H K L M N O P Q R S TU REQUIREMENT #6: Prepare an Adjusted Trial Balance in the space below. Moonlight Bay Inn Adjusted Trial Balance January 31 Only enter accounts that have a balance. List accounts in order Debit Credit 29,600 5,750 230 15,000 35,000 100 15,000 Description (Account Name) Cash Prepaid Insurance Suppiles Land Inn-Building Accummualted Depreciation building Furniture Accummualted Depreciation Furniture Accounts Payable Guest Deposit for Room Note Payable Common Stock Room Rental Revenue Restuarnt Income Wage and Salary Expense Advertisment Exspense Dividends 125 950 490 30,000 60,000 8,790 6,600 9.350 450 600 Supplies exspense Deprication exspense Interest exspense Insurance exspense Utilities exspense Income tax exspense interest payable wages and Salary payable Utility Payable Income tax Payable 720 225 300 250 740 1.007 300 ,120 1 5 740 1,007 114,222 1 14,222 Journal Entries General Ledger Trial Balance Adjusting Entries Adjusted TB Financial Statements Closing Entries Post Closing Trial Balance Grading Rubric 0 + - Ready - + 99% AutoSave OFF S 5 Assignment 1 Accounting Cycle Project_ACCU 602 (Student Version) (2) QuSearch Sheet Home Insert Draw Page Layout Formulas Data Review View Comments 10 A Share E 490 A = = DO ab Wrap Text Century Gothic BIU = E General - PZD - E Paste A 3 Merge & Center $ % -99 Conditional Format Formatting as Table Cell Styles Insert Delete Format Sort & Filter X Find & Select Ideas H7 X fx (enter figures in column I and totals in column J) K L M N O P B C D F Requirement #7: Prepare the financial statements for Moonlight Bay Inn as of January 31 in the space below. You will only be preparing the Income Statement, Statement of Retained Earning, and the Balance Sheet. The Statement of Cash Flows is a required Financial Statement, but is not required for this project. U AWN Moonlight Bay Inn Statement of Retained Earnings For the Month Ending Janauary 31 Moonlight Bay Inn Balance Sheet January 31 (enter figures in column I and totals inlcolumn J) Moonlight Bay Inn Income Statement For the Month Ending January 31 I(enter figures in column B and totals in column C) Revenues: From rental of rooms 8,790 10 From restaurant Total Revenue Assets: 6.600 Retained Earnings, January 1 Add: Net Income Subtotal Less : Dividends Retained Earnings, October 31 2,348 2,348 (600N 1.748 15.390 29600 230 5750 35,580 13 15 Current Assets: Cash Cleaning Supplles Prepaid Insurance Total current assets Property, plant, and Euip.: Land House, net of accum. Depr. Furniture, net of accum. Depr. Total Property, plant, and Eulp. Total Assets Expenses: Advertising Wages Depreciation Interest Insurance Supplies Utilities Income Taxes Total Expenses 17 450 9.350 225 300 250 720 740 1,007 15000 34900 14875 64775 100,355 35,580 20 13.042 Net Income 2,348 950 300 Liabilities and Stockholders' Equity Liabilities: Current Liabilities: Accounts Payable Interest Payable Wages Payable Income Taxes Payable Rent received in advance Utilities Payable Total current labilities Long-term Debt: Notes Payable Total Liabilities 5120 1007 490 740 8607 30,000 38,607 60000 Stockholders' Equity: Capital Stock Retained Earnings Total Stockholders' Equity 1748 61,748 Total Liabilities & Stockholders' Equity 100,355 44 45 Journal Entries General Ledger Trial Balance Adjusting Entries Adjusted TB Financial Statements Closing Entries Post Closing Trial Balance Grading Rubric @ J + - Ready O + 100% Assignment 1 Accounting Cycle Project_ACCU 602 (Student Version) (2) QuSearch Sheet AutoSave OFF Home Insert Draw Svo Page Layout Formulas Data Review View Comments Wrap Text Arial 10 A A = = = DO BIU E DA SE General Share E 490 - PZD - E Paste Merge & Center $ % , -20 Conditional Format Formatting as Table Cell Styles Insert Delete Format Ideas X Sort & Filter Find & Select H30 x fx A C D E F G H I J K L M N O P Q R S T Requirement #9: Post the closing entries to the T-Accounts on the General Ledger worksheet and compute ending balances. Just add to the adjusted balances already listed. Click here to go to the General Ledger worksheet to complete Requirement #9. Date Credit Debit 8.790 6.600 EXAMPLE 15,390 32,800 13,462 General Journal Description (Account Name) 31-Jan Rent Revenues Service Revenue Income Summary 31-Jan Income Summary Advertising Expenses Wages Expenses Dividend Expenses Depreciation expenses-House Depreciation expenses-Furniture Interest Expenses Insurance Expenses Supplles expenses Gas and Electricity Expenses 31-Jan Income Tax 12-31-X3 Revenues Income Summary To close revenues to Income Summary 32,8C 450 9.350 600 100 125 300 250 720 740 For instructions on how to prepare closing entries, view this link: Closing Entries 12-31-X3 30,200 Income Summary Salaries Expense Advertising Expense Fuel Expense Depreciation Expense Interest Expense To close expenses to Income Summary 17,00 5,00 2,00 5,00 1,20 827 1,929 31-Jan Income Summary retained earnings 1.929 12-31-X3 2,600 2,60 Income Summary Retained Earnings To close Income Summary to retained earnings (balance equals net income) 12-31-X3 1,000 Retained Earnings Dividends To close dividends 1,00 SEEEE! 30,780 30.780 42 Journal Entries General Ledger Trial Balance Adjusting Entries Adjusted TB Financial Statements Closing Entries Post Closing Trial Balance Grading Rubric 6 + - Ready - + 100% QuSearch Sheet Comments General - PZD - E Share 549 AutoSave OFF A svus Assignment 1_Accounting Cycle Project_ACCU 602 (Student Version) (2) Home Insert Draw Page Layout Formulas Data Review View Arial 10 A A = = = DO ab Wrap Text BI U DA SE 3 Merge & Center $ % 20 Conditional Format Formatting as Table | 131 x fox A E F H I J K L Requirement #10: Prepare a post-closing trial balance as of January 31 in the space below. Paste Cell Styles Insert Delete Format Ideas X Sort & Filter Find & Select M N O P Q R S T Moonlight Bay Inn Post-Closing Trial Balance January 31 Account Title Account Balance Debit Credit Only enter accounts that have a balnce List accounts in order of Account Number 44 45 Journal Entries General Ledger Trial Balance Adjusting Entries Adjusted TB Financial Statements Closing Entries Post Closing Trial Balance Grading Rubric 6 @ J + - - Ready + 100%