Project Assignment: Comprehensive Accounting Project
Team, you have been called in to help James Miller who has operated a part-time architectural business from his home. His accountant has decided to quit working for him and Miller has decided he needs a more organized approach to keeping his accounting records. (Miller has kept his accounting records in a big file cabinet). Miller has decided to move to a rented office space and is planning to operate the business on a full-time basis. The business will be known as Miller Architects, Inc. Miller also has the following transactions that took place during the month of June 20XX:
1. June 1. The following assets were received from James Miller in exchange for common stock: Cash, $ 23,400; accounts receivable, $ 4,000; supplies, $1,900 and Office Equipment, $ 15,500. There were no liabilities received.
2. June 1. Paid six months' rent in advance on a lease rental contract, $ 6,000.
3. June 2. Paid the premiums on property and casualty insurance policies, $ 2,400. ( The policy is for six months)
4. June 4. Received cash from the Smith Company as an advance payment for services to be provided and it will be recorded as unearned fees for $ 5,000.
5. June 5. Purchased a new computer on account from Stone's Computer Nook for $ 3,000. The useful life has been determined to be 5 years.
6. June 6. Received cash from clients on account for $ 2,200.
7. June 9. Paid cash to Greenfield Tribune for a newspaper advertisement, $ 150.
8. June 12. Recorded services provided on account to various clients for the period of June 1 thru 12, for $ 4,900.
9. June 13. Paid Stone's Computer Nook for part of the liability incurred on June 5, $ 750.
10. June 14. Paid part-time receptionist for two weeks' salary, $ 900.
11. June 17. Paid cash for supplies, $ 900.
12. June 20. Purchased additional office equipment on account from Merrick Office Supply store for $ 2,500.
13. June 20. Recorded services provided on account to various clients for the period of June 13-20, $ 3,100.
14. June 24. Received cash from clients for fees earned during the period of June 17 thru 24, $ 5,400.
15. June 26. Received cash from clients on account from June 12 services, $ 2,000.
16. June 27. Paid part-time receptionist for two weeks salary, $ 900.
17. June 29. Paid telephone bill for June, $ 320.
18. June 29. Paid electricity bill for June, $ 485.
19. June 30. Recorded cash from clients for fees earned for the period of June 25-30, $ 3,200.
20. June 30. Recorded services provided on account for the remainder of June, $ 1,700.
21. June 30. Paid dividends of $ 3,000.
Possible adjustment data for Miller Architects as of June 30, 20XX:
1. Insurance expired during June is $400.
2. Supplies on hand on June 30 is $ 2,250.
3. Monthly depreciation of office equipment is $ 300.
4. Monthly depreciation of computer is $ 50
5. Rent expired during June is $1,000.
6. Accrued receptionist salary on June 30 is $ 150.
7. Unearned fees on June 30 is $ 4,000.
Deliverables for this project:
a. Your job is to review the transactions and help Miller Architects, Inc. develop a chart of accounts that Miller Architects, Inc. will utilize in the future.
b. Your next task to record these transactions using Excel. You will need to create a general journal and a general ledger for Miller Architects
After the recording the transactions and posting the transactions into the general journal and general ledger that you have created, please complete the following tasks:
a. Prepare an unadjusted trial balance.
b. Prepare the adjusting entries and post to the general ledger.
c. Prepare an adjusted trial balance.
d. Prepare the financial statements for the month of June.
e. Prepare the closing entries for the month of June and post to the general ledger.
f. Prepare a post-closing trial balance for the month of June.
Suggested practice: Create tabs in the excel worksheet to help with each of these tasks.
Final Requirement: Once these tasks are completed please prepare a PowerPoint presentation using VoiceThread or Webex that will highlight the following:
a. Creation of your chart of accounts
b. General Journal Entry Presentation
c. Creation of General Ledger which highlights posting of transactions for the month along with posting the adjusting and closing entries.
d. Unadjusted Trial Balance
e. Adjusted Trial Balance
f. Financial Statement Preparation
g. Closing Entry Preparation
h. Post-Closing Trial Balance
i. 1 page memo recommendation to Miller regarding the possibility of acquiring an accounting package to meet the needs of his organization.
Format your assignment according to the give formatting requirements:
a. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
b. The response also includes a cover page containing the title of the assignment, the course title, the student's name, and the date. The cover page is not included in the required page length.
c. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.