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

  • Please explain how to solve these problems without using excel. A zero coupon bond has a...

    Please explain how to solve these problems without using excel. A zero coupon bond has a par value of $10,000 and a current price of $7,400. If the bond has 8 years to maturity, what is its yield to maturity? A. 2.6% B. 2. 9% C. 3.2% D. 3.6% E. 3.8% A 20-year bond with an 8% coupon rate (paid semi-annually) and $1000 par value for $1080. What is the effective annual yield? A. 7.0% B. 7. 2% C. 7.4%...

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

  • (1) (Bond Valuation) a bond that matures in 9 years has a $1000 par value. the...

    (1) (Bond Valuation) a bond that matures in 9 years has a $1000 par value. the annual coupon interest rate is 14% and the markets required yield to maturity on a comparable risk-bond is 16%. what would be the value of this bond if it paid interest annually? what would be the vale of this bond if it paid interest semi-annually? (2) (yield to maturity) the market price is $850 for a 12-year bond ($1000 par value) that pays 9%...

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