i just need help making a balance sheet, and the current assets/liabilities

SLA ar students S21.xdsx Excel SLA 3r students $21. Saved Search (Option File Home Insert Formulas Data Review View Help Open in Desktop App Editing Calibri 11 B ... General A2 fx Adjusted Trial Balance B D F 1 2 3 4 RedBear Landscaping Company Adjusted Trial Balance December 31, Credit Credit $ $ 2021 Debit 35,120 1,700 7,000 8,400 22,000 50,000 5,000 2020 Debit 14,700 1,200 10,000 8,000 22,000 50,000 5,000 $ $ 5 6 Cash 7 Accounts Receivable 8 Supplies 9 Prepaid Expenses 10. Equipment 11 Vehicles 12 Office Furniture 13 Accumulated Depreciation 14. Accounts Payable 15 Accrued Expenses Payable 16 Note Payable (due in six months) 17 Loan Payable (due in five years) 19 Common Stock, Si par 19 Additional Paid in Capital 20 Retained Earnings 21 Dividends Declared (contra RE) 22 Services Revenue 23 Wage Expense 24 Insurance Expense Checklist SLA 3 22,000 5,000 2,400 11,000 4,600 1,800 5,000 44,500 4,000 28,000 44,500 4,000 28,000 12,000 6,100 1,900 79,200 31,680 28,800 8,000 7,200 Ratio Analysis Linked to TB Exhibit 13.3 Ratios 72,000 + Caution Model Automatic Warkbook State 663 MacBook Air Excel SLA 3r students S21 Saved Search (Option +Q) File Home Insert Formulas Data Review View Help Open in Desktop App Editin v Calibri v 11 V B HA.. Gener A2 Fx Adjusted Trial Balance A B D E F LU 17 Loan Payable (due in five years) 44,500 44,500 18 Common Stock $1 par 4,000 4,000 19 Additional Paid in Capital 28,000 28,000 20 Retained Earnings 12,000 21 Dividends Declared (contra RE) 6,100 1,900 22 Services Revenue 79,200 72,000 23 Wage Expense 31,680 28,800 24 Insurance Expense 8,000 7,200 25 Rent Expense 6,000 6,000 26 Advertising Expense 1,000 1,000 27 Depreciation Expense 11,000 11,000 28 Interest Expense 2,800 3,100 29 Income Tax Expense 1,300 1,000 30 Total $ 197,100 $ 197,100 $ 170,900 $ 170,900 31 TRUE A group of four students who started a new residential landscaping and snowplowing business, RedBear Landscaping Company (RBLC), has now completed two years of operations. The Adjusted Trial Balance (before closing) reflects both years of business 32 Required: properly formatted ratios, correct linking and formulas, narratives that include "what the ratios mean for the company AND "trend" analysis. (insufficient. just stating ratio increased or decreased, or just stating ratio good or bad: must include why/what ratio results mean.) Do NOT include how you calculated the ratios, that is demonstrated by correc 33 formulas and linking Checklist SLA 3 Ratio Analysis Linked to TB Exhibit 13.3 Ratios + Calculation Mode: Automatic Workbook Statistics TRUE 063 8 ... MacBook Air