Question

In: Finance

Consider the following financial data for J. White Industries: Total assets turnover: 1.8 Gross profit margin...

Consider the following financial data for J. White Industries:

Total assets turnover: 1.8
Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 29%
Total liabilities-to-assets ratio: 45%
Quick ratio: 1.05
Days sales outstanding (based on 365-day year): 33 days
Inventory turnover ratio: 5.0

The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

Open spreadsheet

Complete the balance sheet and sales information in the table that follows for J. White Industries. Do not round intermediate calculations. Round your answers to the nearest whole dollar.

Partial Income Statement
Information
Sales $  
Cost of goods sold $  

Balance Sheet

Cash $   Accounts payable $  
Accounts receivable $   Long-term debt $  50,000
Inventories $   Common stock $  
Fixed assets $   Retained earnings $  100,000
Total assets $  400,000 Total liabilities and equity $  

Check My Work

Reset Problem

Solutions

Expert Solution

jeff jeffy answered 2 months ago
Next > < Previous

Related Solutions

Balance Sheet Analysis Consider the following financial data for J. White Industries: Total assets turnover: 1.2...
Balance Sheet Analysis Consider the following financial data for J. White Industries: Total assets turnover: 1.2 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 26% Total liabilities-to-assets ratio: 55% Quick ratio: 0.85 Days sales outstanding (based on 365-day year): 38 days Inventory turnover ratio: 5.0 Open Excel spreadsheet and perform the required analysis to answer the questions below. Complete the balance sheet and sales information in the table that follows for J. White Industries. Do not...
AA had a profit margin of 8%, a total assets turnover of 1.5 and an equity...
AA had a profit margin of 8%, a total assets turnover of 1.5 and an equity multiplier of 1.8. 1. Calculate company's ROE . 2. What can you say about this ROE if ROE's Industry Average is 15%
Excel Online Structured Activity: Balance Sheet Analysis Consider the following financial data for J. White Industries:...
Excel Online Structured Activity: Balance Sheet Analysis Consider the following financial data for J. White Industries: Total assets turnover: 2.6 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 21% Total liabilities-to-assets ratio: 50% Quick ratio: 0.90 Days sales outstanding (based on 365-day year): 38 days Inventory turnover ratio: 6.0 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet...
Dp Jones had a profit margin of 0.05,total assets turnover of 1.7, and an equity multipler...
Dp Jones had a profit margin of 0.05,total assets turnover of 1.7, and an equity multipler of 3.0. Calculate DP Jones return on common equity
Using the financial data below calculate the following ratios: 1) Gross Profit Margin; 2) Net Profit...
Using the financial data below calculate the following ratios: 1) Gross Profit Margin; 2) Net Profit Margin; 3) Return on Assets; 4) Days Sales Outstanding; 5) Quick Ratio. For EACH of these five ratios do the following: 1) calculate the value and 2) interpret the value in about one sentence.  TO RECEIVE ANY CREDIT YOU MUST SHOW YOUR WORK, WITHIN THE PROVIDED WORK SPACE. FINAL ANSWERS ONLY WILL NOT CUT IT!         Balance Sheet         ASSETS                                                                                               LIABILITIES                     Cash: $1,160,000                                                                          Current Liabilities: $173,000 A/R: 335,000                                                                                 Non-current...
Calculating Gross Profit Margin and Inventory Turnover The following table presents sales revenue, cost of goods...
Calculating Gross Profit Margin and Inventory Turnover The following table presents sales revenue, cost of goods sold, and inventory amounts for three retailers of fine jewelry, Tiffany & Co., Zale Corporation, and Blue Nile, Inc. (an Internet retailer). ($ millions) 2013 2012 Tiffany & Co. Revenues $4,585 $4,017 Cost of goods sold 1,776 1,674 Inventory 2,489 2,347 Zale Corporation Revenues $1,973 $1,910 Cost of goods sold 989 949 Inventory 823 769 Blue Nile, Inc. Revenues $505 $443 Cost of goods...
Calculating Gross Profit Margin and Inventory Turnover The following table presents sales revenue, cost of goods...
Calculating Gross Profit Margin and Inventory Turnover The following table presents sales revenue, cost of goods sold, and inventory amounts for three retailers of fine jewelry, Tiffany & Co., Zale Corporation, and Blue Nile, Inc. (an Internet retailer). ($ millions) 2013 2012 Tiffany & Co. Revenues $4,231 $3,974 Cost of goods sold 1,766 1,664 Inventory 2,477 2,335 Zale Corporation Revenues $1,963 $1,900 Cost of goods sold 979 939 Inventory 813 759 Blue Nile, Inc. Revenues $495 $433 Cost of goods...
Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.3×...
Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.3× Days sales outstanding: 73.0 daysa Inventory turnover ratio: 5× Fixed assets turnover: 3.0× Current ratio: 2.0× Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 15% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answers to the nearest dollar. Balance Sheet Cash $ Current liabilities $ Accounts receivable Long-term debt 48,000 Inventories Common stock Fixed...
Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.4x...
Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.4x Days sales outstanding: 36.5 daysa Inventory turnover ratio: 4x Fixed assets turnover: 3x Current ratio: 1.9x Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 15% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent. Balance Sheet Cash $ Current liabilities $ Accounts receivable Long-term debt 50,000 Inventories Common stock Fixed...
Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.4x...
Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.4x Days sales outstanding: 36.5 daysa Inventory turnover ratio: 4x Fixed assets turnover: 3x Current ratio: 1.9x Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 15% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent. Balance Sheet Cash $ Current liabilities $ Accounts receivable Long-term debt 50,000 Inventories Common stock Fixed...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT