Home Depot Accounts Receivable and Payable Periods

Need help or steps to calculate Home Depot Accounts receivable and Accounts payable periods in excel spreadsheet for company's last 2 years have no idea how to locate this info on 10-K and what steps to create spreadsheet to get results.

Need help understanding this week assignment
Have to calculate Excel spreadsheet for Accounts receivables period and Accounts payable period from at least the last two years(10-K) annual report for Home Depot.
Do an analysis based on my calculations, for company's working capital by making recommendations for financial decisions, ways to improve operating capital, and what financial impact on the organizations working capital situation.

© SolutionLibrary Inc. solutionlibary.com 9836dcf9d7 https://solutionlibrary.com/business/finance/home-depot-accounts-receivable-and-payable-periods-7g0s

Solution Preview

...(51,885) (47,150)
Accounts Payable, ending 5,732 4,822
Merchandise Inventories, beginning 12,822 11,731
Purchases during the year 50,261 46,240 ...