Fluent Essays

using the attached excel templates. for 3 homeworks from Book name Accounting Warren/Reeve/Duchac 26 edition plus some multiple choices questions answer all questions each excel has the exercise # PR 6-2A PR-6-5APR 4-5A individual you have to get more than 90\% in each attached excel templates, which is shown in red in the upper right corner of each excel exercise pr_6_2a_page_309_accounting.xlsx pr_6_5a_page_311_accounting.xlsx pr4_5a_empty.xlsx pages_91_203_204.pdf pages_309_310_311.pdf Unformatted Attachment Preview Problem 6-2A Name: Section: Score: 0\% Key Code: [Key code here] Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. An asterisk (*) will appear to the left of an incorrect entry. JOURNAL Date Mar. Account 2 2 3 3 4 4 5 5 12 Debit Credit 14 14 16 16 18 18 19 19 19 26 28 31 31 April 3 15 Problem 6-5A Name: Section: Score: 20\% Key Code: [Key code here] Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. An asterisk (*) will appear to the right of an incorrect entry. Essay answers will not be graded. 1. CLAIREMONT CO. Income Statement For the Year Ended May 31, 2016 Sales Cost of merchandise sold Gross profit Expenses: Selling expenses: Total selling expenses Administrative expenses: Total administrative expenses Total expenses Income from operations Other expense: Net income 2. CLAIREMONT CO. Statement of Owners Equity For the Year Ended May 31, 2016 Kristina Marble, capital, June 1, 2015 Kristina Marble, capital, May 31, 2016 3. CLAIREMONT CO. Balance Sheet May 31, 2016 Assets Current assets: Total current assets: Property, plant and equipment: Office equipment Store equipment Total property, plant and equipment Total assets Liabilities Current liabilities: Total current liabilities: Long-term liabilities: Total liabilities Owners Equity Kristina Marble, capital Total liabilities and owners equity 4. a. (Key essay answer here) b. (Key essay answer here) Problem 4-5A Name: Section: Score: 0\% Key Code: 2 Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. An asterisk (*) will appear to the right of an incorrect entry. In the general ledger accounts, only normal balance columns will be graded. For correct grading in the trial balances and work sheet, enter a zero in cells you would otherwise leave blank. 1. and 2. JOURNAL Date Description 2016 July 1 1 2 4 5 6 10 Page 1 Post. Ref. Debit Credit 12 12 14 Page 2 JOURNAL Date 2016 July 17 18 20 24 26 27 29 31 Description Post. Ref. Debit Credit 31 31 31 2., 6., and 9. GENERAL LEDGER Cash Date 11 Item Post. Ref. Balance Dr. Cr. Dr. Cr. 2016 July 1 1 2 4 6 10 12 14 17 18 24 26 27 29 31 31 31 Accounts Receivable Date 2016 July 1 6 12 20 26 31 Item 12 Post. Ref. Balance Dr. Cr. Dr. Cr. Supplies 14 Date 2016 July 1 18 31 Item Post. Ref. Balance Dr. Cr. Dr. Cr. Adjusting Prepaid Rent Date 2016 July 1 31 15 Item Post. Ref. Balance Dr. Cr. Dr. Cr. Adjusting Prepaid Insurance Date 2016 July 2 31 Item 16 Post. Ref. Balance Dr. Cr. Dr. Cr. Adjusting Office Equipment Date Item 18 Post. Ref. Balance Dr. Cr. Dr. Cr. 2016 July 1 5 Accumulated Depreciation Date 2016 July 31 Item 19 Post. Ref. Balance Dr. Cr. Dr. Cr. Adjusting Accounts Payable Date 2016 Item 21 Post. Ref. Balance Dr. Cr. Dr. Cr. July 5 12 Salaries Payable Date 2016 July 31 22 Item Post. Ref. Balance Dr. Cr. Dr. Cr. Adjusting Unearned Fees Date 2016 July 4 31 23 Item Post. Ref. Balance Dr. Cr. Dr. Cr. Adjusting Steffy Lopez, Capital Date 2016 July 1 31 31 Item 31 Post. Ref. Balance Dr. Cr. Dr. Cr. Closing Closing Steffy Lopez, Drawing Date 2016 July 31 31 Item Closing 32 Post. Ref. Balance Dr. Cr. Dr. Cr. Income Summary Date 2016 July 31 31 31 33 Item Post. Ref. Item Post. Ref. Balance Dr. Cr. Dr. Cr. Closing Closing Closing Fees Earned Date 2016 July 12 17 20 24 30 30 31 31 41 Balance Dr. Cr. Dr. Cr. Adjusting Closing Salary Expense Date 2016 July 14 27 31 31 51 Item Post. Ref. Balance Dr. Cr. Dr. Cr. Adjusting Closing Rent Expense Date 2016 July 31 31 52 Item Post. Ref. Balance Dr. Cr. Dr. Cr. Adjusting Closing Supplies Expense Date Item 53 Post. Ref. Balance Dr. Cr. Dr. Cr. 2016 July 31 31 Adjusting Closing Depreciation Expense Date 2016 July 31 31 Item 54 Post. Ref. Balance Dr. Cr. Dr. Cr. Adjusting Closing Insurance Expense Date 2016 July 31 31 Item 55 Post. Ref. Balance Dr. Cr. Dr. Cr. Adjusting Closing Miscellaneous Expense Date 2016 July 10 29 31 31 Item 59 Post. Ref. Balance Dr. Cr. Dr. Closing 3. DIAMOND CONSULTING Unadjusted Trial Balance July 31, 2016 Debit Balances Cash Accounts Receivable Supplies Prepaid Rent Prepaid Insurance Office Equipment Accumulated Depreciation Accounts Payable Salaries Payable Unearned Fees Steffy Lopez, Capital Steffy Lopez, Drawing Fees Earned Salary Expense Rent Expense Credit Balances Cr. Supplies Expense Depreciation Expense Insurance Expense Miscellaneous Expense 5. DIAMOND CONSULTING End-of-Period Spreadsheet (Work Sheet) For the Month Ended July 31, 2016 Unadjusted Trial Balance Dr. Cr. Account Title Cash Accounts Receivable Supplies Prepaid Rent Prepaid Insurance Office Equipment Accum. Depreciation Accounts Payable Salaries Payable Unearned Fees Steffy Lopez, Capital Steffy Lopez, Drawing Fees Earned Salary Expense Rent Expense Supplies Expense Depreciation Expense Insurance Expense Miscellaneous Expense Adjustments Dr. Cr. 32,450 16,450 3,800 4,800 4,500 14,000 1,300 5,500 45,000 12,500 41,600 3,500 1,400 93,400 6. 93,400 JOURNAL Date Description 2016 July 31 Adjusting Entries 31 31 Adjusted Trial Balance Dr. Cr. Page 3 Post. Ref. Debit Credit Income Statement Dr. Balance Sheet Cr. Dr. Cr. 31 31 31 7. DIAMOND CONSULTING Adjusted Trial Balance July 31, 2016 Debit Balances Cash Accounts Receivable Supplies Prepaid Rent Prepaid Insurance Office Equipment Accumulated Depreciation Accounts Payable Salaries Payable Unearned Fees Steffy Lopez, Capital Steffy Lopez, Drawing Fees Earned Salary Expense Rent Expense Supplies Expense Depreciation Expense Insurance Expense Miscellaneous Expense Credit Balances 8. DIAMOND CONSULTING Income Statement For the Month Ended July 31, 2016 Revenues: Total revenues Expenses: Total expenses Net income DIAMOND CONSULTING Statement of Owners Equity For the Month Ended July 31, 2016 Steffy Lopez, capital, July 1, 2016 Total Net income for the month Increase in owners equity Steffy Lopez, capital, July 31, 2016 DIAMOND CONSULTING Balance Sheet July 31, 2016 Assets Current assets: Liabilities Current liabilities Unearned fees Total liabilities Total current assets Property, plant, and equipment: Owners Equity Total property, plant, and equipment Total assets Total liabilities and owners equity 9. JOURNAL Date Description 2016 July 31 Closing Entries Page 4 Post. Ref. Debit 31 Miscellaneous Expense 31 31 10. DIAMOND CONSULTING Post-Closing Trial Balance July 31, 2016 Debit Balances Cash Accounts Receivable Supplies Prepaid Rent Prepaid Insurance Office Equipment Accumulated Depreciation Accounts Payable Salaries Payable Unearned Fees Steffy Lopez, Capital Credit Balances Credit ... Purchase answer to see full attachment