ACCT unit 1 assignment.xlsx - P1-1A Analyze transactions and compute net income On April 1 Julie Spengel established Spengel's Travel Agency The

# ACCT unit 1 assignment.xlsx - P1-1A Analyze transactions...

This preview shows page 1 - 6 out of 17 pages.

P1-1A Analyze transactions and compute net income On April 1, Julie Spengel established Spengel's Travel Agency. The following transactions were completed during the month. 1. Invested \$15,000 cash to start the agency. 2 Paid \$600 cash for April office rent. 3. Purchased equipment for \$3,000 cash. 4. 5. Paid \$900 cash for office supplies. 6. Performed services worth \$10,000: \$3,000 cash is received from customers, and the balance of \$7,000 is billed to customers on account. 7. Withdrew \$600 cash for personal use. 8. 9. Paid employees' salaries \$2,500. 10. Received \$4,000 in cash from customers who have previously been billed in transaction (6). Instructions (a) Prepare a tabular analysis of the transactions using the following column headings: Cash, Accounts Receivable, Supplies, Equipment, Accounts Payable, Owner's Capital, Owner's Drawings, Revenues, and Expenses. (b) From an analysis of the owner's equity columns, compute the net income or net loss for April. NOTE: Enter a number in cells requesting a value; enter either a number or a formula in c (a) SPENGEL'S TRAVE Accounts Accounts Cash + Receivable + Supplies + Equipment = Payable 1. \$15,000 ? = 2. -600 14,400 = 3.ValueValue ?+3,000= 4. Value 14,400 + ? = 700 5.-900Value13,500+900+?=? 6.3,0007,00016,500+?+?+?=? 7.-60015,900+?+?+?=? 8.-500-50015,400+?+?+?=? 9.-2,50012,900+?+?+?=?

#### You've reached the end of your free preview.

Want to read all 17 pages?