Please use the excel PMT Function
Question 1: Loan Payments. If we take out an $8,000 car loan that calls for 48 monthly payments at an APR of 10 percent, what is your monthly payment? What is the effective annual interest rate on the loan.
Question 2: Amortizing Loan. we take out a 30-year $100,000 mortgage loan with an APR of 6 percent and monthly payments. In 12 years you decide to sell your house and pay off the mortgage. What is the principal balance on the loan?
Several years ago , castles in the sand INC, issued a bond at face value at a yield to maturity of 7 percent , now with 8 year left until the maturity of the bonds, the company has run into hard times and the yield to maturity on the bonds has increased to 15 percent. What has happened to the price of the bond? Suppose that investors believe that Castles can make good on the promised coupon payments, but that the company will go bankrupt when the bond matures and the principal comes due. The expectation is that investors will receive only 80 percent of face value at maturity. If they buy the bond today, what yield to maturity do they expect to receive?