Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 Patalp commenteren of teenings and a sheet for Porter Company of December 31, 2018 All method be completed in the "Porter work The should be completed in the green section. There are seatly enough g The multistep income statement should be completed in the yellow section. There are exactly enough is highlighted in yellow The balance sheet should be completed in the section. There are exactly enough All numbers must be formatted as numbers with commas and no decimals or dollar signe All cele must be the proper width so the content comply Cel height and fort we may be changed Alas, subt, and calculations must be populated with a famus and not with hard coded amounts Include line and proper and Do not go and brought the reports (nt type font le font color any anywhere in the reports or The only bolded for that should be used in the les and the sites of the two man sections of the bance sheet Agenteumed in as Canvas in Exam Examples of the various statements are shown be BECKHAM SOCCER ACADEMY Adjusted Trial Balance December 3, 2021 EAGLE SOCCER ACADEMY Income Statement For the month ended December 31, 2021 $4000 10:15 2021-Winter ACCT 251 Excel Project 1... Instructions Porter Co ING FINANCIAL STATEMENTS IN EXCEL (see instructions tab for detailed instructions) 2021-Winter ACCT 251 Excel Project 1... Instructions Porter Co ACCT 251 EXCEL PROJECT 1 - PREPARING FINANCIAL STATEMENTS IN EXCEL (see instructions tab for detailed instruc Porter Company financial data: Prepare a multi-stap income statement below: Prepare a retained earnings Prepare a trial balance below: 12/31/18 Service Revenue 1.206,580 Utilities Expense 125,620 Cash 151,360 Accounts receivable 160,000 Common stock 101,360 Payroll Expense 704,420 Buildings 680,000 Other liabilities 6.360 Interest payable 1.150 Land 771,360 Retained eamings 591,680 Supplies expense 17,460 Rent expense 165,170 Dividends 25,820 Accounts payable 202.720 Equipment 270,000 Supplies 181,360 Salaries payable 141,360 Notes payable 1,001,360

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

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Accounting questions