About Financial Essentials
Share
Explore
About Financial Essentials
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
⁠


Gallery
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.