On January 1, 2023, Panther, Incorporated, issued securities with a total fair value of $581,000 for 100 percent of Stark Corporation's outstanding ownership shares. Stark has long supplied inventory to Panther. The companies expect to achieve synergies with production scheduling and product development with this combination.

Although Stark's book value at the acquisition date was $333,000, the fair value of its trademarks was assessed to be $67,000 more than their carrying amounts. Additionally, Stark's patented technology was undervalued in its accounting records by $181,000. The trademarks were considered to have indefinite lives, and the estimated remaining life of the patented technology was eight years.

In 2023, Stark sold Panther inventory costing $100,000 for $200,000. As of December 31, 2023, Panther had resold 75 percent of this inventory. In 2024, Panther bought from Stark $171,000 of inventory that had an original cost of $85,500. At the end of 2024, Panther held $46,100 (transfer price) of inventory acquired from Stark, all from its 2024 purchases.

During 2024, Panther sold Stark a parcel of land for $107,300 and recorded a gain of $19,100 on the sale. Stark still owes Panther $74,400 (current liability) related to the land sale.

At the end of 2024, Panther and Stark prepared the following statements for consolidation.

Items	Panther, Incorporated	Stark Corporation
Revenues	$ (852,200)	$ (389,000)
Cost of goods sold	366,600	204,100
Other operating expenses	200,700	87,400
Gain on sale of land	(19,100)	0
Equity in Stark's earnings	(57,725)	0
Net income	$ (361,725)	$ (97,500)
Retained earnings, 1/1/24	$ (377,000)	$ (316,600)
Net income	(361,725)	(97,500)
Dividends declared	98,800	35,500
Retained earnings, 12/31/24	$ (639,925)	$ (378,600)
Cash and receivables	$ 135,000	$ 186,000
Inventory	411,100	132,400
Investment in Stark	748,900	0
Trademarks	0	69,700
Land, buildings, and equipment (net)	844,100	336,400
Patented technology	0	150,100
Total assets	$ 2,139,100	$ 874,600
Liabilities	$ (771,675)	$ (286,300)
Common stock	(400,000)	(175,000)
Additional paid-in capital	(327,500)	(34,700)
Retained earnings, 12/31/24	(639,925)	(378,600)
Total liabilities and equity	$ (2,139,100)	$ (874,600)

Required:

Show how Panther computed its $57,725 equity in Stark's earnings balance.

Prepare a 2024 consolidated worksheet for Panther and Stark.

am I missing anything it's telling me I'm missing something please explain and show it in Excel

a. Show how Panther computed its $57,725 equity in Stark's earnings balance. b. Prepare a 2024 consolidated worksheet for Panther and Stark. Answer is not complete. Complete this question by entering your answers in the tabs below. Show how Panther computed its $57,725 equity in Stark's earnings balance. Prepare a 2024 consolidated worksheet for Panther and Stark. Note: For accounts where multiple consolidation entries are required, combine all debit entries into one amount and enter this amount in the debit column of the worksheet. Similarly, combine all credit entries into one amount and enter this amount in the credit column of the worksheet. Input all amounts as positive values