Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hey, can anyone help me with this assigning for Byte of Accounting The Byte of Accounting Corporation (Byte). I need the General journal, worksheet, income

Hey, can anyone help me with this assigning for Byte of Accounting The Byte of Accounting Corporation (Byte). I need the General journal, worksheet, income statement, Changes in retained earnings, and Balance sheet in excel.

Description of transactions: 01. June 1: Jeremy, an investor, made an investment in Byte by purchasing 2,194 shares of its common stock paying $35,650.00 in cash, and contributing to Byte computer equipment with a fair market value of $13,800 and office equipment with a fair value of $1,012.

02. June 1: Clay, an investor, made an investment in Byte by purchasing 2,540 shares of its common stock paying $24,150.00 in cash, and contributing to Byte computer equipment with a fair market value of $34,270.

03. June 1: Lauryn, an investor, made an investment in Byte by purchasing 1,800 shares of its common stock paying $41,400.00 in cash.

04. June 2: Check # 6001 was issued to purchase a one-year insurance policy covering its computer equipment. The cost of the insurance is $6,312.00 and paid to Seth's Insurance. The effective date of the policy was June 16 and the invoice number was 2387.

05. June 4: Additional office equipment costing $4,200 was purchased on credit from Perez's Discount Computer Corporation, invoice number AB9865.

06. June 8: Check # 6002 for $32,000 was issued as a down payment for new computer equipment that cost $160,000 on invoice 827364 from Dell. A five-year note was executed by Byte for the balance.

07. June 8: Defective office equipment costing $840 was returned to Perez's Discount Computer for credit to be applied against the outstanding balance owed by Byte.

08. June 14: Check # 6003 was issued for $24,500 as a partial payment on the balance owed to Dell related to the purchase of computer equipment, invoice 827364.

09. June 16: A check in the amount of $6,500 was received for services performed for Pitman Pictures.

10. June 16: Byte purchased a building and the land it is on for $95,000.00 to house its repair facilities and to store computer equipment. The lot on which the building is located is valued at $15,000.00.

The balance of the cost is to be allocated to the building. Check # 6004 was used to make the down payment of $9,500.00. A thirty year mortgage with an inital payement due on August 1st, was established for the balance.

11. June 17: Byte received invoice number 26354 in the amount of $425.00 from Fida Marketing Agency for advertising.

12. June 17: Check # 6005 for $6,000.00 was prepaid for rent of the office space for June, July and August. Put the total amount into the Prepaid Rent account.

13. June 21: Received a bill for $1,265.00 from Computer Parts and Repair Co. for repairs to the computer equipment. The invoice number was 43254.

14. June 21: Billed various miscellaneous local customers $4,800 for consulting services performed.

15. June 21: Accounts payable in the amount of $3,360.00 were paid with Check # 6006.

16. June 22: Check # 6007 was used to pay salaries of $2,505.00 to equipment operators for the week ending June 18. Ignore payroll taxes.

17. June 22: Check # 6008 was used to pay invoice number 26354, the advertising bill that was previously received from Fida Digital Marketing Agency.

18. June 22: Check # 6009 was used to purchase a scanning machine for the office from Sicre's Office Machines Express for $700.00. The invoice number was 975-328.

19. June 23: Purchased office supplies for $505.00 from Office Max on account. The invoice number was 65498.

20. June 23: Received a bill for the amount of $865.00 from O & G Oil and Gas Co. The invoice number was 784537.

21. June 28: Billed various miscellaneous local customers $5,805 for consulting services performed.

22. June 29: Check # 6010 was used to pay invoice number 43254, the computer repair bill that was previously received from Computer Parts and Repair Co.

23. June 29: Byte received $5,500.00 from customers billed when work was completed.

24. June 29: Check # 6011 was used to pay salaries of $2,505.00 to equipment operators for the week ending June 25. Ignore payroll taxes.

25. June 30: Cash in the amount of $3,845 was received on billings.

26. June 30: Paid a cash dividend of $0.20 per share to the three shareholders of Byte, using Check # 6012 - 6014. [IMPORTANT NOTE: The number of shares of capital stock outstanding can be determined from the first three transactions.]

Adjusting Entries - Round to two decimal places =ROUND(number,num_digits).

27. June 30: A physical inventory showed that only $202.00 worth of office supplies remained on hand as of June 30.

28. June 30: The annual interest rate on the mortgage payable was 8.25 percent. Interest expense for one-half month should be computed because the building and land were purchased and the liability incurred on June 16.

29. June 30: Information relating to the prepaid insurance may be obtained from transaction #4. Record a journal entry to reflect that one half month's insurance has expired.

30. June 30: The rent payment made in transaction # 12 was for June, July and August. Expense the amount associated with one month's rent.

31. June 30: A review of Bytes job worksheets show that there are unbilled revenues in the amount of $5,250 for the period of June 28-30.

32. June 30: The accountant has calculated the following depreciation expenses for the month:

Building - $210.32

Computer Equipment - $3,467.83

Office Equipment - $55.02

33. June 30: A review of the payroll records show that unpaid salaries in the amount of $1,503.00 are owed to the employees of Byte for three days, June 28 - 30.

34. June 30: J. Collins, the Internal Auditor, indicated that $1,120.00 of the revenue recorded in June will not be earned until August.

35. June 30: The note payable in transaction #6 and transaction #8 is a five-year note, with interest

at 12%. The June interest expense from this note is $1,031.33.

36. June 30:Income taxes are to be computed at the rate of 25 percent of net income before taxes.

[IMPORTANT NOTE: Since the income taxes are a percent of the net income you will want to prepare the Income Statements through the Net Income Before Tax line. The worksheet contains all of the accounts and their balances which you can then transfer to the appropriate financial statement.]

Closing Entries

37. Close the revenue accounts.

38. Close the expense accounts.

39. Close the dividends account.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting A Practical Approach Chapters 1-25

Authors: Jeffrey Slater, Mike Deschamps

15th Edition

0137504284, 9780137504282

More Books

Students also viewed these Accounting questions

Question

Name the different levels of the hierarchy of needs. (p. 264)

Answered: 1 week ago