DO IT IN EXCEL APP PLEASE

Do a: Worksheet (Analyze the elements of each account title and categorize all of the account titles in ALORE format. ) Statement of Comprehensive Income Statement of Financial Position Cash on Hand 271,000 Cash in Bank 107,000 Pearson, Capital 750,000 Furniture and Fixtures 200,000 Office Equipment 260,000 Rent Expense 10,000 Utilities Expense - 8,000 Taxes and Licenses 5,000 Office Supplies - 50,000 Accounts Payable 10,000 Consulting Income 252,000 Accounts Receivable - 0 Notes Receivable 21,000 Prepaid Advertisement 24,000 Pearson, Withdrawals 17,000 Salaries Expense 32,000 Transportation Equipment 700,000 Bank Loan 700,000 Insurance Expense 5,000 Gasoline and Oil Expense 2,000