please help me with my assignment

Acctg1-AS2-v3.0 - Excel Eileen Abella EA X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share Calibri - 10 AA D Wrap Text General AutoSum . AY O Fill Paste B IU . 3. A Merge & Center $ 4.0 Conditional Format as Cell Insert Delete Format Sort & Find & Sensitivity Formatting * Table Styles Clear * Filter * Select Clipboard Font Alignment Number Styles Cells Editing Sensitivity Y66 X V A B C D E F G H J K L M N P Q R S T U V 40 41 Ditka Dental 42 Balance Sheet 43 As at February 28, 2020 44 Assets Liabilities 45 CASH in BANK $8,200 ACCOUNTS PAYABLE $7,350 46 ACCOUNTS RECEIVABLE (INSURAN $6,250 BANK LOAN $2,800 47 PREPAID INSURANCE $2,500 LINE OF CREDIT $22,500 48 DENTAL EQUIPMENT $80,000 49 Acc. Depreciation -DENTAL EQU ($10,000) Total Liabil $32,650 50 51 Capital (owners equity) $54,300 52 53 Total Assets $86,950 Total Liabilities & Owners' $86,950 54 56 Transactions for the month of March Mar 1 owner deposited personal cash into the business bank account $5,200 Mar 2 owner borrowed cash for the business & deposited in bank $6,500 Mar 3 bought Dental Xray Machine from cash in bank $10,000 Mar 4 deposit cash for Client services in Bank $4,800 Mar 5 paid rent for the month (wrote cheque from bank) 2,850 Mar 6 paid salaries from bank account (wrote cheques) $975 Mar 8 paid back a portion of the accounts payable (etransfer from bank $1,000 Mar 9 received interest on the bank account $15 Mar 12 purchased supplies on account (expense them) $250 67 Mar 14 Deposited cash from customer to settle their account $900 Sheet 1 + Select destination and press ENTER or choose Paste + 90% 9:38 PM 2021-02-27Acctg1-AS2-v3.0 - Excel Eileen Abella EA X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share Calibri - 10 AA D Wrap Text General AutoSum . AY O Fill Paste IU . 3- A = = Merge & Center * % " 4.0 Conditional Format as Insert Delete Format Sort & Find & Sensitivity Formatting * Table Styles Clear Filter * Select Clipboard Font Alignment Number Styles Cells Editing Sensitivity Y66 X V B C D E F G H J K L M N 0 P Q R S T U V W X 2 AA AE AC 66 Mar 12 purchased supplies on account [expense them) $250 67 Mar 14 Deposited cash from customer to settle their acc 006$ 68 Mar 16 purchased gasoline for the company using bank ; $750 69 Mar 19 sold services on account receivable (Insurance c $2,250 70 Mar 22 paid cash for car insurance used this period (wro $600 71 Mar 26 received an advertising bill that will be paid next $320 72 Mar 28 paid bank loan principle (from business account) $350 73 Mar 28 paid line of credit (from business account) $500 74 Mar 29 paid interest on the bank loan/ line of credit (from $375 75 Mar 30 owner withdrew cash for personal use from bank $1,425 76 Mar 31 Recognized one month of depreciation $475 77 78 79 The Chart of Accounts (GL no.) is shown below: 80 81 Account Description Account # Account Description Account # 82 ASSET REVEN CATEGORY + 83 CASH 101 REVENUE 400 84 ACCOUNTS RECEIVABLE 110 INTEREST REVENUE 410 85 PREPAID CAR INSURAN 112 EXPENSES - CATEGORY 5 86 DENTAL EQUIPMENT 120 87 Acc. Depreciation Dental[ 121 ADVERTISING 505 88 LIABILIT ATEGORY CAR INSURANCE 510 89 ACCOUNTS PAYABLE 200 RENT 520 90 BANK LOAN 210 TELEPHONE 530 91 LINE OF CREDIT 220 SALARY 540 92 SUPPLIES 545 93 OWNER JITY - CATEGORY 3 GASOLINE 550 94 CAPITAL (musers equity 300 DEPRECIATION 560 95 DRAWINGS 310 INTEREST EXPENSE 570 96 97 Required: 98 a] Journalize the transactions (with dates & description$] 99 b] Post the transactions to the general ledger 100 c)_Prepare the financial statements in the worksheets piovided 101 Sheet1 (+ Select destination and press ENTER or choose Paste + 70% 9:40 PM m 2021-02-27