Could someone help me with this ratio part?? Everything else is done ir is just this first screen shot I need help with. I included all the other info that I have!

Home Insert Page Layout Formulas Data Review View Develd * Cut Arial 12 - A- A = = = Copy Paste Format BIUD.&A. E=33 B33 4x fx BCDEFG 1 Please calculate the following ratios and then provide commentary on the January results. 2 Use formulas that link to the financial statements when calculating the ratios. January Industry Ratios 2.00 0.40 5 Activity Ratios: 6 Current Ratio 7 Asset Tumover 8 Receivables Turnover 9 Inventory Turnover 10 Return on Assets 0.70 0.20 12 Profitability Ratios: 13 Profit Margin on Sales 0.55 15 Financing Ratios; 16 DebuEquity 17 Return on Equity 2.00 0.20 Adjusting Journal Entries Adjusted Trial Balance to for Adjusting Entries be testet Edit View Insert Format Tools Data Window Help Home Insert Page Layout Formulas Data Review View Developer * Cut 12 - 6 A- A S.A Arial . BIU. fx Paste Wrap Merge LG Copy " Format 1 x 3 The Vermont Wholesale Company began operations on January 1, 2019. During the month of January 2019, the following transactions occurred: Owners invest $50,000 cash in the corporation in exchange for 5,000 shares of common stock Equipment is purchased for $20,000 cash. On the first day of January $6.000 rent on a building is paid for the months of January and February Merchandise inventory costing $48,000 is purchased on account. The company uses the perpetual $30,000 is borrowed from a local bank, and a note payable is signed Credit sales for the month are $44,000. The cost of merchandise sold is $22,000. $15,000 is collected on account from customers. $20,000 is paid on account to suppliers of merchandise. Salaries of $7,000 are paid to employees for January A bill for $2,000 is received from the local utility company for the month of January $20,000 cash is loaned to another company evidenced by a note receivable. The corporation pays its shareholders a cash dividend of $1,000 structions Rube Initial A p tions Journal Entries Unadjusted Trial Balance T A- A = Paste Copy Format 4 x Ana M B i US fx Cash A E CS2 1 Prepare Joumal Entries for each Transaction 2 Enter Account to be debited in column B, account to be credited in column C. 3 amount to be debited in column D and amount to be credited in column E. 4 Write a brief description of each transaction under the entry. Account Name: Debit Credit Cash Common Stock $50,000.00 NSD 00 $50,000.00 Equipment Cash $20,000.00 $20,000.00 Rent Cash $6,000.00 $6,000.00 Merchandise Inventory Accounts Payable $48,000.00 $48,000.00 Cash Note Payable $30,000.00 $30,000.00 $44.000.00 Accounts receivable Sales revenue Cost of Goods Sold Merchandise Inventory $44,000.00 $22.000.00 $22,000.00 Cash Accounts Receivble $15,000.00 $15.000.00 Instructions Rubrie T ournal Entries Unadjusted Ready Home Inseri Page Layout Formulas Data Review View Develop cut Copy Format 4 x aste Arial - 12 - A A BIU - A fx Cash E = E B $15,000.00 Accounts Receivble $15,000.00 Accounts Payable Cash $20,000.00 $20,000.00 Salary Expense $7,000.00 $7,000.00 Utilities Expense Bills Payable $2,000.00 $2,000.00 Note Receivable Cash... $20,000.00 $20,000.00 Dividends Cash $1,000.00 $1,000.com Instructions Rubric Aral 12 JA- A = = A Copy Paste BIU.EUA. EE 3 Format Fax A B C D E F G 1 Information for Adjusting Journal Entries for the Vermont Wholesale Company 2 Enter Account to be debited in column B, account to be credited in column C. 3 amount to be debited in column D and amount to be credited in column E. 4 Enter description of transaction under each entry. C26 * Prepare Journal Entries for each Transaction NO EE Account Name: Credit Interest Expense Interest Payable Debit $250.00 $250.00 $250.00 Depreciation Expense Equipment $250.00 $300.00 Interest Receivable Interest Income $300.00 $3,000.00 Rent Expense Prepaid rent $3,000.00 9 ANNNNNNSSENSSI Paste Copy Format BiUEVA EE C D E A B The Vermont Wholesale Company Adjusted Trial Balance Credits Debits $21,000.00 $29,000.00 $3,000.00 $26,000.00 $100.00 $20,000.00 $20,000.00 5 Account Title 5 Cash 7 Accounts Receivable Prepaid Rent Merchandise Inventory 0 Interest Receivable 1 Notes receivable 2 Equipment 3. Accumulated depreciation 4 Accounts Payable 5 Interest Payable 16 Notes Payable 17 Common Stock 18 Sales Revenue 19 Interest Revenue 20 Cost of Goods Sold 21 Salary expense 22 Utility Expense 23 Dividend 24 Interest Expense 25 Deprecation Expense 26 Rent Expense $250.00 $30,000.00 $250.00 $30,000.00 $50,000.00 $44,000.00 $100.00 $22,000.00 $7,000.00 $2,000.00 $1,000.00 $250.00 $250.00 $3,000.00 $154,600.00 $154,600.00 A sted Trial B F30 A fel C D E Enter Balance sheet below. Include proper date and title. Enter accounts in appropriate order. Assets 6 Current Assets: Inventory Accounts Receivabe Note Receivable Cash Rent $26,000.00 $29,000.00 $20,000.00 $21,000.00 $6,000.00 Total Current Assets $102,000.00 15 Property and Equipment: Equipment $20,000.00 Total Assets $122,000.00 Liabilities and Shareholder's Equity 22 Current Liabilities: Salary Expense Bills Payable Accounts Payable Total Current Liabilities 27 Shareholder's Equity Common Stock Notes Payable $9,000.00 $2,000.00 $28,000.00 $39,000.00 NA $50,000.00 $30,000.00 Total Shareholder's Equity $80,000.00 33 Total Liabilities and Shareholder's Equity $119.000.00 35 Note: Calculate Retained Earnings as though it is year-end 36 and revenue and expenses are closed to retained earnings. no for Adusting Entries Adjusting Journal Entries Adjusted IL Copy Paste Format B1 UHERIA.EE x fx 6000 UN Enter Income Statement Below. Include appropriate title. Include appropriate date. / / / $22,000.00 / W / 7 Gross Profit 8 Operating Expenses: Rent _ Utility Expense Salary Expense Dividends Total Operating Expenses 14 Operating Income 15 Other Income (Expense): $6,000.00 $2,000.00 $7,000.00 $1,000.00 $16,000.00 $6,000.00 18 Net Income $6,000.00 F BEBE Paste Format x BISA = fx au AWN Enter Statement of Cash Flows Below. Include appropriate title. Include appropriate date. Describe each investing and financing activity. ($18,000.00) ($40,000.00) 7 Net Cash Flows from Operating Activities 8 Cash Flows from Investing Activities: Equipment/Notes Receivable 10 Cash Flows from Financing Activities: issuance Common Stock Notes Payable Dividends $50,000.00 $30,000.00 ($1,000.00) $21,000.00 15 Net Increase in Cash 16 Cash Balance, January 1, 2019 17 Cash Balance, January 31, 2019 Adjusting Journal Enthes Adjusted Trial B Paste copy Format x BIE&A E=33 fe B14 Enter Statement of Shareholders Equity Below Include appropriate title Include appropriate Date Total Shareholders Equity 8 Beginning Balance 9 Income 10 Dividend Common Stock Retained Earnings $50,000.00 $10,000.00 ($1,000.00) $10,000.00 ($1,000.00) $0.00 $0.00 $59,000.00 $50,000.00 $9,000.00 hilo for Adjusting Entries Adjusting Journal Entries Adjusted Trial Balance Ready