Given Information:" Enter a formula in the place of each "?" Make sure to use a conditional statement in cell D33. 1 Cash on hand at the company and not yet deposited at the bank. 5,475 2 EFT for monthly utility bill not yet recorded by the company. 1,200 3 Note collected by the bank and not yet recorded by the company. 8,800 4 Interest collected by the bank from note in #3 not yet recorded by the company. 1,000 5 Debit card used to purchase supplies not yet recorded by the company. 975 6 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. Bank balance at the end of the period. Checkbook at the end of the period. Answers: (a) Bank Reconciliation 2,500 100 2,500 15,800 13,750 Bank Balance: Checkbook Balance: Per statement ? Per Checkbook ? Deposits outstanding ? EFT for utilities ? Checks outstanding ? Note collected ? Interest earned ? Supplies purchased ? Service fee ? NSF checks ? Bank balance per ? Checkbook per reconciliation ? (b) Reconciled? "Use a conditional statement to return a value of "Yes" or "No"