This template calculates Net Present Value and Internal Rate of Return for an investment.You are expected to enter following inputs.

1.Number of years of investment.

2.Investment start date

3.Discount rate for NPV

4. Stream of expected Cash Flows by year wise(- ve if cash outflow)

Once you are done with inputs,it automatically calculates the NPV and IRR values.