Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help with requirement 1-5 thank you in advance! Schrute Farms has completed its year-end adjusting entries and prepared an adjusted trial balance. It now

image text in transcribedimage text in transcribed

Need help with requirement 1-5 thank you in advance!

Schrute Farms has completed its year-end adjusting entries and prepared an adjusted trial balance. It now needs to create an income Statement, Statement of Owner's Equity, and Balance Sheet This is the first year of operations so all account beginning balances are zero. Requirements 1 Complete the income Statement and Balance Sheet section of the Worksheet 2 In a separate sheet within this workbook, create and complete an income Statement from the financial data in the Worksheet Appropriate underlining and dollar signs must be included. A double underline should be under the Net income (Loss) amount Expenses should be listed in order of amount largest to smallest with interest expense listed as the last expense even if it is not the smallest amount. 3 In a separate sheet within this workbook, create and complete a Statement of Owner's Equity from the financial data in the Worksheet Appropriate underlining and dollar signs must be included. A double underline should be under the Ending Owner's Equity amount 4 in a separate sheet within this workbook, create and complete a Balance Sheet from the financial data in the Worksheet Appropriate underlining and dollar signs must be included. A double underline should be under the Total Assets and the Total tiabilities and Equity amounts. 5 All amounts should be in comma formatting with no decimals and parenthese for negative numbers. And proper title indenting must be used. Excel Skills 1 Create new sheets within a workbook 2 Format cells using number formats, bold font, cell underlining, etc. 3 Use merge function to create headers for financial statements 4 Use cell referencing within and among worksheets 5 Use SUM function to calculate totals 6 View the workbook as two separate windows Hint The Owner's Equity balance in the adjusted triai balance is the beginning balance plus and owner contributions. When completing the Statement of Owner's Equity, owner contributions are equal to the adjusted trial balance Owner's Capital amount only for the first year of operations

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

Recommended Textbook for

Auditing And Assurance A Case Studies Approach

Authors: LexisNexis

7th Edition

0409343943, 978-0409343946

More Books

Students also viewed these Accounting questions