INCOME STATEMENT Net sales Membership & other income Total revenues Cost of sales Gross Margin Selling,...

Transcribed Image Text:

INCOME STATEMENT Net sales Membership & other income Total revenues Cost of sales Gross Margin Selling, general & administrative expenses Operating Income BALANCE SHEET Assets Cash & cash equivalents Receivables, net Inventories Other current assets Total current assets Fixed/ Long Term Assets Total Assets Liabilities Retailer 1 Common Size Financials % $ Millions 605881 5408 611289 463721 147586 12714 20428 8625 7933 56576 2521 75655 167542 243197 Retailer 2 $ Millions 237710 4580 242290 212586 29704 21590 8114 15234 2285 16651 1709 35879 33115 68994 Common Size Financials % Retailer 3 $ Millions 107588 1532 109120 82229 26891 23043 3848 2229 1695 13499 423 17846 35489 53335 Common Size Financials % Liabilities Total current liabilities Long Term Liabilities Total Liabilities Total Equity Total Liabilities + Equity Complete the Common Size Financial Statements for all three retailers. (See Ch 2 p 69-71). Calculate % to 1 decimal point. Example 23.1% Calculate the following Financial Ratios for all three retailers (See Apendix to Ch 2 p 82-85 ) Return on Equity Inventory Turnover Total Debt Ratio GM % The three retailers depicted above are Costco (Wholesale Club) Target and Walmart (Mass Discounters) 92198 67245 159443 83754 243197 6254 37682 43936 25058 68994 19500 22603 42103 11232 53335 The three retailers depicted above are Costco (Wholesale Club) Target and Walmart (Mass Discounters) Identify Which Retailer is Retailer 1, Retailer 2 and Retailer 3 Retailer #1 is Retailer #2 is Retailer #3 is Briefly explain how you reached these conclusions based on these financial calculations & and any other analysis you completed. Retailer 2 is Retailer 1 is III Retailer 1 is Retailer 3 is INCOME STATEMENT Net sales Membership & other income Total revenues Cost of sales Gross Margin Selling, general & administrative expenses Operating Income BALANCE SHEET Assets Cash & cash equivalents Receivables, net Inventories Other current assets Total current assets Fixed/ Long Term Assets Total Assets Liabilities Retailer 1 Common Size Financials % $ Millions 605881 5408 611289 463721 147586 12714 20428 8625 7933 56576 2521 75655 167542 243197 Retailer 2 $ Millions 237710 4580 242290 212586 29704 21590 8114 15234 2285 16651 1709 35879 33115 68994 Common Size Financials % Retailer 3 $ Millions 107588 1532 109120 82229 26891 23043 3848 2229 1695 13499 423 17846 35489 53335 Common Size Financials % Liabilities Total current liabilities Long Term Liabilities Total Liabilities Total Equity Total Liabilities + Equity Complete the Common Size Financial Statements for all three retailers. (See Ch 2 p 69-71). Calculate % to 1 decimal point. Example 23.1% Calculate the following Financial Ratios for all three retailers (See Apendix to Ch 2 p 82-85 ) Return on Equity Inventory Turnover Total Debt Ratio GM % The three retailers depicted above are Costco (Wholesale Club) Target and Walmart (Mass Discounters) 92198 67245 159443 83754 243197 6254 37682 43936 25058 68994 19500 22603 42103 11232 53335 The three retailers depicted above are Costco (Wholesale Club) Target and Walmart (Mass Discounters) Identify Which Retailer is Retailer 1, Retailer 2 and Retailer 3 Retailer #1 is Retailer #2 is Retailer #3 is Briefly explain how you reached these conclusions based on these financial calculations & and any other analysis you completed. Retailer 2 is Retailer 1 is III Retailer 1 is Retailer 3 is

Answer rating: 100% (QA)

To calculate Common Size Financial Statements divide each line item by Total Assets and multiply by ... View the full answer