Need Help on these questions, Please. Thanks!
Answer:
Total sales | $200,000 |
Credit sales (60% of total sales) | 120,000 |
Average collection period | 60days |
Formula of Average collection period | 360*Account receivable/Credit Sales |
Computation of Account receivable |
60 =360 * Account receivable/120,000 Account receivable = (120,000*60) / 360 = $20,000 |
Account receivable | $20,000 |
Total Sales | $200,000 |
Less:Gross profit margin 20% | ( 40,000) |
Cost of goods sold | $160,000 |
Inventory turnover ratio | 4 |
Formula of Inventory turnover ratio |
Cost of goods sold/Inventory 4 = 160,000/Inventory Inventory = 160,000/4 Inventory = 40,000 |
Inventory | $40,000 |
Net profit (15 % of sales) |
15% of $200,000 = $30,000 |
Formula of Return on assets |
Net profit/Total assets *100 |
Return on asset |
7.5% 7.5 = 30,000/Total assets *100 Total assets = (30,000*100) / 7.5 =$400,000 |
Total assets | $400,000 |
Account payable | 60days |
Formula of Account Payable ratio |
Account payable days = 360*Account Payable/cost of goods sold 60=(Account Payable*360)/160,000 Account payable = (160,000*60)/360 =$26,667 |
Dividend payout ratio | 80% |
Formula of dividend payout ratio |
Dividend paid/Net income*100 80 = Dividend paid/30,000 *100 Dividend paid = (30,000*80)/100 = $24,000 |
Debt ratio | 40% |
Formula of debt ratio | Total liabilities/ Total assets *100 |
Tota liabilities |
Total assets = $400,000(as calculated above) 40 = (Total liabilities/400,000) *100 Total liabilities = 400,000*40/100 $160,000 |
Total current liabilities |
Account Payable + Notes payable + Accruals $26,667+$10,000+$5,000 =$41,667 |
Long term debt |
Total liabilities - current assets 160,000-41667 = $118,333 |
Current ratio | 1.5 times |
Formula of current ratio | current assets/ current liabilities |
Current assets |
current assets/41,667 = 1.5 Current assets = 62,500 |
Cash |
current assets- (Account receivable +Inventory) 62,500-(20,000+40,000) = $2,500 |
Net fixed assets |
Total assets - current assets 400,000-62,500 $337,500 |
Retained earning (2019) |
Retained earning (2018)+Net income - Dividend paid $23,700+$30,000-$24,000 $29,700 |
Capital surplus | Balancing figure |
Balance sheet for the year ended,2019
Cash | $2,500 | Notes payable | $10,000 |
Account receivable | 20,000 | Account payable | 26,667 |
Inventory | 40,000 | Accruals | 5,000 |
Net fixed assets | 337,500 | Long term debt | 118,333 |
Common stock $2 at par value (Number of outstanding shares = 15,000 shares) |
30,000 | ||
Capital surplus | 180,300 | ||
Retained earning | 29,700 | ||
Total assets | 400,000 | Total liabilities and equity | 400,000 |
Need Help on these questions, Please. Thanks! USE THE FOLLOWING INFORMATION TO FILL IN THE BALANCE...
TSE THE FOLLOWING INFORMATION TO FILL IN THE BALANCE SHEET BELOW TO ANSWER QUESTIONS 31 through 34 45 30 Average collection period (days) Number of shares outstanding 15,000 Accounts payable days Sales $850,000 Retained earnings (2018) $537,400 Gross profit margin 20% Dividend payout ratio 80% Inventory turnover ratio Accruals $9,000 Net profit margin 15% 1.25 Current ratio Return on assets Debt ratio Notes payable $13,000 Note: Of total sales. 60 percent are on credit and the remainder are cash sales....
USE THE INFORMATION BELOW TO ANSWER THE FOLLOWING 3 QUESTIONS Mellon Company Balance Sheet For the Years Ending December 31, 2015 and 2016 (All figures in dollars) Cash Account receivable Inventory Total current assets Gross fixed assets (Accumulated depreciation) Net fixed assets Total assets 2015 1,800 4,010 10,100 15,910 55,800 (9,760) 46,040 61,950 2016 1,840 4,210 9,450 15,500 63,840 (11,050) 52,790 68,290 Notes payable Accounts payable Accruals Current portion of LT debt Total current liabilities Lont-term debt Common stock Paid...
A firm's balance sheets as of the December 31, 2015 and 2016 show the following items: 2015: Cash = $9,916,500; Account Receivable = $9,000,000; Inventory = $4,500,000; Gross Fixed Assets = $10,972,000; Accumulated Depreciation = $1,243,000; Retained Earnings = $1,967,500; Capital Surplus = $8,600,000; Common Stock ($0.50 par) = $4,500,000; Notes Payable = $8,921,000; Long term debt = $2,500,000; Accounts Payable = $6,657,000. 2016: Cash = $11,098,000; Account Receivable = $7,600,000; Inventory = $5,200,000; Gross Fixed Assets = $13,774,000; Accumulated...
A firm's balance sheets as of the December 31, 2015 and 2016 show the following items: 2015: Cash = $9,916,500; Account Receivable = $9,000,000; Inventory = $4,500,000; Gross Fixed Assets = $10,972,000; Accumulated Depreciation = $1,243,000; Retained Earnings = $1,967,500; Capital Surplus = $8,600,000; Common Stock ($0.50 par) = $4,500,000; Notes Payable = $8,921,000; Long term debt = $2,500,000; Accounts Payable = $6,657,000. 2016: Cash = $11,098,000; Account Receivable = $7,600,000; Inventory = $5,200,000; Gross Fixed Assets = $13,774,000; Accumulated...
Following are a statement of cash flows (indirect method) for Harris, Inc., for the year ended December 31, 2017, and the firm’s balance sheet at December 31, 2016: HARRIS, INC. Statement of Cash Flows For the year Ended December 31, 2017 Cash Flows from Operating Activities: Net income $ 13,600 Add (deduct) items not affecting cash: Depreciation expense 32,000 Increase in accounts receivable (7,000 ) Decrease in merchandise inventory 32,800 Increase in accounts payable 4,900 Net cash provided by operating...
help me fill out the charts please Required information [The following information applies to the questions displayed below.) Lansing Company's current-year income statement and selected balance sheet data at December 31 of the current and prior years follow. LANSING COMPANY Income Statement For Current Year Ended December 31 Sales revenue $139,200 Expenses Cost of goods sold 56,000 Depreciation expense 19,000 Salaries expense 32,000 Rent expense 10,400 Insurance expense 5,200 Interest expense 5,000 Utilities expense 4,200 Net income $ 7,400 LANSING...
Please create a balance sheet based on the following income and cash flow statements: PLEASE FILL IN blank columm in balance sheet below for 2016 Income Statement 2016 Sales 655,150 Expenses excluding depreciation and amortization 386,878 EBITDA 268,272 Depreciation and amortization 7,388 EBIT 260,884 Interest expense 8,574 EBT 252,310 Taxes (20%) 20% 50,462 Net income 201,848 Common dividends 12,554 Addition to retained earnings 189,294 Cash flow Statement 2016 Operating Activities 203,409 Net Income 201,848 Depreciation and amortization 7,388 Increase in...
Q. Rao Corporation has the following balance sheet. How much net operating working capital does the firm have? Cash $ 10 Accounts payable $ 20 Short-term investments 30 Accruals 20 Accounts receivable 50 Notes payable 50 Inventory 40 Current liabilities $ 90 Current assets $130 Long-term debt 60 Net fixed assets 100 Common equity 30 Retained earnings 50 Total assets $230 Total liab. & equity $230
Thompson, Inc. Balance Sheets For the years ending December 31, 2011 and 2012) 2012 300 Cash Accounts receivable Inventory Current assets Net fixed assets Total assets 2011 800 3,700 8,400 12,900 34,500 47,400 3,000 10,200 13,500 42,600 56,100 Notes payable Accounts payable Accruals Current liabilities Long-term debt Common stock Capital surplus Retained earnings Total liabilities and equity 1,000 600 1,600 10,700 6,000 18,900 10,200 47,400 1,600 800 700 3,100 10,000 8,000 24,100 10,900 56,100 In its 2011 income statement, Thompson...
The following balance sheet information (in $ millions) comes from the Annual Report to Shareholders of Hotel California for the 2013 fiscal year. (Certain amounts have been replaced with question marks to test your understanding of balance sheets.) In addition, you’re provided with the following information from an analysis of Hotel California’s financial position at the same date: Current ratio = 4.78 Acid-test ratio = 0.968 Debt-to-equity ratio = 1.35 Compute the missing amounts (rounded to the nearest $ in...