Answer To: The question is in assignment sarah6-5, the spreadsheet is to use for answer. Please, my time is...
Sandeep answered on Mar 03 2021
Sheet1
P6-5 Name:
Please add, delete, or move columns, rows, or numbers as necessary.
Please make sure all numbers are formatted with appropriate commas.
Part A
Acct Trial Balance Adjustments Adjusted T/B Income Statement Statement of R.E. Balance Sheet Remarks
No. Account Dr. Cr. Dr. Cr. Dr. Cr. Dr. Cr. Dr. Cr. Dr. Cr.
100 Cash 90,640 (63,100) 27,540 - 0 27,540 Cash is adjusted with the balncing figure after treatment of all the adjustment.
103 Accounts Rec. 159,520 159,520 - 0 159,520
105 Mdse Inventory 285,200 64,800 350,000 - 0 350,000
107 Supplies on Hand 5,360 (1,700) 3,660 - 0 3,660
108 Prepaid Insurance 4,800 (3,400) 1,400 - 0 1,400
112 Prepaid Rent 57,600 (50,600) 7,000 - 0 7,000
170 Equipment 88,000 88,000 - 0 88,000
171 Accum Depr. -- Equip 17,600 8,800 - 0 26,400 26,400
200 Accounts Payable 102,800 - 0 102,800 102,800
300 Capital Stock 220,000 - 0 220,000 220,000
310 Retained Earnings, 1/1/18 219,640 - 0 219,640 219,640
410 Sales 1,122,360 - 0 1,122,360 1,122,360
412 Sales Ret & Allow 5,160 5,160 - 0 5,160 0
418 Interest Revenue 1,000 - 0 1,000 1,000
500 Purchases 500,840 500,840 - 0 500,840
502 Purchase Ret & Allow 4,040 - 0 4,040 0 4,040
503 Transportation In 7,840 7,840 - 0 7,840
505 Advertising Expense 78,000 78,000 -...