Purchase Solution

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

Not what you're looking for?

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.

##### 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"

##### Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media