Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is an individual homework assignment. Use Excel to complete the following questions. Submission and pledge of your work and answers is required on Canvas.
This is an individual homework assignment. Use Excel to complete the following questions. Submission and pledge of your work and answers is required on Canvas. You do not need to read the case for this assignment. The income statements and balance sheets are from the case Costco Wholesale in 2018 and the companies financial reports online. Well discuss the results in class. What were Costcos Revenues, Operating Expenses, and Net Income in 2000, 2005, 2014, 2015, 2016, 2017, and 2018 respectively? What were BJs Revenues, Operating Expenses, and Net Income in 2016, 2017, and 2018 respectively? Use three graphs to compare Costco and BJs Revenues, operating expenses, and net income in 2016, 2017, and 2018. Calculate the following ratios for Costco in 2016, 2017, and 2018. Show the calculation process for each ratio in Excel. Current Ratio Total debt Ratio Inventory turnover Receivables turnover Profit margin Calculate the following ratios for BJs in 2017 and 2018. Show the calculation process for each ratio in Excel. Current Ratio Total debt Ratio Inventory turnover Receivables turnover Profit margin (2016, 2017 and 2018) Use five graphs to compare Costco and BJs Ratios from Questions 4 & 5 in 2017 and 2018. Which company performed better financially, Costco or BJs? Support your argument with evidence
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started