Please complete the following exercises and/or problems from the textbook:

• P5-31A
• P6-33A
• P6-46

Prepare your answers in an Excel workbook, using one worksheet per exercise or problem.

Unadjusted Trial Balance Account Names Debit Credit Cash Adjustments Debit Credit Debit $16,400 Accounts Rec 900 Equipment a. $700 c. 30 70 $200 30 d. $4,200 70 b. 700 70 4700 4700 700 685 e. 18,000 1,400 700 685 685 18000 Salaries Payable Service Revenue $1,800 30 $4,700 1,400 Credit $1,750 $4,200 Accu. Depr.Furniture Davis, Capital Debit $200 $1,800 4,200 Unearned Revenue Credit $16,400 d. 1,800 Accounts Payable Debit Balance Sheet $1,750 $550 Accu. Depr.Equipment Furniture Credit Income Statement $16,400 1,200 Office Suppli Davis, Withd Adjusted Trial Balance 18000 $1,400 2,600 550 a. 700 b. $1,400 3150 700 3850 Rent Expense 550 $550 $550 Utilities Exp 250 $250 $250 Supplies Expense c. 700 $700 $700 Salaries Expense e. 685 $685 $685 Dep. ExpenseEquip. d. 30 $30 $30 Dep. ExpenseFurniture d. 70 $70 $70 Total $26,700 $2,735 $2,735 $28,035 $28,035 $2,285 Net Income Total $26,700 1,565 $3,850 $3,850 $25,750 $24,185 1,565 $3,850 $25,750 $25,750 Requirement 2 Requirement 3 DAVIS CONSULTING Income Statement Month Ended December 31, 2014 Revenues: Service revenue Expenses: Rent Expense Utilities Expense Supplies Expense Salaries Expense Dep. ExpenseEquip. Dep. ExpenseFurniture Total expenses Net Income Statement of Owner's Equity Month Ended December 31, 2014 3,850 550 250 700 685 30 70 Davis, Capital, December 1, 2014 Owner contribution Net income for the month 18,000 1,565 19,565 1,400 18,165 Owner withdrawal Davis, Capital, December 31, 2014 Requirement 4 2,285 1,565 Balance Sheet December 31, 2014 Assets Available accounts: Service Revenue Supplies Expense Salary Expense Rent Expense Utilities Expense Dep. ExpenseFurniture Dep. ExpenseEquipment Current Assets: Cash Accounts Receivable Office Supplies Total Current Assets Plant Assets: Equipment Less: Accu. Depr.Equipment Furniture Less: Accu. Depr.Furniture Total Plant Assets Total Assets 16,400 1,750 200 18,350 1,800 30 4,200 70 1,770 4,130 5,900 24,250 Liabilities Current Liabilities: Accounts Payable Unearned Revenue Salaries Payable Total Liabilities 4,700 700 685 6,085 Owner's Equity Davis, Capital Total Liabilities and Owner's Equity 18,165 24,250 Requirement 5 Date Accounts Dec. 31 Service revenue Income summary Debit 3,850 3,850 31 Income summary Rent Expense Utilities Expense Supplies Expense Salaries Expense Dep. ExpenseEquip. Dep. ExpenseFurniture Dec. 9 Adj. Balance Dec. 5 Balance Dec. 3 Balance Service Revenue Income Summary Income Summary Salaries Expense Supplies Expense Rent Expense Utilities Expense Dep. ExpenseEquipment Dep. ExpenseFurniture Income Summary Davis, Capital Davis, Capital Davis, Withdrawals 1,400 31 Income Summary Retained Earnings Balance 2,285 31 Retained earnings Withdrawls Dec. 2 Dec. 18 Dec. 21 Dec. 28 Available accounts for journal entries: Credit 1,565 Cash 18,000 1,100 1,400 300 550 250 700 685 30 70 1,400 1,565 550 1,800 250 400 1,400 Dec. 2 Dec. 3 Dec. 12 Dec. 26 Dec. 30 Dec. 26 Accounts Payable 400 4,200 900 4,700 Dec. 4 Dec. 5 Balance Clo. 16,400 Accounts Receivable 1,500 300 Office Supplies 900 Dec. 28 Adj. Unearned Revenue 1,400 Adj. Adj. Balance Equipment 1,800 1,800 18,000 18,000 Adj. Balance Furniture 4,200 4,200 Accumulated DepreciationFurniture 70 70 Dec. 12 Balance Balance Davis, Capital 18,000 Accumulated DepreciationEquipment 30 30 Dec. 21 Balance Dec. 2 Balance Balance Salaries Payable Clo. Dec. 4 Balance Service Revenue 1,500 1,100 Dec. 30 Balance Balance Clos. Clos. Adj. Balance Davis, Withdrawals 1,400 1,400 1,400 Income Summary 2,285 3,850 1,565 - Dec. 2 Balance Clo. Balance Clo. Clo. Bal. Balance Dec. 9 Dec. 18 Adj. Adj. Balanc Ba Rent Expense 550 550 Clo Utilities Expense 250 250 Clo Adj. Balance Balance Supplies Expense 700 700 700 - Adj. Balance Balance Salaries Expense 685 685 685 - Adj. Balance Balance Depreciation ExpenseEquipment 30 30 30 - Adj. Balance Balance Depreciation ExpenseFurniture 70 70 70 - Clo Clo Clo Clo 8 ce alance o. o. o. o. o. o. DAVIS CONSULTING Post-Closing Trial Balance December 31, 2014 Account Title Balance Debit Cash 16,400 Accounts Receivable 1,750 Office Supplies 200 Equipment 1,800 Accumulated DepreciationEquipment Furniture 4,200 Accumulated DepreciationFurniture Accounts Payable Unearned Revenue Salaries Payable Davis, Capital Total 24,350 Credit 30 70 4,700 700 685 18,165 ### P6-33A P6-46 I HAVE ATTACHED LAST WEEKS EXCEL SHEET SINCE THIS ONE IS A CONTINUIM OF THAT ONE