After the cash flow for each period is calculated, the present value (PV) of each one is achieved by discounting its future value (see Formula) at a periodic rate of return (the rate of return dictated by the market). NPV is the sum of all the discounted future cash flows.
Starting (Date of Invest)
Ending (Date of Invest)
Number fo Year
Once Input is fillup, it automatically calculates the NPV and IRR values.