Discount Rate Modifiers

This article explains how discount rates and discount rate modifiers work in Model Reef.

You will learn:

  • How WACC and equity discount rates are used.

  • How discount rates interact with model periodicity.

  • How to adjust discount rates by scenario or risk factor.

Discount rates translate future cashflows into present values and have a strong effect on NPV.

1

Core discount rates

Model Reef uses two primary discount rates:

  • WACC (Weighted Average Cost of Capital)

    • Used to discount FCFF.

    • Appropriate when valuing enterprise value.

  • Equity discount rate

    • Used to discount FCFE.

    • Appropriate when valuing equity directly.

You set these in the valuation settings for each model or scenario.

2

Periodicity and discount factors

Discounting respects the model's time structure.

Rules:

  • If the model is monthly, annual discount rates are converted to effective monthly rates.

  • If the model is quarterly or yearly, discount factors are adjusted accordingly.

  • If cashflows are irregular in time, date based discounting matches Excel XNPV style behaviour.

This keeps present value calculations consistent with the underlying period structure.

3

Discount rate modifiers

You can use modifiers to adjust discount rates for:

  • Scenario specific risk premiums.

  • Country or currency risk when modelling multiple regions manually.

  • Project risk relative to the core business.

  • Different investor required returns.

Typical patterns include:

  • Starting from a base WACC or equity rate.

  • Adding or subtracting a percentage for specific risk factors.

  • Using different rates for separate valuation blocks or sensitivities.

Modifiers are usually implemented using driver or assumption variables that feed into the valuation settings.

4

Using discount rates in scenarios and sensitivity analysis

In practice you will often:

  • Set a base discount rate in a central assumption library.

  • Override it in specific scenarios to represent higher or lower risk.

  • Run sensitivity cases where the discount rate varies by a few percentage points.

Model Reef then recomputes NPV, IRR and money multiple for each scenario using its discount rate configuration, allowing you to compare risk adjusted valuations.

Last updated

Was this helpful?