How to Turn a Quarterly Result Into a Financial-Model Update
Download an editable Excel workbook that separates reported actuals, forecast variance and revised assumptions, with a worked quarterly-to-annual EBIT bridge.
To update a financial model after quarterly results, replace the completed quarter with verified actuals and reconsider the assumptions for the quarters still ahead. Keep the old forecast visible so you can distinguish what the company delivered from what you now expect.
Download the quarterly-result-to-model-update workbook (.xlsx). It contains editable formulas and an original hypothetical example, not a forecast for any listed company. No registration, macros or AI calls are required to use it.
A result can beat your revenue estimate and miss your profit estimate. It can also miss this quarter without reducing the full-year forecast, if later-quarter assumptions change for a defensible reason. A good update makes those differences visible rather than hiding them under one revised annual number.
Preserve the forecast you made before the result
Save a dated copy before entering new actuals. At minimum, retain the revenue, cost or margin assumptions for each quarter, the evidence behind them and the date on which you formed the estimate.
Without that baseline, a model tells you what you believe today but not what you learned. Overwriting an estimate also makes it harder to investigate a recurring forecasting error, such as consistently underestimating employee costs or assuming that delayed orders convert immediately.
The workbook keeps the prior estimate in a separate block. That block is a record of the original view, not a second scenario that silently changes whenever the revised assumptions change.
For the broader research routine around a result, see what changes after every quarterly result. Here we focus on the spreadsheet mechanics.
Match the reported number to the model before replacing it
Check the covered period, consolidated or standalone basis, currency, scale and definition. Revenue from operations is not necessarily total income. EBIT, EBITDA and profit after tax are not interchangeable.
If the result reports six-month revenue, do not paste it into a three-month column. If a presentation uses an adjusted profit measure, retain it separately from the statutory number and record the adjustment. Our results, presentation and concall reconciliation guide shows how to investigate these differences.
Interim reports require particular care with cumulative periods and estimates. ICAI’s educational material announcement for Ind AS 34 explains the standard’s scope and purpose. Use the actual filing headings and notes to establish the period being modelled. The arithmetic for compatible cumulative figures is covered in quarterly versus year-to-date reconciliation.
Capture the reported value in the source-input area first. Record its exact document, page or table, publication date and review status. Link the model to that input instead of typing the same actual into several schedules.
A revenue beat with an EBIT miss
The following numbers describe a hypothetical non-financial operating company. Amounts are in ₹ crore. Its illustrative financial year runs from April 2026 to March 2027, and Q1 covers April to June. These are teaching inputs, not observations from Altys’s company database.
For this exercise, EBIT means revenue less operating costs including depreciation, before finance costs and tax. EBIT margin is that EBIT divided by revenue. The exercise excludes other income and does not calculate net profit.
| Q1 measure | Prior estimate | Illustrative actual | Difference |
|---|---|---|---|
| Revenue | 100 | 105 | +5 |
| EBIT | 20 | 18.9 | −1.1 |
| EBIT margin | 20% | 18% | −2 percentage points |
Revenue exceeded the estimate by 5%, but EBIT fell short by 5.5%. The margin calculation is ₹18.9 ÷ ₹105 = 18%.
The two-percentage-point margin shortfall is not a 2% relative decline. Relative to the old 20% margin, it is a 10% reduction. State which comparison you mean.
There is also a useful profit bridge. At the old 20% margin, the additional ₹5 of revenue would have contributed ₹1 of EBIT. Applying the actual 18% margin to ₹105 instead reduces EBIT by ₹2.1 relative to that calculation. The net surprise is ₹1 − ₹2.1 = −₹1.1. That identifies the arithmetic to explain, not its cause. Mix, pricing, operating costs and accounting classification still need evidence.
Forecast the remaining quarters explicitly
Suppose the old model estimated revenue of ₹100, ₹110, ₹120 and ₹130 for Q1 through Q4, with a 20% EBIT margin throughout. That produced annual revenue of ₹460 and EBIT of ₹92.
For the worked exercise, assume the analyst revises the remaining revenue estimates to ₹115, ₹125 and ₹135. The analyst also assumes a 19.5% Q2 margin, followed by 20% in Q3 and Q4. These choices illustrate the calculation. They are not justified by the Q1 result alone.
| Period | Updated revenue | EBIT margin | Updated EBIT | Status |
|---|---|---|---|---|
| Q1 | 105 | 18% | 18.9 | Illustrative actual |
| Q2 | 115 | 19.5% | 22.425 | Analyst assumption |
| Q3 | 125 | 20% | 25 | Analyst assumption |
| Q4 | 135 | 20% | 27 | Analyst assumption |
| Full year | 480 | 19.44% approximately | 93.325 | Actual plus forecast |
Annual revenue is ₹105 + ₹115 + ₹125 + ₹135 = ₹480. Annual EBIT is ₹18.9 + ₹22.425 + ₹25 + ₹27 = ₹93.325. The annual margin is ₹93.325 ÷ ₹480, not the simple average of the quarterly margins.
Multiplying Q1 EBIT by four would produce ₹75.6. That is a different assumption: it treats each future quarter as identical to Q1. It is not a neutral shortcut, particularly for a seasonal business.
For real coverage, the remaining-quarter estimates should come from a company-specific driver model. Volume, realised price, segment mix, store productivity or contracted delivery schedules may explain revenue. A headline growth percentage alone will rarely explain all of it. See the volume, price and mix revenue bridge.
Explain the annual revision in two parts
The completed quarter’s surprise and the revisions to future quarters should reconcile to the annual change.
| EBIT revision bridge | ₹ crore |
|---|---|
| Prior full-year estimate | 92.000 |
| Q1 actual minus prior Q1 estimate | −1.100 |
| Q2 to Q4 revised EBIT minus prior estimates | +2.425 |
| Updated full-year estimate | 93.325 |
The arithmetic is ₹92 − ₹1.1 + ₹2.425 = ₹93.325. In this exercise the full-year EBIT estimate rises by ₹1.325, despite the Q1 miss. The explanation is the improved remaining-quarter forecast, not the miss itself.
That is where the reviewer should focus. What evidence supports those future changes? If the answer is only that the analyst wants to preserve the old annual number, the bridge exposes a weak assumption rather than validating it.
The workbook also shows the revenue bridge: ₹460 + ₹5 of Q1 surprise + ₹15 of forward revisions = ₹480. Revenue rises by about 4.35%, while EBIT rises by about 1.44%. The updated annual EBIT margin therefore falls.
Use the workbook without losing the evidence
Open Model update for the annual comparison, quarterly variance, original estimate, revised inputs and bridge. Blue numeric cells are editable. Green figures link to the Evidence sheet. The native chart follows the calculated EBIT series.
On Evidence, replace the hypothetical Q1 revenue and EBIT with compatible actuals and their document locators. For each forecast change, record the reason, supporting evidence, reviewer and status. The supplied assumptions deliberately say “Needs review”. A populated workbook is not an approved model.
Blank actuals produce n.a. in the affected calculations. A genuine numeric zero remains zero. If revenue is zero, the margin is unavailable rather than a fabricated 0%. Check those distinctions when adapting the workbook.
This is a compact operating-profit update exercise. It does not include financing, tax, working capital, capital expenditure, cash flow, weighted-average shares or valuation. Update those schedules separately where the result changes their inputs. Banks, NBFCs and insurers need sector-specific structures, not this generic EBIT template.
Make the update reviewable outside the research platform
Altys combines source-linked research, financial history and guidance context with spreadsheet-verifiable workflows. The useful division of work is to assemble and compare evidence in Altys, keep calculations visible in Excel, and let the analyst decide which assumptions the evidence supports.
An AI assistant can help locate a disclosure or explain a formula. It should not fill an unresolved source gap with a plausible number. Nor does an Excel export by itself establish that the input or forecast is correct. The source and the assumption record still matter.
Request Altys access to explore research, monitoring and exportable analysis. Keep the completed quarter, the remaining forecast and the reasons for changing it distinguishable in every update.
Educational accounting and modelling material only. Altys Labs is not a SEBI-registered research analyst or investment adviser. No security recommendation, price target, expected investment return or portfolio allocation is provided.
Frequently asked questions
How do analysts update a financial model after quarterly results?
Preserve the pre-result forecast, reconcile the reported period and basis, replace the completed quarter with verified actuals, then revise only the remaining-quarter assumptions supported by new evidence. Explain the annual change as the realised surprise plus changes to future estimates.
Should you multiply quarterly profit by four?
Not as a default forecast. Seasonality, costs, mix and recognition timing can differ across quarters. Use actuals for completed periods and explicit assumptions for the remaining periods.
What is included in the downloadable workbook?
Two sheets contain a hypothetical operating-company example: a preserved prior estimate, Q1 actuals, editable Q2 to Q4 revenue and EBIT-margin assumptions, forecast variances, an annual revision bridge, an editable chart and an evidence and review record. It is not a full three-statement model or a valuation.