Tools › Finance and Business › Accounting › Income Statement Flow › Example
Two years of one firm as money-flow diagrams: sales up 20 %, net income cut in half
| Tool | Income Statement Flow |
| Source | original |
| Level | Undergraduate |
Problem
A firm's revenue grew from 5,000 to 6,000 (thousands) in a year, yet its net income fell from 600 to 300. Work out the gross, operating and net margin of both years, the common-size statement, and see in the flow diagram which costs took the extra revenue.
Inputs to Enter
- Year 2 (Year 1): product sales 4,200 (3,600); service contracts 1,800 (1,400)
- Cost of sales: materials and freight 2,310 (1,800); direct labor 1,050 (800)
- Operating expenses: salaries and benefits 1,260 (950); marketing 540 (300); rent and utilities 330 (300)
- Interest expense 110 (50); income tax 100 (200)
Answers
- Year 2: gross profit = 6,000 − 3,360 = 2,640, gross margin 2,640 / 6,000 = 44.0 % (Year 1: 2,400, 48.0 %)
- Operating income = 2,640 − 2,130 = 510, operating margin 8.5 % (Year 1: 850, 17.0 %)
- Pre-tax income = 510 − 110 = 400; net income = 400 − 100 = 300, net margin 5.0 % (Year 1: 600, 12.0 %)
- Revenue is 20.0 % higher and net income 50.0 % lower; of every 100 of revenue 56.00 goes to cost of sales, 35.50 to operating expenses, 3.50 to interest and tax and 5.00 is left
- Common-size changes: cost of sales +4.0 points, operating expenses +4.5 points (marketing +3.0), net income −7.0 points
Notes
The tool opens on this case; press Submit, or open it in the tool: /analysis-tools/business/accounting/income-statement-flow/?try=sales-up-profit-halved. Both flows are drawn at one scale, so a ribbon of the same width is the same amount in both figures. Illustrative numbers, not a real company; checked against an independent numpy computation (test_income_statement_flow.php). The tool describes the statement; it is not accounting or investment advice.