What is the yield to maturity on the following bonds; all have a maturity of 10 years, a face value of $1,000, and a coupon rate of 9 percent.

Spreadsheet for calculating yield to maturity

Microsoft Excel 2010 is a good tool for this job. To begin, create a new Excel spreadsheet and add the columns headers Par Value (in years), Coupon Rate, Face Valu, Maturity Date, Current Market Value, and Year to maturity. Then, you will need to enter data for the specific problem in the cells below their respective columns. For example, enter 1000 for “Par Value”; 9% for “Coupon Rate”; 10 years for “Maturity Date”; and so on.

The next step is to use Excel’s Price function.() You can calculate the yields on each bond listed above. To do this select an empty cell in your worksheet and use this formula: =Price(rate/2 , ‘par value’, 0 ,’maturity date’- ‘current market value’) where rate is referring to your coupon rate divided by 2 (since it is paid semiannually). It should look like this: =Price(4.5%,1000,-0,’10’-945.50). The annualized yield will be 9.87%. This is repeated for every bond value. Please note that dependencies can vary because of varying dates. These values should be modified in the current formulas as well as in any existing formulas on your worksheet.

Enter key and evaluate the answer. Click bottom to return your desired results.

How do you place an order?

It takes a few steps to place an order with Us:

  • The first step is to place your order. You will need to provide us with some basic information about your project.
  • Once you have placed your order, you will be taken to our secure payment page.
  • Once we receive your order, we will carefully review it and match you with a writer who has the skills and experience.
  • Stay in contact with the writer and discuss vital details of research.
  • Your completed proposal will be delivered via email within the specified deadline.

You are secure when using our service

It's critical for each client to feel secure. As a result, we at Research Proposal Writing take precautions to secure your data.

Financial security You may securely pay for your purchase using a variety of secure payment methods.
Personal security The personal information of our clients is secure. Nobody else will have access to it.
Academic security We use a specialized program to check every completed paper to ensure that we deliver no-plagiarism samples.
Web security This website is safe from unauthorized breaches. We maintain our privacy management in line with the latest laws and regulations.

You can get help placing your order. If you have any questions about our services, please contact us. Our support staff is accessible 24 hours a day, 7 days a week.

If you're still looking for a way to improve your grades and hire expert writers, we've got you covered. Place an order on our website, and we'll help you with any paperwork you want. We will exceed your expectations.

Order now Get a quote