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?

Attachments
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
SWOT

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

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Operations Management

This quiz tests a student's knowledge about Operations Management

Introduction to Finance

This quiz test introductory finance topics.

View More Free Quizzes
Related BrainMass Solutions

  • Bond Valuation- Yield to maturity and yield to call

    I need help with problem set 7-8 questions a through d in excel and problem set 7-22 e and f. No need to re-write the questions. Just show Question "a", Question "b"...Question "f" with excel. Thanks.

  • YTM/Duration

    367053 Graduate Level Finance Question regarding bonds and maturities Please explain how to solve Tab 3-4 in spreadsheet attached. Principles of Corporate Finance. Thanks for helping me out here!!

  • Determining a Bond's Price and Interest Rate Risk

    This solution, completed on an Excel spreadsheet, shows you how to use Excel to compute a bond's price at different discount rates and maturities. It also discusses interest rate risk as a function of both yield to maturity and years to maturity.

  • Retirement Savings, Bond Yields and Coupon Rate

    Question 2 Bond Yields. An AT&T bond has 10 years until maturity, a coupon rate of 8% and sells for $1,100. a. What is the current yield on the bond? b. What is the yield to maturity?

  • Portfolio Valuation: Risk Free Rate, Market Premium and Yield

    You can prove your ability to price the portfolio by developing a spreadsheet that will price the stocks and bonds based on the risk-free rate, the market risk premium and the yield spread (for bonds).

  • Yield To Maturity and To Call

    Using an Excel spreadsheet, this solution illustrates how to compute the yield to maturity and the yield to call on a callable bond.

  • Bond Value Given 10 Year Maturity Selling

    Under the "Financial Functions sub menu" you will see a function called "PRICE" where you enter the maturity date, coupon rate, yield to maturity of each bond, and it calculates the bond price.

  • Using the WACC equation

    future and its stock price is expected to grow at a constant rate.

  • Bond price, current yield, YTM, ROI

    For question#4, my answer is different from yours and works are shown in the spreadsheet. The expert examines bond prices, current yields, YTM and ROI.

View More Related Solutions