Calculate profit needed to meet a full-year earnings forecast

CoTrading editorial team 2026-10-27 阅读中文全文

To find how much a company must earn to meet a full-year forecast, subtract the compatible cumulative actual profit already reported from the annual target. Keep the result attached to the exact remaining period. If nine months have elapsed, the difference belongs to the fourth quarter; if only six months have elapsed, it belongs to the combined third and fourth quarters. Dividing that total equally across quarters would introduce a new seasonal assumption.

This guide turns the subtraction into a usable research worksheet: define the profit measure, reconcile periods and units, calculate the requirement, compare appropriate seasonal history, and flag external operating constraints. The example is synthetic and uses profit attributable to the parent in millions of CNY. It does not predict that the required profit will occur or demonstrate a product connection to broker forecasts.

Gather an annual target and a compatible actual

Obtain a dated full-year forecast with its company, fiscal year, profit definition, currency, units and source. Identify whether it is a specific broker’s estimate, your own model or a stated aggregate. Do not call a personally selected forecast the market consensus. Preserve the original publication date so that a later update cannot silently change the benchmark used in an earlier worksheet.

Next obtain the cumulative actual through a specified quarter. Check the start and end dates, especially when the issuer has a non-calendar fiscal year. A nine-month cumulative figure already includes the first two quarters. Do not subtract the first quarter, half-year cumulative and nine-month cumulative amounts together. If only separate quarterly figures are available, establish nonoverlapping periods before summing them.

The IAS 34 overview describes interim reporting and year-to-date measurement. This guide uses that period distinction to build a compatible worksheet; it does not assert that every market applies IFRS. For an A-share issuer, use the actual filing’s accounting labels and local reporting basis. Confirm that annual and interim values both mean parent-attributable net profit rather than revenue, total net profit or an adjusted performance measure.

Establish the subtraction contract

Our annual target is FY2026 profit of 400 million CNY. Actual profit for the first nine months is 250 million CNY. Both describe fictional company AAA, the same year, parent net profit, CNY and millions. The required remaining profit is 400 - 250 = 150, belonging to Q4 alone. Retain the cumulative-period label in the output so the 150 cannot later be mistaken for an annual forecast.

The program checks those matching fields before arithmetic. It rejects a different company, year, currency, profit scope or unit. It also requires the annual target to extend through quarter four and the actual to extend through quarter one, two or three. These modest checks prevent a valid subtraction from answering the wrong question. They do not replace review of a filing’s detailed accounting definition or changes in consolidation scope.

Python Decimal supports the arithmetic used here. Every financial number must also be finite: targets, actuals, historical comparisons, constraints and share assumptions. NaN or infinity is not a very large profit forecast. Reject the input with a reason and leave the requirement unavailable. Preserve unrounded values internally, then display millions and percentages with a stated presentation precision.

Compare the right seasonal period

Suppose independently supplied historical Q4 profits are 100, 120 and 140 million CNY for three comparable years. Their median is 120. The required 150 is 25% above that median: 150 / 120 - 1 = 0.25. The comparison makes the scale of the challenge visible; three observations do not establish a probability distribution or a reliable likelihood of reaching the target.

Review whether the historical periods share the same operating perimeter and accounting basis. A disposal, acquisition, shutdown or unusual gain may make a historical quarter unsuitable as a benchmark. Preserve the original history and explain exclusions rather than selecting only convenient years. If the comparable history is absent, show the requirement with the historical comparison marked unknown. A nonpositive median also leaves this particular uplift ratio unavailable.

An external operating review supplies a Q4 upper constraint of 145 million CNY for the fixture. The requirement exceeds that supplied constraint by 5 million. Label the outcome exceeds_supplied_constraint. It is a conditional conflict requiring investigation, not mathematical proof that profit above 145 is impossible. Record who supplied the constraint, the reasoning behind it and whether it includes one-off gains or only ordinary operations.

Preserve a multi-quarter remainder as a total

Now change the actual to the first half-year profit of 180 million. The remaining requirement is 220 million for Q3 and Q4 combined. The program returns remaining quarters [3, 4] and no quarter allocation. It does not output 110 for each quarter. A company may have a highly seasonal final quarter, and the available inputs contain no evidence that equal quarterly profit is plausible.

To extend this worksheet, supply a separate reviewed seasonal allocation or a quarterly operating model. Keep that extension labeled as a forecast assumption, with its own source and uncertainty. A historical proportion may be a starting point, but it needs handling for negative quarters, changing business mix and unusual items. The present script deliberately stops at the combined requirement because its inputs support that result directly.

required = finite(target["profit"]) - finite(actual["profit"])
quarters = list(range(actual["through_quarter"] + 1, 5))
# Keep required attached to the whole remaining period.
quarter_allocation = None

Download the complete example. It requires Python 3.12+, uses only the standard library and contains synthetic data. Run python R548.py to reproduce the nine-month case, half-year case, already-met target and missing-share counterexample. The assertions check actual outputs from the subtraction and comparison functions.

Handle an already-met target without inventing a loss forecast

For a different mechanism, suppose cumulative actual profit is 450 against the same annual target of 400. The remaining difference is minus 50. This means the company has already earned more than the stated target and could lose 50 over the remaining period while finishing exactly at 400. It does not mean Q4 is forecast to lose 50. Retain the signed difference and an already_met flag so that both interpretations remain distinguishable.

A target can also be met before the final quarter while the underlying recurring business weakens. Reconcile unusual items separately when the research question concerns recurring profit. Do not change the profit definition halfway through the subtraction to make the requirement look more demanding or easier. If the forecast is adjusted profit and the actual is statutory profit, produce a reconciliation first or block comparison.

An annual EPS target is not automatically a profit amount. IAS 33 explains the numerator and share denominator in EPS calculations. In our simplified conversion, a forecast of 4 CNY per share and an externally supplied matching share assumption of 100 million imply 400 million CNY of profit. The two inputs must describe compatible numerator and dilution conventions.

If the share assumption is missing, the program returns unknown profit with missing_share_assumption. It does not multiply by today’s shares without approval. Forecast weighted-average shares, share issuance, dilution and the precise earnings numerator may differ from a current outstanding-share snapshot. Obtain or reconcile those inputs before using an EPS forecast in this profit worksheet; otherwise retain the EPS target separately.

Deliver and update a requirement worksheet

Save the annual target source and date, cumulative actual source and period, compatibility checks, remaining quarters, signed required total, historical benchmark and external constraint. Separate observed data from assumptions and derived arithmetic. A reviewer should reproduce the requirement with one subtraction, then verify that every comparison refers to the same remaining seasonal period.

When the annual forecast changes, a new quarter is reported or the issuer restates actuals, create a new worksheet version. Show which input changed and how much it altered the remaining requirement. Keep an earlier version if it supported an earlier decision. The useful conclusion is a measurable hurdle and its stated context, followed by the operating questions that would determine whether that hurdle is plausible.

FAQ

Should I divide a two-quarter remainder by two?

Only after explicitly adopting and testing an equal-allocation assumption. This example preserves the combined remainder.

Does a negative requirement predict a loss?

No. It describes the arithmetic margin relative to an annual target already exceeded by cumulative profit.