Answered step by step
Verified Expert Solution
Link Copied!

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 hereimage text in transcribed

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. exp

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Financial Accounting An IFRS Standards Approach

Authors: Pearl Tan, Chu Yeong Lim, Ee Wen Kuah

4th Edition

9789814821278, 9814821276

More Books

Students also viewed these Accounting questions

Question

Get married, do not wait for me

Answered: 1 week ago

Question

Do not pay him, wait until I come

Answered: 1 week ago

Question

Do not get married, wait until I come, etc.

Answered: 1 week ago