• CASE STUDY QUESTION
• Perform the ratio calculation
• All calculation must be done using excel formula. please include the excel formula for each question

i Case 1 Assignment (4) (1) Home Insert Page Layout Formulas Data Review View Tell m Arial - 12 - A- A Wrap Text Accounting Paste BI U-T - A. Merge & Center $ % > Conditional Format Cell Formatting as Table Styles E30 =+H11/L11 A B C G H I J K L M 23 Instruction: 24 Under the Formula column (column C), put in the formula as specified in the textbook for each ratio 25 Under the Calculation column (column E), use Excel formula to do the calculation according to the formula. Any typed-in numbers will not receive mark 26 Please see the example provided in Current Ratio. Each answer must specify "times" or %, etc. Missing description will miss marks 27 28 Formula: Calculation: 29 Liquidity Ratios 30 Current Assets $ 1.23 Times 31 Current Ratio: Current Liabilities 32 33 34 Quick Ratio: 35 36 37 Cash Ratio: 38 39 40 Net working capital ratio: 41 42 43 Interval Measure 44 45 46 Solvency Ratios 47 48 Total Debt Ratio 49 50 51 Debt-equity ration CaseArial - 12 - A- A- Wrap Text Accounting Paste B I U - - A E Merge & Center $ - % 2 Conditional Format Formatting as Table Sty EBO X fic =+H11/L11 A B C D H K L 45 46 Solvency Ratios 47 48 Total Debt Ratio 49 50 51 Debt-equity ratio: 52 53 54 Equity multiplier: 55 56 57 Long-term debt ratio: 58 59 60 Times interest earned: 61 62 63 Cash coverage: 64 65 66 Assets Turnovr Ratios 67 68 Inventory turnover: 69 70 71 Days' sales in inventory: 72 73 Case 1 + Select destination and press ENTER or choose Paste14 Arial Wrap Text Accounting Paste B I U T - G - A - E Merge & Center $ % Conditional Format Cell Formatting as Table Styles E30