Question: heck my work mode: This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. Suppose


heck my work mode: This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. Suppose the returns on long-term corporate bonds and T-bills are normally distributed. Refer to Figure 12.10. 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 0 percent? (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? (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) c-1. In 1980, the return on long-term government bonds was -3.95 percent. How likely is it that such a low return will recur at some point in the future? (Do not round intermediate calculations and enter your answer as percent rounded to 2 decimal places, e.g., 32.16.) c-2. T-bills had a return of 11.24 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? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Answer is complete but not entirely correct. "The 1933 smoll-compony stocks totol return wos 142.9 percent
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
