In 2012, XYZ Inc., a medical equipment distributor, sold 10,000 units of its hospital beds at an average price of $500 per unit. The company reported estimated returns and allowances of $200,000. The company purchased 11,000 units of its product from its manufacturer in 2012 at an average cost of $350 per unit. XYZ began 2012 with 1,000 units of its product in inventory (carried at an average cost of $300 per unit). Operating expenses (excluding depreciation) in 2012 were $400,000, and the depreciation expense was $100,000. XYZ had $2,000,000 in debt outstanding throughout all of 2012, which carried an average interest rate of 10%. The company’s tax rate is 40%. Its fiscal year runs from January 1 through December 31. Given this information, prepare the following documents: a. XYZ’s 2012 income statement b. XYZ’s 2012 ending inventory balance (both in unit and in dollar terms)

Respuesta :

a. The preparation of XYZ's Income Statement  for the year ended December 31, 2012 is as follows:

Net sales revenue                             $4,800,000

Cost of goods sold                             3,450,000

Gross profit                                       $1,350,000

Operating expenses      400,000

Depreciation expense    100,000        500,000

Operating income                            $850,000

Interest Expense                                  200,000

Income before taxes                         $650,000

Taxes (40% x $650,000)                   260,000

Net income                                       $390,000

b. The ending inventory balance of XYZ's 2012 is as follows:

Units = (Beginning inventory + Purchases - Sales)

= 2,000 beds (1,000 + 11,000 - 10,000)

Dollars = $700,000 (2,000 x $350).

Data and Calculations:

Units of beds sold = 10,000

Average price per unit = $500

Sales revenue = $5,000,000

Estimated returns and allowances = $200,000

The Net sales revenue is $4,800,000 ($5,000,000 - $200,000).

The Cost of goods sold is $3,450,000 (9,000 x $350 + 1,000 x $300).

The Ending inventory is $700,000 (2,000 units x $350).

Operating expenses = $400,000

Depreciation expense = $100,000

Interest expense = $200,000 ($2,000,000 x 10%)

Tax rate = 40%

Thus, the ending inventory balance of XYZ's 2012 is 2,000 beds, worth $700,000.

Learn more about preparing income statement here: https://brainly.com/question/24470417