Question

In: Accounting

E5-8 Prepare bank reconciliation and adjustments. The following information pertains to Lance Company. 1. Cash balance...

E5-8 Prepare bank reconciliation and adjustments.
The following information pertains to Lance Company.
1. Cash balance per bank, July 31, $7,328.
2. July bank service charge not recorded by the depositor $38.
3. Cash balance per books, July 31, $7,364.
4. Deposits in transit, July 31, $2,700.
5. $2,016 collected for Lance Company in July by the bank through electronic funds transfer.
The collection has not been recorded by Lance Company.
6. Outstanding checks, July 31, $686.
Instructions
(a) Prepare a bank reconciliation at July 31, 2017.
(b) Prepare a tabular analysis for the adjustments at July 31 on the books of Lance
Company. Use the following column headings: Cash, Accounts Receivable, Revenues,
and Expenses. Include margin explanations for the changes in revenues and expenses.
NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?" .
(a) LANCE COMPANY
Bank Reconciliation
July 31, 2017
Cash balance per bank statement Value
Add: Deposits in transit Value
?
Less: Outstanding checks Value
Adjusted cash balance per bank ?
Cash balance per books Value
Add: Collection of note receivable Value
?
Less: Bank service charge Value
Adjusted cash balance per books ?
Stockholders' Equity
(b) Assets = Liabilities + Account
Cash + Accts. Rec. = + Revenues -Expenses
July 31 Value Value
31 Value Value Text
After you have completed E5-8, consider the following additonal question.
1. Assume that deposit in transit, outstanding checks and cash balance per books changed to
$3,600, $886 and $8,064 respectively. Show the impact of these changes on the bank
reconciliation.

SOLVE FOR MISSING VALUES , CASH , LIABILITIES, STOCK HOLDERS EQUITY AND QUESTION 1

Solutions

Expert Solution

The missing values of liabilities, stock holders' equity and accounts receivable can not be determined without more information.


Related Solutions

What was the cash balance on the Egrane's books (before the adjustments for items on the bank reconciliation)?
Egrane, Incorporated's monthly bank statement showed the ending balance of cash of $20,400. The bank reconciliation for the period showed an adjustment for a deposit in transit of $2,450, outstanding checks of $3,900, an NSF check of $2,600, bank service charges of $125 and the EFT from a customer in payment of the customer's account of $3,400. What was the cash balance on the Egrane's books (before the adjustments for items on the bank reconciliation)? Multiple Choice$18,275$24,825$18,950$21,850
Required information Problem 8-4A Preparing a bank reconciliation and recording adjustments LO P3 [The following information...
Required information Problem 8-4A Preparing a bank reconciliation and recording adjustments LO P3 [The following information applies to the questions displayed below.] The following information is available to reconcile Branch Company’s book balance of cash with its bank statement cash balance as of July 31, 2017.    On July 31, the company’s Cash account has a $25,646 debit balance, but its July bank statement shows a $27,664 cash balance. Check No. 3031 for $1,400 and Check No. 3040 for $692...
Based on the following information, prepare a bank reconciliation to determine the adjusted corrected balance
Based on the following information, prepare a bank reconciliation to determine the adjusted corrected balance: (input each amount as a positive value) Bank balance$ 680Account fees $ 12Checkbook balance$ 642ATM withdrawals$ 80Outstanding checks$ 112Deposit in transit$ 60Direct deposits$ 70Interest earned$ 8
Problem 8-4A Preparing a bank reconciliation and recording adjustments P3 Images Missing The following information is...
Problem 8-4A Preparing a bank reconciliation and recording adjustments P3 Images Missing The following information is available to reconcile Branch Company’s book balance of cash with its bank statement cash balance as of July 31, 2017. On July 31, the company’s Cash account has a $27,497 debit balance, but its July bank statement shows a $27,233 cash balance. Check No. 3031 for $1,482 and Check No. 3040 for $558 were outstanding on the June 30 bank reconciliation. Check No. 3040...
The following information pertains to Sheridan Video Company. 1. Cash balance per bank, July 31, $7,943....
The following information pertains to Sheridan Video Company. 1. Cash balance per bank, July 31, $7,943. 2. July bank service charge not recorded by the depositor $37. 3. Cash balance per books, July 31, $7,964. 4. Deposits in transit, July 31, $1,840. 5. Bank collected $1,240 note for Sheridan in July, plus interest $45, less fee $29. The collection has not been recorded by Sheridan, and no interest has been accrued. 6. Outstanding checks, July 31, $600.
The following information pertains to Ghose Company. 1. Cash balance per bank, July 31, $8,569. 2....
The following information pertains to Ghose Company. 1. Cash balance per bank, July 31, $8,569. 2. July bank service charge not recorded by the depositor $62. 3. Cash balance per books, July 31, $8,605. 4. Deposits in transit, July 31, $3,941. 5. Note for $3,241 collected for Ghose in July by the bank, plus interest $60 less fee $44. The collection has not been recorded by Ghose, and no interest has been accrued. 6. Outstanding checks, July 31, $710.
The following information pertains to Vaughn Video Company. 1. Cash balance per bank, July 31, $7,983....
The following information pertains to Vaughn Video Company. 1. Cash balance per bank, July 31, $7,983. 2. July bank service charge not recorded by the depositor $36. 3. Cash balance per books, July 31, $8,004. 4. Deposits in transit, July 31, $1,860. 5. Bank collected $1,260 note for Vaughn in July, plus interest $44, less fee $28. The collection has not been recorded by Vaughn, and no interest has been accrued. 6. Outstanding checks, July 31, $599. Prepare a bank...
12. based on the following information, prepare a bank reconciliation to determine the adjusted (corrected) balance:...
12. based on the following information, prepare a bank reconciliation to determine the adjusted (corrected) balance: Bank balance $680 Checkbook balance $642 outstanding checks $112 direct deposits $70 Account fees $12 ATM withdrawals $60 interest earned $8
1.) The information below was used to prepare a bank reconciliation for Lorena Company at October...
1.) The information below was used to prepare a bank reconciliation for Lorena Company at October 31: ∙      According to the bank statement, the bank balance as of October 31 was $8,765. According to the books, the cash balance as of October 31 is $9,557. ∙      Outstanding checks totaled $1,433. ∙      A customer's check for $999 was returned for NSF. ∙      October's service charge was $100. ∙      The bank collected $1,600 from a customer of Lorena Company in payment of...
Use the Following Information to Answer the Questions Below to prepare the Bank Reconciliation 1) If...
Use the Following Information to Answer the Questions Below to prepare the Bank Reconciliation 1) If Any Differences or Errors are found, Assume that Our Business made the mistake and the BANK records are accurate. 2) The Following Items were Included on the Bank Statement from the Schwab Bank for the Month as Follows; Ending Bank Balance at January 31 was $69,000. Monthly Bank Fees of $1,500 NSF Check from Customer H.Clinton for $11,000 Interest Earned During the month was...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT