Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please please help the struggle is real begin{tabular}{|l|} hline Account Name hline Cash hline Service Revenue hline Supplies Expense hline Cornmon

please please help the struggle is real image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
\begin{tabular}{|l|} \hline Account Name \\ \hline Cash \\ \hline Service Revenue \\ \hline Supplies Expense \\ \hline Cornmon Stock \\ \hline Insurance Expense \\ \hline Equipment \\ \hline Depreciation Expense \\ \hline Accounts Payable \\ \hline Notes Payable \\ \hline Accounts Receivable \\ \hline Interest Expense \\ \hline Retained Eamings \\ \hline Unearned Service Revenue \\ \hline Wages Expense \\ \hline Prepaid Insurance \\ \hline Supplies \\ \hline Interest Payable \\ \hline Accumulated Depreciation-Equipment \\ \hline Dividends \\ \hline Phone Expense \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline Account Number & Account Name \\ \hline 10 & cash \\ \hline 11 & supplies expense \\ \hline 12 & common stock \\ \hline 13 & equitment \\ \hline 14 & prepaid insurance \\ \hline 15 & supplies \\ \hline 16 & dividends \\ \hline 20 & service revenue \\ \hline 21 & depreciation expense \\ \hline 22 & retained earning \\ \hline 30 & insurnace expense \\ \hline 31 & intrest expense \\ \hline 32 & accumulated depreciation equitment \\ \hline 33 & phone expense \\ \hline 40 & accounts payable \\ \hline 41 & notes payable \\ \hline 42 & accounts recelvable \\ \hline 43 & uneamed service revenue \\ \hline 45 & intrest payable \\ \hline 45 & wage expense \\ \hline \end{tabular} 6. Using the list of adjusting entries from the receipt summary page, journalize and post the adjusting transactions. Use the adjusting entries journal workbook page (purple) and the T-account workbook page (blue) on the Excel template to complete this task. 7. Create an adjusted trial balance for May. Use the adjusted trial balance workbook page (brown) on the Excel template to complete this task. 8. From the adjusted trial balance, prepare the financial statements for Yards by Joe. Prepare an Income Statement, Statement of Retained Earnings, and a Balance Sheet. Use the financial statement workbook page (black) on the Excel template to complete this task. 9. Assume that Joe Green completed no more transactions. Using the balances in the ledger accounts, journalize and post the closing entries. Use the closing entries workbook page (pink) and the T-account workbook page (blue) of the Excel template to complete this task. Summary of May receipts 1. Create a chart of accounts for Yards by Joe. Assign a two-digit number to each account name given and arrange accounts in the chart of account order. Use the chart of account workbook page (yellow) on the Excel template to complete this task. 2. Complete the T-account label with the number you have assigned to each account. The account names are already labeled. Use the T-account workbook page (blue) on the Excel template to complete this task. 3. Using information from Joe's receipt summary page, complete the general journal for the month of May. You can omit transaction descriptions. Use the general journal workbook page (red) on the Excel template to complete this task. 4. Post the journal transactions to the T-accounts. Use both the T-account (blue) and general journal workbook pages (red) on the Excel template to complete this task. 5. Create an unadjusted trial balance for May. Use the unadjusted trial balance workbook page (green) on the Excel template to complete this task. \begin{tabular}{|l|} \hline Account Name \\ \hline Cash \\ \hline Service Revenue \\ \hline Supplies Expense \\ \hline Cornmon Stock \\ \hline Insurance Expense \\ \hline Equipment \\ \hline Depreciation Expense \\ \hline Accounts Payable \\ \hline Notes Payable \\ \hline Accounts Receivable \\ \hline Interest Expense \\ \hline Retained Eamings \\ \hline Unearned Service Revenue \\ \hline Wages Expense \\ \hline Prepaid Insurance \\ \hline Supplies \\ \hline Interest Payable \\ \hline Accumulated Depreciation-Equipment \\ \hline Dividends \\ \hline Phone Expense \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline Account Number & Account Name \\ \hline 10 & cash \\ \hline 11 & supplies expense \\ \hline 12 & common stock \\ \hline 13 & equitment \\ \hline 14 & prepaid insurance \\ \hline 15 & supplies \\ \hline 16 & dividends \\ \hline 20 & service revenue \\ \hline 21 & depreciation expense \\ \hline 22 & retained earning \\ \hline 30 & insurnace expense \\ \hline 31 & intrest expense \\ \hline 32 & accumulated depreciation equitment \\ \hline 33 & phone expense \\ \hline 40 & accounts payable \\ \hline 41 & notes payable \\ \hline 42 & accounts recelvable \\ \hline 43 & uneamed service revenue \\ \hline 45 & intrest payable \\ \hline 45 & wage expense \\ \hline \end{tabular} 6. Using the list of adjusting entries from the receipt summary page, journalize and post the adjusting transactions. Use the adjusting entries journal workbook page (purple) and the T-account workbook page (blue) on the Excel template to complete this task. 7. Create an adjusted trial balance for May. Use the adjusted trial balance workbook page (brown) on the Excel template to complete this task. 8. From the adjusted trial balance, prepare the financial statements for Yards by Joe. Prepare an Income Statement, Statement of Retained Earnings, and a Balance Sheet. Use the financial statement workbook page (black) on the Excel template to complete this task. 9. Assume that Joe Green completed no more transactions. Using the balances in the ledger accounts, journalize and post the closing entries. Use the closing entries workbook page (pink) and the T-account workbook page (blue) of the Excel template to complete this task. Summary of May receipts 1. Create a chart of accounts for Yards by Joe. Assign a two-digit number to each account name given and arrange accounts in the chart of account order. Use the chart of account workbook page (yellow) on the Excel template to complete this task. 2. Complete the T-account label with the number you have assigned to each account. The account names are already labeled. Use the T-account workbook page (blue) on the Excel template to complete this task. 3. Using information from Joe's receipt summary page, complete the general journal for the month of May. You can omit transaction descriptions. Use the general journal workbook page (red) on the Excel template to complete this task. 4. Post the journal transactions to the T-accounts. Use both the T-account (blue) and general journal workbook pages (red) on the Excel template to complete this task. 5. Create an unadjusted trial balance for May. Use the unadjusted trial balance workbook page (green) on the Excel template to complete this task

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

Management And Cost Accounting

Authors: Colin Drury

9th Edition

1408093936, 978-1408093931

More Books

Students also viewed these Accounting questions

Question

mple 10. Determine d dx S 0 t dt.

Answered: 1 week ago

Question

How can you develop media literacy?

Answered: 1 week ago