2.4 TVM and Other Cash Flow Patterns
There are a variety of other common cash flow patterns for which we can perform time value of money calculations. In reality, we can evaluate any stream of cash flows by using FV = PV × (1 + i)n or PV = FV / (1 + i)n for each cash flow. In some instances, however, this technique is not practical and can be circumvented by clever application of the concepts we already know. Here we will discuss three additional cash flow patterns: perpetuities, annuities due, and uneven cash flows.
Perpetuities
A perpetuity is an infinite stream of equally spaced, equal cash flows. Figure 1-5 provides an example of a perpetuity—notice that the payments are of equal size ($1,000), come at equal intervals, and continue forever. In a sense, a perpetuity is just an annuity with an infinite number of periods (n = ∞).
Finding the present value of a perpetuity by using PV = FV / (1 + i)n to discount each individual cash flow would be impossible given that there is an infinite number of cash flows. Instead, since a perpetuity is just an infinite annuity, we can start by looking at the equation for the present value of an annuity:
where:
PMT = the perpetuity payment
n = the number of payments
i = discount rate
We already stated that a perpetuity is an annuity with an infinite n. Think about what will happen mathematically to this formula as the value of n increases to infinity. As n becomes very large, the (1 / (1 + i))n term becomes essentially zero, leaving us with:
Thus, while using the annuity equation alone to calculate the present value of a perpetuity appears impossible, the truth is that perpetuities are very easy to value—simply divide the annual payment by the discount rate.
Example: Present Value of a Perpetuity
What should you be willing to pay in order to receive $10,000 annually forever, if you require 8% per year on the investment?
Though it appears suspiciously easy, the solution to this problem is simply the $10,000 annual payment divided by the 8% interest rate:
Do Perpetuities Really Exist?
Yes! In addition to the issuance of "perpetual bonds," perpetuity valuation is also important in a number of charitable settings. For instance, people often want to establish perpetual gifts for universities, hospitals, and other civic organizations. These "endowments" frequently take the form of an investment account that is structured to provide a perpetual income to the organization. However, in finance, we more commonly encounter perpetuities as part of financial modeling. Hence, while this concept is important in practice, you will find that in the typical finance class perpetuities are frequently used to understand and evaluate more complex securities.
With an 8% required rate of return, this infinite cash stream is actually worth $125,000 to us today.
Annuities Due
Earlier we examined ordinary annuities, or annuities in which the payments occur at the end of the period, i.e. after a one-period delay. An annuity due, in contrast, is an annuity whose payments occur at the beginning of the period. Thus an An annuity that pays at the end of each period. that starts today, at time 0, will not make its first payment until time 1 while an An annuity that pays at the beginning of each period. starting at the same time will make its first payment at time 0. Consider Figure 1-6. We see a three-payment, $1000 per payment annuity. But, is it an ordinary annuity or an annuity due?
In this case, we could evaluate the cash flows either as an ordinary annuity or as an annuity due. But, there is one important difference. Recall from the example for calculating the present value of an annuity that the first annuity payment came at time 1 because we assumed that the annuity started at time 0 and made end-of-period payments (notice that time 1 is the end of the first period). Hence, when we calculated the present value, we obtained the value at time zero—one period before the first payment! This is NOT the case with annuity-due calculations. If we perform an annuity-due calculation, the resulting present value will be at the time of the first payment. This point is subtle, but it is important for two reasons: 1) the difference in value between annuities and annuities due can be significant, and 2) this is a high-likelihood mess-up area on exams for beginning finance students. See Figure 1-7 for an illustration of the timing of the cash flows. Also, note that the difference in the value of an ordinary annuity and an annuity due is caused by the assumption of when the first payment comes and the resulting algebra—there is no deep economic insight.
So, how do we calculate the value of an annuity due? Let's think about the same three-year annuity that we've worked with previously (three payments of $1000 with a discount rate of 8% starting today), only now we change the timing of the payments to the beginning of the year. This means that the first payment will come at time zero.
Generally speaking, there are two ways to calculate the present value of an annuity due:
Method 1
Remember earlier how in Excel we had the Type argument and we promised to get back to it? Well, here it is. If we switch the Type to "1", then we are telling Excel we are doing an annuity due. Here is how we would do this problem in Excel:
= PV(.08,3,–1000,0,1) = 2783.26,
. . . the same answer we got with the two other methods.
Use the ordinary annuity method to find the PV of all payments other than the first payment.
In our example, we are looking for the present value at time zero. The first payment of $1000 comes at time zero. Therefore, the "present value" of the first payment is known (the value today of $1000 to be received today is obviously $1000). All we need to do is find the present value of the other payments using the ordinary annuity method and then simply add in the first payment. Using your financial calculator (after setting it up), the keystrokes will be:
–1000 PMT
8 I / Yr
2 N
Solve: PVpmts 2 and 3 = $1,783.26
Annuity due = $1,783.26 + $1,000 = $2,783.26
Method 2
N=2, I%=8, PMT=–1000, FV=0
PMT:END
Solve: PV=$1783.26 ("Alpha" "Enter")
Annuity Due = $1783.26 + $1000 = $2,783.26
Set calculator to "Begin Mode" and solve for value of all payments.
Your financial calculator is set up to handle annuity due problems. Hence, you can change your calculator to the "Begin Mode" and solve for present value of the annuity due as follows:
N=3, I%=8, PMT=–1000, FV=0
PMT: BEGIN
Solve: PV=$2783.26 ("Alpha" "Enter")
At first glance, you may prefer Method 2. However, you need to be very careful with this approach. Most annuity questions involve ordinary annuity calculations. If you set your calculator to Begin Mode and then forget to change it back to the End Mode, you will probably be very disappointed in your score on the next exam.
Solving for the How much spending power money has at a point in the future. of an annuity due is easiest when using the Begin Mode on your calculator. Similarly to the present value calculation, we can calculate the future value of this same annuity as:
N=3, I%=8, PV=0, PMT=–1000
PMT: BEGIN
Solve: FV=$3506.11 ("Alpha" "Enter")
Enter Begin Mode
1000 PMT
8 I / Yr
3 N
Solve: FV = $3,506.11 (ignore the negative sign on your screen)
In Excel, this solution would look like
=FV(Rate, Nper, Pmt, Pv, Type) or
=FV(.08,3,–1000,0,1) = 3506.11
Without looking, can you figure out whether the annuity due or the ordinary annuity is more valuable? If you're having trouble, look at the picture of the cash flows in Figure 1-8 and ask yourself if you'd rather have the annuity due shown or an ordinary annuity (hint: the first payment for the ordinary annuity would come at time 1).
Recall that in previous examples we calculated the future and present values of this same three-year, $1,000 payment annuity as an An annuity that pays at the end of each period.. With end-of-year payments, we calculated a future value at time 3 of $3,246.40 and a present value at time 0 of $2,577.10. Looking back to our annuity-due calculations, we calculated the future value to be $3,506.11 and the present value to be $2,783.26. In both cases, the value of the annuity due is greater than the value of the ordinary annuity. Hopefully, you were able to reason this to be the case. With an annuity due we receive our payments earlier than we would with an ordinary annuity. As we learned at the beginning of this topic, because of inflation, risk, and opportunity, money today is worth more than money tomorrow. Hence, earlier payments make an annuity due more valuable both today and in the future than an ordinary annuity of equal length and payments.
Uneven Cash Flows
Consider the cash flow stream shown in Figure 1-9. Even though the cash flows all come at even intervals, because they are not of equal size this cannot be considered an annuity. It is also not a perpetuity because of its finite length. This cash flow stream falls in the broad category called uneven cash flows. Unfortunately, there is no simplified method for finding the future or present value of an uneven cash flow stream. When all of the cash flows are different, we have to discount or compound each individual flow separately using the present/future value approach that we used for single sums and then add them together. For example, to find the present value of the cash flow stream shown in Figure 1-9 at a 10% discount rate, we would perform the calculations shown in Figure 1-10..
An important insight is to realize that you now have tools to solve almost any TVM problem imaginable. Your approach may involve more or fewer calculations, but as long as you keep track of timing you can solve any problem. The uneven cash flow problem presented in Figure 1-11 is a good example—if all else fails simply use the "brute force" approach of discounting/compounding each cash flow individually.
Deferred Annuity
shows a common cash flow stream called a deferred annuity. As the name implies, this is a standard annuity whose first payment is deferred to some point in the future. You might encounter cash flows with a deferred annuity pattern in your personal financial planning. The retirement income question can be viewed as a deferred annuity as well as the process of saving for the education of your children. There are also many applications in the financial markets.
In Excel, we can use the NPV (net present value) function to compute this flow of uneven cash flows. The function is:
= NPV(Rate, Value1, Value2, etc.).
So, filling in the numbers here, we would have
= NPV(.1,2000,4000,6000,7000)+10000
= 24412.95.
Notice that "Value1" in this function is always the cash flow in Period 1. As such, we had to add the Period 0 cash flow on the end, as it does not need to be discounted. We'll use the NPV function a lot more in the capital budgeting topic down the road.
Exercise: Present Value of a Deferred Annuity
Cash flows from this investment are expected to be $40 per year at the end of years 4, 5, 6, 7, and 8 (see Figure 1-11. If you require a 20% rate of return, what is the present value of these cash flows?
We can find the present value of a deferred annuity in a number of ways. For instance, as we did with uneven cash flows we can discount each individual cash flow back to time 0 separately using the formula PV = FV / (1 + i)n. Alternatively, we can find the present value of the annuity at its beginning (which, if we consider it to be an ordinary annuity, will be one period before the first payment) then discount the resultant single sum back to time 0. For this deferred annuity, we would calculate the present value of the annuity at time 3, one year before the first payment is made:
Part 1
N=5, I%=20, PMT=40, FV=0
PMT:END
Solve: PV=–$119.62 ("Alpha" "Enter")
Part 2:
N=3, I%=20, PMT=0, FV=–119.62
PMT:END
Solve: PV=$69.22 ("Alpha" "Enter")
Keystrokes
I = 20
PMT = $40
N = 5
Solve: PV3 = –$119.62 (ignore sign)
Are we done? Remember, we want the present value at time 0. What we have calculated here is the single sum value of the annuity at time 3. Hence, we need to finish the problem by discounting this single sum ($119.62) back to time 0:
Keystrokes
I = 20
N = 3
FV = –$119.62
Solve: PV0 = $69.22
In Excel, we'd do =PV(.2,5,40,0,0) = –119.62.
Then we take the –119.62 as our FV and in Excel we do =PV(.2,3,0,–119.6,0) = 69.22.
What if we had used a different approach to the valuation of the deferred annuity in Figure 1-11? No matter how you discount the cash flows, the present value of this deferred annuity will always be $69.22 as long as we properly account for the timing of the cash flows. You might want to take a few minutes to experiment with other approaches to calculating the present value of this deferred annuity.
Want to try our built-in assessments?
Use the Request Full Access button to gain access to this assessment.