Part 5: Optional work sheet

Enter the unadjusted trial balance on a 10-column end-of-period spreadsheet (work sheet), and complete the spreadsheet using the following adjustment data.

a.	Merchandise inventory on May 31			$585,200
b.	Insurance expired during the year			12,000
c.	Store supplies on hand on May 31			4,000
d.	Depreciation for the current year			14,000
e.	Accrued salaries on May 31:
	Sales salaries	$7,000
	Office salaries	6,600	13,600
f.	The adjustment for customer refunds and allowances is $60,000.

If an amount box does not require an entry, leave it blank.

Palisade Creek Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended May 31, 20Y7
	Unadjusted Trial Balance		Adjustments		Adjusted Trial Balance		Income Statement		Balance Sheet
Account Title	Debit	Credit	Debit	Credit	Debit	Credit	Debit	Credit	Debit	Credit
Cash	fill in the blank 1	fill in the blank 2	fill in the blank 3	fill in the blank 4	fill in the blank 5	fill in the blank 6	fill in the blank 7	fill in the blank 8	fill in the blank 9	fill in the blank 10
Accounts Receivable	fill in the blank 11	fill in the blank 12	fill in the blank 13	fill in the blank 14	fill in the blank 15	fill in the blank 16	fill in the blank 17	fill in the blank 18	fill in the blank 19	fill in the blank 20
Merchandise Inventory	fill in the blank 21	fill in the blank 22	fill in the blank 23	fill in the blank 24	fill in the blank 25	fill in the blank 26	fill in the blank 27	fill in the blank 28	fill in the blank 29	fill in the blank 30
Prepaid Insurance	fill in the blank 31	fill in the blank 32	fill in the blank 33	fill in the blank 34	fill in the blank 35	fill in the blank 36	fill in the blank 37	fill in the blank 38	fill in the blank 39	fill in the blank 40
Store Supplies	fill in the blank 41	fill in the blank 42	fill in the blank 43	fill in the blank 44	fill in the blank 45	fill in the blank 46	fill in the blank 47	fill in the blank 48	fill in the blank 49	fill in the blank 50
Store Equipment	fill in the blank 51	fill in the blank 52	fill in the blank 53	fill in the blank 54	fill in the blank 55	fill in the blank 56	fill in the blank 57	fill in the blank 58	fill in the blank 59	fill in the blank 60
Accum. Depr.-Store Equip.	fill in the blank 61	fill in the blank 62	fill in the blank 63	fill in the blank 64	fill in the blank 65	fill in the blank 66	fill in the blank 67	fill in the blank 68	fill in the blank 69	fill in the blank 70
Accounts Payable	fill in the blank 71	fill in the blank 72	fill in the blank 73	fill in the blank 74	fill in the blank 75	fill in the blank 76	fill in the blank 77	fill in the blank 78	fill in the blank 79	fill in the blank 80
Customer Refunds Payable	fill in the blank 81	fill in the blank 82	fill in the blank 83	fill in the blank 84	fill in the blank 85	fill in the blank 86	fill in the blank 87	fill in the blank 88	fill in the blank 89	fill in the blank 90
Salaries Payable	fill in the blank 91	fill in the blank 92	fill in the blank 93	fill in the blank 94	fill in the blank 95	fill in the blank 96	fill in the blank 97	fill in the blank 98	fill in the blank 99	fill in the blank 100
Lynn Tolley, Capital	fill in the blank 101	fill in the blank 102	fill in the blank 103	fill in the blank 104	fill in the blank 105	fill in the blank 106	fill in the blank 107	fill in the blank 108	fill in the blank 109	fill in the blank 110
Lynn Tolley, Drawing	fill in the blank 111	fill in the blank 112	fill in the blank 113	fill in the blank 114	fill in the blank 115	fill in the blank 116	fill in the blank 117	fill in the blank 118	fill in the blank 119	fill in the blank 120
Sales	fill in the blank 121	fill in the blank 122	fill in the blank 123	fill in the blank 124	fill in the blank 125	fill in the blank 126	fill in the blank 127	fill in the blank 128	fill in the blank 129	fill in the blank 130
Cost of Merchandise Sold	fill in the blank 131	fill in the blank 132	fill in the blank 133	fill in the blank 134	fill in the blank 135	fill in the blank 136	fill in the blank 137	fill in the blank 138	fill in the blank 139	fill in the blank 140
Sales Salaries Expense	fill in the blank 141	fill in the blank 142	fill in the blank 143	fill in the blank 144	fill in the blank 145	fill in the blank 146	fill in the blank 147	fill in the blank 148	fill in the blank 149	fill in the blank 150
Advertising Expense	fill in the blank 151	fill in the blank 152	fill in the blank 153	fill in the blank 154	fill in the blank 155	fill in the blank 156	fill in the blank 157	fill in the blank 158	fill in the blank 159	fill in the blank 160
Depreciation Expense	fill in the blank 161	fill in the blank 162	fill in the blank 163	fill in the blank 164	fill in the blank 165	fill in the blank 166	fill in the blank 167	fill in the blank 168	fill in the blank 169	fill in the blank 170
Store Supplies Expense	fill in the blank 171	fill in the blank 172	fill in the blank 173	fill in the blank 174	fill in the blank 175	fill in the blank 176	fill in the blank 177	fill in the blank 178	fill in the blank 179	fill in the blank 180
Miscellaneous Selling Expense	fill in the blank 181	fill in the blank 182	fill in the blank 183	fill in the blank 184	fill in the blank 185	fill in the blank 186	fill in the blank 187	fill in the blank 188	fill in the blank 189	fill in the blank 190
Office Salaries Expense	fill in the blank 191	fill in the blank 192	fill in the blank 193	fill in the blank 194	fill in the blank 195	fill in the blank 196	fill in the blank 197	fill in the blank 198	fill in the blank 199	fill in the blank 200
Rent Expense	fill in the blank 201	fill in the blank 202	fill in the blank 203	fill in the blank 204	fill in the blank 205	fill in the blank 206	fill in the blank 207	fill in the blank 208	fill in the blank 209	fill in the blank 210
Insurance Expense	fill in the blank 211	fill in the blank 212	fill in the blank 213	fill in the blank 214	fill in the blank 215	fill in the blank 216	fill in the blank 217	fill in the blank 218	fill in the blank 219	fill in the blank 220
Miscellaneous Admin. Expense	fill in the blank 221	fill in the blank 222	fill in the blank 223	fill in the blank 224	fill in the blank 225	fill in the blank 226	fill in the blank 227	fill in the blank 228	fill in the blank 229	fill in the blank 230
	fill in the blank 231	fill in the blank 232	fill in the blank 233	fill in the blank 234	fill in the blank 235	fill in the blank 236	fill in the blank 237	fill in the blank 238	fill in the blank 239	fill in the blank 240
Net Income	fill in the blank 241	fill in the blank 242	fill in the blank 243	fill in the blank 244	fill in the blank 245