Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
what information is needed? Assignment 9 Enter the income statement and balance sheet found in the Income Statement.JPG and Balance Sheet.JPG files on separate worksheets.
what information is needed? Assignment 9 Enter the income statement and balance sheet found in the Income Statement.JPG and Balance Sheet.JPG files on separate worksheets. You must do the following for the income statement and balance sheet: o include all of the headings o the company name, financial statement name, and data must be centered in a single merged cell with each on a separate line use formulas to calculate all of the totals and subtotals o include all of the underlines and double-underlines o all numbers must be formatted as Accounting; however, only include $ signs where they exist in Dixon's financial statements o do not include the boxes shown in the pictures O Calculate the following business formulas from chapter 10. These calculations must be on a separate worksheet (the third worksheet used in the assignment). 1. Calculate the sales to current assets ratio. 2. Calculate the gross margin percentage. 3. Calculate the sales to inventory ratio. 4. Calculate working capital. 5. Calculate the current ratio. 6. Calculate the sales to accounts payable ratio. . The order of the worksheets in the submitted assignment must be as follows: First (left): The worksheet with the business formula calculations Second (middle): The worksheet with the income statement Last (right): The worksheet with the balance sheet . . Dixon Sporting Goods Income Statement Multiple Step Format) For the Year Ended December 31, 2017 5357.00 2015100 S Comoros Cold Gross profit 312200 $4300 750 22.000 33975 Operating expenses Selling expenses Deprecaten en toe furniture and totul Advertising Sand we Total selling expenses General and administrative expenses Direction on buildings and amortisation of trema Sand was Etance S. Total general and administrative expenses Total operating expenses -Income from operations 5.000 15000 3.000 OS 6000 231600 Other revenues and expenses test expende Excess of other expenses over other revenue Income before income taxes $1.500 16000 15.00 5 58200 Income tax expen Net income 17.200 $ 41000 Al AT Tartu w THE 120 1900 Town Total BROOKNOLORITY Tata BA Tutsal Dixon Sporting Goods Income Statement Multiple Step Format) For the Year Ended December 31, 2017 5357.00 2015100 S Comoros Cold Gross profit 312200 $4300 750 22.000 33975 Operating expenses Selling expenses Deprecaten en toe furniture and totul Advertising Sand we Total selling expenses General and administrative expenses Direction on buildings and amortisation of trema Sand was Etance S. Total general and administrative expenses Total operating expenses -Income from operations 5.000 15000 3.000 OS 6000 231600 Other revenues and expenses test expende Excess of other expenses over other revenue Income before income taxes $1.500 16000 15.00 5 58200 Income tax expen Net income 17.200 $ 41000 Al AT Tartu w THE 120 1900 Town Total BROOKNOLORITY Tata BA Tutsal
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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