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 4Year 3
Sales$200,200$180,200
Cost of goods sold142,500120,500
Selling expenses21,20019,200
Administrative expenses12,50014,500
Interest expense3,3005,300
Total expenses$179,500$159,500
Income before taxes20,70020,700
Income taxes expense6,1003,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 4Year 3
Sales220,000195,000
Cost of Goods Sold156,000132,000
Gross Profit64,00063,000
Selling Expenses23,50020,800
Administrative Expenses13,20015,000
Interest Expense2,9004,600
Total Expenses195,600172,400
Income Before Taxes24,40022,600
Income Tax Expense7,3004,900
Net Income17,10017,700
  1. Prepare a horizontal analysis: for every line on the statement, find the percent change from Year 3 to Year 4.
  2. 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.

Jake Glidden, CPA, MSA

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%

LineYear 4Year 3$ change% change
Sales220,000195,00025,00012.8%
Cost of goods sold156,000132,00024,00018.2%
Gross profit64,00063,0001,0001.6%
Selling expenses23,50020,8002,70013.0%
Administrative expenses13,20015,000(1,800)(12.0%)
Interest expense2,9004,600(1,700)(37.0%)
Total expenses195,600172,40023,20013.5%
Income before taxes24,40022,6001,8008.0%
Income tax expense7,3004,9002,40049.0%
Net income17,10017,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%.

LineYear 4Year 3
Sales100.0%100.0%
Cost of goods sold70.9%67.7%
Gross profit29.1%32.3%
Selling expenses10.7%10.7%
Administrative expenses6.0%7.7%
Interest expense1.3%2.4%
Total expenses88.9%88.4%
Income before taxes11.1%11.6%
Income tax expense3.3%2.5%
Net income7.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

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.

Ace your accounting classes.

Textbook questions are for reference. We show a textbook's question only so you can find the problem you were assigned. We don't solve textbook questions: every solution and video on this site works through our own Accuity problem, written to teach the same method with different numbers.

Educational use. Accuity problems are original teaching material — we write our own version of each problem and solve it on video so you learn the method. Don't submit our work as your own; that violates your school's academic integrity policy. If you believe content here infringes your rights, file a DMCA notice.