ACCT 610 9041 Financial Accounting (2178)

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. Provide 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:

Audio-enhanced 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: submit in appropriate LEO assignment folder

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

Audio-enhanced Power Point presentation

Word document summarizing your analysis and justification for recommending the company hold, buy, or sell.