Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

EXCEL Assignment # 04 Saved 1 Required information (The following information applies to the questions displayed below.) 5 points In this Applying Excel exercise you

image text in transcribedimage text in transcribedimage text in transcribed

EXCEL Assignment # 04 Saved 1 Required information (The following information applies to the questions displayed below.) 5 points In this Applying Excel exercise you will practice using cell referencing and formulas to create a bank reconciliation. Watch the tutorial video and then complete Parts 1 and 2 to practice and apply the skills demonstrated in the video. X 01:45:39 we eBook www Print References Revise your worksheet to reflect the following transactions and updated values at the end of the accounting period, then answer the questions that follow. (Note: You do not need to upload your revised worksheet for Part 2.) 1 Cash on hand at the company and not yet deposited at the bank. 2 EFT for monthly utility bill not yet recorded by the company. 3 Note collected by the bank and not yet recorded by the company. Interest collected by the bank from note in #3 not yet recorded by the company. 5 A check witten for insurance expense for $80 was cashed. The check was recorded on the books for $140. Checks written by the company but not yet processed by the bank. 7 Service fee charged by bank but not yet recorded by the company. 8 Customer checks determined by the bank to have nonsufficient funds. 5,100 1,600 9,600 1,400 2 2,700 100 3,100 Bank balance at the end of the period. Company balance at the end of the period. 17,680 13,820 Required: 1-a. What is the revised Cash balance at the end of the period? Cash 2-a. What is the balance in Cash if the entry to correct the insurance payment hasn't been made? Cash

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_2

Step: 3

blur-text-image_3

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

Audit Sampling An Introduction

Authors: Dan M. Guy, D. R. Carmichael, O. Ray Whittington

5th Edition

047137590X, 978-0471375906

More Books

Students also viewed these Accounting questions