help please

Excel File Edit View Insert Format Tools Data Window Help $ $ 100% ZZ Sat 3:43 PM Q AutoSave . OFF YOU MUST RENAME AND UPLOAD THIS FILE - 1P91 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 10 AA B Wrap Text v Custom Insert v Ex Delete AY- O. Paste BIUV Merge & Center v v % " Conditional Format Cell Styles Format Sort & Find & ideas Sensitivity Formatting as Table Filter Select E2 X fx 850 B C D E F G H K M N The accounts in the ledger of Ontario Delivery Service contain the following balances (with normal debit or credit balances) on September 30th, 2020. Accounts Receivable 2,040.00 Accounts Payable 2,550.00 Required: Cash Balance = ? 2. [20 Marks] With the account names and balances provided, prepare an income statement, a statement of retained earnings, and a classified balance sheet as of September 30th, 2020. Delivery Equipment 6,460.00 Gas and Oil Expense 850.00 Income Statement Statement of Retained Earnings Insurance Expense 510.00 For the month ended September 30th, 2020 For the month ended September 30th, 2020 10 Notes Payable, due 2022 2,380.00 Accumulated Depreciation 1,700.00 Prepaid Insurance 1,700.00 Depreciation Expense 1,530.00 Service Revenues 4,420.00 Dividends declared 510.00 Contributed Capital 4,250.00 Rent Expense 680.00 Salaries Expense 1,020.00 Salaries Payable 850.00 Retained Earnings (Balance as of Sep 1st, 2020] 850.00 Required: 1. [5 Marks] Prepare the closing entries required at September 30th, 2020. Balance Sheet General Journal Debit Credit At September 30th, 2020 Service Revenue 1,420.00 Current Assets Current Liabilities Retained Earning 4,420.00 Retained Earnings Gas and Oil expense 850.00 insurance expense depreciation expense Non-current Liabilities ent expense salaries expense Non-Current Assets Shareholders' Equity 39 40 INSTRUCTION Part 1 Part 2 Part 3 + Ready - + 100% Help A 10 OPS W X PINSON O T Q V