## Dr. Kevin Bracker; Dr. Fang Lin; and Jennifer Pursley

Most of TVM analysis on your Financial Calculator can be done with the 5-key approach. The five keys are as follows

N ⇒ This key refers to the number of periods

I% ⇒ This key refers to the interest rate (do not enter as a decimal ⇒ 10% would be 10 not 0.10). Sometimes this interest rate is referred to as a discount rate or rate of return.

PV ⇒ This key refers to the Present Value

PMT ⇒ This key refers to the Annuity Payment

FV ⇒ This key refers to the Future Value

In the TI-83 and TI-84, the 5-key approach application is referred to as the TVM Solver. To access this, choose “APPS” and then “Finance”. Once you’ve done this you will see a screen with several finance applications, choose the TVM Solver. When entering values into your financial calculator you enter a value for each of the “keys” that you know. For example, if we want to put in 10 periods, we would go to the N= line and put in 10. Sometimes you will need to enter a negative value. To do this, you must use the “(-)“ key on your calculator instead of the “–“ key. The order that you enter the variables doesn’t matter as long as you enter the four that you know first, and then solve for the fifth. To solve, you just move the cursor to the line of the variable you are trying to find, then press the “alpha” shift and “solve”. Now let’s go through several examples.

# EXAMPLE ONE – Future Value of a Single Cash Flow

You are investing $10,000 today and want to know how much you will have after 6 years if you earn a 7% rate of return over the 6-year time frame. Since you are starting with$10,000, that is your present value. You have 6 years, so the number of time periods is 6. The 7% rate of return means you have a 7% interest rate. In this example we are not using an annuity, so we are going to set the Annuity Payment to 0. Note that I/Y and C/Y should be set to 1 because we are dealing with annual periods.

N= 6
I%= 7
PV= 10000
PMT= 0
FV= -15,007.30
I/Y= 1
C/Y= 1

# ANNUITIES

An annuity is a sequence of equal periodic cash flows. Many financial situations can be modeled as an annuity. For instance, calculating a mortgage payment on a home is an annuity. Simple retirement analysis can be structured as an annuity. Also, bond valuation is partially modeled as an annuity since we receive a fixed coupon payment each year. With annuities, we assume cash flows come at the end of each period. Note that there is a variation referred to as an “Annuity Due” that assumes cash flows come at the BEGINNING of the period. We will not work with Annuity Due situations in this text, however it is relatively simple to do so by making a simple adjustment to your calculator. We will include a sample example to illustrate this, however, in this textbook we will assume cash flows come at the end of each period in all of our annuity problems.

Assume you have just won a $10 Million Lottery Jackpot. However, instead of paying you the$10 Million up front, you have the choice of receiving $5 Million today or$400,000 per year at the end of each year for the next 25 years. Assuming a 6% discount rate, which would you prefer? In order to answer this, you need to find the PV of the $400,000 per year for 25 years. This is done as follows: N= 25 I%= 6 PMT= 400000 FV= 0 PV= 5,113,342.46 (Note that we dropped the negative sign) P/Y= 1 C/Y= 1 Since the annuity is worth more than$5 Million to us, we would prefer to take the $400,000 per year for the next 25 years. # EXAMPLE THREE A – Lottery Jackpot Annuity Due (OPTIONAL) Since many lotteries actually give you your first installment TODAY if you take the installment plan, we could make the example more realistic by assuming the prize was paid as$400,000 per year at the BEGINNING of each year for the next 25 years and leave everything else the same. To adjust your calculator for this, you just need to slide the highlight over to BEGIN at the bottom of the screen. Now repeat the calculation from the Example Three

N= 25
I%= 6
PMT= 400000
FV= 0
PV 5,420,143.01 (Note that we dropped the negative sign)
P/Y= 1
C/Y= 1
PMT:   END   BEGIN

To set it back, just toggle the slide the highlight back to END when you do the next problem on the bottom line. Remember, in class we will almost always use end of period payments.

You are offered an investment that pays you $1000 per year for the next 30 years. Assuming a 10% discount rate, what is this investment worth to you today? # EXAMPLE FOUR – I want to be a Millionaire You want to become a millionaire and plan to do so through a savings/investment plan. Assuming you want to reach your goal in 20 years and anticipate earning a 10% rate of return, how much must you save at the end of each year in order to reach your goal? N= 20 I%= 10 PV= 0 FV= 1000000 PMT$17,459.62
I/Y= 1
C/Y= 1

This means you will need to save $17,459.62 per year in order to achieve your goal. ### PRACTICE PROBLEM FOUR Since saving$17,459.62 per year is not realistic for most of us, let’s try some adjustments. Calculate how much you would need to save under the following conditions

1. 30 years at 10%
2. 40 years at 10%
3. 30 years at 7.5%
4. 30 years at 5%

Note the large difference that time and rate of return make on savings. Having a short savings horizon or earning a low rate of return mean you must save considerably more each year to reach the same goal. This is especially important for retirement planning.

# EXAMPLE FIVE – Changing Periods per Year

Now assume that you want to accumulate $1 million in 30 years, but instead of saving each year, you are going to save every two weeks (we will earn a 10% annual rate of return). There are 26 2-week periods in each year, so now you have to adjust your calculator to work with 26 periods per year. You can do this as follows by just putting 26 into the P/Y line (note that the C/Y line will automatically adjust to 26 as well after you put in the 26 for the P/Y line). Now your calculator will recognize that you are not making annual contributions to your savings plan, but instead making a contribution every other week. Another issue when you change the number of periods per year is to recognize that the N key stands for periods and not necessarily years. Since all of our previous examples were done using 1 P/YR, the number of periods and years were the same. However, now 1 year will have 26 periods. Therefore, 30 years is equivalent to 780 periods (calculated by taking 26 times 30). Now that our adjustments have been made, we are ready to enter the problem into our calculator. N= 780 I%= 10 PV= 0 FV= 1000000 PMT$202.75
P/Y= 26
C/Y= 26

If we save $202.75 every two weeks for the next 30 years and earn a 10% rate of return, we will have$1,000,000 at the end of the 30th year.

### PRACTICE PROBLEM FIVE

Repeat the above example, but now assume weekly payments (52 weeks per year) instead of payments every two weeks. Once you are done, figure out how much you are saving per year under both the once per week and once every other week alternatives and compare this to the answer we got in Practice Problem Four-1. Why are the answers different?

# EXAMPLE SIX – Solving for Interest Rates

Let’s keep working with the goal of becoming a millionaire. However, instead of calculating how much you must save, we’ll assume you can save $3000 per year and want to find the rate of return you will need to earn to reach your goal. This time we will give ourselves 35 years of saving$3000 per year.

N= 35
PV= 0
PMT= -3000
FV= 1000000
I%= 10.89%
P/Y= 1
C/Y= 1

# EXAMPLE SEVEN – Combining PMT, FV, and PV

Here is one last variation on our millionaire example. This time, instead of starting with nothing, let’s assume that we already have $40,000 and plan to save an additional$3000 per year over the next 35 years. Now, what rate of return must we earn in order to accumulate $1,000,000 at the end of the 35th year? N= 35 PV= -40000 PMT= -3000 FV= 1000000 I%= 7.63% P/Y= 1 C/Y= 1 Note that here, we must make both the Present Value and the Annuity Payment negative as they both are flowing away from us into the savings plan. The Future Value will flow back to us at the end of the time period so it is positive. ### PRACTICE PROBLEM SEVEN You want to retire a millionaire and have accumulated$20,000 which you are putting into your retirement plan. In addition, you plan to earn a 9% rate of return. How much must you save PER MONTH over the next 35 years in order to reach your goal?

Video: Introduction and 5-Key Approach (TI-83 or TI-84)

# EXAMPLE EIGHT – Uneven Cash Flow Stream – Present Value

Assuming a 6.5% discount rate, solve for the present value of the following cash flow stream.

Here we can no longer use the 5-key approach (technically, we CAN…it would just be a lot more tedious). Instead we want to move to the cash flow worksheets on our financial calculator. The cash flow worksheet for the TI-83/TI-84 is actually a finance application called the Net Present Value (NPV). You can access it buy going to your finance applications and scrolling down until you see the one labeled npv(. Once you select this, it is critical that you enter your data in the correct format. The format is npv(k, CF0, {CFLIST}, {CFFREQUENCIES} and then you use the Solve (which is an Alpha shift) to get the solution. So, in this example, your k is 6.5%; CF0 is 0 (there is no value for the year 0 cash flow – note that some problems WILL have a value there and it can be either positive or negative); CFLIST is 400, 600, 1000, 1300 (there should be a value for each cash flow sequence); and CFFREQUENCY is 5, 4, 1, 6. This gives us: npv(6.5, 0, {400, 600, 1000, 1300}, {5, 4, 1,6} and when we solve we should get a value of $7047.87. If you get an error message, make sure that (A) everything is entered in the right order, (B) you’ve got all your commas in place, and (C) that you use the right brackets {}. Note that the frequencies add up to 16 which matches the length of the time line. If your frequencies do not add up to the length of the timeline, you miscounted. # EXAMPLE NINE – Uneven Cash Flow Stream – Future Value We can use a similar process to solve for the future value of an uneven cash flow stream. However, we will start by doing the exact same steps we did to get the present value. The reason is that to get the future value of an uneven cash flow stream we first (A) solve for the present value of the cash flow stream and then (B) figure out what that value will grow to over the time horizon. So, if the problem would have given you the same cash flow stream as above, but instead asked what it would be worth as of year 16 (the end of the time horizon). As we found above, the present value of the cash flow stream (what is worth today) is$7047.87. So, if we want to know what the cash flow stream is worth in year 16, we just bring the present value ($7047.87) forward 16 years at the 6.5% rate of return using the 5 key approach as follows: N= 16 I%= 6.5 PV= 7047.87 PMT= 0 FV= -19,304.19 I/Y= 1 C/Y= 1 This tells us that the value of the cash flows will grow to$19,304.19 at the end of the 16 year time horizon if we can invest them to earn a 6.5% rate of return. Note that the PV of an uneven cash flow stream will always be less than the sum of all the individual cash flows ($13,200 in this example) and the FV of an uneven cash flow stream will always be more than the sum of all the individual cash flows. # EXAMPLE TEN – Uneven Cash Flow Stream – Rate of Return Assume you could buy the cash flow stream in this example for$6000 today. Based on this, what would your rate of return be? To do this, we will use the IRR application on the calculator. Go to the Applications ⇒ Finance and then scroll down until you find the irr( application. The format is irr(CF0, {CFLIST}, {CFFREQUENCIES} and then you use the Solve (which is an Alpha shift) to get the solution. In any problem like this, your CF0 must be negative (you are paying something today to buy the cash flow stream) – if you enter the CF0 as positive, you will get an error. For this problem, we are paying $6000 today to buy the cash flow stream, so our CF0 is -$6000 and we would set it up as follows:

irr(-6000, {400, 600, 1000, 1300}, {5, 4, 1,6} and when we solve we should get a value of 8.39%.

This is the average annualized rate of return we earn over the 16 year time horizon on our $6000 investment. ### PRACTICE PROBLEMS EIGHT, NINE AND TEN Assuming a 12.5% discount rate, solve for the present value and future value of the following time line. Also, assuming you could buy the cash flow stream for$80,000, what would your rate of return be?

Video: Uneven Cash Flow Streams (TI-83 or TI-84)

# EXAMPLE ELEVEN – Effective Annual Rate

You are offered the choice of 7.8% compounded quarterly or 7.6% compounded daily. Which is a better investment (assuming both have the same risk)? In order to address whether we are better with the higher interest rate compounded less frequently or the lower interest rate compounded more frequently, we need to make them stable comparison by converting both to their annual compounding equivalent. We do this with the effective annual rate. It can be done with a formula or your financial calculator. If we use the formula, it looks like this:

where

keff represents the annual equivalent
knom represents the nominal or stated interest rate
m represents the number of compounding periods per year

Plugging in our values for the 7.8% compounded quarterly we would get:

And for the 7.6% compounded daily we would get:

In this case, the 7.8% compounded quarterly is better. If using the formulas, be sure to (A) carry out your calculations to several decimal places (or better yet, don’t round at all until you are done), (B) plug in rates into the formula as decimals, and (C) round your final answer to 2 decimal places in percentage terms. You can also do this with the financial calculator as follows:

Go to your Applications, choose Finance and then scroll down until you get to the effective interest rate app ⇒ eff(.

To enter values into this app, you use the format eff(NOM, C) where NOM is the nominal rate (as a percent, not decimal) and C is the compounding periods per year. This would give us:

eff(7.8, 4) SOLVE ⇒ 8.03% and eff(7.6,365) SOLVE ⇒ 7.90%

### PRACTICE PROBLEM ELEVEN

You are offered investments of 12% compounded annually, 11.75% compounded quarterly, or 11.5% compounded weekly. Assuming the same risk, which would you prefer?

Video: Effective Annual Rate (TI-83 or TI-84)

N= 45
I%= 9.5
PV= 400
PMT= 0
P/Y= 1
C/Y= 1

N= 30
I%= 10
PMT= 1000
FV= 0
P/Y= 1
C/Y= 1

N= 40
I%= 10
PV= 0
FV= 1000000
P/Y= 1
C/Y= 1

N= 30
I%= 5
PV= 0
FV= 1000000
PMT= $15,051.44 P/Y= 1 C/Y= 1 ## Practice Problem 5 Calculate Number of Periods ⇒ 52 x 30 = 1560 N= 1560 I%= 10 PV= 0 FV= 1000000 PMT=$101.07
P/Y= 52
C/Y= 52

Annual Savings Required to Accumulate $1,000,000 in 30 years at 10% A) Saving at the end of each year ⇒$6,079.25
B) Saving at end of every 2 weeks ⇒ $202.75 x 26 =$5,271.50
C) Saving at end of each week ⇒ $101.07 x 52 =$5,255.64

The more frequently we make contributions, the less we have to save each year. This is because of the compounding effect. When we make annual contributions, we earn no return the first year. With weekly contributions we start earning a return during the second week.

N= 35
PV= 0
PMT= -4500
FV= 1,000,000
I/YR= 9.13%
P/Y= 1
C/Y= 1

N= 420
I/Y= 9
PV= -20,000
FV= 1,000,000

## Practice Problem 9

Step 1: Solve for Present Value (See solution to 8) ⇒ $63,878.58 Step 2: Bring forward to end of year 13 N= 13 I%= 12.5 PV= 63,878.58 PMT= 0 FV=$295,350.73
P/Y= 1
C/Y= 1

## Practice Problem 10

irr(-80000, {10000, 12000, 5000, 8000, 10000}, {3, 5, 2, 1, 2} SOLVE ⇒ 7.93%

## Practice Problem 11

Since the 12% compounded annual is already annual, there is no need for an effective annual rate. The 11.75% compounded quarterly is eff(11.75, 4) SOLVE ⇒ 12.28% and the 11.5% compounded weekly is eff(11.5, 52) SOLVE ⇒ 12.17%, making the 11.75% quarterly the best deal.