Skip to content
Gallery
Coda template previous rows and interest rates
Preceding values
previous row alternative
Rolling Total
Moving Average
Nett Present Value (NPV)
Interest rates
More
Share
Explore

icon picker
Nett Present Value (NPV)

calculate outcomes based on years, amount and interest rates
Net Present Value (NPV) is a financial metric used to determine the profitability of an investment or project. It calculates the present value of cash inflows and outflows over a specific time period, taking into account the time value of money. The concept behind NPV is that a dollar received in the future is worth less than a dollar received today, due to factors such as inflation and the opportunity cost of capital.

⁠
Add row
⁠
⁠

⁠
NPV
1
amount
percentage
years
nett present value
discount
compound interest
return
1
€5,000.00
2%
3
€4,711.61
-€288.39
€5,306.04
€288.39
2
€1,000.00
4%
5
€821.93
-€178.07
€1,216.65
€178.07
3
€50,000.00
1%
8
€46,174.16
-€3,825.84
€54,142.84
€3,825.84
4
€10,000.00
3%
13
€6,809.51
-€3,190.49
€14,685.34
€3,190.49
5
€20,000.00
2%
21
€13,195.52
-€6,804.48
€30,313.33
€6,804.48
6
€500.00
5%
20
€188.44
-€311.56
€1,326.65
€311.56
7
€2,500.00
4%
17
€1,283.43
-€1,216.57
€4,869.75
€1,216.57
8
€75,000.00
1%
13
€65,899.69
-€9,100.31
€85,357.00
€9,100.31
9
€15,000.00
3%
10
€11,161.41
-€3,838.59
€20,158.75
€3,838.59
10
€30,000.00
7%
5
€21,389.59
-€8,610.41
€42,076.55
€8,610.41
11
€100,000.00
2.5%
10
€78,119.84
-€21,880.16
€128,008.45
€21,880.16
12
€5,000.00
4.5%
9
€3,364.52
-€1,635.48
€7,430.48
€1,635.48
There are no rows in this table
⁠
⁠

To calculate NPV, the cash flows are discounted back to their present values using a predetermined discount rate or cost of capital. If the NPV is positive, it indicates that the investment is expected to generate a return greater than the discount rate and is considered financially viable. Conversely, if the NPV is negative, it suggests that the investment may not be profitable.
NPV is a widely used financial tool for evaluating investment opportunities and making informed decisions. It helps in determining whether an investment will create value for the company or individual and provides a basis for comparing different investment options.

⁠
​
⁠
→
The total period is 2.72 year
⁠
| the money value today for these
3
⁠
periods you see below

⁠
add period with percentage
⁠
⁠
⁠
Clear table - start over again
⁠
⁠

NPV complex
Name
percentage
fromDate
endDate
years
valueToday
1
Period 1
5%
1/24/2024
1/24/2025
1
-€952.38
2
Period 2
3%
1/25/2025
1/25/2026
1
-€970.87
3
Period 3
2%
1/26/2026
10/15/2026
0.72
-€985.84
There are no rows in this table
⁠
⁠

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.