Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Step Instructions Start Excel. Download and open the workbook named: Keown_Martin_Petty_Problem_4-6_Start. Important note: All calculations must be shown using cell references. Do NOT enter absolute
Step Instructions Start Excel. Download and open the workbook named: Keown_Martin_Petty_Problem_4-6_Start. Important note: All calculations must be shown using cell references. Do NOT enter absolute numbers in the cells. 2 In cell B36, calculate the current ratio. 3 In cell B37, calculate the debt ratio 4 In cell B38, calculate the times interest earned. 5 In cell B39, calculate the average collection period. In cell B40, calculate the inventory turnover 7 In cell B41, calculate the foxed-assets turnover 8 In cell B42, calculate the total assets turnover 9 In cell B43, calculate the gross profit margin. 10 In cell B44, calculate the operating profit margin Step Instructions 11 In cel B45, caculate the aperating retum an assets. 12 In cel B46, calculate the return on equity. 13 Save the workbook. Clase the workbook and then exit Excel Submit the workbaok as directed Company are given below. Calculate the following ratios: current ratio, debt rotio, times inted, average collection period, inventory turnover, fixed asset turnoer, total asscts turnover, gross profit margin operting profit margin, operatingensses, return on equity. DATA Balance Sheet: (000) Cash Accounts receivable Inventories $500 2,000 1,000 3,500 4,500 Current assets Net fixed assets Total assets Accounts payable Accrued expenses Short-term notes payable 1,100 Current liabilities Long-term debt Owners' equity 300 2,000 2,000 4,000 Total liabilities and owners' equity Income Statement: (000) Soles (oll credit) Cost of goods sold $8,000 3,300 $4,700 3,000 1,700 36 1,333 Gross profit Operating expenses includes 500 deprecia! Interest expense Income taxes(40%) Opersting profit Earnings before taxe:s Net income 533 SOLUTION Colcuate the following ratios Current ratio Debt ratio Times interest earned Awerage collection period Inventory turnover Fixed asset turnover Total assets turnoer Gross profit morgin Operstin Operoting return on assets Return on equity g profit margin
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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