Homework Answers
a.
yield to maturity using excel function
=RATE(nper,pmt,pv,fv)
=RATE(30,1000*8%,-900,1000)
=8.97%
b.
yield to maturity using excel function
=RATE(nper,pmt,pv,fv)
=RATE(30,1000*8%,-1000,1000)
=8.00%
c.
yield to maturity using excel function
=RATE(nper,pmt,pv,fv)
=RATE(30,1000*8%,-1100,1000)
=7.18%
Add Answer to:
can you help step-by-step so I can enter into Excel
have been die A1 f A...
can you help step-by-step so I can enter into Excel ms B С F H 1...
can you help step-by-step so I can enter into Excel
ms B С F H 1 M 1 2. 3 4 5 DE 11. Bond Pricing. A 30-year maturity bond with face value of $1,000 makes semiannual coupon payments and has a coupon rate of 8%. What is the bond's yield to maturity if the bond is selling for: (L06-2) a. $900? b. $1,000? c. $1,1002 6 7 8 9 10 11 12 13 14 15 16 17 18 19...
can you help step-by-step so I can enter into Excel are not supported in Tears and...
can you help step-by-step so I can enter into Excel
are not supported in Tears and have been disabled A1 B с E G H K L M N 1 2 3 D 21. Rate of Return. A bond is issued with a coupon of 4% paid annually, a maturity of 30 years, and a yield to maturity of 7%. What rate of return will be carned by an investor who purchases the bond for $627.73 and holds it for...
can you help step-by-step so I can enter into Excel. А B с D m F...
can you help step-by-step so I can enter into Excel.
А B с D m F H K 1 7. Bond Prices and Returns. One bond has a coupon rate of 8%, another a coupon rate of 12%. Both bonds pay interest annually, have 10-year maturities, and sell at a yield to maturity of 10%. (L06-2) a. If their yields to maturity next year are still 10%, what is the rate of return on each bond? b. Does the higher-coupon...
I need all parts answered using step by step. Not excel. E 1&2 and also F....
I need all parts answered using step by step. Not excel. E 1&2
and also F.
percent: What is the yield to maturity on a 10-year, 9 percent annual coupon, $1,000 par value bond that sells for $887.002 That sells for $1,134.202 What does the fact that a bond sells at a discount or at a premium te e. (1) ll about the relationship between ra and the bond's coupon rate? you (2) What is the current yield, the capital...
hi i need help worh this problem. can you show your work in excel please File...
hi i need help worh this problem. can you show your work in
excel please
File Home Insert Formulas Data Review View Help Open in Desh brovs Calibri V 11 V B A1 fx I 1 A B С D E F G H 14. Present Values. What is the present value of the following cash-flow stream if the interest rate is 6%? (LO5-2) 2 3 Year 4 5 Cash Flow $200 400 300 2 3 dar 6 7 8...
I need help with answering questions e though I please. Step by step. in each case...
I
need help with answering questions e though I please. Step by
step.
in each case in the preceding quesHoh? f. Suppose that the bond described in part (e) is callable i five years at a cal price equal to $1,090. What is the YTC on the bond if its n $8872 What is the YTC on the same bond if its current mark $1,134.20? e bond if its current market D g. What is interest rate price risk? Which...
I hope that you can explain step by step, I am not very clear about some...
I hope that you can explain step by step, I am not very clear
about some calculation formula, thank you!
Maggie's Magazines (MM) has straight nonconvertible bond that currently yield 7%. MM's stock sells for $22 per share, has an expected constant growth rate of 7%, and has a dividend yield of 4%. MM plans on issuing convertible bonds that will have a $1,000 par value, a coupon rate of 6%, a 20-year maturity, and a conversion ratio of 32...
I need help answering E - I. Step by step. None of it makes sense to...
I need help answering E - I. Step by step. None of it makes
sense to me.
Campbell and Carol Morris are senior vice presidents of Chicago Insurance Company. They are fund management division, with Campbell having resp income securities (primarily bonds) ments. A major new client, Mutual of Chicago present an investment seminar to the mayors of t sented cities. Campbell and Morris, who will make the actual presentation, have asked you to help them by answering the following...
help! not sure how to enter the formulas Crain's Consulting Firm Requires a Date Formula "Today"...
help! not sure how to enter the formulas
Crain's Consulting Firm Requires a Date Formula "Today" Inputs and Constants Today: 7/17/2014 Years Threshold: 5 High Year Rate: 3.25% Low Year Rate: 2.00% Requires Year Frac Function (2-points) Requires a VLOOKUP (3-points) Rating Rating Bonus Raise New Salary Current Years Date Hired Salary Employed Score 4/1/2004 $ 50,000 10.19 5 7/15/2012 $ 75,250 2.01 3.5 10/31/2008 $ 67,250 5.71 4.2 9/8/2003 $ 45,980 10.86 2 3/14/2011 $ 58,750 1.5 6/18/2010 $...
CIUL wrap Text General Paste Clear B I U Merge % ) ,00 .00 2.0 Cong...
CIUL wrap Text General Paste Clear B I U Merge % ) ,00 .00 2.0 Cong Form J20 A В D F H K L 1 2 С Bond A has a coupon rate of 4 percent. Bond B has a coupon rate of 9 percent. Both bonds have 14 years to maturity, make semiannual payments and have a YTM of 6 percent. If interest rates suddenly fall by 1 percent, what is the percentage price change of these bonds?...
can you help step-by-step so I can enter into Excel
ms B С F H 1 M 1 2. 3 4 5 DE 11. Bond Pricing. A 30-year maturity bond with face value of $1,000 makes semiannual coupon payments and has a coupon rate of 8%. What is the bond's yield to maturity if the bond is selling for: (L06-2) a. $900? b. $1,000? c. $1,1002 6 7 8 9 10 11 12 13 14 15 16 17 18 19...
can you help step-by-step so I can enter into Excel
are not supported in Tears and have been disabled A1 B с E G H K L M N 1 2 3 D 21. Rate of Return. A bond is issued with a coupon of 4% paid annually, a maturity of 30 years, and a yield to maturity of 7%. What rate of return will be carned by an investor who purchases the bond for $627.73 and holds it for...
can you help step-by-step so I can enter into Excel.
А B с D m F H K 1 7. Bond Prices and Returns. One bond has a coupon rate of 8%, another a coupon rate of 12%. Both bonds pay interest annually, have 10-year maturities, and sell at a yield to maturity of 10%. (L06-2) a. If their yields to maturity next year are still 10%, what is the rate of return on each bond? b. Does the higher-coupon...
I need all parts answered using step by step. Not excel. E 1&2
and also F.
percent: What is the yield to maturity on a 10-year, 9 percent annual coupon, $1,000 par value bond that sells for $887.002 That sells for $1,134.202 What does the fact that a bond sells at a discount or at a premium te e. (1) ll about the relationship between ra and the bond's coupon rate? you (2) What is the current yield, the capital...
hi i need help worh this problem. can you show your work in
excel please
File Home Insert Formulas Data Review View Help Open in Desh brovs Calibri V 11 V B A1 fx I 1 A B С D E F G H 14. Present Values. What is the present value of the following cash-flow stream if the interest rate is 6%? (LO5-2) 2 3 Year 4 5 Cash Flow $200 400 300 2 3 dar 6 7 8...
I
need help with answering questions e though I please. Step by
step.
in each case in the preceding quesHoh? f. Suppose that the bond described in part (e) is callable i five years at a cal price equal to $1,090. What is the YTC on the bond if its n $8872 What is the YTC on the same bond if its current mark $1,134.20? e bond if its current market D g. What is interest rate price risk? Which...
I hope that you can explain step by step, I am not very clear
about some calculation formula, thank you!
Maggie's Magazines (MM) has straight nonconvertible bond that currently yield 7%. MM's stock sells for $22 per share, has an expected constant growth rate of 7%, and has a dividend yield of 4%. MM plans on issuing convertible bonds that will have a $1,000 par value, a coupon rate of 6%, a 20-year maturity, and a conversion ratio of 32...
I need help answering E - I. Step by step. None of it makes
sense to me.
Campbell and Carol Morris are senior vice presidents of Chicago Insurance Company. They are fund management division, with Campbell having resp income securities (primarily bonds) ments. A major new client, Mutual of Chicago present an investment seminar to the mayors of t sented cities. Campbell and Morris, who will make the actual presentation, have asked you to help them by answering the following...
help! not sure how to enter the formulas
Crain's Consulting Firm Requires a Date Formula "Today" Inputs and Constants Today: 7/17/2014 Years Threshold: 5 High Year Rate: 3.25% Low Year Rate: 2.00% Requires Year Frac Function (2-points) Requires a VLOOKUP (3-points) Rating Rating Bonus Raise New Salary Current Years Date Hired Salary Employed Score 4/1/2004 $ 50,000 10.19 5 7/15/2012 $ 75,250 2.01 3.5 10/31/2008 $ 67,250 5.71 4.2 9/8/2003 $ 45,980 10.86 2 3/14/2011 $ 58,750 1.5 6/18/2010 $...
CIUL wrap Text General Paste Clear B I U Merge % ) ,00 .00 2.0 Cong Form J20 A В D F H K L 1 2 С Bond A has a coupon rate of 4 percent. Bond B has a coupon rate of 9 percent. Both bonds have 14 years to maturity, make semiannual payments and have a YTM of 6 percent. If interest rates suddenly fall by 1 percent, what is the percentage price change of these bonds?...
Most questions answered within 3 hours.
-
M. Laing has suggested a new arrangement of the periodic table
(J.Chem.Ed.1989, 66,
746). Answer the following...
asked 18 minutes ago -
Café Michigan's manager, Gary Stark, suspects that demand for
mocha latte coffees depends on the price...
asked 17 minutes ago -
A US merchant purchases wine from a vineyard outside of Paris.
The wine is transported to...
asked 23 minutes ago -
we have (TTN)*
We have to use just one 2-bit counter with 1-bit global
history?
and...
asked 24 minutes ago -
Firms that fail to compete with lower prices and/or better
products will go bankrupt. Does this...
asked 25 minutes ago -
Question 1 Current and Resistance
Part A: A current of -14.5 nanoamperes is how many electrons...
asked 26 minutes ago -
The population standard deviation for the height of college
basketball players is 3.4 inches. If we...
asked 38 minutes ago -
6.) Use valence bond theory to describe the number and types of
hybrid bonding orbitals on...
asked 40 minutes ago -
2. Define/explain the following traits that are important
adaptations for different types of vertebrate animals:
Jaws...
asked 40 minutes ago -
Firm K produced 45,000 radios using 9,000 hours of labor in
2003; total labor costs were...
asked 41 minutes ago -
Use the information in the table to answer the
question.
Year
2015
2016
2017
2018
Nominal...
asked 46 minutes ago -
Kelso Corporation just paid a dividend of D_0 = $1.50 per
share, and that dividend is...
asked 47 minutes ago