Question

Need Help on these questions, Please. Thanks!USE THE FOLLOWING INFORMATION TO FILL IN THE BALANCE SHEET BELOW TO ANSWER QUESTIONS 31 through 34 60 Number of shares outstaUSE THE INFORMATION BELOW TO ANSWER THE FOLLOWING 3 QUESTIONS Proxelo, Inc. Balance Sheets For the Years Ending December 31,

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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
Add a comment
Know the answer?
Add Answer to:
Need Help on these questions, Please. Thanks! USE THE FOLLOWING INFORMATION TO FILL IN THE BALANCE...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • TSE THE FOLLOWING INFORMATION TO FILL IN THE BALANCE SHEET BELOW TO ANSWER QUESTIONS 31 through...

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

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

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

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

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

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

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

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

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

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

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT