80.2K

Verified Solution

Link Copied!

Bank Reconciliation and Entries (Ch.7, Obj. 5) The following information is available for Airborne, Inc. as of February 28, 2023: a. Cash on the books as of February 28 amounted to $22,754.16. The cash on the bank statement for the same date was $32,351.46. b. A deposit of $3,344.50, representing cash receipts of February 28, did not appear on the bank statement. c. Outstanding checks totaled $3,936.80. d. A check for $1,920.00 returned with the statement was recorded incorrectly in the check register as $1,380.00. The check was for a cash purchase of merchandise. e. The bank collected $10,300.00 for Airborne, on a note. The face value of the note was $10,000.00. f. The bank mistakenly charged to the company account a check for $755.00 drawn by another company. REQUIRED: 1. Prepare in proper format the Bank Reconciliation for Airborne, Inc. as of February 28, 2023. 2. Prepare in proper format the Journal Entries necessary to adjust the accounts as of February 28, 2023. INSTRUCTIONS: 1. The exam must be submitted using an "EXCEL WORKSHEET." The exam will receive a zero grade if submitted in any other format. 2. Ten (10) possible extra points will be awarded for neatness, organization, and clarity, and you must perform all necessary computations using Excel.

Plsss try your best to format it in a way I can put in excel. Ive been struggling with the format for these specific questions.

Bank Reconciliation and Entries (Ch.7, Obj. 5) The following information is available for Airborne, Inc. as of February 28, 2023: a. Cash on the books as of February 28 amounted to $22,754.16. The cash on the bank statement for the same date was $32,351.46. b. A deposit of $3,344.50, representing cash receipts of February 28 , did not appear on the bank statement. c. Outstanding checks totaled $3,936.80. d. A check for $1,920.00 returned with the statement was recorded incorrectly in the check register as $1,380.00. The check was for a cash purchase of merchandise. e. The bank collected $10,300.00 for Airborne, on a note. The face value of the note was $10,000.00. f. The bank mistakenly charged to the company account a check for $755.00 drawn by another company. REQUIRED: 1. Prepare in proper format the Bank Reconciliation for Airborne, Inc. as of February 28, 2023. 2. Prepare in proper format the Journal Entries necessary to adjust the accounts as of February 28, 2023. INSTRUCTIONS: 1. The exam must be submitted using an "EXCEL WORKSHEET." The exam will receive a zero grade if submitted in any other format. 2. Ten (10) possible extra points will be awarded for neatness, organization, and clarity, and you must perform all necessary computations using Excel

Answer & Explanation Solved by verified expert

See Answer