| Prepare a trial balance, multi-step income statement, statement of retained earnings, and classified balance sheet for Porter Company as of December 31, 2017 using the information on the preceeding tab. THERE ARE EXACTLY ENOUGH HIGHLIGHTED LINES FOR EACH ONE |
1ACCT 251 EXCEL ASSIGNMENT PREPARING FINANCIAL STATEMENTS IN EXCEL Prepare a trial balance, multi-step income statement, statement of retained earnings, and classified balance sheet for Porter Company as of December 31, 2017 using the information on the preceeding tab. Working together with others in the cioss 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 highlighted in green. The muiti-step income statement should be compieted in the yellow section. There ore exactiy enough nes highighted in that section. The statement of retoined earnings should be compieted In the grey section. There are exoctly enough ines highlighted in that section. The clossified balonce sheet should be completed in the blue section. There ore exoctly enough lines highlighted in that section All work must be shown on the same tab as the problem titled "Portor Co." tab. All numbers must be formatted with commas and no decimals All numbers much be in numeric format, not in text format. 13 All cells must be the proper width so the content is 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 15 All account names must be populated with a formula and not with hard coded amounts 17 Dollar signs are not necessary anywhere on the reports 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 formatting of text and numbers throughout the reports(formatting Do not put any blank lines anywhere within the reports or financial statements. All totals and subtotals must have total lines where appropriate. font, font size, font color, background color, justification, etc). 20 The only bolded font that should be used is in the titles and the titles of the two main sections of the balance sheet 23 Instructions for Turning In Assignment: Assignment must be turned in on Canvas in Excel format 25 26 28 Prepare a malti-step Prepare a Prepare a Prepare a trial balance for Porter Company: retaised eamines statement classified balance shee: 1Uneamed service revenue d earning strative eipensES 22 Allowance tor doubttul accounts Instructions Porter Co Ready +84%
