The assignment: write an earnings brief a careful reader can verify
A fictional company releases two quarters of segment revenue, cost of sales, operating expenses and management adjustments. The current presentation favors adjusted growth. Your assignment is to reconstruct the reported figures, explain the margin change and write a brief with three investor questions supported by the supplied source pack.
All financial values are in USD thousands. Thus 160,000 means $160 million, not $160,000. The data describes equal-length quarters and an explicitly new segment. There is no actual issuer, no private company information and no investment recommendation. Treat the files as a synthetic source pack rather than pretend they were extracted from a real filing.
Investor.gov explains that company filings contain business, risk and financial information and that management discussion helps contextualize results. This project practices the reading discipline on invented data. It deliberately omits several tempting metrics so you have to distinguish available evidence from a plausible-sounding invention.
Data and worked inputs
Sources[1]
Reconstruct the reported result before writing the headline
Prior revenue totals 120,000 and current revenue 160,000, giving 33.33% growth. Prior gross profit is 56,000; current gross profit is 66,200. Operating expenses rise from 40,000 to 53,000. Subtract them to get operating profit of 16,000 and 13,200: a decline of 17.5% despite revenue growth.
| Measure | Prior quarter | Current quarter |
|---|---|---|
| Revenue | 120,000 | 160,000 |
| Gross profit | 56,000 | 66,200 |
| Operating expenses | 40,000 | 53,000 |
| Operating profit | 16,000 | 13,200 |
| Gross margin | 46.6667% | 41.3750% |
The new segment contributes 15,000 of the 40,000 revenue increase, or 37.5% of the increase. The existing Alpha and Beta segments add the other 25,000. That is a source-perimeter distinction, not proof the new segment’s revenue is economically incremental or that existing segments would have grown the same way without it.
Keep the units beside the numbers throughout the memo. A consistent thousands convention prevents a thousandfold error when moving between a spreadsheet and prose. If you convert to millions for readability, convert every compared amount and label the presentation. Do not change units halfway through a table without making it explicit.
Explain the operating-profit change with a defined bridge
Hold the prior gross-margin rate constant for the revenue-scale effect. The additional 40,000 of revenue at 46.6667% margin adds 18,666.67. The gross-margin-rate change removes 8,466.67 on the current revenue base. Higher operating expenses remove another 13,000.
The bridge is 16,000 + 18,666.67 − 8,466.67 − 13,000 = 13,200, with full precision retained until display. Gross margin falls by about 5.2917 percentage points. That is not a 5.2917% relative decrease. The old and new rates make the distinction easy to inspect.
This bridge allocates the arithmetic change; it does not establish causes. You cannot say raw-material inflation, customer discounts or temporary investment caused the margin pressure unless the source supplies that explanation. In the fictional pack, the proper next step is to ask what operating changes account for the rate decline and expense growth.
Reconcile adjusted growth without erasing reported deterioration
The adjustments file lists share-based compensation of 4,000 previously and 6,000 currently, plus current restructuring of 3,000. The rules say these amounts are already included in reported operating expenses. Adding them back once yields management-adjusted operating profit of 20,000 and 22,200, an 11% increase.
| Item | Prior | Current |
|---|---|---|
| Reported operating profit | 16,000 | 13,200 |
| Share-based compensation added back | 4,000 | 6,000 |
| Restructuring added back | 0 | 3,000 |
| Management-adjusted operating profit | 20,000 | 22,200 |
The reported and adjusted growth rates can therefore move in opposite directions. The adjusted change is not a correction proving the reported number wrong; it is a different measure under the management definition supplied in the case. Present the reconciliation and label it. Do not add the adjustments to revenue, subtract them twice or call the result cash flow.
No depreciation figure is supplied, so EBITDA cannot be computed from this pack. No share count is supplied, so earnings per share cannot be computed. No cash-flow statement is supplied, so cash conversion cannot be assessed. The right answer to a missing metric is a specific source request, not a number reverse-engineered from what seems typical.
Ask questions the supplied evidence makes worth asking
First ask what explains Alpha’s gross-margin change. Its revenue grows from 80,000 to 100,000 while cost of sales grows from 48,000 to 65,000; its gross margin moves from 40% to 35%. The data identifies the change, not whether pricing, mix or cost drove it.
Second ask which operating expenses are expected to recur and what management’s adjustment policy is. The current $3 million restructuring adjustment explains part of the gap between reported and adjusted results, but the label alone does not prove that similar spending will never happen again.
Third ask how the new segment affects the comparability and durability of growth. It contributes $15 million of current revenue. You need its source, investment needs and future economics before treating the current quarter as a reliable run rate. These are questions grounded in the pack, not claims that management has issued guidance or that the stock should move in a particular direction.
A complete financial-communications paragraph
Write an explanation that acknowledges the strong and weak results together. The reader should not need a separate correction to discover which profit measure you used.
Original fictional earnings brief
Build the source register and calculations together
Create one compact model with segment totals, the operating bridge and the adjusted reconciliation. Beside each input, record its file, row or item label, period and units. A source register can be plain text; its purpose is to let another person verify a figure without searching through your work.
Test that segment totals reconcile, expense categories sum and adjustments enter exactly once. Change the units presentation from thousands to millions and confirm that all dollar comparisons still agree. Then remove an input deliberately: your method should report the missing evidence rather than preserve a stale total from the previous version.
Your final package needs the model, a brief and the three questions. Add a visual only when it makes a specific comparison easier. A simple bridge table already communicates the main result; a crowded dashboard can make it harder to see the difference between reported and adjusted measures.
Data and worked inputs
Use the optional SQL track to demonstrate the query itself
The optional SQL reference creates distinct views for segments, operating expenses and management adjustments. It computes reported profit before adding the separately labeled adjustments. This separation lets a reviewer see that an adjusted increase has not overwritten the reported decline. Read the views at their original units of thousands of dollars.
Run python run_sql.py for an in-memory SQLite execution of the supplied CSVs, or use sql-starter.sql to write your own exceptions and report views. The importer checks basic input shapes; your query still needs to detect conflicting identities and missing cost values before aggregating them. No paid database, issuer account or private financial information is needed.
Increase one proposed adjustment by 500 and verify that adjusted profit changes while reported profit does not. Then blank an operating-expense input and confirm the analysis stops rather than summing around it. Explain both results in the memo. A query is useful application evidence when you can show what it rejects and why, not only the number it returns on a clean file.
Data and worked inputs
Sources[2]
Show that you can be precise under pressure
A suitable portfolio description is: “Reconstructed a synthetic earnings pack and reconciled 33.3% revenue growth with a 17.5% reported operating-profit decline; separated the management-adjusted measure and identified missing evidence.” Do not claim you worked on an actual issuer’s earnings or influenced investor decisions.
In an interview, expect to explain why the adjusted figure rises, why a margin-rate change is expressed in percentage points and why EBITDA is unavailable. An interviewer may ask you to make the story more positive. You can improve clarity and relevance without omitting the reported decline or relabeling adjustments as cash.
For a more advanced extension, use a real issuer’s public filings, keep the company’s exact definitions and cite each figure. Do not carry this fictional adjustment policy into that company by assumption. The transferable skill is faithful reconstruction and clear communication, not memorizing the numbers in this example.