All answers must be entered as a formula. Click OK to begin. OK You've observed the following returns on Crash-n-Burn Computer's stock over the past five years. The average inflation rate over this period was 3.5 percent and the average T-bill rate was 4.2 percent. What was the average real return on the stock? What was the average nominal risk premium on the stock? Year Returns 7% -13% 21% 34% 15% Average inflation rate Average T-bill rate 3.5% 4.2% Complete the following analysis. Do not hard code values in your calculations. Make sure to use the "sample" Excel formulas in your calculations Arithmetic average nominal return 12.80% Average real return Average risk premium X All answers must be entered as a formula. Click OK to begin. OK Suppose you have an asset with the following return distribution. Use the NORM.DIST function to calculate the probability you will lose money in any particular year. Average return Standard deviation Return less than 12.10% 20.20% 0.00% Complete the following analysis. Do not harg code values in your calculations. You must use the built-in Excel functions to answer this question. Probability less than 0% All answers must be entered as a formula. Click OK to begin. OK You've observed the following returns on Crash-n-Burn Computer's stock over the past five years. The average inflation rate over this period was 3.5 percent and the average T-bill rate was 4.2 percent. What was the average real return on the stock? What was the average nominal risk premium on the stock? Year Returns 7% -13% 21% 34% 15% Average inflation rate Average T-bill rate 3.5% 4.2% Complete the following analysis. Do not hard code values in your calculations. Make sure to use the "sample" Excel formulas in your calculations Arithmetic average nominal return 12.80% Average real return Average risk premium X All answers must be entered as a formula. Click OK to begin. OK Suppose you have an asset with the following return distribution. Use the NORM.DIST function to calculate the probability you will lose money in any particular year. Average return Standard deviation Return less than 12.10% 20.20% 0.00% Complete the following analysis. Do not harg code values in your calculations. You must use the built-in Excel functions to answer this question. Probability less than 0%