Excel 101 hw real one - Saved File Home Insert Draw Page Layout Formulas Data Review View Help Calibri 12 BA ... XV fx A B C D E F G H I Currency The following account titles pertain to Dora Debit, CPA: Cash, Accounts receivable, Prepaid Advertising, Supplies, Furniture, Auto, Accounts Payable, Notes payable, Unearned Fees, DD Capital, DD Drawing, Fees Earned, Rental income, Insurance expense, Automobile expense, Advertising expense, Telephone expense, Utilities expense, Supplies expense Date Transactions occurring October: 1 Invoiced (billed) clients for services rendered, $9,800 2 Gave dissatisfied client $500 credit for services previously billed on account 3 Purchased supplies on account, $1,800 4 5 8 Problem #1 Received a $90 reduction in the amount owed to Verizon for an erroneous charge on September telephone bill which had been recorded on account. Paid Verizon $370 for the balance of September telephone bill which had been recorded on account. Dora transfers $9,500 from her personal savings account to her business checking account Problem #2 + LE E B 25 26 27 9 28 29 10 30 31 32 33 34 35 36 37 38 39 40 21 41 421 22 43 44 25 45 46 47 8 11 15 16 17 Dora transfers $9,500 from her personal savings account to her business checking account Received $3,000 cash in advance for services to be rendered over the next six months Purchased an automobile (business use) for $25,000 paying $5,000 and issuing a note for the remainder Received a $150 refund from PSE&G (electricity) as a result of an overcharge in September. Paid Blue Cross/Blue Shield health insurance premium for the month of October, $2,800 Paid DeFillippe's Trendmakers Inc. $12,000 for advertisements to be aired on WXRK for the five month period commencing Nov. 1st Collected $2,900 from clients on account Received $400 from Professor Weinstein's for dumpster rental Paid creditors on account, $1,800. Made first $1,000 installment payment applied to the note payable issued as part of automobile purchase 28 Received $ 625 PSE&G (electricity) bill for period ending Oct. 22nd. The bill is scheduled for payment on November 6th. XVfx B C D E F G H I 21 Received $400 from Professor Weinstein's for dumpster rental 22 Paid creditors on account, $1,800. 25 Made first $1,000 installment payment applied to the note payable issued as part of automobile purchase 28 29 30 Received $ 625 PSE&G (electricity) bill for period ending Oct. 22nd. The bill is scheduled for payment on November 6th. Received $7,500 cash from client for services rendered which had not been previously billed Paid BP-Amoco $780 for gasoline charges 31 Paid $150 for Batman costume rental to be used at a neighborhood Halloween party Required: Record the above transactions in Journal Form K