How do you use AVERAGE() correctly for interest calculation?

Average debt balance usually equals AVERAGE(beginning debt, ending debt). Multiply by rate and period fraction. Use it only if ending debt is calculated before interest or if the model intentionally allows iteration. Do not average balances from inconsistent periods or include debt that has been refinanced / repaid mid-period without adjustment.