Instruction
Assignment Summary:
In this assignment you will analyze the financial ratios for Home Depot using an Excel program called the Financial Strategic Assessment (FSA). The program was designed by to help students explore the internal environment of a firm and in particular begin to see the inter-relationships among different financial variables. It will assist you in performing an internal environment analysis of the liquidity, solvency, operating efficiency and capital structure, of a public corporation. Based on this analysis, you will answer a series of multiple choice questions about the internal environment for this company.
Learning Objectives:
Understand (or review) the basic structure of financial statements.
Understand how to access public corporation financial data.
Understand the specific ratio analyses involved in liquidity and solvency ratios, operating
efficiency ratios and capital structure ratios.
Understand (or review) concepts of economic value creation, breakeven analysis and risk.
Understand how to access risk data for a public corporation.
Understand the basic drivers underlying economic profit and the value of the firm.
What you Need:
1. Download the FSA Start.xls file from the course website. The password for the FSA worksheet is shark. You are free to use the program both now and in the future, but not to distribute the program. Please keep it password protected.
2. Download the latest Home Depot Annual Report from S.E.C. EDGAR database of corporation filings. This annual report will include their financial statements. Use the Item 8 for your assignment.
-- password to open file is "shark"