Purchase Solution

Profit margins: What is return on equity given various ratios and amounts?

Not what you're looking for?

Ask Custom Question

To maintain a profit margin of 4% and a sales-to-assets ratio of 3, what is the ROA, if the debt-equity ratio is 1.0, interest payments and taxes are each $10,000, and EBIT is $40,000. What is the return on equity?

Using Excel use math and finance functions so calulations can be seen in background.

Purchase this Solution

Solution Summary

In Excel, the solution is clearly detailed for ease of understanding. The returns on equity given various ratios and amounts for profit margins are examined.

Solution Preview

See attached Excel file

profit margin = income / Sales = 4%
Sales / Asset = 3
ROA ...

Purchase this Solution


Free BrainMass Quizzes
Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Basics of corporate finance

These questions will test you on your knowledge of finance.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.