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