2 please include all excel formulas
statements using 2024 as the base year.
Each formula must include the ROUND function, rounding all percents to 2 decimal places. (XXX.XX%)
Comparative Income Statements
For Years Ended December 31, 2028-2024
able[[,2028,2027,2026,2025,2024],[Sales,$58,000,$52,000,$48,000,$41,000,$36,000
The comparative income statements of Company follow.Calculate trend percents for all components of the income 3 statements using 2024 as the base year 4 Each formula must include the ROUND function,rounding all percents to 2 decimal places.(XXX.XX% 5 6 Company Comparative Income Statements 8 For Years Ended December 31,2028-2024 9 2028 2027 2026 2025 2024 10 Sales $58,000 $52,000 $48,000 $41,000 $36,000 11 Cost of goods sold 34,000 32,000 25,000 25,000 23,000 12 Gross profit 24,000 20,000 23,000 16,000 13,000 13 Operating expenses 14,000 12,000 12,000 10,000 8,000 14 Net income $10,000 $8,000 $11,000 $6,000 $5,000 15 16 17 18 2028 2027 2026 2025 2024 19 Sales 20 Cost of goods sold 21 Gross profit 22 Operating expenses + 23 Net income 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
40 41 42