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 oYour financial ratios must be in Excel file format. a.Your ratio should have at least 4 decimal points. b.Your file name must be “CS1-first name-last name”

FIN 601: Financial Management and Markets Instructor: Dr. Jinsuk Yang Case Study #1

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:
oYour financial ratios must be in Excel file format.
a.Your ratio should have at least 4 decimal points.
b.Your file name must be “CS1-first name-last name”
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.

oFailure 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.