The following are selected account balances from Penske Company and Stanza Corporation as of December $31,2024$:

Account Penske Stanza

Revenues $($$$776,000)($$$556,000)$

Cost of Goods Sold $$276,600$ $$139,000$

Depreciation Expense $$171,000$ $$262,000$

Investment Income Not Given $$0$

Dividends Declared $$80,000$ $$60,000$

Retained Earnings, $1/1/24($$$658,000)($$$394,000)$

Current Assets $$510,000$ $$514,000$

Copyrights $$1,010,000$ $$378,500$

Royalty Agreements $$682,000$ $$1,118,000$

Investment in Stanza Not Given $$0$

Liabilities $($$$592,000)($$$1,241,500)$

Common Stock $($$$600,000)($$$200,000)$

Additional Paid$-$in$-$Capital $($$$150,000)($$$80,000)$

Note: Parentheses indicate a credit balance.

On January $1,2024,$ Penske acquired all of Stanza's outstanding stock for:

Cash and Common Stock $($fair value$)$ $$914,000$

Stock Issuance Costs $$10,000$

At the date of acquisition, copyrights $($with a six$-$year remaining life$)$ have the following:

Remaining life $6$ Years

Book Value $$444,000$

Fair Value $$618,000$

Required:

Note: Use cells A$2$ to C$30$ from the given information and amounts calculated below to complete this question. Input all amounts as positive values. Losses should be calculated and displayed as negative values.

Complete the allocation schedule and determine the following amounts as of December $31,2024$:

a$.$ Complete the allocation schedule

Amounts Remaining Life Amortization

Stanza acquisition fair value $$914,000$

Book Value of Subsidiary

Fair value in excess of book value

Excess fair value allocated to copyrights based on fair value

Goodwill

b$.$ What is the consolidated copyrights balance?

Penske $($Book Value$)$

Stanza $($Book Value$)$

Allocation $($Above$)$

Excess Amortizations, $2024$

Total

c$.$ What is the consolidated net income?

Note: Input all amounts as positive values. Losses should be calculated and displayed as negative values.

Revenues

Cost of Goods Sold

Depreciation Expense

Excess Amortization

Consolidated Net Income

d$.$ What is the consolidated retained earnings balance?

Note: Input all amounts as positive values. Losses should be calculated and displayed as negative values.

Retained Earnings, $1/1/24$

Net Income

Dividends Declared

Total

e$.$ What is the consolidated balance for goodwill?

Goodwill