Quarterly Report Analysis: What Changed?
Paste or attach an interim report and get what beat, what missed, what changed and what to watch next.
A full equity research report on one company: what it sells and how it earns, the central investor debate, the latest quarter, what could support the case, the risks, what the price assumes and bear/base/bull scenarios — with figures and a PDF-ready layout.
Variables
## Role and objective
Act as an independent equity research analyst writing a long-form report headed 'Equity Research: [COMPANY NAME] ([TICKER])'. Write in the language of the reader's request. Establish the header before anything else: analysis date [ANALYSIS DATE]; share price and reference date [REFERENCE PRICE] on [PRICE DATE]; financial data cut-off [DATA CUT-OFF]; latest reporting period [LATEST REPORTING PERIOD]; valuation horizon [VALUATION HORIZON]. Treat the attached or pasted material as the primary source: [LATEST QUARTERLY REPORT]. Do not give a buy or sell recommendation or a price target.
## Report structure
Write the report in exactly this order, with numbered headings.
Executive summary — in one short section answer: What does the company sell, and how does it make money? What is the central investor debate — the 'hot potato' — right now? What is the strongest evidence in favour of the business? What is the strongest evidence against it? What does the share price appear to assume? What would change the assessment? Close with a balanced overall view and a confidence level with a reason.
1. What the company does — explain the business in plain language before discussing the stock: what products or services it provides; who uses them, who pays and why; its main markets and customer groups; how it reached its current position, in two or three sentences; who leads it; and revenue, employee count and approximate market value at the reference price. Define unfamiliar terms briefly and include only history and detail that explain the business today.
2. How the company makes money — explain how customers are charged, how pricing works, and which revenues are recurring, usage-based or transactional. Table: segment | what it does | latest revenue | share of total | growth | operating margin | role in the business, for the latest reported period and labelled as such. Explain which segments drive revenue, profit and growth, where margins differ, and whether segments depend on one another. Reconcile segment revenue to company revenue or explain the difference.
3. The central investor debate — state the main debate as one direct question, for example 'Can new-product revenue justify the infrastructure spending?' or 'Will a new product offset pressure on the core business?'. Then explain why it matters for future earnings and cash flow; the strongest evidence for the optimistic view; the strongest evidence for the cautious view; what is still unknown; and which upcoming results or events could clarify it. Keep company statements, independently reported evidence and analyst interpretation separate.
4. Latest fundamentals and what they mean — compare the latest quarter or fiscal year with the same period a year earlier. Table: metric | latest period | year-ago period | change | what it indicates, covering revenue; revenue by major segment; operating income and margin; reported earnings per share; operating cash flow; capital expenditures; free cash flow; cash, investments and debt; and share count or dilution. Show the prior-period figures so the change is visible, and mark anything you cannot source as 'not available at cut-off'. Separate one-off effects such as investment gains or losses, impairments, legal charges and currency movements from ongoing operations, and label reported, adjusted and company-defined measures. Then interpret the results in practical terms: what improved, what weakened or remains uncertain, covering demand, margins, cash conversion, investment needs and financial flexibility.
5. What could support the business — the strongest plausible path to better performance: how revenue could grow and which segments would drive it; whether margins could improve and why; whether investment could translate into durable free cash flow; which competitive advantages could protect or expand the business; and what management would need to execute well. Tie each point to reported evidence or clearly labelled assumptions.
6. Risks and how the downside could unfold — table: risk | how it could arise | potential effect on revenue, margins or cash flow | what would confirm it. Cover competition and disruption, regulation and litigation, economic sensitivity, customer or supplier concentration, capital intensity, debt and financing, dilution, and execution or leadership risk. Include at least one risk an optimistic investor would tend to underweight. Explain trade-offs — for example rising free cash flow alongside slowing revenue may reflect improved efficiency, or underinvestment and weaker demand — and state what evidence would distinguish those explanations.
7. Current valuation: what is priced in — using the stated share price and date, report the measures that fit the business, such as market capitalisation, enterprise value, price-to-earnings, price-to-sales and free-cash-flow yield, defining the period and calculation behind each. Explain whether the valuation appears to depend on strong growth, higher margins, improving cash flow or a long-lasting competitive position, and compare those expectations with recent performance and the central debate. If the data supports it, add a reverse DCF showing the cash-flow starting point, forecast period, discount rate, terminal growth rate and other key assumptions, and explain what growth or profitability the current price implies; present it as an estimate that depends on assumptions, not a precise forecast.
8. Bear, base and bull scenarios — build three coherent operating scenarios describing how the business, not just the share price, could develop. Table: assumption | bear | base | bull, covering revenue growth, operating margin, capital expenditures, free-cash-flow path, share count or dilution and the main business conditions. Value each case with a DCF, showing the forecast period, discount rate, terminal-value method, formula and sensitivity to the assumptions that matter most, and stating whether the model includes net cash, debt, leases, dilution or other material claims on equity. If you assign probabilities, label them as subjective analyst judgements rather than statistical forecasts, show the probability-weighted calculation and explain how the range of outcomes is skewed.
9. What to monitor and final assessment — table: indicator | bear signal | base or bull signal, listing the indicators most likely to reveal which scenario is unfolding. Finish by answering: what does the company do well? what is the central debate? what does the valuation seem to require? what evidence would change the assessment? State that the report is an analytical exercise, not investment advice.
Sources and methodology — number the sources and cite them inline beside the claims they support; prefer company filings, earnings releases, investor materials and regulatory documents; date and link third-party estimates and market data. Explain calculations, assumptions, data gaps and limitations, and distinguish reported facts, management guidance, third-party estimates and analyst assumptions.
## Figures and visuals
Treat every figure as a picture of the data and place one wherever a number is easier to see than to read.
- Include at least one figure in each data-heavy section: a segment-mix chart for section 2, a revenue and margin trend for section 4, a comparison chart for the support case and risks in sections 5 and 6, a valuation-versus-own-history chart for section 7 when data allows, and a scenario fan or bridge chart for section 8.
- Number figures in order (Figure 1, Figure 2, ...), refer to each from the text ('as Figure 2 shows'), and give every figure a title, axis labels with units, the period covered and a dated source line beneath it.
- Use simple line, bar, stacked-area or waterfall charts. Plot only figures traceable to a cited source; draw forecasts, scenarios and illustrative values as dashed or shaded series and say so in the caption; never extend actual data into a forecast without a visible break.
- Prefer two or three figures that carry a real argument over many decorative ones. If the assistant cannot create images, state that plainly and let the table carry the data — never present ASCII art or a text sketch as if it were a chart.
## Failure modes to avoid
- Do not invent figures, consensus estimates, prices or dates; mark unknowns as 'not available at cut-off'
- Do not give a buy or sell recommendation, or a price target to act on
- Do not mix adjusted and reported figures without labelling them, or let a one-off item distort the read of the quarter — quantify it
- Do not present scenario probabilities as statistical forecasts; they are analyst judgements
- Do not make the bear case a straw man; it must be plausible on its own
- Do not include a figure the text never discusses, or plot numbers that no table or source carries
- Do not skip the central debate because it is unresolved — say what is unknown and what would settle it
## Professional report format
Deliver the analysis as a polished financial research report, not a chat reply. Use the language of the user's request. Apply this presentation standard without expanding beyond the research scope or overriding a requested word limit.
- Start with a concise report title, company or asset (if supplied), analysis date and data cut-off. If the cut-off is unknown, state that; do not invent it. Follow with an executive summary: conclusion, strongest evidence, principal risk and confidence with a reason.
- Use a clear hierarchy of numbered headings and short, well-written analytical paragraphs. Explain what each financial finding means rather than listing numbers without interpretation. Keep the tone measured, precise and institutional; avoid emojis, hype, decorative symbols and conversational introductions or sign-offs.
- Use compact tables for financial history, peer comparisons, forecasts or scenarios only where relevant and supported by data. Split wide tables into smaller ones suitable for a portrait A4 page. Label periods, currency, units and actual versus forecast figures clearly; distinguish reported facts, guidance, consensus and assumptions. Use consistent decimal precision and explain metric definitions. Mark missing values as unavailable, never as zero.
- Typography and visual identity: set the entire report — headings, body text and tables — in Times New Roman (or the closest available serif), the standard typeface of professional equity research. Use a black institutional theme: black for headings, rules, table headers and emphasis, mid-gray for supporting and secondary text, on a clean white page; no blue, no bright or decorative colours and no coloured page backgrounds.
- Figures are part of the report, not decoration: whenever the analysis discusses data — financial history, growth, margins, segment mix, comparisons, scenarios or sensitivities — include a picture of that data (a chart, diagram or map) next to the table whenever the assistant can create images: simple line, bar, stacked-area or waterfall charts that make the trend or comparison visible at a glance, in the same black, white and gray theme. Number figures in order (Figure 1, Figure 2, ...), refer to each one from the text, and give every figure a title, axis labels with units, the period covered and a dated source line beneath it. Plot only figures traceable to cited sources; draw forecasts, scenarios and illustrative values as dashed or shaded series and label them as such; keep charts simple enough to read at A4 width. If the assistant cannot create images, state that plainly and let the table carry the data — never present ASCII art or a text sketch as if it were a chart.
- Place traceable, dated source references next to material claims and table rows, with full source titles, dates and links in a final Sources and methodology section. Do not fabricate sources. Explain assumptions, calculation methods and unresolved data gaps; reconcile totals and distinguish percentage changes from percentage-point changes.
- Finish with a balanced conclusion answering the research question, key risks, contradictory evidence and the indicators that would change the conclusion. Include the analytical-exercise, not-investment-advice limitation.
- Make the output ready for document export: clean Markdown headings, restrained bold emphasis, readable paragraphs and no code fences around the report. Avoid ASCII art, oversized tables and empty decorative cover pages. For a longer report, use logically separated sections and a concise contents list only when useful.
- If the assistant supports creating documents, also provide an actual PDF using a classic institutional research layout: all text in Times New Roman serif, black headings, rules and table headers on a white page with gray supporting text, each figure embedded where it is discussed with its caption and source, A4 portrait pages, generous margins, repeated table headers and page numbers; avoid orphan headings and clipped tables. Otherwise provide the complete formatted report text and clearly state that no PDF file was generated. Never claim an attachment exists unless it was actually created.
## Evidence standard
- Separate clearly: (a) reported historical facts, (b) management guidance, (c) third-party/analyst estimates, (d) your own model assumptions. Label each.
- Cite dated, traceable sources for every material claim. Prefer company filings (10-K, 10-Q, 20-F, annual reports), investor-relations materials, regulatory disclosures, and reputable primary data.
- Do not invent figures, citations, or quotes. If a data point is unavailable or you cannot verify it, say so explicitly and state what would be needed.
- Include contradictory evidence and at least one credible alternative explanation.
- State when a method is unsuitable or incomplete for this situation.
- This is an analytical exercise, not investment advice. Keep the analysis separate from any decision.Paste or attach an interim report and get what beat, what missed, what changed and what to watch next.
Decompose how a company earns money and how recurring, diversified, and predictable that revenue is.
One structured verdict on overall business quality — revenue, profitability, returns on capital, cash flow, balance sheet, moat and management — scored and evidenced.
Build the case for where the next three to five years of growth come from — driver by driver — and what has to be true.