The TI BAII Plus Professional Calculator
BAII Plus Professional Tutorial
Part III
In the previous section we looked at the basic time value of money keys and how to use them to calculate present and future value of annuities. In this section we will take a look at how to use the BAII Plus Professional to calculate the present and future values of uneven cash flow streams. We will also see how to calculate net present value (NPV), internal rate of return (IRR), and the modified internal rate of return (MIRR).
Example 3 — Present Value of Uneven Cash Flows
In addition to the previously mentioned financial keys, the BAII Plus Professional also has the CF (cash flow) key to handle a series of uneven cash flows. To exit from "cash flow mode" at any time, simple press 2nd CPT (quit).
Suppose that you are offered an investment which will pay the following cash flows at the end of each of the next five years:
| Period | Cash Flow |
|---|---|
| 0 | 0 |
| 1 | 100 |
| 2 | 200 |
| 3 | 300 |
| 4 | 400 |
| 5 | 500 |
How much would you be willing to pay for this investment if your required rate of return is 12% per year?
We could solve this problem by finding the present value of each of these cash flows individually and then summing the results (the principle of value additivity). However, that is the hard way. Instead, we'll use the CF key. All we need to do is enter the cash flows exactly as shown in the table. Again, we must clear the cash flow registers first. In this case we need to press 2nd CE/C (note that pressing 2nd FV will have no effect on the cash flow registers). The calculator will prompt you to enter each cash flow and then the frequency with which it occurs. For now, just accept the default frequency of 1 each time, and make sure that the frequency is always at least 1 for each cash flow. Now, press CF then 0 Enter down arrow, 100 Enter down arrow (twice), 200 Enter down arrow (twice), 300 Enter down arrow (twice), 400 Enter down arrow (twice), and finally 500 Enter down arrow (twice). Now, press the NPV key and enter 12 Enter down arrow when prompted for the interest rate. To get the present value of the cash flows, press the down arrow key and then CPT. We find that the present value is $1,000.17922. Note that you can easily change the interest rate by pressing the up arrow key to get back to that step.
Example 3.1 — Future Value of Uneven Cash Flows
Now suppose that we wanted to find the future value of these cash flows instead of the present value. Unlike most other financial calculators, the BAII Plus Professional can do this easily. Since we have already entered the cash flows, just press NPV and enter the interest rate if necessary. Now, press down arrow twice to get to NFV (Net Future Value). Press CPT and you'll see that the future value of these cash flows at 12% per year is $1,762.6575. Pretty easy, huh? (Ok, at least its easier than adding up the future values of each of the individual cash flows.)
Note: At any time, you can return to cash flow mode by pressing CF. This will allow you to scroll through the cash flows that you entered by using the arrow keys. You can change any of these cash flows. However, if you are starting a completely new problem you should always press 2nd CE/C (from within CF mode) to be sure that the cash flows from any previous problem are cleared. Otherwise, you will very likely get a wrong answer.
Example 4 — Net Present Value (NPV)
Calculating the net present value (NPV) and/or internal rate of return (IRR) is virtually identical to finding the present value of an uneven cash flow stream as we did in Example 3.
Suppose that you were offered the investment in Example 3 at a cost of $800. What is the NPV? IRR?
To solve this problem we must not only tell the calculator about the annual cash flows, but also the cost (previously, we set the cost to 0 because we just wanted the present value of the cash flows). Generally speaking, you'll pay for an investment before you can receive its benefits so the cost (initial outlay) is said to occur at time period 0 (i.e., today).
Since we have already entered all of the cash flows, we only need to change the initial outlay. Press CF to get back into cash flow mode, and then input -800 Enter for CF0. Now, press NPV. Note that we need to supply a discount rate so the calculator will now prompt you for it. Input 12 for I when prompted, and then Enter down arrow and CPT. You'll find that the NPV is $200.17922.
Example 4.1 — Internal Rate of Return
Solving for the IRR is done exactly the same way, except that the discount rate is not necessary. This time, you'll press IRR and then CPT, and you'll find that the IRR is 19.5382%.
Example 4.2 — Modified Internal Rate of Return
The IRR has been a popular metric for evaluating investments for many years — primarily due to the simplicity with which it can be interpreted. However, the IRR suffers from a couple of serious flaws. The most important flaw is that it implicitly assumes that the cash flows will be reinvested for the life of the project at a rate that equals the IRR. A good project may have an IRR that is considerably greater than any reasonable reinvestment assumption. Therefore, the IRR can be misleadingly high at times.
The modified internal rate of return (MIRR) solves this problem by using an explicit reinvestment rate. Unfortunately, financial calculators don't have an MIRR key like they have an IRR key. That means that we have to use a little ingenuity to calculate the MIRR. Fortunately, it isn't difficult. Here are the steps in the algorithm that we will use:
- Calculate the total present value of each of the cash flows, starting from period 1 (leave out the initial outlay). Use the calculator's NPV function just like we did in Example 3, above. Use the reinvestment rate as your discount rate to find the present value.
- Calculate the future value as of the end of the project life of the present value from step 1. The interest rate that you will use to find the future value is the reinvestment rate.
- Finally, find the discount rate that equates the initial cost of the investment with the future value of the cash flows. This discount rate is the MIRR, and it can be interpreted as the compound average annual rate of return that you will earn on an investment if you reinvest the cash flows at the reinvestment rate.
Suppose that you were offered the investment in Example 3 at a cost of $800. What is the MIRR if the reinvestment rate is 10% per year?
Let's go through our algorithm step-by-step:
- The present value of the cash flows can be found as in Example 3. Clear the TVM keys and then enter the cash flows (remember that we are ignoring the cost of the investment at this point): press 2nd CE/C to clear the cash flow keys. Now, press CF then 0 Enter down arrow, 100 Enter down arrow (twice), 200 Enter down arrow (twice), 300 Enter down arrow (twice), 400 Enter down arrow (twice), and finally 500 Enter down arrow (twice). Now, press the NPV key and enter 10 Enter down arrow when prompted for the interest rate. To get the present value of the cash flows, press the down arrow key and then CPT. We find that the present value is $1,065.26.
- To find the future value of the cash flows, enter -1,065.26 into PV, 5 into N, and 10 into I/Y. Now press CPT FV and see that the future value is $1,715.61.
- At this point our problem has been transformed into an $800 investment with a lump sum cash flow of $1,715.61 at period 5. The MIRR is the discount rate (I/Y) that equates these two numbers. Enter -800 into PV and then press CPT I/Y. The MIRR is 16.48% per year.
Those are the standard steps to calculate the MIRR. However, the BAII Plus Professional is almost unique among financial calculators in having a net future value function (the HP 17BII is the only other one — even Microsoft Excel doesn't have this function). We can use this function to find the future value without first calculating the present value. To do this, enter the cash flows as before and then press the NPV key. Enter 10 for I and then press the down arrow twice to get to NFV. You will get the same $1,715.61 that we got from step 2 above. Now, continue with step 3 as before.
So, we have determined that our project is acceptable at a cost of $800. It has a positive NPV, the IRR is greater than our 12% required return, and the MIRR is also greater than our 12% required return.
Please continue on to the next page to learn how to solve problems involving non-annual periods.
