Question: How to solve this, Excel formulas needed and how to answer the last question LL 1 A B C D E 1 Store 1 Store

How to solve this, Excel formulas needed and how to answer the last question

How to solve this, Excel formulas needed and how to answer the

LL 1 A B C D E 1 Store 1 Store 2 Store 3 Store 4 2 3 Revenue 10,107,787 90,374,000 43,630,200 36,100,000 4 Cost of Goods Sold 6,571,238 71,494,000 31,836,500 28,081,000 5 Gross Profit 3,536,549 18,880,000 11,793,700 8,019,000 6 SG&A and Other Expenses 2,988,929 17,602,000 10,659,100 8,538,000 7 Operating Income 547,620 1,278,000 1,134,600 (519,000) 8 Net Income 342,612 602,000 516,700 (1,040,000) 9 10 Total Assets 4,292,075 23,476,000 15,073,600 12,053,000 11 Total Liabilities 1,300,770 19,510,000 11,384,500 12,032,000 12 Total Equity 2,991,305 3,966,000 3,689,100 21,000 13 14 Gross Margin Percentage 15 SG&A % of Sales 16 17 Profit Margin 18 Asset Turnover 19 Financial Leverage/Asset Multiplier 20 21 ROA 22 ROE 23 24 List two conclusions you might draw using the financial ratios. 25

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!