Question

1 images 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. (LG 3-2)

images. 2 Calculate the yield to maturity on the following bonds: (LG 3-2)

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.

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.

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. 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. (LG 3-3)

If the required rate of return on the stock is 12 percent, what is its fair present value?

If the required rate of return on the stock is 15 percent, what should the fair value be four years from today? 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 with 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. (LG 3-4)

If interest rates rise by 1 percent (100 basis points), how do the values of the assets and liabilities of each bank change?

What accounts for the differences between the two banks’ accounts? 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? (LG 3-7). 6 Bank Three currently has $600 million in transaction deposits on its balance sheet. The Federal Reserve has currently set the reserve requirement at 10 percent of transaction deposits. (LG 4-3)

If the Federal Reserve decreases the reserve requirement to 8 percent, show the balance sheet of Bank Three and the Federal Reserve System just before and after the full effect of the reserve requirement change. Assume Bank Three withdraws all excess reserves and gives out loans and that borrowers eventually return all of these funds to Bank Three in the form of transaction deposits.

Redo part (a) using a 12 percent reserve requirement. 7 National Bank currently has $500 million in transaction deposits on its balance sheet. The current reserve requirement is 10 percent, but the Federal Reserve is decreasing this requirement to 8 percent. (LG 4-3)

Show the balance sheet of the Federal Reserve and National Bank if National Bank converts all excess reserves to loans, but borrowers return only 50 percent of these funds to National Bank as transaction deposits.

Show the balance sheet of the Federal Reserve and National Bank if National Bank converts 75 percent of its excess reserves to loans and borrowers return 60 percent of these funds to National Bank as transaction deposits.

Answer 1

You have asked multiple unrelated questions in the same post. I have addressed the first one. Please post the balance questions separately one by one.

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.

Yield to maturity can be calculated using the RATE function in excel. Here, the coupons are paid semi annually, hence the period here is half year. The inputs of RATE function and the output are shown below:

Please see the snapshot from my worksheet below. Please be guided by the second column titled “Linkage” to understand the mathematics. The last row highlighted in yellow is your answer. Figures in parenthesis, if any, mean negative values. All financials are in $. Adjacent cells in blue contain the formula in excel I have used to get the final output.