The company is principally in the retail drugstore business and its operations are within one reportable segment. At August 31,2013 there was 8,582 drugstore and other locations in 50 states, the District of Columbia, Guam, and Puerto Rico. Prescription sales were 62.9% of total sales for fiscal 2013 compared to 63.2% in 2012 and 64.7% in 2011.

Allowance for Doubtful Accounts

The provision for bad debt is based on both historical write-off percentages and specifically identified receivables. Activity in the allowance for doubtful accounts was as follows (In millions):

	2013	2012	2011
Balance at beginning of year	$99	$101	$104
Bad debt provision	$124	$107	$88
Write-offs	($69)	($109)	($91)
Balance at end of year	$154	$99	$101

Inventories

Inventories are valued on a lower of last-in, first-out (LIFO) cost or market basis. At August 31, 2013 and 2012, inventories would have been greater by $2.1 billion and $1.9 billion, respectively, if they had been valued on a lower of first-in, first-out (FIFO) cost or market basis. As a result of declining inventory levels, the fiscal 2013 and 2012 LIFO provisions were reduced by $194 million and $268 million of LIFO liquidation, respectively. Inventory includes product costs, inbound freight, warehousing costs, and vendor allowances not classified as a reduction of advertising expense.

3.Leases

The company owns 20.2% of its operating locations; the remaining locations are leased premises. Initial terms are typically 20 to 25 years, followed by additional terms containing renewal options at five-year intervals, and may include rent escalation clauses. The commencement date of all lease terms is the earlier of the date the company becomes legally obligated to make rent payments or the date the Company has to right to control the property. The Company recognizes rent expense on a straight-line basis over the term of the lease. In addition to minimum fixed rentals, some leases provide for contingent rentals based upon a portion of sales.

Minimum rental commitments at August 31, 2013, under all leases having an initial or remaining non-cancelable term of more than one year are shown below (in Millions):

	Capital Lease	Operatin Lease
2014	$19	$2,536
2015	$19	$2,514
2016	$18	$2,464
2017	$17	$2,389
2018	$15	$2,292
Later	$270	$23,507
Total Minimum lease Payments	$358	$35,702

The capital lease amoutn includes $155 million of imputed interest and executory costs. Total minimum lease payments have not been reduced by minimum sublease rentals of approximately $140 million on leases due in the future under non-cancelable subleases.

The Company remains secondarily liable on 26 assigned leases. The maiximum potential undiscounted future payments are $18 million at August 31, 2013. Lease option dates vary, with some extending to 2041.

WALGREEN CO. INFORMATION FROM CONSOLIDATED
STATEMENTS OF COMPREHENSIVE INCOME
For the Years Ended August 31,2013 and 2012 (in millions)
	2013	2012
Sales	$72,217	$71,633
Net Income	$2,450	$2,127

Required:

a. Using the consolidated balance sheets for Walgreen Co. for August 31,2013 and 2012, prepare a common-size balance sheet.

b. Which current asset is the most significant? Which noncurrent asset is the most significant? Are the relative proportions of current and noncurrent assets what you would expect for a drug store?

c. Analyze accounts recievable and allowance for doubtful accounts.

d. What inventory is used to value inventories? Has Walgreen experienced inflation or deflation? Explain your answer. Explain the reference in the inventory note to the LIFO liquidation and what this means with regard to net income reported.

e. Assess the level of debt and risk that Walgreen has by looking only at the balnce sheet.

f. Estimate the dollar amount of dividends Walgreens paid in 2013.

g. Does Walgreen use off-balance sheet fiancing? Explain your answer.

h. Evaluate the creidtworthiness of Walgreen based on the Balance sheet and the excerpts from the notes.

coralhyena380

Topic 2: Consolidation: Intra-grouptransactions

On 1 July 2015, Ping Pong Ltd acquired all the issued shares ofSing Song Ltd. At the date of acquisition, the shareholdersâ equityof Sing Song Ltd consisted of share capital $120,000; generalreserve $25,000 and retained earnings $55,000. The identifiable netassets of Sing Song Ltd were recorded at amounts equal to theirfair values, except for the following assets:

	Carrying amount	Fair value
	$	$
Land	100,000	130,000
Inventories	78,500	86,100
Machinery (cost $86,000)	52,000	56,000
Vehicles (cost $58,000)	47,000	53,000

The assets of Sing Song Ltd at acquisition date includedgoodwill recorded at $15,000 arising from a business combinationtransaction in 2011. As at the date of acquisition, the vehiclesand machinery were expected to have a further useful life of 6 and8 years respectively, with benefits to be received evenly overthose periods. Inventories on hand on 1 July 2015 was all sold by31 January 2016. The land owned at 1 July 2015 was sold inSeptember 2016 for $150,000. The machinery on hand at 1 July 2015was sold on 1 January 2018 for $38,000.

Adjustments for the differences between carrying amount and fairvalues of assets and liabilities on hand at acquisition date arerecognised on consolidation. When assets are sold or derecognised,any related valuation reserves are transferred to retainedearnings.

At 1 July 2015, Sing Song Ltd owned but had not recorded aninternally generated brand name, an identifiable asset included aspart of the business combination transaction. This brand name wasconsidered by Ping Pong Ltd to have a fair value of $29,000 and anindefinite useful life. An impairment test conducted with respectto the brand name on 30 June 2018 concluded that its recoverableamount at that date was $2,000 less than its carrying amount.

In June 2017, Sing Song Ltd paid a share dividend worth $20,000from the general reserve on hand at 1 July 2015.

The trial balances of both companies at 30 June 2018 showed thefollowing balances:

	Ping Pong Ltd		Sing Song Ltd
	Dr ($)	Cr ($)	Dr ($)	Cr ($)
Sales revenue		450,000		320,000
Dividend revenue		17,000		-
Other income		11,400		17,000
Proceeds on sale of equipment		18,000		-
Proceeds on sale of machinery		-		38,000
Cost of sales	210,000		192,550
Income tax expense	30,000		32,000
Depreciation and other expenses	39,000		36,000
Carrying amount of equipment sold	21,000		-
Carrying amount of machinery sold	-		30,500
Dividend paid	10,000		5,000
Dividend declared	20,000		12,000
Transfer to general reserve	10,000		5,000
Share capital		200,000		140,000
General reserve		35,000		10,000
Retained earnings (1 July 2017)		51,300		67,500
Accounts payable		69,500		36,000
Loan payable (due 30 June 2022)		25,000		15,000
Dividend payable		20,000		12,000
Provisions		12,500		9,300
Current tax liability		43,000		34,000
Deferred tax liability		11,800		5,000
Accumulated depreciation-vehicles		16,400		60,000
Accumulated depreciation-equipment		-		34,500
8%Debentures (matures 30 June 2021)		25,000		-
Cash	2,500		1,250
Receivables	27,000		13,000
Inventories	39,700		24,500
Other current assets	15,200		8,200
Deferred tax assets	7,500		3,500
Vehicles	88,000		158,000
Equipment	-		42,000
Land	140,000		180,000
Financial assets	68,000		14,800
Goodwill	28,000		15,000
Shares in Sing Song Ltd	250,000		-
Debentures in Ping Pong Ltd	-		25,000
	1,005,900	1,005,900	798,300	798,300

Additional information:

On 1 January 2018, Ping Pong Ltd sold an item of equipment toSing Song Ltd for $18,000. The equipment had a carrying amount atthe date of sale of $21,000. Both companies depreciate equipment at20% on a straight line basis.

On 1 May 2017, Sing Song Ltd sold a machine to Ping Pong Ltd for$7,800. The machine had a carrying amount of $7,000 at the date ofsale. Ping Pong Ltd recorded the machine as inventories. Theinventories item was sold to an external party in November 2017 for$8,200.

All interests on the 8% debentures has been paid and brought toaccount in the records of both companies.

During the 2017-2018 financial year, Ping Pong Ltd soldinventories to Sing Song Ltd for $75,000. The cost of theseinventories to Sing Song Ltd was $70,000. Of these inventories, 25%is still on hand at 30 June 2018.

The transfer to the general reserve recorded by Sing Song Ltd inthe current year was from retained earnings recorded at 1 July2015.

The tax rate is 30%.

Required:

Prepare an acquisition analysis.

Prepare the consolidation worksheet entries necessary to preparethe consolidated financial statements for the year ending 30 June2018 for the group comprising Ping Pong Ltd and Sing Song Ltd.

Note: you are not required to prepare the consolidationworksheet and the consolidated financial statements.

orchiddeer92

On 1 July 2017, Panda Ltd acquired all the issued shares ofSmarty Ltd. Panda Ltd paid $250,000 more than the equity itacquired in the fair value of Smarty Ltdâs net assets. At the dateof acquisition, the shareholderâs equity of S

On 1 July 2017, Panda Ltd acquired all the issued shares ofSmarty Ltd. Panda Ltd paid $250,000 more than the equity itacquired in the fair value of Smarty Ltdâs net assets. At the dateof acquisition, the shareholderâs equity of Smarty Ltd was asfollows.

$

Share capital

100,000

Retained earnings

175,000

Total

275,000

All the assets and liabilities of Smarty Ltd were recorded atamounts equal to their fair values at the acquisition date, exceptfor some assets detailed below.

Remaining useful life

Cost

Carrying amount

Fair value

$

Plant

5 years

180,000

90,000

120,000

Computer equipment

5 years

90,000

40,000

60,000

Required:

Prepare the acquisition analysis at 1 July 2017.
Prepare the consolidation worksheet entries for Panda Ltdâs groupat 1 July 2017.
Prepare the consolidation worksheet entries for Panda Ltdâs groupat 30 June 2018.

Question 1

Max. marks allocated

Acquisition analysis

3

Consolidation entries at 1 July 2017

6

Consolidation entries at 30 June 2018

10

Presentation

1

Total

20

Question 2 [35 marks]

Topic 2: Consolidation: Intra-group transactions

On 1 July 2015, Ping Pong Ltd acquired all the issued shares ofSing Song Ltd. At the date of acquisition, the shareholdersâ equityof Sing Song Ltd consisted of share capital $120,000; generalreserve $25,000 and retained earnings $55,000. The identifiable netassets of Sing Song Ltd were recorded at amounts equal to theirfair values, except for the following assets:

Carrying amount

Fair value

$

Land

100,000

130,000

Inventories

78,500

86,100

Machinery (cost $86,000)

52,000

56,000

Vehicles (cost $58,000)

47,000

53,000

The assets of Sing Song Ltd at acquisition date includedgoodwill recorded at $15,000 arising from a business combinationtransaction in 2011. As at the date of acquisition, the vehiclesand machinery were expected to have a further useful life of 6 and8 years respectively, with benefits to be received evenly overthose periods. Inventories on hand on 1 July 2015 was all sold by31 January 2016. The land owned at 1 July 2015 was sold inSeptember 2016 for $150,000. The machinery on hand at 1 July 2015was sold on 1 January 2018 for $38,000.

Adjustments for the differences between carrying amount and fairvalues of assets and liabilities on hand at acquisition date arerecognised on consolidation. When assets are sold or derecognised,any related valuation reserves are transferred to retainedearnings.

At 1 July 2015, Sing Song Ltd owned but had not recorded aninternally generated brand name, an identifiable asset included aspart of the business combination transaction. This brand name wasconsidered by Ping Pong Ltd to have a fair value of $29,000 and anindefinite useful life. An impairment test conducted with respectto the brand name on 30 June 2018 concluded that its recoverableamount at that date was $2,000 less than its carrying amount.

In June 2017, Sing Song Ltd paid a share dividend worth $20,000from the general reserve on hand at 1 July 2015.

The trial balances of both companies at 30 June 2018 showed thefollowing balances:

Ping Pong Ltd

Sing Song Ltd

Dr ($)

Cr ($)

Dr ($)

Cr ($)

Sales revenue

450,000

320,000

Dividend revenue

17,000

-

Other income

11,400

17,000

Proceeds on sale of equipment

18,000

-

Proceeds on sale of machinery

-

38,000

Cost of sales

210,000

192,550

Income tax expense

30,000

32,000

Depreciation and other expenses

39,000

36,000

Carrying amount of equipment sold

21,000

-

Carrying amount of machinery sold

-

30,500

Dividend paid

10,000

5,000

Dividend declared

20,000

12,000

Transfer to general reserve

10,000

5,000

Share capital

200,000

140,000

General reserve

35,000

10,000

Retained earnings (1 July 2017)

51,300

67,500

Accounts payable

69,500

36,000

Loan payable (due 30 June 2022)

25,000

15,000

Dividend payable

20,000

12,000

Provisions

12,500

9,300

Current tax liability

43,000

34,000

Deferred tax liability

11,800

5,000

Accumulated depreciation-vehicles

16,400

60,000

Accumulated depreciation-equipment

-

34,500

8%Debentures (matures 30 June 2021)

25,000

-

Cash

2,500

1,250

Receivables

27,000

13,000

Inventories

39,700

24,500

Other current assets

15,200

8,200

Deferred tax assets

7,500

3,500

Vehicles

88,000

158,000

Equipment

-

42,000

Land

140,000

180,000

Financial assets

68,000

14,800

Goodwill

28,000

15,000

Shares in Sing Song Ltd

250,000

-

Debentures in Ping Pong Ltd

-

25,000

1,005,900

798,300

Additional information:

On 1 January 2018, Ping Pong Ltd sold an item of equipment toSing Song Ltd for $18,000. The equipment had a carrying amount atthe date of sale of $21,000. Both companies depreciate equipment at20% on a straight line basis.
On 1 May 2017, Sing Song Ltd sold a machine to Ping Pong Ltd for$7,800. The machine had a carrying amount of $7,000 at the date ofsale. Ping Pong Ltd recorded the machine as inventories. Theinventories item was sold to an external party in November 2017 for$8,200.
All interests on the 8% debentures has been paid and brought toaccount in the records of both companies.
During the 2017-2018 financial year, Ping Pong Ltd sold inventoriesto Sing Song Ltd for $75,000. The cost of these inventories to SingSong Ltd was $70,000. Of these inventories, 25% is still on hand at30 June 2018.
The transfer to the general reserve recorded by Sing Song Ltd inthe current year was from retained earnings recorded at 1 July2015.
The tax rate is 30%.

Required:

Prepare an acquisition analysis.
Prepare the consolidation worksheet entries necessary to preparethe consolidated financial statements for the year ending 30 June2018 for the group comprising Ping Pong Ltd and Sing Song Ltd.

Note: you are not required to prepare the consolidationworksheet and the consolidated financial statements.

marty Ltd was as follows.

	$
Share capital	100,000
Retained earnings	175,000
Total	275,000

All the assets and liabilities of Smarty Ltd were recorded atamounts equal to their fair values at the acquisition date, exceptfor some assets detailed below.

	Remaining useful life	Cost	Carrying amount	Fair value
		$	$	$
Plant	5 years	180,000	90,000	120,000
Computer equipment	5 years	90,000	40,000	60,000

Required:

Prepare the acquisition analysis at 1 July 2017.

Prepare the consolidation worksheet entries for Panda Ltdâsgroup at 1 July 2017.

Prepare the consolidation worksheet entries for Panda Ltdâsgroup at 30 June 2018.

Question 1	Max. marks allocated
Acquisition analysis	3
Consolidation entries at 1 July 2017	6
Consolidation entries at 30 June 2018	10
Presentation	1
Total	20

Question 2 [35 marks]

Topic 2: Consolidation: Intra-grouptransactions

On 1 July 2015, Ping Pong Ltd acquired all the issued shares ofSing Song Ltd. At the date of acquisition, the shareholdersâ equityof Sing Song Ltd consisted of share capital $120,000; generalreserve $25,000 and retained earnings $55,000. The identifiable netassets of Sing Song Ltd were recorded at amounts equal to theirfair values, except for the following assets:

	Carrying amount	Fair value
	$	$
Land	100,000	130,000
Inventories	78,500	86,100
Machinery (cost $86,000)	52,000	56,000
Vehicles (cost $58,000)	47,000	53,000

The assets of Sing Song Ltd at acquisition date includedgoodwill recorded at $15,000 arising from a business combinationtransaction in 2011. As at the date of acquisition, the vehiclesand machinery were expected to have a further useful life of 6 and8 years respectively, with benefits to be received evenly overthose periods. Inventories on hand on 1 July 2015 was all sold by31 January 2016. The land owned at 1 July 2015 was sold inSeptember 2016 for $150,000. The machinery on hand at 1 July 2015was sold on 1 January 2018 for $38,000.

Adjustments for the differences between carrying amount and fairvalues of assets and liabilities on hand at acquisition date arerecognised on consolidation. When assets are sold or derecognised,any related valuation reserves are transferred to retainedearnings.

At 1 July 2015, Sing Song Ltd owned but had not recorded aninternally generated brand name, an identifiable asset included aspart of the business combination transaction. This brand name wasconsidered by Ping Pong Ltd to have a fair value of $29,000 and anindefinite useful life. An impairment test conducted with respectto the brand name on 30 June 2018 concluded that its recoverableamount at that date was $2,000 less than its carrying amount.

In June 2017, Sing Song Ltd paid a share dividend worth $20,000from the general reserve on hand at 1 July 2015.

The trial balances of both companies at 30 June 2018 showed thefollowing balances:

	Ping Pong Ltd		Sing Song Ltd
	Dr ($)	Cr ($)	Dr ($)	Cr ($)
Sales revenue		450,000		320,000
Dividend revenue		17,000		-
Other income		11,400		17,000
Proceeds on sale of equipment		18,000		-
Proceeds on sale of machinery		-		38,000
Cost of sales	210,000		192,550
Income tax expense	30,000		32,000
Depreciation and other expenses	39,000		36,000
Carrying amount of equipment sold	21,000		-
Carrying amount of machinery sold	-		30,500
Dividend paid	10,000		5,000
Dividend declared	20,000		12,000
Transfer to general reserve	10,000		5,000
Share capital		200,000		140,000
General reserve		35,000		10,000
Retained earnings (1 July 2017)		51,300		67,500
Accounts payable		69,500		36,000
Loan payable (due 30 June 2022)		25,000		15,000
Dividend payable		20,000		12,000
Provisions		12,500		9,300
Current tax liability		43,000		34,000
Deferred tax liability		11,800		5,000
Accumulated depreciation-vehicles		16,400		60,000
Accumulated depreciation-equipment		-		34,500
8%Debentures (matures 30 June 2021)		25,000		-
Cash	2,500		1,250
Receivables	27,000		13,000
Inventories	39,700		24,500
Other current assets	15,200		8,200
Deferred tax assets	7,500		3,500
Vehicles	88,000		158,000
Equipment	-		42,000
Land	140,000		180,000
Financial assets	68,000		14,800
Goodwill	28,000		15,000
Shares in Sing Song Ltd	250,000		-
Debentures in Ping Pong Ltd	-		25,000
	1,005,900	1,005,900	798,300	798,300

Additional information:

On 1 January 2018, Ping Pong Ltd sold an item of equipment toSing Song Ltd for $18,000. The equipment had a carrying amount atthe date of sale of $21,000. Both companies depreciate equipment at20% on a straight line basis.

On 1 May 2017, Sing Song Ltd sold a machine to Ping Pong Ltd for$7,800. The machine had a carrying amount of $7,000 at the date ofsale. Ping Pong Ltd recorded the machine as inventories. Theinventories item was sold to an external party in November 2017 for$8,200.

All interests on the 8% debentures has been paid and brought toaccount in the records of both companies.

During the 2017-2018 financial year, Ping Pong Ltd soldinventories to Sing Song Ltd for $75,000. The cost of theseinventories to Sing Song Ltd was $70,000. Of these inventories, 25%is still on hand at 30 June 2018.

The transfer to the general reserve recorded by Sing Song Ltd inthe current year was from retained earnings recorded at 1 July2015.

The tax rate is 30%.

Required:

Prepare an acquisition analysis.

Prepare the consolidation worksheet entries necessary to preparethe consolidated financial statements for the year ending 30 June2018 for the group comprising Ping Pong Ltd and Sing Song Ltd.

Note: you are not required to prepare the consolidationworksheet and the consolidated financial statements.

lilachorse999

ACCT 1A Lecture Notes - Lecture 7: Contingent Liability, Financial Statement

Document Summary

Get access

Related Documents

ACCT 1A Lecture Notes - Lecture 18: Contingent Liability, Working Capital, Financial Statement

ACCT 1A Lecture Notes - Lecture 6: Accrual, Deferred Income, Accounts Payable

ACCT 1A Lecture Notes - Lecture 27: Pension, Life Insurance

Related Questions