Formula: Add, Subtracts Cell Referensing

Using Excel to Determine the Adjusted Gash Balance

PROBLEM

For the month of August, Pratt Company has the following information concerning its checking account at its bank.

Cash balance per books, August $31$

Outstanding checks

Data from the bank statement

Charge for printing Pratt Company checks Interest earned on checking account balance

Student Work Area

Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area.

$$,9,500$

$$,800$

$35$

$40$

Determine the adjusted cash balance per books at August $31.$

$$ Adjusted cash balance per books