Self-Assessment HW4D (YTM Annually, Semi-annually)

docx

School

University of Maryland, University College *

*We aren’t endorsed by this school

Course

330 7980

Subject

Finance

Date

Nov 24, 2024

Type

docx

Pages

6

Uploaded by Dogmom87

Report
Question 1 What is the yield to maturity of a 22-year bond that pays a coupon rate of 11.65 percent per year, has a $1,000 par value, and is currently priced at $1,214? Assume annual coupon payments. Round the answers to two decimal places in percentage form. (Write the percentage sign in the "units" box). You should use Excel or financial calculator. Your Answer: 9.33 Answer units W Hide Check my answer Step 1: Calculate annual coupon payments: $1,000*11.65% = 116.50 Step 2: Open Excel. Click Formulas ~ Financial - find function RATE Enter: Nper 22 Pmt 116,50 PV -1214 (must be entered as a negative number) FV 1000 Type 0 Get the answer 9.33% =RATE(22,116.5,-1214,1000,0) = 9.33% (Excel shows the answer as a whole number. You should increase the number of decimals) File Home Insert Page Layout Formulas Data Review =g & Cut Calibri Jno fij [@®copy ~ 2 Paste . . O . v 6 Format Painter Iy Clipboard N Font N~ Al M fe =RATE(22,116.5,-1214,1000,0) A B © D E F G w = w w w R el
Question 2 Blue Crab, Inc. plans to issue new bonds, but is uncertain how the market would set the yield to maturity. The bonds would be 27-year to maturity, carry a 13.94 percent annual coupon, and have a $1,000 par value. Blue Crab, Inc. has determined that these bonds would sell for $1,190 each. What is the yield to maturity for these bonds? Round the answers to two decimal places in percentage form. (Write the percentage sign in the "units" box). You should use Excel or financial calculator. Your Answer: 11.61 Answer units. w Hide Check my answer Step 1: Calculate annual coupon payments: $1,000*13.94% = 139.40 Step 2: Open Excel. Click Formulas ~ Financial - find function RATE Enter: Nper 27 Pmt 139.40 PV -1190 (must be entered as a negative number) FV 1000 Type 0 Get the answer 11.61% =RATE(27,139.4,-1190,1000,0) = 11.61% (Excel shows the answer as a whole number. You should increase the number of decimals) File Home Insert Page Layout Formulas Data Review 2D g [ Insert AutoSum Recently Financial Logical Text Date& Lookup& Math& Function v Used ~ v v v Time~ Reference~ Trigv Fu Function Library Al hd f =RATE(27,139.4,-1190,1000,0) A A B C D E F G = - oy o [ * =
Question 3 Fresh Fruit, Inc. has a $1,000 par value bond that is currently selling for $1,031. It has an annual coupon rate of 6.44 percent, paid semiannually, and has 22-years remaining until maturity. What would the annual yield to maturity be on the bond if you purchased the bond today and held it until maturity? Round the answer to two decimal places in percentage form. (Write the percentage sign in the "units" box) You should use Excel or financial calculator: Your Answer: 6.18 Answer units W Hide Check my answer Step 1: Think in terms of periods instead of years « 22 years means 22*2 = 44 semi-annual periods « Annual coupon payment ($1000°6.44% =$64.40) will be paid as $64.40/2 = $32.20 every half-of-a year « Annual interest rate (Yield to maturity) received as a result of Excel function is the interest rate per each half-of-a year. To get an annual YTM, this answer should be multiplied by 2. Step 2: Open Excel. Click Formulas - Financial - find function RATE Enter: Nper 22*2 Pmt 64.40/2 PV -1031 (must be entered as a negative number) FV 1000 Type 0 Get the result 3.09% (Excel shows the result as a whole number. You should increase the number of decimals) Step 3: Annual interest rate (Yield to maturity) received as a result of Excel function is the interest rate per each half-of-a year. To get an annual YTM, this answer should be multiplied by 2. =RATE(22*2,64.4/2,-1031,1000,0)*2 = 6.18% (Excel shows the result as a whole number. You should increase the number of decimals)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
file Home Insert Pagelayout Formulas Data Review Ao X g @ Insert | AutoSum Recently Financial Logical Text Dated Lookup& Math& Function | v Usedv v © v Timev Referencev Tigv Fu Fundtion Library A1 - £ | =RATE(22%2,64.4/2,-1031,1000,0) 4__A 8 c [ 3 F < 1[_a00%] fle Home Inset Pagelajout Formuls Data Review View foX g O Insert AutoSum Recently Financial Logical Text Date& Lookup& Math& Morc Function v Used~ v v v Time~ Reference~ Tig~ Functior Fundtion Library AL - £ | -RATE(2272,64.4/2,-1031,1000,0)°2 4 A 8 | ¢ | b | E | F | G | H
Question 4 A few years ago, Spider Web, Inc. issued bonds with a 7.79 percent annual coupon rate, paid semiannually. The bonds have a par value of $1,000, a current price of $864, and will mature in 16 years. What would the annual yield to maturity be on the bond if you purchased the bond today? Round the answer to two decimal places in percentage form. (Write the percentage sign in the "units" box) You should use Excel or financial calculator. Your Answer: Answer W Hide Check my answer Step 1: Think in terms of periods instead of years « 16 years means 16*2 = 32 semi-annual periods « Annual coupon payment ($1000*7.79% =$77.90) will be paid as $77.90/2 = $38.95 every half-of-a year « Annual interest rate (Yield to maturity) received as a result of Excel function is the interest rate per each half-of-a year. To get an annual YTM, this answer should be multiplied by 2. Step 2: Open Excel. Click Formulas - Financial - find function RATE Enter: Nper 16*2 Pmt 77.90/2 PV -864 (must be entered as a negative number) FV 1000 Type 0 Get the result 4.73% (Excel shows the result as a whole number. You should increase the number of decimals) Step 3: Annual interest rate (Yield to maturity) received as a result of Excel function is the interest rate per each half-of-a year. To get an annual YTM, this answer should be multiplied by 2. =RATE(16*2,77.9/2,-864,1000,0)*2 = 9.46% (Excel shows the result as a whole number. You should increase the number of decimals)
File Home Insert Pagelayout Formulas Data Revi DY E Insert AutoSum Recently Financial Logical Text Date& Lookup& Matl Function v Usedv ~ v v Time~ Reference~ Tig Funtion Library AL M fe || =RATE(16%2,77.9/2,-864,1000,0) 4 A B © D E F G Fle Home Insert Pagelayout Formulas Data Review foX Insert | AutoSum Recently Financial Logical Text Date& Lookup& Math & Function v Usedv © v Time~ Reference~ Trig~ Function Library A - £ || =RATE(16%2,77.9/2,-864,1000,0)*2 4 A | 8 | c | o | E | F | & | © & =]
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help