What is net present value (NPV)?
Net present value (NPV) is crucial for evaluating investment projects, as it helps us understand the profitability of an investment by considering future cash flows brought to the present. Known in Spanish as BPN or BAN, and in English as NPV, this concept focuses on evaluating whether or not a project should be accepted based on its outcome.
To calculate NPV, we discount future cash flows according to a discount rate and subtract the initial investment. If the NPV is positive, it means that the project is potentially profitable. If it is negative, it does not satisfy the discount rate and should not be accepted. A NPV of zero implies that the project will not generate a net profit.
How to calculate NPV?
Calculating NPV can be done manually or using tools such as Excel. The following elements are taken into account:
- Initial investment: This is the initial expenditure, typified as negative.
- Cash flows: The expected future earnings, discounted to the present.
- Discount rate: Reflects the opportunity cost of capital or other associated risks.
- Salvage value: Possible recovery at the end of the analysis period.
In Excel, the NPV
formula simplifies this process by entering the investment, the periodic flows and the discount rate. Manually, divide each future flow by ((1 + (1 + interest rate))^{{period}} ), add these discounted values, and subtract the initial investment.
How to apply NPV to a practical case?
Let's see how NPV is applied with a detailed example.
Case: Purchase of machinery
Suppose Alfonso buys a backhoe loader for $50 million, with a projection of generating $20 million each year for five years. In the end, he will sell the machine for $10 million. The opportunity rate can be 22% or 25%.
- Determine the initial investment: -50 million (initial expense).
- Calculate cash flows: 20 million per year for five years.
- Include salvage value: 10 million at the end.
- Select discount rate: Determine between 22% and 25%.
For both cases, the NPV formula in Excel is used to calculate the net present values and compare them. When making the calculation:
- With a 22% rate, the NPV is 17 million, which makes the project acceptable.
- With a rate of 25%, the NPV is 13 million, still positive, but lower.
Alfonso should opt for the 22% rate, as it provides a higher NPV. It is important to remember to always choose the project that has the comparatively highest positive NPV.
Practical tips when using the NPV
- Make sure you have all the data: Cash flows, discount rate and salvage value are indispensable.
- Make comparisons: Use NPV to compare similar projects and maximize profitability.
- Consider additional factors: Take into account other variables such as differential rates or news capitalization.
Finally, are you currently evaluating a project? Identifying the cash flows and associated risks can significantly help in your investment decisions. Do not hesitate to use the NPV to project the success of your business ideas and share them to receive more tips!
Want to see more contributions, questions and answers from the community?