Richard recently inherited $12,000 and is considering purchasing 12 bonds of the Lucky Corporation. The bond...

Richard recently inherited $12,000 and is considering purchasing 12 bonds of the Lucky Corporation. The bond has a par value of $2,000 with 12 percent coupon rate and will mature in 12 years. Does richard have enough money to buy 12 bonds if the required rate of return is 10 percent?

USE EXCEL FORMULAS SO I CAN SEE THE INPUTS PLEASE AND SHOW THE WORK I WANT TO LEARN IT!

Expert Solution

Par/Face value	2000
Annual Coupon rate	0.12
Annual coupon	240

Present Value = Future value/ ((1+r)^t)
where r is the interest rate that is 10% and t is the time period in years
price of the bond = sum of present values of future cash flows
r	0.1
mt	1	2	3	4	5	6	7	8	9	10	11	12
future cash flow	240	240	240	240	240	240	240	240	240	240	240	2240
present value	218.1818	198.3471	180.3156	163.9232	149.0211	135.4737	123.1579	111.9618	101.7834	92.53039	84.11854	713.733
sum of present values	2272.55

The price of each bond $2272.55.
The price of 12 bonds is	12*2275.55
The price of 12 bonds is	27306.6
Richard has inherited $12000, however the price of 12 bonds is $27306.6.
Richard does not have enough money to buy 12 bonds.

jeff jeffy answered 9 months ago

PROBLEM #2 You are considering purchasing bonds to add to your investment portfolio. Bond A is...

PROBLEM #2 You are considering purchasing bonds to add to your investment portfolio. Bond A is a 15 year bond that pays a 12% annual coupon. Bond B is a 20 year bond that pays a 8% annual coupon. Assume both bond terms started 2 years ago and that the discount rate is 10%. A. What are both bonds worth today? B. What is the total return on both bonds? C. Would you purchase both, neither, or one of the...

An investor is considering 3 purchasing different Bonds. Bond X pays a coupon rate of 2%...

An investor is considering 3 purchasing different Bonds. Bond X pays a coupon rate of 2% and matures in 12 years. Bond Y pays a coupon rate of 4% and matures in 12 years. Bond Z pays a coupon rate of 4% and matures in 7 years. For a 300 basis point increase in the required rate of return: Bond X will most likely exhibit a smaller percent decrease price than Bond Y. Bond X will most likely exhibit a...

A investor is considering purchasing a $1,000 bond with an 8% coupon rate. The bond was...

A investor is considering purchasing a $1,000 bond with an 8% coupon rate. The bond was issued 7 years ago with a 30 year original maturity. If the investor requires a return of 7% based on the riskiness oft he bond, how much should she pay for the bond? 2. As of now Treasury bills are returning 2% and the S&P 500 is returning 10%.You are considering purchasing a stock in CCC firm. The firm has an estimated beta of...

You are considering purchasing a bond. The bond will pay you $100 at the end of...

You are considering purchasing a bond. The bond will pay you $100 at the end of each year for three years. At the end of the third year, the bond will also pay you back its $1,000 face value. Assuming a 10% discount rate, how much is this bond worth today? Round to the nearest dollar

Having recently inherited some money from a distant relative,you are considering investing the funds in...

Having recently inherited some money from a distant relative, you are considering investing the funds in financial assets. You are aware that financial assets exhibit four main attributes. List and discuss these attributes. In your answer give examples to explain your points. (Marks 4) (b) Tim is going to retire in 10 years. He is planning to build a retirement fund that he would like to receive at the end of 10 years from now. Company Y offers a package...

) Having recently inherited some money from a distant relative, you are considering investing the funds...

) Having recently inherited some money from a distant relative, you are considering investing the funds in financial assets. You are aware that financial assets exhibit four main attributes. List and discuss these attributes. In your answer give examples to explain your points. (Marks 4) (b) John is going to retire in 10 years. He is planning to build a retirement fund that he would like to receive at the end of 10 years from now. Company X offers a package...

Bond J is a 4% coupon bond. Bond K is a 12% coupon bond. Both bonds...

Bond J is a 4% coupon bond. Bond K is a 12% coupon bond. Both bonds have 9 years to maturity, make semiannual payments, and have a YTM of 8%. A. If interest rates suddenly rise by 2%, what is the percentage price change of these bonds? B. What is rates suddenly fall by 22% instead? What does this problem tell you about the interest rate risk of lower-coupon bonds?22% instead? C. What does this problem tell you about the...

You are considering investing some of the money you inherited in bonds. You have identified one...

You are considering investing some of the money you inherited in bonds. You have identified one corporate bond (CB01) and two government bonds (GBo2 and GB03). All three bonds have a par value of R1000. The corporate bond CB01 offers a coupon rate of 13% per annum, while the two government bonds GB02 and GB03 offer coupon rates of 11% and 12% respectively. All three bonds pay coupons semi-annually and have a face value of R1000. Your intentions are to...

Question 6 A. Gigi recently inherited some bonds (face value $100,000) from her father, and soon...

Question 6 A. Gigi recently inherited some bonds (face value $100,000) from her father, and soon thereafter she became engaged to Adrian, a Bond Business School marketing graduate. Ralf wants Gigi to cash in the bonds so the two of them can use the money to “live like royalty” for two years in Monte Carlo. The 2 percent annual coupon bonds mature on December 31, 2037, and it is now January 1, 2018. Interest on these bonds is paid annually...

Lord of the Rings Corporation Lord of the Rings Corporation is considering purchasing a new state...

Lord of the Rings Corporation Lord of the Rings Corporation is considering purchasing a new state of the art microprocessor machine for its manufacturing division, the X-80, to replace their old machine “MISTY”, model G-40 (model G-40 will be sold for $15,000). Both machines have the same capacity to produce and package microprocessors for customer delivery, and both have the same remaining life of 10 years from today. The company's tax rate is 40%. G-40 X-80 Cost $100,000 ...

Question