Formula: Add, Subtract; Cell Referencing Using Excel to Determine the Adjusted Cash Balance PROBLEM For the month of August, Pratt Company has the following information concerning its checking account at its bank. Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area. Cash balance per books, August 31 $ 9,500 Outstanding checks $ 800 Determine the adjusted cash balance per books at August 31. Data from the bank statement Charge for printing Pratt Company checks 35 Interest earned on checking account balance 40 345 Adjusted cash balance per books $ 9,505