Suppose you want to buy a house which is valued at $100,000. You decide to borrow the money from the bank at an interest rate of 12.5 percent and agree to make equal annual end of year payments over the next 5 years to fully repay the loan. Also assume you work as a financial manager at the bank and you want to prepare a loan amortization schedule yourself. So, prepare the loan amortization schedule showing separate columns for the Year, beginning- of-year principal, loan payment, interest amount, principal amount and end-of-year principal.