Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Principles And Techniques

Authors: Sanjib Kumar Basu, Andrei Alexandrescu

1st Edition

8177581783, 9788177581782

More Books

Students also viewed these Accounting questions

Question

What are some of the possible scenes from our future?

Answered: 1 week ago