Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Walgreen Co. and Subsidiaries The following excerpts are from the 2013 Walgreen Co. Form 10-K: CONSOLIDATED BALANCE SHEETS Walgreen Co. and Subsidiaries at August 31,

Walgreen Co. and Subsidiaries

The following excerpts are from the 2013 Walgreen Co. Form 10-K:

CONSOLIDATED BALANCE SHEETS

Walgreen Co. and Subsidiaries at August 31, 2013 and 2012

(in millions, except shares and per share amounts)

2013

2012

Assets

Current Assets

Cash and cash equivalents

$ 2,106

$ 1,297

Accounts receivable, net

2,632

2,167

Inventories

6,852

7,036

Other current assets

284

260

Total Current Assets

11,874

10,760

Noncurrent Assets

Property and equipment, at cost, less accumulated depreciation and amortization

12,138

12,038

Equity investment in Alliance Boots

2,410

2,161

Alliance Boots call option

6,261

6,140

Goodwill

839

866

Other noncurrent assets

1,959

1,497

Total Noncurrent Assets

23,607

22,702

Total Assets

$ 35,481

$ 33,462

Liabilities and Shareholders' Equity

Current Liabilities

Short-term borrowings

$570

$ 1,319

Trade accounts payable

4,635

4,384

Accrued expenses and other liabilities

3,577

3,019

Income taxes

101

Total Current Liabilities

8,883

8,722

NonCurrent Liabilities

Long-term debt

4,477

4,073

Deferred income taxes

600

545

Other noncurrent liabilities

2,067

1,886

Total Noncurrent Liabilities

7,144

6,504

Commitments and Contingencies (see Note)

Shareholders' Equity

Preferred stock, S.0625 par value; authorized

32 million shares; none issued

Common stock, $.078125 par value; authorized 3.2 billion shares;

issued 1,028,180,150 shares in 2013 and 2012

80

80

Paid-in capital

1,074

936

Employee stock loan receivable

(11)

(19)

Retained earnings

21,523

20,156

Accumulated other comprehensive (loss) income

(98)

68

Treasury stock at cost, 81,584,572 shares in 2013 and 84,124,816 shares in 2012

(3,114)

(2,985)

Total Shareholders Equity

19,454

18,236

Total Liabilities and Shareholders Equity

$ 35,481

$ 33,462

Notes to Consolidated Financial Statements

1. Summary of Major Accounting Policies

Description of Business

The Company is principally in the retail drugstore business and its operations are within one reportable segment. At August 31, 2013 there were 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

S 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 the 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

Operating 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

S 358

$ 35,702

The capital lease amount 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 maximum 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

S 2,450

S 2,127

Extracted from 10-K filings for Walgreen Co. 2013. Obtained from U.S. Securities and Exchange Commission. www.sec.gov.

(g) Does Walgreen use offbalance sheet financing? Explain your answer.

(h) Evaluate the creditworthiness of Walgreen based on the balance sheet and the excerpts from the notes.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Ray H. Garrison, Alan Webb, Theresa Libby

12th Canadian Edition

1260193276, 978-1260193275

More Books

Students explore these related Accounting questions

Question

Explain the need for a general journal.

Answered: 3 weeks ago