Short report on Consolidated financial statements and calculations
Consolidation worksheet with adjustment entries for intragroup transactions: inventories, PPE, dividends, and debentures
Task Details:
On 1 July 2021, Ingrid Ltd acquired all the issued shares of Isabella Ltd. The consideration for the acquisition was $47 350 cash plus 100000 shares in Ingrid Ltd, which had a fair value of $2 per share.
At the acquisition date, Isabella Ltd had inventories with a fair value $1500 greater than carrying amount. All these inventories were sold by Isabella Ltd prior to 30 June 2022.
All these inventories were sold by Isabella Ltd prior to 30 June 2022. Isabella Ltd conducts a research and development division. It has expensed all past outlays. At the acquisition date, Ingrid Ltd assessed there was an in-process research and development asset with a fair value of $12000. Ingrid decided that $3000 of this asset should be impaired for the year to 30 June 2022. The income tax rate is 30%.
Intragroup transactions occurring in the annual period ended 30 June 2022 were as follows.
(a) During the course of the year, Isabella Ltd sold inventories to Ingrid Ltd. Total sales were $60000, these being sold at cost plus 25%. At 30 June 2022, Ingrid Ltd still held inventories that it had bought from Isabella Ltd for $15000.
(b) On 1 January 2022, Ingrid Ltd acquired 900 $100 8% debentures previously issued by Isabella Ltd. These were acquired on the open market for $85500. Interest on debentures is paid half-yearly. Interest due on 30 June 2022 has been paid by Isabella Ltd.
(c) On 1 April 2022, Ingrid Ltd sold an inventory item to Isabella Ltd for $45000. This asset had cost Isabella Ltd $36000 to manufacture. The asset is used by Isabella Ltd as part of its plant and machinery. The depreciation rate used by Isabella Ltd for this type of asset is 20% p.a. on cost.
(d) On 1 March 2022, Isabella Ltd declared and paid a dividend of $14 700 from its profits. On 30 June 2022, Isabella Ltd declared a further dividend of $10 800.
The financial information provided by the two entities for 30 June 2022 was as follows:
	Ingrid Ltd	Isabella Ltd
Sales	352,100.00	272,000.00
Dividend revenue	25,500.00	5,000.00
Other income/gains	10,000.00	23,000.00
	387,600.00	300,000.00
Cost of Sales	- 184,500.00	- 180,000.00
Other Expenses	- 51,900.00	- 33,000.00
	- 236,400.00	- 213,000.00
Profit before income tax	151,200.00	87,000.00
Income tax expense	- 48,000.00	- 30,000.00
Profit for the year	103,200.00	57,000.00
Retained earnings (1/7/21)	36,000.00	18,000.00
	139,200.00	75,000.00
Dividend Paid	- 51,000.00	- 14,700.00
Dividend Declare	- 36,000.00	- 10,800.00
	- 87,000.00	- 25,500.00
Retained earnings (1/7/22)	52,200.00	49,500.00
Share Capital	480,000.00	180,000.00
General Reserve	102,000.00	36,000.00
Total Equity	634,200.00	265,500.00
Deferred Tax Liability	19,500.00	7,500.00
8% Debentures	-	120,000.00
Dividend Payable	24,000.00	10,800.00
Provisions	18,000.00	35,460.00
Payables	16,500.00	15,000.00
Total Liabilities	78,000.00	188,760.00
Total Equity and Liablities	712,200.00	454,260.00
Plant and Machinery	160,000.00	165,000.00
Accumulated Depreciation	- 60,000.00	- 39,000.00
Land	143,450.00	225,000.00
Debentures	85,500.00	-
Shares in Isabella Ltd	247,350.00	-
Cash	1,150.00	5,260.00
Receivables	31,750.00	15,500.00
Inventories	103,000.00	82,500.00
Total Assests	712,200.00	454,260.00
Required
1. Calculate acquisition analysis as of 1 July 2021
2. Prepare the consolidation journal entries for 30 June 2022
3. Complete the consolidated worksheet for 30 June 2022
4. Prepare the consolidated financial statements at 30 June 2022