Question

Exercise 6-21B Complete the accounting cycle using inventory transactions (LO6-2, 6-3, 6-5, 6-6, 6-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	$	22,500
Accounts Receivable		38,000
Allowance for Uncollectible Accounts				$	3,700
Inventory		33,000
Land		66,100
Accounts Payable					30,900
Notes Payable (8%, due in 3 years)					33,000
Common Stock					59,000
Retained Earnings					33,000
Totals	$	159,600		$	159,600

The $33,000 beginning balance of inventory consists of 330 units, each costing $100. During January Year 1, the company had the following inventory transactions:

January		3		Purchase 1,200 units for $129,600 on account ($108 each).
January		8		Purchase 1,300 units for $146,900 on account ($113 each).
January		12		Purchase 1,400 units for $165,200 on account ($118 each).
January		15		Return 115 of the units purchased on January 12 because of defects.
January		19		Sell 4,000 units on account for $600,000. The cost of the units sold is determined using a FIFO perpetual inventory system.
January		22		Receive $577,000 from customers on accounts receivable.
January		24		Pay $407,000 to inventory suppliers on accounts payable.
January		27		Write off accounts receivable as uncollectible, $2,800.
January		31		Pay cash for salaries during January, $117,000.

The following information is available on January 31, Year 1.

1. At the end of January, the company estimates that the remaining units of inventory are expected to sell in February for only $100 each.
2. The company estimates future uncollectible accounts. The company determines $4,300 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 5% of these accounts are estimated to be uncollectible. (Hint: Use the January 31 accounts receivable balance calculated in the general ledger.)
3. Accrued interest expense on notes payable for January. Interest is expected to be paid each December 31.
4. Accrued income taxes at the end of January are $12,600.

Exercise 6-21B Part 4

4. Prepare a multiple-step income statement for the period ended January 31, Year 1.
  

Answer 1

Solution :-

Multiple step Income Statement ;-

Particulars	Amount($)	Amount($)
Sales		600000
Less : Cost of Goods Sold (Working Note 1)		(447560)
Gross Profit		152440
Less : Operating Expenses :-
Salaries Expenses	117000
Bad Debt Expenses (Working Note 2)	3300	(120300)
Less : Non Operating Expenses :-
Interest Expenses (($33000*8%)/12)	220	(220)
Income Before Tax		31920
Less : Income Tax Expenses		(12600)
Net Income		19320

Working Note :-

1) Cost of Goods Sold :-

= Beginning Inventory + Purchases - Return - Ending Inventory

= $33000 + $129600 + $146900 + $165200 -(115*118)-((330+1200+1300+1400-115-4000)*$118)

= $33000 + $129600 + $146900 + $165200 - $13570 - 13570

= $447560

2) Bad Debt Expenses :-

= ($4300*30%) + ($58200*5%) - ($3700-$2800)

= $1290 + $2910 - $900

= $3300

Closing Balance of Accounts Receivable :-

= Beginning Balance + Credit Sale - Cash Received - Bad Debt

= $38000 + $600000 - $577000 - $2800

= $58200