excel sheet solve
Description
Unformatted Attachment Preview
Unadjusted Trial Balance
30 Decemeber 1999
Account
Cash
Accounts receivable
Supplies
Prepaid insurance
Equipment
Accumulated depreciation
Accounts payable
Notes payable
Unearned revenue
Share Capital – Ordinary
Retained earnings
Service revenue
Advertising expense
Insurance expense
Depreciation expense
Salaries expense
Rent expense
Utilities expense
Supplies expense
Dr
Cr
51,234
5,784
13,575
27,000
145,000
87,500
14,927
6,000
5,433
30,000
20,150
392,620
35,792
8,500
17,500
65,435
98,000
42,837
45,973
556,630
556,630
ACC 202 – Financial Accounting
Fall 2022
Assignment
Cimear’s Hair Design
The following tasks need to be completed for Cimear’s
Hair Design for the month of July.
A.
Post the Unadjusted Trial Balance to the general ledger.
B.
Enter the DEC 31 adjusting entries into the general journal.
C.
Post the adjusting entries for Decemeber into the general ledger.
D.
Prepare an Adjusted trial balance at 31 Dec 2000.
E. Prepare an income statement, a statement of retained earnings, and a balance
sheet.
1
31-Dec
A note payable of $6,000 has been outstanding since September 1, 2000. Under the terms of the note, the note plus in
2
3
4
5
6
7
8
31-Dec
31-Dec
31-Dec
31-Dec
31-Dec
31-Dec
31-Dec
Salaries of $650 for December will be paid in January.
Service provided to a customer for $350 has not been recorded/collected.
A computer was purchased on January 1, 1998 for $1,600. The useful life of the computer is 4 years. Record depreciat
On October 1, 2000, the compnay had paid $4,800 as insurance for a six month period.
The amount of supplies available on hand at the end of December was $2000.
Services were provided (earned) to a customer for $450. The cash was collected in advance on November 28, 2000.
$2,000 of the unearned service revenue had been earned
he terms of the note, the note plus interest (12% annual rate) is to be paid on March 1, 2001. No interest has been recorded on the note.
omputer is 4 years. Record depreciation for a year.
This had been recorded as prepaid insurance.
n advance on November 28, 2000.
General Journal
4
Cimear’s Hair Design
General Journal
Names:
ID #:
Date
Account
Dr
Cr
0
0
General Journal
5
Cimear’s Hair Design
General Journal
Names:
ID #:
Date
Account
Dr
Cr
0
0
Cimear’s Hair Design
General Ledger
Names:
6
ID#s:
Cash
Accounts Receivable
Prepaid Insurance
Supplies
Prepaid Rent
Equipment
Accumulated Depreciation
Salaries Payable
Accounts Payable
Loan Payable
Utilities Payable
Interest Payable
Unearned Revenue
Cimear’s Hair Design
General Ledger
Names:
7
ID#s:
Share Capital – Ordinary
Advertising Expense
Retained Earnings
Service Revenue
Insurance Expense
Depreciation Expense
Salaries Expense
Rent Expense
Utilities Expense
Supplies Expense
Interest Expense
Dividends
YOU ARE RESPONSIBLE FOR CREATING AND FORMATTING THIS PAGE
Names:
ID#s:
Purchase answer to see full
attachment
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."