Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

1. Compute the average total depreciable life of assets in use for Wal-Mart at t

ID: 2448804 • Letter: 1

Question

1. Compute the average total depreciable life of assets in use for Wal-Mart at the end of Jan 31, 2015.

2.Compute the average age to date of depreciable assets in use for Wal-Mart at the end of Jan 31, 2015.

3. Did Wal-Mart report a liability for its capital lease on January 31, 2015 balance sheet? By how much?

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

As of January 31, 2014 (Amounts in millions) ASSETS Current assets: 2015 Cash and cash equivalents Receivables, net Inventories Prepaid expenses and other Current assets of discontinued operations 9,135S 6,677 44,858 1,909 460 61,185 6,778 45,141 2,224 Total current assets 63,278 Property and equipment Property and equipment Less accumulated depreciation 177,395 (63,115) 114,280 173,089 (57,725) 115,364 Property and equipment, net Property under capital leases: 5,239 (2,864) 2,375 5,589 (3,046) 2,543 Property under capital leases Les s accumulated amortization Property under capital leases, net Goodwill Other assets and deferred charges Total assets 19,510 6,149 204,751 18,102 5,671 203,706 S LIABILITIES, REDEEMABLE NONCONTROLLING INTEREST, AND EQUITY Current liabilities: 7,670 37,415 18,793 Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Obligations under capital leases due within one year Current liabilities of discontinued operations 1,592S 38,410 19,152 1,021 4,810 287 4,103 89 Total current liabilities 65,272 69,345 Long-term debt Long-term obligations under capital leases Deferred income taxes and other 41,086 2,606 8,805 41,771 2,788 Redeemable poncontrolling interest Commitments and contingencies ul Common stock Capital in excess of par value Retained earnings 323 2,462 85,777 323 2,362 76,566

Explanation / Answer

1. Average total depreciable life of assets in use

Average total depreciable life of assets in use = Average acquisition cost of assets / Depreciation expense

From Note 1, we can get the acquisition cost of assets. In this, cost of land and Construction in progress shalll not be considered as they are not depreciable.

Average acquisition cost of assets = ($97,496 + $45,044 + $2,807 + $95,488 + $42,971 + $2,785) / 2 = $143,295.50 million

Depreciation expense for the year 2015 = $9.10 billion = $9,100 million

Average total depreciable life of assets in use = $143,295.50 / $9,100 = 15.75 years

2. Average age to date of depreciable assets in use

Average age to date of depreciable assets in use = Average accumulated depreciation / Depreciation expense

Average accumulated depreciation = ($63,115 + $57,725) / 2 = $60,420 million

Depreciation expense for the year 2015 = $9.10 billion = $9,100 million

Average age to date of depreciable assets in use = $60,420 / $9,100 = 6.64 years

3. Remaining useful life of depreciable assets in use

Remaining useful life of depreciable assets in use = Average Net cost of assets / Depreciation expense

Average net cost of assets = Average acquisition of assets - Average accumulated depreciation

= $143,295.50 million - $60,420 million = $82,875.50 million

Remaining useful life of depreciable assets in use = $82,875.50 / $9,100 = 9.11 years

4.

The company is reporting deferred tax liability of $5,972 million under Note 9. Taxes. Deferred tax liabilty shows tht Net cost of the Property and Equipments as per tax law is higher than the Net cost of assets as per financial accounting.

Difference in the net cost of assets = Timing difference on account of depreciation

Timing difference on account of depreciation = Deferred tax liability / Tax rate = $5,972 / 0.35 = $2090.20 million

Net cost of property, plant, and equipment as per tax laws = Net cost as per financial books + $2090.20 million

= $114,280 + $2090.20 = $116,370.20 million

5.

Amount of depreciation expense recognized for tax purposes

= Depreciation expense as per financial accounts - $2090.20 million

= $9100 million - $2090.20 million = $7009.80 million