Chapter 17

Question 1

Loan Amortization Table Calculation

Period – BoP – Interest – Principal – Payment – EoP

Answer 1

Period – BoP – Interest – Principal – Payment – EoP
BoP = Original Principal 
Interest = Interest/12*BoP
Principal = Payment - Interest 
Payment = PMT Formula 
EoP = BoP - Principal