Question:
Financial Statement Analysis Project
Instructions
Financial Statement Analysis Project:
Assessment Goal:
Assess the students' ability to interpret and analyze financial statements, and make a presentation to the boss and colleagues.
Scenario:
You graduated Summa Cum Laude with a MS in Accounting and Financial Management from a state university. Your role is to be a financial analyst for a large brokerage firm. Your boss (professor) asks you to prepare a financial analysis for a retail company. Your analysis will be part of a company-wide analysis of the retail business sector in the US. You will present your analyses to your boss and colleagues.
Steps to Completion:
Select any U.S. corporation that is listed on the NYSE in the retail sector. Click Edgar to search for the SEC filings of your chosen retail corporation. Download and review the SEC Form 10-K for the most recent year.
Perform:
· Horizontal and vertical financial statement analysis in Excel (using formulas)
· Ratio analysis in Excel (using formulas)
Prepare:
· PPT presentation for your boss and colleagues
o Include a recommendation to either hold, sell, or buy more stock from the corporation you chose to analyze
Deliverables:
· SEC Form 10-K used for the analysis
o Highlight figures on the Form 10-K that you used in your analyses
· 1 Excel file with 3 tabs:
o Horizontal analysis
o Vertical analysis
o Ratio analysis
§ Note: all computations must be computed via an Excel formula
· Power Point presentation
· 1 page Word document summarizing your analysis and justification for recommending the company hold, buy, or sell.