In this video, we will calculate the NPV Using Excel
First, we need to enter the cash flows
In this example, we are using annual flows.
In year 0, we need to enter the initial investment, using a negative value.
Next, enter the estimated future annual flows
Now, enter the discount rate
And finally, enter the NPV formula
NPV(discount rate,range of future flows) - Initial Investment
Thanks!