Purchase Solution

Ratios: Find the inventories, fixed assets, and common stock

Not what you're looking for?

Ask Custom Question

Balance sheet analysis

Complete the balance sheet and sales information using the following financial data:
debt to assets ratio= 50%
Current ratio= 1.8x
Total assets turnover=1.5x
Days sales outstanding=36.5 days
Gross profit margin on sales(sales-cost of goods sold)/sales=25%
Inventory turnover ratio=5x
Calculation is based on a 365 day year
Total assets= $300,000
Long term debt= 60,000
Retained earnings= 97,500

Find the inventories, fixed assets, and common stock portions of the balance sheet.

Purchase this Solution

Solution Summary

Your solution is in excel. Each ratio is shown, including numerator and denominator. Cells that you have to "figure out" are in yellow. The formulas used to solve for yellow cells are in the cell contents (click in cell to see formula revealed). This is a template for similar work.

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Learning Lean

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

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Basics of corporate finance

These questions will test you on your knowledge of finance.