ZuoTi.Pro
Question

Solution is needed in EXCEL format please (EXCEL formula needed) Example 1: Bond Pricing As with...

Solution is needed in EXCEL format please (EXCEL formula needed)

Example 1: Bond Pricing
As with any financial instrument, the price of a bond is just the present value of the future cash flows. What is the price of a bond with semiannual coupon payments and the following characteristics?
Coupon rate: 8.00%
Years to maturity:                        10
Yield to maturity: 7.50%
Par value: $               1,000
Since the bond has semiannual payments, the coupon payments will be:
Coupon payments:
Of course, we could have simply entered the coupon payments and par value in the same PV function, making sure that both were negative. This would give us:
Bond price:
business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1


1 Example 1: Bond Pricing As with any tinancial instrument, the price ot a bond is just the present value ot the tuture cash tlows. 2 What is the price of a bond with semiannual coupon payments and the following characteristics? 8.00% 10 Coupon rate Years to maturity Yield to maturity: Par value: 1000 9 Since the bond has semiannual payments, the co Coupon payments: 40 12 Ot course, we could have simply entered the coupon payments and par value in the same PV tunction, 13 making sure that both were negative. This would give us: 15 Bond price: 1,034.74 17 20 23 24 25 1-0 4 ト 뉘 Sheet1 1 14 Sheet1 1 1 5 Sheet1 1 16 Sheet1 117 Sheet1 1 18 Sheet1 1 19 Sheet1 120 Sheet1 121 . 23:05 US 10VD1/2019 1 Example 1: Bond Excel formula As with any tinancial instrument, the price ot a bond is just the present value ot the tuture

0 0
Add a comment
Know the answer?
Add Answer to:
Solution is needed in EXCEL format please (EXCEL formula needed) Example 1: Bond Pricing As with...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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

  • Question: As with any financial instrument, the price of a bond is just the present value...

    Question: As with any financial instrument, the price of a bond is just the present value of the future cash flows. What is the price of a bond with semiannual coupon payments and the following characteristics? Coupon rate: 8.00% Years to maturity:                        10 Yield to maturity: 7.50% Par value: $               1,000 Since the bond has semiannual payments, the coupon payments will be: Coupon payments: Of course, we could have simply entered the coupon payments and par value in the...

  • Solution (s) is needed in EXCEL Format (EXCEL Formula only please) Example 2: Bond YTM Input...

    Solution (s) is needed in EXCEL Format (EXCEL Formula only please) Example 2: Bond YTM Input area: Annual coupon rate 7% Settlement date 1/1/00 Maturity date 1/1/09 Coupons per year                       1 Bond price (% of par)             96.150 Face value (% of par)                   100 Output area: Yield to maturity

  • ANSWER MUST BE IN EXCEL FORMAT - EXAMPLE - =D7+D9/E8 Compute the current bond price. ANSWER...

    ANSWER MUST BE IN EXCEL FORMAT - EXAMPLE - =D7+D9/E8 Compute the current bond price. ANSWER MUST BE IN EXCEL FORMAT - EXAMPLE - =D7+D9/E8 Compute the current bond price. AB Ninja Co. issued 14-year bonds a year ago at a coupon rate of 6.9 percent. The bonds make semiannual payments. If the YTM on these bonds is 5.2 percent, what is the current bond price in dollars? Assume a par value of $1,000 1/1/2000 1/1/2013 6.90% Settlement date Maturity...

  • Calculate the YTM. ANSWER MUST BE IN EXCEL FORMULA FORMAT A Stone Sour Corp. issued 20-year...

    Calculate the YTM. ANSWER MUST BE IN EXCEL FORMULA FORMAT A Stone Sour Corp. issued 20-year bonds two years ago at a coupon rate of 7.1 percent. The bonds make semiannual payments. If these bonds currently sell for 105 percent of par value, what is the YTM? 1/1/2000 1/1/2018 7.10% Settlement date Maturity date Annual coupon rate Coupons per year Face value (% of par) Bond price (% of par) 100 105 Complete the following analysis. Do not hard code...

  • Bond pricing and yield to maturity:  Be able to make future value and present value calculatio...

    Bond pricing and yield to maturity:  Be able to make future value and present value calculations with given values of i and n. For example, what is the future value of $500 saved for two years at a 5% annual interest rate?  How does present value change for larger values of i? How does it change for larger values for n?  What is a debt instrument? What are the three main characteristics of a debt instrument? ...

  • please use excel coding Bond X is a premium bond making semiannual payments. The bond pays...

    please use excel coding Bond X is a premium bond making semiannual payments. The bond pays a 9 percent coupon, has a YTM of 7 percent, and has 13 years to maturity. Bond Y is a discount bond making semiannual payments. This bond pays a 7 percent coupon, has a YTM of 9 percent, and also has 13 years to maturity. What is the dollar price of each bond today? If interest rates remain unchanged, what do you expect the...

  • PLEASE WRITE THE ANSWER AS A EXCEL FORMULA X 5 Calculating a bond price - Excel...

    PLEASE WRITE THE ANSWER AS A EXCEL FORMULA X 5 Calculating a bond price - Excel ? X = INSERT - Sign In FILE HOME PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri 11 AA - A Paste B IU Alignment Number Cells Editing 5.12 oints Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Skipped A1 AB E F G H eBook Print Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.9...

  • Bond Pricing Using Tables Bond Pricing Using Tables 1. Calculate the price of a bond using...

    Bond Pricing Using Tables Bond Pricing Using Tables 1. Calculate the price of a bond using tables. D Bond Pricing - Excel 7 - X . . HOME FILE INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in B T U . A Alignment Number - Cells Editing Paste Clipboard A1 3- Font Conditional Format as Cell Formatting Table Styles Styles X 1 On January 1, Ruiz Company issued bonds as follows: 1 On January 1, Ruiz Company issued bonds...

  • Example 4: Constant Dividend Growth SOLUTION IS NEEDED IN EXCEL FORMAT ONLY. (EXCEL FORMULA) Unlike bond...

    Example 4: Constant Dividend Growth SOLUTION IS NEEDED IN EXCEL FORMAT ONLY. (EXCEL FORMULA) Unlike bond pricing, Excel does not have built-in functions for stock pricing, so we need to create our own equations. We will begin with constant growth in dividends. Suppose we have a stock with the following: Current dividend: $     2.40 Dividend growth rate: 5.00% Required return: 13.00% With this growth rate, the dividend next year will be: Dividend next year: So, the stock price today with...

  • Please answer in excel and show formulas! Thanks! Zero-coupon bond. What is the annual implied interest...

    Please answer in excel and show formulas! Thanks! Zero-coupon bond. What is the annual implied interest of a five-year zero-coupon bond (using the semiannual pricing convention) with a yield to maturity of 12% and a par value of $1,000? What is the first year's implied interest of the zero-coupon bond? $ (Round to the nearest cent.)

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
ADVERTISEMENT