Question on PRICE and YIELD function in spreadsheet
Not what you're looking for?
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.
SWOT
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.