Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using EXCEL, compute common-size income statements for all three fiscal years. In common-size income statements, net sales are 100 percent and every other number is

Using EXCEL, compute common-size income statements for all three fiscal years. In common-size income statements, net sales are 100 percent and every other number is a percentage of net sales. however, the common-size financial statements you prepare with EXCEL will likely have many more lines). You may have to slightly reformat your company's Income Statement if it does not include a subtotal for Gross Margin and Operating Income.(Note every number on your common-size income statements for all three years should have a percentage calculation).

Using the common-sized income statements, identify the significant trends (generally indicated by significant percentage changes in accounts over the three-year period).

What was the gross margin (gross profit)andthe gross margin percentage each of the three years presented in your common-size income statements? (Round the gross margin percentage to two decimal places).

If the gross margin percentage changed over the three-year period, what caused the change? (Hint: Changes in either sales or cost of goods sold reveal what caused the change in the gross margin percentages).

What was the percentage return on sales for each of the three fiscal years? What do the return on sales and gross margin percentage ratios indicate about your company?

and the company are Walgreen and Walmart and Starbuck plz if you can help me with that will be amazing and it for the last threee years

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Managerial Accounting For Dummies

Authors: Mark P Holtzman, Karen Schoenebeck

1st Edition

1118116429, 978-1118116425

More Books

Students also viewed these Accounting questions

Question

Why should a U.S.-based manager be concerned with globalization?

Answered: 1 week ago

Question

Explain the characteristics of a good system of control

Answered: 1 week ago

Question

State the importance of control

Answered: 1 week ago

Question

What are the functions of top management?

Answered: 1 week ago

Question

Bring out the limitations of planning.

Answered: 1 week ago