Co-Authored By:

##### Asked by: January Bereznitsky

business and finance debt factoring and invoice discounting# How do I track a loan on a spreadsheet?

Open a blank

**Excel spreadsheet**file. Write "**Loan**Amount:" in cell A1 (omit the quotation marks here and throughout), "Interest Rate:" in cell A2, "# of Months:" in cell A3 and "Monthly Payment:" in cell A4. Highlight and bold the text to make them stand out.

In this manner, how do I make a loan repayment spreadsheet?

**Steps**

- Launch Microsoft Excel and open a new spreadsheet.
- Create labels in cells A1 down through A4 as follows: Loan Amount, Interest Rate, Months and Payments.
- Include the information pertaining to your loan in the cells B1 down through B3.
- Enter your loan interest rate as a percentage.

**amortization schedule**is a table that shows each

**loan**payment and a breakdown of the amount of interest and principal. Typically, it will also show the remaining balance after each payment has been made.

Regarding this, how do I keep track of my loans?

**Here are some of the best ways to keep track of your student loan payments:**

- Get Organized to Keep Track of Your Student Loan Payments.
- Take Inventory of Your Loans.
- Set Up Spreadsheets.
- Ask for Help from Your Lender(s)
- Keep Track via Statements.

**Instructions**

- Step #1: Enter the original amount borrowed.
- Step #2: Enter the annual interest rate of the loan.
- Step #3: Enter the monthly payment amount.
- Step #4: Select the month and enter the 4-digit year of the date of the first payment.
- Step #5:
- Step #6:
- Step #7:
- Step #8: