Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I can not seem to find the answer to blank boxes in this spreadsheet what am I missing here Problem 5-4 Name: Section: Score: 93%
I can not seem to find the answer to blank boxes in this spreadsheet what am I missing here
Problem 5-4 Name: Section: Score: 93% Key Code: 2 Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answer. 1. AZTEC INTERIORS Bank Reconciliation May 31, 2012 Cash balance according to bank statement Add: Deposit of May 31, not recorded by bank $10,956.74 1,043.26 $12,000.00 Deduct outstanding checks: No. 613 No. 632 $137.50 62.40 No. 634 Adjusted balance 503.30 Cash balance according to company's records Add: $7,121.80 Proceeds of note collected by bank, including interest Company error in recording deposit as 331.45 instead of 731.45 Company error in charging check as $328.87 instead of $238.87 $4,160.00 400.00 90.00 Deduct: Check returned because of insufficient funds Bank service charges Adjusted balance $450.00 25.00 Cash balance, April 1 4,650.00 $11,771.80 475.00 11,296.80 $9,578.00 Plus cash deposited in April Less checks written in April Balance per company's records, April 30 703.20 $11,296.80 5,948.81 (8,405.01) $7,121.80 2. Balance Sheet Effects of note collection and correcting company error Statement of Cash Flows O 4,650.00 Effects of NSF check and bank service charge F (475) Assets = Notes/Accts. Cash + Receivable = 4,650.00 (4,000.00) (475) 3. The amount of cash as it should appear on the balance sheet $11,296.80 4. The error should be added to the \"balance according to bank statement," and reported to the bank. 450 Liabilities Accounts Payable + + Stockholders' Equity Retained Earnings (25) Income Statement Sales 160.00 Int. revenue (25.00) Misc. expStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started