NPV Calculator
Free NPV Calculator with IRR analysis. Calculate Net Present Value and Internal Rate of Return for investment decisions, project evaluation, and capital budgeting.
View all free toolsInputs
Results
How to interpret:
- •NPV > 0: Project adds value
- •NPV < 0: Project destroys value
- •IRR > Discount Rate: Meets return requirements
Complete Guide to NPV and IRR Analysis
Net Present Value (NPV) and Internal Rate of Return (IRR) are essential tools for evaluating investment opportunities, comparing projects, and making informed capital allocation decisions.
What is Net Present Value (NPV)?
Net Present Value is a capital budgeting technique that calculates the difference between the present value of cash inflows and outflows over a period of time. NPV uses a discount rate to determine whether a project will add value to your business.
The NPV formula discounts all future cash flows back to their present value, accounting for the time value of money. A positive NPV indicates that the projected earnings (in present dollars) exceed the anticipated costs, making the investment worthwhile.
NPV Calculation Best Practices
1Choose the Right Discount Rate
Use your Weighted Average Cost of Capital (WACC) for corporate projects, or your required rate of return for personal investments. Typical rates range from 8-15% for business projects.
2Be Conservative with Projections
Use realistic cash flow estimates. Over-optimistic projections lead to poor investment decisions. Always run sensitivity analysis with best-case, base-case, and worst-case scenarios.
3Consider All Relevant Cash Flows
Include initial investment, operating cash flows, terminal value, and any salvage value. Don't forget to account for working capital changes and taxes.
4Compare NPV with Other Metrics
Use NPV alongside IRR, payback period, and return on investment (ROI). No single metric tells the complete story.
NPV vs IRR: Which Should You Use?
Pro tip: When NPV and IRR disagree, trust NPV. It directly measures value creation, while IRR can be misleading when comparing projects with different cash flow patterns.
Industry Benchmarks
Discount rates vary significantly across industries based on risk profiles, capital structures, and market conditions. The table below shows typical weighted average cost of capital (WACC) ranges used as discount rates in NPV analysis.
Need More Comprehensive Financial Models?
While this NPV calculator is perfect for quick project evaluations, complex financial decisions require comprehensive modeling.
Alex Tapio
Founder of Finamodel • Professional Financial Modeller • Ex-Deloitte
Frequently asked questions
NPV is the difference between the present value of cash inflows and outflows over time. It helps you determine if an investment will add value. A positive NPV means the project is expected to generate more value than it costs.
IRR is the discount rate that makes the NPV of all cash flows equal to zero. It represents the expected annual rate of return for an investment. Generally, if IRR exceeds your required rate of return (discount rate), the investment is considered acceptable.
The discount rate typically reflects your cost of capital or required rate of return. For businesses, this is often the Weighted Average Cost of Capital (WACC). For personal investments, it might be your opportunity cost or expected market return. Common rates range from 8-15% for most business projects.
Yes! You can compare multiple projects by calculating the NPV and IRR for each. The project with the highest NPV (assuming equal risk and investment size) typically creates the most value. However, also consider IRR, payback period, and qualitative factors.
A negative NPV means the project is expected to destroy value at your chosen discount rate. This suggests you should reject the investment unless there are strategic reasons (market entry, competitive necessity) that justify accepting a negative NPV project.
The calculations are mathematically precise, but remember: garbage in, garbage out. The accuracy of your results depends entirely on the accuracy of your cash flow projections and discount rate assumptions. Always perform sensitivity analysis by testing different scenarios.
Need More Advanced Models?
Explore our professional financial model templates for comprehensive analysis and forecasting.