In: Finance
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.