es Suppose the returns on long-term corporate bonds and T-bills are normally distributed. Assume for a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
es Suppose the returns on long-term corporate bonds and T-bills are normally distributed. Assume for a certain time period, long-term corporate bonds had an average return of 5.8 percent and a standard deviation of 8.9 percent. For the same period, T-bills had an average return of 4.3 percent and a standard deviation of 3.1 percent. Use the NORMDIST function in Excel to answer the following questions: a. What is the probability that in any given year, the return on long-term corporate bonds will be greater than 10 percent? Less than O percent? Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16. 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? Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16. c. In one year, the return on long-term corporate bonds was -4.7 percent. How likely is it that such a low return will recur at some point in the future? T-bills had a return of 10.62 percent in this same year. How likely is it that such a high return on T-bills will recur at some point in the future? Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16. a. Probability of return greater than 10 percent Probability of return less than 0 percent b. Probability of return greater than 10 percent Probability of return less than 0 percent % % % % c. Probability of return less than -4.7 percent % Probability of return greater than 10.62 percent + % es Suppose the returns on long-term corporate bonds and T-bills are normally distributed. Assume for a certain time period, long-term corporate bonds had an average return of 5.8 percent and a standard deviation of 8.9 percent. For the same period, T-bills had an average return of 4.3 percent and a standard deviation of 3.1 percent. Use the NORMDIST function in Excel to answer the following questions: a. What is the probability that in any given year, the return on long-term corporate bonds will be greater than 10 percent? Less than O percent? Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16. 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? Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16. c. In one year, the return on long-term corporate bonds was -4.7 percent. How likely is it that such a low return will recur at some point in the future? T-bills had a return of 10.62 percent in this same year. How likely is it that such a high return on T-bills will recur at some point in the future? Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16. a. Probability of return greater than 10 percent Probability of return less than 0 percent b. Probability of return greater than 10 percent Probability of return less than 0 percent % % % % c. Probability of return less than -4.7 percent % Probability of return greater than 10.62 percent + %
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
In Exercises 7582, express the given function h as a composition of two functions f and g so that h(x) = (f g)(x). h(x) = x-9
-
The following data are derived from the 2009 financial statements of Southwest Airlines. All dollars are in millions. Southwest has a December 31 year-end. Cash balance, January 1, 2009 .............
-
Identify three controls that may help to reduce control risk pertaining to each of the following assertions for credit sales transactions: a. Existence or occurrence. b. Completeness. c. Valuation or...
-
Discuss the role of accounts and show how debits and credits are used in the double-entry accounting system using T-accounts. - An account is a record of increases and decreases in each of the basic...
-
Comprehensive Fixed-Asset Problem Darby Sporting Goods Inc. has been experiencing growth in the demand for its products over the last several years. The last two Olympic Games greatly increased the...
-
E 3 - 1 5 Below are he restated amounts of net income and retained earnings for Raiders Inc for the period 2 0 1 2 - 2 0 2 1 . Raiders began operations in 2 0 2 0 . Calculate the balance of retained...
-
You spin the spinner once 6 5 3 4 What is P prime Write your answer as a percentage
-
How do advanced geospatial analysis techniques, such as remote sensing data fusion and machine learning algorithms, contribute to the site selection process for land development projects,...
-
The Sindh Engineering Company produces a bicycle which sells at Rs.1,000 per unit. At 80% capacity utilization which is the normal level of activity, the sales are Rs.180 million. Costs are as under:...
-
Describe the dividend policy of Berkshire Hathaway has adopted. Consider the historical dividend payments and the company's public statements regarding dividend distribution. (can you write a...
-
A non-investment grade company wants to borrow money. It is considering two options: (i) issuing a 144a high-yield bond, or (ii) issuing a leveraged loan. The company is certain that interest rates...
-
Davis Industries must choose between a gas or electric forklift to move materials around the plant. You cannot buy both as they perform the same function. (They are a mutually exclusive investment.)...
-
(7 points) Vert uses a periodic system. It discovered the following inventory errors in 2023. Books are open. 2022: Ending inventory was $1,100 too high. 2023: $1,600 ending inventory too low. 2023:...
-
In muscle tissue, the ratio of phosphorylase a to phosphorylase b determines the rate of conversion of glycogen to glucose 1phosphate. Classify how each event affects the rate of glycogen breakdown...
-
What is gross profit or gross margin on sales? How is the gross profit ratio computed? In your explanation, assume that net sales revenue is $100,000 and cost of sales is $60,000.
-
Which basic accounting concept is satisfied by using the allowance method of accounting for bad debts?
-
What is the effect of the write-off of bad debts (using the allowance method) on (a) net earnings and (b) net accounts receivable?
Study smarter with the SolutionInn App