70.2K

Verified Solution

Link Copied!

ration computations tab

+ Problem General Journal Cash Accounts Receivable Note Receivable Inventory Supplies Prepaid Rent Equipment T Accounts ACRSI On December 1, 2022. Divine Distributing Company had the following account balances Debit Credit Trial Balance 9,200.00 5.400.00 Accumulated Depreciation-Equipment 6,000.00 Accounts Payable 10,700.00 Uneamed Service Revenue 1.500.00 Salaries and Wages Payable 9,600.00 Common Stock 21,000.00 Retained Earnings 63,400.00 During December the company completed the following transactions Dec 4,200.00 7,100.00 2,100.0 1,200.00 18.000.00 30,800.00 63,400.00 Adjusting Entries 6 Paid $2.200 for salaries and wages due employees, of which $1000 is for December and $1,200 was accrued in November to salaries a 7 $300 of merchandise was returned from a November 30, 2022 sale on account 8 Received $1,800 cash from customers in payment of account (no discount allowed). 10 Sold merchandise for cash $9,100. The cost of the merchandise sold was $5,000 13 Purchased merchandise on account from Hecht Co. $7.500, terms 2/10, n/30 Financial Statements 15 Purchased supplies for cash $1,800. 18 Sold merchandise on account $14.000, terms 3/10, r/30. The cost of the merchandise sold was $7,500 20 Paid salaries and wages $2.400 21 Paid $2,400 in advance for next year's annual insurance 23 Paid Hecht Co in full, less discount. 27 Received collections in ful less discounts, from customers billed on December 18. 28 Received $500 from customers for services to be preformed in the future 29 Purchase Equipment on account for $3200 Adjustment data Accrued salaries and wages payable were $850 at the end of the month 2 Depreciation was $460 per month 3. Supplies on hand were $1.300 4. One month of interest income should be recorded on the $6000 Note Receivable at an APR of 5% 5. Services were preformed to satisfy $1200 of the uneamed revenue 6 December's prepaid rent has been used (annual amount was $9600 as recorded in Prepaid Rent) Required Complete each tab of this Excel Worksheet General Journal (all transactions in December), map into T Accounts (add any if necessary), prepare Trial Balance prepare the adjusting entries (1-6 above), Prepare Financial Statements in good form (multi-step income statement, statement of retained earnings, balance sheet) prepare the closing entries, prepare the required ratio computations its Trial Balance Ratio Computations Current Ratio Accounts Receivable (AR) Turnover Average Collection Period Debt to Assets Ratio Return on Assets Ratio Gross Profit Margin Net Profit Margin Adjusting Entries Financial Statements Current Assets Current Liabilities Net Sales Accounts Receivable 365 days AR Turnover Total Debt Total Assets Net Income Total Assets Gross Profit Net Sales Net Income Net Sales Post Closing Entries Show Computation Here Ratio Computations Show Final Answer in good form 4

Answer & Explanation Solved by verified expert

See Answer