I know the outstanding checks amount but I don't know how to use excel equation to show the answer
Homework Answers
| Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
| Superior Printing Inc. | ||||
| Bank reconciliation statement | Amount $ | Amount $ | ||
| Ending Balance as per bank statement | 59,000.00 | Ending cash Balance as per books | 82,190.00 | |
| Add: | Add: | |||
| Deposit in transit | 28,000.00 | Interest Earned | 30.00 | |
| Less: | Less: | |||
| Outstanding check- 109 | 770.00 | NSF Check | 840.00 | |
| Outstanding check- 110 | 4,900.00 | Service charges | 50.00 | |
| Reconciled balance as per bank | 81,330.00 | Reconciled balance as per books | 81,330.00 |
Add Answer to:
I know the outstanding checks amount but I don't know how to use
excel equation to...
fill out excel at the bottom The June bank statement and the cash T-account for Superior...
fill out excel at the bottom
The June bank statement and the cash T-account for Superior Printing, Inc., is A The June bank statement and the cash T-account for Superior Printing, Inc., is shown below. BANK STATEMENT Deposits Other Checks Date June 1 10,000 440 1,200 500 1,200 250 80 9,800 350 4,600 700 920 NSF 840 Balance 18,500 18,060 16,860 16,360 15,160 24,910 23,990 49,190 48,840 44,240 60,540 59,570 59,000 35,000 17,000 600 Serv. Charge Interest Earned Cash June...
Superior Printing, Inc. has provided you with its bank statement and Cash T-Account for the month...
Superior Printing, Inc. has provided you with its bank statement and Cash T-Account for the month of June. The Controller has asked you to prepare the Bank Reconciliation for the month of June. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=B11" was entered, the...
Use Excel formulas to compute the following Superior Printing, Inc. has provided you with its bank...
Use Excel formulas to compute
the following
Superior Printing, Inc. has provided you with its bank statement and Cash T-Account for the month of June. The Controller has asked you to prepare the Bank Reconciliation for the month of June. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in...
Need help in bank reconciliation and general journal. McDermott Company's bank statement for September 30 showed...
Need help in bank reconciliation and general journal.
McDermott Company's bank statement for September 30 showed an ending cash balance of $1,420. The company's Cash account in its general ledger showed a $1,070 debit balance. The following information was also available as of September 30. • The bank deducted $150 for an NSF check from a customer deposited on September 15. • The September 30 cash receipts, $1,300, were placed in the bank's night depository after banking hours on that...
Brief Exercise 195 Given the following information, determine the adjusted cash balance per books; Balance per...
Brief Exercise 195 Given the following information, determine the adjusted cash balance per books; Balance per books as of June 30 Outstanding checks NSF check returned with bank statement Deposit mailed the afternoon of June 30 Check printing charges Interest earned on checking account $8,800 $600 $130 $300 $30 $40 Adjusted cash balance per books Question Attempts: 0 of 1 used
Required information [The following information applies to the questions displayed below.) Hills Company's June 30 bank...
Required information [The following information applies to the questions displayed below.) Hills Company's June 30 bank statement and the June ledger account for cash are summarized here: BANK STATEMENT Checks Deposits Other $18,500 Balance, June 1 Deposits during June Checks cleared during June Bank service charges Balance, June 30 Balance $ 7,300 25, 800 6, 200 6,169 6, 169 $19, 600 $31 June 1 June Balance Deposits Cash (A) 7, 300 20,000 19,900 Checks written 7, 400 June June 30...
Outstanding checks haven't been presented to the bank for payment but have been subtracted in the...
Outstanding checks haven't been presented to the bank for payment but have been subtracted in the checkbook. have been subtracted on the bank records but not the checkbook records. have been returned to the business for nonpayment. haven't been presented to the bank for payment and haven't been subtracted from the checkbook. Question 2 (5 points) Using the following information, calculate the adjusted cash balance at the end of April. $2.000 Bank statement ending cash balance General ledger cash balance...
Egrane, Inc.'s monthly bank statement showed the ending balance of cash of $14,800. The bank reconciliation...
Egrane, Inc.'s monthly bank statement showed the ending balance
of cash of $14,800. The bank reconciliation for the period showed
an adjustment for a deposit in transit of $1,200, outstanding
checks of $1,600, a NSF check of $560, bank service charges of $24
and the EFT from a customer in payment of the customer's account of
$1,200.
What journal entry should be recorded by Egrane for the NSF
check returned?
MC Qu. 5-150 Egrane, Inc.s monthly bank statement.. grane, Inc.'s...
Required information (The following information applies to the questions displayed below.) The September 30 bank statement...
Required information (The following information applies to the questions displayed below.) The September 30 bank statement for Cadieux Company and the September ledger account for cash are summarized here: BANK STATEMENT Checks Deposits Other NSF check $ 90 $2,730 Balance, September 1 September 7 September 11 September 12 September 17 September 26 September 29 September 30 #101 #102 #103 $ 710 1,520 2,210 Balance $1,820 1,730 4,460 3,750 2,230 20 125 1 15 105 EFT deposit Service charge 10 Balance...
Required information The following information applies to the questions displayed below. The September 30 bank statement...
Required information The following information applies to the questions displayed below. The September 30 bank statement for Cadieux Company and the September ledger account for cash are summarized here: BANK STATEMENT Checks Deposits Other NSF check $ 100 $3,24 Balance, September 1 September 7 September 11 September 12 September 17 September 26 September 29 September 30 #101 #102 #103 $ 889 1,860 2,380 Balance $2,160 2,060 5,3ee 4,420 2,560 180 370 350 190 EFT deposit Service charge Balance Sep 1...
fill out excel at the bottom
The June bank statement and the cash T-account for Superior Printing, Inc., is A The June bank statement and the cash T-account for Superior Printing, Inc., is shown below. BANK STATEMENT Deposits Other Checks Date June 1 10,000 440 1,200 500 1,200 250 80 9,800 350 4,600 700 920 NSF 840 Balance 18,500 18,060 16,860 16,360 15,160 24,910 23,990 49,190 48,840 44,240 60,540 59,570 59,000 35,000 17,000 600 Serv. Charge Interest Earned Cash June...
Superior Printing, Inc. has provided you with its bank statement and Cash T-Account for the month of June. The Controller has asked you to prepare the Bank Reconciliation for the month of June. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=B11" was entered, the...
Use Excel formulas to compute
the following
Superior Printing, Inc. has provided you with its bank statement and Cash T-Account for the month of June. The Controller has asked you to prepare the Bank Reconciliation for the month of June. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in...
Need help in bank reconciliation and general journal.
McDermott Company's bank statement for September 30 showed an ending cash balance of $1,420. The company's Cash account in its general ledger showed a $1,070 debit balance. The following information was also available as of September 30. • The bank deducted $150 for an NSF check from a customer deposited on September 15. • The September 30 cash receipts, $1,300, were placed in the bank's night depository after banking hours on that...
Brief Exercise 195 Given the following information, determine the adjusted cash balance per books; Balance per books as of June 30 Outstanding checks NSF check returned with bank statement Deposit mailed the afternoon of June 30 Check printing charges Interest earned on checking account $8,800 $600 $130 $300 $30 $40 Adjusted cash balance per books Question Attempts: 0 of 1 used
Required information [The following information applies to the questions displayed below.) Hills Company's June 30 bank statement and the June ledger account for cash are summarized here: BANK STATEMENT Checks Deposits Other $18,500 Balance, June 1 Deposits during June Checks cleared during June Bank service charges Balance, June 30 Balance $ 7,300 25, 800 6, 200 6,169 6, 169 $19, 600 $31 June 1 June Balance Deposits Cash (A) 7, 300 20,000 19,900 Checks written 7, 400 June June 30...
Outstanding checks haven't been presented to the bank for payment but have been subtracted in the checkbook. have been subtracted on the bank records but not the checkbook records. have been returned to the business for nonpayment. haven't been presented to the bank for payment and haven't been subtracted from the checkbook. Question 2 (5 points) Using the following information, calculate the adjusted cash balance at the end of April. $2.000 Bank statement ending cash balance General ledger cash balance...
Egrane, Inc.'s monthly bank statement showed the ending balance
of cash of $14,800. The bank reconciliation for the period showed
an adjustment for a deposit in transit of $1,200, outstanding
checks of $1,600, a NSF check of $560, bank service charges of $24
and the EFT from a customer in payment of the customer's account of
$1,200.
What journal entry should be recorded by Egrane for the NSF
check returned?
MC Qu. 5-150 Egrane, Inc.s monthly bank statement.. grane, Inc.'s...
Required information (The following information applies to the questions displayed below.) The September 30 bank statement for Cadieux Company and the September ledger account for cash are summarized here: BANK STATEMENT Checks Deposits Other NSF check $ 90 $2,730 Balance, September 1 September 7 September 11 September 12 September 17 September 26 September 29 September 30 #101 #102 #103 $ 710 1,520 2,210 Balance $1,820 1,730 4,460 3,750 2,230 20 125 1 15 105 EFT deposit Service charge 10 Balance...
Required information The following information applies to the questions displayed below. The September 30 bank statement for Cadieux Company and the September ledger account for cash are summarized here: BANK STATEMENT Checks Deposits Other NSF check $ 100 $3,24 Balance, September 1 September 7 September 11 September 12 September 17 September 26 September 29 September 30 #101 #102 #103 $ 889 1,860 2,380 Balance $2,160 2,060 5,3ee 4,420 2,560 180 370 350 190 EFT deposit Service charge Balance Sep 1...
Most questions answered within 3 hours.
-
BaS crystallizes in a cubic unit cell with S2- ions on each
corner and each face....
asked 28 minutes ago -
A. 0≤P(Oi)≤10≤P(Oi)≤1 for each i
B. P(Oi)≤0P(Oi)≤0
C. P(Oi)=1+P(OCi)P(Oi)=1+P(OiC)
D. P(Oi)≥1P(Oi)≥1
If an experiment consists of...
asked 2 hours ago -
A battery has an emf of 9.20V and an internal resistance of 1.20
ohm. a)What resistance...
asked 2 hours ago -
The area of an elastic circular loop decreases at a constant
rate, dA/dt = −6.60×10−3 m2/s...
asked 3 hours ago -
The denaturation of proteins can be described by the
equilibrium
F⇌U
where F and U represent...
asked 4 hours ago -
Please answer what the maximum and minimum force is, and the
angle on the ion is...
asked 4 hours ago -
implement a program that reads a number of rows and a symbol.
The program will draw...
asked 4 hours ago -
Assume that when adults with smartphones are randomly selected,
45% use them in meetings or classes....
asked 4 hours ago -
Determine the number of formula units of
Na2SO4 and moles of oxygen contained in 8.11
moles...
asked 4 hours ago -
Explain in steps on the following code
What would be the output when executed
using System;...
asked 5 hours ago -
Given the information in the table, which of the following
statements is CORRECT?
Stock A
Stock...
asked 5 hours ago -
Write MARIE assembly language programs that do the following:
Write a program that inputs an integer...
asked 5 hours ago