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
jeff jeffy answered 1 year agoRelated 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
Latest Questions
- What is the difference among the principles of modularization, abstraction, encapsulation, and separation of interface and...
- An investment project costs $20,100 and has annual cash flows of $4,400 for six years. ...
- PUT IN JAVA PROGRAMMING The StockB class: Design a class named StockB that contains the following...
- Draw a DFA for the following ( ∑ = {0,1}): Set of all strings with.
- In the article from Forbes notes that the goal of a leader is not to clone...
- Many people keep time using a 24 hour clock (11 is 11am and 23 is 11pm,...
- UNIX ONLY -- DIFFICULT LAB ASSIGNMENT This is an extremely difficult subject for me. Could you...
ADVERTISEMENT