How to Build a Debt Payoff Calculator in Excel or Google Sheets (NPER, FV and PMT, Tested)

Months to debt-free, exact total interest (with the smaller last payment), what an extra payment saves, and the payment for a target date. Formulas tested against a month-by-month model.