Present Value (PV)

The Present Value (PV) is a measure of how much a future cash flow, or stream of cash flows, is worth as of the current date.

Conceptually, any future cash flow expected to be received on a later date must be discounted to the present using an appropriate rate that reflects the expected rate of return (and risk profile).

Why? The time value of money (TVM) principle, which states that a dollar received today is worth more than a dollar received on a future date.

Table of Contents

How to Calculate Present Value (PV)

The present value (PV) concept is fundamental to corporate finance and valuation.

The core premise of the present value theory is based on the time value of money (TVM), which states that a dollar today is worth more than a dollar received in the future.

Therefore, receiving cash today is more valuable (and thus, preferable) than receiving the same amount at some point in the future.

In short, there are two primary reasons that support this theory:

Present Value Formula (PV)

The present value (PV) formula discounts the future value (FV) of a cash flow received in the future to the estimated amount it would be worth today given its specific risk profile.

The formula used to calculate the present value (PV) divides the future value of a future cash flow by one plus the discount rate raised to the number of periods, as shown below.

Present Value (PV) = Future Value ÷ (1 + Discount Rate) ^ Number of Periods

How Does the Discount Rate Affect Present Value?

Since money received on the present date carries more value than the equivalent amount in the future, future cash flows must be discounted to the current date when thought about in “present terms.”

Moreover, the size of the discount applied is contingent on the opportunity cost of capital (i.e. comparison to other investments with similar risk/return profiles).

All future receipts of cash (and payments) are adjusted by a discount rate, with the post-reduction amount representing the present value (PV).

Given a higher discount rate, the implied present value will be lower (and vice versa).

When estimating the intrinsic value of an asset, namely via the discounted cash flow (DCF) method, how much a company is worth is equal to the sum of the present value of all the future free cash flows (FCFs) the company is expected to generate in the future.

More specifically, the intrinsic value of a company is a function of its ability to generate future cash flows and the risk profile of the cash flows, i.e. the company’s value is equal to the sum of the discounted values of its future free cash flows (FCFs).

Present Value (PV) Calculation Example

Let’s say you loaned a friend $10,000 and are attempting to determine how much to charge in interest.

If your friend has promised to repay the entire borrowed amount in five years, how much is the $10,000 worth on the date of the initial borrowing?

Assuming that the discount rate is 5.0% – the expected rate of return on comparable investments – the $10,000 in five years would be worth $7,835 today.

Present Value vs. Future Value: What is the Difference?

The present value (PV) calculates how much a future cash flow is worth today, whereas the future value is how much a current cash flow will be worth on a future date based on a growth rate assumption.

While the present value is used to determine how much interest (i.e. the rate of return) is needed to earn a sufficient return in the future, the future value is usually used to project the value of an investment in the future.

Present Value Calculator (PV)

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

1. Excel PV Calculation Exercise Assumptions

Suppose we are calculating the present value (PV) of a future cash flow (FV) of $10,000.

We’ll assume a discount rate of 12.0%, a time frame of 2 years, and a compounding frequency of one.

2. PV Formula in Excel

Using those assumptions, we arrive at a PV of $7,972 for the $10,000 future cash flow in two years.

Thus, the $10,000 cash flow in two years is worth $7,972 on the present date, with the downward adjustment attributable to the time value of money (TVM) concept.

Present Value (PV) Calculator

3. Discounted Cash Flow Analysis Assumptions (DCF)

In the next part, we’ll discount five years of free cash flows (FCFs).

Starting off, the cash flow in Year 1 is $1,000, and the growth rate assumptions are shown below, along with the forecasted amounts.

4. DCF Present Value (PV) Calculation Example

If we assume a discount rate of 6.5%, the discounted FCFs can be calculated using the “PV” Excel function.

=PV(rate, nper, pmt, [fv], [type])

The sum of all the discounted FCFs amounts to $4,800, which is how much this five-year stream of cash flows is worth today.

Present Value (PV) Example Calculation

Step-by-Step Online Course

Everything You Need To Master Financial Modeling

Enroll in The Premium Package: Learn Financial Statement Modeling, DCF, M&A, LBO and Comps. The same training program used at top investment banks.