Homework Help is Here – Start Your Trial Now!
Business
Accounting
ropriate mathematical formula and cell referencing for this. Those were needed.

ropriate mathematical formula and cell referencing for this. Those were needed.

Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter4: Internal Control And Cash
Section: Chapter Questions
Problem 45E
See similar textbooks
icon
Related questions
Question
Please see below. Be sure to include the appropriate mathematical formula and cell referencing for this. Those were needed.
122 fx AB C D F G 1 Formula: Add, Subtract; Cell Referencing 2 3 Using Excel to Determine the Adjusted Cash Balance Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem 4 PROBLEM 5 For the month of August, Pratt Company has the following information 6 concerning its checking account at its bank. area. $ 9,500 Cash balance per books, August 31 Outstanding checks Data from the bank statement 8 $ 800 Determine the adjusted cash balance per books at August 31 9 10 Charge for printing Pratt Company checks 35 Adjusted cash balance per books 11 12 Interest earned on checking account balance 40 13 14 15
Transcribed Image Text:122 fx AB C D F G 1 Formula: Add, Subtract; Cell Referencing 2 3 Using Excel to Determine the Adjusted Cash Balance Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem 4 PROBLEM 5 For the month of August, Pratt Company has the following information 6 concerning its checking account at its bank. area. $ 9,500 Cash balance per books, August 31 Outstanding checks Data from the bank statement 8 $ 800 Determine the adjusted cash balance per books at August 31 9 10 Charge for printing Pratt Company checks 35 Adjusted cash balance per books 11 12 Interest earned on checking account balance 40 13 14 15
Expert Solution
steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Techniques of Time Value Of Money
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Accounting (Text Only)
Accounting (Text Only)
Accounting
ISBN:
9781285743615
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781285866307
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS