Amortization Schedule - Student Loan Fixed rate loan at 4.5% 10 year repayment Regular repayment $ Enter values Loan amount (principal) Annual interest rate Loan period in years Start date of loan repayment 30,000.00 4.50% or 0.375% per month 10 or 120 months 1/1/2021 Monthly payment monthly payment left blank for your calculation Put this number in the monthly payment below Number of payments 120 Notes: * (a (a) ( (b) payment payment number date 1 1/1/2021 2 2/1/2021 3 3/1/2021 4 4/1/2021 (c) beginning loan balance 30,000.00 30,112.50 30,225.42 30,338.77 (d) (e) ( of monthly amount of payment amount of payment payment applied to interest applied to principal 112.50 (112.50) 112.92 (112.92) 113.35 (113.35) 113.77 (113.77) (h) ) ending loan balance 30,112.50 * 30,225.42 30,338.77 30,452.54 (a) (b) 6 (c) c * * (d) ( (e) (e) these numbers will be correct once the monthly payment is put in The number of each payment, one per month Payments are due on the first day of each month The first month this is the full loan amount After that, this is the balance of the loan at the beginning of the month, before the payment is made. A fixed rate loan means the payment is the same every month. The beginning loan balance times the monthly interest rate (4.50%/12 = 375% or.00375) The payment amount minus the monthly interest owed. The beginning balance of the loan minus the amount of payment applied to principal. These calculations should give you total months to repayment total payments, total interest paid, and total principal paid with a small amount of rounding error. (h) (i) (0)