When evaluating an investment, understanding the Modified Internal Rate of Return (MIRR) is crucial for informed decision-making. MIRR is a financial metric that takes both the cost of investment and the reinvestment rate for positive cash flows into account. This makes it a more accurate reflection of an investment’s true profitability than the traditional Internal Rate of Return (IRR). In this article, we will explore how to calculate MIRR using a BA II Plus calculator.

1. Setting Up Your Calculator:

Before starting, it’s essential to ensure that your calculator is correctly set up.

– Press [2nd] followed by [FORMAT].

– Check if your desired number format is selected (e.g., US or European style). If not, keep pressing [ENTER] until you have the correct one.

– Press [2nd] followed by [QUIT] to return to the main screen.

2. Inputting Cash Flows:

To calculate MIRR, you need to input your investment’s expected cash flows.

– Press [CF] to access the cash flow worksheet.

– Clear any previous data by pressing [2nd] followed by [CLR WORK].

– Input your initial cash outflow (investment cost) by entering the number and pressing [ENTER].

– Use the arrow keys to move from one cash flow period to another.

– Input other cash flows (either positive or negative) for each period, pressing [ENTER] after each input.

3. Setting Finance Rate and Reinvestment Rate:

Next, set both the finance rate (cost of investment) and reinvestment rate.

– Press [I/Y] to access the interest rate worksheet.

– Enter the finance rate value as a percentage and press [ENTER].

– Press the down arrow key and enter the reinvestment rate value as a percentage. Press [ENTER].

4. Calculating MIRR:

Now that everything is set up, you can calculate MIRR.

– Press [IRR] followed by [CPT].

– Press [MIRR]. The result should appear on the calculator’s screen.

5. Interpreting the Result:

The displayed MIRR represents the percentage return on your investment, accounting for both your investment cost and any gains you would receive from reinvesting positive cash flows. An MIRR value higher than your finance rate implies that the investment is profitable, while a lower value indicates it may not be a wise choice.

In conclusion, calculating MIRR using a BA II Plus calculator is a straightforward process that allows you to account for costs and reinvestment rates when evaluating investment opportunities. Following these steps ensures accurate results, which are essential in making informed decisions.