Prepare financial statements for the month ending January 31, 2019. (Income Statement. Statement of Retained Earnings. Classified Balance Sheet). Formatting is important and will be graded so be sure you use dollar signs and underlines as appropriate. Also be sure you have headings and proper column usage for all statements. There is a tab for these statements. Heading are PARTIALLY completed for the 3 statements. Prepare closing entries for the end of the period Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab and the Financial Statements from the Financial Statements tab to the Financial Statements tab. Highlight the entire worksheet/financial statements area respecively and press the "ctrl" key and the "-" key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed. NUMBERS ACCOUNT BEGINNING DEBIT 88,500 CREDIT Worksheet - BeeMoor Consulting Inc UNADJUSTED TRIAL JANUARY ENTRIES BALANCE DEBIT CREDIT DEBIT CREDIT 74,410 37,150 125,760 22,560 19,650 2,910 9,562 19,422 11,400 11,400 35,000 36,500 ADJUSTMENTS ADJUSTED TRIAL BALANCE DEBIT CREDIT | DEBIT CREDIT 125,760 6,580 9,490 5,670 950 10.450 35,000 36,500 9,860 13752 35,000 36,500 165/ 165 8,590 8,590 8,590 190 9,860 9,860 9.562 Cash Accounts Receivable Supplies Prepaid Rent Land Computer Equipment Accumulated Depreciation, Comp Equip Office Furniture Accumulated Depreciation, Off Furn B Accounts Payable Salaries Payable 5 Interest Payable Unearned Revenue - Long-term Notes Payable 3 Common Stock Retained Earnings Dividends Service Revenue Salaries Expense Rent Expense Supplies Expense 5 Utilities Expense 5 Interest Expense - Depreciation Expense, Comp Equip 3 Depreciation Expense, Office Furniture 190 9,562 3720 50 12,100 30,000 160,000 1100 13,200 30,000 13,200 30,000 160,000 160,000 1,000 1,000 1,000 34,120 34,120 41,800 4,650 4.650 3720 950 13752 1,650 8,370 1 950 13752 1,650 150 1 165 190 50 165 190 169,860 169,860 143,682 143,682 246,882 246,882 26507 2 6507 257,587 257587 BeeMoor Consulting Inc Income Statement BeeMoor Consulting Inc Balance Sheet BeeMoor Consulting Inc Statement of Retained Earnings info JE ADJUSTING JE CLOSING JE Worksheet statements worksheet formulas financial statement formulas Trans Analysis NOT REC ... CLOSING JOURNAL ENTRIES -BeeMoor Consulting Inc ACCOUNT DEBIT CREDIT DATE Prepare financial statements for the month ending January 31, 2019. (Income Statement. Statement of Retained Earnings. Classified Balance Sheet). Formatting is important and will be graded so be sure you use dollar signs and underlines as appropriate. Also be sure you have headings and proper column usage for all statements. There is a tab for these statements. Heading are PARTIALLY completed for the 3 statements. Prepare closing entries for the end of the period Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab and the Financial Statements from the Financial Statements tab to the Financial Statements tab. Highlight the entire worksheet/financial statements area respecively and press the "ctrl" key and the "-" key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed. NUMBERS ACCOUNT BEGINNING DEBIT 88,500 CREDIT Worksheet - BeeMoor Consulting Inc UNADJUSTED TRIAL JANUARY ENTRIES BALANCE DEBIT CREDIT DEBIT CREDIT 74,410 37,150 125,760 22,560 19,650 2,910 9,562 19,422 11,400 11,400 35,000 36,500 ADJUSTMENTS ADJUSTED TRIAL BALANCE DEBIT CREDIT | DEBIT CREDIT 125,760 6,580 9,490 5,670 950 10.450 35,000 36,500 9,860 13752 35,000 36,500 165/ 165 8,590 8,590 8,590 190 9,860 9,860 9.562 Cash Accounts Receivable Supplies Prepaid Rent Land Computer Equipment Accumulated Depreciation, Comp Equip Office Furniture Accumulated Depreciation, Off Furn B Accounts Payable Salaries Payable 5 Interest Payable Unearned Revenue - Long-term Notes Payable 3 Common Stock Retained Earnings Dividends Service Revenue Salaries Expense Rent Expense Supplies Expense 5 Utilities Expense 5 Interest Expense - Depreciation Expense, Comp Equip 3 Depreciation Expense, Office Furniture 190 9,562 3720 50 12,100 30,000 160,000 1100 13,200 30,000 13,200 30,000 160,000 160,000 1,000 1,000 1,000 34,120 34,120 41,800 4,650 4.650 3720 950 13752 1,650 8,370 1 950 13752 1,650 150 1 165 190 50 165 190 169,860 169,860 143,682 143,682 246,882 246,882 26507 2 6507 257,587 257587 BeeMoor Consulting Inc Income Statement BeeMoor Consulting Inc Balance Sheet BeeMoor Consulting Inc Statement of Retained Earnings info JE ADJUSTING JE CLOSING JE Worksheet statements worksheet formulas financial statement formulas Trans Analysis NOT REC ... CLOSING JOURNAL ENTRIES -BeeMoor Consulting Inc ACCOUNT DEBIT CREDIT DATE