Excel Online Structured Activity: Balance Sheet AnalysisConsider the following financial data for J. White Industries:Total assets turnover: 1.2Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 27%Total liabilities-to-assets ratio: 45%Quick ratio: 0.90Days sales outstanding (based on 365-day year): 29.5 daysInventory turnover ratio: 4.0The 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 IncomeStatementInformationSales$ fill in the blank 2Cost of goods sold$ fill in the blank 3Balance SheetCash$ fill in the blank 4Accounts payable$ fill in the blank 5Accounts receivable$ fill in the blank 6Long-term debt$ 50,000Inventories$ fill in the blank 7Common stock$ fill in the blank 8Fixed assets$ fill in the blank 9Retained earnings$ 100,000Total assets$ 400,000Total liabilities and equity$ fill in the blank 10 123 Total assets turnover4Balance Sheet Analysis567891011Gross profit margin on salesTotal liabilities-to-assets ratioQuick ratioDays sales outstandingInventory turnover ratioTotal assetsLong-term debtRetained earnings12 Number of days in year1314 Financial Statements15Partial Income:16171819 Balance Sheet:SalesCost of good sold20 Cash21Accounts receivable22 Inventories221.2027.00%45.00%0.9029.504.00$400,00050,000100,000365Formulas#N/A#N/A#N/A#N/A#N/AHAL/A Balance Sheet:CashAccounts receivableInventoriesFixed assetsTotal assetsAccounts payableLong-term debtCommon stockRetained earningsTotal liabilities and equity$400,00050,000100,000#N/A#N/A#N/A#N/A#N/A#N/A#N/A

Days sales outstanding represent the period taken by the company to collect the account receivable.…

Answered: Consider the following financial data…

Fundamentals of Financial Management, Concise Edition (MindTap Course List)

9th Edition

ISBN:9781305635937

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Eugene F. Brigham, Joel F. Houston

Chapter4: Analysis Of Financial Statements

Section: Chapter Questions

Problem 7DQ: From the Google Finance site, use the DuPont analysis to determine the total assets turnover ratio...

See similar textbooks

Excel Online Structured Activity: 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 = 27%
Total liabilities-to-assets ratio: 45%
Quick ratio: 0.90
Days sales outstanding (based on 365-day year): 29.5 days
Inventory turnover ratio: 4.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	$ fill in the blank 2
Cost of goods sold	$ fill in the blank 3

Balance Sheet

Cash	$ fill in the blank 4	Accounts payable	$ fill in the blank 5
Accounts receivable	$ fill in the blank 6	Long-term debt	$ 50,000
Inventories	$ fill in the blank 7	Common stock	$ fill in the blank 8
Fixed assets	$ fill in the blank 9	Retained earnings	$ 100,000
Total assets	$ 400,000	Total liabilities and equity	$ fill in the blank 10

Balance Sheet:
Cash
Accounts receivable
Inventories
Fixed assets
Total assets
Accounts payable
Long-term debt
Common stock
Retained earnings
Total liabilities and equity
$400,000
50,000
100,000
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.