Time Value of Money and Other Cash Flow Patterns (2024)

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.

Perpetuity

Figure 1.5: Perpetuity

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:

Present Value of a Perpetuity

PV perpetuity = PMT i

where:

PMT=the perpetuity payment

n=the number ofpayments

i=discount rate

PV annuity = PMT × { 1 [ 1 ÷ ( 1 + i ) ] n i }

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

PV perpetuity = PMT i

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:

PV perpetuity = PMT i = $ 10,000 ÷ 0.08 = $ 125,000

With an 8% required rate of return, this infinite cash stream is actually worth $125,000 to us today.

Perpetuities in Real Life

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 called endowments 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.

Annuity Due

Earlier we examined ordinary annuities, or annuities in which the payments occur at the end of the period, that is, after a one-period delay. An annuity due, by contrast, is an annuity whose payments occur at the beginning of the period. Thus, an ordinary annuity that starts today, at time 0, will not make its first payment until time 1, while an annuity due starting at the same time will make its first payment at time 0. Consider Figure 1.6. We see a three-payment, $1,000 per payment annuity. But, is it an ordinary annuity or an annuity due?

Figure 1.6: Three-Payment Annuity

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.

Figure 1.7: Valuation of an Ordinary Annuity (top) vs. an Annuity Due (bottom)

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 $1,000 with a discount rate of 8% starting today) but change the timing of the payments to the beginning of the year. This means that the first payment will come at time 0.

Generally speaking, there are two ways to calculate the present value of an annuity due.

Method 1

Annuity Due: Method 1 with the TI-83/TI-84

Solve: PV = $1783.26 (press “Alpha” and then “Enter”)

Annuity Due = $1783.26 + $1000 = $2,783.26

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 0. The first payment of $1000 comes at time 0. Therefore, the present value of the first payment is known (the value today of $1,000 to be received today is obviously $1,000). 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 as follows:

PMT = –1000

I/Y = 8

N = 2

Solve: PVpmts 2 and 3 = $1,783.26

Annuity Due = $1,783.26 + $1,000 = $2,783.26

Method 2

Annuity Due: Method 2 with the TI-83/TI-84

N = 3

I% = 8

PMT = –1000

FV = 0

PMT:BEGIN

Solve: PV = $2783.26 (press “Alpha” and then “Enter”)

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 “Begin Mode” and solve for present value of the annuity due as follows:

Enter Begin Mode (see Figure 1.2)

PMT = –1000

I/Y =8

N = 3

Solve: PVannuity due = $2,783.26

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 End Mode, you will probably be very disappointed in your score on the next exam.

Annuity Due Problem in Excel

Remember earlier in Excel when 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 that we are doing an annuity due. Here is how we would do this problem in Excel:

=PV(.08,3,–1000,0,1) = 2783.26

This is the same answer we got with the two other methods.

Future Value of an Annuity Due

Future Value of an Annuity Due with the TI-83/TI-84

N = 3

I% = 8

PV = 0

PMT = –1000

PMT:BEGIN

Solve: FV = $3506.11 (press “Alpha” and then “Enter”)

Solving for the future value of an annuity due is easiest when using the Begin Mode on your calculator. We can calculate the future value of this same annuity similar to how we calculated the present value by doing the following:

Enter Begin Mode

PMT = 1000

I/Y =8

N = 3

Solve: FV = $3,506.11 (ignore the negative sign on your screen)

Excel—Need a Hint?

In Excel, this solution would look like

=FV(rate,nper,pmt,pv,type) or

=FV(.08,3,–1000,0,1) = 3,506.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).


Figure 1.8: Three-Payment, $1,000 Annuity Due

Recall that in previous examples we calculated the future and present values of this same three-year, $1,000 payment annuity as an ordinary annuity. 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

Figure 1.9: 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 Table 1.1.

Table 1.1

Present Value of Uneven Cash Flows

Period CF Keystrokes PV (CF)
0 10,000 None needed (time 0 CF) $10,000.00
1 2,000 2000 FV, 1 N, 10 1/Y; solve PV 1,818.18
2 4,000 4000 FV, 2 N, 10 1/Y; solve PV 3,305.79
3 6,000 6000 FV, 3 N, 10 1/Y; solve PV 4,507.89
4 7,000 7000 FV, 4 N, 10 1/Y; solve PV 4,781.09
PV of Cash Flow Streams: Sum PV of CFs 0–4 $24,412.94

It’s important 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.10 is a good example—if all else fails, simply use the brute force approach of discounting/compounding each cash flow individually.

Calculating NPV in Excel

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],...)

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.

Deferred Annuity

Figure 1.10: Deferred Annuity

Figure 1.10 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 can the process of saving for the education of your children. There are also many applications in financial markets.

Exercise: Present Value of a Deferred Annuity

Cash flows from the investment illustrated above are expected to be $40 per year at the end of years 4, 5, 6, 7, and 8 (see Figure 1.10). 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, just 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.

Present Value of a Deferred Annuity with the TI-83/TI-84

Part 1

N = 5

I% = 20

PMT = 40

FV = 0

PMT:END

Solve: PV = –$119.62 (press “Alpha” and then “Enter”)

Part 2

N = 3

I% = 20

PMT = 0

FV = –119.62

PMT:END

Solve: PV = $69.22 (press “Alpha” and then “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

Excel—Need a Hint?

In Excel, we would do =PV(.2,5,40,0,0) = –119.62.

Then we would take the –119.62 as our FV and input =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.10? 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.

Excel Shortcut

Now that we’ve gotten this far with our Excel skills, here’s a little shortcut tip. In Excel, if the function input is not required as part of the problem, you can just leave it blank and Excel will assume a zero. So for the first part of this example, we could put =PV(.2,5,40) and we would get the right answer. Notice that we simply left off the last two arguments. For the second part, we could have put =PV(.2,3,,–119.6). Notice here that we have two commas after the nper on purpose; we are telling Excel that pmt is zero. Notice that we are also leaving off the last argument (type) because Excel assumes end-of-year payments unless we set type as 1.

Want to try our built-in assessments?

Use the Request Full Access button to gain access to this assessment.

Time Value of Money and Other Cash Flow Patterns (2024)

FAQs

What are the cash flow patterns in time value of money? ›

There are four main types of cash flows related to time value of money:Future value of a lump sum, future value of an annuity, present value of a lump sum, and present value of an annuity. Tables, financial calculators, and spreadsheets are good tools for calculating time value of money.

What is the time value of money and cash flow? ›

The process by which payments (or cash flows) are moved backward in time is called discounting. All time value of money calculations involve either compounding or discounting — that is, moving amounts either forward or backward in time.

What are the 3 main reasons of time value of money pdf? ›

There are three reasons for the time value of money: inflation, risk and liquidity.

What is time value of money in finance CFA Level 1? ›

Time value of money is a concept that refers to the greater benefit of receiving a given amount of money at present rather than in the future due to its earning potential. For example, money could be invested in a bank account and earn interest even overnight.

What are the patterns of cash flow? ›

Steady, cyclical, and irregular are the common cash flow patterns found in businesses. What are the different types of cash flow activities analysed in business studies? Operating, investing, and financing activities are the different types of cash flow activities analysed in business studies.

What are the four types of time value of money? ›

In this section, we will learn how to calculate time value of money. There are four types of tvm calculations including future value of lump sum, future value of an annuity, the present value of lump sum, and present value of annuity.

What are the techniques for time value of money? ›

All time value of money problems involve two fundamental techniques: compounding and discounting. Compounding and discounting is a process used to compare dollars in our pocket today versus dollars we have to wait to receive at some time in the future.

What influences time value of money? ›

The time value of money takes several things into account when calculating the future value of money, including the present value of money (PV), the number of compounding periods per year (n), the total number of years (t), and the interest rate (i).

What is the main idea behind the time value of money? ›

The time value of money is a financial principle that states the value of a dollar today is worth more than the value of a dollar in the future. This philosophy holds true because money today can be invested and potentially grow into a larger amount in the future.

What are the two main sources of time value of money? ›

The exact time value of money is determined by two factors: Opportunity Cost, and Interest Rates.

What is the principle of time value of money? ›

The time value of money (TVM) is the concept that a dollar today is worth more than a dollar tomorrow. Understanding TVM allows you to evaluate financial opportunities and risks. The principle underlies almost every financial and investing decision you make.

What is the relationship between interest rates and the time value of money? ›

Interest rates are a key quantitative representation of the time value of money. When investing in bonds, for example, the interest increases the value of deposited cash over time if left reinvested.

What is the time value of money to make financial decisions? ›

The time value of money helps investors make the best financial decisions: the decisions that will have the most financial returns. Most investors and businesses have many investment opportunities to choose from; using the time value of money helps equalize these opportunities based on timing.

What are the 3 types of cash flows shown on the statement of cash flows? ›

The three categories of cash flows are operating activities, investing activities, and financing activities.

What are the 4 basic time value of money variables? ›

1. What are the four basic parts (variables) of the time-value of money equation? The four variables are present value (PV), time as stated as the number of periods (n), interest rate (r), and future value (FV).

What are three 3 different financial applications of the time value of money? ›

The applications of the time value of money may involve loan valuation, bonds valuation, capital budgeting decisions, investment analysis, and personal finance analysis.

What are the timing cash flows? ›

The timing of cash flows is directly tied to when a company receives or spends money, and it represents the company's ability to generate cash to meet its financial obligations.

Top Articles
Latest Posts
Article information

Author: Annamae Dooley

Last Updated:

Views: 5808

Rating: 4.4 / 5 (45 voted)

Reviews: 92% of readers found this page helpful

Author information

Name: Annamae Dooley

Birthday: 2001-07-26

Address: 9687 Tambra Meadow, Bradleyhaven, TN 53219

Phone: +9316045904039

Job: Future Coordinator

Hobby: Archery, Couponing, Poi, Kite flying, Knitting, Rappelling, Baseball

Introduction: My name is Annamae Dooley, I am a witty, quaint, lovely, clever, rich, sparkling, powerful person who loves writing and wants to share my knowledge and understanding with you.