Hello,

I am wanting to display annual payments in addition to monthly. I have a formula already, but I'm not sure if it is correct. My formula for monthly, that does figure correctly is =rate/12,term,(amount financed)*((1+(1rate/12)^(12/365)-1)^days to first payment),0,1)*-1. My formula for annual is =rate,term,(amount financed)*((1+(1+rate/12)^(12/365)-1)^days to first payment),0,1)*-1.

Does anyone know if this is correct?