Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Instructions for Completion of Assignment: Prepare a trial balance, multi-step income statement, statement of retained eamings, and classified balance sheet for Porter Company as of
Instructions for Completion of Assignment: Prepare a trial balance, multi-step income statement, statement of retained eamings, 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 closs is encouraged, though each person must submit their own work The trial balance shouid be completed in the green section. There are exactly enough lines highlighted in green The multi-step income statement should be completed in the yelow section. There are exocty enough nes highighted in that section. The statement of retained earnings should be completed in the grey section. There are exactly enough lines highlighted in that section The classified balance sheet shouid be completed in the blue section. There are exactly enough ines highlighted in thot 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 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 All account names must be populated with a formula and not with hard coded amounts 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 17 Indude line titles and proper and consistent formatting of text and numbers throughout the reports formatting = font, font size, font coor background color justification, etc). 20 Do not put any blank lines anywhere within the reports or financial statements All totals and subtotals must have total lines wher e appropriate. 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: 25 Assigriment must be turned in on Canvas in Excel format 26 27 28 30 31 InstructionsPorter Co. +10% 1ACCT 251 EXCEL ASSIGNMENT PREPARING FINANCIAL STATEMENTS IN EXCEL (see instructions tab for detailed instructions) Prepare a multi-step Prepare a retained earnings statement: Prepare Prepare a triel balance for Porter Company income statement clessified belence sheet: 11 Cost of eoods sold depreciation machine 14 Accumulated depreciation-bull 22Allowance for doubtful accounts Instructions Porter Co. +84% Reacty
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started