I am trying to figure out a formula to build an amortization schedule in Excel with a 365/365 accrual base. It appears that the PMT function in Excel calculates monthly payments on a 365/360 basis. I am trying to create this so that I can plug in loan information and it will spit out the same...