Compute the percentage change in working capital

Assignment Help Financial Accounting
Reference no: EM132493448

The following are the consolidated statement of earnings and the balance sheet of Home Depot, Inc and Subsidiaries.

THE HOME DEPOT, INC. AND SUBSIDIARIES

CONSOLIDATED STATEMENTS OF EARNINGS Fiscal Year Ended(1)amounts in millions, except per share data

                                                January 31,2016                 February 1, 2015                        February 2, 2014

NET SALES                                    $66,193                            $71,293                                    $77,363

Cost of Sales                                       43,756                          47,297                                     51,348

GROSS PROFIT                                    22,437                            23,996                                       26,015

Operating Expenses:

Selling, General and Administrative            15,900                                17,843                                    17,044

Depreciation and Amortization                   1,692                                1,770                                       1,695

Total Operating Expenses                        17,592                                19,613                                        18,739

OPERATING INCOME                                 4,845                                     4,383                                       7,276

Interest and Other (Income) Expense:

Interest and Investment Income                 (20)                                          (20)                                            (83)

Interest Expense                                       663                                            612                                         689

Other                                                    (159)                                            159                                          -

Interest and Other, net                                  802                                         751                                    606

EARNINGS BEFORE PROVISION FOR INCOME TAXES  4,043                                  3,632                                    6,670

Provision for Income Taxes                        1,353                                             1,261                                  2,406

NET EARNINGS                                       $2,690                                            $2,371                                 $4,264

Weighted Average Common Shares            1,539                                             1,602                                       1,688

BASIC EARNINGS PER SHARE                      $1.75                                              $1.68                                    $2.53

Diluted Weighted Average Common Shares  1,551                                                 1,610                                   1,549

DILUTED EARNINGS PER SHARE                 $1.73                                                 $1.47                                     $2.75

(1) Fiscal years ended January 31, 2016, February 1, 2015 and February 2, 2014 include 52 weeks.

THE HOME DEPOT, INC. AND SUBSIDIARIES

CONSOLIDATED BALANCE SHEETSamounts in millions, except share and per share data

                                                                     January  31, 2016                      February 1, 2015

ASSETS Current Assets:

Cash and Cash Equivalents                                   $1,279                     $1,226

Receivables, net                                                981 988

Merchandise Inventories                                    10,258                           10,738

Other Current Assets                                         1,321                             1,195

Total Current Assets                                         13,839                               14,147

Property and Equipment, at cost                          37,433                              36,619

Less Accumulated Depreciation and Amortization   11,700                                  10,228

Net Property and Equipment                              25,733                                 26,391

Goodwill                                                        1,175                                     1,150

Other Assets                                                     229                                        404

Total Assets                                                    $40,976                                     $42,092

LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities:

Short-Term Debt                                                  $390                                   $570

Accounts Payable                                              5,423                                     4,809

Accrued Salaries and Related Expenses                1,259                                      1,116

Sales Taxes Payable                                             361                                      317

Deferred Revenue                                               1,155                                    1,156

Income Taxes Payable                                         103                                              277

Current Installments of Long-Term Debt                    1,013                                 1,760

Other Accrued Expenses                                        1,588                                1,640

Total Current Liabilities                                         11,292                                   11,645

Long-Term Debt, excluding current installments            8,648                                   9,652

Other Long-Term Liabilities                                        2,125                                     2,179

Deferred Income Taxes                                             1,155                                        1,156

Total Liabilities                                                         23,220                                       24,632

Point 1: STOCKHOLDERS' EQUITY Common Stock, par value $0.05; authorized: 10 billion shares; issued: 1.754 billion shares at January 31, 2016 and 1.733 billion shares at February 1, 2015; outstanding: 1.484 billion shares at January 31, 2016 and 1.537 billion shares at February 1, 2015 77 76 Paid-In Capital 6,298 6,037 Retained Earnings 11,606 11,818 Accumulated Other Comprehensive Income 360 80 Treasury Stock, at cost, 270 million shares at January 31, 2016 and 196 million shares at February 1, 2015 (585) (391)Total Stockholders' Equity 17,756 17,460 Total Liabilities and Stockholders' Equity$40,976 $42,092

Selected information as on February 2, 2014:

Working capital$2,668

Cash balance$1,280

Total assets$44,329

Stockholders' equity$17,679

Assume that you are the credit manager of a medium-size supplier of building materials and related products. Home Depot wants to make credit purchases from your company, with payment due in 60 days.

Instructions:

Question a-1. Compute the current ratio for the fiscal years ending January 31, 2016, and February 1, 2015.

Question a-2. Compute the quick ratio for the fiscal years ending January 31, 2016, and February 1, 2015.

Question a-3. Compute the amount of working capital for the fiscal years ending January 31, 2016, and February 1, 2015.

Question a-4. Compute the percentage change in working capital from the prior year for the fiscal years ending January 31, 2016, and February 1, 2015.

Question a-5. Compute the percentage change in cash and cash equivalents from the prior year for the fiscal years ending January 31, 2016, and February 1, 2015.

Reference no: EM132493448

Questions Cloud

What is the npv of the system : For the next four years, the savings will be $20,000 per year. Assuming a 12% discount rate, what is the NPV of the system?
Great customer service skills and mediocre technical skills : Based on your learning this week, consider rules, policies, and procedures. Technicians are often eager to just get started on a project. If you were working on
Budgetary Planning - Prepare cash budget for a month : Budgetary Planning: Prepare cash budget for a month. Prepare a cash budget for the month ended July 31, 2017, and indicate how much money
Relationship between population increases and climate change : What is the relationship between population increases and climate change? Do you think fertility control is an effective strategy to halt climate change?
Compute the percentage change in working capital : Compute the percentage change in working capital from the prior year for the fiscal years ending January 31, 2016, and February 1, 2015.
Why did you initially purchase the product : Think of something you purchased that you no longer use because it became outdated or obsolete. Why did you initially purchase the product?
How christian worldview impact your view of business : How does your Christian faith or worldview impact your view of business and customers? Discuss an area that interests you and consider how you might learn more.
Technique in detail highlighting pros and cons of technique : For these 3 basic approaches in Integration testing: Top down, bottom up and sandwich. Explain each technique in detail highlighting pros and cons
Draw the corresponding expression tree : 1) Convert the prefix expression -/ab*+bcd into infix expression and then draw the corresponding expression tree.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd