| Course | ACC 486 Financial Statement Analysis |
|---|---|
| Topic | Topic 4 |
| Paper type | Common size trend analysis |
| Length | About 950 words, 2 pages |
| Format | APA 7 student paper |
| School | Grand Canyon University (GCU) |
| Program | BS in Accounting |
| Updated | September 2026 |
Free sample paper for ACC 486 Topic 4
A Third Larger, Earning Slightly Less: Common Size and Index Trends in Four Years of an Outdoor Furniture Maker's Statements
[Author Name]
Colangelo College of Business, Grand Canyon University
ACC-486: Financial Statement Analysis
Topic 4 Assignment
[Instructor Name]
[Date]
The organization, setting and figures below are a composite written as a model document. No real employer, client, colleague or patient is described.
A Third Larger, Earning Slightly Less: Common Size and Index Trends in Four Years of an Outdoor Furniture Maker's Statements
Two Ways of Looking at Four Years
A composite outdoor furniture maker has grown its revenue from $200 million to $262 million over four years. The analysis restates its statements two ways. Common size statements express each line as a percentage of a base, revenue for the income statement and total assets for the balance sheet, so that the structure of the business can be compared across years of different size. Index statements express each line as a percentage of its own value in year one, so that the growth of each line can be compared with the growth of revenue. Each answers a question the other cannot (Palepu & Healy, 2013). All figures are illustrative.
The Income Statement, Common Size
Table 1
Income Statement as a Percentage of Revenue
| Common size, % of revenue | Year 1 | Year 2 | Year 3 | Year 4 |
|---|---|---|---|---|
| Revenue | 100 | 100 | 100 | 100 |
| Cost of sales | 66 | 66 | 66 | 66 |
| Gross margin | 34 | 34 | 34 | 34 |
| Selling, general and administrative | 22 | 23 | 24 | 25 |
| Operating margin | 12 | 11 | 10 | 9 |
Gross margin held at 34% in every year, so the company's pricing and product costs kept pace with each other. Selling, general and administrative expense rose one point a year, from 22% to 25% of revenue, and operating margin fell by the same amount, from 12% to 9%. The common size view locates the problem precisely: it is below gross profit, in operating expenses.
The Income Statement, Indexed
Table 2
Income Statement Indexed to Year 1
| Index, year 1 = 100 | Year 1 | Year 2 | Year 3 | Year 4 |
|---|---|---|---|---|
| Revenue | 100 | 109 | 120 | 131 |
| Gross profit | 100 | 109 | 120 | 131 |
| Selling, general and administrative | 100 | 114 | 131 | 149 |
| Operating income | 100 | 100 | 100 | 98 |
Indexed, revenue reached 131 and gross profit grew with it. Selling and administrative expense reached 149, growing half again as fast as revenue. Operating income ended at 98. A business nearly a third larger earned slightly less from operations in year four than in year one. The common size view shows that margins fell; the index view shows what that meant in absolute terms: all of the growth in gross profit was consumed by operating expenses.
The Balance Sheet
Table 3
Balance Sheet Measures
| Balance sheet | Year 1 | Year 2 | Year 3 | Year 4 |
|---|---|---|---|---|
| Total assets, $ millions | 160 | 175 | 195 | 215 |
| Inventory, % of total assets | 18 | 20 | 22 | 24 |
| Inventory index, year 1 = 100 | 100 | 122 | 149 | 179 |
| Receivables, % of total assets | 15 | 15 | 15 | 15 |
On the balance sheet, receivables held a steady 15% of total assets, consistent with stable customer terms. Inventory climbed from 18% to 24% of total assets, and indexed it reached 179, growing more than twice as fast as revenue. The company is holding far more stock relative to its sales than it did four years ago, and because receivables did not change as a share of assets, the growth in working capital is almost entirely an inventory story.
What Explains the Pattern
Management's discussion offers a single explanation for both trends: in year two the company began selling directly to consumers online, alongside its traditional sales to retailers. Direct sales carry the company's own marketing, customer service and delivery costs, which retailers had borne before, and require a wider range of finished stock available to ship immediately. Both would raise selling expense and inventory relative to revenue.
If that is the whole explanation, the question is whether the direct channel earns its keep. Its gross margin is reportedly higher than on retail sales, but the combined results show that any gain is more than offset by the added selling cost. Research connecting ratio analysis to valuation emphasizes that it is the combination of margin and asset use, not either alone, that determines return on the capital a business employs (Nissim & Penman, 2001). Here both components worsened: lower operating margin and more inventory per dollar of sales.
Putting a Size on the Shift
The two views together allow a rough estimate of what the structural shift has cost. Had selling and administrative expense stayed at year one's 22% of revenue, it would have been about $57.6 million in year four instead of $65.5 million, and operating income would have been about $31.4 million instead of $23.6 million. The shift in cost structure is worth roughly $8 million of operating income a year at current revenue, about a third of what the company now earns from operations.
The balance sheet shift has a cash cost as well. Had inventory grown only in line with revenue, to an index of 131, it would stand at about $37.7 million rather than $51.6 million. The difference, about $14 million, is cash tied up in stock. Neither figure is a precise measure of the direct channel's cost, since other things changed over four years, but together they give the analyst and management a scale for the question: the channel needs to add about $8 million of operating income and justify about $14 million of inventory before it pays for itself.
What the Analyst Should Ask
The segment note, if the company reports the direct channel separately, would show its own margin and whether selling expense is concentrated there. If it is not reported separately, management should be asked for the channel's revenue, contribution and inventory. The analyst should also ask whether the inventory build includes slow-moving product from the retail channel, which the direct channel's growth might be masking. A forecast built on the headline revenue growth, without these answers, would overstate the business's earning power, because each added dollar of revenue since year one has brought 34 cents of gross profit and about 35 cents of added operating expense (Penman, 2013).
References
Nissim, D., & Penman, S. H. (2001). Ratio analysis and equity valuation: From research to practice. Review of Accounting Studies, 6(1), 109-154. https://doi.org/10.1023/A:1011338221623
Palepu, K. G., & Healy, P. M. (2013). Business analysis and valuation: Using financial statements (5th ed.). Cengage Learning.
Penman, S. H. (2013). Financial statement analysis and security valuation (5th ed.). McGraw-Hill.
What the ACC 486 Topic 4 instructions ask for
The Topic 4 instructions in ACC-486 ask students to use common size and trend analysis to evaluate a company over several years. Weak submissions present percentage tables without interpretation. The assignment rewards analyses that restate the income statement and balance sheet as percentages of a base and as indexes to a base year, and explain what each view reveals that the other does not. Students should locate where margins changed, compare line growth with revenue growth, connect the patterns to management's explanation, size the effect in dollars and list the questions an analyst should ask.
How the ACC-486 Topic 4 example is put together
Two sets of tables form the core of the finished analysis, all figures illustrative. The first restates four years of income statements as percentages of revenue: gross margin holds at 34 percent throughout, while selling, general and administrative expense rises a point a year, from 22 to 25 percent, taking operating margin from 12 to 9. The second indexes each line to year one. Revenue reaches 131, selling and administrative expense 149 and operating income 98, so a business nearly a third larger earned slightly less from operations. The balance sheet gets the same treatment, with inventory climbing from 18 to 24 percent of total assets. The narrative then connects the lines, tracing the expense growth to outbound shipping on online orders, which management's discussion says rose from a tenth of sales to nearly a third.
Where the marks sit in the ACC 486 Topic 4 rubric
Faculty grading the trend analysis reward two views combined into one finding. Excellent analyses show margins falling below gross profit and costs growing faster than revenue in the index view. Credit goes to extending the analysis to the balance sheet and finding inventory growing faster than sales. The rubric values linking the pattern to a business change and putting dollar figures on its cost. The highest level connects margin and asset use to return on capital and directs specific questions to management. Analyses that show percentages with no explanation usually lose marks.
Common ACC 486 Topic 4 mistakes, and how to avoid them
The characteristic deduction on common-size work is a set of percentages that nobody explains. A paper presenting four years of vertical tables, accurate to a decimal, with a paragraph noting that expenses increased, has converted the statements and stopped there. Mixing bases, such as balance sheet items divided by revenue in a table labeled as a share of assets, produces figures a marker cannot read. Two-year comparisons fall short because a single change is indistinguishable from an ordinary fluctuation. Analyses that report revenue growth and operating margin separately, never setting the 131 index against the 98, miss the contrast that makes this company worth studying. Explanations drawn from general knowledge of retail, rather than from the company's own discussion and segment disclosures, earn less, since in many sections the cause is expected to be traceable in the filing itself.
Get an ACC-486 Topic 4 example written to your instructions
Send the ACC-486 Topic 4 instructions, your rubric and the company and years your section assigned. We write a custom example to them, with vertical and horizontal tables built on stated bases, several years compared, the diverging lines singled out and a cause found in the company's own disclosures, back in 24 to 48 hours. The first one costs nothing.
More ACC 486 papers and BS in Accounting samples
- ACC 486 Topic 1: Comparability Adjustment Schedule
- ACC 486 Topic 2: Profit to Cash Gap Analysis
- ACC 486 Topic 3: Normalized Earnings Worksheet
- ACC 486 Topic 5: Flattering Ratio Discussion Post
- ACC 486 Topic 6: Driver Based Revenue Forecast
- ACC 486 Topic 7: Pro Forma Forecast with Assumptions
- ACC 486 Topic 8: Valuation Sensitivity Table
- ACC 465 Topic 4: Related Party Transaction Review
- ACC 240 Topic 4: Closing Entry Sequence
- ACC 460 Topic 4: Deduction Test Analysis
- ACC 250 Topic 4: Allowance Estimate Review
ACC 486 Topic 4 questions, answered
What is the difference between vertical and horizontal analysis?
Vertical analysis expresses each line against a base within the same year, usually revenue for the income statement and total assets for the balance sheet. Horizontal analysis compares each line with itself across years, either as a percentage change or as an index to a base year. The first shows a company's structure, the second its direction, and the example uses both on the same data.
Why use four years instead of two?
Two years give one change, and one change can be a timing effect, a single large order or an unusual cost. Several years let a reader see whether a movement persists, accelerates or reverses. Many assignments ask for at least three. The example uses four because the rise in selling expense is steady, and that steadiness is what makes it worth explaining.
Can common-size statements compare companies of different sizes?
Yes, which is one of their main uses. Converting each company's figures to percentages removes the effect of scale, so a regional retailer can be set beside a national one. The comparison still depends on similar classification, since one company may report shipping in cost of sales and another in selling expense, and the example notes that difference before comparing margins.
Where can I find a free ACC 486 Topic 4 sample paper?
This page carries the complete analysis: two ways of looking, the common size and indexed income statement, the balance sheet, what explains the pattern, a size for the shift and what to ask. Send four years of statements and we will draft the analysis free.
What does the index view add in ACC 486 Topic 4?
It shows that operating income ended at 98 while revenue reached 131, so a business nearly a third larger earned slightly less from operations.