Problem:
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.