User Account

All Pages

Calculate the new price of the bond

Assignment Help Finance Basics
Reference no: EM133113666

  1. For a bond with information defined in the table below. Please perform the following calculations:
    1. Map out the cash flows as a function of years into the future in Excel, calculate the discount factor (using YTM) for each of the cash flow 
    2. Calculate the present value of each of the cash flows and the price of the bond based on PV of the all of the cash flows
    3. Calculate the price of the bond using a different way: the PRICE function in Excel and confirm you obtained the same price as in step b
    4. For the same bond in prob, assuming the new yield of the bond one year from today is 4%. Perform the following calculations:
      1. Calculate the new price of the bond, using the Price function in Excel. (Ignore the fact one year later this bond is only a four year bond)
      2. Calculate the price return of the bond and the income of the bond (using original YTM)
      3. Calculate the 1 year total return of the bond

settlement

11/19/2021

Maturity

11/19/2026

Yield to Maturity

Coupon

Principal

 

3.00%

3.50%

 $100 

 

 Compounding Freq

2.0

 

 

Reference no: EM133113666

Questions Cloud

Find current market yields : What price would you pay for a corporate bond with a face value of $500 000, maturing in 7 years and paying 7.00 per cent per annum coupons semi-annually, if cu
What is her cash-on-cash return : a. Jones, the investor, proposes taking participating preferred stock' with 1x liquidation preference in return for her $5 million investment. Draw the payoff d
What is the probability that a theft with occur : RST Company has production facilities in Salt Lake City and Cleveland. The probability that in any given year a fire theft will occur in the facility in Salt La
What is the current yield on the bonds : BrainSoft has 12% coupon bonds on the market with 9 years to maturity. The bonds make semi-annual payments and currently sell for 110% of par. What is the curre
Calculate the new price of the bond : For a bond with information defined in the table below. Please perform the following calculations:
Why a 401k is popular and its advantages : Explain in 150 words or more why a 401K is popular and its advantages.
Find the value of option using cox-ross-rubenstein : Using Excel, find the value of this option using Cox-Ross-Rubenstein 10-step binomial option pricing model.
Determining the total market value of the firm : The following information has been presented to you about the Gibson Corporation.
Equally weighted average annualized return : Suppose a venture fund wishes to base its required return (used in discounting future terminal values) on its historical experience and suggests merely averagin

Reviews

Write a Review

Finance Basics Questions & Answers

  Common-size percentage for the dividends paid

The profit margin is 3.4 percent and the retention ratio is 60 percent. What is the common-size percentage for the dividends paid?

  Why are financial institutions necessary in the us

Why are financial institutions necessary in the US? How would not having financial institutions affect people.

  Calculate the cost of equity using the sml method

Berta Industries stock has a beta of 1.25. The company just paid a dividend of $0.40, and the dividends are expected to grow at 5 percent. The expected return on the market is 12 percent, and Treasury bills are yielding 4.7 percent. The most recen..

  What is the npv

what is the NPV? If the discount rate is infinite, what is the NPV? At what discount rate is the NPV just equal to zero?

  Estimate the value of pse stock

If its equity cost of capital is 4% and dividends are expected to grow by 2% per year in the future, estimate the value of PSE's stock.

  What would be the opportunity cost of lowering taxes

Critical Thinking An economist likes to think in terms of trade-offs and opportunity costs. If you wanted to make changes to a balanced state budget.

  Describe the purpose of each of the four financial statement

Identify the four basic financial statements. Describe the purpose of each of the four financial statements.

  Find the probability of being dealt a bridge hand of 13

find the probability of being dealt a bridge hand of 13 cards containing 5 spades 2 hearts 3 diamonds and 3

  Calculation of npv & irr of uneven cash flows

Calculation of NPV & IRR of uneven Cash Flows and Comparing NPV & IRR between two Investment options.

  What profit margin must the firm achieve

McCormac Co. wishes to maintain a growth rate of 12 percent a year, a debt-equity ratio of 1.20, and a dividend payout ratio of 30 percent. The ratio of total assets to sales is constant at .75.

  What stock price is expected one year from now

What stock price is expected one year from now (P1)? Round your answer to two decimal places.

  What does double taxation of corporate income mean

If you were starting a business, what tax considerations might cause you to prefer to set it up as a proprietorship or a partnership rather than as a corporation? Would you consider the average or the marginal tax rate more relevant?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd