Data Analytics case study

Instruction:

Your CFO wants to invest the reserved funds in common stock with good returns. She

asked you, the senior staff accountant, to analyze the following two stocks she has in

mind, and recommend which stock she should invest in with the fund. These two

companies are: Home Depot and Lowes.

Copy the data to your spreadsheet.

5. Create common-size statements for both companies (with the same years).2023 and 2022

6. Do a few ratio analyses with the financial data you have on both companies. The

ratio analyses should cover the four categories indicated in the textbook (p.13 or

Chapter 1 PowerPoint # 21)

7. Compare the results and comment on the performance of these two companies

with your common-size statements and ratio analyses results.

8. Use charts, graphs and any visualization tools to illustrate your analyses.

9. Provide your recommendation to your CFO.

10. Use the six-steps case analysis format you have learnt in Chapter One to write

the case report.

Balance Sheet All numbers in thousands Show: Income Statement Balance Sheet Cash Flow Income Statement All numbers in thousands Ralanre Sheet Nll numharc in thnuc candc Income Statement All numbers in thousands