Income statements for Solomon Company for Year 3 and Year 4 follow
Financial AccountingFinancial Statements
The textbook question
Income statements for Solomon Company for Year 3 and Year 4 follow:
SOLOMON COMPANY
Income Statements
| Year 4 | Year 3 | |
|---|---|---|
| Sales | $200,200 | $180,200 |
| Cost of goods sold | 142,500 | 120,500 |
| Selling expenses | 21,200 | 19,200 |
| Administrative expenses | 12,500 | 14,500 |
| Interest expense | 3,300 | 5,300 |
| Total expenses | $179,500 | $159,500 |
| Income before taxes | 20,700 | 20,700 |
| Income taxes expense | 6,100 | 3,800 |
| Net income | $14,600 | $16,900 |
Required
a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4.
b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year.
Below is the Accuity problem: the same method with different numbers. We solve ours, so work through it and you'll know how to solve yours.
The Accuity problem
Sales at Accuity grew in Year 4, yet the bottom line shrank. Before the year-end planning meeting, the finance lead laid the last two income statements side by side to find out where the money went.
| Accuity — Income Statements (in $) | Year 4 | Year 3 |
|---|---|---|
| Sales | 220,000 | 195,000 |
| Cost of Goods Sold | 156,000 | 132,000 |
| Gross Profit | 64,000 | 63,000 |
| Selling Expenses | 23,500 | 20,800 |
| Administrative Expenses | 13,200 | 15,000 |
| Interest Expense | 2,900 | 4,600 |
| Total Expenses | 195,600 | 172,400 |
| Income Before Taxes | 24,400 | 22,600 |
| Income Tax Expense | 7,300 | 4,900 |
| Net Income | 17,100 | 17,700 |
- Prepare a horizontal analysis: for every line on the statement, find the percent change from Year 3 to Year 4.
- Prepare a vertical analysis: for each year, express every line as a percent of that year's sales.
An Accuity original. We write our own version of each problem and solve it from scratch, so you learn the method rather than copying an answer.
Video solution
Covers the full step-by-step solution below, start to finish.

Solved by
Jake Glidden, CPA, MSA
Founder of Accuity
Jake started Accuity while studying accounting at UCF and has worked with hundreds of students in introductory and upper-level accounting classes. Accuity solutions are checked against the textbook before they're published.
Certified Public Accountant (CPA) · B.S.B.A. in Accounting, UCF · M.S. in Accounting, UCF
More about Accuity →Step-by-step solution
The same steps the video works through, written out.
This problem tests the two basic tools of financial statement analysis.
- Horizontal analysis compares the same line across years: % change = (Year 4 − Year 3) ÷ Year 3. The older year is always the base.
- Vertical analysis compares each line to a base within the same year. On an income statement the base is sales, so sales is always 100%.
One thing to watch on this statement: Total Expenses already includes cost of goods sold (156,000 + 23,500 + 13,200 + 2,900 = 195,600). Gross Profit is just a subtotal shown in the middle. Analyze it like any other line, but don't add it into the expenses.
Requirement 1 — Horizontal analysis
Sales: (220,000 − 195,000) ÷ 195,000 = 25,000 ÷ 195,000 = 12.8%
| Line | Year 4 | Year 3 | $ change | % change |
|---|---|---|---|---|
| Sales | 220,000 | 195,000 | 25,000 | 12.8% |
| Cost of goods sold | 156,000 | 132,000 | 24,000 | 18.2% |
| Gross profit | 64,000 | 63,000 | 1,000 | 1.6% |
| Selling expenses | 23,500 | 20,800 | 2,700 | 13.0% |
| Administrative expenses | 13,200 | 15,000 | (1,800) | (12.0%) |
| Interest expense | 2,900 | 4,600 | (1,700) | (37.0%) |
| Total expenses | 195,600 | 172,400 | 23,200 | 13.5% |
| Income before taxes | 24,400 | 22,600 | 1,800 | 8.0% |
| Income tax expense | 7,300 | 4,900 | 2,400 | 49.0% |
| Net income | 17,100 | 17,700 | (600) | (3.4%) |
Requirement 2 — Vertical analysis
Year 4 cost of goods sold: 156,000 ÷ 220,000 = 70.9%. Year 3: 132,000 ÷ 195,000 = 67.7%.
| Line | Year 4 | Year 3 |
|---|---|---|
| Sales | 100.0% | 100.0% |
| Cost of goods sold | 70.9% | 67.7% |
| Gross profit | 29.1% | 32.3% |
| Selling expenses | 10.7% | 10.7% |
| Administrative expenses | 6.0% | 7.7% |
| Interest expense | 1.3% | 2.4% |
| Total expenses | 88.9% | 88.4% |
| Income before taxes | 11.1% | 11.6% |
| Income tax expense | 3.3% | 2.5% |
| Net income | 7.8% | 9.1% |
What the numbers say
Cost of goods sold grew faster than sales (18.2% vs 12.8%), so gross margin slid from 32.3% to 29.1%. Lower admin and interest costs saved most of it, but a 49% jump in taxes pushed net income down 3.4%.
Horizontal: sales +12.8%, cost of goods sold +18.2%, net income −3.4%. Vertical: net income is 7.8% of sales in Year 4 vs 9.1% in Year 3.
Where students go wrong
- Dividing by the wrong year. The base for a percent change is the earlier year (Year 3), not Year 4.
- Adding gross profit into total expenses. It's a subtotal, and cost of goods sold is already in the 195,600.
More Financial Statements problems
- Following is the balance sheet of Campbell Company for Year 3This problem tests calculation of six key financial ratios from balance sheet and income data: liquidity ratios (current and quick), profitability metrics (EPS, ROI, ROE), and leverage (debt-to-equity). Solutions require identifying current assets/liabilities and applying standard ratio formulas.
- The following data come from the financial records of Solomon CorporationThis problem tests your ability to calculate the times interest earned ratio, which measures how many times a company's earnings can cover its interest obligations. The ratio is computed by dividing earnings before interest and taxes by interest expense.
- Astro Corporation was started by issuing 5,200 shares of $9 par stockTests preparation of four interconnected financial statements from startup data. Solution demonstrates how cash revenues, expenses, and dividends flow through the income statement, equity statement, balance sheet, and cash flow statement.
- Mijka Company was started on January 1, Year 1: three accounting eventsTests understanding of how three basic transactions (revenue, expenses, dividends) flow through the accounting equation and financial statements.
- On December 31, 2024, Rachel Cooking Services reports revenues and expensesThis problem tests the preparation of an income statement and statement of stockholders' equity. Students calculate net income from revenues and expenses, then track changes in common stock, retained earnings, and dividends to determine ending stockholders' equity balances.
- Amounts owed to suppliers for supplies purchased on accountThis problem tests your understanding of balance sheet classifications. Amounts owed to suppliers represent obligations to pay cash in the future, making them liabilities rather than expenses, assets, or revenue.
Got a different wording of this problem?
Assignments vary by school and semester. Share the version you were given and we'll add it so other students can find this solution.
Studying Financial Statements for a class?
Accuity courses map to your actual syllabus — video lessons, exam-style practice, and walkthroughs for the problems you're assigned.