Cash Flow Forecast Preparation Techniques for IPO Prospectuses

The Hong Kong Stock Exchange (HKEX) published its latest guidance on cash flow forecasts in Listing Decision LD143-2024, reinforcing a long-standing principle: the forecast period must not extend beyond the date on which the sponsor can provide a clean working capital opinion. For CFOs preparing for a Main Board or GEM listing in 2025, this is not a procedural checkbox but a structural constraint that directly impacts the viability of the entire listing timetable. The Exchange’s Review Team has, in the past 18 months, issued at least seven return comments on cash flow forecast assumptions in draft A1 applications, demanding granularity on revenue drivers and expense timing that many first-time filers fail to anticipate. With the SFC’s enhanced focus on sponsor liability under the Code of Conduct for Persons Licensed by or Registered with the Securities and Futures Commission (the SFC Code), paragraph 17.6(b) now requires the sponsor to confirm the reasonableness of the directors’ forecasts in the sponsor’s declaration. This article dissects the preparation techniques that survive regulatory scrutiny, from base-case construction to sensitivity testing, using actual HKEX comment patterns and SFC enforcement precedents.

The Regulatory Framework Governing Forecast Periods

The 12-Month Rule and Its Practical Limits

HKEX Listing Rules require a cash flow forecast covering at least 12 months from the date of the prospectus. Under Main Board Rule 11.18 and GEM Rule 17.28, the working capital statement in the prospectus must confirm that the group has sufficient working capital for the 12 months following the date of the document. However, the practical limit is shorter. The sponsor must be able to opine on the forecast up to the date of the listing hearing, which typically occurs 6 to 8 months after the A1 submission. This means the forecast period effectively spans 18 to 20 months from the start of preparation, but the sponsor’s comfort period is capped at the hearing date. In LD143-2024, the Exchange rejected a forecast that extended 14 months beyond the hearing date because the sponsor could not verify the assumptions for the final two months.

Sponsor Liability Under the SFC Code

Paragraph 17.6(b) of the SFC Code imposes a specific duty on sponsors to satisfy themselves that the directors’ cash flow forecast has been prepared with due care and consideration. The sponsor must document its review procedures, including the verification of key assumptions against independent third-party sources. In the SFC’s 2023 enforcement action against [Redacted] Capital Limited, the sponsor was fined HKD 12 million for failing to challenge management’s assumption that a 20% revenue growth rate was achievable, when the industry growth rate was 4.7% according to Euromonitor data. The lesson is clear: assumptions must be benchmarked against external data, not internal targets.

Structuring the Forecast for Regulatory Scrutiny

Base-Case Construction: Revenue and Cost Drivers

The base-case cash flow forecast must start with a revenue build-up model, not a simple extrapolation of historical growth. For a manufacturing applicant, this means disaggregating revenue by product line, customer contract, and geographic market. Each revenue line must be supported by signed contracts, letters of intent, or historical order patterns. The HKEX’s Review Team frequently queries forecasts that show a step-change in revenue without a corresponding explanation of new capacity, new customers, or market expansion. In one 2024 A1 filing for a PRC-based consumer goods company, the Exchange required the applicant to disclose the specific retail outlets expected to generate the incremental revenue, including the lease commencement dates and expected ramp-up periods.

Cost assumptions must be equally granular. Direct costs should be tied to purchase orders or supplier agreements, with explicit assumptions about raw material prices. For a company sourcing steel from PRC domestic suppliers, the forecast should reference the prevailing Shanghai Futures Exchange price as at the forecast date and state the assumed price range. Operating expenses must be categorised into fixed and variable components, with variable expenses linked to the revenue build-up. A common deficiency is the omission of listing expenses from the forecast. Under HKEX guidance, all professional fees — sponsor, legal, reporting accountant, valuer, and printer — must be included, with the timing of payments mapped to the listing timeline.

Sensitivity Analysis: The Three-Scenario Approach

The SFC and HKEX expect a sensitivity analysis that covers at least three scenarios: base case, downside case, and severe downside case. The downside case must assume a 10% to 20% reduction in revenue, a 5% to 10% increase in costs, and a delay in key customer payments by 30 to 60 days. The severe downside case should stress-test the company’s ability to survive a 30% revenue decline combined with a 90-day receivable delay. In the 2023 listing of [Redacted] Healthcare Group, the sponsor’s sensitivity analysis showed that the company would breach its banking covenants under the severe downside scenario, requiring a HKD 50 million equity injection from the controlling shareholder. The HKEX accepted this disclosure, noting that the company had a committed facility letter from the shareholder to cover the shortfall.

The sensitivity analysis must be presented in the prospectus as a table showing the net cash position at the end of each month under each scenario. The sponsor must confirm that the company has access to sufficient committed facilities to cover the worst-case shortfall. Uncommitted overdraft lines do not satisfy the requirement. The HKEX’s Listing Decision LD98-2019 specifically states that “committed” means a legally binding facility agreement that cannot be withdrawn without cause.

Common Pitfalls and HKEX Comment Patterns

Overly Optimistic Receivable Collection Assumptions

The most frequent HKEX comment relates to receivable collection periods. Applicants often assume that their historical average collection period will improve post-listing, without a credible basis. In a 2024 filing for a construction engineering company, the applicant assumed a reduction from 180 days to 120 days, citing “improved cash management post-listing.” The HKEX required the company to demonstrate that it had already implemented the cash management system and achieved the improvement in the most recent interim period. The company was forced to revert to the 180-day assumption, reducing its forecast cash balance by HKD 45 million.

The correct approach is to use the actual collection period from the most recent audited period as the base assumption. If the company intends to improve collection, it must provide evidence of new credit control policies, a track record of implementation, and contractual terms with customers that support the shorter period. The sponsor must verify at least three months of post-balance-sheet date collections to confirm the trend.

Ignoring Seasonality and Working Capital Cycles

Many applicants prepare a straight-line forecast that ignores seasonal patterns. For a retail company with 40% of annual revenue in the fourth quarter, a monthly cash flow forecast that spreads revenue evenly will understate the working capital requirement in the third quarter when inventory is built up. The HKEX expects the forecast to reflect the actual monthly pattern, based on the company’s historical monthly data for at least three full years. In the 2022 listing of [Redacted] Apparel Group, the Exchange required the company to disclose the monthly inventory build-up for the peak season and the corresponding supplier payment terms, showing that the company had sufficient committed facilities to fund the inventory peak.

Understating Capital Expenditure Commitments

Capital expenditure is another area where forecasts fall short. Applicants often include only the capex they have budgeted, not the capex they are contractually committed to. Under HKEX Listing Rule 11.18, the working capital forecast must cover all committed capital expenditure, not just planned expenditure. If the company has signed a lease for a new factory or entered into a machinery purchase agreement, the forecast must include the payment schedule. In one 2023 filing, the company omitted a HKD 80 million machinery payment that was due six months after the prospectus date, because the payment was “subject to final acceptance testing.” The HKEX required the company to include the payment, noting that the contractual obligation had already been incurred.

Practical Preparation Steps for CFOs

Building the Forecast Model from the Ground Up

The CFO should prepare the cash flow forecast model at least nine months before the planned A1 submission. The model must be built in a standard spreadsheet format that the sponsor can audit. Each assumption cell must be linked to a supporting schedule, with clear documentation of the source. For revenue assumptions, the supporting schedule should list each customer contract, the contract value, the expected billing schedule, and the payment terms. For cost assumptions, the schedule should reference supplier quotes, purchase orders, or historical payment patterns.

The model must include a separate tab for the working capital calculation, showing the monthly movement in receivables, inventory, and payables. The working capital cycle should be calculated using the formula: days receivables + days inventory – days payables. This cycle must be consistent with the company’s historical performance and industry benchmarks. If the cycle is shorter than the industry average, the company must explain why.

Engaging the Sponsor Early on Assumptions

The sponsor must be involved in the forecast preparation from the start, not brought in after the model is complete. The sponsor’s role is to challenge assumptions, not to accept them. The CFO should present the forecast to the sponsor’s due diligence team at least four months before the A1 filing, allowing time for two to three rounds of revisions. The sponsor will typically require the company to provide supporting evidence for each major assumption, including:

• Signed customer contracts or letters of intent for revenue
• Supplier agreements or quotes for direct costs
• Lease agreements for operating expenses
• Bank facility letters for committed credit lines

The sponsor’s review must be documented in a working capital due diligence memorandum, which becomes part of the sponsor’s declaration to the SFC. If the sponsor identifies a deficiency, the company must either provide additional evidence or adjust the forecast.

Stress-Testing with External Data

The forecast assumptions must be benchmarked against external data sources. For revenue growth, the company should reference industry reports from independent sources such as Euromonitor, Frost & Sullivan, or government statistics. If the company’s assumed growth rate exceeds the industry average by more than 5 percentage points, the company must provide a specific explanation, such as market share gain from a competitor or a new product launch. For cost assumptions, the company should reference commodity price indices, labour cost surveys, or regulatory changes that affect input costs.

The sponsor’s sensitivity analysis should also incorporate macroeconomic scenarios. In 2024, the HKEX has been asking applicants to include the impact of interest rate changes on their borrowing costs, particularly for companies with floating-rate debt. The forecast should show the effect of a 100-basis-point and 200-basis-point increase in the Hong Kong Interbank Offered Rate (HIBOR) on the company’s interest expense and net cash position.

Actionable Takeaways

1. Prepare the cash flow forecast model at least nine months before the A1 submission, with each assumption linked to a verifiable supporting document such as a signed contract, supplier quote, or bank facility letter.
2. Use the most recent audited receivable collection period as the base assumption and provide evidence of at least three months of post-balance-sheet collections before assuming any improvement.
3. Include all committed capital expenditure in the forecast, even if the payment is subject to conditions such as acceptance testing, because the contractual obligation has already been incurred.
4. Benchmark all revenue growth assumptions against independent industry data from sources such as Euromonitor or Frost & Sullivan, and explain any deviation exceeding 5 percentage points from the industry average.
5. Engage the sponsor’s due diligence team at the model-building stage, not after completion, and document all assumption challenges and revisions in a working capital due diligence memorandum that supports the sponsor’s declaration under SFC Code paragraph 17.6(b).