For the Chapter 4 problems, show all work in an Excel book, labeling each item by the problem number. be sure to use appropriate formulas to solve each exercise or problem.

Quick-E Inc.s current assets consist of cash of $5 million, account receivables of $27 million, inventory of $37 million, and it has current liabilities of $48 million. Calculate Quick-Es current ratio and quick ratio.

Deb Co. has interest-bearing debt of $122 million, noninterest-bearing debt of $33 million, and equity of $76 million. Calculate Deb Co.s debt-to-assets, debt-to-equity, and long-term debt-to-capital ratios.

IOU Inc. has EBIT of $58,000, depreciation and amortization of $12,000, interest expenses of $21,000, principal repayments of $17,000, and a tax rate of 35%. Calculate IOU Inc.s interest coverage ratio and debt service coverage ratio.