Q$5-$ Please show step by step solution and use excel please. Thank you. I hope the answers are correct.

The following are selected accounts and balances for Jonah Company and Hill, Incorporated, as of December $31,2024.$ Several of Jonah's accounts have been omitted. Credit balances are indicated by parentheses. Dividends were declared and paid in the same period.

Assume that Jonah acquired Hill on January $1,2020,$ by issuing $7,000$ shares of common stock having a par value of $()/((/$$ $10/))$ per share but a fair value of $()/((/$$ $100/))$ each. On January $1,2020,$ Hill's land was undervalued by $()/((/$$ $18,600/)),$ its buildings were overvalued by $()/((/$$ $29,600/)),$ and equipment was undervalued by $()/((/$$ $61,200/).)$ The buildings had a $10-$year remaining life; the equipment had a $5-$year remaining life. A proprietary database with an appraised value of $()/((/$$ $110,000/))$ was developed internally by Hill and was estimated to have a $20-$year remaining useful life.

Required A Required A

Required B

Required C

In requirement part $($a$),$ can the consolidated totals be determir

for the subsidiary? Required C

If the parent uses the equity method, what consolidation entries would be used on a $2024$ worksheet?

Note: If no entry is required for a transactio$($n$)/($e$)$vent$,$ select $"$No journal entry required" in the first account field.

Consolidation

Worksheet Entries

Prepare Entry S to eliminate the beginning stockholders' equity of the

subsidiary.

Note: Enter debits before credits.