### CFO Desk

A desk full of tools for the American CFO that allows her to make wise investment decisions.

For the American CFO, we present a collection of online financial calculators.

For the American CFO, we present a collection of online financial calculations.

For the American CFO, we present a collection of financial tutorials.

For the American CFO, we present a collection of financial tables.

For the American CFO, we present a collection of Excel financial functions.

For the American CFO, we present a user guide for TI BA II plus.

For the American CFO, we present free downloads of financial software.

For the American CFO, we present a user guide for TI 83 plus.

With this tutorial on Texas Instruments BA II Plus, you will learn how to find profitability index for an annuity with constant cash flows.

We will illustrate how you can use TI BA II Plus to find profitability index with an annuity that has constant payment. Let's assume McDonalds Corporation purchased a machinery for 52,125. It will save the company $12,000 annually for the next 8 years. The company's cost of capital is 12%. How do we find the profitability index with TI BA II Plus

To | Press | Display | |||

Set all variables to default | 2nd | reset | enter | RST | 0.00 |

Enter number of periods | 8 | N | N= | 8.00 | |

Enter interest rate per payment period | 12 | I/Y | I/Y= | 12.00 | |

Enter Payment | 12000 | +/- | PMT | PMT= | -12000.00 |

Compute present value (ordinary annuity) | CPT | PV | PV= | 59611.68 | |

Divide by initial cash outlay | ÷ | 52125 | = | PI= | 1.14 |

Up until Excel 2013, there weren't any financial functions in Excel to find the profitability index or any of the other financial measures of return on investment - ROI. In 2012, tadXL was released to the software market that offered a large number of financial functions to analyze investments. A number of these different functions calculate profitability index of an investment depending on number of attributes that are known about the investment. The trivial one of these financial function find the financial PI with just the cash flows and the discount rate. The more complicated of the profitability index calculations allow for use of different compounding frequencies, the different lengths of time periods for the investment and the various discounting conventions. Not sure what Microsoft is planning for its upcoming Excel 2015 or 2016 yet if it is found that the next version Excel includes a new set of financial functions than more than likely these will be based on the tadXL series of financial functions. I suppose that rightfull owner of original work takes the back bench whereas those who cheat on the exam get the income from work that others started.

=tadPI ( discount rate, cash flows, compounding, period, concentration )

%