As cost of goods sold is not given, therefore sales revenue will taken in the formula of inventory turnover ratio. | |||||||
Net sales: 1075900 | |||||||
Total assets turnover =2.90 times | |||||||
Total assets turnover = Net sales/ Total assets | |||||||
2.90 = 1075900 / Total assets | |||||||
Total assets = 371000 | |||||||
Cash to Total assets = 1.30% | |||||||
Cash = 371000 *1.30% = 4823 | |||||||
Accounts receivable turnover = 10 times | |||||||
Accounts receivable turnover = Net sales / Accounts receivable | |||||||
10 = 1075900 / Accounts receivable | |||||||
Accounts receivable = 107590 | |||||||
Inventory turnover ratio =14 times | |||||||
Inventory Turnover ratio = Net sales/ Inventory | |||||||
14 = 1075900 / Inventory | |||||||
Inventory =76850 | |||||||
Total current assets = Cash+Accounts receivable + Inventory | |||||||
4823+107590+76850 = 189263 | |||||||
Total assets = Total current assets+ Fixed assets | |||||||
371000 = 189263 - Fixed assets | |||||||
Fixed assets = 371000-189263 =181737 | |||||||
Current ratio =1.88 times | |||||||
Current ratio = Current assets / Current liabilties | |||||||
1.88 = 189263 / Current liabilities | |||||||
Current liabilities = 100672 | |||||||
Debt to t otal assets =45% | |||||||
Debt to total assets = Debt / Total assets | |||||||
Debts = 371000*45% = 166950 | |||||||
Long term debt = Total debts - Current liabilities = 166950-100672 = 66278 | |||||||
Total liabilities and Stockholder equity = Total assets = 371000 | |||||||
Therefore | |||||||
Stockholder's equity = 371000 - Total debts =371000-166950 = 204050 | |||||||
Balance Sheet: | |||||||
Assets | Liabilities and Stockholder's equity | ||||||
Cash | 4823 | Current liabilities | 100672 | ||||
Accounts receivable | 107950 | Long term debts | 66278 | ||||
Inventory | 76850 | Total liabilities | 166950 | ||||
Total current assets | 189263 | ||||||
Fixed assets | 181737 | Equity | 204050 | ||||
Total Assets | 371000 | Total debt and Stockholder's equity | 371000 | ||||
The Griggs Corporation has credit sales of $1,075,900 Total assets turnover Cash to total assets Accounts...
The Griggs Corporation has credit sales of $1,075,900 Total assets turnover Cash to total assets Accounts receivable turnover Inventory turnover Current ratio Debt to total assets 2.90 times 1.30 % 10 times 14 times 1.88 times 45 % Using the above ratios, complete the balance sheet. (Round your answers to the nearest whole dollar.) GRIGGS CORPORATION Balance Sheet Assets Liabilities and Stockholders' Equity Cash Accounts receivable Inventory Current debt Long-term debt Total debt Total current assets Fixed assets Equity Total...
The Griggs Corporation has credit sales of $845,250 2.45 times Total assets turnover Cash to total assets Accounts receivable turnover Inventory turnover Current ratio Debt to total assets 2.00 % 10 times 12 times 1.86 times 35 % Using the above ratios, complete the balance sheet. (Round your answers to the nearest whole number.) GRIGGS CORPORATION Balance Sheet Assets Liabilities and Stockholders' Equity Current debt Cash Accounts receivable Inventory Long-term dett Total debt Total current assets Fixed assets Equity Total...
Current ratio = 2.6 times Credit sales $1,314m Average collection period 50 days Inventory turnover 1.50 times Total asset turnover 0.50 times Debt ratio 75% Use the above information to complete the balance sheet below. (Enter your answer in millions. Use 365 days a year.) Cash million million Current liabilities Accounts receivable $ 670 million million Long-term debt Inventory million 0 million Total debt Current assets 670 million million Stockholders' equity million 670 million Fixed assets $ 0 million Total...
Wal-Mart Stores, Inc. Target Corporation Income Statement Data for Year Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income $65,300 45,000 14,000 660 $417,000 301,000 79,000 1,800 (85) (380) 1,500 4,055 7,100 $27,720 Balance Sheet Data (End of Year) Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders $16,000 27.400 $43,400 $11,000 17,800 14,600 $50,000 121,000 $171,000 $54,000 43,000 74,000 $171,000...
The following information is from Harrelson Inc.'s, financial statements. Sales (all credit) were $18.00 million for last year. Sales to total assets Total debt to total assets Current ratio Inventory turnover Average collection period Fixed asset turnover 1.50 times 45% 2.90 times 6 times 19 days 5 times Complete the balance sheet: (Use a 360-day year. Do not round intermediate calculations. Input your answers in millions rounded to 2 decimal places.) $ in millions $ in millions Current debt 0.90...
Total assets turnover: 1.2x Days sales outstanding: 30.5 daysa Inventory turnover ratio: 4x Fixed assets turnover: 3x Current ratio: 2x Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 15% Calculation is based on a 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent. Balance Sheet Cash Current liabilities Accounts receivable Long-term debt 68,750 Inventories Common stock Fixed assets Retained earnings 82,500 Total assets $275,000 Total liabilities and equity Sales Cost of...
please I requested you to plz provide me a full step by step detail of solution . because for my understanding Q No.8 The Shannon Corporation has Sales of $750,000. Given the following ratios, fill in the balance sheet below: Total asset turnover Cash to total assets Accounts Receivable Turnover Inventory turnover Current Ratio Debt to Total assets 2.5 times 2.0 percent 10.0 times 15.0 times 2.0 times 45.0 percent SHANNON CORPORATION BALANCE SHEET, 1999 Assets Liabilities & Shareholder's Equity...
The following information is from Pramacy Inc.’s financial statements: Sales (all credit) $245,000 Total assets turnover 0.80 times Total debt to total assets 30.83% Fixed asset turnover 1.1 times Current ratio 4.04 times Average collection period 29.68 days Inventory turnover 7.42 times Part A Using the above listed ratios and data, compute the balance of the following accounts. Assume all sales are on credit and a 360-day year. Round to the nearest dollar. [Hint: use ratio formulas to derive the...
Is due by tonight at midnight please help. Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $67,000 $410,000 Cost of goods sold 302,000 Selling and administrative expenses 44,000 14,300 700 81,000 Interest expense 2,000 Other income (expense) (85) (390) Income tax expense 1,400 7,000 Net income $6,515 $ 17,610 Balance Sheet Data (End of Year) Current assets $17,000 $49,000 Noncurrent assets 27,500 122,000 Total assets $44,500 $171,000 Current liabilities $10,000 $55,000 44,000 Long-term debt 18,200 Total...
The balance sheet for Vernon Corporation follows: Current assets $ 246,000 Long-term assets (net) 761,000 Total assets $ 1,007,000 Current liabilities $ 155,000 Long-term liabilities 457,000 Total liabilities 612,000 Common stock and retained earnings 395,000 Total liabilities and stockholders’ equity $ 1,007,000 Required Compute the following. (Round "Ratios" to 1 decimal place.) Working capital Current ratio Debt to assets ratio % Debt to equity ratio Following is the balance sheet of Adams Company for 2018: ADAMS COMPANY Balance sheet Assets...