Present your solution on this tab: Use only formulas on this tab. 1 Download financial statement...

  

Transcribed Image Text:

Present your solution on this tab: Use only formulas on this tab. 1 Download financial statement data onto tabs 3 and 4. 2 Populate data template on tab 1. 3 Calculate the values requested. Check the "instructions" tab for guidance. Use formulas to populate this template from the data on tabs 3 and 4. Net Sales Cost of Sales Net Income Data Template Receivables Merchandise inventories Total current assets Total assets Total shareholders' equity Total Current Liabilities Long-Term Debt Long-Term Lease Liabilities. Deferred Income Taxes Other Liabilities January 29, 2022 24,460 (14,956) 1,430 297 4,383 6,758 17,590 3,621 5,416 3,295 3,098 983 1,177 Calculate these values from the data in the template: Total liabilities Working capital Average age of inventory (AAI) Average collection period (ACP) Current ratio Debt/equity ratio Financial leverage multiplier (FLM) Net profit margin Total asset turnover Return on assets Return on equity C 13,969 1,342 Present your solution on this tab: Use only formulas on this tab. 1 Download financial statement data onto tabs 3 and 4. 2 Populate data template on tab 1. 3 Calculate the values requested. Check the "instructions" tab for guidance. Use formulas to populate this template from the data on tabs 3 and 4. Net Sales Cost of Sales Net Income Data Template Receivables Merchandise inventories Total current assets Total assets Total shareholders' equity Total Current Liabilities Long-Term Debt Long-Term Lease Liabilities. Deferred Income Taxes Other Liabilities January 29, 2022 24,460 (14,956) 1,430 297 4,383 6,758 17,590 3,621 5,416 3,295 3,098 983 1,177 Calculate these values from the data in the template: Total liabilities Working capital Average age of inventory (AAI) Average collection period (ACP) Current ratio Debt/equity ratio Financial leverage multiplier (FLM) Net profit margin Total asset turnover Return on assets Return on equity C 13,969 1,342

Answer rating: 100% (QA)

Apologies for the confusion Based on the given data lets calculate the values requested Total liabil... View the full answer