Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions