Question: please show how to do this through excel not by hand ! A bond pays interest semiannually. Its coupon rate is 7.6%, a term to

please show how to do this through excel not by hand !

A bond pays interest semiannually. Its coupon rate is 7.6%, a term to maturity of 13 years, a par value of $1,000. Yields or comparable market rates for this bond are 3.9%. Based on this information what is the value or price of the bond? Show 2 decimals, for example: $999.99

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!

Bond Valuation Practice Problems 1. The $1,000 face value ABC bond has a coupon rate of 6%, with interest paid semi-annually, and matures in 5 years. If the bond is priced to yield 8%, what is the...

3.33. Compton Company bonds pay interest semiannually, and they will mature after 10 years. Their current yield is 8%, whereas their yield to maturity is 10%. Find the coupon rate and the market...

Assignment 2 Please answer all questions clearly, and show your work. You may work in pairs. Please make sure only one member per pair submits the completed assignment. 25 points total. 1. A firm...

QUESTION 1 COST OF DEBT. The coupon rate of a bond with a maturity of 6 years is 4.8%. The yield-to-maturity (YTM) on this bond is 5.4%. This bond makes semi-annual coupon payments. Tax rate is 20%....

Please show your work and help me understand how to get the correct answers. 1. A zero coupon bond has a term to maturity of 25 years, a par value of $1,000. Yields or comparable market rates for...

Chapter 1 The Financial Manager and the Firm What is the goal of the firm? What is the main idea behind capital budgeting? We know that there are two ways to finance a projectequity and debt. What...

Bond Valuation A corporate bond has a face value of $1,000. The bond has an 8% coupon rate and it has 13 years to maturity. The interest rate on similar bonds is 6%. Assume interest is paid annually....

Please show step by step. Don''t want answers only... 1A new one-year bond pays interest of 1.04%. A new two-year bond pays interest of 1.46%. Using expectations theory of term structure and assuming...

Calculate Duration and Price Change for the following bonds. Coupon Rate is 6%, Yield to maturity is 5.5%, Maturing in 3 years and pays interest semiannually. Coupon Rate is 3%, Yield to maturity is...

Blossom Corp. issued a five-year bond one year ago with a coupon rate of 6.0 percent. The bond pays interest semiannually. If the yield to maturity on this bond is 12 percent, what is the price of...

Todd Silver is the purchasing agent for Moore Company. One of his suppliers, Gem Company, offers Todd a free vacation to France if he buys at least 75% of Moores supplies from Gem Company. Todd, who...

Compute MST for the following algorithms (a) Prim's algorithm (b) Dijkistra's algorithm (Source a) (c) Kruskal's algorithm C 4 g 5 2 6 3 a 4 d h k 5 7 3 1 6 8 b e i 3 4 5 T 2 3 6 9 f 5

likely to represent a phantastic object for investors? A . Venture capital fund with several biotech firms. B . Hedge fund with several opaque assets. C . Small - cap fund with the newest dot.com...

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

3. Western Europe seems to be uniquely involved with various forms of worker participation. What are some reasons that these worker participation systems have developed so fully there instead of...

1. Evaluate the exchange rates and wage rates shown in Exhibit 14.1 and decide where you should dock your ship for local production. You are the owner of a small North Carolina factory that makes...

6. Which features of Canadas labor relations system would you transfer to the United States?