Things You'll Need:
- Know your loan balance
- Know your APR
- computer
- Microsoft Excel
-
Step 1
Open Microsoft Excel. At the bottom of the worksheet you will see 3 Tabs, Sheet1, Sheet2, Sheet3.
-
Step 2
Using the right button on your mouse, right click on Sheet1 and select Insert from the menu.
-
Step 3
Go to the Spreadsheet Solutions Tab and Select Loan Amortization from the list. Click OK.
-
Step 4
Now plug in your loan information and it let Excel do the rest of the work!













