Question: i want values as well I/Y P/Y etc A B C D E 3 Required: 4 a) Construct an full amortization schedule for the scenerio
A B C D E 3 Required: 4 a) Construct an full amortization schedule for the scenerio below. Details to 5 include pmt #, payment amount, interest portion and principal portion. 6 7 b) Determine how much interest was paid over the term of the loan. 8 9 Details: 10 Kirkland Corporation obtained a $100,000 loan for a new business venture. The 11 loan contract requires payments at the end of each quarter including interest at 12 4% compounded semi-annually. The loan is to be repaid by equal quarterly 13 14 payments over a five year term. 15 16 17 1/Y 18 P/Y 19 C/Y 20 N 21 PV compounding NOM C/Y EFF 22 FV 23 PMT 24 25 payment NOM C/Y EFF 26 Pmt # Payment Interest Portion Principal Portion Principal Balance 27 Amortization Ferrin A B C D E 3 Required: 4 a) Construct an full amortization schedule for the scenerio below. Details to 5 include pmt #, payment amount, interest portion and principal portion. 6 7 b) Determine how much interest was paid over the term of the loan. 8 9 Details: 10 Kirkland Corporation obtained a $100,000 loan for a new business venture. The 11 loan contract requires payments at the end of each quarter including interest at 12 4% compounded semi-annually. The loan is to be repaid by equal quarterly 13 14 payments over a five year term. 15 16 17 1/Y 18 P/Y 19 C/Y 20 N 21 PV compounding NOM C/Y EFF 22 FV 23 PMT 24 25 payment NOM C/Y EFF 26 Pmt # Payment Interest Portion Principal Portion Principal Balance 27 Amortization Ferrin
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
