Change loan rate over time

I’m trying to set up an excel sheet that can automatically calculate current loan debt and rate changes depending on a monthly decreasing debt. Assuming the debt decreases the same amount every month. How can I do this?