Intruction Aston ACC Winter 2002 - DAJES Ausled Tube A ERROR FULL Attestation Duna und Jesshed To Bence Part 1 TTTTTT ET DAJES Adjusted Til Balance matrime Attestation Part 2 Instructions Anton Abris Part 3 Dute and AJE Afted Trial Balance Financial Statement DAJE Tra ta) Part Reversing Subashi General Journal Instructions Attestation Rubric Data and AJES Adjusted Trial Balance Financial Statements ACC2202 - Winter 2022 - Excel Assignment #1 This assignment may be completed in groups of 2-3 students OR may be completed individually NO MORE THAN THREE STUDENTS You must submit your completed Excel file via Brightspace by the due date indicated on Brightspace and on your course schedule I do NOT need to know in advance if you are working with a team BUT...It is 100% your responsibility to ensure your name is indicated in the submitted file. Once files are submitted, that's it, they're submitted Submit only one file for each group. Each group member will receive the same grade. (If you do not submit on time, you will receive a grade of '). Assignment Instructions: Note: This company uses the alternative method and also uses reversing entries. Using the company data provided on the Data tab and Adjusted Trial Balance tab, prepare the following: 1 Adjusting journal entries required at the year-end. December 31, 2021. Use the General Journal Page provide on the "DATA and AJE's" tab, starting at row 54 2 Post the adjusting entries to the "Adjustments columns (D and F) on the "Adjusted Trial Balance" tab, and prepare the resulting adjusted trial balance. a Reference the adjusting journal entry number in the column provided 3 Prepare financial statements for the year ended December 31, 2021 in good format - no abbreviations allowed, with all necessary underlines & currency symbols Single-Step Income Statement Report expense accounts from highest to lowest amounts Statement of Owner's Equity Classified Balance Sheet 4 Prepare the reversing entries and subsequent cash entries SEE THE RUBRIC FOR FULL MARKS BREAKDOWN. THIS ASSIGNMENT INCLUDES MARKS FOR FORMATTING AND CELL REFERENCING Rename your Excel file using your own names as the file name, for example: "Mohamad and Anne.xlsx" Late assignments will not be accepted. Each student in the group MUST enter their name on the INSTRUCTIONS tab and the Declaration area in the ATTESTATION tab of this Excel file Technical Requirements: There are 7 other tabs to this Excel file. please complete the tasks required in each tab You must une coll references and formular in all collo (with the exception of account names for the Statement of Owner's Equity), As well, all calculations must be shown to the side of your cell where calculations are required Brightspace - submit your finished Excel filo into Brightspace for grading, One team member should submit the file for all team members and the file name will be your 5 All numbers MUST be presented in proper number format-1.0 100000 is WRONGI 100,000 is CORRECTH Marks will be deducted if incorrect number format is All work must be in Arial font size 12. This assignment will include substantial marks for formatting and cell referencing Good formatting includes neat, legible work, with font size and style, and number for throughout Excel also has a spell check feature to catch misspelling of words Group Member Names and Student Numbers: 1 2 3 4 7 2 3 Mandatory Student number Mandatory Student number Mandatory Student number Yuri You must add your Attestation Rubric Financial Statements Instructions Part 1 Data and AJES Adjusted Trial Balance Demet Batee Receive Introve S Anh red KS Str. Gm www De LU bertention 22 www. New to you awaane Me Sway On Marco Thes wy www 02D en de 1.2021. The y movie 2003 Bele A PT Instructions Financial Statements Part 2 Account Name Attestation Rubric Data and AJES Adjusted Trial Balance Denmark Consulting Unadjusted Trial Balance at December 31, 2021 Adjustments Required for Year End Adjusted Trial Balance for December 31, 2021 Credit Debit Ref Credit Ref Debit Credit Debit $24.200 38.500 75.000 0 0 0 72,000 Cash Accounts receivable Note receivable Interest receivable Supplies Prepaid insurance Furniture Accumulated depreciation-furniture Accounts payable Salaries payable Unearned revenue K. Smeltz, capital K. Smeltz, withdrawals Consulting revenue Interest revenue Salaries expense Rent expense Insurance expense Utilities expense Depreciation expense Supplies expense Totals $13.800 18.400 0 0 76.750 46.000 166,125 375 32.000 33 000 3,450 2.300 6,600 2,400 275,450 276,4501 Attestation Rubric Data and AJES Adjusted Trial Balance Financial Statements Instructions Part 3 Instructions Attestation Rubric Data and AJES Adjusted Trial Balance Financial Statements Part 4 Reversing Entries Date Accounts Dr Cr Subsequent Cash Entries General Journal Date Account Intruction Aston ACC Winter 2002 - DAJES Ausled Tube A ERROR FULL Attestation Duna und Jesshed To Bence Part 1 TTTTTT ET DAJES Adjusted Til Balance matrime Attestation Part 2 Instructions Anton Abris Part 3 Dute and AJE Afted Trial Balance Financial Statement DAJE Tra ta) Part Reversing Subashi General Journal Instructions Attestation Rubric Data and AJES Adjusted Trial Balance Financial Statements ACC2202 - Winter 2022 - Excel Assignment #1 This assignment may be completed in groups of 2-3 students OR may be completed individually NO MORE THAN THREE STUDENTS You must submit your completed Excel file via Brightspace by the due date indicated on Brightspace and on your course schedule I do NOT need to know in advance if you are working with a team BUT...It is 100% your responsibility to ensure your name is indicated in the submitted file. Once files are submitted, that's it, they're submitted Submit only one file for each group. Each group member will receive the same grade. (If you do not submit on time, you will receive a grade of '). Assignment Instructions: Note: This company uses the alternative method and also uses reversing entries. Using the company data provided on the Data tab and Adjusted Trial Balance tab, prepare the following: 1 Adjusting journal entries required at the year-end. December 31, 2021. Use the General Journal Page provide on the "DATA and AJE's" tab, starting at row 54 2 Post the adjusting entries to the "Adjustments columns (D and F) on the "Adjusted Trial Balance" tab, and prepare the resulting adjusted trial balance. a Reference the adjusting journal entry number in the column provided 3 Prepare financial statements for the year ended December 31, 2021 in good format - no abbreviations allowed, with all necessary underlines & currency symbols Single-Step Income Statement Report expense accounts from highest to lowest amounts Statement of Owner's Equity Classified Balance Sheet 4 Prepare the reversing entries and subsequent cash entries SEE THE RUBRIC FOR FULL MARKS BREAKDOWN. THIS ASSIGNMENT INCLUDES MARKS FOR FORMATTING AND CELL REFERENCING Rename your Excel file using your own names as the file name, for example: "Mohamad and Anne.xlsx" Late assignments will not be accepted. Each student in the group MUST enter their name on the INSTRUCTIONS tab and the Declaration area in the ATTESTATION tab of this Excel file Technical Requirements: There are 7 other tabs to this Excel file. please complete the tasks required in each tab You must une coll references and formular in all collo (with the exception of account names for the Statement of Owner's Equity), As well, all calculations must be shown to the side of your cell where calculations are required Brightspace - submit your finished Excel filo into Brightspace for grading, One team member should submit the file for all team members and the file name will be your 5 All numbers MUST be presented in proper number format-1.0 100000 is WRONGI 100,000 is CORRECTH Marks will be deducted if incorrect number format is All work must be in Arial font size 12. This assignment will include substantial marks for formatting and cell referencing Good formatting includes neat, legible work, with font size and style, and number for throughout Excel also has a spell check feature to catch misspelling of words Group Member Names and Student Numbers: 1 2 3 4 7 2 3 Mandatory Student number Mandatory Student number Mandatory Student number Yuri You must add your Attestation Rubric Financial Statements Instructions Part 1 Data and AJES Adjusted Trial Balance Demet Batee Receive Introve S Anh red KS Str. Gm www De LU bertention 22 www. New to you awaane Me Sway On Marco Thes wy www 02D en de 1.2021. The y movie 2003 Bele A PT Instructions Financial Statements Part 2 Account Name Attestation Rubric Data and AJES Adjusted Trial Balance Denmark Consulting Unadjusted Trial Balance at December 31, 2021 Adjustments Required for Year End Adjusted Trial Balance for December 31, 2021 Credit Debit Ref Credit Ref Debit Credit Debit $24.200 38.500 75.000 0 0 0 72,000 Cash Accounts receivable Note receivable Interest receivable Supplies Prepaid insurance Furniture Accumulated depreciation-furniture Accounts payable Salaries payable Unearned revenue K. Smeltz, capital K. Smeltz, withdrawals Consulting revenue Interest revenue Salaries expense Rent expense Insurance expense Utilities expense Depreciation expense Supplies expense Totals $13.800 18.400 0 0 76.750 46.000 166,125 375 32.000 33 000 3,450 2.300 6,600 2,400 275,450 276,4501 Attestation Rubric Data and AJES Adjusted Trial Balance Financial Statements Instructions Part 3 Instructions Attestation Rubric Data and AJES Adjusted Trial Balance Financial Statements Part 4 Reversing Entries Date Accounts Dr Cr Subsequent Cash Entries General Journal Date Account