Find the duration of the bond using excel formula with the given information. Duration = Total PV of CF / current bond value Face value = RM1000 Maturity = 6 years  Coupon = 5% Bond Value = RM1020

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)
7th Edition
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Chapter12: Investing In Stocks And Bonds
Section: Chapter Questions
Problem 6FPE
icon
Related questions
Question

Find the duration of the bond using excel formula with the given information.

Duration = Total PV of CF / current bond value

Face value = RM1000

Maturity = 6 years 

Coupon = 5%

Bond Value = RM1020

Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Bond Valuation
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning