What is the present value of $6811 to be received in one year if the discount rate is 6.5 percent?

What is a Discount Rate?

The Discount Rate represents the minimum return expected to be earned on an investment given its specific risk profile.

In practice, the present value (PV) of future cash flows is calculated using an appropriate discount rate, i.e. the opportunity cost of capital.

Table of Contents

• How to Calculate the Discount Rate
• Discount Rate Formula
• Discount Rate and Net Present Value (NPV)
• Types of Discount Rates in DCF Valuation
• How to Determine the Discount Rate
• WACC Calculation [Step-by-Step Guide]
• Discount Rate Calculator – Excel Model Template
• Discount Rate Calculation Example (WACC)

How to Calculate the Discount Rate

In corporate finance, the discount rate is the minimum rate of return necessary to invest in a particular project or investment opportunity.

The discount rate reflects the necessary return of the investment given the riskiness of its future cash flows.

Conceptually, the discount rate estimates the risk and potential returns of an investment – so a higher rate implies greater risk but also more upside potential.

In part, the estimated discount rate is determined by the “time value of money” – i.e. a dollar today is worth more than a dollar received on a future date – and the return on comparable investments with similar risks.

Interest can be earned over time if the capital is received on the current date. Hence, the discount rate is often called the opportunity cost of capital, i.e. the hurdle rate used to guide decision-making around capital allocation and selecting worthwhile investments.

When considering an investment, the rate of return that an investor should reasonably expect to earn depends on the returns on comparable investments with similar risk profiles.

Calculating the discount rate is a three-step process:

• Step 1 → First, the value of a future cash flow (FV) is divided by the present value (PV)
• Step 2 → Next, the resulting amount from the prior step is raised to the reciprocal of the number of years (n)
• Step 3 → Finally, one is subtracted from the value to calculate the discount rate.

Discount Rate Formula

The discount rate formula is as follows.

Formula

• Discount Rate = (Future Value / Present Value) ^ (1 / n) – 1

For instance, suppose your investment portfolio has grown from $10,000 to $16,000 across a four-year holding period.

• Future Value (FV) = $16,000
• Present Value (PV) = $10,000
• Number of Periods = 4 Years

If we plug those assumptions into the formula from earlier, the discount rate is approximately 12.5%.

• ($16,000 / $10,000) ^ (1/4) – 1 = 12.47%

The example we just completed assumes annual compounding, i.e. 1x per year.

However, rather than annual compounding, if we assume that the compounding frequency is semi-annual (2x per year), we would multiply the number of periods by the compounding frequency.

Upon adjusting for the effects of compounding, the discount rate comes out to be 6.05% per 6-month period.

• ($16,000 / $10,000) ^ (1/8) – 1 = 6.05%

Discount Rate and Net Present Value (NPV)

The net present value (NPV) of a future cash flow equals the cash flow amount discounted to the present date.

Formula

• Net Present Value (NPV) = Σ Cash Flow / (1 + Discount Rate) ^ n

A higher discount rate reduces the present value (PV) of the future cash flows (and vice versa).

In the formula above, “n” is the year when the cash flow is received, so the further out the cash flow is received, the greater the reduction.

Moreover, a fundamental concept in valuation is that incremental risk should coincide with greater returns potential.

• Higher Discount Rate → Lower NPV (and Implied Valuation)
• Lower Discount Rate → Higher NPV (and Implied Valuation)

Therefore, the expected return is set higher to compensate the investors for undertaking the risk.

If the expected return is insufficient, it would not be reasonable to invest, as there are other investments elsewhere with a better risk/return trade-off.

On the other hand, a lower discount rate causes the valuation to rise because such cash flows are more certain to be received.

More specifically, the future cash flows are more stable and likely to occur into the foreseeable future – hence, stable, market-leading companies like Amazon and Apple tend to exhibit lower discount rates.

Types of Discount Rates in DCF Valuation

How to Determine the Discount Rate

In a discounted cash flow (DCF) model, the intrinsic value of an investment is based on the projected cash flows generated, which are discounted to their present value (PV) using the discount rate.

Once all the cash flows are discounted to the present date, the sum of all the discounted future cash flows represents the implied intrinsic value of an investment, most often a public company.

The discount rate is a critical input in the DCF model – in fact, the discount rate is arguably the most influential factor to the DCF-derived value.

One rule to abide by is that the discount rate and the represented stakeholders must align.

The appropriate discount rate to use is contingent on the represented stakeholders:

• Weighted Average Cost of Capital (WACC) → All Stakeholders
• Cost of Equity → Common Shareholders
• Cost of Debt → Debt Lenders
• Cost of Preferred Stock → Preferred Shareholders

WACC vs. Cost of Equity

WACC reflects the required rate of return on an investment for all capital providers, i.e. debt and equity holders.

Since both debt and equity providers are represented in WACC, the free cash flow to firm (FCFF) – which belongs to both debt and equity capital providers – is discounted using the WACC.

By contrast, the cost of equity is the minimum rate of return from the viewpoint of only equity shareholders.

A company’s free cash flow to equity (FCFE) should be discounted using the cost of equity, as the represented capital provider in such a case are common shareholders.

Thereby, an unlevered DCF projects a company’s FCFF, which is discounted by WACC – whereas a levered DCF forecasts a company’s FCFE and uses the cost of equity as the discount rate.

WACC Calculation [Step-by-Step Guide]

The weighted average cost of capital (WACC) is the opportunity cost of an investment based on comparable investments of similar risk profiles.

The WACC is calculated by multiplying the equity weight by the cost of equity and adding it to the debt weight multiplied by the tax-affected cost of debt.

WACC Formula

• WACC = [ke * (E / (D + E)] + [kd * (D / (D + E)]

Where:

• E / (D + E) = Equity Weight (%)
• D / (D + E) = Debt Weight (%)
• ke = Cost of Equity
• kd = After-Tax Cost of Debt

Unlike the cost of equity, the cost of debt must be tax-effected because interest expense is tax-deductible, i.e. the interest “tax shield.”

In order to tax affect the pre-tax cost of debt, the rate must be multiplied by one minus the tax rate.

After-Tax Cost of Debt Formula

• After-Tax Cost of Debt = Pre-Tax Cost of Debt * (1 – Tax Rate %)

The capital asset pricing model (CAPM) is the standard method used to calculate the cost of equity.

Based on the CAPM, the expected return is a function of a company’s sensitivity to the broader market, typically approximated as the returns of the S&P 500 index.

CAPM Formula

• Cost of Equity (Re) = Risk-Free Rate + Beta × Equity Risk Premium

There are three inputs in the CAPM formula:

1. Risk-Free Rate (rf): In theory, the risk-free rate is the rate of return received on default-free investments, which serves as the minimum return hurdle for riskier assets. The risk-free rate should reflect the yield to maturity (YTM) on default-free government bond issuances of equal maturity as the projected cash flows.
2. Equity Risk Premium (ERP): The incremental risk from investing in the stock market instead of risk-free securities such as government bonds, i.e. the excess return above the risk-free rate. Historically, the ERP has been around 4% to 6%. The ERP is equal to the difference between the expected market return and the risk-free rate.
3. Beta (β): Beta is a risk measure that determines the sensitivity of an individual security or portfolio to systematic risk relative to the broader securities market, i.e. the non-diversifiable risk that cannot be mitigated from diversification of the portfolio. The higher the beta, the more volatile the security relative to the overall market.

Calculating the cost of debt (kd), unlike the cost of equity, tends to be relatively straightforward because debt issuances like bank loans and corporate bonds have readily observable interest rates via sources such as Bloomberg.

Conceptually, the cost of debt is the minimum return that debt holders demand before bearing the burden of lending debt capital to a specific borrower.

Discount Rate Calculator – Excel Model Template

We’ll now move to a modeling exercise, which you can access by filling out the form below.

Discount Rate Calculation Example (WACC)

Suppose we are calculating the weighted average cost of capital (WACC) for a company.

In the first part of our model, we’ll calculate the cost of debt.

If we assume the company has a pre-tax cost of debt of 6.5% and the tax rate is 20%, the after-tax cost of debt is 5.2%.

• After-Tax Cost of Debt (kd) = 6.5% * 20%
• kd = 5.2%

The next step is to calculate the cost of equity using CAPM.

The three assumptions for our three inputs are as follows:

1. Risk-Free Rate (rf) = 2.0%
2. Beta (β) = 1.10
3. Equity Risk Premium (EPP) = 8.0%

If we enter those figures into the CAPM formula, the cost of equity comes out to 10.8%.

• Cost of Equity (ke) = 2.0% + (1.10 * 8.0%)
• ke = 10.8%

We must now determine the capital structure weights, i.e. the % contribution of each source of capital.

The market value of equity – i.e. the market capitalization (or equity value) – is assumed to be $120 million. On the other hand, the net debt balance of a company is assumed to be $80 million.

• Market Value of Equity = $120 million
• Net Debt = $80 million

While the market value of debt should be used, the book value of debt shown on the balance sheet is usually fairly close to the market value (and can be used as a proxy should the market value of debt not be available).

The intuition behind the usage of net debt is that cash on the balance sheet could hypothetically be used to pay down a portion of the outstanding gross debt balance.

By adding the $120 million in equity value and $80 million in net debt, we calculate that the total capitalization of our company equals $200 million.

From that $200 million, we can determine the relative weights of debt and equity in the company’s capital structure:

• Equity Weight = 60%
• Debt Weight = 40%

We now have the necessary inputs to calculate our company’s discount rate, which is equal to the sum of each capital source cost multiplied by the corresponding capital structure weight.

• Discount Rate (WACC) = (5.2% * 40%) + (10.8% * 60%)
• WACC = 8.6%