Question

In: Finance

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

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 $  

Solutions

Expert Solution


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...
Excel Online Structured Activity: Amortization schedule The data on a loan has been collected in the...
Excel Online Structured Activity: Amortization schedule The data on a loan 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 a. Complete an amortization schedule for a $18,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 12% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Year Balance...
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...
Complete the balance sheet and sales information in the table that follows for J. White Industries...
Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Total assets turnover: 1.7 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 25% Total liabilities-to-assets ratio: 50% Quick ratio: 1.10 Days' sales outstanding (based on 365-day year): 36.5 days Inventory turnover ratio: 3.75 Do not round intermediate calculations. Round your answers to the nearest whole dollar. Partial Income Statement Information Sales $   Cost of goods...
Complete the balance sheet and sales information in the table that follows for J. White Industries...
Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Total assets turnover: 1.9 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 25% Total liabilities-to-assets ratio: 40% Quick ratio: 1.00 Days' sales outstanding (based on 365-day year): 36.5 days Inventory turnover ratio: 3.50 Do not round intermediate calculations. Round your answers to the nearest whole dollar. Partial Income Statement Information Sales $   Cost of goods...
Complete the balance sheet and sales information in the table that follows for J. White Industries...
Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Total assets turnover: 2.8 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 26% Total liabilities-to-assets ratio: 45% Quick ratio: 1.15 Days sales outstanding (based on 365-day year): 38.5 days Inventory turnover ratio: 4.0 Do not round intermediate calculations. Round your answers to the nearest whole dollar. Partial Income Statement Information Sales $    Cost of goods...
Below are the financial statements for J & P Industries Balance Sheet for J & P...
Below are the financial statements for J & P Industries Balance Sheet for J & P Industries 2018 Current assets Cash              215 Accounts receivable              310 Inventory              328      Total current assets              853 Fixed assets Net plant and equipment           6,527 Total assets           7,380 Current liabilities Accounts payable              298 Notes payable           1,427      Total currrent liabilities           1,725 Long-term debt           2,308 Owners' equity Common stock and paid in surplus           1,000 Retained earnings...
Excel Online Structured Activity: New project analysis You must evaluate the purchase of a proposed spectrometer...
Excel Online Structured Activity: New project analysis You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $190,000, and it would cost another $47,500 to modify the equipment for special use by the firm. The equipment falls into the MACRS 3-year class and would be sold after 3 years for $85,500. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require a $10,000 increase in net operating working capital...
Excel Online Structured Activity: New project analysis You must evaluate the purchase of a proposed spectrometer...
Excel Online Structured Activity: New project analysis You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $110,000, and it would cost another $27,500 to modify the equipment for special use by the firm. The equipment falls into the MACRS 3-year class and would be sold after 3 years for $38,500. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require an $9,000 increase in net operating working capital...
Excel Online Structured Activity: New project analysis You must evaluate the purchase of a proposed spectrometer...
Excel Online Structured Activity: New project analysis You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $60,000, and it would cost another $12,000 to modify the equipment for special use by the firm. The equipment falls into the MACRS 3-year class and would be sold after 3 years for $30,000. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require an $13,000 increase in net operating working capital...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT