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 places
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
