# Question

Suppose the returns on bonds and T-bills are normally distributed. Based on the historical record, use the NORMDIST function in Microsoft Excel to answer the following questions:

a. What is the probability that in any given year, the return on bonds will be greater than 10 percent? Less than 0 percent?

b. What is the probability that in any given year, the return on T-bills will be greater than 10 percent? Less than 0 percent?

c. In 1979, the return on bonds was -4.18 percent. How likely is it that a return this low will recur at some point in the future? T-bills had a return of 10.56 percent in this same year. How likely is it that a return on T-bills this high will recur at some point in the future?

a. What is the probability that in any given year, the return on bonds will be greater than 10 percent? Less than 0 percent?

b. What is the probability that in any given year, the return on T-bills will be greater than 10 percent? Less than 0 percent?

c. In 1979, the return on bonds was -4.18 percent. How likely is it that a return this low will recur at some point in the future? T-bills had a return of 10.56 percent in this same year. How likely is it that a return on T-bills this high will recur at some point in the future?

## Answer to relevant Questions

Suppose you bought a 6 percent coupon bond one year ago for $1,040. The bond sells for $1,063 today. a. Assuming a $1,000 face value, what was your total dollar return on this investment over the past year? b. What was your ...Consider the following information: a. Your portfolio is invested 30 percent each in A and C and 40 percent in B. What is the expected return of the portfolio? b. What is the variance of this portfolio? The standard ...Security F has an expected return of 10 percent and a standard deviation of 26 percent per year. Security G has an expected return of 17 percent and a standard deviation of 58 percent per year. a. What is the expected ...Kose Inc. has a target debt-to-equity ratio of 0.65. Its WACC is 11.2 percent, and the tax rate is 35 percent. a. If Kose’s cost of equity is 15 percent, what is its pre-tax cost of debt? b. If instead you know that the ...Fama’s Llamas has a WACC of 9.8 percent. The company’s cost of equity is 13 percent, and its cost of debt is 6.5 percent. The tax rate is 35 percent. What is Fama’s debt-to- equity ratio?Post your question

0