Question
Need answers to all questions please. Need step-by-step answers. Excel is acceptable.Section 14.1A.For each of the following debt amortized by equal payments made at the end of each payment interval, compute (a) the size of the periodic payments; (b) the interest paid, principal repaid, and the balance for the first period;Debt PrincipalRepayment PeriodPayment PeriodInterest RateCompounding Period2.$8,000.005 Years1 Month12%MonthlySection 14.2A.For the following debt amortized by equal payments made at the end of each payment interval, compute (a) the size of the periodic payments; (c) the interest paid, principal repaid, and the balance for the second period.Debt PrincipalRepayment PeriodPayment PeriodInterest RateCompounding Period$36,00020 Years6 Months8%QuarterlyB.The owner of the Blue Goose Motel borrowed $12 500 at 7.1% compounded semi- annually and agreed to repay the loan by making payments of $700 at the end of every three months.(a) How many payments will be needed to repay the loan?(b) How much will be owed at the end of five years?(c) By the end of five years of payments, how much total interest has been paid?Section 14.3A.For the following loan, compute the size of the final payment.PrincipalPeriodic PaymentPayment PeriodPayment Made at:Interest RateCompounding Period$15,400$1,6006 MonthsEnd8%QuarterlyB.A contract valued at $27 500 requires payments of $6000 every six months. The first payment is due in four years and interest is 11% compounded semi-annually.(a) How many payments are required?(b) What is the size of the last payment?(c) How much will be paid in total?(d) How much of what is paid is interest?Review ExerciseMilton Investments borrowed $32 000 at 11% compounded semi-annually. The loan is repaid by payments of $4500 due at the end of every six months.(a) How many payments are needed? (b) How much of the principal will be repaid by the fifth payment? (c) Prepare a partial amortization schedule showing the details of the last three payments and totals.