How to Create a Sallie Mae Amortization Table

Save
Going to college can be costly, so you should track your student loans.
Going to college can be costly, so you should track your student loans. (Image: education image by Anatoly Tiplyashin from Fotolia.com)

Sallie Mae is a lender for student loans. Using Sallie Mae, students are able to afford colleges by borrowing money now and repaying the money at a later date. When repaying the money, the student needs to pay both interest and payment. To see how much you pay in interest and payment each month, you should create an amortization table for your Sallie Mae loan. After creating this table, you can see how changing your monthly payment will affect the amount of interest and repayment period on the loan.

Draw five columns. Label the columns "Payment Number," "Payment," "Interest Paid," "Principal Paid" and "Remaining Principal."

Number, starting with 0, the amount of loan payments under the "Payment Number" column.

Write the amount borrowed in the "Remaining Principal" column for row 0. Put dashes in the remaining columns in row 0.

Write your payment amount in each row for the "Payment" column. Your payment should be the same for each month.

Divide your annual interest rate by 12 to find the monthly interest rate. Then multiply the monthly interest by the amount in the "Remaining Principal" column from the previous payment row. Enter this amount in the "Interest Paid" column.

Subtract the number in the "Interest Paid" column from the amount in the "Payment" column. Enter the result in the "Principal Paid" column.

Subtract the "Principal Paid" column from the previous payments "Remaining Principal" column and put the result in the "Remaining Principal" column.

Related Searches

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

4 Credit Myths That Are Absolutely False

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!