ABC D E F G H 1 ACCT 251 EXCEL PROJECT 1 - PREPARING FINANCIAL STATEMENTS...

Transcribed Image Text:

ABC D E F G H 1 ACCT 251 EXCEL PROJECT 1 - PREPARING FINANCIAL STATEMENTS IN EXCEL 2 3 Instructions for Completion of Assignment: 4 Prepare a trial balance, multi-step income statement, statement of retained earnings, and balance sheet for Porter Company as of December 31, 2021 All statements should be completed in the "Porter Co" worksheet 56 Working together with others in the class is encouraged, though each person must submit their own work. 7 The trial balance should be completed in the green section. There are exactly enough lines highlighted in green. 8 The multi-step income statement should be completed in the yellow section. There are exactly enough lines highlighted in yellow 9 10 The statement of retained earnings should be completed in the grey section. There are exactly enough lines highlighted in grey. The balance sheet should be completed in the blue section. There are exactly enough lines highlighted in blue. 11 All numbers must be formatted as numbers with commas and no decimals or dollar signs. 12 All cells must be the proper width so the content is completely visible. 13 Cell height and font size may not be changed. 14 15 The title section of each report or financial statement must have merged cells so that each line is one cell for each report or statement. 16 17 All totals, subtotals, and calculations must be populated with a formula and not with hard coded amounts. Include line titles and proper and consistent formatting of text and numbers throughout the reports (font type, font size, font color, background color, etc). Do not put any blank lines anywhere within the reports or financial statements. 18 All totals and subtotals must have total lines where appropriate. 19 The only bolded font that should be used is in the titles and the titles of the two main sections of the balance sheet. 20 21 Instructions for Turning In Assignment: 22 Assignment must be turned in on Canvas in Excel format. 23 Examples of the various statements are shown below 24 25 Examples of Financial Statements: 26 EAGLE SOCCER ACADEMY ABC D E F G H 1 ACCT 251 EXCEL PROJECT 1 - PREPARING FINANCIAL STATEMENTS IN EXCEL 2 3 Instructions for Completion of Assignment: 4 Prepare a trial balance, multi-step income statement, statement of retained earnings, and balance sheet for Porter Company as of December 31, 2021 All statements should be completed in the "Porter Co" worksheet 56 Working together with others in the class is encouraged, though each person must submit their own work. 7 The trial balance should be completed in the green section. There are exactly enough lines highlighted in green. 8 The multi-step income statement should be completed in the yellow section. There are exactly enough lines highlighted in yellow 9 10 The statement of retained earnings should be completed in the grey section. There are exactly enough lines highlighted in grey. The balance sheet should be completed in the blue section. There are exactly enough lines highlighted in blue. 11 All numbers must be formatted as numbers with commas and no decimals or dollar signs. 12 All cells must be the proper width so the content is completely visible. 13 Cell height and font size may not be changed. 14 15 The title section of each report or financial statement must have merged cells so that each line is one cell for each report or statement. 16 17 All totals, subtotals, and calculations must be populated with a formula and not with hard coded amounts. Include line titles and proper and consistent formatting of text and numbers throughout the reports (font type, font size, font color, background color, etc). Do not put any blank lines anywhere within the reports or financial statements. 18 All totals and subtotals must have total lines where appropriate. 19 The only bolded font that should be used is in the titles and the titles of the two main sections of the balance sheet. 20 21 Instructions for Turning In Assignment: 22 Assignment must be turned in on Canvas in Excel format. 23 Examples of the various statements are shown below 24 25 Examples of Financial Statements: 26 EAGLE SOCCER ACADEMY