Question

In: Finance

Cash $   Current liabilities $   Accounts receivable $   Long-term debt $40,000 Inventories $   Common stock $  ...

Cash $   Current liabilities $  
Accounts receivable $   Long-term debt $40,000
Inventories $   Common stock $  
Fixed assets $   Retained earnings $60,000
Total assets $200,000 Total liabilities and equity $  
Sales $   Cost of goods sold

1. Complete the balance sheet and sales information using the following financial data:

Total assets turnover: 1.1x
Days sales outstanding: 38 days
Inventory turnover ratio: 4x
Fixed assets turnover: 2.5x
Current ratio: 2.5x
Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 15%
Calculation is based on a 365-day year. Round your answer to the nearest cent.

Solutions

Expert Solution

Answer:

Total Assets Turnover = Sales / Total Assets
1.1 = Sales / 200,000
Sales = $220,000

Days Sales Outstanding = 365 * Accounts Receivable / Sales
38 = 365 * Accounts Receivable / 220,000
Accounts Receivable = $22,904

Gross Profit Margin on Sales = (Sales – Cost of Goods Sold) / Sales * 100
15 = (220,000 – Cost of Goods sold) / 220,000 * 100
33,000 = (220,000 – Cost of Goods sold)
Cost of Goods Sold = $187,000

Inventory Turnover Ratio = Cost of Goods Sold / Inventory
4 = 187,000 / Inventory
Inventory = $46,750

Fixed Assets Turnover = Sales / Fixed Assets
2.5 = 220,000/ Fixed Assets
Fixed Assets = $88,000

Total Assets = Cash + Accounts Receivable + Inventories + Fixed Assets
$200,000 = Cash + $22,904 + $46,750 + $88,000
Cash = $42,346

Current Assets = Cash + Accounts Receivable + Inventories
Current Assets = $42,346 + $22,904 + $46,750
Current Assets = $112,000

Current Ratio = Current Assets / Current Liabilities
2.5 = 112,000/ Current Liabilities
Current Liabilities = $44,800

Total Liabilities and Equity = Current Liabilities + Long Term Debt + Common Stock + Retained Earnings
Total Liabilities and Equity = Total Assets
Total Liabilities and Equity = $200,000

$200,000 = $44,800 + $40,000 + Common Stock + $60,000
Common Stock = $55,200


Related Solutions

Assets Liabilities and Equity Cash $ 25,000 Accounts payable $ 25,000 Accounts receivable 156,000 Long-term debt...
Assets Liabilities and Equity Cash $ 25,000 Accounts payable $ 25,000 Accounts receivable 156,000 Long-term debt 103,000 Inventory 79,000 Common stock ($7 par; 21,000 3,000 shares outstanding) Plant and equipment 190,000 Additional paid-in capital 155,000 Retained earnings 146,000 $450,000 $450,000 Construct a new balance sheet showing the impact of a two-for-one split. If the current market price of the stock is $50, what is the price after the split? Round the par value and the market price after the split...
Current liabilities include: A. Accounts receivable B. Unearned revenues. C. Portion of long-term debt that will...
Current liabilities include: A. Accounts receivable B. Unearned revenues. C. Portion of long-term debt that will be paid with noncurrent assets D. All of these E. None of these.
Assets Liabilities and Equity Cash $ 51,000 Accounts Payable $ 23,000 Accounts Receivable 43,000 Common Stock...
Assets Liabilities and Equity Cash $ 51,000 Accounts Payable $ 23,000 Accounts Receivable 43,000 Common Stock 84,000 Land 27,000 Retained Earnings 14,000 Total $ 121,000 Total $ 121,000 The following accounting events apply to Waddell Company's Year 2 fiscal year: Jan. 1 Acquired $46,000 cash from the issue of common stock. Feb. 1 Paid $5,100 cash in advance for a one-year lease for office space. Mar. 1 Paid a $1,900 cash dividend to the stockholders. Apr. 1 Purchased additional land...
​Hurggasky, Inc.'s balance sheet is shown as​ follows: Cash: 460,000 Accounts receivable: 4,080,000 Inventories: 7,900,000 Long-term...
​Hurggasky, Inc.'s balance sheet is shown as​ follows: Cash: 460,000 Accounts receivable: 4,080,000 Inventories: 7,900,000 Long-term debt: 11,140,000 Net property, plant, and equipment: 19,146,000 Common equity: 20,446,000 Total assets:31,586,000 Total debt and equity: 31,586,000 .Currently the price of the​ company's common stock is selling at a price the same as its book​ value, and the​ company's bonds are selling at par. The​ market's required rate of return for its stock is estimated to be 19 percent. The yield to maturity...
Determine the following 2021 amounts and ratios: 1. Current liabilities 2. Long-term liabilities 3. Accounts receivable 4. The acid-test ratio
The current asset section of Guardian Consultant’s balance sheet consists of cash, accounts receivable, and prepaid expenses. The 2021 balance sheet reported the following: cash, $1,300,000; prepaid expenses, $360,000; long-term assets, $2,400,000; and shareholders’ equity, $2,500,000. The current ratio at the end of the year was 2.0 and the debt to equity ratio was 1.4.   Required: Determine the following 2021 amounts and ratios: 1. Current liabilities 2. Long-term liabilities 3. Accounts receivable 4. The acid-test ratio
Accounting for debt is important in businesses. Understanding the accounting for current and long-term liabilities is...
Accounting for debt is important in businesses. Understanding the accounting for current and long-term liabilities is important in understanding the solvency of a business. In this Discussion, you will look at how businesses finance operations through debt. Sunner Company obtains $20,000 in cash by signing a 9%, 6-month, $20,000 note payable to First Bank on July 1. Sunner's fiscal year ends on September 30. What information should be reported for the note payable in the annual financial statements? What disclosure...
Accounting for debt is important in businesses. Understanding the accounting for current and long-term liabilities is...
Accounting for debt is important in businesses. Understanding the accounting for current and long-term liabilities is important in understanding the solvency of a business. In this Discussion, you will look at how businesses finance operations through debt. Rayborn Company obtains $20,000 in cash by signing a 9%, 6-month, $20,000 note payable to First Bank on July 1. Rayborn's fiscal year ends on September 30. What information should be reported for the note payable in the annual financial statements? What disclosure...
Explain how the accounts receivable, inventory, power and equipment, accounts payable, wages payable and long-term debt...
Explain how the accounts receivable, inventory, power and equipment, accounts payable, wages payable and long-term debt impacted cash flow from one year to the next. 200-word minimum.
Current assets Current liabilities Cash $72,000 Accounts payable $12,000 Accounts receivable 18,000 Interest payable 12,000 Interest...
Current assets Current liabilities Cash $72,000 Accounts payable $12,000 Accounts receivable 18,000 Interest payable 12,000 Interest receivable 1,000 Inventory 60,000 Total current assets $151,000 Total current liabilities $24,000 Long-term assets Long-term liabilities Equipment (net of depreciation) $128,000 Note payable 100,000 Total long-term assets $128,000 Total long-term liabilities $100,000 Equity Common stock 10,000 Paid-in capital 50,000 Retained earnings 95,000 Total equity $155,000 Total assets 279,000 Total liabilities and equity $279,000 Yes the difference between account payable and accounts receivable is required....
Spartan Sportswear's current assets consist of cash, marketable securities, accounts receivable, and inventories. The following data...
Spartan Sportswear's current assets consist of cash, marketable securities, accounts receivable, and inventories. The following data were abstracted from a recent financial statement: Inventories $ 280,000 Total assets $ 825,000 Current ratio 2.90 Acid-test ratio 1.30 Debt to equity ratio 1.20 Required: Compute the current assets for Spartan (Do not round intermediate calculations.):
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT