Need help doing the statements from this worksheet

Home Insert Draw Page Layout Formulas Data Review View + Share ~ X Cut Geneva 14 A- Wrap Text General AutoSum A ND Copy Fill Paste B I U V V Z A E KE LE Merge & Center $ 7 % " Conditional Format Cell Insert Delete Format Sort & Find & Format Formatting as Table Styles Clear Filter Select AT fx A B C D F G H K M N 0 P Q ZKTZ Consulting Inc ZKTZ Consulting Inc Income Statement Balance Sheet ZKTZ Consulting Inc Statement of Retained Earnings JE ADJUSTING JE CLOSING JE Worksheet worksheet formulas statement formulas Trans Analysis NOT REQUIRED statements T Accounts NOT REQUIRED + Select destination and press ENTER or choose Paste 90%Home Insert Draw Page Layout Formulas Data Review View Cut + Share ~ Geneva 10 A A Copy Wrap Text Accounting IH1 AutoSum Paste B Format I U Y Y E KE CE Merge & Center .00 Fill .0 Conditional Format Cell Insert Delete Format Sort & Find & 140 Formatting as lable Styles Clear X V fx Filter Select B C D G H Worksheet - ZKTZ Consulting Inc P Q BEGINNING NUMBERS JANUAR ENTRIES UNADJUSTED TRIAL BALANCE ADJUSTMENTS ADJUSTED TRIAL BALANCE ACCOUNT INCOME STATEMENT DEBI BALANCE SHEET CREDIT DEBI CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT Cash CREDIT $ 49,200.00 DEBIT CREDIT DEBIT $ 63,210.00 $ 37,586.00 $ 74,824.00 CREDIT Accounts Receivable 11,500.00 $ 74,824.00 8,950.00 $ 2,550.00 $ 74,824.00 Supplies 6,985.00 10,590.00 9,535.00 $ 5,650.00 16,240.00 9,535.00 7 Prepaid Rent $ 4,680.00 $ 1,560.00 9,000.00 9,000.00 11,560.00 Land $ 58,300.00 750.00 $ 8,250.00 $ 58,300.00 8,250.00 9 Computer Equipment $ 67,500.00 $ $8,300.00 $ 67,500.00 $ 58,300.00 10 Accumulated Depreciation, Comp Equip $7,500.00 $ 67,500.00 1 Office Fumiture $ 295.00 295.00 8,950.00 8,950.00 $ 295.00 12 Accumulated Depreciation, Off Fum $ 8,950.00 8,950.00 3 Accounts Payable 85.00 $ 10,590.00 $ 10,590.00 $ 5,650.00 85.00 14 Salaries Payable $ 5,650.00 85.00 5,650.00 $ 5,650.00 5 Interest Payable 2,624.00 2,624.00 2,624.00 6 Unearned Revenue 50.00 50.00 $ 11,760.0 $ $ 11,760.00 50.00 7Long-term Notes Payable 980.00 $ 10,780.00 $ 30,000.00 $ 30,000.00 $ 10,780.00 8 Common Stock $ 175,000.00 $ 30,000.00 $ 175,000.00 $ 30,000.00 9 Retained Earnings $ 175,000.00 $ 175,000.00 20 500.00 500.00 21 Service Revenue 500.00 $ 24,000.00 500.00 $ 24,000.00 22 Salaries Expense 7,965.00 $ $ 31,965.00 6,560.00 $ 6,560.00 $ 31,965.00 23 Rent Expense 2,624.00 9,184.00 $ 9,184.00 4 Supplies Expense 750.00 750.00 $ 750.00 25 Utilities Expense 4,680.00 ,680.00 1,986.00 $ 4,680.00 1,986.00 26 Interest Expense 1,986.00 $ 1,986.00 50.00 27 Depreciation Expense, Comp Equip 50.00 $ 50.00 295.00 8 Depreciation Expense, Office Fumiture 295.00 $ 295.00 29 85.00 85.00 85.00 30 $ 185,590.00 $ 185,590.00 $ 117,946.00 $ 117,946.00 $ 246,410.00 $ 246,410.00 $ 16,449.00 $ 16,449.00 $ 256,449.00 $ 256,449.00 $ 17,030.00 $ 31,965.00 $ 239,419.00 $ 224,484.00 $ 14,935.00 $ 14,935.00 $ 31,965.00 $ 239,419.00 JE ADJUSTING JE CLOSING JE Worksheet worksheet formulas statement formulas Trans Analysis NOT REQUIRED statements T Accounts NOT REQUIRED Ready Accessibility: Unavailable + 90%