At work we have a specific software that produces analysis for bond deals we work on. I need to replicate one of the reports in excel that relates to present value of cash flow savings. The cash flows are semi-annual (3/1 & 9/1 beginning 9/1/2017) The challenge is I need to be able to PV it back to 6/8/2017. This means the cash flow gets PV'd back to June 8, 2017 on a semi-annual cash flow basis. Also note that the cash flow is related to a municipal bond so it would be on a 30/360 basis instead of act/365.
Below are the cash flows I am trying to PV along with an excel file that shows the results of the PV from the software I am trying to match and my attempt to write a formula that matches the software result. As you can see I can come within $144.86 but need to match perfectly.