Purchase Solution

Computation of Ratios with formulas in excel

Not what you're looking for?

Ask Custom Question

Liquidity ratios: Flying Penguins Corp. has total current assets of $11,845,175, current liabilities of $5,311,020, and a quick ratio of 0.89. What is its level of inventory?

4.6 Leverage ratios: Breckenridge Ski Company has total assets of $422,235,811 and a debt ratio of 29.5 percent. Calculate the company's debt-to-equity ratio and the equity multiplier.

4.8 DuPont equation: The Rangoon Timber Company has the following relationships:

Sales/Total assets = 2.23; ROA = 9.69%; ROE = 16.4%

What are Rangoon's profit margin and debt ratio?

4.18 Profitability ratios: Cisco Systems has total assets of $35.594 billion, total debt of $9.678 billion, and net sales of $22.045 billion. Their net profit margin for the year was 20 percent, while the operating profit margin was 30 percent. What are Cisco's net income, EBIT ROA, ROA, and ROE?

Purchase this Solution

Solution Summary

The solution computes leverage, profitability, Liquidity ratios for Flying Penguins Corp,Breckenridge Ski Company,Rangoon Timber Company, Cisco Systems.

Purchase this Solution


Free BrainMass Quizzes
IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.