Question

$ 4.800 5,250 5,300 3,000 30,300 Accounts eceivable Prepaid advertising. .. . Trucks._.. . $10,000 Equipment . . . . Accumulated depreciation-Equipment... Accounts payable... Uneaned service fees . . 7,600 2,100 6.700 10,000 16,050 Retained eamings Service fees eaned... Rent expense.. 7.500 80,500 29,800 10,200 4,900 8,000

Prepare a detailed Balance Sheet and also calculate the following ratios:

A) Current Ratio

B) Working Capital

C) Assets Turnover

D) Fixed Assets Turnover

E) A/R Turnover

F) Debt Ratio

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

Solution:

A. Current Ratio = Current assets / Current liabilities

   = (4,800 + 5,250 +5,300 + 3,000) / (1,200 +6,700) = 2.32 (Rounded off )

B.Working capital = Current assets - Current liabilities

   = (4,800 + 5,250 +5,300 + 3,000) - (1,200 +6,700) = 10,450

C. Assets Turnover = Net sales / Total assets

= 80,500 / 44,150 = 1.82 (Rounded off)

D. Fixed assets turnover = Net sales / Total Fixed assets

= 80,500 / 25,800 = 3.12 (Rounded off)

E. A/R turnover = Net credit sales / Average Accounts Receivable

   = 80,500 / 5,250    (Here Service is assumed to be credit)

   = 15.33 (Rounded off)

F. Debt ratio = Total debt / Total assets

= 1,200 / 44,150 = 0.027

Add a comment
Know the answer?
Add Answer to:
Prepare a detailed Balance Sheet and also calculate the following ratios: A) Current Ratio B) Working...
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
  • Prepare a Balance Sheet $ 4.800 5,250 5,300 3,000 30,300 Accounts eceivable Prepaid advertising. .. ....

    Prepare a Balance Sheet $ 4.800 5,250 5,300 3,000 30,300 Accounts eceivable Prepaid advertising. .. . Trucks._.. . $10,000 Equipment . . . . Accumulated depreciation-Equipment... Accounts payable... Uneaned service fees . . 7,600 2,100 6.700 10,000 16,050 Retained eamings Service fees eaned... Rent expense.. 7.500 80,500 29,800 10,200 4,900 8,000

  • Prepare an Income Statement and a statement of Retained Earnings sheet. Also, calculate profit margin and...

    Prepare an Income Statement and a statement of Retained Earnings sheet. Also, calculate profit margin and payout ratio. XYZ Company Adjusted Trial Balance Debit Credit Cash 9,800 Accounts receivable 5,250 5,300 Supplies Prepaid Advertising 3,000 Trucks 30,300 $ 10,000 Accumulated depreciation – Trucks Equipment 7,600 Accumulated depreciation – Equipment 2,100 Accounts payable 1,200 Unearned service fees 6,700 Common Stock 10,000 Retained earnings 16,050 Dividends 12,000 Service fees earned 90,000 Wages expense 29,800 Rent expense 10,200 Insurance expense 4,900 Supplies expense...

  • Problem #3 XYZ Company Adjusted Trial Balance Debit Credit Cash $ 19,800 Accounts receivable 5,250 Supplies...

    Problem #3 XYZ Company Adjusted Trial Balance Debit Credit Cash $ 19,800 Accounts receivable 5,250 Supplies 5,300 Prepaid Advertising 3,000 Trucks 30,300 Accumulated depreciation - Trucks Equipment 7,600 Accumulated depreciation - Equipment Accounts payable Unearned service fees S 10,000 2,100 1.200 6,700 20,000 16,050 12,000 90,000 29,800 Common Stock Retained carnings Dividends Service fees earned Wages expense Rent expense Insurance expense Supplies expense Advertising expense Depreciation expense - Trucks Depreciation expense - Equipment 10,200 4,900 5,100 8,000 4,000 800 $146,050...

  • Please figure out the following: 1. Income Statement. 2. Statement of Retained earnings. 3. Profit Margin...

    Please figure out the following: 1. Income Statement. 2. Statement of Retained earnings. 3. Profit Margin and Payout Ratio. $ 4,800 5,250 5,300 3,000 30,300 Accounts ts receivable Trucks.... Accumulated S10,000 7,600 2,100 1,200 6.700 10,000 16,050 Accumulated depreciation-Equipment.. 80,500 29,800 Supplies expense Advertising expense... 5,100 8,000 Depreciation expense-Equipment

  • L06 P3-9B. Closing Entries The adjusted trial balance for Okay Moving Service as of December 3...

    L06 P3-9B. Closing Entries The adjusted trial balance for Okay Moving Service as of December 3 l is a oWS Adjusted Trial Balance Debit Credit 5,250 5,300 3,000 30,300 $ 10,000 7,600 2,100 1,200 6,700 10,000 16,050 7,500 80,500 29,800 10,200 4,900 5,100 8,000 4,000 800 Required a. Prepare the closing entries at December 31 directly to Retained Earnings in general journal form b. After the closing entries are posted, calculate the ending balance in the Retained Earnings account. c....

  • Prepare a detailed Balance Sheet and also calculate the following ratios: A) Current Ratio B) Working...

    Prepare a detailed Balance Sheet and also calculate the following ratios: A) Current Ratio B) Working Capital C) Assets Turnover D) Fixed Assets Turnover E) A/R Turnover F) Debt Ratio $ 2,700 3.270 Supplies. Prepaid insurance Accumulated depreciation Equipment Long-term notes payable. 1,500 6,400 . . $ 1,080 845 7,000 3,000 5,205 2,900 Service fees eamed... . 62,400 15,000 33,400 4,700 3,250 720 $79,530 $79,530

  • Prepare a detailed Balance Sheet and also calculate the following ratios: A) Current Ratio B) Working...

    Prepare a detailed Balance Sheet and also calculate the following ratios: A) Current Ratio B) Working Capital C) Assets Turnover D) Fixed Assets Turnover E) A/R Turnover F) Debt Ratio Adjusted Trial Balance Cash $ 3,500 8,000 3,600 75,000 Prepaid insurance $12,000 600 30,000 14,100 Common stock. 7,500 102,200 4,200 Miscellaneous income.. Salaries expense. Rent expense. Insurance expense. Depreciation expense.. . 42,800 12,900 1,800 8,000 8,800 8,800 $171,900 $171,900

  • A. Required: 1. Please calculate the following ratios and amounts: a) working capital, b) current ratio,...

    A. Required: 1. Please calculate the following ratios and amounts: a) working capital, b) current ratio, c) acid-test ratio, d) cash to current liabilities ratio, e) days’ sales in receivables (based on ending accounts receivables), f) days’ sales in inventory (based on cost of goods and ending inventory), g) operating cycle, h) total debt to equity ratio and i) times interest earned. For your calculations, assume that a year amounts for 360 days The balance sheet and the income statement...

  • 4. Given the balance sheet in Table P3.2, calculate the following ratios: (a) Current ratio (b)...

    4. Given the balance sheet in Table P3.2, calculate the following ratios: (a) Current ratio (b) Quick ratio (c) Debt-equity ratio A Liabilities 1620 Title 1.2.3636 13 7.80 26.3.1 NE 1.679 (rrent liabilities Accounts payable Due subcontractors Accrued expenses and takes Equipment contracts, carne Provision for income taxes Total (g) Deferred credits Income billed on jobs in progress at December 1944 Costs incurred to 31 December 1984 n uncompleted jobs 3306.2029 713.991.66 50.599.69 23.60 97.316.66 1.171.8260 12.777.97 2.778.331.36 2.7187O 9.5935...

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