Reference no: EM13838923
Assignment:
This assignment consists of two parts. The first part consists of four problems to be solved using Excel. You should submit your answers in an excel file with each question clearly labeled, all inputs listed (for example, r=.03), and your answer clearly labeled. Each question in Part One is worth five points. Part two is a writing assignment.
PART ONE:
Question 1: Company X offers a 10 year bond that has a coupon rate of 5 percent and semiannual payments. The face value is $1,000 and the YTM is 12.6%. What is the current value of this bond?
Question 2: A 20 year zero coupon bond has a face value of $1,000, a required rate of return of 5%, and semi-annual compounding. What is this bond worth today?
Question 3: A 15 year bond was issued on 1/1/2012 at its face value of $1,000. It has a coupon rate of 8% and semiannual payments (made on 6/30 and 12/31 each year). The market rate as of 7/1/2015 was 6%. What is this bond worth on 7/1/2015?
Question 4: Company X has 7.5 percent coupon bonds that pay interest semiannually. The face value of each bond is $1,000 and the current market price is $1,012.20. If the yield to maturity is 7.6 percent, how many years is it until these bonds mature? Round your answer to the nearest 10th of a year (for example, 3.2 years).
PART TWO:
Write a memo to your supervisor in which you explain five factors that affect the yield on a corporate bond. For each factor, explain how it affects the price of bonds with varying maturities. You should assume that your supervisor has some knowledge of finance but little knowledge of bonds.
|
Explain what is provenance
: What is provenance. How does provenance affect the value of art. How does this documentary affect the way you view fine art
|
|
How leaders use multiculturalism to build a company culture
: How can leaders in an organization use multiculturalism to build a company culture, which promotes inclusiveness
|
|
Discuss how the graphics are misused
: Find an example of a document that misuses graphics. This can be a document that you have received (please blot out any sensitive information and names) or a document that you find on the Internet.
|
|
The context of contemporary social problems
: What do you think the future of America looks like (focus more in the context of contemporary social problems we have, and be specific to the context of what you have stated in above no. 1) ? Why?
|
|
Determining the current value of bond
: Question 1: Company X offers a 10 year bond that has a coupon rate of 5 percent and semiannual payments. The face value is $1,000 and the YTM is 12.6%. What is the current value of this bond?
|
|
Write an annotated bibliography about health workforce issue
: Write an annotated bibliography about Health workforce issue. For example, rural general practitioner training, expanded scope of practice for paramedics in rural locations, working hours for junior doctors, nurse practitioners in emergency departm..
|
|
Recommendation on the action that the company needs
: Prepare a recommendation on the action that the company needs to take against the offender - Prepare a recommendation on the action that the company needs to take against the offender.
|
|
Analyzing the role of the foreign exchange market
: Write a 350-500 word paper analyzing the role of the foreign exchange market in facilitating the global trading positions of the Japan Foreign exchange market Discuss the relative strength or weakness of the importing country's currency relative t..
|
|
Reflection on the significance of race and ethnicity
: Reflection on the significance of ‘race' and ethnicity in these interactions. How can these concepts be defined? Do you think the interactions and relations you observed are influenced by ‘race' and ethnicity in any way? If yes, in what way?
|