PLEASE ANSWER IN EXCEL FORM WITH EXACT CELL FORMULAS USED TO SOLVE EACH OF THE YELLOW BOXES.

Suppose the returns on long-term corporate bonds and T-bills are normally distributed. Based on the values below 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? 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 long-term corporate bonds was -2.76 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.56 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? 6.30% 8.40% Long-term corporate bonds Average return Standard deviation T-bills Average return Standard deviation a. Return greater than Return less than b. Return greater than Return less than 3.50% 3.10% 10.00% 0.00% 10.00% 0.00% Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel functions to answer this question. a. Probability of return greater than 10% Probability of return less than 0% b. Probability of return greater than 10% Probability of return less than 0% c. Probability of return less than -2.76% Probability of return greater than 10.56% ... Sheet1 ... + READY @ D -- + 100% Attempt(s) 3/3 Hint Step: The probability a return is greater than a specific value is one minus the probability the return is less than that value. Use the NORM.DIST formula in your calculations. Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel functions to answer this question. 21 22 a. Probability of return greater than 10% Probability of return less than 0% 23 24 25 b. Probability of return greater than 10% Probability of return less than 0% 26 27 28 c. Probability of return less than -2.76% Probability of return greater than 10.56% 29 30 31 32 ... Sheet1 ... + READY 0 -- Attempt(s) 3/3 Step: Use the NORM.DIST formula to calculate the probability a return is less than a specific value. + 100% Hint