Business Analysis Made Easy Business Analysis Tools Small Business Finance Decision Making Models Regression Analysis Invention Submission Create A Graph Trademark Application
Business Analysis

NPV Calculator

"Net Present Value is today's value for a project's lifetime of cash flows."

This NPV calculator will calculate net present value for a series of cash flows. See Calculate NPV for a discussion of what this means.

The Calculator

You will see two series of cash flows. Each series of cash flows support the net present value results at the bottom. To obtain a NPV for your cash flows, you need to supply the actual cash flows from each project. You will also need to supply the discount rate. Be sure to clear out the numbers to zero for the years not needed. The year column can be changed by just changing the first year. Play close attention to the numbers that you put into your analysis. You don't want the express "Garbage in, garbage out." to apply to an analysis that you are using to make an important business decision.



What It Means

Use the net present value as a comparison number between projects. If cash flows are generating a present value higher than the investment, then the highest net present value wins. If you are generating present values of costs with little or no positive cash flow, then you want to chose the lowest present value.

Spreadsheets And Cashflow Analysis

Summary

Once you have used the NPV calculator to calculate net present value for your projects, you can make a rational decision about which project is most economical for your situation.

Business Analysis
NPV Calculator to Business Analysis Made Easy
© 2006 - 2008 Stellar Force