Search This Blog

Dustbuster solution in excel

Appendix Q Comprehensive Problem Dustbusters Cleaning Company

Louise Dreyton opened Dustbusters Cleaning Company on February 1, 2010. During the first month of operation the following transactions occurred:

Feb 1 Dreyton invested $20,000 cash in exchange for common stock

1 Purchased used truck for $9000, paying $4,000 cash and the balance on account

2 Purchased cleaning supplies for $2,100 on account

7 Paid $1,800 cash for a one-year insurance policy effective February 1

11 Billed customers $5,100 for cleaning services

16 Paid $2,900 cash on Accounts Payable due

19 Paid $2,800 cash for employee salaries

21 Collected $3,400 cash from customers billed on account

25 Billed customers $9,000 for cleaning services

28 Paid gas & oil for the month on truck $350

28 Declared and paid a $1,600 cash dividend

Instructions

(a) Journalize the February transactions on the tab labeled General Journal

(b) Post the February transactions on the tab labeled Ledger Accounts

---------Be sure to calculate the balance in the account after each posted transaction

(c) Prepare a trial balance at February 28 on the tab labeled Trial Balance

(d) Journalize the adjusting entries on the tab labeled Adjusting Entries

(1) Services provided but unbilled and uncollected at February 28 are $2,700

(2) Depreciation on equipment for the month is $500

(3) One month of the insurance expired

(4) An inventory count shows $700 of cleaning supplies on hand at February 28

(5) Accrued but unpaid employee salaries are $1,000

(e) Post the adjusting entries on the tab labeled Ledger Accounts

Be sure to calculate the balance in the account after each posted transaction

(f) Prepare an adjusted trial balance at February 28 on the tab labeled Adjusted Trial Balance

(g) Prepare the income statement and retained earnings statement for February and a classified balance sheet at February 28 on the tab labeled Financial Statements

(h) Journalize the closing entries on the tab labeled Closing Entries

(i) Post the closing entries on the tab labeled Ledger Accounts

Be sure to calculate the balance in the account after each posted transaction

(j) Prepare a post-closing trial balance at February 28 on the tab labeled Post-Closing Trial Balance

(k) Bonus (Optional) - Complete the 10-column worksheet for Dustbusters Cleaning Company on the tab labeled Worksheet

Click here for solution

No comments:

Post a Comment