Calculate the following cash conversion cycle ratios based on the financial statements usingMicrosoftExcel:

• Average inventory
• Inventory turnover rate
• Production cycle
• Average account receivable
• Account receivable turnover
• Average collection cycle

PLEASE SHOW ALL WORK INCLUDING ALL FIGURES AND FORMULAS....

Thank you.

5/22/2017 Document 10K 1 lowesform10k.htm FORM 10K UNITED STATES SECURITIES AND EXCHANGE COMMISSION Washington, D.C. 20549 FORM 10K (Mark One) ANNUAL REPORT PURSUANT TO SECTION 13 OR 15(d) OF THE SECURITIES EXCHANGE ACT OF 1934 For the fiscal year ended February 3, 2017 or TRANSITION REPORT PURSUANT TO SECTION 13 OR 15(d) OF THE SECURITIES EXCHANGE ACT OF 1934 For the transition period from ________ to _________ Commission file number 17898 LOWE'S COMPANIES, INC. (Exact name of registrant as specified in its charter) NORTH CAROLINA 560578072 (State or other jurisdiction of incorporation or organization) (I.R.S. Employer Identification No.) 1000 Lowe's Blvd., Mooresville, NC 28117 (Address of principal executive offices) (Zip Code) Registrant's telephone number, including area code 7047581000 Securities registered pursuant to Section 12(b) of the Act: Title of each class Name of each exchange on which registered Common Stock, $0.50 Par Value New York Stock Exchange (NYSE) Indicate by check mark if the registrant is a wellknown seasoned issuer, as defined in Rule 405 of the Securities Act. Yes No Indicate by check mark if the registrant is not required to file reports pursuant to Section 13 or Section 15(d) of the Exchange Act. Yes No Indicate by check mark whether the registrant (1) has filed all reports required to be filed by Section 13 or 15(d) of the Securities Exchange Act of 1934 during the preceding 12 months (or for such shorter period that the registrant was required to file such reports), and (2) has been subject to such filing requirements for the past 90 days. Yes No Indicate by check mark whether the registrant has submitted electronically and posted on its corporate Web site, if any, every Interactive Data File required to be submitted and posted pursuant to Rule 405 of Regulation ST (232.405 of this chapter) during the preceding 12 months (or for such shorter period that the registrant was required to submit and post such files). Yes No Indicate by check mark if disclosure of delinquent filers pursuant to Item 405 of Regulation SK (229.405 of this chapter) is not contained herein, and will not be contained, to the best of registrant's knowledge, in definitive proxy or information statements incorporated by reference in Part III of this Form 10K or any amendment to this Form 10K. Indicate by check mark whether the registrant is a large accelerated filer, an accelerated filer, a nonaccelerated filer, or a smaller reporting company. See the definitions of \"large accelerated filer,\" \"accelerated filer,\" and \"smaller reporting company\" in Rule 12b2 of the Exchange Act. (Check one): Large accelerated filer Accelerated filer Nonaccelerated filer Smaller reporting company Indicate by check mark whether the registrant is a shell company (as defined in Rule 12b2 of the Exchange Act). Yes No https://www.sec.gov/Archives/edgar/data/60667/000006066717000076/lowesform10k.htm 1/118 5/22/2017 Document As of July 29, 2016, the last business day of the Company's most recent second quarter, the aggregate market value of the registrant's common stock held by nonaffiliates of the registrant was $72.4 billion based on the closing sale price as reported on the New York Stock Exchange. Indicate the number of shares outstanding of each of the registrant's classes of common stock, as of the latest practicable date. CLASS OUTSTANDING AT 3/31/2017 Common Stock, $0.50 par value 857,332,918 DOCUMENTS INCORPORATED BY REFERENCE Document Portions of the Proxy Statement for Lowe's 2017 Annual Meeting of Shareholders https://www.sec.gov/Archives/edgar/data/60667/000006066717000076/lowesform10k.htm Parts Into Which Incorporated Part III 2/118 5/22/2017 Document LOWE'S COMPANIES, INC. TABLE OF CONTENTS Page No. PART I Item 1. Business Item 1A. Risk Factors 9 Item 1B. Unresolved Staff Comments 14 Item 2. Properties 14 Item 3. Legal Proceedings 14 Item 4. Mine Safety Disclosures 15 Executive Officers and Certain Significant Employees of the Registrant 16 PART II 4 Item 5. Market for Registrant's Common Equity, Related Stockholder Matters and Issuer Purchases of Equity Securities 17 Item 6. Selected Financial Data 18 Item 7. Management's Discussion and Analysis of Financial Condition and Results of Operations 19 Item 7A. Quantitative and Qualitative Disclosures About Market Risk 34 Item 8. Financial Statements and Supplementary Data 36 Item 9. Changes in and Disagreements with Accountants on Accounting and Financial Disclosure 69 Item 9A. Controls and Procedures 69 Item 9B. Other Information 69 PART III Item 10. Directors, Executive Officers and Corporate Governance 70 Item 11. Executive Compensation 70 Item 12. Security Ownership of Certain Beneficial Owners and Management and Related Stockholder Matters 70 Item 13. Certain Relationships and Related Transactions, and Director Independence 70 Item 14. Principal Accountant Fees and Services 70 PART IV Item 15. Exhibits and Financial Statement Schedules Item 16. Form 10K Summary Signatures https://www.sec.gov/Archives/edgar/data/60667/000006066717000076/lowesform10k.htm 71 79 80 3/118 5/22/2017 Document Table of Contents Part I Item 1 Business General Information Lowe's Companies, Inc. and subsidiaries (the Company or Lowe's) is a Fortune 50 company and the world's second largest home improvement retailer. As of February 3, 2017, Lowe's operated 2,129 home improvement and hardware stores, representing approximately 213 million square feet of retail selling space. These operations were comprised of 1,820 stores located across 50 U.S. states, including 87 Orchard Supply Hardware (Orchard) stores, as well as 299 stores in Canada, and 10 stores in Mexico. During 2016, Lowe's acquired RONA inc. (RONA) which owns and operates 245 stores in Canada as of February 3, 2017, as well as services approximately 236 dealerowned stores. The RONA stores represent various complementary store formats operating under various banners. Lowe's was incorporated in North Carolina in 1952 and has been publicly held since 1961. The Company's common stock is listed on the New York Stock Exchange ticker symbol \"LOW\". See Item 6, \"Selected Financial Data\