Answer To: I have this accounting excel file that needs to be completed by Oct 11. You guys are awesome -...
Bhavani answered on Oct 07 2021
Directions & JE Descriptions
ABC Company
ABC Company is a merchandising business. Below are the routing transactions for ABC Company for the month of December.
Dec 1 Paid rent for December, $8000.
Dec 3 Purchased merchandise from Goat Company for $7,000 under terms 1/15, n/30, FOB Shipping Point.
Dec 4 Paid $400 cash for freight charges on purchase of Dec 3.
Dec 5 Sold merchandise to Beaver company for $21,100 under credit terms 2/10, n/60, FOB Shipping Point. The merchandise had a cost of $8800.
Dec 6 Purchased merchandise from Duck Company for 27,500, under terms n/eom.
Dec 8 Received $23,000 on account from Warthog Company, no discount. This sale was made in November.
Dec 9 After negotiations with Goat Company concerning problems with the merchandise purchased on Dec 3, ABC Company received an credit memorandum from Goat Company granting an allowance of $1,000.
Dec 10 Paid part-time sales clerk for two weeks salary including the amount owed on December 1st, $3000.
Dec 11 Sold merchandise on account to Cow Company, terms 2/10, n/60, FOB destination, $22,000. The merchandise had a cost of $10,000.
Dec 12 Paid $350 cash for shipping charges related to the Dec 11 sale to Cow Company.
Dec 13 Paid the amount due to Goat Company for the Dec 3 purchase less the allowance granted.
Dec 15 Received balance due from Beaver Company for merchandise sold on Dec 5.
Dec 16 Cow company returned merchandse from the Dec 11 sale that had cost ABC Company $1000 and been sold for $5,500. The merchandise was restored to inventory.
Dec 21 Received amount due from Cow company for the Dec 11 sale less the sale return on Dec 16.
Dec 23 Paid advertising expense for ads running the last week of December, $800.
Dec 24 Paid part-time sales clerk for two weeks' salary, $3000.
Dec 27 Purchased office supplies on account, $500.
Dec 31 Paid Duck Company amount due from the Dec 6 purchase.
At the end of December, the following adjustment data were assembled.
a After a physical count of inventory, it was determined that $127,200 of inventory exists at December 31.
b 1% of sales is expected to be refunded.
c Estimated Cost of Merchandise that will be returned in the next year is $5500
.
d Insurance Expired during the year, $2200.
e Office supplies on hand at Dec 31, $1250.
f Depreciation for December is $1400.
g Sales clerk earned $1500 of unpaid and unrecorded salary as of Dec 31.
Directions:
1. Journalize the routine transactions above on the Journal-December tab.
2 Use the Unadjusted Trial Balance and adjusting information provided above to journalize the 7 adjusting entries on the Journal - December tab (below the routine entries).
3 Use the Adjusted Trial Balance provided to prepare an income statement appropriate to a merchandising business, a statement of owner's equity, and a report form balance sheet. These should be completed on the Financial Statements tab.
You should use this template file to complete your midterm. Please rename the file to begin with your last name, first name. You may use another spreadsheet program as long as Excel can open the file.
Unadjusted Trial Balance
ABC Company
Unadjusted Trial Balance
December 31, 20xx
Debit Credit
Cash $ 60,678
Petty Cash 1,000
Notes Receivable 30,000
Accounts Receivable 51,830
Merchandise Inventory 129,840
Estimated Returns Inventory 1,000
Prepaid Insurance 8,740
Office Supplies 1,750
Delivery Equipment 60,150
Accumulated Depreciation - Delivery Equipment 22,950
Accounts Payable 64,600
Salaries Payable -...