Education Technology

Solution 30211: Computing Net Present Value (NPV), Modified Internal rate (MIRR), and Internal Rate of Return (IRR) Using a TI-Nspire™ Family Products.

How do I compute NPV, MIRR, and IRR using a TI-NSPIRE family handheld or software?

Commands Syntax.

irr(CF0,CFList [,CFFreq])

CF0 is the initial cash flow at time 0; it must be a real number.
CFList is a list of cash flow amounts after the initial cash flow CF0.
CFFreq is a list in which each element specifies the frequency of occurrence for a rouped (consecutive) cash flow amount, which is the corresponding element of CFList. The default is 1; if you enter values, they must be positive integers < 10,000.

The following examples will demonstrate how to compute NPV, MIRR, and IRR.

For example:

Initial cash flow is -100
Interest rate is 7%
Cf1=10 Frequency=2
CF2=-9 Frequency=3
CF3=20 Frequency=5

What is the NPV, MIRR, and IRR?

1) Press [Home] and select Lists & Spreadsheets.
2) Press [10] [enter] [-9] [enter] [20] [enter] [Ctrl] [7].
3) Press [Tab] [k] [Tab] [l] [enter] [Tab].
4) Press [2] [enter] [3] [enter] [5] [enter]


5) Press [Home] and select Calculator

Calculate NPV:

1) Press [menu] [8: Finance] [4: Cash Flows] [1: Net Present Value]
2) Press [7] [,] [-] [1] [0] [0] [,] [k] [,] [l] [Enter]

Calculate IRR:

1) Press [menu] [8: Finance] [4: Cash Flows] [2: Internal Rate of Return]
2) Press  [-] [1] [0] [0] [,] [k] [,] [l] [Enter]

Calculate MIRR:

1) Press [menu] [8: Finance] [4: Cash Flows] [3: Modified Internal Rate of Return]
2) Press  [i] [r] [r] [(]  [-] [1] [0] [0] [,] [k] [,] [l] [Right Arrow] [,] [7] [,] [-] [1] [0] [0] [,] [k] [,] [l] [Enter]

Please Note: You can alternatively copy the IRR result by pressing [Up Arrow] then [Enter] instead of  computing the value within MIRR if you computed IRR before MIRR as listed in the image below.

Please see the TI-Nspire CX, TI-Nspire CX CAS, TI-Nspire and TI-Nspire CAS guidebooks for additional information.