Reference no: EM131332184
Your wealthy uncle has invested some of his money on a government bond. The annual coupon rate of the bond is 6%. The face value is $1000. Interest is paid each May and November, implying that coupon is made twice a year. The face value will be paid out in 4 years. The market interest rate is 10% and your uncle is not sure how much he should pay to buy the bond.
a) He asks you to prepare a spreadsheet that shows the value of the bond, cash flows from the bond each period, yield to maturity of the bond, and the price of the bond in each period, so if he decides to sell the bond in a few years he could sell it at the right price. He also wants your model to be complete enough to answer his questions if he buys other bonds in future with different maturity, coupon payments, etc.(You need to use IF function to make your model flexible )
b) Find out the bond duration
c) Perform a sensitivity analysis of bond duration to both coupon rate (with the value of 0%,2%,4%,6%,8%, 10%) and Maturity (with the value of 4,5,6,7,8,9, and 10 years)
Input section:
Par value: 1000
Coupon rate: 0.06
Years remaining: 4
Number of times: 2
YTM: 0.1
Original number : 20
Requested to buy/sell bonds: Buy
Requested number of bonds in the transaction: 5 shares
Requested transaction period: Year 2
Offered bond price: 850
Prepare a report that includes your habits over a day
: Prepare a report that includes your original data presented in an Excel chart or Word table (or some other readable format). This report should also include your narrative explaining the data you found, its meaning, and the overall interpretation...
|
Extension of the firm current operations
: Panelli's is analyzing a project with an initial cost of $110,000 and cash inflows of $65,000 in year 1 and $74,000 in year 2. This project is an extension of the firm's current operations and thus is equally as risky as the current firm. The firm us..
|
Weighted average cost of capital
: The dividend yield is 7%. The company also has $5,000,000 of bonds(also sold at par) with a coupon rate of 5%. The tax rate for Alpha is 30%. What is its weighted average cost of capital (WACC)?
|
What role does the concept of the hidden curriculum play
: What role does the concept of the hidden curriculum play in American's education system? Is education "the great equalizer?" Why or why not
|
Find out the bond duration
: Your wealthy uncle has invested some of his money on a government bond. The annual coupon rate of the bond is 6%. The face value is $1000. Interest is paid each May and November, implying that coupon is made twice a year. Find out the bond duration
|
Write a draft paper about the drug vyvanse
: Discuss about the drug Vyvanse.History and epidemiology of the drug,The pharmacology, how does it work in the system,How is it grown, manufactured, transported and marketed.
|
What does the IRR rule advise regarding payment arrangement
: Professor Wendy Smith has been offered the following? opportunity: A law firm would like to retain her for an upfront payment of $49,000. In return, for the next year the firm would have access to eight hours of her time every month. Smith's rate is ..
|
Both perpetuities have the same present value
: One perpetuity-imediate with annual payments of $50 has a present value of $300. A second perpetuity has first payment equal to $35, increasing by 3% each year for the next 5 years; the payments are $X thereafter. Both perpetuities have the same pres..
|
What is the expected return of stock
: The stock of company A has a beta of 1.5. The return of market portfolio is 9% and the risk-free rate is1%. 1) According to the Capital Asset Pricing Model (CAPM), what is the expected return of this stock?
|