Question

Winners Adjusted Trial Balance December 31, 2017 Debit Credit 100,000.00 54,000.00 125,000.00 23,000.00 6,300.00 1,200,000.00

RATIO ANALYSIS SPREADSHEET SOLVENCY RATIOS 2012 20 20 Current Current Assets Current Libilities Quick Cash Accounts Receivabl
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Income Statement
Particulars $ $
Delivery Fees earned 855000
-Wages -89500
-Supplies -5500
Gross Profit 760000
Other Expenses:
Advertisement 6300
Depreciation 14083
Insurance Expense 22000
Interest 25000
Rental Vehicle 500
Utilities 6000 73883
Net Income 686117
Balance Sheet
Assets $ $
Non-Current Assets:
Land 125000
Building 1200000
-Accumulated Dep-Building -125000
Vehicles 359247
-Accumulated Dep-Vehicles -23000
Intangible Assets 175000 1711247
Current Assets:
Accounts Receivable 100000
Cash 10150
Prepaid Insurance 5500
Prepaid Mortgage 18000
Short Term Investments 10000
Supplies Inventory 2500 146150
Total 1857397
Equity & Liabilities $ $
Equity:
H. Jackson Capital 128000
H. Jackson withdrawals -15000
Net Income 686117 799117
Liabilities:
Non-Current Liabilities:
Loan Payable 125000
Note Payable 850000 975000
Current Liabilities:
Accounts Payable 54000
Insurance Payable 11400
Wages Payable 17880 83280
Total 1857397
Ratio Analysis
Ratio Calculation
Current 1.75 =146150/83280
Quick 1.44 =(10150+100000+10000)/83280
Debt to Equity 1.32 =(975000+83280)/799117
GP Margin 88.89% =760000/855000
Pre-Tax Profit Margin 80.25% =686117/855000
Return on Assets 36.94% =686117/1857397
Return on Equity 85.86% =686117/799117
Sales to Assets 0.46 =855000/1857397
Inventory Turnover 2.20 =5500/2500
Inventory Days 165.91 =365/2.2
Accts. Receivable Turnover 8.55 =855000/100000
Collection Period (Days) 42.69 =365/8.55
Accts. Payable Turnover 1.76 =(89500+5500)/54000
Accounts Payable Days 207.39 =365/1.76
Add a comment
Know the answer?
Add Answer to:
Winners Adjusted Trial Balance December 31, 2017 Debit Credit 100,000.00 54,000.00 125,000.00 23,000.00 6,300.00 1,200,000.00 150.00...
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
  • Winners Adjusted Trial Balance December 31, 2017 Debit Credit 100,000.00 54,000.00 125,000.00 23,000.00 6,300.00 1,200,000.00 150.00...

    Winners Adjusted Trial Balance December 31, 2017 Debit Credit 100,000.00 54,000.00 125,000.00 23,000.00 6,300.00 1,200,000.00 150.00 10,000.00 855,000.00 8,333.00 5,750.00 128,000.00 Accounts Receivable Accounts Payable Accumulated Depreciation-Building Accumulated Depreciation Vehicles Advertising Expense Buildings Cash--Checking Cash-Savings Delivery Fees Earned Depreciation Expense-Building Depreciation Expense-Vehicles H. Jackson, Capital H. Jackson, Withdrawals Insurance Expense Insurance Payable Intangible Assets Interest Expense Land Loan Payable Note Payable Prepaid Insurance Prepaid Mortgage Rental Vehicle Expense Short-term Investments Supplies Expense Supplies Inventory Utilities Expense 15,000.00 22,000.00 11,400.00 175,000.00...

  • Adjusted Trial Balance December 31, 2017 Debit Credit 100,000.00 54,000.00 125,000.00 23,000.00 6,300.00 1,200,000.00 150.00 10,000.00...

    Adjusted Trial Balance December 31, 2017 Debit Credit 100,000.00 54,000.00 125,000.00 23,000.00 6,300.00 1,200,000.00 150.00 10,000.00 855,000.00 8,333.00 5,750.00 128,000.00 Accounts Receivable Accounts Payable Accumulated Depreciation-Building Accumulated Depreciation-Vehicles Advertising Expense Buildings Cash--Checking Cash-Savings Delivery Fees Earned Depreciation Expense-Building Depreciation Expense-Vehicles H. Jackson, Capital H. Jackson, Withdrawals Insurance Expense Insurance Payable Intangible Assets Interest Expense Land Loan Payable Note Payable Prepaid Insurance Prepaid Mortgage Rental Vehicle Expense Short-term Investments Supplies Expense Supplies Inventory Utilities Expense 15,000.00 22,000.00 11,400.00 175,000.00 25,000.00 125,000.00...

  • PROBLEM #1 OUTDOORS, INC. Adjusted Trial Balance December 31, 2019 Debit($) Credit($). Cash 12,400 Accounts receivable...

    PROBLEM #1 OUTDOORS, INC. Adjusted Trial Balance December 31, 2019 Debit($) Credit($). Cash 12,400 Accounts receivable 18,600 Supplies 4,200 Prepaid Insurance 2.930 Office Equipment 70,000 Accumulated depreciation 13,000 Building 80,000 Accumulated depreciation 20,000 Land 60,000 Bonds Payable 120,000 Accounts payable 17,100 Unearned subscription revenue 15,000 Salaried Payable 3,500 Common Stock 35,000 Retained Earnings 21,400 Subscription Revenue 195,700 Advertising Revenue 39,300 Salaries Expense 125,410 Printing and mailing expense 80,800 Rent Expense 9,100 Supplies Expense 6,600 Insurance Expense 1,860 Depreciation Expense 5,600...

  • Sparrow Company Adjusted Trial Balance December 31, 2019 Debit Credit Cash $3,050 5,650 Accounts Receivable Prepaid...

    Sparrow Company Adjusted Trial Balance December 31, 2019 Debit Credit Cash $3,050 5,650 Accounts Receivable Prepaid Insurance Equipment 4,480 42,000 Accumulated Depreciation, Equipment Accounts Payable Salaries Payable $24,000 2,700 4,450 3,875 Unearned Service Revenue Common Stock 8,000 Retained Earnings 2,255 10,500 99,600 Dividends Service Revenue Salaries Expense Rent Expense Insurance Expense Depreciation Expense Income Taxes Expense 49,400 17,250 2,200 4,950 5,400 Totals $144,880 $144,880 Required: TO Required: Prepare a classified balance sheet for Sparrow at December 31, 2019. Sparrow Company...

  • The adjusted trial balance for Monty at December 31, 2019, contains the following accounts. Debit Credit...

    The adjusted trial balance for Monty at December 31, 2019, contains the following accounts. Debit Credit Buildings $127,400 Common Stock $93,050 Accounts Receivable 14.700 26,150 Retained Earnings Accumulated Depreciation-Buildings Prepaid Insurance 4,400 43,300 Cash 18,900 Accounts Payable 11,900 Equipment 62,500 Notes Payable 96,300 18,300 Land Insurance Expense 68,500 Accumulated Depreciation-Equipment 900 Interest Payable 7,400 Service Revenue 2,400 $307,100 2,400 15,700 Depreciation Expense Interest Expense $280,950 Prepare a classified balance sheet: assume that $23,000 of the note payable will be paid...

  • Skate 'n' Surf Adjusted trial balance as at 30 June 20XX Account no. Account Debit Credit...

    Skate 'n' Surf Adjusted trial balance as at 30 June 20XX Account no. Account Debit Credit 100 Cash at bank 6,110 110 Accounts receivable 12,925 120 Inventory 40,370 130 Prepaid insurance 4,235 171 Shop equipment (cost) 33,300 172 Accumulated depreciation - shop equipment 694 200 Accounts payable 30,980 210 PAYG withholding payable 50 220 Superannuation payable 90 230 Bank loan 29,523 300 Capital 29,000 400 Sales revenue 23,925 410 Sales returns and allowances 1,100 420 Discount received 2,090 500 Cost...

  • Dump Company Post-Closing Trial Balance December 31, 2016 Account Debit Credit Cash $ Accounts Receivable 27,000 18,000...

    Dump Company Post-Closing Trial Balance December 31, 2016 Account Debit Credit Cash $ Accounts Receivable 27,000 18,000 18,000 Merchandise Inventory 1,500 50,000 12,000 Prepaid Insurance Equipment and Fixtures Accumulated Depreciation Accounts Payable Salaries and Commissions Payable Common Stock 21,000 6,600 23,000 51,900 Retained Earnings $ 114,500 $ 114,500 Totals For the Quarter Ended March 31, 2017 Sales Revenue $ 121,700 60,850 Cost of Goods Sold Gross Profit Selling and Administrative Expenses: 60,850 Commissions Expense 6,085 5,000 Salaries Expense Rent Expense...

  • Presented below is the adjusted trial balance of Tamarisk, Inc at December 31, 2017 Debit Credit...

    Presented below is the adjusted trial balance of Tamarisk, Inc at December 31, 2017 Debit Credit Cash $ Supplies 1110 Accounts Receivable 3,420 Prepaid Insurance 2.400 Equipment 80.100 $20060 Accumulated Depreciation-Equipment Trademarks 3.540 Accounts Payable Salaries and Wages Payable Unearned Service Revenue Bonds Payable due 2024 LE32060 Common Stock Additional paid-in capital Retained Earnings Service Revenue Salaries and Wages Expense Insurance Expense Rent Expense Additional Nettheve 2o Video Course Content 2020 SPRIN* Chapter 5 Homework s.com/courses/32973/assignments/3353614 Prepare a classified balance...

  • BLOSSOM COMPANY Income Statements For the Years Ended December 31 2017 2016 Net sales Cost of...

    BLOSSOM COMPANY Income Statements For the Years Ended December 31 2017 2016 Net sales Cost of goods sold Gross profit Selling and administrative expenses Income from operations Other expenses and losses $1,896,440 $1,756,400 1,011,900 744,500 484,900 259,600 1,064,440 832,000 505,900 326,100 Interest expense Income before income taxes Income tax expense Net income 24,100 302,000 94,100 $207,900 22,100 237,500 75,100 $162,400 BLOSSOM COMPANY Balance Sheets December 31 Assets 2017 2016 Current assets Cash Debt investments (short-term) Accounts receivable Inventory 60,100 64,200...

  • Account number Account Income statement Balance sheet Unadjusted trial Adjusted trial balance Adjustments balance Debit Credit...

    Account number Account Income statement Balance sheet Unadjusted trial Adjusted trial balance Adjustments balance Debit Credit Debit Credit Debit Credit 42,350 42,350 Debit Credit Debit Credit 100 Cash 42350 110 Cash float 450 450 450 120 Accounts receivable 679 679 679 130 Inventory - food 1,366 1,366 1366 140 Inventory - packaging 995 995 995 150 Prepaid advertising 586 293 293 709 293 1,418 160 Prepaid insurance 2,127 1418 170 Motor vehicles (cost) 19,290 19,290 19290 171 Accumulated depreciation -...

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