Tag Uneven Cash Flows

Excel’s NPV Function Doesn’t Calculate Net Present Value

The article explains that Excel's NPV function does not truly calculate Net Present Value because it doesn’t include the initial investment. Instead, it calculates the present value of uneven cash flows. To get real NPV, subtract the initial outlay from the NPV result or include it in the cash flow range and adjust the time period. It also introduces a third method using the PV function with arrays to achieve the same result in one step.

TI 83 and TI 83 Plus Tutorial, Part III

Uneven Cash Flow Streams 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 lump sums and regular annuities. In this section we will take a look at how to use the TI 83 Plus to calculate the present and future values of uneven…

Bond Valuation on the HP 19BII Calculator

A bond is a debt instrument, usually tradable, that represents a debt owed by the issuer to the owner of the bond. Most commonly, bonds are promises to pay a fixed rate of interest for a number of years, and then to repay the principal on the maturity date. In the U.S. bonds typically pay interest every six months (semi-annually),…

HP 19BII 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 lump sums and annuities. In this section we will take a look at how to use the HP 19BII to calculate the present and future values of uneven cash flow streams. We will also…

HP 12C 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 lump sums and annuities. In this section we will take a look at how to use the HP 12C to calculate the present and future values of uneven cash flow streams. We will also…

HP 10BII+ Tutorial, Part III

Uneven Cash Flows 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 lump sums and regular annuities. In this section we will take a look at how to use the HP 10BII+ to calculate the present and future values of uneven cash flow…

HP 17BII 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 HP 17BII to calculate the present and future values of uneven cash flow streams. We will also see how to…

HP 10B 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 lump sums and regular annuities. In this section we will take a look at how to use the HP 10B to calculate the present and future values of uneven cash flow streams. We will…

Microsoft Excel as a Financial Calculator, Part III

In the previous section we looked at using the basic time value of money functions to calculate present and future value of annuities (even cash flows). In this section we will take a look at how to use Excel to calculate the present and future values of uneven cash flow streams. We will also see how to calculate net present…

HP 20b Tutorial, Part III

Uneven Cash Flows 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 lump sums and annuities. In this section we will take a look at how to use the HP 20b to calculate the present and future values of uneven cash flow streams.…

TI 84 Plus Tutorial, Part III

Uneven Cash Flow Streams 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 lump sums and regular annuities. In this section we will take a look at how to use the TI 84 Plus to calculate the present and future values of uneven…

BAII Plus Tutorial, Part III

This article focuses on using the TI BAII Plus financial calculator to calculate the present and future values of uneven cash flow streams. It explains how to handle uneven cash flows, net present value (NPV), internal rate of return (IRR), and modified internal rate of return (MIRR). The tutorial provides step-by-step instructions for inputting cash flows and calculating these financial metrics, emphasizing the importance of correct data entry and using specific keys on the calculator. The article aims to help readers effectively evaluate investments with varying cash flows using the TI BAII Plus.

TI BAII Plus Pro Tutorial, Part III

This article focuses on using the TI BAII Plus Professional financial calculator to calculate the present and future values of uneven cash flow streams. It explains how to handle uneven cash flows, net present value (NPV), internal rate of return (IRR), and modified internal rate of return (MIRR). The tutorial provides step-by-step instructions for inputting cash flows and calculating these financial metrics, emphasizing the importance of correct data entry and using specific keys on the calculator. The article aims to help readers effectively evaluate investments with varying cash flows using the TI BAII Plus Professional.