Below are the balances of the accounts: Required: Classify the accounts as CA, NCA, CL, NCL, Equity, Rev., and Exp., and A/D - Equipment 24,000 present its normal balance if debit or Accounts payable 80,000 credit. If correct normal balances are presented for each account, the total debit and total credit will be equal. Accounts receivable 72,000 Allow. for Bad Debts 12,000 Bad debts expense 4,500 Cash 256,000 Instructions: Depreciation expense 2,500 1. Use Excel in solving this formative Equipment 110,000 assessment. Furniture and fixtures 46,000 2. Format the amounts with no decimal Loans payable (long-term) 65,000 Loans payable (short-term) Owner's capital places. 3. Use the category "accounting" in formatting cells of debit and credit. 7,000 315,000 Owner's drawing 30,000 Prepaid rent 48,000 4. Save the Excel file as PDF with a file Rent expense 38,000 name: FA02: L11 Salaries expense 94,000 5. Upload the PDF file in SB Dropbox. Service income 248,000 Supplies expense ,000 Reminder: Do your own work and no sharing of answers. Utilities expense 42,000