Acct 370 Excel Project

 Acct 370 Excel Project

                Click Link Below To Buy:

http://hwcampus.com/shop/acct-370-excel-project/

Contact Us:

Hwcoursehelp@gmail.com

PART 1:

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.