In: Finance
Dominique LeBlanc is the owner of a new ten-year $50,000 8% par-value bond with a Bermuda option and annual coupons. Allowable call dates are at the ends of years 6through 10, and the call premium at the end of year n is $300(10-n). Dominique purchased the bond for $51,975.00.
A) Find the lowest yield that Dominique may receive during the period she holds the bond.
B) Find the highest yield that Dominique may receive during the period she holds the bond.
C) Upon receipt, Dominique deposits each coupon and the redemption amount in an ac-count earning 6%. Find the lowest yield that Dominique may receive during the ten-year period.
D) Upon receipt, Dominique deposits each coupon and the redemption amount in an ac-count earning 6%. Find the highest yield that Dominique may receive during the ten-year period.
n | A=300*(10-n) | Fv=50000+A | ||||||
Year | Call Premium | Amount of Receipt after n Years | ||||||
6 | 1200 | $51,200 | ||||||
7 | 900 | $50,900 | ||||||
8 | 600 | $50,600 | ||||||
9 | 300 | $50,300 | ||||||
10 | 0 | $50,000 | ||||||
n | Year | 6 | 7 | 8 | 9 | 10 | ||
Nper | Number of Years | 6 | 7 | 8 | 9 | 10 | ||
Pmt | Annual Coupon Payment =50000*8% | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | ||
Pv | Purchase Price | $51,975 | $51,975 | $51,975 | $51,975 | $51,975 | ||
Fv | Terminal receipt at end of n years | $51,200 | $50,900 | $50,600 | $50,300 | $50,000 | ||
RATE | Yield | 7.49% | 7.46% | 7.44% | 7.43% | 7.43% | ||
(Using RATE function of excel) | ||||||||
A | LOWEST YIELD | 7.43% | ||||||
Holding Period=10 Years | ||||||||
B | HIGHEST YIELD | 7.49% | ||||||
Holding Period=6 Years | ||||||||
C | Future Value(FV) at end of 10 years | |||||||
(Cash Flow)*((1+i)^(10-n)) | ||||||||
i=interest rate, n=year of cash flow | ||||||||
Interest rate =i=6%=0.06 | n | A | FV=A*(1.06^(10-n) | B | FV=B*(1.06^(6-n) | |||
Year | Cash Flow | Future Value | Cash Flow | Future Value | ||||
1 | $4,000 | $6,758 | $4,000 | $5,353 | ||||
2 | $4,000 | $6,375 | $4,000 | $5,050 | ||||
3 | $4,000 | $6,015 | $4,000 | $4,764 | ||||
4 | $4,000 | $5,674 | $4,000 | $4,494 | ||||
5 | $4,000 | $5,353 | $4,000 | $4,240 | ||||
6 | $4,000 | $5,050 | $55,200 | $55,200 | ||||
7 | $4,000 | $4,764 | SUM | $79,101 | ||||
8 | $4,000 | $4,494 | ||||||
9 | $4,000 | $4,240 | ||||||
10 | $54,000 | $54,000 | ||||||
SUM | $102,723 | |||||||
Yield =R for 10 years | ||||||||
51975*(1+R)^10=102723 | ||||||||
(1+R)^10=102723/51975 | 1.98 | |||||||
1+R=1.98^(1/10)= | 1.07 | |||||||
Yield =R= | 7.05% | |||||||
Yield =R1 for 6 years | ||||||||
51975*(1+R)^10=79101*(1.06^4) | $99,864 | |||||||
(1+R1)^10=99864/51975 | 1.92 | |||||||
1+R1=1.92^(1/10)= | 1.07 | |||||||
Yield =R= | 6.75% |
Related SolutionsCompany B issues a ten-year bond that has a face value (or par value) of $100,000...Company B issues a ten-year
bond that has a face value (or par value) of $100,000 and a stated
rate of 4%. The interest is paid annually, the date is January 1,
2018 and the current market rate is 6%.
What is the issue price of the bond (round to the nearest
dollar)? Show your work (Using the preset tables)
Mayfawny owns an 8 year bond with a par value of 1,000. The bond matures for...Mayfawny owns an 8 year bond with a par value of 1,000. The bond
matures for par and pays semi-annual coupons at a rate of 6%
convertible semi-annually.
Calculate the Modified duration of this bond at an annual
effective interest rate of 9.2025%.
9. Bond T is a 3 year, 8% annual coupon bond with a par value of...9. Bond T is a 3 year, 8% annual coupon bond with a par value of
$1000 and current value of $1000. The discount rate is equal to the
coupon rate. What is the duration of Bond T?
10. Using the information in #9 and considering an expected rise
of interest rates by 1%, calculate the modified duration for Bond
T.
13. Daniels Company’s preferred stock is expected to pay a $1.25
dividend at the end of each year. The...
An 8 year bond with a par value of $1000 has a semiannual coupon of 7.1%...An 8 year bond with a par value of $1000 has a semiannual coupon
of 7.1% and yield of 5%. What is the approximate price of this
bond? Please provide excel formula.
a) $864
b) $1,000
c)$1085
d) $1106
e)$1137
A ten-year bond, with par value equals $1000, pays 10% annually. If similar bonds are currently...A ten-year bond, with par value equals $1000, pays 10% annually.
If similar bonds are currently yielding 6% annually, what is the
market value of this bond? Use semi-annual analysis. Please show
all work and no financial calculators are allowed for the
problem..
Bond XYZ is a 4-year, 8% annual coupon bond, with $1,000 par value. The required return...Bond XYZ is a 4-year, 8% annual coupon bond, with $1,000 par
value. The required return on the bond is 5.4%. 1)What is the
duration, 2) What is the modified duration of this bond?
What is the value of $1000 par value 8 3/8% Marriott Corporation bond for the for...What is the value of $1000 par value 8 3/8% Marriott Corporation
bond for the for each of the following required rates of return and
assuming that the investor will hold the bond to maturity assume
the coupon is paid semiannually (every six months) and the mature
the bond matures in three years?
a. 6.50%
b. 11.30%
A. You are considering a 25-year, $1,000 par value bond. Itscoupon rate is 8%, and...A. You are considering a 25-year, $1,000 par value bond. Its
coupon rate is 8%, and interest is paid semiannually. If you
require an "effective" annual interest rate (not a nominal rate) of
9.2025%, how much should you be willing to pay for the bond? Do not
round intermediate calculations. Round your answer to the nearest
cent. $___B. Nesmith Corporation's outstanding bonds have a $1,000 par
value, a 10% semiannual coupon, 7 years to maturity, and a 13% YTM.
What...
a. Suppose an investor can purchase a 5-year 8% coupon bond with a par value of...a. Suppose an investor can purchase a 5-year 8% coupon bond with
a par value of $100 that pays interest semi-annually. The yield to
maturity for this bond is 9% on a bond-equivalent basis. What is
the total future dollars and the total dollar return that should be
generated from this bond if it is to yield 9%? b. What is the
coupon interest, capital gain/loss and reinvestment income
associated with this bond? Assume that the reinvestment rate is
equal...
A 20-year, 8% semiannual coupon bond with a par value of $1,000 may be called in...
A
20-year, 8% semiannual coupon bond with a par value of $1,000 may
be called in 5 years at a call price of $1,040. The bond sells for
$1,100. (Assume that the bond has just been issued.)
Basic Input Data:
Years to maturity:
20
Periods per year:
2
Periods to maturity:
40
Coupon rate:
8%
Par value:
$1,000
Periodic payment:
$40
Current price
$1,100
Call price:
$1,040
Years till callable:
5
Periods till callable:
10
a. What is the
bond's...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|