For this component of the project, you are asked to analysis of financial ratios for Lowe's, both through time and relative to financial ratios for Home Depot, using both tables and graphs.
To complete the through-time analysis, Please see attached financial data for Lowes. Calculate the financial ratios for each year and present these ratios in a table format... Discuss each ratio with respect to how it has adjusted across time and explain what conclusions you generate from each.
To complete the relative analysis, use the attached financial data for competing firm - Home Depot. Calculate the financial ratios for each company and present these ratios in a table format.. Discuss each ratio with respect to how the Lowe's ratio differs from the competing firm and what conclusions you generate from each. Note: If you compare your company's data with more than one competing firm, present each firm's ratios plus an average ratio of the competing firm collectively. The Financial Ratios Analysis Example, located in the Resources, using Home Depot data provides guidance on how to proceed. A summary of the basic data needed for this project has been provided.
Do only the ratios listed in the Ratios tab. Five: For computing the Break-even point, compute it in number of tickets. A ticket is the amount of an average sale, whether the sale is for one item or twenty items. (This will be asked for later). The average number of tickets and the average revenue per ticket is already computed for you in the Project Data tab. To get the variable cost per ticket, consider the cost of goods sold to be the only variable cost. Compute the ratio of cost of goods sold to sales.
Attachment:- Assignment Files.rar