A B C D E F G H I J K L M
1
2 P2WORK
3 Merchandising Company Worksheet
4
5 Sports Connection
6 Work Sheet
7 For Year Ended June 30, 2013
8 Trial Balance Adjustments Adj. T/Balance Income Statement Balance Sheet
9 Account Title Dr. Cr. Dr. Cr. Dr. Cr. Dr. Cr. Dr. Cr.
10 Cash 17,150 17,150 0
11 Accts receivable 27,780 27,780 0
12 Merchandise inv. 47,964 47,964 0
13 Prepaid insurance 4,410 4,410 0
14 Store Supplies 2,370 2,370 0
15 Store equipment 30,000 30,000 0
16 Accum. deprec. 3,000 0 3,000
17 Accounts payable 12,420 0 12,420
18 M. Moser, capital 105,572 0 105,572
19 M. Moser, drawing 14,400 14,400 0
20 Sales 299,400 0 299,400
21 Purchases 192,900 192,900 0
22 Advertising exp. 7,950 7,950 0
23 Rent expense 30,000 30,000 0
24 Salaries exp. 39,840 39,840 0
25 Utilities exp. 5,628 5,628 0
26 420,392 420,392
27 Income summary 0 0
28 Supplies expense 0 0
29 Insurance expense 0 0
30 Depreciation exp. 0 0
31 Prepaid rent 0 0
32 Salaries payable 0 0
33 FORM1 FORM2 FORM3 FORM4 FORM5 FORM6 FORM7 FORM8
34 Net income 0 0 0 0
35 0 0 0 0
36
Sports Connection
Breakdown of Expenses
Insurance
0%
Salaries
Advertising
Rent
Supplies
Depreciation
CGS
Utilities
Chart
Data Table
Insurance #REF!
Salaries #REF!
Advertising #REF!
Rent #REF!
Supplies #REF!
Depreciation #REF!
CGS #REF!
Utilities #REF!
Insurance
Salaries
Advertising
Supplies
Depreciation