Reference no: EM133612516

Case: For your CFFA computations, the values for each of the key components and subcomponents for each of the 10 quarters also need to be computed. For example, for CFFA from Operations, you will need to compute Operating Cash Flow (OCF), Net Capital Spending (NCS), and Changes in Net Working Capital (dNWC) for each of the 10 quarters. Then, for each of those components, the values for the corresponding subcomponents need to be computed as well. For example, for OCF, you will need to compute EBIT, Depreciation, and Taxes for each of the 10 quarters. Same goes for everything else. Similarly, CFFA from method 2 (stakeholders) needs to be computed.

All of these items need to be computed in a single Excel Worksheet, which should be named "CFFAs".

Compute the following 5 financial ratios -as in Chapter3- for each of the 10 quarters: Profit Margin (PM), Return on Assets (ROA), Return on Equity (ROE), Debt-Equity Ratio, and Total Asset Turnover Ratio (TATR). The numerator and denominator items need to be computed separately for each ratio. For each of the financial ratios, use the ratio values only to do bar charts.
All of these ratios and bar charts need to be on a single Excel Worksheet, which should be named "Ratios."

a brief analysis of the industry to which Home Depot belongs. Touch upon economics, marketing, and other relevant topics pertaining to the industry. (Write in Excel Workbook Under Industry Worksheet)
a brief write-up of the company focusing on Management issues. (Write in Excel Workbook Under Industry Worksheet)