Need to calculate NPV using VBA in Excel

This is an assignment for which I need to write a VBA function to calculate net present value of cashflows. The template with cashflow is attached. The assignment description is also detailed in a second tab. Let me know if any info is missing. Quick response is appreciated as the deadline for the task is close.