Question

In: Finance

1- What is the price of the bond given the information below. The bond makes annual...

1- What is the price of the bond given the information below. The bond makes annual interest payments. (Do not round intermediate calculations, round answer to two decimals, i.e. 32.16)

Coupon Rate:7.9%

YTM:10.3%

Maturity (years):7

Par value: $1,000

Current Price: ?

2- What is the YTM of the bond given the information below. The bond makes annual interest payments. (Do not round intermediate calculations, round answer to two decimals, i.e. 32.16)

Coupon Rate:8.5%

Maturity (years):12

Current Price: $1,236.64

Par value: $1,000.00

YTM: ? .

3- What is the copon rate of the bond given the information below. The bond makes annual interest payments. (Do not round intermediate calculations, round answer to two decimals, i.e. 32.16)

YTM:9.5%

Maturity (years):24

Current Price: $967.96

Par value: $1,000.00

Cpoupon Rate: ?

4- What is the price of the bond given the information below. The bond makes semiannual interest payments. (Do not round intermediate calculations, round answer to two decimals, i.e. 32.16)

Coupon Rate:6.7%

YTM:10.2%

Maturity (years):30

Par value: $1,000

Current Price: ?

Solutions

Expert Solution

1. Use PV function in EXCEL to find the price of the bond

=PV(rate,nper,pmt,fv,type)

rate=YTM=10.3%

nper=7 years

pmt=coupon paymnet=(coupon arte*face value)=(7.9%*1000)=79

fv=face value=1000

=PV(10.3%,7,79,1000,0)=$884.30

Current price=$884.30

2. Use RATE function in EXCEL to find the YTM

=RATE(nper,pmt,pv,fv,type)

nper=12 years

pmt=(8.5%*1000)=85

pv=1236.64

fv=1000

=RATE(12,85,-1236.64,1000,0)=5.72%

YTM=5.72%

3. Use PMT function to find the coupon rate

=PMT(rate,nper,pv,fv,type)

rate=9.5%

nper=24 years

pv=967.96

fv=1000

=PMT(9.5%,24,-967.96,1000,0)=91.57

Coupon rate=coupon/par value=91.57/1000=9.157%

4. Remember that the paymnets are semi-annual

=PV(rate,nper,pmt,fv,type)

rate=10.2%/2=5.1%

nper=2*30=60

pmt=semi-annual coupon=(6.7%*1000)/2=67/2=33.5

fv=1000

=PV(5.1%,60,33.5,1000,0)=$674.21

Current Price=$674.21


Related Solutions

1- What is the copon rate of the bond given the information below. The bond makes...
1- What is the copon rate of the bond given the information below. The bond makes semiannual interest payments. (Do not round intermediate calculations, round answer to two decimals, i.e. 32.16) YTM:10.2% Maturity (years):9 Current Price: $1,130.33 Par value: $1,000.00 Cpoupon Rate: ? 3- Question 7 5 Points 2- What is the price of the bond given the information below. The bond makes semiannual interest payments. (Do not round intermediate calculations, round answer to two decimals, i.e. 32.16) Coupon Rate:6.1%...
What is the YTM of the bond given the information below. The bond makes semiannual interest...
What is the YTM of the bond given the information below. The bond makes semiannual interest payments. (Do not round intermediate calculations, round answer to two decimals, i.e. 32.16) Coupon Rate:7.4% Maturity (years):18 Current Price: $1,163.80 Par value: $1,000.00 YTM: ? %
1. What is the price of a $1,000 par value bond given the following information: (Show...
1. What is the price of a $1,000 par value bond given the following information: (Show work) Maturity:                     5 Years Coupon Rate:             0% (semiannual) YTM:                              3% $1,563 $861 $784 $863
Annual information about the uniform time produced in ABC business is given below. - Sales Price:...
Annual information about the uniform time produced in ABC business is given below. - Sales Price: 5.000 TL - Direct Substance Expense: 1.250 TL - Direct Labor Cost: 825 TL - Variable General Production Expenses: 370 TL - Fixed General Production Expenses: 42.500.000 TL - Fixed Sales and Management Expenses: 14.500.000 TL a) Calculate the break-even point in units and amounts. b) Calculate the security margin and rate since the budgeted sales amount is 35,000. c) How many hours must...
Given the information in the table, what is the price of the stock in YEAR 1?...
Given the information in the table, what is the price of the stock in YEAR 1? Today’s Dividend $3.10 Discount Rate 6.59% Growth rate in dividends 0 to 1 8.24% Growth rate in dividends 1 to 2 7.28% Growth rate in dividends 2 to 3 5.50% Growth rate in dividends 3 onward 4.26%
Given the information in the table, what is the price of thestock in YEAR 1?...
Given the information in the table, what is the price of the stock in YEAR 1? Today’s Dividend $3.78 Discount Rate 7.94% Growth rate in dividends 0 to 1 7.52% Growth rate in dividends 1 to 2 8.95% Growth rate in dividends 2 to 3 6.38% Growth rate in dividends 3 onward 3.08%
Given the information in the table, what is the price of the stock in YEAR 1?...
Given the information in the table, what is the price of the stock in YEAR 1? Today’s Dividend $4.62 Discount Rate 9.31% Growth rate in dividends 0 to 1 9.58% Growth rate in dividends 1 to 2 6.56% Growth rate in dividends 2 to 3 5.79% Growth rate in dividends 3 onward 3.34%
Given the information in the table, what is the price of the stock in YEAR 1?...
Given the information in the table, what is the price of the stock in YEAR 1? Today’s Dividend $3.19 Discount Rate 7.45% Growth rate in dividends 0 to 1 7.12% Growth rate in dividends 1 to 2 7.25% Growth rate in dividends 2 to 3 5.40% Growth rate in dividends 3 onward 4.65% Please do on piece of paper or show work and not on excel so i can follow.
Given the information in the table, what is the price of the stock in YEAR 1?...
Given the information in the table, what is the price of the stock in YEAR 1? Today’s Dividend $3.75 Discount Rate 7.86% Growth rate in dividends 0 to 1 7.53% Growth rate in dividends 1 to 2 8.34% Growth rate in dividends 2 to 3 5.82% Growth rate in dividends 3 onward 4.89%
You are given the following information Bond A has a price of $ 123.78, it matures...
You are given the following information Bond A has a price of $ 123.78, it matures on Jan-2030, its coupon rate is 3.78%, and it's AAA-rated Bond B has a price of $ 117.34, it matures on Jan-2030, its coupon rate is3.65%and it's AA-rated Bond C has a price of $ 119.22, it matures on Jan-2030, its coupon rate is 3.96%, and it's BBB-rated. Bond D has a price of $ 129.3, it matures on Jan-2030, its coupon rate is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT