We cover how to calculate the net present value in order to decide between two projects in excel. Net present value is underpinned by the fact that £1 now is worth more than £1 in the future. One reason is because inflation erodes the value of money. Moreover, by investing £1 in a project, this leaves you with £1 less to invest in other alternative investments; which is known as the opportunity cost of capital. To account for the time value of money, the NPV formula uses a discount rate which can be calculated in several ways. In practice, a company may calculate this discount rate using the expected return of other projects with a similar riskiness.
Calculate Net Present Value Using Cash Flows That Occur Irregularly - XNPV Function:
https://youtu.be/Q-_8ZKXd07o
Subscribe for weekly Excel tutorials, techniques and examples:
https://www.youtube.com/channel/UCgdRm6hepAn6Y0FqMZPLiAw?sub_confirmation1
Please share this video with others that may find it useful:
https://youtu.be/wU22dZnE1_4
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
The Excel Hub website: https://theexcelhub.com/
Instagram: https://www.instagram.com/theexcelhub/
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]Overview: (0:00)
NPV Function: (0:51)
Decide Using NPV: (2:13)
How It Works: (2:27)