1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Anna11 [10]
3 years ago
5

Complete the balance sheet and sales information in the table that follows for J. White

Business
1 answer:
deff fn [24]3 years ago
6 0

Answer:

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 <em>which is equal to the data given</em>

<em />

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%

<u>Less: Gross profit margin on sales 25%</u>

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

  • Days sales outstanding = Accounts receivable / (Annual credit sales / 365 days)
  • 36.5 days = Accounts receivable / ($600,000 / 365)
  • Accounts receivable = 36.5 * ($600,000 / 365)
  • Accounts receivable = $60,000

<em>To check our answer:</em>

<em>$60,000 / ($600,000 / 365)</em>

<em>$60,000 / 1,643.84</em>

<em>36.5 days</em>

<em />

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:

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

<em>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.</em>

<em />

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:

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

<em />

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.

  • $400,000 - ($28,000 + $60,000 + $120,000)
  • $400,000 - $208,000
  • $192,000 (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

You might be interested in
Which hmmwv variant is the primary vehicle carrying the s250 electrical equipment shelter?
KonstantinChe [14]

Its usually the M1152 model of hmmwvs

6 0
3 years ago
Bachelor's degrees are awarded by
Misha Larkins [42]
A bachelor's degree (from Middle Latin baccalaureus) or baccalaureate (from Modern Latin baccalaureatus) is an undergraduate academic degree awarded by colleges and universities upon completion of a course of study lasting three to seven years (depending on institution and academic discipline).
5 0
3 years ago
Read 2 more answers
Andrew bryant of the new york times interviewed the ceo of aruba networks, who said he valued a mentor he had at hewlett packard
Dafna11 [192]
The CEO was describing a former mentor who empowered his employee.  Dynamic pioneers today give workers the expert and duty to settle on choices all alone. This is the embodiment of strengthening. The administration mentors and prompts representatives, as opposed to coordinating their work.
8 0
3 years ago
Read 2 more answers
Farmers contributed to the problems that led to the Dust Bowl by
solmaris [256]
The answer is D 
(using intensive farming practices that removed protective grasses.)

Hope it helps :) 
8 0
3 years ago
The interest accrued on $7,500 at 6% for 90 days is:
Oksi-84 [34.3K]
405,000
HOPE THIS HELPS!!!!!!! ;-)
3 0
3 years ago
Other questions:
  • When pay is made public, people evaluate how equitable their pay is in light of the pay other people are receiving. The problem
    11·1 answer
  • If all monopolistically competitive firms had identical cost curves:_________.a. the industry would remain monopolistically comp
    9·1 answer
  • Companies use technology cycles and innovation streams for which of the following purposes? A. To create a competitive advantage
    5·1 answer
  • 1. In the study of communication, noise is best defined as _
    15·2 answers
  • Snow Co. began operations on January 2, 2017. It employs 15 people who work 8-hour days. Each employee earns 10 paid vacation da
    15·1 answer
  • Jennifer and Jamie are starting a business and have asked you for advice about whether they should form a partnership, a corpora
    6·1 answer
  • A guidance counselor at a high school is working on a project to get more girls interested in the Science, Technology,
    13·2 answers
  • Type the correct answer in the box. Spell all words correctly.
    10·1 answer
  • In which ways can goals be classified?<br> Goals can be classified as <br> , <br> , or personal.
    9·2 answers
  • you were recently hired by a firm as a project analyst. the owner of the firm is unfamiliar with financial analysis and wants to
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!