ZuoTi.Pro
Question

2) You are looking at a bond with 13 years to maturity, has a coupon rate of 4% paid semi- annually, and a price of 105. What

MUST BE DONE ON EXCEL USING EXCEL FORMULAS

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

B C D E F G $ $ $ $ Face Value Price Maturity coupon 100 105 13 4% FV PV NPER PMT 100 -105 26 2 $ YTM = 1.76%

G27 100 105 Face Value Price Maturity coupon FV PV NPER PMT 100 -105 =C4*2 =C2*C5/2 0.04 YTM= =(-RATE(F4,F5,F2, F3)

0 0
Add a comment
Know the answer?
Add Answer to:
MUST BE DONE ON EXCEL USING EXCEL FORMULAS 2) You are looking at a bond 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

  • MUST BE DONE ON EXCEL USING FORMULAS 4) For this question you will be using the...

    MUST BE DONE ON EXCEL USING FORMULAS 4) For this question you will be using the FINRA website we reviewed in class. The link to the website is on slide 35. Your task will be to select two different bonds. The bonds must be issued by different companies and should not be the same bonds as your friends have selected. I recommend just randomly selecting bonds as the best approach. For each bond answer the following: What is the organization's...

  • Not done using excel. A semi-annual coupon bond has a 6 percent coupon rate, a $1,000...

    Not done using excel. A semi-annual coupon bond has a 6 percent coupon rate, a $1,000 face value, a current value of $1,036.09, and 3 years until the first call date. What is the call price if the yield to call is 6.5 percent?

  • A​ ​$10000 bond with a coupon rate​ of​ 3​% paid​ semi-annually has 6 years to maturity...

    A​ ​$10000 bond with a coupon rate​ of​ 3​% paid​ semi-annually has 6 years to maturity and a​ semi-annual yield to maturity​ of​ 2​%. What is the price of​ this​ bond? Please give me two solutions of formula calculation and excel calculation

  • Using Excel, compute the yield-to-maturity for the following bonds (report your Excel formulas and their inputs):...

    Using Excel, compute the yield-to-maturity for the following bonds (report your Excel formulas and their inputs): Price = 90, Fixed Coupon Rate = 5%, Maturity = 5 years, Coupon Frequency = 1 Price = 90, Fixed Coupon Rate = 5%, Maturity = 5 years, Coupon Frequency = 2 Price = 90, Fixed Coupon Rate = 5%, Maturity = 5 years, Coupon Frequency = 4 Do you see any differences in yield-to-maturities computed for bonds with different coupon frequencies? If so,...

  • You must invest $200000. Market interest rates are 6% APR semi-annually compounded. What is the duration...

    You must invest $200000. Market interest rates are 6% APR semi-annually compounded. What is the duration of this bond? Please show formulas and do not use financial calculator or excel. B. 3 years to maturity and 7% coupon rate (coupons paid semi-annually)

  • Questions 1-4 show excel formulas The coupon rate and market price for the 10-year US Treasury...

    Questions 1-4 show excel formulas The coupon rate and market price for the 10-year US Treasury bond are 2.50% and 96.3828 respectively. Note, the price is expressed as a percentage of par (like other bonds). If par is $1000, then this bond is selling for $963.828. 1. Assume that this bond will mature in precisely 10 years, pay coupons semi-annually, and has a par value of $1000. Determine the yield to maturity for this bond. 2. Compute the duration of...

  • 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...

  • You must invest $100,000, and the bonds listed below from A to E are the only...

    You must invest $100,000, and the bonds listed below from A to E are the only investments available today (assume that it is possible to buy a fraction of a bond in order to invest the full $100,000). The same 6% market interest rate (APR, compounded semi-annually) applies to all of these bonds and they have the following additional characteristics: A. 6 years to maturity and 4% coupon rate (coupons paid annually) B. 3 years to maturity and 7% coupon...

  • please answer question in excel and show the formula to get the answer ( I must...

    please answer question in excel and show the formula to get the answer ( I must have the formula) Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.9 percent paid semiannually and 13 years to maturity. The yield to maturity of the bond is 3.8 percent. What is the dollar price of the bond? 1/1/2000 1/1/2013 4.90% Settlement date Maturity date Coupon rate Coupons per year Redemption value (% of par) Yield to...

  • NOTE PLEASE ALL ANSWERS MUST BE IN EXCEL FORMULA. X 5 ? X . HOME Calculating...

    NOTE PLEASE ALL ANSWERS MUST BE IN EXCEL FORMULA. X 5 ? X . HOME Calculating yield to maturity - Excel FORMULAS DATA REVIEW - Sign In FILE INSERT PAGE LAYOUT VIEW Paste B I U- - - A Alignment Number 8.12 oints Conditional Format as Cell Formatting Table Styles Styles Cells - Clipboard Font Skipped D17 А в E F G H I к eBook Print A Japanese company has a bond outstanding that sells for 91.53 percent of...

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