Use Excel formulas to compute
the following
Homework Answers
Solution:
| Superior Printing Inc. | |||
| Bank Reconciliation | |||
| At June 30 | |||
| Updates to Bank Statement | Updates to Company's Books | ||
| Ending balance per bank statement | $59,000 | ending cash balance per books | $82,190 |
| Additions: | Additions: | ||
| Deposit in transit | $28,000 | Interest Earned | $30 |
| Deductions: | Deductions: | ||
| Outstanding checks (#109 and 110) | $5,670 | Service Charge | $50 |
| ($770+4900) | NSF Check | $840 | |
| Up to date ending cash balance | $81,330 | Up to date ending cash balance | $81,330 |
Add Answer to:
Use Excel formulas to compute
the following
Superior Printing, Inc. has provided you with its bank...
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...
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...
I know the outstanding checks amount but I don't know how to use excel equation to...
I know the outstanding checks amount but I don't know how to use
excel equation to show the answer
А The June bank statement and the cash T-account for Superior Printing, Inc., is shown below. BANK STATEMENT Deposits Date June 1 Checks Other inin 440 1,200 500 1,200 250 80 9,800 10,000 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 NSF onu 35,000 350 4,600 700 17,000 920 Serv. Charge Interest Earned 59,000 - A...
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...
[The following information applies to the questions displayed below.] Hills Company’s June 30 bank statement and...
[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 Balance Balance, June 1 $ 7,200 Deposits during June $ 18,000 25,200 Checks cleared during June $ 19,100 6,100 Bank service charges $ 30 6,070 Balance, June 30 6,070 Cash (A) June 1 Balance 6,800 June Deposits 19,000 19,400 Checks written June June 30 Balance 6,400 Required: Prepare a bank...
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 $17,800 Balance, June 1 Deposits during June Checks cleared during June Bank service charges Balance, June 30 $18,900 Other Balance $ 7,160 24,960 6,060 $30 6,038 6,830 June 1 June June 30 Balance Deposits Balance Cash (A) 7,160 18,600 19,200 Checks written 6,560 June Required: 1. Prepare a bank...
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 $17, 800 Balance, June 1 Deposits during June Checks cleared during June Bank service charges Balance, June 30 Balance $ 7, 160 24, 960 6,060 6,030 6, 030 $18,900 $30 June 1 June Balance Bala Deposits Cash (A) 7,160 18,600 19,200 Checks written 6,560 June June 30 Balance...
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 $17,200 Balance, June 1 Deposits during June Checks cleared during June Bank service charges Balance, June 30 Other Balance $ 7,040 24, 240 5,940 $30 5,910 5,910 $18,300 June 1 June Balance Deposits Balance Cash (A) 7,040 17,400 18,600 5,840 Checks written June June 30 Required: 1. Prepare a...
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...
Sage Hill Inc.'s bank statement from Main Street Bank at August 31, 2022, gives the following...
Sage Hill Inc.'s bank statement from Main Street Bank at August 31, 2022, gives the following information. Balance, August 1 $18,635 Bank debit memorandum: August deposits 71,235 Safety deposit box fee $ 40 Checks cleared in August 68,663 Service charge 65 Bank credit memorandum: Balance, August 31 21,162 Interest earned 60 A summary of the Cash account in the ledger for August shows the following: balance, August 1, $18,935; receipts $74,235; disbursements $73,555; and balance, August 31, $19,615. Analysis reveals...
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...
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...
I know the outstanding checks amount but I don't know how to use
excel equation to show the answer
А The June bank statement and the cash T-account for Superior Printing, Inc., is shown below. BANK STATEMENT Deposits Date June 1 Checks Other inin 440 1,200 500 1,200 250 80 9,800 10,000 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 NSF onu 35,000 350 4,600 700 17,000 920 Serv. Charge Interest Earned 59,000 - A...
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...
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 $17,800 Balance, June 1 Deposits during June Checks cleared during June Bank service charges Balance, June 30 $18,900 Other Balance $ 7,160 24,960 6,060 $30 6,038 6,830 June 1 June June 30 Balance Deposits Balance Cash (A) 7,160 18,600 19,200 Checks written 6,560 June Required: 1. Prepare a 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 $17, 800 Balance, June 1 Deposits during June Checks cleared during June Bank service charges Balance, June 30 Balance $ 7, 160 24, 960 6,060 6,030 6, 030 $18,900 $30 June 1 June Balance Bala Deposits Cash (A) 7,160 18,600 19,200 Checks written 6,560 June June 30 Balance...
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 $17,200 Balance, June 1 Deposits during June Checks cleared during June Bank service charges Balance, June 30 Other Balance $ 7,040 24, 240 5,940 $30 5,910 5,910 $18,300 June 1 June Balance Deposits Balance Cash (A) 7,040 17,400 18,600 5,840 Checks written June June 30 Required: 1. Prepare a...
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...
Sage Hill Inc.'s bank statement from Main Street Bank at August 31, 2022, gives the following information. Balance, August 1 $18,635 Bank debit memorandum: August deposits 71,235 Safety deposit box fee $ 40 Checks cleared in August 68,663 Service charge 65 Bank credit memorandum: Balance, August 31 21,162 Interest earned 60 A summary of the Cash account in the ledger for August shows the following: balance, August 1, $18,935; receipts $74,235; disbursements $73,555; and balance, August 31, $19,615. Analysis reveals...
Most questions answered within 3 hours.
-
Slow 'n Steady, Inc., has a stock price of $30, will pay a
dividend next year...
asked 8 minutes ago -
During the current financial year, the owner of Omega
Enterprises withdrew supplies of $2,000 for personal...
asked 4 minutes ago -
PLEASE SHOW MATH CALCULATION(formulas)it has to be done on excel
P12-4 Last year (2016), Richter Condos...
asked 13 minutes ago -
A couple of small ice cubes at 0 °C are added to glass of warm
water...
asked 5 minutes ago -
Regarding language development, which of the following
statements is FALSE?
Babies are able to cry from...
asked 7 minutes ago -
A machine shop owner wishes to assign each of three machinists
(labeled 1, 2, and 3)...
asked 7 minutes ago -
A 0.25μF capacitor is charged to 50 V . It is then connected in
series with...
asked 29 minutes ago -
Calculate the current, I, through the batteries for:
- a 2-bulb parallel circuit
- How does...
asked 30 minutes ago -
Choose the sentence that uses correct punctuation.
1a. The prefatory parts of a report include the...
asked 36 minutes ago -
For the element arsenic, which one of the following sets of
quantum numbers could not apply...
asked 46 minutes ago -
Compare and contrast the architectures of 3 types of ADCs:
Flash, SAR, and pipelined. Use the...
asked 47 minutes ago -
Given P(A) = 0.40, P(B) = 0.50, P(A ∩ B) = 0.15. Which of the
following...
asked 51 minutes ago