Answered step by step
Verified Expert Solution
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.
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
Get Instant Access to Expert-Tailored 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