In: Accounting
Required information [The following information applies to the questions displayed below.] On January 1, 2021, the general ledger of ACME Fireworks includes the following account balances: Accounts Debit Credit Cash $ 27,100 Accounts Receivable 50,200 Allowance for Uncollectible Accounts $ 6,200 Inventory 22,000 Land 66,000 Equipment 25,000 Accumulated Depreciation 3,500 Accounts Payable 30,500 Notes Payable (6%, due April 1, 2022) 70,000 Common Stock 55,000 Retained Earnings 25,100 Totals $ 190,300 $ 190,300
During January 2021, the following transactions occur: January 2 Sold gift cards totaling $12,000. The cards are redeemable for merchandise within one year of the purchase date. January 6 Purchase additional inventory on account, $167,000. January 15 Firework sales for the first half of the month total $155,000. All of these sales are on account. The cost of the units sold is $83,800. January 23 Receive $127,400 from customers on accounts receivable. January 25 Pay $110,000 to inventory suppliers on accounts payable. January 28 Write off accounts receivable as uncollectible, $6,800. January 30 Firework sales for the second half of the month total $163,000. Sales include $17,000 for cash and $146,000 on account. The cost of the units sold is $89,500. January 31 Pay cash for monthly salaries, $54,000. Depreciation on the equipment for the month of January is calculated using the straight-line method. At the time the equipment was purchased, the company estimated a residual value of $5,200 and a two-year service life. The company estimates future uncollectible accounts. The company determines $31,000 of accounts receivable on January 31 are past due, and 30% of these accounts are estimated to be uncollectible. The remaining accounts receivable on January 31 are not past due, and 4% of these accounts are estimated to be uncollectible. (Hint: Use the January 31 accounts receivable balance calculated in the general ledger.) Accrued interest expense on notes payable for January. Accrued income taxes at the end of January are $15,000. By the end of January, $5,000 of the gift cards sold on January 2 have been redeemed.
Prepare a classified balance sheet as of January 31, 2021.
Balance Sheet Acme Fireworks As of January 31,2021 |
||
Assets |
||
Current Asets: |
||
Cash (WN 1) |
19,500 |
|
Accounts receivable (WN 2) |
217,000 |
|
Allowance for Uncollectible Accounts (WN 3) |
(17,008) |
|
Inventory (WN 4) |
15,700 |
|
Total Current Asset |
235,192 |
|
Non-current Asset |
||
Tangible Asset – Fixed Asset |
||
Land |
66,000 |
|
Equipment |
25,000 |
|
Accumulated depreciation (WN 5) |
(4,325) |
|
Total Fixed Asset |
86,675 |
|
Total Asset |
321,867 |
|
Liabilities & SH .Equity |
||
Current Liability |
||
Accounts Payable (WN 6) |
87,500 |
|
Gift card liability (12,000 – 5,000 = 7,000) |
7000 |
|
Income tax payable |
15000 |
|
Interest payable (70,000 * 6%) / 12 |
350 |
|
Total current liabilities |
109,850 |
|
Notes Payable (6%, due April 1, 2022) |
70,000 |
|
Total Liabilities |
179,850 |
|
SH .Equity |
||
Common stock |
55,000 |
|
Retained Earnings (25100 + 61917) (WN 7) |
87,017 |
|
Total SH .Equity |
142,017 |
|
Total Liabilities & SH .Equity |
321,867 |
WORKING NOTES:
WN 1
Cash A/c |
|||
Date |
Debit |
Date |
Credit |
Opening balance |
27,100 |
Jan 25 Accounts payable |
110,000 |
Jan 2 Gift card sold |
12,000 |
Jan 31 Salaries |
54,000 |
Jan 23 Accounts Receivable |
127,400 |
||
Jan 30 Sales |
17,000 |
Bal C/F |
19500 |
183,500 |
183,500 |
WN 2
Accounts Receivable |
|||
Date |
Debit |
Date |
Credit |
Opening balance |
50,200 |
Jan 23 Cash received |
127,400 |
Jan 15 Cr. Sales |
155,000 |
Jan 28 AR written off |
6800 |
Jan 30 Cr. Sales |
146,000 |
Bal C/F |
217,000 |
351,200 |
351,200 |
WN 3
Allowance for Uncollectible Accounts |
|||
Date |
Debit |
Date |
Credit |
Jan 28 AR written off |
6,800 |
Opening balance |
6,200 |
Bal C/F |
17,008 |
New provn. Reqd.(Bal.fig.) |
17,608 |
23,808 |
23,808 |
Ending Allowance for Uncollectible Acs. Rec. reqd.
$31,000 * 30% = 9,300
(217,000 – 9300) * 4% = 8308
Total allowance required = 9300 + 8308 = 17,608
WN 4
Inventory A/c |
|||
Date |
Debit |
Date |
Credit |
Opening Balance |
22,000 |
Jan 15 COGS |
83,800 |
Jan 6 Inventory purchased |
167,000 |
Jan 30 COGS |
89,500 |
Bal C/F |
15,700 |
||
189,000 |
189,000 |
WN 5
Accumulated Depreciation |
|||
Date |
Debit |
Date |
Credit |
Opening Balance |
3,500 |
||
Bal C/F |
4,325 |
Depreciation-equipment |
825 |
4,325 |
4,325 |
WN 6
Accounts Payable |
|||
Date |
Debit |
Date |
Credit |
Jan 25 paid to supplier |
110,000 |
Opening Balance |
30,500 |
Bal C/F |
87,500 |
Jan 6 Cr Purchase |
167,000 |
197,500 |
197,500 |
WN 7
Income statement |
|
Sales (155,000 + 163,000 + 5,000) |
323,000 |
Less: COGS (83800 + 89500) |
(173,300) |
Gross Profit |
149,700 |
Less: operating expenses |
|
Depreciation- equipment |
(825) |
Salaries expense |
(54,000) |
Bad debt Expense |
(17,608) |
Operating Income |
77,267 |
Less: Interest expense (70,000 * 6%) / 12 |
(350) |
Income before tax |
76,917 |
Less: Income tax expense |
(15,000) |
Net Income |
61,917 |