Instructions:
• The Case Study 1 (CS1) is due by 11:00 pm CST, October 25, 2020
• To complete the CS1, you must download the Excel file: Case_Study_1_Costco_Format.
o Module 1 > Module 1 Assignments > Case Study 1
• Total scores for CS1 are 20 points. And, you must submit it through Blackboard to earn credits.
• Any late submission will not be accepted.
• Please read FAQs on the last page of the instruction before you post a thread in the Blackboard forum.
• Please follow the steps listed below.
1. Download the “Case_Study_1_Costco_Format”. And, calculate key financial ratios in the “Ratios” spreadsheet for all years presented (2019, 2018, and 2017).
o You can compute the ratios by using the Excel cells or a calculator.
Submission Guidelines:
o Your financial ratios must be in Excel file format.
a. Your ratio should have at least .
b. Your file name must be “
c. No space between words (don’t forget put the hyphen “ – ” between words)
d. You must save the file as “Save as type: Excel Workbook (.xlsx)”, not “CSV” or any other
formats.
o Failure to comply with the “submission guidelines” will result in penalty: - 2 points. FAQ:
• More ratios in the lecture videos?
What you are seeing from the lecture videos (with Example) has more ratios than CS1. So, please use
“Case_Study_1_Costco_Format” to complete the assignment.
• Where is the solution?
The solution will be available in the “Module 1 Assignments” folder once all the grades are posted