the yield to maturity of a 20-year 8% coupon bond with a $1,000 face value that sells for $1,200. (Excel function: rate)

Use Excel to calculate (Please type the complete function command with all parameter inputs; round up your answers to 2 decimal places):

1. the yield to maturity of a 20-year 8% coupon bond with a $1,000 face value that sells for $1,200. (Excel function: rate)
2. the yield to maturity of a 5-year discount bond with $1,000 face value that sells for $950. (Excel function: rate)
3. the installment payment of a 4-year fixed payment loan of $25,000 with 4% interest rate. (Excel function: pmt)
4. the present value of a lottery winning that pays $20,000 annually for 30 years with discounting rate of 5% (Note: the first payment is received today.) (Excel function: pv)

e. the unpaid balance of a 3% (per month) fixed-payment car loan of $15,000 with monthly payment of $800 paid for one year. (Excel function: fv)

Expert Solution

Refer the attached screenshot of excelsheet

B. Refer the screenshot of excel

C. Refer the formula in the formula bar

D. Refer the attached picture

E. Refer the attached picture

Refer the formula in the formula bar.

Rahul Sunny answered 2 years ago

A bond has a face value of $1,000, a coupon rate of 8%, and a yield...

A bond has a face value of $1,000, a coupon rate of 8%, and a yield to maturity of 9.5%. If the bond matures in 8 years, what is the price of the bond? (Assume coupons are paid annually.)

A bond has $1,000 face value, coupon rate of 3.5%, and yield to maturity (YTM) of...

A bond has $1,000 face value, coupon rate of 3.5%, and yield to maturity (YTM) of 3.7%. It will mature in 17 years and coupons are paid annually. What is this bond’s current yield?

Find the yield to maturity for a 15-year, 8% annual coupon rate, $1,000 par value bond...

Find the yield to maturity for a 15-year, 8% annual coupon rate, $1,000 par value bond if the bond sells for $1,218 currently? We assume that interest is paid on this bond annually. 2.90% 5.79% 6.64% 6.86% calculate the bond’s current yield. 6.20% 6.57% 6.80% 7.18% calculate the bond’s capital gain yield. -0.78% 0.78% 6.22% 6.57%

An 11-year, $1,000 face value bond has an annual coupon rate of 8% and its yield...

An 11-year, $1,000 face value bond has an annual coupon rate of 8% and its yield to maturity is 7.5%. The bond can be called 3 years from now at a price of $1,060. What is the bond’s nominal yield to call?

Current yield and yield to maturity An annual coupon bond has a $1,000 face value, coupon...

Current yield and yield to maturity An annual coupon bond has a $1,000 face value, coupon rate of 5%, will mature in 10 years, and currently sells for $810.34. a. What is the yield to maturity of the bond? b. What is the current yield of the bond? c. Why does the current yield differ from the yield to maturity? d. One year later, the market rates have increased to 8%. Assume that you have just received a coupon payment...

3. A 20-year maturity coupon bond with face value of $1,000 makes annual coupon payments and...

3. A 20-year maturity coupon bond with face value of $1,000 makes annual coupon payments and has a coupon rate of 20%. When the bond sells at 1500, the YTM is____; When the bond sells at 1000, the YTM is _____; When the bond sells at 800, the YTM is _____.

b) Bond with 10 year maturity, a face value or $1,000, a coupon rate of 7%...

b) Bond with 10 year maturity, a face value or $1,000, a coupon rate of 7% (coupon is paid annually) and assume that the yield to maturity on the bond is 7%. Compute the duration of this bond. c) Next, we are going to analyze the effect of time to maturity on the duration of the bond. Compute the duration of a bond with a face value of $1,000, a coupon rate of 7% (coupon is paid annually) and a...

(i) A 5-year bond with face value $1,000 (paid at maturity) and coupon rate 5% (coupon...

(i) A 5-year bond with face value $1,000 (paid at maturity) and coupon rate 5% (coupon paid in arrears annually) has yield-to-maturity 4.5%. What is the convexity of the bond? (ii)Assume that stock returns follow a 2-factor structure. The risk-free return is 3%. Portfolio A has average return 8% and factor-betas 0.7 and 0.9 (for factor 1 and 2, respectively). Portfolio B has average return 10% and factorbetas 1.2 and 1.1 (for factor 1 and 2, respectively). What is the...

A 5-year bond with face value $1,000 (paid at maturity) and coupon rate 5% (coupon paid...

A 5-year bond with face value $1,000 (paid at maturity) and coupon rate 5% (coupon paid in arrears annually) has yield-to-maturity 4.5%. What is the convexity of the bond?

Analyze the 20-year, 8% coupon rate (annual payment), $1,000 par value bond. The bond currently sells...

Analyze the 20-year, 8% coupon rate (annual payment), $1,000 par value bond. The bond currently sells for $1,318. What’s the bond’s current yield, and capital gain yield? 6.07%, 0.71% 6.07%, -0.71% 8%, 1.43% 8%, -1.43%

Question