Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

 What is the yield to maturity (total yield) on a $1,000 bond selling for 113

Finance Apr 01, 2021

 What is the yield to maturity (total yield) on a $1,000 bond selling for 113.42 if the bond has a coupon rate of 9% and matures in ten years?

Expert Solution

Computation of Yield to Maturity using Rate Function in Excel:

=rate(nper,pmt,-pv,fv)

Here,

Rate = Yield to Maturity = ?

Nper = 10 years

PMT = $1,000*9% = $90

PV = $1,000*113.42% = $1,134.2

FV = $1,000

Substituting the values in formula:

=rate(10,90,-1134.20,1000)

Rate or Yield to Maturity = 7.08%

Archived Solution
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment