Reference no: EM132596934

Question - How to prepare an adjust trial balance for the problem below. Will the balance sheet be based on the value on Dec 31st or September 30th?

9/1 Kawabata begins practice as a dentist and invests $20,000 cash.

9/1 Purchases a one-year insurance policy for $1,200, paying the entire amount in cash.

9/2 Purchases dental equipment on account from Green Jacket Co. for $17,280.

9/2 Collects $3,000 prepayment from patient for 2 year orthodontic treatment plan.

9/4 Pays rent for office space, $680 for the month.

9/4 Employs a receptionist, Michael Bradley.

9/5 Purchases dental supplies for cash, $942.

9/8 Receives cash of $1,690 from patients for services performed.

9/10 Pays miscellaneous office expenses, $430.

9/14 Bills patients $5,820 for services performed.1

9/8 Pays Green Jacket Co. on account, $3,600.

9/19 Withdraws $3,000 cash from the business for personal use.

9/20 Receives $980 from patients on account.

9/25 Bills patients $2,110 for services performed.

9/30 Pays the following expenses in cash: Salaries and wages $1,800; miscellaneous office expenses $85. (Record each separately.)

Record depreciation using a 5-year life on the equipment, the straight-line method, and no salvage value. Dental supplies used during September totaled $330.

The solution to the Week 1 Group Assignment has now been posted in Week 1. Please review the solution, and use the correct balances to update your own group work. Prepare necessary adjusting entries for depreciation, prepaid insurance, unearned revenue, and supplies used. Then prepare a adjusted trial balance, income statement, and balance sheet in Excel.