Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please provide the solutions in bold. I already got the infromation fro the 10K report just need a few easy questions completed. Please show all

Please provide the solutions in bold. I already got the infromation fro the 10K report just need a few easy questions completed. Please show all work/calculations

Problem 1:

Refer to the balance sheet and note 11 (Commitments) of Wal-Mart in Appendix.

Required:

Did Wal-Mart report a liability for its operating lease on January 31, 2015 balance sheet? By how much? Yes 2606

Did Wal-Mart report a liability for its capital lease on January 31, 2015 balance sheet? By how much? Yes the operating lease was

Did Wal-Mart report an asset for its operating lease on January 31, 2015 balance sheet? By how much?

Did Wal-Mart report an asset for its capital lease on January 31, 2015 balance sheet? By how much?

Assuming an interest rate of 5%, compute the present value of the operating lease commitments on January 31, 2015. Show all calculations for credit.

Assuming that Wal-Mart was required to capitalize its operating lease, calculate the companys 2015s Liabilities to Assets ratio and Long-term Debt Ratio.

Appendix

Wal-Mart Stores, Inc.

Consolidated Balance Sheets

As of January 31,

(Amounts in millions)

2015

2014

ASSETS

Current assets:

Cash and cash equivalents

$

9,135

$

7,281

Receivables, net

6,778

6,677

Inventories

45,141

44,858

Prepaid expenses and other

2,224

1,909

Current assets of discontinued operations

460

Total current assets

63,278

61,185

Property and equipment:

Property and equipment

177,395

173,089

Less accumulated depreciation

(63,115

)

(57,725

)

Property and equipment, net

114,280

115,364

Property under capital leases:

Property under capital leases

5,239

5,589

Less accumulated amortization

(2,864

)

(3,046

)

Property under capital leases, net

2,375

2,543

Goodwill

18,102

19,510

Other assets and deferred charges

5,671

6,149

Total assets

$

203,706

$

204,751

LIABILITIES, REDEEMABLE NONCONTROLLING INTEREST, AND EQUITY

Current liabilities:

Short-term borrowings

$

1,592

$

7,670

Accounts payable

38,410

37,415

Accrued liabilities

19,152

18,793

Accrued income taxes

1,021

966

Long-term debt due within one year

4,810

4,103

Obligations under capital leases due within one year

287

309

Current liabilities of discontinued operations

89

Total current liabilities

65,272

69,345

Long-term debt

41,086

41,771

Long-term obligations under capital leases

2,606

2,788

Deferred income taxes and other

8,805

8,017

Redeemable noncontrolling interest

1,491

Commitments and contingencies

Equity:

Common stock

323

323

Capital in excess of par value

2,462

2,362

Retained earnings

85,777

76,566

Accumulated other comprehensive income (loss)

(7,168

)

(2,996

)

Total Walmart shareholders' equity

81,394

76,255

Nonredeemable noncontrolling interest

4,543

5,084

Total equity

85,937

81,339

Total liabilities, redeemable noncontrolling interest, and equity

$

203,706

$

204,751

See accompanying notes.

Note 1. Summary of Significant Accounting Policies

......

Property and Equipment

Property and equipment are stated at cost. Gains or losses on disposition are recognized as earned or incurred. Costs of major improvements are capitalized, while costs of normal repairs and maintenance are charged to expense as incurred. The following table summarizes the Company's property and equipment balances and includes the estimated useful lives that are generally used to depreciate the assets on a straight-line basis:

Fiscal Years Ended January 31,

(Amounts in millions)

Estimated Useful Lives

2015

2014

Land

N/A

$

26,261

$

26,184

Buildings and improvements

3-40 years

97,496

95,488

Fixtures and equipment

2-30 years

45,044

42,971

Transportation equipment

3-15 years

2,807

2,785

Construction in progress

N/A

5,787

5,661

Property and equipment

$

177,395

$

173,089

Accumulated depreciation

(63,115

)

(57,725

)

Property and equipment, net

$

114,280

$

115,364

Leasehold improvements are depreciated over the shorter of the estimated useful life of the asset or the remaining expected lease term. Depreciation expense for property and equipment, including amortization of property under capital leases, for fiscal 2015, 2014 and 2013 was $9.1 billion, $8.8 billion and $8.4 billion, respectively. Interest costs capitalized on construction projects were $59 million, $78 million and $74 million in fiscal 2015, 2014 and 2013, respectively.

Note 9. Taxes

Income from Continuing Operations

The components of income from continuing operations before income taxes are as follows:

Fiscal Years Ended January 31,

(Amounts in millions)

2015

2014

2013

U.S.

$

18,610

$

19,412

$

19,352

Non-U.S.

6,189

5,244

6,310

Total income from continuing operations before income taxes

$

24,799

$

24,656

$

25,662

A summary of the provision for income taxes is as follows:

Fiscal Years Ended January 31,

(Amounts in millions)

2015

2014

2013

Current:

U.S. federal

$

6,165

$

6,377

$

5,611

U.S. state and local

810

719

622

International

1,529

1,523

1,743

Total current tax provision

8,504

8,619

7,976

Deferred:

U.S. federal

(387

)

(72

)

38

U.S. state and local

(55

)

37

(8

)

International

(77

)

(479

)

(48

)

Total deferred tax expense (benefit)

(519

)

(514

)

(18

)

Total provision for income taxes

$

7,985

$

8,105

$

7,958

Deferred Taxes

The significant components of the Company's deferred tax account balances are as follows:

January 31,

(Amounts in millions)

2015

2014

Deferred tax assets:

Loss and tax credit carryforwards

$

3,255

$

3,566

Accrued liabilities

3,395

2,986

Share-based compensation

184

126

Other

1,119

1,573

Total deferred tax assets

7,953

8,251

Valuation allowances

(1,504

)

(1,801

)

Deferred tax assets, net of valuation allowance

6,449

6,450

Deferred tax liabilities:

Property and equipment

5,972

6,295

Inventories

1,825

1,641

Other

1,618

1,827

Total deferred tax liabilities

9,415

9,763

Net deferred tax liabilities

$

2,966

$

3,313

The deferred taxes are classified as follows in the Company's Consolidated Balance Sheets:

January 31,

(Amounts in millions)

2015

2014

Balance Sheet classification:

Assets:

Prepaid expenses and other

$

728

$

822

Other assets and deferred charges

1,033

1,151

Asset subtotals

1,761

1,973

Liabilities:

Accrued liabilities

56

176

Deferred income taxes and other

4,671

5,110

Liability subtotals

4,727

5,286

Net deferred tax liabilities

$

2,966

$

3,313

Note 11. Commitments

The Company has long-term leases for stores and equipment. Rentals (including amounts applicable to taxes, insurance, maintenance, other operating expenses and contingent rentals) under operating leases and other short-term rental arrangements were $2.8 billion in both fiscal 2015 and 2014 and $2.6 billion in fiscal 2013.

Aggregate minimum annual rentals at January 31, 2015, under non-cancelable leases are as follows:

(Amounts in millions)

Fiscal Year

Operating Leases

Capital Leases

2016

$

1,759

$

504

2017

1,615

476

2018

1,482

444

2019

1,354

408

2020

1,236

370

Thereafter

10,464

3,252

Total minimum rentals

$

17,910

$

5,454

Less estimated executory costs

49

Net minimum lease payments

5,405

Less imputed interest

2,512

Present value of minimum lease payments

$

2,893

Certain of the Company's leases provide for the payment of contingent rentals based on a percentage of sales. Such contingent rentals were not material for fiscal 2015, 2014 and 2013. Substantially all of the Company's store leases have renewal options, some of which may trigger an escalation in rentals.

The Company has future lease commitments for land and buildings for approximately 282 future locations. These lease commitments have lease terms ranging from 1 to 30 years and provide for certain minimum rentals. If executed, payments under operating leases would increase by $58 million for fiscal 2016, based on current cost estimates.

In connection with certain long-term debt issuances, the Company could be liable for early termination payments if certain unlikely events were to occur. At January 31, 2015, the aggregate termination payment would have been $64 million. The arrangement pursuant to which this payment could be made will expire in fiscal 2019.

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

Step: 3

blur-text-image

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

Auditors Guide To Information Systems Auditing

Authors: Richard E. Cascarino

1st Edition

0470009896, 978-0470009895

More Books

Students also viewed these Accounting questions

Question

Define Conventional Marketing.

Answered: 1 week ago