Purchase Solution

Valuing a Bond using excel

Not what you're looking for?

Ask Custom Question

Use the RATE, NPER, and PV functions to solve for "X". Please show the forumulas utilized in an excel format and explain.

Face Value of Bond $1,000 (Zero Coupon)

Price - $300
Maturity (Years) - 30
Yield to Maturity - X%

Price - $300
Maturity (Years) - X
Yield to Maturity - 8%

Price - $X
Maturity (Years) - 10
Yield to Maturity - 10%

Purchase this Solution
Solution Summary

The solution explains the various excel functions which cann be used in valuing a bond

Purchase this Solution
Free BrainMass Quizzes
Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Introduction to Finance

This quiz test introductory finance topics.

Motivation

This tests some key elements of major motivation theories.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Valuation of a Stock and Bond

    Thanks for using BrainMass. This solution provides a step by step response illustrating how to compute the valuation of both a stock and a bond. An Excel spreadsheet is attached which illustrates how to derive the appropriate values.

  • Bonds

    433911 Valuing Bonds, Interest Rate Risk and Bond Yields 1. Valuing Bonds What is the price of a 10-year, zero coupon bond paying $1,000 at maturity if the YTM is: a) 5 percent? b) 10 percent? c. 15 percent? 2.

  • Valuing Firms Stocks And Bonds In Excel

    The bonds you are valuing have 3 years to maturity, a 6% annual coupon, and a face value of US$1,000. The market interest rates are 5%. Use Microsoft Excel to calculate the value of the stocks and the bonds.

  • Valuing Bond prices, spreads, and yields

    648070 Valuing Bond prices, spreads, and yields 6.

  • Valuation

    The bonds you are valuing have 3 years to maturity, a 6% annual coupon, and a face value of US$1,000. The market interest rates are 5%. Use Microsoft Excel to calculate the value of the stocks and the bonds.

  • Valuing a Bond with Semi Annual Interest Payments

    501172 Valuing a Bond with Semi Annual Interest Payments Valuing Bonds: Microhard has issued a bond with the following characteristics: Par: $1,000 Time to maturity: 25 years Coupon Rate: 7 percent Semi Annual Interest Payments Calculate the

  • What is the IRR of a ten-year bond with 6% annual coupon and 5% YTM?

    228406 Time Value of Money and Valuing Bonds Suppose you purchase a ten-year bond with a 6% annual coupons. You hold the bond for four years and sell it immediately after receiving the fourth coupon.

  • Valuing Delayed Annuities; Amortizing Loan;Interest rate ris

    45740 Several Problems: Valuing Delayed Annuities; Amortizing Loan; Annuity Value; Interest Rate Risk 34. Valuing Delayed Annuities. Suppose that you will receive annual payments of $10,000 for a period of 10 years.

  • Valuation

    Yield to Maturity Calculate the yield to maturity of an 8% coupon bond with 5 years to maturity if the bond sells for $800. The face value of the bond is $1,000. We can determine YTM by using the following formula.

View More Related Solutions