Question: provided, complete the following information using the excel template provided. Enter the journal entries to record all of the business activity for the month of

provided, complete the following information using the excel template provided.

  1. Enter the journal entries to record all of the business activity for the month of May.
  2. Compile a trial balance from the journal entries.
  3. Prepare the income statement, statement of changes in equity and balance sheet for your client.
  4. Prepare an email to the accountant to submit with the file. Discuss the following:
    • As you are very ambitious and want to demonstrate your analytical skills, provide your insight on the financial performance of your clients first month of business.
    • After completing the financial statements, the client sent another email to you (see Appendix A). Explain to the accountant how this new information would change the financial statements you already prepared.

Trans No.

Trans Date

Description

Activity type (o,I,f)

1

May 1

I invested $30,000 cash into my new business

F

2

May 3

I bought equipment on account from a supply company name Espresso for $15,000 and paid $7000

I

3

May 5

I bought ingredients for $2,000 cash from Costco

O

4

May 6

I bought furniture on account for $11,000, paid $5,000 as down payment

I

5

May 7

Income for the week is $4,000

O

6

May 9

I bought baking and caf ingredients on account for $2,500

O

7

May 11

Full payment to Espresso for $8,000 which I issued a note for

I

May 14

Income for the week is $8,000

O

May 25

Expenses: Utility $200- Salary $500- Taxes $150

O

May 28

Income for two weeks is $16,000

0

May 30

Withdrew cash for repair the coffee machine $1,500

F

provided, complete the following information using the excel template provided. Enter thejournal entries to record all of the business activity for the monthof May. Compile a trial balance from the journal entries. Prepare theincome statement, statement of changes in equity and balance sheet for yourclient. Prepare an email to the accountant to submit with the file.

hase 2: Journal Entries Use the following worksheet to input journal entries for each accounting transactions described by the client. Note the following: > Include descriptions for each entry. > Round all transaction amounts to the nearest dollar. If the check box at the end of the table is red please recheck your debits equal your credits! Company Name General Ledger Trans No. Trans Date Dr / Cr Acct No. Acct. Name Dr. Amount Cr. Amount Description 3 4. 55 66 67 68 69 70 71 Total 72 73 Check 74 75 1. JE's 2. TB 3a. IS 3b. SCE 3c. BS 4. Email + Instructions Chart of Accounts Accessibility. Investigate Ready Average: 0 Count: 2 Phase 2: Chart of Accounts 3 4 Use the following Chart of Accounts to help you prepare your journal entries, trial balance and financial statements. 5 Do not add new accounts. Use the best fit account instead. 6 7 Company Name 8 Chart of Accounts 9 Assets Liabilities Equity Revenues Expenses Acct No. Name Acct No. Name Acct No. Name Acct No. Name Acct No. Name 100 Cash 300 Accounts Payables 500 Common Shares / Cap 600 Sales 700 Salaries and Wages 12 105 Short Term Investments 310 Salaries and Wages Pay 505 Equity (for non corpor 610 Cost of Goods S 710 Supplies Expense 110 Accounts Receivables 320 Interest Payable 510 Retained Earnings 720 Advertising and Marketing Expense 120 Inventory 330 Taxes Payable 520 Dividends Declared 730 Rent Expense 130 Supplies 340 Unearned Revenue 740 Sales and Marketing Expense 140 Prepaid Expenses 400 Loan Payable 750 Insurance Expense 200 Property, Plant and Equipment (PPE) 760 Interest Expense 201 Accumulated Depreciation - PPE 770 Income Tax Expense PENOPFAT 20 21 22 Phase 2: Trial Balance Use the following to create a trial balance. You may need to use T-Accounts to help you post the correct amounts. Make sure your trial balance it balances! Company Name Trial Balance Month Ended May, 30th, XXX Debit Account No. Account Name 2 105 Short Term Investments 3 110 Accounts Receivables 4 120 Inventory 15 130 Supplies 16 140 Prepaid Expenses 17 200 Property, Plant and Equipment (PPE) 18 201 Accumulated Depreciation - PPE 19 300 Accounts Payables 20 310 Salaries and Wages Payables 21 320 interest Payable 22 330 Taxes Payable 23 340 Unearned Revenue 24 400 Loan Payable 25 500 Common Shares / Capital 26 505 Equity (for non corporations) 27 510 Retained Earnings 28 520 Dividends Declared 29 600 Sales 30 610 Cost of Goods Sold 31 700 Salaries and Wages 32 710 Supplies Expense 33 720 Advertising and Marketing Expense 34 730 Rent Expense 35 740 Sales and Marketing Expense 36 750 Insurance Expense 37 760 Interest Expense Instructions Chart of Accounts Account Financial Credit Mapping Statement Current Assets Balance Sheet Current Assets Balance Sheet Current Assets Balance Sheet Current Assets Balance Sheet Current Assets Balance Sheet Long Term Assets Balance Sheet Long Term Assets Balance Sheet Current Liabilities Balance Sheet Current Liabilities Balance Sheet Current Liabilities Balance Sheet Current Liabilities Balance Sheet Current Liabilities Balance Sheet LT Liabilities Balance Sheet Equity tatement of Change in Equi Equity tatement of Change in Equit Equity tatement of Change in Equit Equity tatement of Change in Equit Revenues Income Statement Revenues Income Statement Expenses Income Statement Expenses Income Statement Expenses Income Statement Expenses Income Statement Expenses Income Statement Expenses Income Statement Expenses Income Statement 1. JE's 2. TB 3a. IS 3b. SCE 3c. BS Readyx Accessibility. Investigate 4 Type here to search LI 2 Phase 2: Income Statement 3 4 5 Company Name Income Statement Month Ended May 30th, XXX 6 7 Revenues 8 9 10 Net Revenues 11 12 Operating Expenses 13 14 15 16 17 18 19 Instructions Chart of Accounts 1. JE's 2. TB 3a. IS Ready Accorribili - Phase 2: Statement of Changes in Equity B 4. Company Name 5 Statement of Financial Position 6 Month Ended May 30th, XXX 7 8 Opening Balance, May 1 9 10 11 12 13 14 15 Balance, May 30 16 17 ro 18

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!