Acct 370 Excel Project
Click Link Below To Buy:
Excel Project: Part V Instructions
Common Sized Statements and Trend Analysis on WALMART Stores Inc.
The tenth tab in your Financial Statement Analysis Template must be labeled Common Sized Balance SheetsThe eleventh tab in your Financial Statement Analysis Template must be labeled Common Sized Income StatementsThe twelfth tab in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Balance SheetsThe thirteenth tab in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Income StatementsInclude the latest three years for the common sized (vertical analysis) and horizontal analysis in Tabs 10–13.
*PLEASE WORK OFF OF ATTACHED EXCEL SPREADSHEET. When you open the document, you will see that there are already 9 tabs. Follow the instructions above. You will need to add 4 more tabs labeled appropriately with the above titles (see instructions). Please save the work and send it back to me.
PART 2: - Use WORD to complete this part
COMPARITIVE ANALYSIS REPORT. - WALMART
Examine common sized financial statements and ratios for the company you selected for the Excel project and two of its competitors. Write a 1000-word report in current APA format. Include the following in your report:
Compare and contrast the selected company, its competitors, and industry averages
Identify the selected company’s strengths and weaknesses and examine the implications for financial statement analysis and future projections.
Compute ROA and ROCE and examine the selected company’s financial leverage in light of its competitors and the industry average.
*The two competitive companies are TARGET and COSTCO.
*Attached is an excel worksheet if you need information.