Learning Objective 4.4 LO 4.4) Prob.1. Beerbo has the following accounts listed in its ledger: Cash > Accounts Receivable Prepaid Rent Notes Receivable Interest Revenue Miscellaneous Expense For the month of February, Beerbo showed the following postings to its Cash account: Date Feb. 1 Activity Detail Bal. CASH Date Activity Detail 3,680 550 Feb. 3 check #5055 Feb. 6 deposit cash 800 2,500 Feb. 12 check #5056 Feb. 15 deposit customer check 2,000 1,200 Feb. 19 check #5057 Feb. 23 deposit customer check 1,500 500 Feb. 25 check #5058 650 Feb. 27 check #5059 Feb. 28 deposit cash 2,500 Feb. 28 Bal. 5,080 Beerbo's February 2021 bank statement from Local Bank was as follows: Beginning balance, February 1, 2021 Bank deposits processed/cleared 3,680 Date Type ID Number Amount ($) Feb. 7. Cash n/a 800 Feb. 15 Check Mitter Lite, no. 321 2,000 Feb. 24 Cash Mitter Lite, no. 329 1,500 4,300 Checks processed/cleared Date Type ID Number Feb. 8 Check 5055 Feb. 16 Check 5056 Feb. 23 Check 5057 Amount ($) (550) (2,500) (1,200) (4,250) Other activities processed/cleared Date Type Activity Amount (S) Feb. 2 Deposit Collection: note receivable 2,100 Feb. 12 Deduction NSF: "LBK Suds Chib (900) Feb. 25 Feb. 26 Deduction EFT: "WesTex Property Rentals Deduction Service fee (250) (16) Feb. 27 Deposit Earned interest 10 Ending balance, February 28, 2021 944 4,674 Additional information: - 1 Beerbo prepays next month's rent during the last week of the current month. No bank errors or book errors were noted by Beerbo. Checks written by Beerbo can take up to one month before they are processed and cleared by Local Bank. Beerbo ordered no new checks from Local Bank during February. Interest earned on Beerbo's note receivable is auto-deposited into Beerbo's bank account at the beginning of each month. LO 4.4) Prob.1.a. Create the "BANK SIDE" of Beerbo's bank reconciliation Determine which items (if any) appear in Beerbo's ledger (i.e. Cash account) that do not appear on the bank statement from Local Bank. Calculate the adjusted bank balance. Use proper bank reconciliation formatting. LO 4.4) Prob.1.b. Create the "BOOK SIDE" of Beerbo's bank reconciliation Determine which items (if any) appear on the bank statement from Local Bank that do not appear in Beerbo's ledger (i.e. Cash account). Calculate the adjusted bank balance. Use proper bank reconciliation formatting. LO 4.4) Prob.1.c. Record the necessary journal entries Determine the necessary journal entries Beerbo should record to ensure its ending Cash balance (per its ledger) equals the adjusted book balance (per the bank reconciliation). Use proper journal entry formatting. LO 4.4) Prob.1.d. Post the journal entries to the Cash ledger account Recreate the Cash ledger account from the information given above. From LO 4.4) Prob.1.c (above), post the effects of the journal entries to the Cash ledger account. Calculate the new February 28th ending balance for the Cash ledger account