The discount rate is the interest rate used when calculating the net present value (NPV) of something. NPV is a core component of corporate budgeting and is a comprehensive way to calculate whether a proposed project will add value or not.
For this article, when we look at the discount rate, we will be solving for the rate such that the NPV equals zero. Doing so allows us to determine the internal rate of return (IRR) of a project or asset.
Discount Rate Defined
First, let's examine each step of NPV in order. The formula is:
NPV = ∑ {AfterTax Cash Flow / (1+r)^t}  Initial Investment
Broken down, each period's aftertax cash flow at time t is discounted by some rate, shown as r. The sum of all these discounted cash flows is then offset by the initial investment, which equals the current NPV. Any NPV greater than $0 is a valueadded project, and in the decisionmaking process among competing projects, having the highest NPV should go a long way toward being chosen.
The NPV, IRR and discount rate are all connected concepts. With an NPV, you know the amount and timing of cash flows, and you know the weighted average cost of capital (WACC), which is designated as r when solving for the NPV. With an IRR, you know the same details, and you can solve for the NPV expressed as a percentage return.
The big question is  what is the discount rate that sets the IRR to zero? This is the same rate that will cause the NPV to be zero. As you will see below, if the discount rate equals the IRR, then the NPV is zero. Or to put it another way, if the cost of capital equals the return of capital, then the project will break even and have a NPV of 0.
Calculating the Discount Rate in Excel
In Excel, you can solve for the discount rate a few ways:
 You can find the IRR, and use that as the discount rate, which causes NPV to equal zero.
 You can use WhatIf analysis, a builtin calculator in Excel, to solve for the discount rate that equals zero.
To illustrate the first method, we will take our NPV / IRR example. Using a hypothetical outlay, our WACC riskfree rate, and expected aftertax cash flows, we've calculated a NPV of $472,169 with an IRR of 57%. (Note: If table is hard to read, rightclick and hit "view" for a bigger image.)
Since we already defined the discount rate as a WACC that causes the IRR to equal 0, we can just take our calculated IRR and put it in place of WACC to see the NPV of 0. That replacement is shown below:
Let's now look at the second method, using Excel's WhatIf calculator. This assumes we did not calculate the IRR of 57%, as we did above, and have no idea what the correct discount rate is.
To get to the WhatIf solver, go to the Data Tab > WhatIf Analysis Menu > Goal Seek. Then simply plug in the numbers, and Excel will solve for the correct value. When you hit "OK," Excel will recalculate WACC to equal to discount rate that makes the NPV zero (57%).

Which is a better measure for capital budgeting, IRR or NPV?
All other things being equal, using IRR and NPV measurements to evaluate projects often results in the same findings. However, ... Read Answer >> 
How do you use internal rate of return to calculate a capital budget?
Learn about how the internal rate of return is used in the creation of a capital budget along with net present value and ... Read Answer >> 
How do you use discounted cash flow to calculate a capital budget?
Learn how discounted cash flows are used in creating capital budgets as a part of the net present value and internal rate ... Read Answer >> 
What is the formula for calculating net present value (NPV) in Excel?
Net present value is used to estimate the profitability of projects or investments. Here's how to calculate NPV using Microsoft ... Read Answer >> 
What are the disadvantages of using net present value as an investment criterion?
While net present value (NPV) calculations are useful when you are valuing investment opportunities, the process is by no ... Read Answer >> 
What are the main differences between compound annual growth rate (CAGR) and internal ...
The compound annual growth rate (CAGR), measures the return on an investment over a certain period of time. The internal ... Read Answer >>

Investing
Internal Rate of Return: An Inside Look
The internal rate of return can be used to measure an compare capital projects, stock buyback programs, and investments to determine which will yield the most favorable return. 
Investing
Internal Rate of Return Formula for Excel
The internal rate of return, or IRR, is a popular metric businesses use to measure a project’s return on investment. 
Investing
An Introduction To Capital Budgeting
We look at three widely used valuation methods and figure out how companies justify spending. 
Investing
Private Equity on Steroids: How Debt Fuels Outsized Returns
Hot Air: Many private equity firms use a legal technique that can boost returns by 25% or more, Bloomberg says 
Small Business
Calculating Net Present Value at Different Points Using Excel
Calculating the net present value (NPV) of your investment projects using Excel. 
Financial Advisor
A Guide on the RiskAdjusted Discount Rate
When a project or investment faces higher amounts of risk or uncertainty, it may be appropriate to utilize the riskadjusted discount rate. 
Investing
Investors Need A Good WACC
Weighted average cost of capital may be hard to calculate, but it's a solid way to measure investment quality. 
Investing
Valuing Firms Using Present Value of Free Cash Flows
When trying to evaluate a company, it always comes down to determining the value of the free cash flows and discounting them to today.

Internal Rate of Return  IRR
Internal Rate of Return (IRR) is a metric used in capital budgeting ... 
IRR Rule
A measure for evaluating whether to proceed with a project or ... 
The Net Internal Rate of Return (Net IRR)
Net internal rate of return (net IRR) is a performance measure ... 
Net Present Value  NPV
Net Present Value (NPV) is the difference between the present ... 
Conventional Cash Flow
Conventional cash flow is a series of inward and outward cash ... 
Discount Rate
Discount rate is the interest rate charged to commercial banks ...