Reference no: EM131222118
Answer the following question:
The Calculations must be done on Excel with actual calculations in the cells.
Question 1:
Using a Spreadsheet to Calculate Yield to Maturity. What is the yield to maturity on the following bonds; all have a maturity of 10 years, a face value of $1,000, and a coupon rate of 9 percent (paid semiannually). The bonds' current market values are $945.50, $987.50, $1,090.00, and $1,225.875, respectively
| Market value |
Total Payments |
Periodic coupon Payment
|
Face Value |
The yield to maturity will be
|
| 945.50 |
10 x 2 =20
|
1,000(.09)/2=45
|
$1,000 |
9.87% |
| 987.50 |
20 |
45 |
1,000 |
9.19 |
|
1,090.00
|
20
|
45
|
1,000
|
7.69
|
| 1,225.875 |
20 |
45 |
1,000 |
5.97 |
Question 2:
Calculate the yield to maturity on the following bonds.
a. A 9 percent coupon (paid semiannually) bond, with a $1,000 face value and 15 years remaining to maturity. The bond is selling at $985.
b. An 8 percent coupon (paid quarterly) bond, with a $1,000 face value and 10 years remaining to maturity. The bond is selling at $915.
c. An 11 percent coupon (paid annually) bond, with a $1,000 face value and 6 years remaining to maturity. The bond is selling at $1,065.
Question 3:
A stock you are evaluating just paid an annual dividend of $2.50. Dividends have grown at a constant rate of 1.5 percent over the last 15 years and you expect this to continue.
a. If the required rate of return on the stock is 12 percent, what is its fair present value?
b. If the required rate of return on the stock is 15 percent, what is its expected price four years from today?
Question 4:
Consider the following two banks:
Bank 1 has assets composed solely of a 10-year, 12 percent coupon, $1 million loan with a 12 percent yield to maturity. It is financed with a 10-year, 10 percent coupon, $1 million CD with a 10 percent yield to maturity.
Bank 2 has assets composed solely of a 7-year, 12 percent, zero-coupon bond with a current value of $894,006.20 and a maturity value of $1,976,362.88. It is financed by a 10-year, 8.275 percent coupon, $1,000,000 face value CD with a yield to maturity of 10 percent.
All securities except the zero-coupon bond pay interest annually.
a. If interest rates rise by 1 percent (100 basis points), how do the values of the assets and liabilities of each bank change?
b. What accounts for the differences between the two banks' accounts?
Question 5:
What is the duration of a five-year, $1,000 Treasury bond with a 10 percent semiannual coupon selling at par? Selling with a yield to maturity of 12 percent? 14 percent? What can you conclude about the relationship between duration and yield to maturity? Plot the relationship. Why does this relationship exist?
|
Are the two schedules equivalent in terms of present values
: Are the two schedules equivalent in terms of present values? Why or why not? - Why is the total sum of interest payments higher for the equal installment schedule?
|
|
The installment method of accounting generally equals cash
: Income recognized using the installment method of accounting generally equals cash collected multiplied by the. A company uses the completed-contract method to account for a long-term construction contract. Revenue is recognized when recorded progres..
|
|
What is the just wage doctrine
: Internal structures are part of the incentives offered in the organizations.Look into any organization you are familiar with. Describe the flow of work. How is the job structure aligned with the organization's business, the work flow, and the orga..
|
|
Compute the current weighted average cost of capital
: QM Industries is a large publicly listed company is the market leader in robotic technology. The company is looking to set up a manufacturing plant overseas to produce a new line of domestic robots. This will be a six year project. Calculate the proj..
|
|
What is the yield to maturity on the given bonds
: What is the yield to maturity on the following bonds; all have a maturity of 10 years, a face value of $1,000, and a coupon rate of 9 percent.
|
|
Organizing drive for zinnia and acme scenarios
: Also, in the second part of your essay critique the current organizing drive and develop your own union organizing drive for both the Zinnia and ACME scenarios. Be sure to include specific tactics and issues you would address.
|
|
Develop software project management plan for organization
: Determine at least three (3) risks that may occur if the requirements engineering process is not properly followed. Speculate on how failing to perform these processes may lead to project failure. Include examples to support your answer.
|
|
Account for inventory cost flow for the financial records
: A company that is publicly-traded can use LIFO to account for inventory cost flow for the financial records it prepares for tax purposes and FIFO to account for its inventory cost flow in the financial statements its presents to its investors.
|
|
Noncontrolling interest reflected in consolidated balance
: Company A buys Company B and pays $5 million more than the fair value of the identifiable assets and liabilities. The $5 million was recorded as Goodwill. Big Company buys 80 percent of the outstanding shares of Little Company on January 1, Year One...
|