Mullins Corp. reported the following items on its June 30, 2023 trial balance and on its comparative trial balance one year earlier:

(a) Determine the June 30, 2023 cash and cash equivalents amount for the 2023 statement of cash flows, and calculate the change in cash and cash equivalents since June 30, 2022.

(b) Create a waterfall chart using Excel to visualize the changes in the cash and cash equivalent balances from June 30, 2022, to June 30, 2023.

Transcribed Image Text:

Cash in bank Petty cash Investment in shares of GTT Ltd. (to be sold within 60 days) Investment in Canada 60-day treasury bills Accounts payable Temporary bank overdraft, chequing account June 30, 2023 $12,100 700 6,500 22,000 66,300 13,800 June 30, 2022 $ 9,460 525 -0- 69,225 1,000