2021-Winter ACCT 251 Excel Project 1... Instructions Porter Co ACCT 251 EXCEL PROJECT 1 - PREPARING FINANCIAL STATEMENTS IN EXCEL Instructions for Completion of Assignment: Prepare a trial balance, multi-step income statement, statement of retained earnings, and balance sheet for Porter Company as of December 31, 2018 All statements should be completed in the "Porter Co" worksheet Working together with others in the class is encouraged, though each person must submit their own work The trial balance should be completed in the green section. There are exactly enough Ines highaghted in groen The multi-step income statement should be completed in the yellow section. There are exactly enough lines highlighted in yellow The statement of retained eamings 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. All numbers must be formatted as numbers with commas and no decimals or dollar signs All cells must be the proper width so the content in completely visible. Cell height and font size may not be changed All totals, subtotals, and calculations must be populated with a formula and not with hard coded amounts. 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 Include line titles and proper and consistent formating 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 All totals and subtotals must have total Ines where appropriate The only bolded fant that should be used is in the tides and the titles of the two main sections of the balance sheet. Instructions for Turning In Assignment: Assignment must be turned in on Canvas in Excel format Examples of the various statements are shown below BECKHAM SOCCER ACADEMY S Adjusted Trial Balance December 31, 2021 Dunda Supplies Exe Rent Expe T EAGLE SOCCER ACADEMY Income Statement For the month ended December 31, 2021 (. EAGLE SOCCER ACADEMY For the month ended December 31, 2021 Stockholders Equity 25.000 Service revenue Adt Net income for the pred 1300 1,900 Le Dividends Ending bance Dec 200 $25,000 300 Rentexpense 500 Sp 1,000 THE COMPUTER SHOP December 31, 2021 Salaries expense 3,100 Usities expense 900 Can 4300 Inexpens 100 2400 $10,000 1.000 26.000 $4,000 Notes ple 10.000 Other expenses Common stack 19,000 100 11.000 Total expe 6,000 $44,000