Question: 5 9 ( Use cells B 8 to C 5 2 from the given information to complete this quesuon. ) 6 0 6 1 Gross
Use cells to C from the given information to complete this quesuon.
Gross margin percentage
Current ratio use the Excel ROUND function rounded to two decimal places
Acidtest ratio use the Excel ROUND function rounded to two decimal places
Accounts receivable turnover use the Excel ROUND function rounded to two decimal places
Days' sales uncollected use the Excel ROUNDUP function rounded to the nearest whole day
Inventory turnover ratio use the Excel ROUND function rounded to two decimal places
Days' sales in inventory use the Excel ROUNDUP function rounded to the nearest whole day
Debttoequity ratio use the Excel ROUND function rounded to two decimal places
Times interest earned use the Excel ROUND function feunded to two decimal places
Book value per share use the Excel ROUND function rounded to two decimal places
Earnings per share use the Excel ROUND function rounded to two decimal places
Dividend payout ratio use the Excel ROUND function rounded to three decimal places
Dividend yield ratio use the Excel ROUND function rounded to three decimal places
Priceearnings ratio use the Excel ROUND function rounded to two decimal places
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
