Present Value fo Cash Flow Calculation Macro

Hello there,

Please help me create a macro that calculates the present value of cash flows based on the dates of the cash flows and the maturity date of the instrument. I have absolutely no idea about how I should calculate it using a macro.
I have explained the details I the spreadsheet attached because it will make the context clearer.
Please help me.


Thank you so much in advance.