write my assignment 4211

Create an amortization schedule for a five-year loan of $63,000. Assume the interest rate is 8 percent per year, and the loan agreement calls for a principal reduction of 12,600 every year Year 1Begining Balance Total Payment Interest Payment Principal Ending PaymentYear 2Begining Balance Total Payment Interest Payment Principal Ending PaymentYear 3Begining Balance Total Payment Interest Payment Principal Ending PaymentYear 4Begining Balance Total Payment Interest Payment Principal Ending PaymentYear 5Begining Balance Total Payment Interest Payment Principal Ending Payment