Difference in the ytm calculation between xirr and yield

Assignment Help Finance Basics
Reference no: EM132681990

On August 15, 2000, the Canadian Government issued a bond maturing on February 15, 2030. The bond has a coupon rate of 6.75%, payable semi annually on 15 February and 15 August. If, on June 01, 2015 a $ 100 face value bond is selling for $115.00, what is the bond's yield to maturity using the following Excel functions. Show the detailed cash flow calculations

1. XIRR

2. Yield

3. Show the calculation that will reconcile the difference in the YTM calculation between XIRR and Yield.

Reference no: EM132681990

Questions Cloud

Articulate the approach to solving the problem : Articulate the approach to solving the problem, including which financial information is relevant and not relevant. Perform all calculations correctly
How it contributed to america''s vast racial wealth gap : Essay on How Redlining Continue to shape our communities today and how it contributed to America's vast racial wealth gap.
What is the optimum order size-massa machine tool : Massa Machine Tool expects total sales of $60,000. The price per unit is $10. The firm estimates an ordering cost of $25 per order, with an inventory cost of $0
Calculate the fcf for years : Durham Corporation currently has free cash flow (FCF) of $ 15 million. A well- respected stock analyst estimates that this FCF will increase by 8 % for the next
Difference in the ytm calculation between xirr and yield : On August 15, 2000, the Canadian Government issued a bond maturing on February 15, 2030. The bond has a coupon rate of 6.75%, payable semi annually
What is the npv of financing : DIY's debt beta is 0.3. The market risk premium is 12.8% and risk-free rate is 2.1%. Tax rate is 24%. What is the NPV of this financing?
Determine the consolidation worksheet entries : Determine the consolidation worksheet entries in the following year, assuming the inventory has been -sold, and explain the adjustments on a line-by-line basis
Capital gain-loss from selling the machine after 5 years : The Pickering Company (PC) manufactures food products. The company is considering the purchase of a new machine that will allow the company to produce meatless
Find lower cost and greater availability of capital : What are the dimensions of a strategy to capture this lower cost and greater availability of capital?

Reviews

Write a Review

Finance Basics Questions & Answers

  What is your effective annual interest rate on the lending

What is your effective annual interest rate on the lending arrangement if you borrow $37 million immediately and repay it in one year? (Do not round intermediate calculations.

  What are the inputs to and outputs of a supply chain

What strategic issues or challenges do you anticipate? What measures do you recommend to overcome these challenges?

  How much will he have saved in eight years when he buys

George Robinson plans to save $5,818 every year for the next eight years, starting today. At the end of eight years, George will turn 30 years old

  Determine the treasury zero yield curve

The following Treasury bonds were quoted on 29 August 2018, Determine the Treasury zero yield curve in six month intervals to two years

  Assignment on money management

List at least three of your financial goals. Explain whether they are short-term, intermediate, or long-term.

  1500 was invested in a bank at a nominal rate of 225 and

1500 was invested in a bank at a nominal rate of 2.25 and that interest on that balance is compounded monthly. at what

  Streamline operations

If Tapley could streamline operations, cut operating costs, and raise net income to $300

  Important multiple choice questions

Owen is a holder of a promissory note obtain from Purchase Money Corporation Regarding the defenses against payment of the note to which Purchase Money is subject,

  Using the payback and rate of return methods to make

using the payback and rate of return methods to make capital investment decisions. suppose smith valley is deciding

  Discuss liability coverage

What insurance coverage should Kevin include when purchasing an insurance policy for this truck? Please discuss liability coverage, medical payments coverage, uninsured motorist, and damage to insured's auto.

  Determine the exercise price

The loan implicit in the break forward contract will have a face value of 40.19. Determine if this is a fair amount by using your answer in a and computing the value of K.

  Sppose that base case forecast is 10000 visits find the

revenue 10000 visitsnbspnbspnbsp 400000wages and benefitsnbspnbspnbspnbspnbspnbspnbspnbsp

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!

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