Question

Calculate the duration of the following loans (please indicate if you make any additional assumptions): a. An interest o...

Calculate the duration of the following loans (please indicate if you make any additional assumptions):

a. An interest only loan with a maturity of 7 years that pays an annual coupon of 6% and has a 5.875% yield to maturity.

b. A 12-year zero coupon loan.

c. A 4-year amortized loan with an interest rate of 3.75% with quarterly payments and a 4.625% yield to maturity.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

We will use the excel function DURATION to get the duration of each of the bonds. Let's assume a settlement price of 01/01/2019 (this assumption is required to make DURATION function work, this assumption will not impact your final output.

Please note that the duration of a zero coupon loan is same as the term of the loan.

к [ 104 Bond 105 Settlement date 106 Maturity date 107 Coupon 1/1/2019 1/1/2026 6% 1/1/2019 1/1/2031 0% 1/1/2019 1/1/2023 3.7

Add a comment
Know the answer?
Add Answer to:
Calculate the duration of the following loans (please indicate if you make any additional assumptions): a. An interest o...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • a. A 6% coupon bond paying interest annually has a modified duration of 7 years, sells...

    a. A 6% coupon bond paying interest annually has a modified duration of 7 years, sells for $820, and is priced at a yield to maturity of 9%. If the YTM decreases to 8%, what is the predicted change in price ($) using the duration concept? (2 marks) b. A bond with annual coupon payments has a coupon rate of 6%, yield to maturity of 7 % , and Macaulay duration of 12 years. What is the bond's modified duration?...

  • 9. A financial institution is considering a customer’s request for a 12-year $15 million loan, with annual interest paym...

    9. A financial institution is considering a customer’s request for a 12-year $15 million loan, with annual interest payments and the principal due at maturity. The financial institution requires a 22.5% risk adjusted return on capital for this loan. Its cost of funds is 3.875% for this loan and it will charge a 2% risk premium. Historically, the worst 1% of comparable loans experience a 125 basis point increase in the credit risk premium. The financial institution’s typical origination fee...

  • please explain how to calculate in a financial calculator Question 2. MTV Corporation has 7 percent coupon bonds on...

    please explain how to calculate in a financial calculator Question 2. MTV Corporation has 7 percent coupon bonds on the market with a par of $1,000 and 8 years left to maturity. The bonds make semi-annual interest payments. If the market interest rate on these bonds is 6 percent, what is the current bond price? Question 3. Jones Corporation has zero coupon bonds on the market with a par of $1,000 and 8 years left to maturity. If the market...

  • please show how to calculate with financial calculator. Question 3. Jones Corporation has zero coupon bonds on the m...

    please show how to calculate with financial calculator. Question 3. Jones Corporation has zero coupon bonds on the market with a par of s1,000 and 8 years left to maturity. If the market interest rate on these bonds is 6 percent what is the current bond price? (Use the semi-annual interest payment model.) Question 4. Wilson Corporation has 5 percent coupon bonds on the market with a par of $1,000 and 6 years left to maturity. The bonds make annual...

  • Show work (40 Points) As the new management trainee at the Rossville Bank of Tennessee, you...

    Show work (40 Points) As the new management trainee at the Rossville Bank of Tennessee, you are given balance sheet, you have been asked by the bank president to determine the current mark-to-market balance sheet and modified durations for the bank's assets and liabilities. Fill in the blanks with market values and modified durations. Some of this information is already filled in. The bank has only three types of assets and two types of deposits. Amounts are in S thousands...

  • please show how to compute with a financial calculator. thank you! Bond Valuation Exercises: OM Question...

    please show how to compute with a financial calculator. thank you! Bond Valuation Exercises: OM Question 1. GTF Corporation has 5 percent coupon bonds on the market with a par of $1,000 and 10 years left to maturity. The bonds make annual interest payments. If the market interest rate on these bonds is 7 percent, what is the current bond price? Question 2. MTV Corporation has 7 percent coupon bonds on the market with a par of $1,000 and 8...

  • *Please explain the answers* 1- .Although you will get a 30-year mortgage, you plan to prepay...

    *Please explain the answers* 1- .Although you will get a 30-year mortgage, you plan to prepay the loan by making an additional payment each month along with your regular payment. How much extra must you pay each month if you wish to pay off the loan in 20 years? A) $ 24.56 B) $ 54.88 C) $100.80 D) $103.28 E) $106.86 24. 2- J&J Manufacturing just issued a bond with a $1,000 face value and a coupon rate of 8%....

  • You observe the following Treasury bills and bond prices available in Saudi Arabia Bond/Bill

    .1.  You observe the following Treasury bills and bond prices available in Saudi Arabia Bond/Bill Bond/Bill principalTime to maturityAnnual couponBond price1000.25099.21000.50098.31000.75097.210016.2 (Quarterly payments)1021001.256.6 (Quarterly Payments)102.5a) Calculate continuously compounded zero rates for maturities of 3 months, 6 months, 9 months, 12 months and 15 months. b) Calculate the par yield for the following bonds: I. A 12-month bond that pays coupons semiannually. II. A 12-month bond that pays coupons quarterly. c) What is the continuously compounded yield on the coupon-paying bonds, which mature in 1 and...

  • 12. Mortgage payments Mortgages, loans taken to purchase a property, involve regular payments at fixed intervals...

    12. Mortgage payments Mortgages, loans taken to purchase a property, involve regular payments at fixed intervals and are treated as reverse annuities. Mortgages are the reverse of annuities, because you get a lump-sum amount as a loan in the beginning and then you make monthly payments to the lender You've decided to buy a house that is valued at $1 million. You have $400,000 to use as a down payment on the house, and want to take out a mortgage...

  • 19. Mortgage payments Aa Aa Mortgages, loans taken to purchase a property, involve regular payments at...

    19. Mortgage payments Aa Aa Mortgages, loans taken to purchase a property, involve regular payments at fixed intervals and are treated as reverse annuities. Mortgages are the reverse of annuities, because you get a lump-sum amount as a loan in the beginning, and then you make monthly payments to the lender. You've decided to buy a house that is valued at $1 million. You have $500,000 to use as a down payment on the house, and want to take out...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT