XLS SAMPLING

xlsx

School

Kenyatta University *

*We aren’t endorsed by this school

Course

402

Subject

Accounting

Date

Nov 24, 2024

Type

xlsx

Pages

4

Uploaded by muthuri.paul

Report
ETA: Data visualization 3-Your Turn: Waterfall & Analysis Blaney Company Income statement for the month ended July 31, 2022. Sales revenue 395,500 Less: sales Discount -8,100 Less: Sales returns and allowances -17,600 Net Sales 369,800 subtotal Cost of goods sold ($200,000) Gross profit 169,800 subtotal Salaries and wages -64,000 Rent expense ($33,600) Insurance expense -12,500 Freight-out -6,400 Income before income taxes 53,300 subtotal Income tax expense -5,100 Net income 48,200 subtotal ANALYSIS (Answer the following questions.) Your Name: NAME By looking at the waterfall chart, in general, which expense category is the greatest for the company? By looking at the waterfall chart, which OPERATING expense is the greatest for the Chapter 5 - Multi-Step Income Statement (waterfall) The income tax expenseas are the greates for the organization the operating expenses before taxes are the grreates twith freight out being great since it is less
company?
Cost of goods sold $200,000 Rent expense Freight-out 6,400 Sales discounts Insurance expense 12,500 Sales returns and allowances Salaries and wages expense 64,000 Sales revenue Income tax expense 5,100 INSTRUCTIONS: Use the following data to prepare the Income Statement for Blaney Compan 31, 2022. Your income statement should only have formulas or functions and cell references. This chart isn't available in your version of Excel. Editing this shape or saving this workbook into a different file format will permanently break the chart.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$33,600 8,100 17,600 395,500 ny for the month ended July .