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

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 a AwN 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. 18 19 Arithmetic average nominal return 12.80% 20 21 Average real return 8.99% 22 23 Average risk premium 24 25 26 27 ... Sheet1 ... + Sheet1 READY Attempt(s) 3/3 Step: The risk premium is the return minus the risk-free rate. ' @ D