Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Complete the Excel Analysis of the Income Statement and Balance Sheet and . Don't forget to comment briefly on your findings. Comparitive Summary Income Sheet

Complete the Excel Analysis of the Income Statement and Balance Sheet and . Don't forget to comment briefly on your findings. image text in transcribed

Comparitive Summary Income Sheet For The Years Ended December 31, 2020 & 2021 2021 Percentage 2020 Percentage Dollars Dollars Revenue: Sales Less: Sales Returns Net Sales 600,000 3,000 597,000 580,000 2,800 577,200 $ Cost Of Merchandise Sold: $ 381,000 $372,000 Gross Profit On Sales: $ 194,000 $181,200 Operating Expenses: Total Selling Expenses Total Administrative Expenses Total Operating Expenses 74,350 73,450 147,800 69,340 70,480 139,820 $ $ Operating Income: $ 46,200 $ 41,380 Other Expenses: Interest Expense 3,400 3,800 Net Income $ 42,800.00 $ 37,580.00 Comment briefly on your findings

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

The Life Audit Take Control Of Your Life Now Every Minutes Counts

Authors: Caroline Righton

1st Edition

978-0340836781

More Books

Students also viewed these Accounting questions

Question

What does the acronym API stand for? What is the role of an API?

Answered: 1 week ago