Anna decided to open Cygnet Jewellery on 1 August 2021 At first, she will just provide a repair service and then move into jewelry production She contributed equipment valued at $12,000 and shop fittings of $4 000 and deposited $15,000 cash in a business bank account Transactions during August were Aug 4 Took a five year lease on a shop and paid the first 6 months of rent $6 000 4 Purchased office supplies for $260 and paid $100 cash in part payment for these supplies 6 Cash received for minor repair work completed, $350 Completed repair works for a customer and issued an invoice for $200 Purchased tools for $1 600, paying $400 cash with the balance to be paid later Cash revenue earned for repair work, $230 Engaged a part time assistant at an agreed wage of $350 per week Paid petrol $50, postage $10, and electricity bill $230 Cash of $200 received for repair work Earned of $450 for repairs on credit Paid the balance owing for office supplies purchased on 4 August The owner withdrew $100 for her own use Office supplies purchased for $250 on credit Cash revenue received $365 Paid weekly wages to the upholsterer 21 Revenue earned for repairs cash $80, on credit $170 Customer paid $650 of work previously performed on credit Petrol expenses paid $50 Paid weekly wages to the assistant Revenue earned for repair work $390, receiving $100 in cash and the remainder to be paid later A customer paid $350 in advance for repairs to be performed next month Revenue earned for repair work $390, receiving $100 in cash and the remainder to be paid later A customer paid $350 in advance for repairs to be performed next month A customer paid $350 in advance for repairs to be performed next month Office supplies remaining $200 Complete a worksheet in Excel for the month of August using the above data and then on another worksheet, prepare an Income statement and Balance Sheet for the month of August 2021 (these two Excel worksheets must be linked)

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 20, 2021

Anna decided to open Cygnet Jewellery on 1 August 2021. At first, she will just provide a repair service and then move into jewelry production.

Anna decided to open Cygnet Jewellery on 1 August 2021. At first, she will just provide a repair service and then move into jewelry production. She contributed equipment valued at $12,000 and shop fittings of $4 000 and deposited $15,000 cash in a business bank account.

Transactions during August were:

Aug 4 Took a five-year lease on a shop and paid the first 6 months of rent $6 000.

4 Purchased office supplies for $260 and paid $100 cash in part payment for these supplies.

6 Cash received for minor repair work completed, $350.

1. Completed repair works for a customer and issued an invoice for $200.
2. Purchased tools for $1 600, paying $400 cash with the balance to be paid later.
3. Cash revenue earned for repair work, $230.
Engaged a part time assistant at an agreed wage of $350 per week.
Paid petrol $50, postage $10, and electricity bill $230.
Cash of $200 received for repair work.

Earned of $450 for repairs on credit.
Paid the balance owing for office supplies purchased on 4 August.
The owner withdrew $100 for her own use.
Office supplies purchased for $250 on credit.
Cash revenue received $365.
Paid weekly wages to the upholsterer.

21 Revenue earned for repairs: cash $80, on credit $170.

Customer paid $650 of work previously performed on credit.
Petrol expenses paid $50.
Paid weekly wages to the assistant.
Revenue earned for repair work $390, receiving $100 in cash and the remainder to be paid later.
A customer paid $350 in advance for repair’s to be performed next month.
Revenue earned for repair work $390, receiving $100 in cash and the remainder to be paid later.
A customer paid $350 in advance for repairs to be performed next month.
A customer paid $350 in advance for repairs to be performed next month.
Office supplies remaining $200.
Complete a worksheet in Excel for the month of August using the above data and then on another worksheet, prepare an Income statement and Balance Sheet for the month of August 2021 (these two Excel worksheets must be linked).