ItemPriceFree Download
 
Please feel at home to download tadXL for FREE, currently valued at US$119
 
Whether you require analyzing a single investment to find investor's ROI or are eager to evaluate a whole portfolio of investments, tadXL will deliver the results. And how about analyzing a "portfolio of portfolios" or even a portfolio of "portfolios of portfolios"
 
tadXL v2.5 allows one dimensional financial analysis, the next many iterations of tadXL will allow for N-dimensional financial analysis starting with 2 dimensional TVM equation in v3.0 followed by 3 dimensional time value of money equation in v4.0 and moving upwards
 
Free 32-bit tadXL v2.5 full versionFREEDownload Now
Free 64-bit tadXL v2.5 full versionFREEDownload Now
 
In near future you will be get to download newer versions of tadXL v3.0, v4.0, v5.0, v6.0, v7.0, v8.0, v9.0 and v10.0
 
Don't be surprised if you find out that Microsoft has copied ideas from tadXL to offer similar financial functions in its upcoming Excel 2015. And you thought Microsoft would respect others copy protected work, yet that is not the case this time with that software Giant pirate
 
NPV using TI BA II plus

With this tutorial on Texas Instruments BA II Plus, you will learn how to find net present value of an annuity with constant and uneven cash flows

NPV Example with constant cash flows

We will illustrate how you can use TI BA II Plus to find net present value with an annuity that has constant payment. Let's assume Sears Corporation purchased a machinery for $7,000 it will save company $3,000 annually for next 5 years. The company's cost of capital is 12%. How do we find the net present value with TI BA II Plus

NPV Step by Step using TI BA II Plus

To Press Display
Set all variables to default 2nd reset enter RST 0.00
Select Cash Flow worksheet. CF CF0= 0.00
Enter initial cash flow. 7000 +/- ENTER CF0= -7000.00
Enter cash flow for years 1 to 5
3000
5
ENTER
ENTER
C01=
F01=
3000.00
5
Access interest rate variable NPV I= 0.00
Enter interest rate per period. 12 ENTER I= 12.00
Compute net present value. CPT NPV= 3814.33

NPV Example with uneven cash flows

A four year financial project has net cash flows of $20,000; $25,000; $30,000, and $50,000 in the next four years. It will cost $75,000 to implement the project. If the required rate of return is 20%, conduct a discounted cash flow calculation to determine the net present value (NPV).

NPV Step by Step using TI BA II Plus

To Press Display
Set all variables to default 2nd reset enter RST 0.00
Select Cash Flow worksheet. CF CF0= 0.00
Enter initial cash flow. 75000 +/- ENTER CF0= -75000.00
Enter cash flow for year 1
20000 ENTER C01=
F01=
20000.00
1
Enter cash flow for year 2
25000 ENTER C02=
F02=
25000.00
1
Enter cash flow for year 3
30000 ENTER C03=
F03=
30000.00
1
Enter cash flow for year 4
50000 ENTER C04=
F04=
50000.00
1
Access interest rate variable NPV I= 0.00
Enter interest rate per period. 20 ENTER I= 20.00
Compute net present value. CPT NPV= 501.54

Finding NPV in Excel

=tadNPV( rates, inflation, tax_rates, cashflows, adjust_for_inflation, frequencies, types, compoundings, periods, concentrations, hair_cuts, rate_rigged_by )