Prepare financial statements for the month ending January 31, 2019. (Income Statement, Statement of Retained Earnings,...

 

Transcribed Image Text:

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. ACCOUNT Cash Accounts Receivable Supplies Prepaid Rent Land } ) Computer Equipment Accumulated Depreciation, Comp Equip Office Furniture 2 Accumulated Depreciation, Off Furn 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 Utilities Expense Interest Expense Depreciation Expense, Comp Equip Depreciation Expense, Office Furniture BEGINNING NUMBERS DEBIT CREDIT 88,500 9,860 35,000 36,500 169,860 9,860 160,000 169,860 Worksheet - BeeMoor Consulting Inc JANUARY DEBIT 74,410 22,560 9,562 11,400 8,590 9,860 1,000 4.650 1,650 143,682 ENTRIES CREDIT 37,150 19,650 9,562 13,200 30,000 34,120 143,682 UNADJUSTED TRIAL BALANCE DEBIT 125,760 2,910 19,422 11,400 35,000 36,500 8,590 1,000 4,650 1.650 246,882 CREDIT 9,562 13,200 30,000 160,000 34,120 246,882 ADJUSTMENTS DEBIT 6,580 1100 3720 950 13752 26507 50 165 190 CREDIT 13752 950 165 190 3720 50 26507 7680 ADJUSTED TRIAL BALANCE DEBIT CREDIT 125,760 9,490 5,670 10,450 35,000 36,500 8,590 1,000 8,370 950 13752 1,650 50 165 190 257,587 165 190 9,562 3720 50 12,100 30,000 160,000 41.800 257587 ➤ BeeMoor Consulting Inc Income Statement BeeMoor Consulting Inc Statement of Retained Earnings info JE ADJUSTING JE CLOSING JE Worksheet statements worksheet formulas BeeMoor Consulting Inc Balance Sheet financial statement formulas Trans Analysis NOT REC... DATE CLOSING JOURNAL ENTRIES -BeeMoor Consulting Inc ACCOUNT DEBIT CREDIT 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. ACCOUNT Cash Accounts Receivable Supplies Prepaid Rent Land } ) Computer Equipment Accumulated Depreciation, Comp Equip Office Furniture 2 Accumulated Depreciation, Off Furn 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 Utilities Expense Interest Expense Depreciation Expense, Comp Equip Depreciation Expense, Office Furniture BEGINNING NUMBERS DEBIT CREDIT 88,500 9,860 35,000 36,500 169,860 9,860 160,000 169,860 Worksheet - BeeMoor Consulting Inc JANUARY DEBIT 74,410 22,560 9,562 11,400 8,590 9,860 1,000 4.650 1,650 143,682 ENTRIES CREDIT 37,150 19,650 9,562 13,200 30,000 34,120 143,682 UNADJUSTED TRIAL BALANCE DEBIT 125,760 2,910 19,422 11,400 35,000 36,500 8,590 1,000 4,650 1.650 246,882 CREDIT 9,562 13,200 30,000 160,000 34,120 246,882 ADJUSTMENTS DEBIT 6,580 1100 3720 950 13752 26507 50 165 190 CREDIT 13752 950 165 190 3720 50 26507 7680 ADJUSTED TRIAL BALANCE DEBIT CREDIT 125,760 9,490 5,670 10,450 35,000 36,500 8,590 1,000 8,370 950 13752 1,650 50 165 190 257,587 165 190 9,562 3720 50 12,100 30,000 160,000 41.800 257587 ➤ BeeMoor Consulting Inc Income Statement BeeMoor Consulting Inc Statement of Retained Earnings info JE ADJUSTING JE CLOSING JE Worksheet statements worksheet formulas BeeMoor Consulting Inc Balance Sheet financial statement formulas Trans Analysis NOT REC... DATE CLOSING JOURNAL ENTRIES -BeeMoor Consulting Inc ACCOUNT DEBIT CREDIT

Answer rating: 100% (QA)

ANSWER Income Statement Revenue 41800 Expenses 26507 Net Income 15293 Statement of Retain... View the full answer