P$4-3$A The cash records and bank statement for the month of May for Diaz Ertertainment are shown below.

Additional information:

a$.$ The difference in the beginning balances in the company's records and the bank statement relates to checks #$469$ and

#$470,$ which are outstanding as of April $30,2024($prior month$).$

b$.$ The bank made the EFI on May $20$ in error. The bank accidentally charged Diaz for payment that should have been made on

another account.

Required:

Prepare a bank reconciliation for Diaz's checking acoount on May $31,2024.$

Record the necessary cash adjustments.

Prepare the statement of cash flows $($LO$4-7)$

P$4-4$A Below is a summary of all transactions of Pixar Tor Manufacturing for the month of August $2024.$

Required:

Prepare a statement of cash flows for the month of August $2024,$ properly classifying each of the transactions into operating.

investing. and financing activities. The cash balance at the beginning of August is $$25,500.$

Record transactions, post to the Cash T$-$account, and prepare the statement of cash flows $($LO$4-7)$

$($answer both in excel format please$)$