In: Accounting
Exercise 7-21B Complete the accounting cycle using long-term asset transactions (LO7-4, 7-7)
[The following information applies to the questions
displayed below.]
On January 1, Year 1, the general ledger of a company includes the
following account balances:
Accounts | Debit | Credit | |||||
Cash | $ | 59,800 | |||||
Accounts Receivable | 27,200 | ||||||
Allowance for Uncollectible Accounts | $ | 3,300 | |||||
Inventory | 37,400 | ||||||
Notes Receivable (5%, due in 2 years) | 25,200 | ||||||
Land | 166,000 | ||||||
Accounts Payable | 15,900 | ||||||
Common Stock | 231,000 | ||||||
Retained Earnings | 65,400 | ||||||
Totals | $ | 315,600 | $ | 315,600 | |||
During January Year 1, the following transactions occur:
January | 1 | Purchase equipment for $20,600. The company estimates a residual value of $2,600 and a five-year service life. | ||
January | 4 | Pay cash on accounts payable, $10,600. | ||
January | 8 | Purchase additional inventory on account, $93,900. | ||
January | 15 | Receive cash on accounts receivable, $23,100. | ||
January | 19 | Pay cash for salaries, $30,900. | ||
January | 28 | Pay cash for January utilities, $17,600. | ||
January | 30 | Sales for January total $231,000. All of these sales are on account. The cost of the units sold is $120,500. |
Information for adjusting entries:
rev: 11_22_2018_QC_CS-148298, 06_13_2019_QC_CS-170054
Exercise 7-21B Part 3
3. Prepare an adjusted trial balance as of
January 31, Year 1.
4. Prepare a multiple-step income statement for the period ended January 31, Year 1.
Firstly we need to pass journal entries for the given transactions and adjusting entries which are shown as follows:-
Journal Entries (Amounts in $)
Date | Account Titles and Explanations | Debit | Credit |
Jan 1 | Equipment | 20,600 | |
Cash | 20,600 | ||
(To record the purchase of equipment) | |||
Jan 4 | Accounts Payable | 10,600 | |
Cash | 10,600 | ||
(To record the cash paid on accounts payable) | |||
Jan 8 | Inventory | 93,900 | |
Accounts Payable | 93,900 | ||
(To record the inventory purchased on account) | |||
Jan 15 | Cash | 23,100 | |
Accounts Receivable | 23,100 | ||
(To record the cash received from customers) | |||
Jan 19 | Salaries expense | 30,900 | |
Cash | 30,900 | ||
(To record the salaries expense paid) | |||
Jan 28 | Utilities Expense | 17,600 | |
Cash | 17,600 | ||
(To record the utilities expense paid) | |||
Jan 30 | Accounts Receivable | 231,000 | |
Sales Revenue | 231,000 | ||
(To record the sales revenue on account) | |||
Jan 30 | Cost of goods sold | 120,500 | |
Inventory | 120,500 | ||
(To record the cost of units sold) | |||
Jan 31 | Depreciation Expense [(20,600-2,600)/5 yrs]*1/12 | 300 | |
Accumulated Depreciation-Equipment | 300 | ||
(To record the depreciation expense) | |||
Jan 31 | Bad Debt Expense | 5,680 | |
Allowance for Uncollectible Accounts (8,980-3,300) | 5,680 | ||
(To record the bad debt expense | |||
Jan 31 | Interest Receivable (25,200*5%*1/12) | 105 | |
Interest Revenue | 105 | ||
(To record the interest revenue on note) | |||
Jan 31 | Income Tax Expense | 10,100 | |
Income Tax Payable | 10,100 | ||
(To record the income tax payable) |
Working Note:-
1) Calculation of Accounts Receivable balance as on Jan 31 (Amounts in $)
Beginning Balance on Jan 1 | 27,200 |
Less: Cash received from customers | 23,100 |
Add: Sales on Account | 231,000 |
Balance as on Jan 31 | 235,100 |
Ending Balance of Allowance = (4,100*50%)+[(235,100-4,100)*3%]
= $2,050+6,930 = $8,980
3) Adjusted Trial Balance as on Jan 31 (Amounts in $)
Accounts | Debit | Credit |
Cash (59,800-20,600-10,600+23,100-30,900-17,600) | 3,200 | |
Accounts Receivable | 235,100 | |
Allowance for Uncollectible Accounts (3,300+5,680) | 8,980 | |
Inventory (37,400+93,900-120,500) | 10,800 | |
Notes Receivable (5%, due in years) | 25,200 | |
Land | 166,000 | |
Accounts Payable (15,900-10,600+93,900) | 99,200 | |
Common Stock | 231,000 | |
Retained Earnings | 65,400 | |
Equipment | 20,600 | |
Accumulated Depreciation-Equipment | 300 | |
Salaries expense | 30,900 | |
Utilities expense | 17,600 | |
Sales revenue | 231,000 | |
Cost of goods sold | 120,500 | |
Depreciation Expense | 300 | |
Bad debt expense | 5,680 | |
Interest Receivable | 105 | |
Interest Revenue | 105 | |
Income Tax Expense | 10,100 | |
Income Tax Payable | 10,100 | |
Total | 646,085 | 646,085 |
4) Multi-Step Income Statement for the month of January (Amounts in $)
Sales Revenue | 231,000 |
Cost of goods sold | (120,500) |
Gross Profit (A) | 110,500 |
Expenses: | |
Salaries expense | 30,900 |
Utilities expense | 17,600 |
Depreciation Expense | 300 |
Bad debt expense | 5,680 |
Total Expenses (B) | 54,480 |
Other Revenue: | |
Interest Revenue (C) | 105 |
Income before tax (D = A-B+C) | 56,125 |
Income tax expense (E) | 10,100 |
Net Income | 46,025 |