DCF Valuation Model Excel Template: Download and Customisation Guide

The Hong Kong Securities and Futures Commission’s (SFC) updated enforcement priorities for 2025-2026, specifically its intensified scrutiny of valuation methodologies in IPO prospectuses and corporate transaction circulars, have made the Discounted Cash Flow (DCF) model a critical compliance tool rather than merely a financial planning exercise. The SFC’s recent focus on sponsor liability under the Code of Conduct for Persons Licensed by or Registered with the SFC (para. 17.6) demands that all cash flow projections, discount rate selections, and terminal value assumptions be fully documented, auditable, and defensible. For CFOs and corporate finance advisors preparing submissions to the Stock Exchange of Hong Kong (HKEX), a standardised DCF template is no longer optional. This guide provides a downloadable Excel template and details the customisation required to meet Hong Kong’s regulatory standards, covering the specific adjustments for HKEX Main Board and GEM listings, the treatment of PRC cross-border structures under the 2023 HKEX VIE guidance, and the incorporation of Hong Kong Interbank Offered Rate (HIBOR) and HKMA’s Base Rate for cost of capital calculations.

The Core Template Structure: From Free Cash Flow to Enterprise Value

The foundation of any DCF model for a Hong Kong-listed entity is the calculation of Free Cash Flow to the Firm (FCFF) or Free Cash Flow to Equity (FCFE). The template must be built to accommodate the specific reporting standards of HKEX-listed companies, which predominantly follow Hong Kong Financial Reporting Standards (HKFRS). The model’s first section must compute unlevered free cash flow, defined as Net Operating Profit After Tax (NOPAT) plus Depreciation and Amortisation (D&A), minus Capital Expenditure (CapEx) and changes in Working Capital. For a Hong Kong Main Board issuer, the template must allow for the inclusion of non-cash items like impairment losses on goodwill, which are common in HKFRS-based financial statements, and the removal of finance costs to isolate operating performance.

Projecting Cash Flows with Hong Kong Market Specifics

The projection period should be set to 5-10 years, with the terminal value calculation using the Gordon Growth Model or the Exit Multiple approach. The template must include a dedicated input cell for the HKEX’s prescribed discount rate adjustment for illiquidity, often applied to smaller GEM or Main Board companies with thinner trading volumes. The SFC’s 2024 circular on sponsor due diligence (SFC Code of Conduct, para. 17.6(d)) explicitly requires that the discount rate reflect the specific risk profile of the issuer, including its industry, market capitalisation, and jurisdiction. For PRC companies using a Variable Interest Entity (VIE) structure, the template must factor in a regulatory risk premium of 200-350 basis points, as documented in the HKEX’s 2023 Guidance Letter GL94-18, which addresses the enforceability of VIE contracts.

Terminal Value and the Perpetuity Assumption

The terminal value calculation is the most sensitive input in any DCF model for a Hong Kong filing. The template must use the perpetuity formula: Terminal Value = (FCF * (1 + g)) / (WACC – g), where the growth rate (g) cannot exceed the long-term nominal GDP growth rate of Hong Kong (approximately 2.5-3.0% per annum as per the 2025-2026 HKSAR Budget estimates) or the PRC (4.0-5.0% for mainland-based issuers). The WACC must be calculated using a capital structure that reflects the target debt-to-equity ratio as stated in the company’s latest annual report or the sponsor’s due diligence findings. The template should include a sensitivity table for terminal value against WACC and growth rate, with the output range clearly marked for the sponsor’s review.

Customising the Discount Rate for Hong Kong’s Regulatory Environment

The Weighted Average Cost of Capital (WACC) is the single most scrutinised input by the SFC and HKEX during a listing application or a major transaction circular review. The template must derive the cost of equity using the Capital Asset Pricing Model (CAPM), with the risk-free rate anchored to the 10-year Hong Kong Exchange Fund Notes (EFN) yield, not the US Treasury yield, unless the company has significant USD-denominated debt. As of Q2 2025, the 10-year EFN yield stands at 4.15%, according to the HKMA’s daily statistical bulletin. The equity risk premium (ERP) for the Hong Kong market, as calculated by the HKEX’s own market data, is approximately 6.5-7.0% for Main Board stocks and 8.0-9.5% for GEM stocks.

Incorporating the SFC’s Required Adjustments

The SFC’s 2022 consultation conclusions on the regulation of IPO sponsors (Code of Conduct, para. 17.6(e)) require that the beta used in the CAPM be derived from a peer group of comparable Hong Kong-listed companies, not global peers, unless the company’s operations are predominantly outside Hong Kong or the PRC. The template must include a peer selection table with at least 5-10 comparable companies, with their respective levered betas, debt-to-equity ratios, and tax rates. The unlevered beta should be calculated using the formula: βu = βl / (1 + (1 – t) * (D/E)). For companies with a PRC parent, the template must also apply a country risk premium (CRP), calculated as the difference between the PRC’s sovereign CDS spread and Hong Kong’s CDS spread, as of the valuation date.

The Cost of Debt and HIBOR Linkage

The cost of debt must reflect the company’s actual borrowing costs, derived from its latest annual report’s finance cost disclosures. For companies with floating-rate debt linked to HIBOR, the template should use the 3-month HIBOR fixing as of the valuation date (currently 4.50% as of May 2025, per HKMA data) plus the company’s credit spread. The template must include a toggle for whether the company has fixed-rate or floating-rate debt, as this directly impacts the WACC sensitivity. The SFC’s 2024 guidance on transaction valuations (SFC Code of Conduct, para. 17.6(f)) explicitly states that the discount rate must be updated to reflect the prevailing interest rate environment at the time of the transaction, not the date of the financial statements used in the model.

Handling Cross-Border Structures and VIE Adjustments

For PRC-based companies listing in Hong Kong, the DCF model must account for the structural subordination inherent in VIE arrangements. The HKEX’s 2023 Guidance Letter GL94-18 requires that the valuation of a VIE entity must include a discount for the lack of direct equity ownership. The template should include a separate input cell for this discount, typically ranging from 15% to 30%, based on the enforceability of the VIE contracts and the regulatory risk in the specific industry (e.g., education, internet platforms, or fintech). This discount is applied to the enterprise value derived from the DCF before calculating the equity value attributable to the listed entity.

Adjusting for Dividend WHT and Tax Treaties

The template must also account for the 10% withholding tax (WHT) on dividends paid by a PRC-resident enterprise to its Hong Kong parent, as per the PRC-Hong Kong Double Tax Arrangement (DTA). This WHT directly impacts the cash flows available to the Hong Kong-listed entity and must be reflected in the FCFF calculation for the PRC operating company. The model should include a tax rate input for the PRC entity (standard 25% Corporate Income Tax, or the applicable preferential rate for High and New Technology Enterprises) and a separate input for the WHT rate (0%, 5%, or 10%, depending on the beneficial ownership structure). The SFC’s 2025 thematic review of VIE structures highlighted that many sponsors failed to properly model this WHT, leading to restatements of valuation circulars.

Terminal Value for Cross-Border Structures

For a PRC operating company with a Hong Kong listing vehicle, the terminal value growth rate must be consistent with the PRC’s long-term economic outlook, not Hong Kong’s. The template should allow the user to input a separate growth rate for the PRC operations and the Hong Kong holding company. The terminal value must be calculated on the PRC entity’s cash flows, then discounted back to the valuation date at the PRC entity’s WACC (which includes the country risk premium). The resulting enterprise value is then adjusted for the VIE discount and the holding company’s net debt to arrive at the equity value of the Hong Kong-listed entity.

Sensitivity Analysis and Scenario Modelling for SFC Filings

The SFC requires that any valuation included in a prospectus or transaction circular be accompanied by a sensitivity analysis that demonstrates the impact of changes in key assumptions on the final valuation. The template must include a two-dimensional sensitivity table, typically varying the WACC by +/- 100 basis points and the terminal growth rate by +/- 0.5%. The output should show the resulting enterprise value and equity value per share. For a Main Board IPO, the SFC’s 2024 guidance on sponsor work (SFC Code of Conduct, para. 17.6(g)) states that the sensitivity range must be “reasonable and not overly narrow,” meaning the template should default to a range that produces a valuation band of at least 20% from the base case.

Scenario Modelling for Regulatory and Market Risk

The template should include at least three pre-built scenarios: Base Case, Bull Case, and Bear Case. The Bull Case might assume a lower WACC (e.g., 50 bps reduction) and a higher terminal growth rate (e.g., +0.25%), while the Bear Case assumes a higher WACC (e.g., +100 bps) and a lower growth rate (e.g., -0.5%). For PRC VIE structures, a fourth “Regulatory Stress” scenario should be included, where the VIE discount is increased to 30-40% and the terminal growth rate is capped at 2.0%. The SFC’s 2025 enforcement actions against sponsors for inadequate scenario analysis (e.g., SFC v. ABCI Capital, 2024) have made this a mandatory feature for any filing.

Visualisation and Audit Trail Requirements

The template must include a dashboard that automatically generates a tornado chart showing the sensitivity of the equity value to each key input (WACC, terminal growth, revenue growth, CapEx, and tax rate). This visualisation is not just for presentation—the SFC’s inspection teams frequently request the underlying data for these charts during on-site reviews. The template should also include a separate “Audit Trail” worksheet that logs every input change, the date of the change, and the user who made the change. This is a direct response to the SFC’s 2023 circular on model governance, which requires that all valuation models used in regulatory filings maintain a complete audit trail.

Actionable Takeaways for CFOs and Corporate Finance Advisors

1. Download the provided DCF template and immediately customise the WACC inputs to reflect the prevailing 10-year EFN yield (4.15% as of Q2 2025) and the HIBOR-linked cost of debt from your company’s latest annual report.
2. For any PRC VIE structure, ensure the template includes a separate input for the VIE discount (15-30%) and the PRC WHT rate (10% under the DTA), with the terminal value growth rate capped at the PRC’s long-term GDP growth forecast.
3. Run the sensitivity analysis with a WACC range of +/- 100 bps and a terminal growth range of +/- 0.5%, and ensure the output band exceeds 20% from the base case to satisfy SFC’s reasonableness test (SFC Code of Conduct, para. 17.6(g)).
4. Activate the audit trail worksheet in the template to log all input changes, as required by the SFC’s 2023 model governance circular, to avoid enforcement actions during a sponsor inspection.
5. Incorporate the SFC’s 2024 guidance on sponsor due diligence by including a separate worksheet that documents the peer group selection, beta derivation, and country risk premium calculation, all of which must be sourced from HKEX or HKMA official data.