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.
amounts in million US
February 3, 2008 February 1, 2009
Accounts Payable, beginning 7,356 5,732
Purchases during the year 50,261 46,240
This solution shows step-by-step calculations in an Excel sheet to determine the total of accounts payable, accounts receivable and purchases during the year.