In addition to the written memo, please provide your calculated historical 1997-2001 financial ratios for Lowe’s as well as a forecast for Lowe’s for 2002-2006.
Within the written memo, be sure to well address the following questions:
- What do the financial ratios in case Exhibit 7 tell you about the operating performance of Home Depot? What additional information do the different ratios provide? Complete and compare a similar analysis for Lowe’s using the Excel Template provided – Lowe’s Financial Ratios.
- Who deserves the “management of the year” award in the retail-building-supply industry? Provide a detailed explanation including support for your position.
- Assumptions drive the financial forecasting models like that of Home Depot in Exhibit 8. By putting the assumptions all at the top of the model, the analyst can also easily alter the assumptions and measure the impact. What do you think of Galeotafiore’s forecast for Home Depot? Are there any “red flags” in Galeotafiore’s work?
4. Prepare a forecast for Lowe’s using the Excel Template provided – Lowe’s Forecast. Articulate and explain your choice of key assumptions within the memo. Draw upon the case dialogue about future growth opportunities and financial forecast for Lowes, as well as overall economic, demographic or sector/industry trends evidenced in the exhibits.