Gallery
About Financial Essentials
Share
Explore
Sample Uses

icon picker
NPV

Determine the net present value for a series of cash flows

Calculate NPV

Enter the discount rate and number of cash flows per year (12 for monthly, 4 for quarterly, 1 for annual):
1
Discount Rate (annual)
Cash Flows per Year
NPV
20.00%
1
$14,129.45
There are no rows in this table

List the cash flows to be analyzed:
Use negative numbers for outflows and positive numbers for inflows
You may paste numbers into the Cash Flow column from another source; the number of rows will expand to accommodate the number of rows pasted
Delete unused rows

Clear Cash Flow Table
Delete Empty Rows
1
2
3
4
5
6
7
8
9
10
11
Cash Flow
Notes
-$100,000
$10,000
$12,000
$15,000
$18,000
$20,000
$22,000
$25,000
$27,000
$30,000
$300,000
There are no rows in this table

NPV at various discount rates

You may change the discount rates to include in the analysis
1
2
3
4
5
6
Discount Rate
NPV
0%
$379,000
10%
$110,200
20%
$14,129
30%
-$23,268
40%
-$38,513
50%
-$44,624
There are no rows in this table


Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.