Analyze both bonds and calculate respective intrinsic values

Reference no: EM132043763

Question: Please show all work and provide a brief explanation of how you analyzed the situation.

Diana Voorman, portfolio manager at Gigantico Inc. is looking at two different bonds and intends to purchase only one of them for her firm's intermediate bond portfolio.

The first bond is from The Zelio Film Company. The ask price is 93.25 firm. The bond was issued on February 15th, 2017 and matures on February 15th, 2027. The bond has a coupon rate of 7.50% payable on a semiannual basis. The face value of the bonds is $10,000 and the required rate of return for similar bonds is 8.28% as determined by Diana's investment committee. If purchased, the bond would settle on May 1st, 2017.

The second bond is from Xenix Motion, Ltd. The ask price is 102.50 firm. The bond was issued on November 15th, 2010 and matures on November 15th, 2025. The bond has a coupon rate of 9.25% payable on a semiannual basis. The face value of the bonds is $10,000 and the required rate of return for similar bonds is 9.10% as determined by Diana's investment committee. If purchased, the bond would settle on May 1st, 2017.

Analyze both bonds and calculate their respective intrinsic values. Use the Excel "Formulas" then "Financial" drop down menu, use the PRICE function to solve for the intrinsic value.

With the expected settlement date of May 1st, 2017, calculate the amount of accrued interest that Gigantico would pay upon acquiring either bond. Alas, the Excel function here requires manipulating the date format and a workaround, so the recommendation is to manually calculate being aware of the "Basis" information and when the bond was issued, or last paid interest.

Evaluate the bonds and determine the yield to maturity of both bonds based on the current price for the bonds.

Analyze the two bonds to determine if one offers greater value to Gigantico than the other and explain. You may disregard the accrued interest as bond purchasers generally consider the accrual as rather inconsequential.

Reference no: EM132043763

Questions Cloud

Prepare journal entries to record first two interest payment : The bonds are issued at a price of $4,895,980. Prepare the journal entries to record the first two interest payments

What is the realized rate of return for the investors : Six years ago, Bradford Community Hospital issued 20-year municipal bonds with a 7 percent annual coupon rate. The bonds were called today for a $70 call.

What are the proceeds from the sale : If Emerson sold the bonds on August 1 for 109.50, what are the proceeds from the sale? Please help me with this problem.

What is the exact cost of trade credit as an annual rate : If Jolly Joe's buys $100 worth of supplies on credit with terms 3/10 n30, What is the exact cost of trade credit as an annual rate

Analyze both bonds and calculate respective intrinsic values : Analyze both bonds and calculate their respective intrinsic values. Use the Excel "Formulas" then "Financial" drop down menu, use the PRICE function to solve.

What is the gain on the transaction : What is the total cost of the purchase? What are the proceeds on the sale? What is the gain (or loss) on the transaction. Please help me with this problem.

What is the dividend per share of common stock : What are the dividends due the preferred shareholders? What is the dividend per share of common stock?

Determine the velocity : Determine the velocity, to the nearest hundredth foot per second of the object after 1.6 seconds.

What is the aftertax salvage value of plant and equipment : The manufacturing plant has an eight-year tax life, and DEI uses straight-line depreciation. At the end of the project (that is, the end of Year 5).

User Account

All Pages