12-10 points (use excel) On June 1 of the current year, Pamela Schatz established a business to manage rental property. She completed the following transactions during June 1. Opened a business bank account with a deposit of $55,000 from personal funds, b. Purchased office supplies on account. 3.300. c. Received cash from fees eamed for managing rental property. $18.300. d. Paid rent on office and equipment for the month, $8.300. e Paid credito on account, $2,290 Billed customers for fees earned for managing rental property $30.800 Paid automobile expenses (including rental charges) for the month $1.390, and miscel- laneous expenses $1.800 Paid office salaries 300 Determined that the cost of supplies on hand was $1250; therefore, the cost of up plies used was $2.050, Withdrew cash for personal use. $15.00 Instructions 1. Indicate the effect of each an action and the balance after each transaction, using the following tabular beadings Det C