Bonds based on the current price for the bonds

Assignment Help Financial Management

Reference no: EM131890223

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 102.50 firm.

* The bond was issues 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.

a) Analyze the bond and calculate its respective intrinsic values. Use the Excel "Formulas" then "Financial" drop down menu, use the PRICE function to solve for the intrinsic value.

b) With the expected settlement date of May 1st, 2017, calculate the amount of accrued interest that Gigantico would pay upon acquiring the 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.

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

Provide Excel syntax (formulas)

Reference no: EM131890223

Questions Cloud

Secrete thyroid-releasing hormone : Neurons in the hypothalamus secrete thyroid-releasing hormone (TRH). TRH stimulates cells in the anterior Picture wary to secrete

What will be optimal cash replenishment level : What will be its optimal cash replenishment level?

Explain the efforts by the us firm you identified : Summarize the basic situation in the case including a discussion of the business strategy of the U.S. firm you identified.

Describe the economic outcome of single-price monopoly : Describe the economic outcome of this single-price monopoly in terms of profit. Provide one (1) supporting fact to support your response

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

Analyze roles parents play in assessment and treatment : Analyze assessment instruments used for evaluating children and adolescents. Analyze roles parents play in assessment and treatment.

What will be optimal cash replenishment level : What will be its optimal upper cash limit? What will be its optimal cash replenishment level?

Summarize significant limitations found with either model : The flow of patient care must run efficiently and effectively from the point of admission to discharge. Clinical and Administrative health care teams greatly.

Explain the identified changes to the suppliers : Explain the identified changes to the suppliers in such a way that they will understand the standards that Apple requires.

User Account

All Pages