quantative methods

Loan Amortization Schedule Required: a) Construct an full amortization schedule for the scenerio below. Details to include pmt #, payment amount, interest portion and principal portion. b) Determine how much interest was paid over the term of the loan. Details: Kirkland Corporation obtained a $100,000 loan for a new business venture. The loan contract requires payments at the end of each quarter including interest at 4% compounded semi- annually. The loan is to be repaid by equal quarterly payments over a five year term. I/Y P/Y C/Y N PV compounding NOM C/Y EFF FV payment NOM C/Y EFF PMT Pmt # Payment Interest Portion Principal Portion Principal Balance