Solution Matrix • Cost-Benefit-Analysis

Discount rate

Discount Rate is the interest rate used in calculating present values in discounted cash flow analysis. (Note however, that in the United States, the term discount rate also refers to the rate the Federal Reserve charges member banks for loans).

A discount rate is a key component in calculating  Discounted Cash Flow (DCF), a cash flow summary adjusted to reflect the time value of money. DCF can be an important criterion in evaluating or comparing investments, proposed actions, or purchases. Other things being equal, the action or investment associated with the larger DCF is the better decision. When discounted cash flow events in a cash flow stream are added together, the result is called the Net Present Value (NPV).

Discount Rate, Present Value, DCF, NPV and related time value of money concepts are more easily understood when explained together and illustrated, as shown in the sections below.

Time Value of Money in Finance and Business Planning 
Present Value, Future Value, and Net Present Value 
DCF and NPV: Mathematically Speaking 
Choosing a Discount Rate for Discounted Cash Flow Analysis 
Example: Comparing Competing Investments with NPV 
When to Use CF and NPV in the Business Case

Time Value of Money in Finance and Business Planning

When business case or investment projections extend more than a year into the future, professionals trained in finance usually want to see cash flows in both discounted terms and non discounted terms. They will want to see projections, that is, that consider the time value of money. In modern finance, time-value-of-money concepts play a central role in decision support and planning.

Time value of money analysis begins with the Present Value concept, the idea that money you have now is worth more, today, than an identical amount you would receive in the future Why? There are at least 3 reasons:

  • Opportunity. The money you have now you could (in principle) invest now, and gain return or interest, between now and the future time. Money you will not have until a future time cannot be used now.  
  • Risk. Money you have now is not at risk. Money predicted to arrive in the future is less certain.
  • Inflation. A sum you have today will very likely buy more than an equal sum you will not have until years in future. Inflation over time reduces the buying power of money.

[ Page Top ]     [ Encyclopedia ]     [ Business Case Books & Tools ]     [ Home ]

Present Value, Future Value, and Net Present Value

What future money is worth today is called its Present Value (PV), and what it will be worth in the future when it finally arrives is called not surprisingly its Future Value (FV). The right to receive a payment one year from now for $100 (the future value) might be worth to us today $95 (its present value). Present value is discounted below future value.

When the analysis concerns a series of cash inflows or outflows coming at different future times, the series is called a cash flow stream. Each future cash flow has its own value today (its own present value). The sum of these present values is the Net Present Value for the cash flow stream. 

Consider an investment today of $100, that brings net gains of $100 each year for 6 years. The future values and present values of these cash flow events might look like this:

FV_PV_NPV.jpg

 

 

 

 

 

 

 

 

 

 

All three sets of bars represent the same investment cash flow stream. The black bars stand for cash flow figures in the currency units when they actually appear in the future (Future values). The lighter bars are values of those cash flows now, in present value terms. The net values in the legend show that after five years, the net cash flow expected is $500, but the Net Present Value today is discounted to something less.

The size of the discounting effect depends on two things: the amount of time between now and each future payment (the number of discounting periods) and an interest rate called the Discount Rate. The example shows that:

  • As the number of discounting periods between now and the cash arrival increases, the present value decreases.
  • As the discount rate (interest rate) in the present value calculations increases, the present value decreases. 

Whether you will or will not calculate present values yourself, your ability to use and interpret NPV / DCF figures will benefit from a simple understanding of the way that interest rates and discounting periods work together in discounting. If you wish to skip the next section on mathematics, however, click here to skip the maths topic and go directly to  "Choosing a Discount Rate."

[ Page Top ]     [ Encyclopedia ]     [ Business Case Books & Tools ]     [ Home ]

DCF and NPV: Mathematically Speaking

FVformula.jpgDCF and NPV calculations are closely related to calculations for interest growth and compounding, which are already familiar to most people. Remember briefly how these work. The formula at left looks into the future and might ask, for instance: What is the future value (FV) in one year, of $100 invested today (the PV), at an annual interest rate of 5%?

FV1  = $100 ( 1 + 0.05)1 = $105

When the FV is more than one period into the future, as most people know, interest compounding takes place. Interest earned in earlier periods begins to earn interest on itself, in addition to interest on the original PV. Compound interest growth is delivered by the exponent in the FV formula, showing the number of periods. What is the future value in five years of $100 invested today at an annual interest rate of 5%?

FV5  = $100 ( 1 + 0.05)5 = $128

PVformula.jpgThe same formula can be rearranged to deliver a Present Value given a Future Value (and interest rate) for input, as shown at left. Now, the formula starts in the future and looks backwards in time, to today, and might ask: What is the value today of a $100 payment arriving in one year, using a discount rate of 5%?

PV1 = ($100) / (1.0 + 0.05)   = $100 / (1.05)     = $95 

You should be able to see why PV will decrease if we either (a) increase the interest rate, or (b) increase the number of periods before the FV arrives. What is the Present Value of $100 we will receive in 5 Years, using a 5% discount rate?

PV = $100 / (1.0 +0.05)5      = $100 / (1.276)     = $75.13

When discounting is applied to a series of cash flow events, a cash flow stream, as illustrated in the graph example above, Net Present Value for the stream is the sum of PVs for each FV:

NPV_5.jpg

Finally, note two commonly used variations on the examples shown thus far. The examples above and most textbooks show  "Year End" discounting, with periods one year in length, and cash inflows and outflows discounted as though all cash flows in the year occur on day 365 of the year. However: 

  • Some financial analysts prefer to assume that cash flows are distributed more or less evenly throughout the period, and discounting should be applied when the cash actually flows.
    • For calculating present values this way, it is mathematically equivalent to calculate as though all cash flow occurs at mid year.  This is so-called "Mid Period Discounting." 
    • Year end discounting is more severe (has a greater discount effect) than mid year (mid period) discounting, because the former discounts all cash flow in the period for the full period.
  • When actual cash flow is known or estimated for months, quarters, or some other period, discounting may be performed for each of these periods rather than for one year periods. In such cases, the discount rate used for calculation is the annual rate divided by the fraction of a year covered by a period. Quarterly discounting, for example, would use the annual rate divided by 4.

Net Present Value Calculations Mid Year discounting quarterly discountingDiscounted cash flow and NPV formula key.The formulas at left show NPV calculations for mid-year discounting (upper formula) and for discounting with periods other than one year (lower formula).

In any case, the business analyst will want to find out which of the above discount methods is preferred by the organization's financial specialists, and why, and follow their practice (unless there is justification for doing otherwise).

Working examples of these formulas, along with guidance for spreadsheet implementation and good-practice usage are available in the spreadsheet-based tool Financial Metrics Pro.

[ Page Top ]     [ Encyclopedia ]     [ Business Case Books & Tools ]     [ Home ]

Choosing a Discount Rate for Discounted Cash Flow Analysis

The analyst will also want to find out from the organization's financial specialists which discount rate the organization uses for discounted cash flow analysis. Financial officers who have been with an organization for some time, usually develop good reasons for choosing one rate or another as the most appropriate discount rate for the organization.

  • In private industry, many companies use their own cost of capital (or weighted average cost of capital) as the preferred discount rate.
  • Government organizations typically prescribe a discount rate for use in the organization's planning and decision support calculations. In the United States, for instance, the Office of Management and Budget (OMB) publishes a quarterly circular with prescribed discount rates for Federal Government use.
  • Financial officers may use a higher discount rate for investments or decisions viewed as risky, and a lower discount rate when expected returns from a proposed action are seen as less risky.  The higher rate is viewed as a hedge against risk, because it puts relatively more emphasis (weight) on near-term returns compared to distant future returns.

[ Page Top ]     [ Encyclopedia ]     [ Business Case Books & Tools ]     [ Home ]

Example: Comparing Competing Investments with NPV.

Consider two competing investments in computer equipment. Each calls for an initial cash outlay of $100, and each returns a total a $200 over the next 5 years making net gain of $100. But the timing of the returns is different, as shown in the table below (Case A and Case B), and therefore the present value of each year’s return is different. The sum of each investment’s present values is called the Discounted Cash flow (DCF) or Net Present Value (NPV). Using a 10% discount  rate again, we find:


Timing
                             CASE A                             CASE B
     Net Cash Flow    Present Value      Net Cash Flow    Present Value
Now     – $100.00      – $100.00     – $100.00      – $100.00
Year 1         $60.00          $54.54        $20.00         $18.18
Year 2         $60.00          $49.59        $20.00         $16.52
Year 3         $40.00          $30.05        $40.00         $30.05
Year 4         $20.00          $13.70        $60.00        $41.10
Year 5         $20.00          $12.42        $60.00        $37.27
Total Net CFA =  $100.00   NPVA = $60.30 Net CFB = $100.00 NPVB = $43.12


Comparing the two investments, you can see that the early large returns in Case A lead to a better net present value (NPV) than the later large returns in Case B. Note especially the Total line for each present value column in the table. This total is the net present value (NPV) of each "cash flow stream." When choosing alternative investments or actions, other things being equal, the one with the higher NPV is the better investment.

[ Page Top ]     [ Encyclopedia ]     [ Business Case Books & Tools ]     [ Home ]

When to Use DCF and NPV in the Business Case

In brief, an NPV / DCF view of the cash flow stream should probably appear with a business case summary when:

  • The business case deals with an "investment" scenario of any kind, in which different uses for money are being compared.
  • The business case covers long periods of time (two or more years).
  • Inflows and outflows change differently over time (e.g., the largest inflows come at a different time from the largest outflows).
  • Two or more alternative cases are being compared and they differ with respect to cash flow timing within the analysis period.

For a working spreadsheet example of discounted cash flow calculations, download either the free financial metrics tool (click here), or the more in-depth coverage in Financial Metrics Pro.

[ Page Top ]     [ Encyclopedia ]     [ Business Case Books & Tools ]     [ Home ]

[ Pacioli ]

Business Case Essentials: A Guide to Structure and Content

New edition just published!

The concise, complete guide to what belongs in a business case and why—The world's most popular introduction to business case analysis. With nearly one million copies in circulation, Essentials is also the leading trusted authority (Search Google to see citations). Clear step-by-step guidance for building a compelling case, complete with NOV, ROI, TCO, and other important financial and non financial outcomes. Available in printed, ebook (PDF), and Kindle editions. Order the printed edition online. Or, download the worlds most frequently cited business case resource today as an e-book.

Financial Metrics Pro

Financial Metrics Pro The complete financial metrics resource: clear, easy
to follow spreadsheet instructions, comprehensive handbook, usage and interpretation, and working examples. Covers all important cash flow metrics, including Net Cash Flow, NPV, IRR, ROI, Payback Period, and all financial statement metrics, from Working Capital and Quick Ratio, to full DuPont System analysis. Ready to copy templates for more than 100 important financial metrics. Download today!

Financial Modeling Pro

Financial Modeling Pro Step by step guidance for building the financial model at the heart of the business case. Includes model design strategy, best practice spreadsheet programming, designing for usability, and the dynamic model for risk and senitivity analysis.

Click for an overview.

Learn case building at the premier seminar on business case analysis:

Building The Business Case

Building the Business Case Seminar ParticipantsTwo days hands on learning and practice with the leading source for business case training. Join more than 16,000 professionals on five continents who successfully completed Building the Business Case seminars.
Qualify for professional eductaion and certification credits.

Request detailed seminar contents and agendas.

Cost/Benefit Newsletter

Read newsletter past issues

  • ROI Users Survival Guide
  • Getting a Yes from the CFO
  • Business Case Critics:
    De-Clawing the Cat
  • Do "Soft" Benefits Belong in a Business Case?
  • And more...

Subscribe to the free weekly newsletter and receive a free
e-mail course: "5 Days to Success with Your Business Case"



We value your privacy
Read newsletter past issues

The No-Hassle Guarantee

Our goal is to reduce risk in business, not raise it. We believe that a decision to try the Business Case Guide, Business Case Essentials, the Definitive Guide to Getting Your Budget Approved, Financial Metrics Pro, or Financial Modeling Pro should be risk-free. Solution Matrix Ltd. stands behind them with a 30-day "no hassle" guarantee. If for any reason you wish to return the purchase, simply let us know within 30 days of your order that you have destroyed all copies of the product in your possession, in electronic or any other form, and you will receive a prompt refund of the full purchase price. No problem, no hassle!