Net Future Value (NFV) Calculator — Project All Cash Flows to a Future Date
Calculate the net future value (NFV) of any investment by compounding all cash flows to a future date. Enter cash flows for each period, set your rate, and see the NFV alongside the equivalent NPV — with interactive charts and a period-by-period breakdown.
| Period | Cash Flow ($) |
|---|
What Is Net Future Value (NFV)?
NFV Definition in Corporate Finance
Net Future Value (NFV), also called Net Future Worth (NFW), is the sum of all cash flows compounded forward to a specific future date. While NPV answers "What is this investment worth today?", NFV answers "What will this investment be worth at the end of its life?"
How NFV Differs from Simple FV
NFV is particularly useful in scenarios where you want to know the accumulated wealth or cost at a specific future point:
- Capital budgeting — Evaluating the total future wealth a project creates.
- Investment comparison — Comparing the terminal value of competing investments.
- Project evaluation — Assessing whether a project creates positive future value.
- Education planning — Projecting the total cost or savings at a future date.
NFV Formula & Calculation
The General NFV Formula
The NFV is calculated by compounding each cash flow forward to the final period n:
Where:
- CFt = Cash flow at time t (negative for outflows, positive for inflows)
- r = Discount/investment rate per period
- n = Total number of periods
- (n − t) = Number of periods remaining for cash flow at time t to compound
Converting NPV to NFV
Alternatively, if you already know the NPV:
This shortcut is useful when you've already calculated the NPV and want to express the result in future terms.
NFV vs NPV: When to Use Which
When NFV Gives Better Decision Insights
Both metrics measure the same economic reality from different time perspectives:
Side-by-Side Comparison Table
| Feature | NPV | NFV |
|---|---|---|
| Time reference | Present (time 0) | Future (time n) |
| Direction | Discounts cash flows back | Compounds cash flows forward |
| Question answered | "What is it worth today?" | "What will it be worth at the end?" |
| Units | Present dollars | Future dollars |
| Decision rule | Accept if NPV > 0 | Accept if NFV > 0 |
| Relationship | NFV = NPV × (1+r)n | |
| Best used when | Comparing to today's investment cost | Projecting terminal wealth |
Step-by-Step NFV Calculation Example
Example: 5-Year Equipment Investment
Consider an investment with a 10% discount rate and the following cash flows:
| Period (t) | Cash Flow | Remaining Periods | FV Factor | Compounded Value |
|---|---|---|---|---|
| 0 | −$50,000 | 5 | 1.6105 | −$80,526 |
| 1 | $15,000 | 4 | 1.4641 | $21,962 |
| 2 | $18,000 | 3 | 1.3310 | $23,958 |
| 3 | $20,000 | 2 | 1.2100 | $24,200 |
| 4 | $12,000 | 1 | 1.1000 | $13,200 |
| 5 | $10,000 | 0 | 1.0000 | $10,000 |
| NFV (Sum) | $12,793 | |||
Interpreting Positive vs. Negative NFV
The NFV is $12,793, meaning this investment creates $12,793 in value by the end of Year 5. The equivalent NPV = $12,793 / (1.10)5 = $7,944. Both are positive, confirming this is a worthwhile investment.
NFV in Capital Budgeting
Using NFV for Project Comparison
In capital budgeting, NFV serves as a complementary metric to NPV. While most textbooks focus on NPV, NFV has practical advantages in certain contexts:
- Terminal wealth comparison — When stakeholders care about the total value created by the end of a project, NFV provides a more intuitive answer than NPV.
- Reinvestment assumption — NFV explicitly shows how cash flows grow when reinvested at the discount rate, making the reinvestment assumption more transparent.
NFV with Unequal Project Lifespans
- Project ranking — For mutually exclusive projects with different lifespans, NFV calculated at a common future date enables fair comparison.
- Fund management — Portfolio managers often want to know the terminal value of investment strategies, making NFV more naturally applicable.
The decision rules are identical to NPV:
- NFV > 0: Accept the project — it creates future wealth above the required return.
- NFV = 0: Indifferent — the project exactly meets the required return.
- NFV < 0: Reject — the project fails to meet the required return.
Frequently Asked Questions
-
Net Future Value is the sum of all cash flows (both inflows and outflows) compounded forward to a specific future date at a given rate. It measures the total accumulated value of a project or investment at the end of its life. If NFV > 0, the investment is profitable; if NFV < 0, it destroys value.
-
NPV discounts all cash flows to the present, while NFV compounds all cash flows to a future date. They are related by NFV = NPV × (1+r)n. Both always give the same accept/reject decision and the same project ranking. NFV simply expresses the result in future dollars rather than today's dollars.
-
Use NFV when you want to know the accumulated value at a specific future date — for example, what a series of investments will be worth when you retire, or the total value of a project at completion. Use NPV when you need to compare the investment to its current cost in today's dollars.
-
No. Because (1+r)n is always positive, multiplying NPV by it cannot change the sign. If NPV is positive, NFV is positive; if NPV is negative, NFV is negative. They always agree on whether a project should be accepted or rejected.
-
A negative cash flow represents a cash outflow — money leaving your pocket. Typically, Period 0 has a large negative cash flow (the initial investment), while subsequent periods have positive cash flows (returns). The initial outflow is compounded forward, which increases its magnitude and must be overcome by the compounded inflows for a positive NFV.
-
Excel doesn't have a built-in NFV function, but you can combine NPV with compounding:
=NPV(rate, CF1:CFn) * (1+rate)^n + CF0 * (1+rate)^n. Or compound each cash flow individually with=SUMPRODUCT(CFs, (1+rate)^(n - periods)). Our calculator does this automatically for you.