Question: what am I doing wrong? excel A bond has an 8-year maturity, a 8% coupon paid monthly, and $1000 par value. The required rate of

what am I doing wrong? excel

A bond has an 8-year maturity, a 8% coupon paid monthly, and $1000 par value.
The required rate of return (yield to maturity)on the bond is 6%.
Compute the price of the bond today using the appropriate Excel formula
SHOW WORK HERE, HIGHLIGHT FINAL ANSWER IN YELLOW
PV ($5.21) monthly int rate 8%*12 0.96
RATE 0.96 coupon 60/12 5
NPER 96 nper 8 * 12 96
PMT 5
FV 1000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

(4) Suppose a firm issued an 8% coupon (paid semiannually), $1,000 par value bond 30 years ago. The bond now has 10 years left until its maturity date but the firm is having financial difficulties....

Q:

Please answer these so I can verify that I got my answer correct 1) A convertible bond is a. like a straight bond plus a warrant, but the warrant in the convertible bond cannot be sold separately b....

Q:

1) A convertible bond is a. like a straight bond plus a warrant, but the warrant in the convertible bond cannot be sold separately b. like stock plus a put option on the stock c. like stock plus a...

Q:

15min time limit 1) A convertible bond is a. like a straight bond plus a warrant, but the warrant in the convertible bond cannot be sold separately b. like stock plus a put option on the stock c....

Q:

A 6% semiannual coupon bond matures in 5 years. The bond has a face value of $1,000 and a current yield of 6.8535%. What are the bond's price and YTM? (Hint: Refer to Footnote 6 for the definition of...

Q:

7 of 15 (0 complete) This Qui rk Yield to maturity. What is the yield of each of the following bonds if interest (coupon) is paid monthly? Test Par Value Coupon Rate M Par Value Coupon...

Q:

It is now January 1c 2018 and you are considering the purchase of an outstanding bond that was issued on January 1,2016. It has an 8.5%annual coupon and had a 30 year original maturity.(It matures on...

Q:

Need help with the attached please. Let me know if you have any questions. THanks Question 1 A convertible bond is Question 2 Hedging Question 3 Viewing things in terms of options Question 4 You ask...

Q:

I need the answer now. Please just provide an answer to each question. No need to explain. Thank you. The volatility of a bond is given by A) duration/(1 + yield) only. B) slope of the curve relating...

Q:

Problem 7-15 Bond valuation Bond X is noncallable and has 20 years to maturity, a 11% annual coupon, and a $1,000 par value. Your required return on Bond X is 8%; and if you buy it, you plan to hold...

Q:

18. A series resonant circuit has a resistance of 10 , an inductance of 2.2 mH, a capacitance C of 0.068 uF and a resonant frequency of 13.019 kHz. The magnitude of the inductive reactance X and...

Q:

A truss hinged at A and supported on rollers at D is loaded as shown in the figure below. The force in member BC is ___________ kN.

Q:

Describe the structure of the U.S. Federal Reserve System and explain how its actions and policies affect the supply of money.

Q:

Find the radius of gyration of a plate covering the region bounded by x=3, x=5, y=0, and y=4 with respect to the y-axis.

Q:

Identify possible reasons for ineffective performance.

Q:

Describe the components of a needs assessment.

Q:

Describe the benefits of employee orientation.