Assignment
In this group project, you will consider investing in one of two companies (mentioned below) and write a paper on the positives and negatives you assessed when evaluating and comparing these two companies for a potential investment of your $10,000. You will need to perform a ratio analysis using Excel, the fundamentals of ratio analysis are discussed in the recording below.
The two companies that you need to evaluate and compare
o Home Depot
o Lowe's
Write the ratio analysis. Make sure to include the following:
o Part A: For each company analyze the ratios for the current year and the prior year and group them into either negative or positive findings. Make sure to include a discussion as to why you group them as negative or positive!
o Part B: Which company would you rather invest in and why?
o Part C: Pick one ratio with a big difference between the companies and discuss what might be driving this difference.
o Part D: Provide one recommendation for each company to improve one of the ratios that you've calculated. The improvement should be implementable, it is not sufficient to suggest something like "improve the debt to equity ratio by improving debt."
Format your assignment according to the following formatting requirements:
o The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
o The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
o Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.