Question: Suppose Microsoft were to issue a $1,000 face value bond with 10 years to maturity. This bond as an annual coupon of $40. Bonds with

Suppose Microsoft were to issue a $1,000 face value bond with 10 years to maturity. This bond as an annual coupon of $40. Bonds with similar risk have a yield to maturity of 4%. What is the value of this bond today? Solve in excel and please include the formulas used.

Now suppose instead that the market interest rate 5% and newly issued bonds are now paying coupon rates of 5%. How much is the Microsoft bond issued worth now if it still pays a $40 coupon and has 10 years to maturity?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

The following personnel have been assigned full-time to the Red Zuma project team: 4 marketing specialists 4 design engineers 4 development engineers 4 industrial engineers 4 test riders 2 purchasing...

11. There a project for SBU, Inc. with expected cash flows describe below. 0 2 3 WACC=? H + + -100 80 50 30 Answer the following questions with the additional information give below. (25 points...

1. A semi-annual coupon bond with 10 years to maturity and 10% annual coupon rate. The annual market required interest rate is 8%. Assume the bond's face value is $1000. The bond price should be...

Please show work and let me know if a, b, c or d is correct. Thanks. if interest rate is expected to fall (rise) the best bond strategy is to own low (high) coupon and long (short) maturity bonds? a....

if interest rate is expected to fall (rise) the best bond strategy is to own low (high) coupon and long (short) maturity bonds? a. true b. false c. uncertain jordan plans to issue bonds with a par...

please help w homework Suppose that the MU corporation has a $1000 par value bond with three years remaining and a 4% annual coupon rate. If bonds with similar risk are priced to yield a 6% rate of...

11:01 l Voda NZ FINA 201 Assignment .pdf Q-1. (Annuity) Your friend is celebrating her 35th birthday today and wants to start saving for her anticipated retirement at age 65. She wants to be able to...

Question 1 (30 marks) Imagine a $100 face value bond with 4 years to maturity that: Pays annual coupons at a rate of 8% per annum; and, Has a yield to maturity of 8% per annum. Required Will the bond...

Show Your Work Problem 1: A $1,000 par value bond has 3 years until maturity, 8 percent annual coupon rate, and coupon payments are made semi-annually. The annual yield to maturity is 9.5 percent. a....

annual payments, she has decided to make one lump-sum payment on her 35th birthday to cover her retirement needs. What amount does she have to deposit? Q-2. (Bond Valuation) The YTM on a bond is the...

According to the intrinsic value of the bond from Q1, is the bond selling at a premium, at a discount, or at par? Premium Discount At par Suppose that the MU corporation has a $1000 par value bond...

An August 12, 2011, article in Time, As Regular Malls Struggle, Outlet Malls Are Booming, analyzed trends in how consumers shop, and found that more and more consumers are visiting outlet malls as a...

If your college hires the next 4 employees without regard to gender, and the pool of applicants is large with an equal number of men and women, then the probability distribution for the number x of...

QuickBooks Online automatically saves the work completed. Select one: True False

A company declared a $0.5 per share cash dividend. The company has 200,000 shares authorized, 190,000 shares issued and outstanding. The journal entry to record the payment of the dividends is:...