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.5

gross profit margin on sales: (sales %u2013 cost of goods sold)/sales = 25%

total liabilities-to-assets ratio: 40%

quick ratio: 0.80

days sales outstanding (based on 365-day year): 36.5 days

inventory turnover ratio: 3.75

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

Sales $600,000

Cost of Goods Sold $450,000

Cash $28,000

Accounts payable $110,000

Accounts receivable $60,000

Inventory $120,000

Common Stock $140,000

Fixed Asset $192,000

Total Liabilities and equity $400,000

Explanation:

1.To compute the missing amount of sales, we must look for the data given that has something to do with sales. And the two data given that will give us the hint are the Asset turnover and the total asset.

ASSET TURNOVER = Net Sales / Total Asset

1.5 = Net Sales * $400,000

Net Sales = 1.5 * $400,000

Net Sales = $600,000

To check if the answer is correct:

$600,000 / $400,000 = 1.5 which is equal to the data given

2. The Sales has been computed above and Gross profit margin on sales is present, these are the hint we needed to compute the Cost of goods sold.

Sales  100%

Less: Gross profit margin on sales 25%

Cost of goods sold ratio on sales 75%

Therefore, $600,000 x 75% (ratio on sales) = $450,000

3.ACCOUNTS RECEIVABLE

It is impossible to compute the cash based on the data given without the accounts receivable. So, let's compute the accounts receivable beforehand.

The additional hint that we have is the Days sales outstanding (based on 365-day year).

To check our

$60,000 / ($600,000 / 365)

$60,000 / 1,643.84

36.5 days

4. ACCOUNTS PAYABLE

Next missing item that we will compute is the accounts payable. The hint that we have that is related to the computation of accounts payable is the Liability to asset ratio.

FORMULA :

Liability to asset ratio = Total Liabilities / Total Assets

40% = Total Liabilities / $400,000

Total Liabilities = 40% * $400,000

Total liabilities = $160,000

To Check:

$160,000 / $400,000 = 40% which is equal to the data given

Next Step, Compute accounts payable (the only current liability account in the given partial income statement). Long term debt is the only non-current liability on the data given, which means it is the only account that is included in the total liability of $160,000.

So, $160,000 less $50,000 = $110,000 (accounts payable)

5. CASH

We can now compute the cash based on the accounts already computed above. The additional hint that we have is the quick ratio. Quick ratio is the quotient of Cash & cash equivalent plus Marketable securities (which is not present in the data given, therefore ignore) plus the accounts receivable over the current liability.

Computation:

0.80 = (Cash + Marketable security + Accounts receivable) / current liability

0.80 = (Cash + Accounts receivable) / $110,000

Cash + Accounts receivable = 0.80 * $110,000

Cash + Accounts receivable = 88,000

Cash + $60,000 = $88,000

Cash = $88,000 - $60,000

Cash = $28,000

6. INVENTORY

To compute the inventory, we need the inventory turn-over hint.

Inventory turn-over = Cost of goods sold / Average inventory

3.75 = $450,000 / Ave inventory

Average inventory = $450,000 / 3.75

Average inventory = $120,000

to check:

$450,000 / $120,000 = 3.75 which is equal to the data given

7. COMMON STOCK

Total asset = Liabilities + Equity

$400,000 = $160,000 +?

$400,000 - $160,000 = $240,000

Equity is composed of common stock and retained earnings. Therefore, $240,000 - $100,000 (Retained earnings) = $140,000 (common stock)

8. FIXED ASSET

It is the only asset account that is missing after we computed cash, accounts receivable and inventory. Therefore total assets less current assets equals fixed assets.

9. TOTAL LIABILITIES AND EQUITY

Current liability + Non-current liability + Common stock + Retained earnings

$110,000 + $50,000 + $140,000 + $100,000

$400,000