Net Present Worth - NPW - of a Stream of Payments

Net Present Worth - NPW - or Value of a stream of payments

The present value of a stream of payments

can be calculated with the discounting factor

NPW = F₀ / (1 + i)⁰ + F₁ / (1 + i)¹ + F₂ /(1 + i)² + .... + F_n /(1 + i)ⁿ  (1)

where

NPW = present worth or value

F = future cash flow

i = discount rate

Example - Present Worth of an Investment Transaction

The present worth by investing 1000 today receiving 250 every year in 5 years at an interest or discount rate of 10%, can be calculated

NPW = - 1000 / (1 + 0.1)⁰ + 250 / (1 + 0.1)¹ + 250 /(1 + 0.1)²

            + 250 /(1 + 0.1)³ + 250 /(1 + 0.1)⁴ + 250 /(1 + 0.1)⁵

    = -52.3

PV is negative - and the investment should be avoided.

Net Present Value of a Cash Flow Stream - Online Calculator

• money out - negative values
• money in - positive values

Cash Flows - Period

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

i - Discounting Rate (%)

A more flexible Net Present Value and Internal Rate Calculator in Excel spreadsheet format is available here!

Resources, Tools and Basic Information for Engineering and Design of Technical Applications!

Web The Engineering ToolBox