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.

Input:

Investment (Cost)

Discount Rate

Starting (Date of Invest)

Ending (Date of Invest)

Number fo Year

Once Input is fillup, it automatically calculates the NPV and IRR values.