First, calculate the percentage change in sales from 20'X'7 to 20'X'8 in cell G7.calculation for horizontal analysis
Fantastic news! We've Found the answer you've been seeking!
Question:
First, calculate the percentage change in sales from 20'X'7 to 20'X'8 in cell G7.calculation for horizontal analysis in cells G7:G15 for 20'X'8. First, calculate the percentage change in sales from 20'X'7 to 20'X'8 in cell G7. Copy and paste cell G7 into cells G8:G15 to calculate the percentage change of the remaining accounts from 20'X'7 to 20'X'
Year-to-Year | % Sales | Year-to-Year | % Sales | % Sales | |||||||
Net Sales | 1,000,000 | 700,000 | 600,000 | ||||||||
Cost of goods sold | 710,000 | 500,000 | 430,000 | ||||||||
Gross profit on sales | 290,000 | 200,000 | 170,000 | ||||||||
Operating expenses | 240,000 | 160,000 | 120,000 | ||||||||
Operating income | 50,000 | 40,000 | 50,000 | ||||||||
Interest expense | 22,000 | 22,000 | 22,000 | ||||||||
Income (loss) before income tax | 28,000 | 18,000 | 28,000 | ||||||||
Income tax expense (refund) | 13,000 | 6,000 | 9,000 | ||||||||
Net income (loss) | 15,000 | 12,000 | 19,000 | ||||||||
Related Book For
Posted Date: