Part 3: Loan Amortization 4. You purchase a truck and finance the entire purchase price. The total amount of your loan is $47,500. You obtain an annual interest rate of 5.0% based on your credit score. The loan lasts 5 years, and payments are made monthly. Calculate the monthly fixed payment. b. Complete this loan amortization table for the first 3 months of your loan (You need to show your work for at least row 1): Period Beginning of Period Balance Fixed Payment Amount {=PMT) Interest Paid Principal Paid Remaining Principal 1 2 3 c. What will the remaining balance of your loan be at the end of the 6th year (end of period #60)?