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

This is an AMP page - Open full page! for all features.

Net Present Worth - NPW - of a Stream of Payments

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

Sponsored Links

The present value of a stream of payments - Net Present Worth (NPW) or Net Present Value (NPV) -

can be calculated with a discounting rate

P = F0 / (1 + i)0 + F1 / (1 + i)1 + F2 / (1 + i)2 + .... + Fn / (1 + i)n                    (1)

where

P = Net Present Worth (or Value)

F = cash flow in the future

i = discounting rate

(1 + i)n is known as the "compound amount factor".

Example - the Net Present Worth of an Investment Transaction with a variable Cash Flow

The Net Present Worth - NPW - of investing an amount of 1000 today and saving 250, 200, 300, 310 and 290 the next 5 years - and selling the investment for 310 in the last fifth year - at an interest or discount rate of 10%, can be calculated as

P = (-1000) / (1 + 0.1)0 + (250) / (1 + 0.1)1 + (200) / (1 + 0.1)2 + (300) / (1 + 0.1)3 + (310) / (1 + 0.1)4 + (290 + 310) / (1 + 0.1)5

        = 202

Net Present Worth is positive and the investment is profitable.

Example - Investment In Renewable Energy - Discounted Cash Flow

Net Present Worth Calculator - Variable Cash Flow Stream

The calculator below can be used to estimate Net Present Wort - NPW - in an investment project with up to 20 periods and variable cash flows.

  • money out - negative values
  • money in - positive values
PeriodCash FlowCash Flow
(discounted)
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
SUM
Discount rate (%)

Load Calculator!

Net Present Worth Calculator - Investment with Fixed Cash Flow and Growth Rate

The calculator below can be used to calculate the Net Present Worth for a project with a fixed investment value and fixed return cash flows with a growth rate.

Investment (money out - at period 0)

Fixed Cash Flow (money in - or saved - from period 1)

no. of periods (typical years)

Discount rate (% per period)

Growth rate (% per period - growth of Fixed Cash Flow)


Load Calculator!

Example - Investing in a Solar Power System

An investment of 30000 in a solar power system saves an amount of 1000 on the electricity bill the first year. The electricity price is in the future assumed to rise 10% (growth rate) each year. The alternative use of the money is to invest in a savings account with 3% interest rate (discount rate).

The lifespan of the solar power system is estimated to 20 years (no. of periods).

Using these values in the calculator above gives

P = 12819

IRR = 6.1%

- and the investment is profitable compared to the savings account.

Using the same values - but for a shorter lifespan of 15 years - gives

P = -3581

IRR = 1.6%

- and the investment is not profitable compared to the savings account.

Net Present Value - Spreadsheet

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

Sponsored Links

Related Topics

Related Documents

Sponsored Links

Share

Search Engineering ToolBox

  • the most efficient way to navigate the Engineering ToolBox!

SketchUp Extension - Online 3D modeling!

Add standard and customized parametric components - like flange beams, lumbers, piping, stairs and more - to your Sketchup model with the Engineering ToolBox - SketchUp Extension - enabled for use with the amazing, fun and free SketchUp Make and SketchUp Pro .Add the Engineering ToolBox extension to your SketchUp from the Sketchup Extension Warehouse!

Privacy

We don't collect information from our users. Only emails and answers are saved in our archive. Cookies are only used in the browser to improve user experience.

Some of our calculators and applications let you save application data to your local computer. These applications will - due to browser restrictions - send data between your browser and our server. We don't save this data.

Google use cookies for serving our ads and handling visitor statistics. Please read Google Privacy & Terms for more information about how you can control adserving and the information collected.

AddThis use cookies for handling links to social media. Please read AddThis Privacy for more information.

Topics

Unit Converters

Temperature

oC
oF


Load Calculator!

Length

m
km
in
ft
yards
miles
naut miles


Load Calculator!

Area

m2
km2
in2
ft2
miles2
acres


Load Calculator!

Volume

m3
liters
in3
ft3
us gal


Load Calculator!

Weight

kgf
N
lbf


Load Calculator!

Velocity

m/s
km/h
ft/min
ft/s
mph
knots


Load Calculator!

Pressure

Pa (N/m2)
bar
mm H2O
kg/cm2
psi
inches H2O


Load Calculator!

Flow

m3/s
m3/h
US gpm
cfm


Load Calculator!

9 13

This website use cookies. By continuing to browse you are agreeing to our use of cookies! Learn more