PROJECT INFORMATION

You have been given financial statements for Amazon and Walmart (Income Statement, Balance Sheet, and Statement of Cash Flows). For this project, you will use the information in those statements to compute the ratios requested on the Ratios Tab. Current year information is Fiscal or Calendar year ended 2018 for both companies.

SUGGESTED STEPS FOR COMPLETION OF THE PROJECT:

Determine what amounts are needed to calculate the ratios requested. For example you need Current Assets and Current Liabilities to compute the Current Ratio. Enter the names of the items needed in the boxes in column A for each of the ratios. See Ratios Tab, column A for Current Ratio.

Next, use the cell reference function and any other necessary formulas to enter the numbers for each of the items for each of the companies in the boxes under the requested ratios. Again see Ratios Tab Columns C and E for the Current Ratio for Walmart and for Amazon.

Next use the numbers you have entered to calculate the ratios requested. Again see the Ratios Tab Columns C and E for Current Ratio for Walmart and for Amazon.

ROUND ALL RATIO AMOUNTS TO 3 DECIMAL PLACES

Repeat the steps for each of the ratios listed on the Ratio Tab

Assume all sales were on credit where necessary.

COGS can also be called Cost of Sales

Income Tax Expense can also be called the Provision for Income Taxes

Remember to consider the Statement of Cash Flows when trying to determine cash spent for any particular items.

Final step - So that we can see your use of formulas you must use the following steps to display your formulas for the ratios on the Ratios Formula Tab. Copy all of the Ratios information from the Ratios Tab to the Ratios formulas tab. Highlight the entire ratios information area and press the "ctrl" key and the "~" key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed on the Ratio Formulas Tab page and the numbers displayed on the Ratios Tab.

POSSIBLE 5 POINTS EXTRA CREDIT

For an opportunity to earn 5 points extra credit, please read the posted article WalMart has already lost its battle with Amazon. Prepare a 1 1 page (max) double spaced paper with your opinion on the statements in the article. For the potential to earn the full 5 points you must refer to the ratios that you calculated in the excel portion of the project. You must mention specific ratios and how they support or do not support your position/opinion on the article. Your submission will also be graded for correct spelling, sentence structure, and grammar. Your paper must be prepared in Word (no other programs accepted).

You must submit your Word document to the correct submission link on the Canvas site before 5pm on the due date.

Each student must submit an ORIGINAL excel file that is their own work. While students are encouraged to work together, each student must process and format his/her own set of excel worksheet. Duplicate submissions (format, not numbers) will result in the students receiving a 0 for the assignment. And possibly other consequesces as stated inthe University Integrity policies.

Submissions will NOT be accepted via email attachment. Submission to other than the correct link on Canvas will result in a 10% point deduction.

NO LATE SUBMISSIONS WILL BE ACCEPTED