Purchase Solution

Bond Values

Not what you're looking for?

Ask Custom Question

Your company has two bond issues outstanding. They both have an 8% coupon rate and a $1,000 par value. One bond matures in two years while the other bond matures in 20 years.

1. Using an Excel spread sheet, calculate the value of each of these bonds if:
a) Current market rates are 5%.
b) Current market rates are 8%.
c) Current market rates are 13%.
2. Why does the longer-term bond fluctuate more in value than the shorter-term bond?

Can you help me get started on this assignment?

Purchase this Solution
Solution Summary

The solution goes into a great amount of detail in order to answer the question. The solution is very well written and easy to understand. Detailed step by step instructions have been provided to answer all the questions being asked. Overall, an excellent response to the question being asked.

Purchase this Solution
Free BrainMass Quizzes
Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

View More Free Quizzes
Related BrainMass Solutions

  • Bond Price and Analyst Values

    269441 Bond Price and Analyst Values An analyst values a newly issued, 15-year, 9 percent annual coupon bond at par as of April 1, 2000. On April 1, 2008, the market prices the bond to yield 8.3 percent.

  • Bond prices and interest rates: the relationship

    In 196 words, this solution gives a brief discussion in regards to the relationship between interest rates and bond prices, the yield to maturity of a bond and the current yield, bond prices, and how to use tables to determine present and future values

  • Present Values/Future Values/Interest Rate Calculations

    138296 Present Values/Future Values/Interest Rate Calculations Present Values/Future Values/Interest Rate Calculations. See attached file for full problem description.

  • Valuation - Present and Future Value

    Why do bond values go down when interest rates go up? Is this true in the opposite direction? Present and future values make sure that appropriate treatment is given to future cash flows. A dollar now is worth more than a dollar a year from now.

  • Finance : Bond Values

    247386 Finance: Bond Values If the British government has a consol bond outstanding paying 100 pound per year forever. Assume the current intrest rate is 4% per year. What is the value of the bond immediately after a payment is made?

  • Calculations- bonds, loans, present values

    110014 Calculations- bonds, loans, present values Bond Prices and Yields, Bond Pricing, Loan Payments, Present Values Present Values Compute the present value of a $100 cash flow for the following combinations of discount rates and times:

  • Calculating Problems In Excel

    All my calculations are negative values. See attached file for full problem description. Quiz Questions 1, 2, 6 1. Present Values.

  • TVM, Bonds (pricing, yields)

    , Future Values, Interest rate), Loan payments, Bond Pricing, Bond yields

  • Answer

    = $1,171.18 When R = 0.12 (12% rate) --> PV = $863.78 [the formula is a bit tedious to calculate by hand; fortunately, it can be done in Excel with the same results] So those are the values of Bond L for different interest rates.

  • Average Bond Energies and Delta H.

    Just remember that a bond can be written two ways: H-S is the same S-H. Stepwise solution to find heat of reaction using bond energy values.

View More Related Solutions