(Use cells A6 to B7 from the given information to complete this question. You must use the built-in Excel function to answer this question.) (Use cells A6 to B11 from the given information to complete this question. You must use the built-in Excel function to answers this question. Make sure to use the "sample" Excel formulas.) Suppose the historical returns for government bonds, corporate bonds, and 2 inflation are as shown below. What is the historical real return on long-term government bonds? On long-term corporate bonds? 3 4 Input area: 5 9 10 (Use cells A6 to B8 from the given information to complete this question.) Suppose a stock had an initial price of $74 per share, paid a dividend of 2 \$1.65 per share during the year, and had an ending share price of $83. Compute the percentage total return. 4 Input area: 5 9 10 (Use cells A6 to B8 from the given information to complete this question.) Suppose a stock had an initial price of $74 per share, paid a dividend of $1.65 per share during the year, and had an ending share price of $83. Compute the total percentage return. What was the dividend yield? The capital gains yield? 3 4 inputarea: 5 9 10 (Use cells A6 to B8 from the given information to complete this question.) distributed. Based on the historical record, use the 2 NORMDIST function in Excel to determine the probability that in any given year you will lose money by investing in common stock. 3 4 input area: s. 10 (Use cells A6 to B8 from the given information to complete this question. You must use the 11 built-in Excel function to answer this question.) (Use cells A6 to B13 from the given information to complete this question. You must use the built-in Excel function to answer this question. Make sure to use the "sample" Excel formula.) (Use cells A6 to C11 from the given information to complete this question. You must use the built -in Excel function to answers this question. Make sure to use the "sample" Excel formulas.)