All answers must be entered/submitted as a formula.

You've observed the following returns on Crash-n-Burn Computer's stock over the pas 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? Complete the following analysis. Do not hard code values in your calculations. Make sure to use the "sample" Excel formulas in your calculations