Purchase Solution

Question on PRICE and YIELD function in spreadsheet

Not what you're looking for?

Ask Custom Question

Please see attached examples from my textbook. I don't have the PRICE and YIELD functions on my spreadsheet, so how would I solve similar problems to these? Thanks.

Suppose we have a bond with 22 years to maturity, a coupon rate of 8 percent, and a yield to maturity
of 9 percent. If the bond makes semiannual payments,what is its price today?

Settlement date: 1/1/2000
Maturity date: 1/1/2022
Annual coupon rate: 0.08
Yield to maturity: 0.09
Face value (% of par): 100
Coupons per year: 2
Bond price (% of par): 90.49

My textbook says the formula entered for the bond price is =PRICE(b7,b8,b9,b10,b11,b12)

I don't understand the PRICE function--it is not on my excel spreadsheet.
Is there another way to solve this on a spreadsheet?

Purchase this Solution

Solution Summary

The price and yield functions on spreadsheets are examined. The formula entered for the bond price are given.

Purchase this Solution

Free BrainMass Quizzes
Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Learning Lean

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

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.


This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.