Question

Note: If not otherwise stated, assume that: • Yield-to-maturity (YTM) is an APR, semi-annually compounded •...

Note: If not otherwise stated, assume that:

• Yield-to-maturity (YTM) is an APR, semi-annually compounded

• Bonds have a face value of $1,000

• Coupon bonds make semi-annual coupon payments; however, coupon rates (rc) are annual rates, i.e., bonds make a semi-annual coupon payment of rc/2

Four years ago, Candy Land Corp. issued a bond with a 14% coupon rate, semi-annual coupon payments, $1,000 face value, and 14-years until maturity.

a) You bought this bond three years ago (right after the bond made its coupon payment) when the yield-to-maturity was 10%. How much did you pay for the bond?

Select one:  

$1,006.3

$725.2

$1,000.0

$1,263.3

$1,249.2

$1,187.9

$1,287.5

$2,293.8

b) The current yield-to-maturity is 15%. If you sell the bond today (next coupon payment is in 6 months from today), after having owned it for three years, what would be your capital gain/loss yield? Remember, the capital gain/loss yield is the return resulting from price changes of your investment.

Select one:

-8.8%

-3.0%

-31.2%

-26.3%

-27.5%

10.0%

35.7%

15.0%

c) Suppose two years from now (right after the bond made its coupon payment) the bond has a value of $1,154. What would be the yield-to-maturity of the bond (APR, semi-annually compounded)? Use Excel or a financial calculator to solve this question

Select one:

5.5%

-0.7%

11.1%

14.0%

10.8%

5.4%

11.8%

11.4%

NOTE: Please show all the work, without using excel, unless necessary. (step by step with equations) Thanks!

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

I HAVE SOLVED FIRST 2 USING FORMULA AND LAST ONE USING EXCEL.

PVIFA AND PVIF CALCULATED USING EXCEL. YOU WANT ANY HELP, FILL FREE TO ASK.

THANK YOU.

Home nert Page Layout Formulas Data Review View dd-Ins s Cut ta copy. Σ AutoSum ー E ゴWrap Text B I 프 . 灬 ▲· 逻锂函Merge & Center. $, % , 弼, conditional Format eCell Insert Delete Format Sort &Find & Format Painter Formatting as Table Styles2 Clear Clipboard Alignment Number Cells Edting H115 YEARS LIFE COUPON 13 14% SEMI ANNUAL 1096 97 a 98 100 101 102 103 104 105 106 107 b 108 109 110 PURCHASE PRICE = (RATE WILL BE HALF, YEARS WILL BE DOUBLE AS SEMI-ANNUAL COMPOUNDING IS THERE) COUPON X PVI FA @5%, 26 PERIODS + PAR VALUEX PVIF@5%, 26 PERIODS 70 X 14.3752 1000 X 0.2812 1287.46 ANSWER: 1287.5 15% 10 LIFE YEARS PURCHASE PRICE COUPON X PVIFA @7.5%, 20 PERIODS + PAR VALUE X PVIF@7.5%. 20 PERIODS 70 X 10.19451000 X 0.2354 112 113 114 115 (4 く トト1 | ( AFN . BANKING 949.02 CAPITAL GAIN LOSS = CAPITAL GAIN LOSS (949.02-1287.46)/1287,46 26.3% NOTE , BIDDING, UNDERWRITING EUAC AW PM LIFE . LP, lP, MRP, INFLATION YIELD WARRANTrefund bond CLEAN INVOICE PRICE . Sheet1 | Sheet3 , 08:52 27-01-2019Home nert Page Layout Formulas Data Review View dd-Ins s Cut aCopy E AutoSum Wrap Text B I 프 . 灬 ▲· 逻锂函Merge & Center. $, % , 弼,8 Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard A125 A. Alignment Number Cells LIFE PRICE YEARS 118 C 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 (4 く トト1 | . AFN . BANKING 1154 5.525% EXCEL-RATE(8*2,140/2,1154,-1000) SEMI ANNUAL ANNUAL NOTE , BIDDING, UNDERWRITING / EUAC AW PM LIFE . LP, lP, MRP, INFLATION YIELD 7 -WARRANTrefund bond CLEAN INVOICE PRICE . Sheet1 | Sheet3 08:53 27-01-2019

Home nert Page Layout Formulas Data Review View dd-Ins s Cut aCopy E AutoSum Wrap Text B 1 프 . 灬 ▲· 逻锂函Merge & Center. $ % , to:: Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard Alignment Number Cells Edting E139 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 (4 く トト1 | . AFN . BANKING NOTES PVI FA @ 5%, 26 PERIODS PVI FA @ 5%, 26 PERIODS 14.3752 0.2812 PV(5%,26,-1) PV(5%,26,,-1) PVI FA @ 7.5%, 20 PERIODS PVI FA @ 7.5%, 20 PERIODS 10.1945 0.2354 PV(7.5%,20,1) PV(7.5%,20,-1) WE CAN ALSO SOLVE USING FORMULA NOTE , BIDDING, UNDERWRITING / EUAC AW PM LIFE . LP, lP, MRP, INFLATION YIELD 7 -WARRANTrefund bond CLEAN INVOICE PRICE . Sheet1 | Sheet3 08:56 27-01-2019

Add a comment
Know the answer?
Add Answer to:
Note: If not otherwise stated, assume that: • Yield-to-maturity (YTM) is an APR, semi-annually compounded •...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

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
  • Note: If not otherwise stated, assume that: • Yield-to-maturity (YTM) is an APR, semi-annually compounded •...

    Note: If not otherwise stated, assume that: • Yield-to-maturity (YTM) is an APR, semi-annually compounded • Bonds have a face value of $1,000 • Coupon bonds make semi-annual coupon payments; however, coupon rates (rc) are annual rates, i.e., bonds make a semi-annual coupon payment of rc/2 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...

  • Five years ago, Winter Tire Corp. issued a bond with a 12% coupon rate, semi-annual coupon...

    Five years ago, Winter Tire Corp. issued a bond with a 12% coupon rate, semi-annual coupon payments, $1,000 face value, and 15-years until maturity. a) You bought this bond two years ago (right after the coupon payment) when the yield-to-maturity was 12%. How much did you pay for the bond? b) If the yield-to-maturity is 15% now, what is the value of the bond today (next coupon payment is in 6 months from today)? c) If you sold the bond...

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

  • Unless stated otherwise, interest is compounded annually, and payments occur at the end of the period....

    Unless stated otherwise, interest is compounded annually, and payments occur at the end of the period. Face value for bonds is $1000. 1. Hawk Inc. originally issued 10-year bonds with a face value of $1000 at par. The bonds have a coupon rate of 8%, and coupons are paid semiannually. The bonds will mature in 6 years, and the yield to maturity is 6.4% with semiannual compounding. Find the bond’s price today. If the yield rises, what do you expect...

  • A bond was issued three years ago at a price of $946 with a maturity of...

    A bond was issued three years ago at a price of $946 with a maturity of six years, a yield-to-maturity (YTM) of 6.25% compounded semi-annually, and a face value of $1,000 with semi-annualy coupons. What is the price of this bond today immediately after the receipt of today's coupon if the YTM has fallen to 5.00% compounded semi-annually?

  • Five years ago, Cookie Corp. issued a bond with 15% coupon rate, semi-annual coupon payments, $1000...

    Five years ago, Cookie Corp. issued a bond with 15% coupon rate, semi-annual coupon payments, $1000 face value and 15 years until maturity. The current YTM is 16%. If you sell the bond today (next coupon payment is in 6 months from today), after having owned it for 4 years, what would your capital gain/loss yield? Please show formulas and do not use excel or financial calculator.

  • A bond was issued three years ago at a price of $1,064 with a maturity of...

    A bond was issued three years ago at a price of $1,064 with a maturity of six years, a yield-to-maturity (YTM) of 8.25% compounded semi-annually, and a face value of $1,000 with semi-annualy coupons. What is the price of this bond today immediately after the receipt of today's coupon if the YTM has risen to 9.50% compounded semi-annually? Question 13 options: $903 $928 $953 $978 $1,003

  • -What is the yield to call of a 30-year to maturity bond that pays a coupon...

    -What is the yield to call of a 30-year to maturity bond that pays a coupon rate of 11.98 percent per year, has a $1,000 par value, and is currently priced at $918? The bond can be called back in 7 years at a call price $1,089. Assume annual coupon payments. -Marco Chip, Inc. just issued zero-coupon bonds with a par value of $1,000. The bond has a maturity of 17 years and a yield to maturity of 10.23 percent,...

  • Problem 1: Using a Spreadsheet to Calculate Yield to Maturity What is the yield to maturity...

    Problem 1: Using a Spreadsheet to Calculate Yield to Maturity What is the yield to maturity on the following bonds; all have a maturity of 10 years and a face value of $1,000, and a coupon rate of 9 percent (paid semiannually). The bonds' current market values are $945.50, $987.50, $1,090.00, and $1,225.875, respectively. Market Total Coupon Periodic Coupon Face SEMI-ANNUAL => Yield to Value (PV) Payments (NPER) Rate (ANNUAL) Payment (PMT) Value (FV) YTM (RATE) Maturity $945.50 20 9%...

  • Consider two bonds: bond XY and bond ZW . Bond XY has a face value of $1,000 and 10 years to maturity and has just been...

    Consider two bonds: bond XY and bond ZW . Bond XY has a face value of $1,000 and 10 years to maturity and has just been issued at par. It bears the current market interest rate of 7% (i.e. this is the yield to maturity for this bond). Bond ZW was issued 5 years ago when interest rates were much higher. Bond ZW has face value of $1,000 and pays a 13% coupon rate. When issued, this bond had a...

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