The cash flow range. Excel allows a user to get an internal rate of return and a net present value of an investment using the NPV and IRR functions. NPV F 1 rn where PV Present Value F Future payment cash flow r Discount rate n the number of periods in the future is based on future cash flows.
For example project X requires an initial investment of 100 cell B5.
Consider an investment of 50000. In the example shown the formula in F6 is. If theres one cash flow from a project that will be paid one year from now the calculation for the net. If playback doesnt begin shortly try restarting your device.