How to Make a Spreadsheet to Track a Loan. ... Play with the loan rate, and see exactly how much your monthly payment changes, as the rate increases or decreases.

Payment status, such as “Paid” or “Outstanding.” To enhance functionality, add dropdown menus or checkboxes for payment status. This makes it easier to update and track payments.