ACCT 23020 Lecture Notes - Lecture 13: Accounts Payable, Financial Statement, Retained Earnings
Document Summary
Get access
Related Documents
Related Questions
Palisade Creek Co. is a merchandising business that uses theperpetual inventory system. The account balances for Palisade CreekCo. as of May 1, 2016 (unless otherwise indicated), are asfollows:
110 | Cash | $ 83,600 |
112 | Accounts Receivable | 233,900 |
115 | Merchandise Inventory | 624,400 |
116 | Estimated Returns Inventory | 28,000 |
117 | Prepaid Insurance | 16,800 |
118 | Store Supplies | 11,400 |
123 | Store Equipment | 569,500 |
124 | Accumulated Depreciation-Store Equipment | 56,700 |
210 | Accounts Payable | 96,600 |
211 | Salaries Payable | Ć¢ĀĀ |
212 | Customers Refunds Payable | 50,000 |
310 | Lynn Tolley, Capital, June 1, 2015 | 685,300 |
311 | Lynn Tolley, Drawing | 135,000 |
312 | Income Summary | Ć¢ĀĀ |
410 | Sales | 5,069,000 |
510 | Cost of Merchandise Sold | 2,823,000 |
520 | Sales Salaries Expense | 664,800 |
521 | Advertising Expense | 281,000 |
522 | Depreciation Expense | Ć¢ĀĀ |
523 | Store Supplies Expense | Ć¢ĀĀ |
529 | Miscellaneous Selling Expense | 12,600 |
530 | Office Salaries Expense | 382,100 |
531 | Rent Expense | 83,700 |
532 | Insurance Expense | Ć¢ĀĀ |
539 | Miscellaneous Administrative Expense | 7,800 |
During May, the last month of the fiscal year, the followingtransactions were completed:
Record the following transactions on page 20 of the journal.Refer to the Chart of Accounts for exact wording of accounttitles.
May | 1 | Paid rent for May, $5,000. |
3 | Purchased merchandise on account from Martin Co., terms 2/10,n/30, FOB shipping point, $36,000. | |
4 | Paid freight on purchase of May 3, $600. | |
6 | Sold merchandise on account to Korman Co., terms 2/10, n/30,FOB shipping point, $68,500. The cost of the merchandise sold was$41,000. | |
7 | Received $22,300 cash from Halstad Co. on account. | |
10 | Sold merchandise for cash, $54,000. The cost of the merchandisesold was $32,000. | |
13 | Paid for merchandise purchased on May 3. | |
15 | Paid advertising expense for last half of May, $11,000. | |
16 | Received cash from sale of May 6. | |
19 | Purchased merchandise for cash, $18,700. | |
19 | Paid $33,450 to Buttons Co. on account. | |
20 | Paid Korman Co. a cash refund of $13,230 for returnedmerchandise from sale of May 6. The invoice amount of the returnedmerchandise was $13,500 and the cost of the returned merchandisewas $8,000. |
Record the following transactions on page 21 of the journal.Refer to the Chart of Accounts for exact wording of accounttitles.
May | 20 | Sold merchandise on account to Crescent Co., terms 1/10, n/30,FOB shipping point, $110,000. The cost of the merchandise sold was$70,000. |
21 | For the convenience of Crescent Co., paid freight on sale ofMay 20, $2,300. | |
21 | Received $42,900 cash from Gee Co. on account. | |
21 | Purchased merchandise on account from Osterman Co., terms 1/10,n/30, FOB destination, $88,000. | |
24 | Returned of damaged merchandise purchased on May 21, receivinga credit memo from the seller for $5,000. | |
26 | Refunded cash on sales made for cash, $7,500. The cost of themerchandise returned was $4,800. | |
28 | Paid sales salaries of $56,000 and office salaries of$29,000. | |
29 | Purchased store supplies for cash, $2,400. | |
30 | Sold merchandise on account to Turner Co., terms 2/10, n/30,FOB shipping point, $78,750. The cost of the merchandise sold was$47,000. | |
30 | Received cash from sale of May 20 plus freight paid on May21. | |
31 | Paid for purchase of May 21, less return of May 24. |
Required: | |||||||||||||||||||
1. | Download the spreadsheet in the Ledger panel and save the Excelfile to your computer. Use the spreadsheet to post the Maytransactions from the journal to a ledger of four-column accounts.Be sure to save your work in Excel as it will be used to completethe following steps in Part 1 of this problem as well as steps inPart 2 of this problem. Your input into the spreadsheet will not beincluded in your grade in CengageNOW on this problem.
| ||||||||||||||||||
2. | Post the journal to the general ledger, extending the month-endbalances to the appropriate balance columns after all posting iscompleted. In this problem, you are not required to update or postto the accounts receivable and accounts payable subsidiary ledgers.Add the appropriate posting reference to the journal. | ||||||||||||||||||
3. | Prepare an unadjusted trial balance. Accounts with zerobalances can be left blank. | ||||||||||||||||||
4. | At the end of May, the following adjustment data wereassembled. Analyze and use these data to complete (5) and (6).
| ||||||||||||||||||
5. | (Optional) On your own paper or spreadsheet, enter theunadjusted trial balance on a 10-column end-of-period spreadsheet(work sheet), and complete the spreadsheet. Find a blankend-of-period work sheet in the Excel spreadsheet you previouslydownloaded. | ||||||||||||||||||
6. |
| ||||||||||||||||||
7. | Prepare an adjusted trial balance. Accounts with zero balancescan be left blank.
|
Transactions related to revenue and cash receipts completed byAspen Architects Co. during the period June 2Ć¢ĀĀ30, 2016, are asfollows:
June 2. | Issued Invoice No. 793 to Nickle Co., $7,330. | |
June 5. | Received cash from Mendez Co. for the balance owed on itsaccount. | |
June 6. | Issued Invoice No. 794 to Preston Co., $2,640. | |
June 13. | Issued Invoice No. 795 to Shilo Co., $3,930. | |
Post revenue and collections to the accounts receivablesubsidiary ledger. | ||
June 15. | Received cash from Preston Co. for the balance owed on June1. | |
June 16. | Issued Invoice No. 796 to Preston Co., $8,210. | |
June 19. | Received cash from Nickle Co. for the balance due on invoice ofJune 2. | |
June 20. | Received cash from Preston Co. for invoice of June 6. | |
June 22. | Issued Invoice No. 797 to Mendez Co., $10,820. | |
June 25. | Received $2,990 note receivable in partial settlement of thebalance due on | |
June 30. | Recorded cash fees earned, $18,460. |
Required:
1. Insert the following balances in the generalledger as of June 1:
11 | Cash | $16,240 |
12 | Accounts Receivable | 19,780 |
14 | Notes Receivable | 8,610 |
41 | Fees Earned | - |
After completing the recording of the transactions in thejournals in part 3, total each of the columns of the specialjournals, and post the individual entries and totals to the generalledger. Insert account balances after the last posting. Whenposting to the general ledger, post in chronological order.However, if there is more than one entry on the same date, be sureto post transactions from the revenue journal before postingtransactions from the cash receipts journal.
If an amount box does not require an entry, leave it blank.
GENERAL LEDGER | ||||||
Date | Item | Post. | Debit | Credit | Balance Dr. | Balance Cr. |
Account: Cash # 11 | ||||||
2016 | ||||||
June 1 | Balance | Ć¢ĀĀ | ||||
Account: Accounts Receivable # 12 | ||||||
2016 | ||||||
June 1 | Balance | Ć¢ĀĀ | ||||
Account: Notes Receivable # 14 | ||||||
2016 | ||||||
June 1 | Balance | Ć¢ĀĀ | ||||
Account: Fees Earned # 41 | ||||||
2016 | ||||||
2. Insert the following balances in theaccounts receivable subsidiary ledger as of June 1:
Mendez Co. | $11,370 |
Nickle Co. | - |
Preston Co. | 8,410 |
Shilo Co. | - |
After completing the recording of the transactions in thejournals in part 3, post to the accounts receivable subsidiaryledger in chronological order, and insert the balances at thepoints indicated in the narrative of transactions. Determine thebalance in the customer's account before recording a cash receipt.If an amount box does not require an entry, leave it blank.
ACCOUNTS RECEIVABLE SUBSIDIARY LEDGER | |||||
Date | Item | Post. Ref. | Debit | Credit | Balance |
Account: Mendez Co. | |||||
2016 | |||||
June 1 | Balance | Ć¢ĀĀ | |||
Account: Nickle Co. | |||||
2016 | |||||
Account: Preston Co. | |||||
2016 | |||||
June 1 | Balance | Ć¢ĀĀ | |||
Account: Shilo Co. | |||||
2016 | |||||
3. Prepare a single-column revenue journal (p.40) and a cash receipts journal (p. 36). Use the following columnheadings for the cash receipts journal: Fees Earned Cr., AccountsReceivable Cr., and Cash Dr. The Fees Earned column is used torecord cash fees.
4. Using the two special journals and thetwo-column general journal (p. 1), journalize the transactions inchronological order for June. Post to the accounts receivablesubsidiary ledger (in part 2), and insert the balances at thepoints indicated in the narrative of transactions. Determine thebalance in the customer's account before recording a cashreceipt.
5. Total each of the columns of the specialjournals, and post the individual entries and totals to the generalledger (in part 1). Insert account balances after the lastposting.
If an amount box does not require an entry, leave it blank.
REVENUE JOURNAL | PAGE 40 | |||
Date | Invoice No. | Account Debited | Post. Ref. | Accounts Rec. Dr. |
2016 | ||||
Ć¢ĀĀ | ||||
Ć¢ĀĀ | ||||
Ć¢ĀĀ | ||||
Ć¢ĀĀ | ||||
Ć¢ĀĀ | ||||
CASH RECEIPTS JOURNAL | PAGE 36 | ||||
Date | Account Credited | Post. Ref. | Fees Earned Cr. | Accts. Rec. Cr. | Cash Dr. |
2016 | |||||
Ć¢ĀĀ | |||||
Ć¢ĀĀ | |||||
Ć¢ĀĀ | |||||
Ć¢ĀĀ | |||||
Ć¢ĀĀ | |||||
JOURNAL | PAGE 1 | |||
Date | Description | Post Ref. | Debit | Credit |
2016 | ||||
6. What is the sum of the customerbalances?
$
Does the sum of the customer balances agree with the accountsreceivable controlling account in the general ledger?
7. Would an automated system omit postings to acontrolling account as performed in step 5 for AccountsReceivable?