Purchase Solution

Bond Valuation and Worksheet

Not what you're looking for?

Ask Custom Question

Please see the attached files. Could you please use formula or add comments so that I understand it for the future? I also attached copies from my book regarding this problem.
Thank you!

Attachments
Purchase this Solution
Solution Summary

The expert examines bond valuation and worksheets for a company. Excel is used.

Solution Preview

Below is you tutorial.

Please note that rather than accomplishing the Excel sheet you provided, I presented the step by step solution here.

Topic 5 Individual Issue Value
From the disclosure under Market Information, we know that the current rate of the note issue is 6.875% (7 year term), hence we will use this information in computing the present values of both the principal and the interest payments of the note.

Please note that since no additional information was provided, I assumed that the note pays interest once a year.

PV of principal (face) amount = Principal x [1/(1+Market rate)^year] = $30 million x [1/(1+6.875%)^7] = $18,835,986.07

Interest payment = $30,000,000 x 4. 25% = $1,275,000.00

PV of interest payments ...

Purchase this Solution
Free BrainMass Quizzes
Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Situational Leadership

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

View More Free Quizzes
Related BrainMass Solutions

  • Finance problems: Bond valuation, NPV.

    The worksheet is simple and can be used for other problems. Thank you for using Brainmass. The problem set deals with calculating the net present value of an investment and the price of a semi-annual bond.

  • Determine the minimum price that you should ask for the sale of 51 percent of the shares of Omni Services...

    Critically review and comment on the valuation report. What would you do differently? Please revise the valuation model and provide a detail review of the valuation attached. Hi Please see the attached Excel file.

  • Semiannual coupon bond valuation

    540977 Semiannual coupon bond valuation Semiannual coupon bond valuation 1. Hartnett Computing has 8 year, non-callable, 8.8% semiannual coupon bonds outstanding. The bonds have a par value of $1,000 and a nominal YTM of 9.5%.

  • Duration of bond

    218690 Bond Valuation: Calculate bond's modified duration Calculate the duration of an 8 percent, $1,000 par bond that matures in the three years if the bond's YTM is 10 percent and interest is paid semi-annually.

  • Bond Valuation- Yield to maturity and yield to call

    Valuation Rework Problem 7-8 using a spreadsheet model.

  • Finance problems: IRR and NPV.

    Click on each worksheet below. Each worksheet contains a number of questions.

  • Stock Valuation versus Bond Valuation

    Bond valuation is directly related to the rate of interest the bond pays, the current rate of interest, and the value of the bond on redemption. Each of these can be easily ascertained. So, stock valuation is considerably less precise.

  • Bond Valuation, Yield to Maturity and the After Tax Cost of Debt

    24671 Bond Valuation, Yield to Maturity and the After Tax Cost of Debt Russell Container Corporation has a $1,000 par value bond outstanding with 20 years to maturity.

  • Different Valuation Models

    3) Valuation - corporate bond A $1,000 corporate bond with 10 years to maturity pays a coupon of 8% (semi-annual) and the market required rate of return is a) 7.2% or b) 10%. What is the current selling price for a) and b)?

View More Related Solutions