Chapter 7: Q7-7TI (page 404)
The Scott Sun & Shade Company had the following financial data at December 31, 2018:
Cash and cash equivalents $ 60,000
Total current liabilities 75,000
What is the cash ratio as of December 31, 2018, for Scott Sun & Shade?
Answer:
The cash ratio of the company is 0.80.
Over 30 million students worldwide already upgrade their learning with Vaia!
All the tools & learning materials you need for study success - in one app.
Get started for free
What are some limitations of internal controls?
Using Excel for a Bank Reconciliation
Download an Excel template for this problem online in MyAccountingLab or athttp://www.pearsonhighered.com/Horngren.
Lori Anders of Wilderness Associates is getting ready to prepare the October bank reconciliation.
The cash balance on the books of Wilderness Associates on October 31 is \(3,546.
Lori reviews the bank statement, and notes the checking account balance at October 31 is \)2,445. The bank statement also
reveals that the bank collected a note receivable on behalf of Wilderness Associates—the principal was \(1,500 and the interest
was \)15. One customer’s check for \(29 was returned by the bank for insufficient funds. Two additional items on the bank statement
were the monthly EFT for the utilities, \)250, and the bank service fee of \(12. Lori notes that the cash deposit made on
October 31 of \)3,300 does not appear on the statement, and that three checks totaling $975 had not cleared the bank account
when the bank statement was prepared.
Requirements
1. Prepare the bank reconciliation for Wilderness Associates at October 31, 2018. Format appropriate cells with dollar signs and double
underlines. Use Excel formulas to calculate subtotals and totals.
2. Journalize the entries based on the bank reconciliation. For dollar amounts, use cell references on bank reconciliation
Conduct an Internet search for information on internal control and the Sarbanes-Oxley Act. Write a report of your findings. In your account, discuss some of the advantages and disadvantages of the Sarbanes-Oxley Act. Present it to your class (if required by your instructor).
Preparing a bank reconciliation
Hardy Photography’s checkbook lists the following:
Date Check No. Item Check Deposit Balance
Nov. 1 \( 500
4 622 Quick Mailing \) 45 455
9 Service Revenue \( 135 590
13 623 Photo Supplies 85 505
14 624 Utilities 45 460
18 625 Cash 50 410
26 626 Office Supplies 110 300
28 627 Upstate Realty Co. 290 10
30 Service Revenue 1,235 1,245
Hardy’s November bank statement shows the following:
Learning Objective 6
1. Adjusted Balance \)1,137
Balance
Deposits
Checks: No. Amount
622 \( 45
623 85
624 105*
625 50
Other charges:
Printed checks
Service charge
Balance
*This is the correct amount for check number 624.
\) 500
135
(285)
(48)
$ 302
23
25
Requirements
1. Prepare Hardy Photography’s bank reconciliation at November 30, 2018.
2. How much cash does Hardy actually have on November 30, 2018?
3. Journalize any transactions required from the bank reconciliation.
What are the controls needed to secure the petty cash fund?
What do you think about this solution?
We value your feedback to improve our textbook solutions.
