this is all the info given so please don't ask for more info

Replace the fair value of H with the following amounts:

Current assets $540,000

Non-current assets (net) 3,390,000

Current liabilities 810,000

Long-term debt 910,000

Change the required to the following:

Required:

1. Marks will be assigned for the use of Excel with proper formulas. Prepare D Ltds consolidated balance sheet after the combination using the worksheet approach and the acquisition method. Use the acquisition differential concept to calculate goodwill. To be clear:

Change the wording to read " On July1, Year 5, D Ltd. purchased 100% of H Corporation's shares".

2. Marks will be assigned for the use of Excel with proper formulas. Prepare D Ltds consolidated balance sheet after the combination using the direct approach and the acquisition method. To be clear:

Change the wording to read " On July1, Year 5, D Ltd. purchased 100% of H Corporation's shares".

D Ltd. and H Corporation are both engaged in the manufacture of computers. On July 1, Year 5, they agree to a merger, whereby D will issue 300,000 shares with a current market value of $9 each for the net assets of H. Summarized balance sheets of the two companies prior to the merger are presented below: Current assets Non-current assets (net) BALANCE SHEET At June 30, Year 5 D Ltd. H Corporation Carrying Amount Carrying Amount Fair Value $ 450,000 $ 500,000 $ 510,000 4,950,000 3,200,000 3,500,000 $5,400,000 $3,700,000 $ 600,000 $ 800,000 800,000 1,100,000 900,000 920,000 2,500,000 500,000 1,200,000 1,500,000 $5,400,000 $3,700,000 Current liabilities Long-term debt Common shares Retained earnings In determining the purchase price, the management of D Ltd. noted that H Corporation leases a manufacturing facil- ity under an operating lease that has terms that are favourable relative to market terms. However, the lease agreement explicitly prohibits transfer of the lease (through either sale or sublease). An independent appraiser placed a value of $60,000 on this favourable lease agreement