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:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/664951efd6fae_135664951efd0749.jpg)
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
-
Why does the cost to load in an unconstrained system is lower compared to contrained with N - 1 Contingency in PLEXOS Modelling? What are the factors that affect the increase in cost to load during...
-
For the particle in Problem 2, find the magnetic field at (a) x = 1 m, y = 3 m (b) x = 2 m, y = 2 m and (c) x = 2 m, y = 3 m.
-
Louisa Santiago purchases 50% of Leo Lemon's capital (SO interest in the K & L partnership for \($22,000.\) If the capital balance of Kate Kildare and Leo Lemon are \($40,000\) and \($30,000,\)...
-
Given that the approximate frequency of \(\mathrm{F}_{4}=349 \mathrm{~Hz}\), what is the approximate frequency of \(\mathrm{F}_{5}\), rounded to the nearest whole number?
-
After researching the competitors of EJH Enterprises, you determine that most comparable firms have the following valuation ratios (see MyFinanceLab for the data in Excel format): EJH Enterprises has...
-
Beginning Balances January 3 1 , 2 0 1 9 Debit Credit Cash 1 0 0 0 0 Accounts Receivable 7 0 0 0 Allowance for doubtful accounts 6 0 Office Supplies 3 0 0 Inventory 1 0 0 0 Prepaid Insurance 2 0 0 0...
-
Many insurance companies provide suggestions for what to do in an accident. For example, GEICO provides the following recommendations links to an external site. Choose all of the actions recommended:...
-
Identify whether the following statements are true or false. a. GAAP can differ from one country to another. b. U.S. GAAP is established by the FASB. c. U.S. GAAP is a guide to action that may change...
-
When computer systems are used, how does the auditor evaluate the system of authorizations used by an organization?
-
Determine whether the following statements are true or false and explain why: a. The accounting process is only interested in communicating economic activity. b. There are few potential users of...
-
Why is the need for competent and trustworthy personnel even more important when an organization uses computers for its data processing?
-
With the increasing use of computers for data processing, is the audit trail disappearing? Explain.
-
Please calculate the median of these scores. 25, 9, 24, 22, 12, 15, 15, 19, 16, 18
-
A. Select a recent issue (paper or online) of Report on Business Magazine, Canadian Business Magazine (online only), Bloomberg Businessweek, Fast Company, The Economist, or another business magazine....
-
differentiate among the ethical models,
-
How do ethics and organizational mission and vision interrelate?
-
Prepare budgeted income statement (Learning Objective 2)} The budget committee of Vinning Office Supply has assembled the following data. As the business manager, you must prepare the budgeted income...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App