If an annuity has quarterly payments and interest compounded semi$-$annually, our annuity calculation requires the semi$-$annual compound interest rate be adjusted to quarterly compounding before being entered into our hand calculation or Excel's financial functions.