But what if I told you there’s a straightforward way to handle this using Excel’s PMT function ... off interest and how much is applied to reducing the principal balance.