Question: Using Excel to Determine the Adjusted Cash Balance Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Use mathematical

Using Excel to Determine the Adjusted Cash Balance Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area. For the month of August, Pratt Company has the following information concerning its checking account at its bank.Cash balance per books, August 31$9,500Outstanding checks$800 Determine the adjusted cash balance per books at August 31.Data from the bank statement Charge for printing Pratt Company checks 35 Adjusted cash balance per books Interest earned on checking account balance 40
I NEED THE ACTAUL EXCEL FORMULA AND SET UP! DO NOT ANSWER THE QUESTION WITHOUT THE COMPLETED EXCEL FORMULA INLCUDED!
I NEED THE ANSWER IN THE CORRECT EXCEL FORMULA!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!