Question
Prepare a comparative common-size income statement for Sensible Music Co., using the 2010 and 2009 data of Exercise 13-16A and rounding to four decimal places.
Prepare a comparative common-size income statement for Sensible Music Co., using the 2010 and 2009 data of Exercise 13-16A and rounding to four decimal places. Exercise 13-16A Sensible Music Co. Comparative Income Statements Years Ended December 31, 2010 and 2009 I need this in a spreadsheet and answer this questions: How did you format the cells? Any suggestions where to obtain assistance building the spreadsheet? 2010 2009 Total revenue $852,000 $912,000 Expenses: Cost of goods sold $402,000 $408,000 Selling and general expenses 232,000 261,000 Interest expense 9,200 10,500 Income tax expense 83,000 84,000 Total expenses 726,200 763,500 Net income $125,800 $148,500
1.Exercise 13-16A Sensible Music Co. Comparative Income Statements Years Ended December 31, 2010 and 2009 2010 Total revenue 2009 $852,000 $ Cost of goods sold $402,000 $ Selling and general expenses 232,000 2 Interest expense 9,200 1 Income tax expense 83,000 8 Total expenses 726,200 7 $125,800 $ Expenses: Net income Prepare a comparative common-size income statement for Sensible Music Co., using the 2010 and 2009 data of Exercise 13-16A and rounding to four decimal placesStep 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